eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_CONC_RES_PUB dependencies on FND_MESSAGE

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

163: -- Adding Code for Enh to Create Salesperson and Roles (Job-Role Map) Automatically
164: IF (p_get_new_emp ='Y') THEN
165: IF (p_create_srp = 'Y') THEN
166: IF (p_sales_credit_type IS NULL) THEN
167: fnd_message.set_name ('JTF','JTF_RS_CP_PM_SLS_CRDT_TYP_NULL');
168: fnd_file.put_line(fnd_file.log, fnd_message.get);
169: fnd_file.new_line(fnd_file.log,1);
170: set_err_var := 'Y';
171: END IF;

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

164: IF (p_get_new_emp ='Y') THEN
165: IF (p_create_srp = 'Y') THEN
166: IF (p_sales_credit_type IS NULL) THEN
167: fnd_message.set_name ('JTF','JTF_RS_CP_PM_SLS_CRDT_TYP_NULL');
168: fnd_file.put_line(fnd_file.log, fnd_message.get);
169: fnd_file.new_line(fnd_file.log,1);
170: set_err_var := 'Y';
171: END IF;
172: IF (l_prof_srp_num = 'MANUALLY_ENTERED' OR l_prof_srp_num IS NULL) THEN

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

169: fnd_file.new_line(fnd_file.log,1);
170: set_err_var := 'Y';
171: END IF;
172: IF (l_prof_srp_num = 'MANUALLY_ENTERED' OR l_prof_srp_num IS NULL) THEN
173: fnd_message.set_name('JTF', 'JTF_RS_PROF_SRP_NUM_CONC_ERR');
174: fnd_message.set_token('P_PROFILE_VALUE', l_prof_srp_num);
175: fnd_file.put_line(fnd_file.log, fnd_message.get);
176: fnd_file.new_line(fnd_file.log,1);
177: set_err_var := 'Y';

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

170: set_err_var := 'Y';
171: END IF;
172: IF (l_prof_srp_num = 'MANUALLY_ENTERED' OR l_prof_srp_num IS NULL) THEN
173: fnd_message.set_name('JTF', 'JTF_RS_PROF_SRP_NUM_CONC_ERR');
174: fnd_message.set_token('P_PROFILE_VALUE', l_prof_srp_num);
175: fnd_file.put_line(fnd_file.log, fnd_message.get);
176: fnd_file.new_line(fnd_file.log,1);
177: set_err_var := 'Y';
178: END IF;

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

171: END IF;
172: IF (l_prof_srp_num = 'MANUALLY_ENTERED' OR l_prof_srp_num IS NULL) THEN
173: fnd_message.set_name('JTF', 'JTF_RS_PROF_SRP_NUM_CONC_ERR');
174: fnd_message.set_token('P_PROFILE_VALUE', l_prof_srp_num);
175: fnd_file.put_line(fnd_file.log, fnd_message.get);
176: fnd_file.new_line(fnd_file.log,1);
177: set_err_var := 'Y';
178: END IF;
179: END IF;

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

700: );
701:
702: -- dbms_output.put_line('name '||fetch_emp_rec.full_name);
703: IF ( l_return_status <> fnd_api.g_ret_sts_success) THEN
704: fnd_message.set_name('JTF', 'JTF_RS_CONC_CREATE_EMP_ERR');
705: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
706: fnd_file.put_line(fnd_file.log, fnd_message.get);
707: FOR i IN 1..l_msg_count
708: LOOP

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

701:
702: -- dbms_output.put_line('name '||fetch_emp_rec.full_name);
703: IF ( l_return_status <> fnd_api.g_ret_sts_success) THEN
704: fnd_message.set_name('JTF', 'JTF_RS_CONC_CREATE_EMP_ERR');
705: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
706: fnd_file.put_line(fnd_file.log, fnd_message.get);
707: FOR i IN 1..l_msg_count
708: LOOP
709: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,

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

