221: -- Adding Code for Enh to Create Salesperson and Roles (Job-Role Map) Automatically
222: IF (p_get_new_emp ='Y') THEN
223: IF (p_create_srp = 'Y') THEN
224: IF (p_sales_credit_type IS NULL) THEN
225: fnd_message.set_name ('JTF','JTF_RS_CP_PM_SLS_CRDT_TYP_NULL');
226: fnd_file.put_line(fnd_file.log, fnd_message.get);
227: fnd_file.new_line(fnd_file.log,1);
228: set_err_var := 'Y';
229: END IF;
222: IF (p_get_new_emp ='Y') THEN
223: IF (p_create_srp = 'Y') THEN
224: IF (p_sales_credit_type IS NULL) THEN
225: fnd_message.set_name ('JTF','JTF_RS_CP_PM_SLS_CRDT_TYP_NULL');
226: fnd_file.put_line(fnd_file.log, fnd_message.get);
227: fnd_file.new_line(fnd_file.log,1);
228: set_err_var := 'Y';
229: END IF;
230: IF (l_prof_srp_num = 'MANUALLY_ENTERED' OR l_prof_srp_num IS NULL) THEN
227: fnd_file.new_line(fnd_file.log,1);
228: set_err_var := 'Y';
229: END IF;
230: IF (l_prof_srp_num = 'MANUALLY_ENTERED' OR l_prof_srp_num IS NULL) THEN
231: fnd_message.set_name('JTF', 'JTF_RS_PROF_SRP_NUM_CONC_ERR');
232: fnd_message.set_token('P_PROFILE_VALUE', l_prof_srp_num);
233: fnd_file.put_line(fnd_file.log, fnd_message.get);
234: fnd_file.new_line(fnd_file.log,1);
235: set_err_var := 'Y';
228: set_err_var := 'Y';
229: END IF;
230: IF (l_prof_srp_num = 'MANUALLY_ENTERED' OR l_prof_srp_num IS NULL) THEN
231: fnd_message.set_name('JTF', 'JTF_RS_PROF_SRP_NUM_CONC_ERR');
232: fnd_message.set_token('P_PROFILE_VALUE', l_prof_srp_num);
233: fnd_file.put_line(fnd_file.log, fnd_message.get);
234: fnd_file.new_line(fnd_file.log,1);
235: set_err_var := 'Y';
236: END IF;
229: END IF;
230: IF (l_prof_srp_num = 'MANUALLY_ENTERED' OR l_prof_srp_num IS NULL) THEN
231: fnd_message.set_name('JTF', 'JTF_RS_PROF_SRP_NUM_CONC_ERR');
232: fnd_message.set_token('P_PROFILE_VALUE', l_prof_srp_num);
233: fnd_file.put_line(fnd_file.log, fnd_message.get);
234: fnd_file.new_line(fnd_file.log,1);
235: set_err_var := 'Y';
236: END IF;
237: END IF;
758: );
759:
760: -- dbms_output.put_line('name '||fetch_emp_rec.full_name);
761: IF ( l_return_status <> fnd_api.g_ret_sts_success) THEN
762: fnd_message.set_name('JTF', 'JTF_RS_CONC_CREATE_EMP_ERR');
763: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
764: fnd_file.put_line(fnd_file.log, fnd_message.get);
765: FOR i IN 1..l_msg_count
766: LOOP
759:
760: -- dbms_output.put_line('name '||fetch_emp_rec.full_name);
761: IF ( l_return_status <> fnd_api.g_ret_sts_success) THEN
762: fnd_message.set_name('JTF', 'JTF_RS_CONC_CREATE_EMP_ERR');
763: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
764: fnd_file.put_line(fnd_file.log, fnd_message.get);
765: FOR i IN 1..l_msg_count
766: LOOP
767: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
760: -- dbms_output.put_line('name '||fetch_emp_rec.full_name);
761: IF ( l_return_status <> fnd_api.g_ret_sts_success) THEN
762: fnd_message.set_name('JTF', 'JTF_RS_CONC_CREATE_EMP_ERR');
763: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
764: fnd_file.put_line(fnd_file.log, fnd_message.get);
765: FOR i IN 1..l_msg_count
766: LOOP
767: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
768: p_encoded => fnd_api.g_false)));
843: x_msg_data => s_msg_data,
844: x_salesrep_id => l_salesrep_id
845: );
846: IF(s_return_status <> 'S') THEN
847: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_SRP_ERR');
848: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
849: fnd_file.put_line(fnd_file.log, fnd_message.get);
850: FOR i IN 1..s_msg_count LOOP
851: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
844: x_salesrep_id => l_salesrep_id
845: );
846: IF(s_return_status <> 'S') THEN
847: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_SRP_ERR');
848: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
849: fnd_file.put_line(fnd_file.log, fnd_message.get);
850: FOR i IN 1..s_msg_count LOOP
851: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
852: p_encoded => fnd_api.g_false)));
845: );
846: IF(s_return_status <> 'S') THEN
847: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_SRP_ERR');
848: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
849: fnd_file.put_line(fnd_file.log, fnd_message.get);
850: FOR i IN 1..s_msg_count LOOP
851: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
852: p_encoded => fnd_api.g_false)));
853: END LOOP;
893: l_role_name := NULL;
894: OPEN c_role_name (i.role_id);
895: FETCH c_role_name INTO l_role_name;
896: CLOSE c_role_name;
897: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_RES_ROLE');
898: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
899: fnd_message.set_token('P_ROLE_NAME',l_role_name);
900: fnd_file.put_line(fnd_file.log, fnd_message.get);
901: FOR i IN 1..r_msg_count LOOP
894: OPEN c_role_name (i.role_id);
895: FETCH c_role_name INTO l_role_name;
896: CLOSE c_role_name;
897: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_RES_ROLE');
898: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
899: fnd_message.set_token('P_ROLE_NAME',l_role_name);
900: fnd_file.put_line(fnd_file.log, fnd_message.get);
901: FOR i IN 1..r_msg_count LOOP
902: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
895: FETCH c_role_name INTO l_role_name;
896: CLOSE c_role_name;
897: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_RES_ROLE');
898: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
899: fnd_message.set_token('P_ROLE_NAME',l_role_name);
900: fnd_file.put_line(fnd_file.log, fnd_message.get);
901: FOR i IN 1..r_msg_count LOOP
902: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
903: p_encoded => fnd_api.g_false)));
896: CLOSE c_role_name;
897: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_RES_ROLE');
898: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
899: fnd_message.set_token('P_ROLE_NAME',l_role_name);
900: fnd_file.put_line(fnd_file.log, fnd_message.get);
901: FOR i IN 1..r_msg_count LOOP
902: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
903: p_encoded => fnd_api.g_false)));
904: END LOOP;
1091:
1092: -- dbms_output.put_line('name '||fetch_emp_rec.full_name);
1093: IF ( l_return_status <> fnd_api.g_ret_sts_success) THEN
1094:
1095: fnd_message.set_name('JTF', 'JTF_RS_CONC_CREATE_EMP_ERR');
1096: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
1097: fnd_file.put_line(fnd_file.log, fnd_message.get);
1098: FOR i IN 1..l_msg_count
1099: LOOP
1092: -- dbms_output.put_line('name '||fetch_emp_rec.full_name);
1093: IF ( l_return_status <> fnd_api.g_ret_sts_success) THEN
1094:
1095: fnd_message.set_name('JTF', 'JTF_RS_CONC_CREATE_EMP_ERR');
1096: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
1097: fnd_file.put_line(fnd_file.log, fnd_message.get);
1098: FOR i IN 1..l_msg_count
1099: LOOP
1100: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
1093: IF ( l_return_status <> fnd_api.g_ret_sts_success) THEN
1094:
1095: fnd_message.set_name('JTF', 'JTF_RS_CONC_CREATE_EMP_ERR');
1096: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
1097: fnd_file.put_line(fnd_file.log, fnd_message.get);
1098: FOR i IN 1..l_msg_count
1099: LOOP
1100: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
1101: p_encoded => fnd_api.g_false)));
1161: x_msg_data => s_msg_data,
1162: x_salesrep_id => l_salesrep_id
1163: );
1164: IF(s_return_status <> 'S') THEN
1165: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_SRP_ERR');
1166: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
1167: fnd_file.put_line(fnd_file.log, fnd_message.get);
1168: FOR i IN 1..s_msg_count LOOP
1169: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
1162: x_salesrep_id => l_salesrep_id
1163: );
1164: IF(s_return_status <> 'S') THEN
1165: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_SRP_ERR');
1166: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
1167: fnd_file.put_line(fnd_file.log, fnd_message.get);
1168: FOR i IN 1..s_msg_count LOOP
1169: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
1170: p_encoded => fnd_api.g_false)));
1163: );
1164: IF(s_return_status <> 'S') THEN
1165: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_SRP_ERR');
1166: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
1167: fnd_file.put_line(fnd_file.log, fnd_message.get);
1168: FOR i IN 1..s_msg_count LOOP
1169: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
1170: p_encoded => fnd_api.g_false)));
1171: END LOOP;
1212: OPEN c_role_name (i.role_id);
1213: FETCH c_role_name INTO l_role_name;
1214: CLOSE c_role_name;
1215:
1216: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_RES_ROLE');
1217: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
1218: fnd_message.set_token('P_ROLE_NAME',l_role_name);
1219: fnd_file.put_line(fnd_file.log, fnd_message.get);
1220: FOR i IN 1..r_msg_count LOOP
1213: FETCH c_role_name INTO l_role_name;
1214: CLOSE c_role_name;
1215:
1216: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_RES_ROLE');
1217: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
1218: fnd_message.set_token('P_ROLE_NAME',l_role_name);
1219: fnd_file.put_line(fnd_file.log, fnd_message.get);
1220: FOR i IN 1..r_msg_count LOOP
1221: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
1214: CLOSE c_role_name;
1215:
1216: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_RES_ROLE');
1217: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
1218: fnd_message.set_token('P_ROLE_NAME',l_role_name);
1219: fnd_file.put_line(fnd_file.log, fnd_message.get);
1220: FOR i IN 1..r_msg_count LOOP
1221: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
1222: p_encoded => fnd_api.g_false)));
1215:
1216: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_RES_ROLE');
1217: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
1218: fnd_message.set_token('P_ROLE_NAME',l_role_name);
1219: fnd_file.put_line(fnd_file.log, fnd_message.get);
1220: FOR i IN 1..r_msg_count LOOP
1221: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
1222: p_encoded => fnd_api.g_false)));
1223: END LOOP;
1455: , x_msg_count => l_msg_count
1456: , x_msg_data => l_msg_data);
1457:
1458: IF ( l_return_status <> fnd_api.g_ret_sts_success) THEN
1459: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_TER_RES');
1460: fnd_message.set_token('P_RESOURCE_NAME', term_emp_rec.resource_name);
1461: fnd_file.put_line(fnd_file.log, fnd_message.get);
1462: FOR i IN 1..l_msg_count LOOP
1463: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
1456: , x_msg_data => l_msg_data);
1457:
1458: IF ( l_return_status <> fnd_api.g_ret_sts_success) THEN
1459: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_TER_RES');
1460: fnd_message.set_token('P_RESOURCE_NAME', term_emp_rec.resource_name);
1461: fnd_file.put_line(fnd_file.log, fnd_message.get);
1462: FOR i IN 1..l_msg_count LOOP
1463: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
1464: p_encoded => fnd_api.g_false)));
1457:
1458: IF ( l_return_status <> fnd_api.g_ret_sts_success) THEN
1459: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_TER_RES');
1460: fnd_message.set_token('P_RESOURCE_NAME', term_emp_rec.resource_name);
1461: fnd_file.put_line(fnd_file.log, fnd_message.get);
1462: FOR i IN 1..l_msg_count LOOP
1463: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
1464: p_encoded => fnd_api.g_false)));
1465: END LOOP;
2103: l_role_name := NULL;
2104: OPEN c_role_name (l_job_roles_rec.role_id);
2105: FETCH c_role_name INTO l_role_name;
2106: CLOSE c_role_name;
2107: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');
2108: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2109: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2110: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2111: fnd_file.put_line(fnd_file.log, fnd_message.get);
2104: OPEN c_role_name (l_job_roles_rec.role_id);
2105: FETCH c_role_name INTO l_role_name;
2106: CLOSE c_role_name;
2107: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');
2108: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2109: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2110: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2111: fnd_file.put_line(fnd_file.log, fnd_message.get);
2112: for i in 1..r_msg_count loop
2105: FETCH c_role_name INTO l_role_name;
2106: CLOSE c_role_name;
2107: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');
2108: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2109: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2110: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2111: fnd_file.put_line(fnd_file.log, fnd_message.get);
2112: for i in 1..r_msg_count loop
2113: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,p_encoded => fnd_api.g_false)));
2106: CLOSE c_role_name;
2107: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');
2108: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2109: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2110: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2111: fnd_file.put_line(fnd_file.log, fnd_message.get);
2112: for i in 1..r_msg_count loop
2113: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,p_encoded => fnd_api.g_false)));
2114: end loop;
2107: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');
2108: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2109: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2110: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2111: fnd_file.put_line(fnd_file.log, fnd_message.get);
2112: for i in 1..r_msg_count loop
2113: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,p_encoded => fnd_api.g_false)));
2114: end loop;
2115: CLOSE c_job_roles;
2194: l_role_name := NULL;
2195: OPEN c_role_name (l_job_roles_rec.role_id);
2196: FETCH c_role_name INTO l_role_name;
2197: CLOSE c_role_name;
2198: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');
2199: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2200: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2201: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2202: fnd_file.put_line(fnd_file.log, fnd_message.get);
2195: OPEN c_role_name (l_job_roles_rec.role_id);
2196: FETCH c_role_name INTO l_role_name;
2197: CLOSE c_role_name;
2198: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');
2199: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2200: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2201: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2202: fnd_file.put_line(fnd_file.log, fnd_message.get);
2203: for j in 1..r_msg_count loop
2196: FETCH c_role_name INTO l_role_name;
2197: CLOSE c_role_name;
2198: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');
2199: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2200: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2201: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2202: fnd_file.put_line(fnd_file.log, fnd_message.get);
2203: for j in 1..r_msg_count loop
2204: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(j,p_encoded => fnd_api.g_false)));
2197: CLOSE c_role_name;
2198: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');
2199: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2200: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2201: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2202: fnd_file.put_line(fnd_file.log, fnd_message.get);
2203: for j in 1..r_msg_count loop
2204: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(j,p_encoded => fnd_api.g_false)));
2205: end loop;
2198: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');
2199: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2200: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2201: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2202: fnd_file.put_line(fnd_file.log, fnd_message.get);
2203: for j in 1..r_msg_count loop
2204: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(j,p_encoded => fnd_api.g_false)));
2205: end loop;
2206: fnd_msg_pub.delete_msg;
2262: l_role_name := NULL;
2263: OPEN c_role_name (i.role_id);
2264: FETCH c_role_name INTO l_role_name;
2265: CLOSE c_role_name;
2266: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');
2267: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2268: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2269: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2270: fnd_file.put_line(fnd_file.log, fnd_message.get);
2263: OPEN c_role_name (i.role_id);
2264: FETCH c_role_name INTO l_role_name;
2265: CLOSE c_role_name;
2266: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');
2267: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2268: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2269: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2270: fnd_file.put_line(fnd_file.log, fnd_message.get);
2271: for j in 1..r_msg_count loop
2264: FETCH c_role_name INTO l_role_name;
2265: CLOSE c_role_name;
2266: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');
2267: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2268: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2269: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2270: fnd_file.put_line(fnd_file.log, fnd_message.get);
2271: for j in 1..r_msg_count loop
2272: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(j,p_encoded => fnd_api.g_false)));
2265: CLOSE c_role_name;
2266: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');
2267: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2268: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2269: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2270: fnd_file.put_line(fnd_file.log, fnd_message.get);
2271: for j in 1..r_msg_count loop
2272: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(j,p_encoded => fnd_api.g_false)));
2273: end loop;
2266: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');
2267: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2268: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2269: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2270: fnd_file.put_line(fnd_file.log, fnd_message.get);
2271: for j in 1..r_msg_count loop
2272: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(j,p_encoded => fnd_api.g_false)));
2273: end loop;
2274: fnd_msg_pub.delete_msg;
2355: l_role_name := NULL;
2356: OPEN c_role_name (l_job_roles_rec.role_id);
2357: FETCH c_role_name INTO l_role_name;
2358: CLOSE c_role_name;
2359: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_ROL_ERR');
2360: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2361: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2362: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2363: fnd_file.put_line(fnd_file.log, fnd_message.get);
2356: OPEN c_role_name (l_job_roles_rec.role_id);
2357: FETCH c_role_name INTO l_role_name;
2358: CLOSE c_role_name;
2359: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_ROL_ERR');
2360: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2361: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2362: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2363: fnd_file.put_line(fnd_file.log, fnd_message.get);
2364: for i in 1..r_msg_count loop
2357: FETCH c_role_name INTO l_role_name;
2358: CLOSE c_role_name;
2359: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_ROL_ERR');
2360: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2361: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2362: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2363: fnd_file.put_line(fnd_file.log, fnd_message.get);
2364: for i in 1..r_msg_count loop
2365: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,p_encoded => fnd_api.g_false)));
2358: CLOSE c_role_name;
2359: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_ROL_ERR');
2360: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2361: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2362: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2363: fnd_file.put_line(fnd_file.log, fnd_message.get);
2364: for i in 1..r_msg_count loop
2365: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,p_encoded => fnd_api.g_false)));
2366: end loop;
2359: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_ROL_ERR');
2360: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2361: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2362: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2363: fnd_file.put_line(fnd_file.log, fnd_message.get);
2364: for i in 1..r_msg_count loop
2365: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,p_encoded => fnd_api.g_false)));
2366: end loop;
2367: fnd_msg_pub.delete_msg;
2501: l_role_name := NULL;
2502: OPEN c_role_name (l_job_roles_rec.role_id);
2503: FETCH c_role_name INTO l_role_name;
2504: CLOSE c_role_name;
2505: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');
2506: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2507: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2508: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2509: fnd_file.put_line(fnd_file.log, fnd_message.get);
2502: OPEN c_role_name (l_job_roles_rec.role_id);
2503: FETCH c_role_name INTO l_role_name;
2504: CLOSE c_role_name;
2505: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');
2506: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2507: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2508: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2509: fnd_file.put_line(fnd_file.log, fnd_message.get);
2510: for j in 1..r_msg_count loop
2503: FETCH c_role_name INTO l_role_name;
2504: CLOSE c_role_name;
2505: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');
2506: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2507: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2508: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2509: fnd_file.put_line(fnd_file.log, fnd_message.get);
2510: for j in 1..r_msg_count loop
2511: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(j,p_encoded => fnd_api.g_false)));
2504: CLOSE c_role_name;
2505: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');
2506: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2507: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2508: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2509: fnd_file.put_line(fnd_file.log, fnd_message.get);
2510: for j in 1..r_msg_count loop
2511: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(j,p_encoded => fnd_api.g_false)));
2512: end loop;
2505: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');
2506: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2507: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2508: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2509: fnd_file.put_line(fnd_file.log, fnd_message.get);
2510: for j in 1..r_msg_count loop
2511: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(j,p_encoded => fnd_api.g_false)));
2512: end loop;
2513: fnd_msg_pub.delete_msg;
2547: l_role_name := NULL;
2548: OPEN c_role_name (l_job_roles_rec.role_id);
2549: FETCH c_role_name INTO l_role_name;
2550: CLOSE c_role_name;
2551: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_ROL_ERR');
2552: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2553: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2554: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2555: fnd_file.put_line(fnd_file.log, fnd_message.get);
2548: OPEN c_role_name (l_job_roles_rec.role_id);
2549: FETCH c_role_name INTO l_role_name;
2550: CLOSE c_role_name;
2551: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_ROL_ERR');
2552: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2553: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2554: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2555: fnd_file.put_line(fnd_file.log, fnd_message.get);
2556: for i in 1..r_msg_count loop
2549: FETCH c_role_name INTO l_role_name;
2550: CLOSE c_role_name;
2551: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_ROL_ERR');
2552: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2553: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2554: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2555: fnd_file.put_line(fnd_file.log, fnd_message.get);
2556: for i in 1..r_msg_count loop
2557: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,p_encoded => fnd_api.g_false)));
2550: CLOSE c_role_name;
2551: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_ROL_ERR');
2552: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2553: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2554: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2555: fnd_file.put_line(fnd_file.log, fnd_message.get);
2556: for i in 1..r_msg_count loop
2557: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,p_encoded => fnd_api.g_false)));
2558: end loop;
2551: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_ROL_ERR');
2552: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2553: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2554: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2555: fnd_file.put_line(fnd_file.log, fnd_message.get);
2556: for i in 1..r_msg_count loop
2557: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,p_encoded => fnd_api.g_false)));
2558: end loop;
2559: fnd_msg_pub.delete_msg;
3555: RES.SOURCE_MAILSTOP = emp_rec.mailstop
3556: WHERE RES.resource_id = emp_rec.resource_id;
3557: WHEN OTHERS
3558: THEN
3559: fnd_message.set_name('JTF', 'JTF_RS_UPD_TERM_RES_ERR');
3560: fnd_message.set_token('P_PERSON_ID',term_res_rec.source_id );
3561: fnd_file.put_line(fnd_file.log, fnd_message.get);
3562:
3563: end;
3556: WHERE RES.resource_id = emp_rec.resource_id;
3557: WHEN OTHERS
3558: THEN
3559: fnd_message.set_name('JTF', 'JTF_RS_UPD_TERM_RES_ERR');
3560: fnd_message.set_token('P_PERSON_ID',term_res_rec.source_id );
3561: fnd_file.put_line(fnd_file.log, fnd_message.get);
3562:
3563: end;
3564: fetch term_res_cur into term_res_rec;
3557: WHEN OTHERS
3558: THEN
3559: fnd_message.set_name('JTF', 'JTF_RS_UPD_TERM_RES_ERR');
3560: fnd_message.set_token('P_PERSON_ID',term_res_rec.source_id );
3561: fnd_file.put_line(fnd_file.log, fnd_message.get);
3562:
3563: end;
3564: fetch term_res_cur into term_res_rec;
3565: end loop;
4444: ) ;
4445:
4446: IF ( l_return_status <> fnd_api.g_ret_sts_success)
4447: THEN
4448: fnd_message.set_name('JTF', 'JTF_RS_CONC_UPDATE_USERID_ERR');
4449: fnd_message.set_token('P_SOURCE_ID', l_c_invalid_userid.source_id);
4450: fnd_file.put_line(fnd_file.log, fnd_message.get);
4451: FOR i IN 1..l_msg_count
4452: LOOP
4445:
4446: IF ( l_return_status <> fnd_api.g_ret_sts_success)
4447: THEN
4448: fnd_message.set_name('JTF', 'JTF_RS_CONC_UPDATE_USERID_ERR');
4449: fnd_message.set_token('P_SOURCE_ID', l_c_invalid_userid.source_id);
4450: fnd_file.put_line(fnd_file.log, fnd_message.get);
4451: FOR i IN 1..l_msg_count
4452: LOOP
4453: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
4446: IF ( l_return_status <> fnd_api.g_ret_sts_success)
4447: THEN
4448: fnd_message.set_name('JTF', 'JTF_RS_CONC_UPDATE_USERID_ERR');
4449: fnd_message.set_token('P_SOURCE_ID', l_c_invalid_userid.source_id);
4450: fnd_file.put_line(fnd_file.log, fnd_message.get);
4451: FOR i IN 1..l_msg_count
4452: LOOP
4453: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
4454: p_encoded => fnd_api.g_false)));
4499: ) ;
4500:
4501: IF ( l_return_status <> fnd_api.g_ret_sts_success)
4502: THEN
4503: fnd_message.set_name('JTF', 'JTF_RS_CONC_UPDATE_USERID_ERR');
4504: fnd_message.set_token('P_SOURCE_ID', l_c_invalid_active_userid.source_id);
4505: fnd_file.put_line(fnd_file.log, fnd_message.get);
4506: FOR i IN 1..l_msg_count
4507: LOOP
4500:
4501: IF ( l_return_status <> fnd_api.g_ret_sts_success)
4502: THEN
4503: fnd_message.set_name('JTF', 'JTF_RS_CONC_UPDATE_USERID_ERR');
4504: fnd_message.set_token('P_SOURCE_ID', l_c_invalid_active_userid.source_id);
4505: fnd_file.put_line(fnd_file.log, fnd_message.get);
4506: FOR i IN 1..l_msg_count
4507: LOOP
4508: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
4501: IF ( l_return_status <> fnd_api.g_ret_sts_success)
4502: THEN
4503: fnd_message.set_name('JTF', 'JTF_RS_CONC_UPDATE_USERID_ERR');
4504: fnd_message.set_token('P_SOURCE_ID', l_c_invalid_active_userid.source_id);
4505: fnd_file.put_line(fnd_file.log, fnd_message.get);
4506: FOR i IN 1..l_msg_count
4507: LOOP
4508: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
4509: p_encoded => fnd_api.g_false)));
4553: x_msg_data => l_msg_data
4554: ) ;
4555: IF ( l_return_status <> fnd_api.g_ret_sts_success)
4556: THEN
4557: fnd_message.set_name('JTF', 'JTF_RS_CONC_UPDATE_USERID_ERR');
4558: fnd_message.set_token('P_SOURCE_ID', l_c_null_userid.source_id);
4559: fnd_file.put_line(fnd_file.log, fnd_message.get);
4560: FOR i IN 1..l_msg_count
4561: LOOP
4554: ) ;
4555: IF ( l_return_status <> fnd_api.g_ret_sts_success)
4556: THEN
4557: fnd_message.set_name('JTF', 'JTF_RS_CONC_UPDATE_USERID_ERR');
4558: fnd_message.set_token('P_SOURCE_ID', l_c_null_userid.source_id);
4559: fnd_file.put_line(fnd_file.log, fnd_message.get);
4560: FOR i IN 1..l_msg_count
4561: LOOP
4562: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
4555: IF ( l_return_status <> fnd_api.g_ret_sts_success)
4556: THEN
4557: fnd_message.set_name('JTF', 'JTF_RS_CONC_UPDATE_USERID_ERR');
4558: fnd_message.set_token('P_SOURCE_ID', l_c_null_userid.source_id);
4559: fnd_file.put_line(fnd_file.log, fnd_message.get);
4560: FOR i IN 1..l_msg_count
4561: LOOP
4562: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
4563: p_encoded => fnd_api.g_false)));