DBA Data[Home] [Help]

APPS.JTF_RS_CONC_RES_PUB dependencies on FND_MESSAGE

Line 225: fnd_message.set_name ('JTF','JTF_RS_CP_PM_SLS_CRDT_TYP_NULL');

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;

Line 226: fnd_file.put_line(fnd_file.log, fnd_message.get);

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

Line 231: fnd_message.set_name('JTF', 'JTF_RS_PROF_SRP_NUM_CONC_ERR');

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';

Line 232: fnd_message.set_token('P_PROFILE_VALUE', l_prof_srp_num);

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;

Line 233: fnd_file.put_line(fnd_file.log, fnd_message.get);

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;

Line 762: fnd_message.set_name('JTF', 'JTF_RS_CONC_CREATE_EMP_ERR');

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

Line 763: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);

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,

Line 764: fnd_file.put_line(fnd_file.log, fnd_message.get);

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)));

Line 847: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_SRP_ERR');

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,

Line 848: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);

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)));

Line 849: fnd_file.put_line(fnd_file.log, fnd_message.get);

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;

Line 897: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_RES_ROLE');

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

Line 898: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);

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,

Line 899: fnd_message.set_token('P_ROLE_NAME',l_role_name);

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)));

Line 900: fnd_file.put_line(fnd_file.log, fnd_message.get);

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;

Line 1095: fnd_message.set_name('JTF', 'JTF_RS_CONC_CREATE_EMP_ERR');

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

Line 1096: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);

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,

Line 1097: fnd_file.put_line(fnd_file.log, fnd_message.get);

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)));

Line 1165: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_SRP_ERR');

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,

Line 1166: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);

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)));

Line 1167: fnd_file.put_line(fnd_file.log, fnd_message.get);

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;

Line 1216: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_RES_ROLE');

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

Line 1217: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);

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,

Line 1218: fnd_message.set_token('P_ROLE_NAME',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,
1222: p_encoded => fnd_api.g_false)));

Line 1219: fnd_file.put_line(fnd_file.log, fnd_message.get);

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;

Line 1459: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_TER_RES');

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,

Line 1460: fnd_message.set_token('P_RESOURCE_NAME', term_emp_rec.resource_name);

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)));

Line 1461: fnd_file.put_line(fnd_file.log, fnd_message.get);

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;

Line 2107: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');

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);

Line 2108: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);

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

Line 2109: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);

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)));

Line 2110: fnd_message.set_token('P_ROLE_NAME', 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)));
2114: end loop;

Line 2111: fnd_file.put_line(fnd_file.log, fnd_message.get);

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;

Line 2198: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');

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);

Line 2199: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);

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

Line 2200: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);

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)));

Line 2201: fnd_message.set_token('P_ROLE_NAME', 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)));
2205: end loop;

Line 2202: fnd_file.put_line(fnd_file.log, fnd_message.get);

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;

Line 2266: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');

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);

Line 2267: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);

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

Line 2268: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);

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)));

Line 2269: fnd_message.set_token('P_ROLE_NAME', 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)));
2273: end loop;

Line 2270: fnd_file.put_line(fnd_file.log, fnd_message.get);

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;

Line 2359: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_ROL_ERR');

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);

Line 2360: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);

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

Line 2361: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);

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)));

Line 2362: fnd_message.set_token('P_ROLE_NAME', 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)));
2366: end loop;

Line 2363: fnd_file.put_line(fnd_file.log, fnd_message.get);

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;

Line 2505: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');

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);

Line 2506: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);

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

Line 2507: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);

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)));

Line 2508: fnd_message.set_token('P_ROLE_NAME', 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)));
2512: end loop;

Line 2509: fnd_file.put_line(fnd_file.log, fnd_message.get);

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;

Line 2551: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_ROL_ERR');

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);

Line 2552: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);

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

Line 2553: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);

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)));

Line 2554: fnd_message.set_token('P_ROLE_NAME', 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)));
2558: end loop;

Line 2555: fnd_file.put_line(fnd_file.log, fnd_message.get);

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;

Line 3559: fnd_message.set_name('JTF', 'JTF_RS_UPD_TERM_RES_ERR');

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;

Line 3560: fnd_message.set_token('P_PERSON_ID',term_res_rec.source_id );

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;

Line 3561: fnd_file.put_line(fnd_file.log, fnd_message.get);

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;

Line 4448: fnd_message.set_name('JTF', 'JTF_RS_CONC_UPDATE_USERID_ERR');

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

Line 4449: fnd_message.set_token('P_SOURCE_ID', l_c_invalid_userid.source_id);

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,

Line 4450: fnd_file.put_line(fnd_file.log, fnd_message.get);

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)));

Line 4503: fnd_message.set_name('JTF', 'JTF_RS_CONC_UPDATE_USERID_ERR');

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

Line 4504: fnd_message.set_token('P_SOURCE_ID', l_c_invalid_active_userid.source_id);

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,

Line 4505: fnd_file.put_line(fnd_file.log, fnd_message.get);

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)));

Line 4557: fnd_message.set_name('JTF', 'JTF_RS_CONC_UPDATE_USERID_ERR');

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

Line 4558: fnd_message.set_token('P_SOURCE_ID', l_c_null_userid.source_id);

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,

Line 4559: fnd_file.put_line(fnd_file.log, fnd_message.get);

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)));