702: -- dbms_output.put_line('name '||fetch_emp_rec.full_name);
703: IF ( l_return_status <> fnd_api.g_ret_sts_success) THEN
704: fnd_message.set_name('JTF', 'JTF_RS_CONC_CREATE_EMP_ERR');
705: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
706: fnd_file.put_line(fnd_file.log, fnd_message.get);
707: FOR i IN 1..l_msg_count
708: LOOP
709: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
710: p_encoded => fnd_api.g_false)));

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

785: x_msg_data => s_msg_data,
786: x_salesrep_id => l_salesrep_id
787: );
788: IF(s_return_status <> 'S') THEN
789: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_SRP_ERR');
790: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
791: fnd_file.put_line(fnd_file.log, fnd_message.get);
792: FOR i IN 1..s_msg_count LOOP
793: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,

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

786: x_salesrep_id => l_salesrep_id
787: );
788: IF(s_return_status <> 'S') THEN
789: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_SRP_ERR');
790: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
791: fnd_file.put_line(fnd_file.log, fnd_message.get);
792: FOR i IN 1..s_msg_count LOOP
793: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
794: p_encoded => fnd_api.g_false)));

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

787: );
788: IF(s_return_status <> 'S') THEN
789: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_SRP_ERR');
790: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
791: fnd_file.put_line(fnd_file.log, fnd_message.get);
792: FOR i IN 1..s_msg_count LOOP
793: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
794: p_encoded => fnd_api.g_false)));
795: END LOOP;

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

835: l_role_name := NULL;
836: OPEN c_role_name (i.role_id);
837: FETCH c_role_name INTO l_role_name;
838: CLOSE c_role_name;
839: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_RES_ROLE');
840: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
841: fnd_message.set_token('P_ROLE_NAME',l_role_name);
842: fnd_file.put_line(fnd_file.log, fnd_message.get);
843: FOR i IN 1..r_msg_count LOOP

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

836: OPEN c_role_name (i.role_id);
837: FETCH c_role_name INTO l_role_name;
838: CLOSE c_role_name;
839: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_RES_ROLE');
840: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
841: fnd_message.set_token('P_ROLE_NAME',l_role_name);
842: fnd_file.put_line(fnd_file.log, fnd_message.get);
843: FOR i IN 1..r_msg_count LOOP
844: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,

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

837: FETCH c_role_name INTO l_role_name;
838: CLOSE c_role_name;
839: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_RES_ROLE');
840: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
841: fnd_message.set_token('P_ROLE_NAME',l_role_name);
842: fnd_file.put_line(fnd_file.log, fnd_message.get);
843: FOR i IN 1..r_msg_count LOOP
844: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
845: p_encoded => fnd_api.g_false)));

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

838: CLOSE c_role_name;
839: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_RES_ROLE');
840: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
841: fnd_message.set_token('P_ROLE_NAME',l_role_name);
842: fnd_file.put_line(fnd_file.log, fnd_message.get);
843: FOR i IN 1..r_msg_count LOOP
844: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
845: p_encoded => fnd_api.g_false)));
846: END LOOP;

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

1033:
1034: -- dbms_output.put_line('name '||fetch_emp_rec.full_name);
1035: IF ( l_return_status <> fnd_api.g_ret_sts_success) THEN
1036:
1037: fnd_message.set_name('JTF', 'JTF_RS_CONC_CREATE_EMP_ERR');
1038: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
1039: fnd_file.put_line(fnd_file.log, fnd_message.get);
1040: FOR i IN 1..l_msg_count
1041: LOOP

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

1034: -- dbms_output.put_line('name '||fetch_emp_rec.full_name);
1035: IF ( l_return_status <> fnd_api.g_ret_sts_success) THEN
1036:
1037: fnd_message.set_name('JTF', 'JTF_RS_CONC_CREATE_EMP_ERR');
1038: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
1039: fnd_file.put_line(fnd_file.log, fnd_message.get);
1040: FOR i IN 1..l_msg_count
1041: LOOP
1042: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,

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

