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,
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;
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
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;
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);
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);
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);
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);
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;
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);
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);
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:
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(
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,
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,
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;