DBA Data[Home] [Help]

APPS.IGS_AD_EMP_DTL_PKG dependencies on FND_API

Line 152: P_INIT_MSG_LIST => FND_API.G_TRUE,

148: L_EMP_HISTORY_REC.REASON_FOR_LEAVING := x_reason_for_leaving;
149:
150: --HZ_API is changed from HZ_PER_INFO_PUB to HZ_PERSON_INFO_V2PUB
151: HZ_PERSON_INFO_V2PUB.create_employment_history(
152: P_INIT_MSG_LIST => FND_API.G_TRUE,
153: P_EMPLOYMENT_HISTORY_REC => l_EMP_HISTORY_REC,
154: X_EMPLOYMENT_HISTORY_ID => x_employment_history_id,
155: X_RETURN_STATUS => x_return_status,
156: X_MSG_COUNT => l_msg_count,

Line 165: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

161:
162: IF x_RETURN_STATUS IN ('E','U') THEN
163: IF l_msg_count > 1 THEN
164: FOR i IN 1..l_msg_count LOOP
165: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
166: tmp_var1 := tmp_var1 || ' '|| tmp_var;
167: END LOOP;
168: x_msg_data := tmp_var1;
169: END IF;

Line 307: L_EMP_HISTORY_REC.EMPLOYED_AS_TITLE := NVL(x_position,FND_API.G_MISS_CHAR);

303:
304: --Branch,Military_rank,serverd and station fields are obsoleted.
305: L_EMP_HISTORY_REC.EMPLOYMENT_HISTORY_ID := x_employment_history_id;
306: L_EMP_HISTORY_REC.BEGIN_DATE := x_start_dt;
307: L_EMP_HISTORY_REC.EMPLOYED_AS_TITLE := NVL(x_position,FND_API.G_MISS_CHAR);
308: L_EMP_HISTORY_REC.EMPLOYED_BY_DIVISION_NAME := NVL(x_employed_by_division_name,FND_API.G_MISS_CHAR);
309: L_EMP_HISTORY_REC.EMPLOYED_BY_NAME_COMPANY := NVL(x_employer,FND_API.G_MISS_CHAR);
310: L_EMP_HISTORY_REC.END_DATE := NVL(x_end_dt,FND_API.G_MISS_DATE);
311: L_EMP_HISTORY_REC.SUPERVISOR_NAME := NVL(x_contact,FND_API.G_MISS_CHAR); --Bug :2037512

Line 308: L_EMP_HISTORY_REC.EMPLOYED_BY_DIVISION_NAME := NVL(x_employed_by_division_name,FND_API.G_MISS_CHAR);

304: --Branch,Military_rank,serverd and station fields are obsoleted.
305: L_EMP_HISTORY_REC.EMPLOYMENT_HISTORY_ID := x_employment_history_id;
306: L_EMP_HISTORY_REC.BEGIN_DATE := x_start_dt;
307: L_EMP_HISTORY_REC.EMPLOYED_AS_TITLE := NVL(x_position,FND_API.G_MISS_CHAR);
308: L_EMP_HISTORY_REC.EMPLOYED_BY_DIVISION_NAME := NVL(x_employed_by_division_name,FND_API.G_MISS_CHAR);
309: L_EMP_HISTORY_REC.EMPLOYED_BY_NAME_COMPANY := NVL(x_employer,FND_API.G_MISS_CHAR);
310: L_EMP_HISTORY_REC.END_DATE := NVL(x_end_dt,FND_API.G_MISS_DATE);
311: L_EMP_HISTORY_REC.SUPERVISOR_NAME := NVL(x_contact,FND_API.G_MISS_CHAR); --Bug :2037512
312: L_EMP_HISTORY_REC.PARTY_ID := x_person_id;

Line 309: L_EMP_HISTORY_REC.EMPLOYED_BY_NAME_COMPANY := NVL(x_employer,FND_API.G_MISS_CHAR);

305: L_EMP_HISTORY_REC.EMPLOYMENT_HISTORY_ID := x_employment_history_id;
306: L_EMP_HISTORY_REC.BEGIN_DATE := x_start_dt;
307: L_EMP_HISTORY_REC.EMPLOYED_AS_TITLE := NVL(x_position,FND_API.G_MISS_CHAR);
308: L_EMP_HISTORY_REC.EMPLOYED_BY_DIVISION_NAME := NVL(x_employed_by_division_name,FND_API.G_MISS_CHAR);
309: L_EMP_HISTORY_REC.EMPLOYED_BY_NAME_COMPANY := NVL(x_employer,FND_API.G_MISS_CHAR);
310: L_EMP_HISTORY_REC.END_DATE := NVL(x_end_dt,FND_API.G_MISS_DATE);
311: L_EMP_HISTORY_REC.SUPERVISOR_NAME := NVL(x_contact,FND_API.G_MISS_CHAR); --Bug :2037512
312: L_EMP_HISTORY_REC.PARTY_ID := x_person_id;
313: L_EMP_HISTORY_REC.EMPLOYMENT_TYPE_CODE := NVL(x_type_of_employment,FND_API.G_MISS_CHAR);

Line 310: L_EMP_HISTORY_REC.END_DATE := NVL(x_end_dt,FND_API.G_MISS_DATE);

306: L_EMP_HISTORY_REC.BEGIN_DATE := x_start_dt;
307: L_EMP_HISTORY_REC.EMPLOYED_AS_TITLE := NVL(x_position,FND_API.G_MISS_CHAR);
308: L_EMP_HISTORY_REC.EMPLOYED_BY_DIVISION_NAME := NVL(x_employed_by_division_name,FND_API.G_MISS_CHAR);
309: L_EMP_HISTORY_REC.EMPLOYED_BY_NAME_COMPANY := NVL(x_employer,FND_API.G_MISS_CHAR);
310: L_EMP_HISTORY_REC.END_DATE := NVL(x_end_dt,FND_API.G_MISS_DATE);
311: L_EMP_HISTORY_REC.SUPERVISOR_NAME := NVL(x_contact,FND_API.G_MISS_CHAR); --Bug :2037512
312: L_EMP_HISTORY_REC.PARTY_ID := x_person_id;
313: L_EMP_HISTORY_REC.EMPLOYMENT_TYPE_CODE := NVL(x_type_of_employment,FND_API.G_MISS_CHAR);
314: L_EMP_HISTORY_REC.FRACTION_OF_TENURE := NVL(x_fraction_of_employment,FND_API.G_MISS_NUM);

Line 311: L_EMP_HISTORY_REC.SUPERVISOR_NAME := NVL(x_contact,FND_API.G_MISS_CHAR); --Bug :2037512

307: L_EMP_HISTORY_REC.EMPLOYED_AS_TITLE := NVL(x_position,FND_API.G_MISS_CHAR);
308: L_EMP_HISTORY_REC.EMPLOYED_BY_DIVISION_NAME := NVL(x_employed_by_division_name,FND_API.G_MISS_CHAR);
309: L_EMP_HISTORY_REC.EMPLOYED_BY_NAME_COMPANY := NVL(x_employer,FND_API.G_MISS_CHAR);
310: L_EMP_HISTORY_REC.END_DATE := NVL(x_end_dt,FND_API.G_MISS_DATE);
311: L_EMP_HISTORY_REC.SUPERVISOR_NAME := NVL(x_contact,FND_API.G_MISS_CHAR); --Bug :2037512
312: L_EMP_HISTORY_REC.PARTY_ID := x_person_id;
313: L_EMP_HISTORY_REC.EMPLOYMENT_TYPE_CODE := NVL(x_type_of_employment,FND_API.G_MISS_CHAR);
314: L_EMP_HISTORY_REC.FRACTION_OF_TENURE := NVL(x_fraction_of_employment,FND_API.G_MISS_NUM);
315: L_EMP_HISTORY_REC.TENURE_CODE := NVL(x_tenure_of_employment,FND_API.G_MISS_CHAR);

Line 313: L_EMP_HISTORY_REC.EMPLOYMENT_TYPE_CODE := NVL(x_type_of_employment,FND_API.G_MISS_CHAR);

309: L_EMP_HISTORY_REC.EMPLOYED_BY_NAME_COMPANY := NVL(x_employer,FND_API.G_MISS_CHAR);
310: L_EMP_HISTORY_REC.END_DATE := NVL(x_end_dt,FND_API.G_MISS_DATE);
311: L_EMP_HISTORY_REC.SUPERVISOR_NAME := NVL(x_contact,FND_API.G_MISS_CHAR); --Bug :2037512
312: L_EMP_HISTORY_REC.PARTY_ID := x_person_id;
313: L_EMP_HISTORY_REC.EMPLOYMENT_TYPE_CODE := NVL(x_type_of_employment,FND_API.G_MISS_CHAR);
314: L_EMP_HISTORY_REC.FRACTION_OF_TENURE := NVL(x_fraction_of_employment,FND_API.G_MISS_NUM);
315: L_EMP_HISTORY_REC.TENURE_CODE := NVL(x_tenure_of_employment,FND_API.G_MISS_CHAR);
316: L_EMP_HISTORY_REC.WEEKLY_WORK_HOURS := NVL(x_weekly_work_hours,FND_API.G_MISS_NUM);
317: L_EMP_HISTORY_REC.COMMENTS := NVL(x_comments,FND_API.G_MISS_CHAR);

Line 314: L_EMP_HISTORY_REC.FRACTION_OF_TENURE := NVL(x_fraction_of_employment,FND_API.G_MISS_NUM);

310: L_EMP_HISTORY_REC.END_DATE := NVL(x_end_dt,FND_API.G_MISS_DATE);
311: L_EMP_HISTORY_REC.SUPERVISOR_NAME := NVL(x_contact,FND_API.G_MISS_CHAR); --Bug :2037512
312: L_EMP_HISTORY_REC.PARTY_ID := x_person_id;
313: L_EMP_HISTORY_REC.EMPLOYMENT_TYPE_CODE := NVL(x_type_of_employment,FND_API.G_MISS_CHAR);
314: L_EMP_HISTORY_REC.FRACTION_OF_TENURE := NVL(x_fraction_of_employment,FND_API.G_MISS_NUM);
315: L_EMP_HISTORY_REC.TENURE_CODE := NVL(x_tenure_of_employment,FND_API.G_MISS_CHAR);
316: L_EMP_HISTORY_REC.WEEKLY_WORK_HOURS := NVL(x_weekly_work_hours,FND_API.G_MISS_NUM);
317: L_EMP_HISTORY_REC.COMMENTS := NVL(x_comments,FND_API.G_MISS_CHAR);
318: L_EMP_HISTORY_REC.RESPONSIBILITY := NULL;

Line 315: L_EMP_HISTORY_REC.TENURE_CODE := NVL(x_tenure_of_employment,FND_API.G_MISS_CHAR);

311: L_EMP_HISTORY_REC.SUPERVISOR_NAME := NVL(x_contact,FND_API.G_MISS_CHAR); --Bug :2037512
312: L_EMP_HISTORY_REC.PARTY_ID := x_person_id;
313: L_EMP_HISTORY_REC.EMPLOYMENT_TYPE_CODE := NVL(x_type_of_employment,FND_API.G_MISS_CHAR);
314: L_EMP_HISTORY_REC.FRACTION_OF_TENURE := NVL(x_fraction_of_employment,FND_API.G_MISS_NUM);
315: L_EMP_HISTORY_REC.TENURE_CODE := NVL(x_tenure_of_employment,FND_API.G_MISS_CHAR);
316: L_EMP_HISTORY_REC.WEEKLY_WORK_HOURS := NVL(x_weekly_work_hours,FND_API.G_MISS_NUM);
317: L_EMP_HISTORY_REC.COMMENTS := NVL(x_comments,FND_API.G_MISS_CHAR);
318: L_EMP_HISTORY_REC.RESPONSIBILITY := NULL;
319: L_EMP_HISTORY_REC.EMPLOYED_BY_PARTY_ID := NVL(x_employed_by_party_id,FND_API.G_MISS_NUM);

Line 316: L_EMP_HISTORY_REC.WEEKLY_WORK_HOURS := NVL(x_weekly_work_hours,FND_API.G_MISS_NUM);

312: L_EMP_HISTORY_REC.PARTY_ID := x_person_id;
313: L_EMP_HISTORY_REC.EMPLOYMENT_TYPE_CODE := NVL(x_type_of_employment,FND_API.G_MISS_CHAR);
314: L_EMP_HISTORY_REC.FRACTION_OF_TENURE := NVL(x_fraction_of_employment,FND_API.G_MISS_NUM);
315: L_EMP_HISTORY_REC.TENURE_CODE := NVL(x_tenure_of_employment,FND_API.G_MISS_CHAR);
316: L_EMP_HISTORY_REC.WEEKLY_WORK_HOURS := NVL(x_weekly_work_hours,FND_API.G_MISS_NUM);
317: L_EMP_HISTORY_REC.COMMENTS := NVL(x_comments,FND_API.G_MISS_CHAR);
318: L_EMP_HISTORY_REC.RESPONSIBILITY := NULL;
319: L_EMP_HISTORY_REC.EMPLOYED_BY_PARTY_ID := NVL(x_employed_by_party_id,FND_API.G_MISS_NUM);
320: L_EMP_HISTORY_REC.REASON_FOR_LEAVING := NVL(x_reason_for_leaving,FND_API.G_MISS_CHAR);

Line 317: L_EMP_HISTORY_REC.COMMENTS := NVL(x_comments,FND_API.G_MISS_CHAR);

313: L_EMP_HISTORY_REC.EMPLOYMENT_TYPE_CODE := NVL(x_type_of_employment,FND_API.G_MISS_CHAR);
314: L_EMP_HISTORY_REC.FRACTION_OF_TENURE := NVL(x_fraction_of_employment,FND_API.G_MISS_NUM);
315: L_EMP_HISTORY_REC.TENURE_CODE := NVL(x_tenure_of_employment,FND_API.G_MISS_CHAR);
316: L_EMP_HISTORY_REC.WEEKLY_WORK_HOURS := NVL(x_weekly_work_hours,FND_API.G_MISS_NUM);
317: L_EMP_HISTORY_REC.COMMENTS := NVL(x_comments,FND_API.G_MISS_CHAR);
318: L_EMP_HISTORY_REC.RESPONSIBILITY := NULL;
319: L_EMP_HISTORY_REC.EMPLOYED_BY_PARTY_ID := NVL(x_employed_by_party_id,FND_API.G_MISS_NUM);
320: L_EMP_HISTORY_REC.REASON_FOR_LEAVING := NVL(x_reason_for_leaving,FND_API.G_MISS_CHAR);
321:

Line 319: L_EMP_HISTORY_REC.EMPLOYED_BY_PARTY_ID := NVL(x_employed_by_party_id,FND_API.G_MISS_NUM);

315: L_EMP_HISTORY_REC.TENURE_CODE := NVL(x_tenure_of_employment,FND_API.G_MISS_CHAR);
316: L_EMP_HISTORY_REC.WEEKLY_WORK_HOURS := NVL(x_weekly_work_hours,FND_API.G_MISS_NUM);
317: L_EMP_HISTORY_REC.COMMENTS := NVL(x_comments,FND_API.G_MISS_CHAR);
318: L_EMP_HISTORY_REC.RESPONSIBILITY := NULL;
319: L_EMP_HISTORY_REC.EMPLOYED_BY_PARTY_ID := NVL(x_employed_by_party_id,FND_API.G_MISS_NUM);
320: L_EMP_HISTORY_REC.REASON_FOR_LEAVING := NVL(x_reason_for_leaving,FND_API.G_MISS_CHAR);
321:
322: --HZ_API is changed from HZ_PER_INFO_PUB to HZ_PERSON_INFO_V2PUB
323: HZ_PERSON_INFO_V2PUB.update_employment_history(

Line 320: L_EMP_HISTORY_REC.REASON_FOR_LEAVING := NVL(x_reason_for_leaving,FND_API.G_MISS_CHAR);

316: L_EMP_HISTORY_REC.WEEKLY_WORK_HOURS := NVL(x_weekly_work_hours,FND_API.G_MISS_NUM);
317: L_EMP_HISTORY_REC.COMMENTS := NVL(x_comments,FND_API.G_MISS_CHAR);
318: L_EMP_HISTORY_REC.RESPONSIBILITY := NULL;
319: L_EMP_HISTORY_REC.EMPLOYED_BY_PARTY_ID := NVL(x_employed_by_party_id,FND_API.G_MISS_NUM);
320: L_EMP_HISTORY_REC.REASON_FOR_LEAVING := NVL(x_reason_for_leaving,FND_API.G_MISS_CHAR);
321:
322: --HZ_API is changed from HZ_PER_INFO_PUB to HZ_PERSON_INFO_V2PUB
323: HZ_PERSON_INFO_V2PUB.update_employment_history(
324: P_INIT_MSG_LIST => FND_API.G_TRUE,

Line 324: P_INIT_MSG_LIST => FND_API.G_TRUE,

320: L_EMP_HISTORY_REC.REASON_FOR_LEAVING := NVL(x_reason_for_leaving,FND_API.G_MISS_CHAR);
321:
322: --HZ_API is changed from HZ_PER_INFO_PUB to HZ_PERSON_INFO_V2PUB
323: HZ_PERSON_INFO_V2PUB.update_employment_history(
324: P_INIT_MSG_LIST => FND_API.G_TRUE,
325: P_EMPLOYMENT_HISTORY_REC => l_EMP_HISTORY_REC,
326: P_OBJECT_VERSION_NUMBER => x_object_version_number,
327: X_RETURN_STATUS => x_return_status,
328: X_MSG_COUNT => l_msg_count,

Line 361: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

357: ELSE
358: -- this means that the HZ record update gave an error
359: IF l_msg_count > 1 THEN
360: FOR i IN 1..l_msg_count LOOP
361: tmp_var := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
362: tmp_var1 := tmp_var1 || ' '|| tmp_var;
363: END LOOP;
364: x_msg_data := tmp_var1;
365: END IF;