1035: IF ( l_return_status <> fnd_api.g_ret_sts_success) THEN
1036:
1037: fnd_message.set_name('JTF', 'JTF_RS_CONC_CREATE_EMP_ERR');
1038: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
1039: fnd_file.put_line(fnd_file.log, fnd_message.get);
1040: FOR i IN 1..l_msg_count
1041: LOOP
1042: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
1043: p_encoded => fnd_api.g_false)));

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

1103: x_msg_data => s_msg_data,
1104: x_salesrep_id => l_salesrep_id
1105: );
1106: IF(s_return_status <> 'S') THEN
1107: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_SRP_ERR');
1108: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
1109: fnd_file.put_line(fnd_file.log, fnd_message.get);
1110: FOR i IN 1..s_msg_count LOOP
1111: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,

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

1104: x_salesrep_id => l_salesrep_id
1105: );
1106: IF(s_return_status <> 'S') THEN
1107: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_SRP_ERR');
1108: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
1109: fnd_file.put_line(fnd_file.log, fnd_message.get);
1110: FOR i IN 1..s_msg_count LOOP
1111: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
1112: p_encoded => fnd_api.g_false)));

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

1105: );
1106: IF(s_return_status <> 'S') THEN
1107: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_SRP_ERR');
1108: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
1109: fnd_file.put_line(fnd_file.log, fnd_message.get);
1110: FOR i IN 1..s_msg_count LOOP
1111: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
1112: p_encoded => fnd_api.g_false)));
1113: END LOOP;

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

1154: OPEN c_role_name (i.role_id);
1155: FETCH c_role_name INTO l_role_name;
1156: CLOSE c_role_name;
1157:
1158: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_RES_ROLE');
1159: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
1160: fnd_message.set_token('P_ROLE_NAME',l_role_name);
1161: fnd_file.put_line(fnd_file.log, fnd_message.get);
1162: FOR i IN 1..r_msg_count LOOP

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

1155: FETCH c_role_name INTO l_role_name;
1156: CLOSE c_role_name;
1157:
1158: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_RES_ROLE');
1159: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
1160: fnd_message.set_token('P_ROLE_NAME',l_role_name);
1161: fnd_file.put_line(fnd_file.log, fnd_message.get);
1162: FOR i IN 1..r_msg_count LOOP
1163: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,

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

1156: CLOSE c_role_name;
1157:
1158: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_RES_ROLE');
1159: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
1160: fnd_message.set_token('P_ROLE_NAME',l_role_name);
1161: fnd_file.put_line(fnd_file.log, fnd_message.get);
1162: FOR i IN 1..r_msg_count LOOP
1163: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
1164: p_encoded => fnd_api.g_false)));

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

1157:
1158: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_RES_ROLE');
1159: fnd_message.set_token('P_EMPLOYEE_NAME', fetch_emp_rec.full_name);
1160: fnd_message.set_token('P_ROLE_NAME',l_role_name);
1161: fnd_file.put_line(fnd_file.log, fnd_message.get);
1162: FOR i IN 1..r_msg_count LOOP
1163: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
1164: p_encoded => fnd_api.g_false)));
1165: END LOOP;

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

1397: , x_msg_count => l_msg_count
1398: , x_msg_data => l_msg_data);
1399:
1400: IF ( l_return_status <> fnd_api.g_ret_sts_success) THEN
1401: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_TER_RES');
1402: fnd_message.set_token('P_RESOURCE_NAME', term_emp_rec.resource_name);
1403: fnd_file.put_line(fnd_file.log, fnd_message.get);
1404: FOR i IN 1..l_msg_count LOOP
1405: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,

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

1398: , x_msg_data => l_msg_data);
1399:
1400: IF ( l_return_status <> fnd_api.g_ret_sts_success) THEN
1401: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_TER_RES');
1402: fnd_message.set_token('P_RESOURCE_NAME', term_emp_rec.resource_name);
1403: fnd_file.put_line(fnd_file.log, fnd_message.get);
1404: FOR i IN 1..l_msg_count LOOP
1405: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
1406: p_encoded => fnd_api.g_false)));

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

1399:
1400: IF ( l_return_status <> fnd_api.g_ret_sts_success) THEN
1401: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_TER_RES');
1402: fnd_message.set_token('P_RESOURCE_NAME', term_emp_rec.resource_name);
1403: fnd_file.put_line(fnd_file.log, fnd_message.get);
1404: FOR i IN 1..l_msg_count LOOP
1405: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
1406: p_encoded => fnd_api.g_false)));
1407: END LOOP;

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

1901: l_role_name := NULL;
1902: OPEN c_role_name (l_job_roles_rec.role_id);
1903: FETCH c_role_name INTO l_role_name;
1904: CLOSE c_role_name;
1905: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');
1906: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
1907: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
1908: fnd_message.set_token('P_ROLE_NAME', l_role_name);
1909: fnd_file.put_line(fnd_file.log, fnd_message.get);

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

1902: OPEN c_role_name (l_job_roles_rec.role_id);
1903: FETCH c_role_name INTO l_role_name;
1904: CLOSE c_role_name;
1905: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');
1906: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
1907: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
1908: fnd_message.set_token('P_ROLE_NAME', l_role_name);
1909: fnd_file.put_line(fnd_file.log, fnd_message.get);
1910: for i in 1..r_msg_count loop

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

1903: FETCH c_role_name INTO l_role_name;
1904: CLOSE c_role_name;
1905: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');
1906: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
1907: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
1908: fnd_message.set_token('P_ROLE_NAME', l_role_name);
1909: fnd_file.put_line(fnd_file.log, fnd_message.get);
1910: for i in 1..r_msg_count loop
1911: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,p_encoded => fnd_api.g_false)));

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

1904: CLOSE c_role_name;
1905: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');
1906: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
1907: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
1908: fnd_message.set_token('P_ROLE_NAME', l_role_name);
1909: fnd_file.put_line(fnd_file.log, fnd_message.get);
1910: for i in 1..r_msg_count loop
1911: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,p_encoded => fnd_api.g_false)));
1912: end loop;

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

1905: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');
1906: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
1907: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
1908: fnd_message.set_token('P_ROLE_NAME', l_role_name);
1909: fnd_file.put_line(fnd_file.log, fnd_message.get);
1910: for i in 1..r_msg_count loop
1911: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,p_encoded => fnd_api.g_false)));
1912: end loop;
1913: CLOSE c_job_roles;

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

1961: l_role_name := NULL;
1962: OPEN c_role_name (i.role_id);
1963: FETCH c_role_name INTO l_role_name;
1964: CLOSE c_role_name;
1965: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');
1966: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
1967: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
1968: fnd_message.set_token('P_ROLE_NAME', l_role_name);
1969: fnd_file.put_line(fnd_file.log, fnd_message.get);

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

1962: OPEN c_role_name (i.role_id);
1963: FETCH c_role_name INTO l_role_name;
1964: CLOSE c_role_name;
1965: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');
1966: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
1967: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
1968: fnd_message.set_token('P_ROLE_NAME', l_role_name);
1969: fnd_file.put_line(fnd_file.log, fnd_message.get);
1970: for j in 1..r_msg_count loop

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

1963: FETCH c_role_name INTO l_role_name;
1964: CLOSE c_role_name;
1965: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');
1966: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
1967: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
1968: fnd_message.set_token('P_ROLE_NAME', l_role_name);
1969: fnd_file.put_line(fnd_file.log, fnd_message.get);
1970: for j in 1..r_msg_count loop
1971: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(j,p_encoded => fnd_api.g_false)));

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

1964: CLOSE c_role_name;
1965: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');
1966: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
1967: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
1968: fnd_message.set_token('P_ROLE_NAME', l_role_name);
1969: fnd_file.put_line(fnd_file.log, fnd_message.get);
1970: for j in 1..r_msg_count loop
1971: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(j,p_encoded => fnd_api.g_false)));
1972: end loop;

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

1965: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');
1966: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
1967: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
1968: fnd_message.set_token('P_ROLE_NAME', l_role_name);
1969: fnd_file.put_line(fnd_file.log, fnd_message.get);
1970: for j in 1..r_msg_count loop
1971: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(j,p_encoded => fnd_api.g_false)));
1972: end loop;
1973: fnd_msg_pub.delete_msg;

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

2018: l_role_name := NULL;
2019: OPEN c_role_name (l_job_roles_rec.role_id);
2020: FETCH c_role_name INTO l_role_name;
2021: CLOSE c_role_name;
2022: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_ROL_ERR');
2023: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2024: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2025: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2026: fnd_file.put_line(fnd_file.log, fnd_message.get);

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

2019: OPEN c_role_name (l_job_roles_rec.role_id);
2020: FETCH c_role_name INTO l_role_name;
2021: CLOSE c_role_name;
2022: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_ROL_ERR');
2023: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2024: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2025: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2026: fnd_file.put_line(fnd_file.log, fnd_message.get);
2027: for i in 1..r_msg_count loop

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

2020: FETCH c_role_name INTO l_role_name;
2021: CLOSE c_role_name;
2022: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_ROL_ERR');
2023: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2024: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2025: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2026: fnd_file.put_line(fnd_file.log, fnd_message.get);
2027: for i in 1..r_msg_count loop
2028: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,p_encoded => fnd_api.g_false)));

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

2021: CLOSE c_role_name;
2022: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_ROL_ERR');
2023: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2024: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2025: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2026: fnd_file.put_line(fnd_file.log, fnd_message.get);
2027: for i in 1..r_msg_count loop
2028: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,p_encoded => fnd_api.g_false)));
2029: end loop;

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

2022: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_ROL_ERR');
2023: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2024: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2025: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2026: fnd_file.put_line(fnd_file.log, fnd_message.get);
2027: for i in 1..r_msg_count loop
2028: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,p_encoded => fnd_api.g_false)));
2029: end loop;
2030: fnd_msg_pub.delete_msg;

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

2074: l_role_name := NULL;
2075: OPEN c_role_name (i.role_id);
2076: FETCH c_role_name INTO l_role_name;
2077: CLOSE c_role_name;
2078: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');
2079: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2080: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2081: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2082: fnd_file.put_line(fnd_file.log, fnd_message.get);

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

2075: OPEN c_role_name (i.role_id);
2076: FETCH c_role_name INTO l_role_name;
2077: CLOSE c_role_name;
2078: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');
2079: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2080: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2081: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2082: fnd_file.put_line(fnd_file.log, fnd_message.get);
2083: for j in 1..r_msg_count loop

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

2076: FETCH c_role_name INTO l_role_name;
2077: CLOSE c_role_name;
2078: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');
2079: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2080: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2081: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2082: fnd_file.put_line(fnd_file.log, fnd_message.get);
2083: for j in 1..r_msg_count loop
2084: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(j,p_encoded => fnd_api.g_false)));

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

2077: CLOSE c_role_name;
2078: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');
2079: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2080: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2081: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2082: fnd_file.put_line(fnd_file.log, fnd_message.get);
2083: for j in 1..r_msg_count loop
2084: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(j,p_encoded => fnd_api.g_false)));
2085: end loop;

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

2078: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_UPD_ROL_ERR');
2079: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2080: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2081: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2082: fnd_file.put_line(fnd_file.log, fnd_message.get);
2083: for j in 1..r_msg_count loop
2084: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(j,p_encoded => fnd_api.g_false)));
2085: end loop;
2086: fnd_msg_pub.delete_msg;

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

2131: l_role_name := NULL;
2132: OPEN c_role_name (l_job_roles_rec.role_id);
2133: FETCH c_role_name INTO l_role_name;
2134: CLOSE c_role_name;
2135: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_ROL_ERR');
2136: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2137: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2138: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2139: fnd_file.put_line(fnd_file.log, fnd_message.get);

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

2132: OPEN c_role_name (l_job_roles_rec.role_id);
2133: FETCH c_role_name INTO l_role_name;
2134: CLOSE c_role_name;
2135: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_ROL_ERR');
2136: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2137: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2138: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2139: fnd_file.put_line(fnd_file.log, fnd_message.get);
2140: for i in 1..r_msg_count loop

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

2133: FETCH c_role_name INTO l_role_name;
2134: CLOSE c_role_name;
2135: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_ROL_ERR');
2136: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2137: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2138: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2139: fnd_file.put_line(fnd_file.log, fnd_message.get);
2140: for i in 1..r_msg_count loop
2141: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,p_encoded => fnd_api.g_false)));

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

2134: CLOSE c_role_name;
2135: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_ROL_ERR');
2136: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2137: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2138: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2139: fnd_file.put_line(fnd_file.log, fnd_message.get);
2140: for i in 1..r_msg_count loop
2141: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,p_encoded => fnd_api.g_false)));
2142: end loop;

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

2135: fnd_message.set_name('JTF', 'JTF_RS_CP_SYN_EMP_CRT_ROL_ERR');
2136: fnd_message.set_token('P_EMPLOYEE_NAME', l_ppf_rec.full_name);
2137: fnd_message.set_token('P_JOB_TITLE', p_new_job_title);
2138: fnd_message.set_token('P_ROLE_NAME', l_role_name);
2139: fnd_file.put_line(fnd_file.log, fnd_message.get);
2140: for i in 1..r_msg_count loop
2141: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,p_encoded => fnd_api.g_false)));
2142: end loop;
2143: fnd_msg_pub.delete_msg;

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

3104: RES.SOURCE_MAILSTOP = emp_rec.mailstop
3105: WHERE RES.resource_id = emp_rec.resource_id;
3106: WHEN OTHERS
3107: THEN
3108: fnd_message.set_name('JTF', 'JTF_RS_UPD_TERM_RES_ERR');
3109: fnd_message.set_token('P_PERSON_ID',term_res_rec.source_id );
3110: fnd_file.put_line(fnd_file.log, fnd_message.get);
3111:
3112: end;

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

3105: WHERE RES.resource_id = emp_rec.resource_id;
3106: WHEN OTHERS
3107: THEN
3108: fnd_message.set_name('JTF', 'JTF_RS_UPD_TERM_RES_ERR');
3109: fnd_message.set_token('P_PERSON_ID',term_res_rec.source_id );
3110: fnd_file.put_line(fnd_file.log, fnd_message.get);
3111:
3112: end;
3113: fetch term_res_cur into term_res_rec;

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

3106: WHEN OTHERS
3107: THEN
3108: fnd_message.set_name('JTF', 'JTF_RS_UPD_TERM_RES_ERR');
3109: fnd_message.set_token('P_PERSON_ID',term_res_rec.source_id );
3110: fnd_file.put_line(fnd_file.log, fnd_message.get);
3111:
3112: end;
3113: fetch term_res_cur into term_res_rec;
3114: end loop;

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

3995: ) ;
3996:
3997: IF ( l_return_status <> fnd_api.g_ret_sts_success)
3998: THEN
3999: fnd_message.set_name('JTF', 'JTF_RS_CONC_UPDATE_USERID_ERR');
4000: fnd_message.set_token('P_SOURCE_ID', l_c_invalid_userid.source_id);
4001: fnd_file.put_line(fnd_file.log, fnd_message.get);
4002: FOR i IN 1..l_msg_count
4003: LOOP

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

3996:
3997: IF ( l_return_status <> fnd_api.g_ret_sts_success)
3998: THEN
3999: fnd_message.set_name('JTF', 'JTF_RS_CONC_UPDATE_USERID_ERR');
4000: fnd_message.set_token('P_SOURCE_ID', l_c_invalid_userid.source_id);
4001: fnd_file.put_line(fnd_file.log, fnd_message.get);
4002: FOR i IN 1..l_msg_count
4003: LOOP
4004: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,

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

3997: IF ( l_return_status <> fnd_api.g_ret_sts_success)
3998: THEN
3999: fnd_message.set_name('JTF', 'JTF_RS_CONC_UPDATE_USERID_ERR');
4000: fnd_message.set_token('P_SOURCE_ID', l_c_invalid_userid.source_id);
4001: fnd_file.put_line(fnd_file.log, fnd_message.get);
4002: FOR i IN 1..l_msg_count
4003: LOOP
4004: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
4005: p_encoded => fnd_api.g_false)));

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

4050: ) ;
4051:
4052: IF ( l_return_status <> fnd_api.g_ret_sts_success)
4053: THEN
4054: fnd_message.set_name('JTF', 'JTF_RS_CONC_UPDATE_USERID_ERR');
4055: fnd_message.set_token('P_SOURCE_ID', l_c_invalid_active_userid.source_id);
4056: fnd_file.put_line(fnd_file.log, fnd_message.get);
4057: FOR i IN 1..l_msg_count
4058: LOOP

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

4051:
4052: IF ( l_return_status <> fnd_api.g_ret_sts_success)
4053: THEN
4054: fnd_message.set_name('JTF', 'JTF_RS_CONC_UPDATE_USERID_ERR');
4055: fnd_message.set_token('P_SOURCE_ID', l_c_invalid_active_userid.source_id);
4056: fnd_file.put_line(fnd_file.log, fnd_message.get);
4057: FOR i IN 1..l_msg_count
4058: LOOP
4059: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,

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

4052: IF ( l_return_status <> fnd_api.g_ret_sts_success)
4053: THEN
4054: fnd_message.set_name('JTF', 'JTF_RS_CONC_UPDATE_USERID_ERR');
4055: fnd_message.set_token('P_SOURCE_ID', l_c_invalid_active_userid.source_id);
4056: fnd_file.put_line(fnd_file.log, fnd_message.get);
4057: FOR i IN 1..l_msg_count
4058: LOOP
4059: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
4060: p_encoded => fnd_api.g_false)));

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

4104: x_msg_data => l_msg_data
4105: ) ;
4106: IF ( l_return_status <> fnd_api.g_ret_sts_success)
4107: THEN
4108: fnd_message.set_name('JTF', 'JTF_RS_CONC_UPDATE_USERID_ERR');
4109: fnd_message.set_token('P_SOURCE_ID', l_c_null_userid.source_id);
4110: fnd_file.put_line(fnd_file.log, fnd_message.get);
4111: FOR i IN 1..l_msg_count
4112: LOOP

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

4105: ) ;
4106: IF ( l_return_status <> fnd_api.g_ret_sts_success)
4107: THEN
4108: fnd_message.set_name('JTF', 'JTF_RS_CONC_UPDATE_USERID_ERR');
4109: fnd_message.set_token('P_SOURCE_ID', l_c_null_userid.source_id);
4110: fnd_file.put_line(fnd_file.log, fnd_message.get);
4111: FOR i IN 1..l_msg_count
4112: LOOP
4113: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,

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

4106: IF ( l_return_status <> fnd_api.g_ret_sts_success)
4107: THEN
4108: fnd_message.set_name('JTF', 'JTF_RS_CONC_UPDATE_USERID_ERR');
4109: fnd_message.set_token('P_SOURCE_ID', l_c_null_userid.source_id);
4110: fnd_file.put_line(fnd_file.log, fnd_message.get);
4111: FOR i IN 1..l_msg_count
4112: LOOP
4113: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
4114: p_encoded => fnd_api.g_false)));