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_FILE

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 227: fnd_file.new_line(fnd_file.log,1);

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
231: fnd_message.set_name('JTF', 'JTF_RS_PROF_SRP_NUM_CONC_ERR');

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 234: fnd_file.new_line(fnd_file.log,1);

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;
238: END IF;

Line 274: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

270:
271: EXCEPTION
272: WHEN fnd_api.g_exc_error
273: THEN
274: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
275: ROLLBACK TO CONC_EMPLOYEE_SP;
276: WHEN fnd_api.g_exc_unexpected_error
277: THEN
278: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

Line 278: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

274: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
275: ROLLBACK TO CONC_EMPLOYEE_SP;
276: WHEN fnd_api.g_exc_unexpected_error
277: THEN
278: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
279: ROLLBACK TO CONC_EMPLOYEE_SP;
280: --FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
281: WHEN OTHERS
282: THEN

Line 283: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

279: ROLLBACK TO CONC_EMPLOYEE_SP;
280: --FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
281: WHEN OTHERS
282: THEN
283: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
284: --ROLLBACK TO CONC_EMPLOYEE_SP;
285: --FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
286:
287: END synchronize_employee;

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 767: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,

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)));
769: END LOOP;
770: fnd_msg_pub.delete_msg;
771: fnd_file.new_line(fnd_file.log,1);

Line 771: fnd_file.new_line(fnd_file.log,1);

767: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
768: p_encoded => fnd_api.g_false)));
769: END LOOP;
770: fnd_msg_pub.delete_msg;
771: fnd_file.new_line(fnd_file.log,1);
772: raise fnd_api.g_exc_error;
773: END IF;
774:
775: -- Code added by repuri (04/09/03) for Enh/Bug # 2828368

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 851: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,

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;
854: fnd_msg_pub.delete_msg;
855: fnd_file.new_line(fnd_file.log,1);

Line 855: fnd_file.new_line(fnd_file.log,1);

851: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
852: p_encoded => fnd_api.g_false)));
853: END LOOP;
854: fnd_msg_pub.delete_msg;
855: fnd_file.new_line(fnd_file.log,1);
856: raise fnd_api.g_exc_error;
857: END IF;
858: l_salesrep_extsts := 'Y';
859: END IF;

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 902: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,

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;
905: fnd_msg_pub.delete_msg;
906: fnd_file.new_line(fnd_file.log,1);

Line 906: fnd_file.new_line(fnd_file.log,1);

902: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
903: p_encoded => fnd_api.g_false)));
904: END LOOP;
905: fnd_msg_pub.delete_msg;
906: fnd_file.new_line(fnd_file.log,1);
907: raise fnd_api.g_exc_error;
908: END IF;
909: end if; -- End of Check for Sales Comp Roles
910: END LOOP;

Line 925: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);

921:
922: EXCEPTION
923: WHEN fnd_api.g_exc_error
924: THEN
925: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
926: ROLLBACK TO create_resource_sp;
927: WHEN fnd_api.g_exc_unexpected_error
928: THEN
929: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);

Line 929: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);

925: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
926: ROLLBACK TO create_resource_sp;
927: WHEN fnd_api.g_exc_unexpected_error
928: THEN
929: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
930: ROLLBACK TO create_resource_sp;
931: WHEN OTHERS
932: THEN
933: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);

Line 933: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);

929: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
930: ROLLBACK TO create_resource_sp;
931: WHEN OTHERS
932: THEN
933: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
934: ROLLBACK TO create_resource_sp;
935:
936: END;
937:

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 1100: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,

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)));
1102: END LOOP;
1103: fnd_msg_pub.delete_msg;
1104: fnd_file.new_line(fnd_file.log,1);

Line 1104: fnd_file.new_line(fnd_file.log,1);

1100: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
1101: p_encoded => fnd_api.g_false)));
1102: END LOOP;
1103: fnd_msg_pub.delete_msg;
1104: fnd_file.new_line(fnd_file.log,1);
1105: raise fnd_api.g_exc_error;
1106: END IF;
1107:
1108: -- Code added by repuri (04/09/03) for Enh/Bug # 2828368

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 1169: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,

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;
1172: fnd_msg_pub.delete_msg;
1173: fnd_file.new_line(fnd_file.log,1);

Line 1173: fnd_file.new_line(fnd_file.log,1);

1169: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
1170: p_encoded => fnd_api.g_false)));
1171: END LOOP;
1172: fnd_msg_pub.delete_msg;
1173: fnd_file.new_line(fnd_file.log,1);
1174: raise fnd_api.g_exc_error;
1175: END IF;
1176: l_salesrep_extsts := 'Y';
1177: END IF;

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 1221: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,

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;
1224:
1225: fnd_msg_pub.delete_msg;

Line 1226: fnd_file.new_line(fnd_file.log,1);

1222: p_encoded => fnd_api.g_false)));
1223: END LOOP;
1224:
1225: fnd_msg_pub.delete_msg;
1226: fnd_file.new_line(fnd_file.log,1);
1227: raise fnd_api.g_exc_error;
1228: END IF;
1229: end if; -- End of Check for Sales Comp Roles
1230: END LOOP;

Line 1245: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);

1241:
1242: EXCEPTION
1243: WHEN fnd_api.g_exc_error
1244: THEN
1245: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
1246: ROLLBACK TO create_resource_sp;
1247: WHEN fnd_api.g_exc_unexpected_error
1248: THEN
1249: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);

Line 1249: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);

1245: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
1246: ROLLBACK TO create_resource_sp;
1247: WHEN fnd_api.g_exc_unexpected_error
1248: THEN
1249: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
1250: ROLLBACK TO create_resource_sp;
1251: WHEN OTHERS
1252: THEN
1253: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);

Line 1253: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);

1249: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
1250: ROLLBACK TO create_resource_sp;
1251: WHEN OTHERS
1252: THEN
1253: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
1254: ROLLBACK TO create_resource_sp;
1255:
1256: END;
1257:

Line 1269: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

1265:
1266: EXCEPTION
1267: WHEN fnd_api.g_exc_error
1268: THEN
1269: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
1270: ROLLBACK TO CREATE_EMPLOYEE_SP;
1271: WHEN fnd_api.g_exc_unexpected_error
1272: THEN
1273: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

Line 1273: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

1269: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
1270: ROLLBACK TO CREATE_EMPLOYEE_SP;
1271: WHEN fnd_api.g_exc_unexpected_error
1272: THEN
1273: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
1274: ROLLBACK TO CREATE_EMPLOYEE_SP;
1275: WHEN OTHERS
1276: THEN
1277: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

Line 1277: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

1273: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
1274: ROLLBACK TO CREATE_EMPLOYEE_SP;
1275: WHEN OTHERS
1276: THEN
1277: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
1278: ROLLBACK TO CREATE_EMPLOYEE_SP;
1279: fnd_file.put_line(fnd_file.log, sqlerrm);
1280:
1281: END create_employee;

Line 1279: fnd_file.put_line(fnd_file.log, sqlerrm);

1275: WHEN OTHERS
1276: THEN
1277: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
1278: ROLLBACK TO CREATE_EMPLOYEE_SP;
1279: fnd_file.put_line(fnd_file.log, sqlerrm);
1280:
1281: END create_employee;
1282:
1283:

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 1463: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,

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;
1466: fnd_msg_pub.delete_msg;
1467: fnd_file.new_line(fnd_file.log,1);

Line 1467: fnd_file.new_line(fnd_file.log,1);

1463: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
1464: p_encoded => fnd_api.g_false)));
1465: END LOOP;
1466: fnd_msg_pub.delete_msg;
1467: fnd_file.new_line(fnd_file.log,1);
1468: raise fnd_api.g_exc_error;
1469: END IF;
1470:
1471: -------------------------------------------------------------------------------

Line 1481: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);

1477: end if;
1478:
1479: EXCEPTION
1480: WHEN fnd_api.g_exc_error THEN
1481: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
1482: ROLLBACK TO TERMINATE_EMPLOYEE_IN_SP;
1483: WHEN fnd_api.g_exc_unexpected_error THEN
1484: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
1485: ROLLBACK TO TERMINATE_EMPLOYEE_IN_SP;

Line 1484: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);

1480: WHEN fnd_api.g_exc_error THEN
1481: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
1482: ROLLBACK TO TERMINATE_EMPLOYEE_IN_SP;
1483: WHEN fnd_api.g_exc_unexpected_error THEN
1484: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
1485: ROLLBACK TO TERMINATE_EMPLOYEE_IN_SP;
1486: WHEN OTHERS THEN
1487: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
1488: ROLLBACK TO TERMINATE_EMPLOYEE_IN_SP;

Line 1487: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);

1483: WHEN fnd_api.g_exc_unexpected_error THEN
1484: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
1485: ROLLBACK TO TERMINATE_EMPLOYEE_IN_SP;
1486: WHEN OTHERS THEN
1487: fnd_file.put_line(fnd_file.log, SQLCODE||':'||SQLERRM);
1488: ROLLBACK TO TERMINATE_EMPLOYEE_IN_SP;
1489: END;
1490:
1491: end loop; -- end of term_emp_cur

Line 1498: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

1494:
1495: EXCEPTION
1496: WHEN fnd_api.g_exc_error
1497: THEN
1498: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
1499: ROLLBACK TO TERMINATE_EMPLOYEE_SP;
1500: WHEN OTHERS
1501: THEN
1502: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

Line 1502: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

1498: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
1499: ROLLBACK TO TERMINATE_EMPLOYEE_SP;
1500: WHEN OTHERS
1501: THEN
1502: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
1503: ROLLBACK TO TERMINATE_EMPLOYEE_SP;
1504: -- fnd_file.put_line(fnd_file.log, sqlerrm);
1505:
1506: END terminate_employee;

Line 1504: -- fnd_file.put_line(fnd_file.log, sqlerrm);

1500: WHEN OTHERS
1501: THEN
1502: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
1503: ROLLBACK TO TERMINATE_EMPLOYEE_SP;
1504: -- fnd_file.put_line(fnd_file.log, sqlerrm);
1505:
1506: END terminate_employee;
1507:
1508:

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 2113: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,p_encoded => fnd_api.g_false)));

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;
2116: -- CLOSE c_job_id;
2117: fnd_msg_pub.delete_msg;

Line 2118: fnd_file.new_line(fnd_file.log,1);

2114: end loop;
2115: CLOSE c_job_roles;
2116: -- CLOSE c_job_id;
2117: fnd_msg_pub.delete_msg;
2118: fnd_file.new_line(fnd_file.log,1);
2119: raise fnd_api.g_exc_error;
2120: ELSE -- r_return_status is success
2121: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2122: debug(p_message=>'Update role Relate is Success ',

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 2204: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(j,p_encoded => fnd_api.g_false)));

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;
2207: fnd_file.new_line(fnd_file.log,1);
2208: raise fnd_api.g_exc_error;

Line 2207: fnd_file.new_line(fnd_file.log,1);

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;
2207: fnd_file.new_line(fnd_file.log,1);
2208: raise fnd_api.g_exc_error;
2209: END IF;
2210: END IF;
2211: END IF; --c_existing_role_relations

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 2272: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(j,p_encoded => fnd_api.g_false)));

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;
2275: fnd_file.new_line(fnd_file.log,1);
2276: raise fnd_api.g_exc_error;

Line 2275: fnd_file.new_line(fnd_file.log,1);

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;
2275: fnd_file.new_line(fnd_file.log,1);
2276: raise fnd_api.g_exc_error;
2277: ELSE -- r_return_status is success
2278: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2279: debug(p_message=>'Update role Relate is Success ',

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 2365: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,p_encoded => fnd_api.g_false)));

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;
2368: fnd_file.new_line(fnd_file.log,1);
2369: raise fnd_api.g_exc_error;

Line 2368: fnd_file.new_line(fnd_file.log,1);

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;
2368: fnd_file.new_line(fnd_file.log,1);
2369: raise fnd_api.g_exc_error;
2370: ELSE --r_return_status is success
2371: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2372: debug(p_message=>'Create role Relate is Success and Role Relate Id is '||l_role_relate_id,

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 2511: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(j,p_encoded => fnd_api.g_false)));

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;
2514: fnd_file.new_line(fnd_file.log,1);
2515: raise fnd_api.g_exc_error;

Line 2514: fnd_file.new_line(fnd_file.log,1);

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;
2514: fnd_file.new_line(fnd_file.log,1);
2515: raise fnd_api.g_exc_error;
2516: END IF;
2517:
2518: --Bug13682589 End

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 2557: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,p_encoded => fnd_api.g_false)));

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;
2560: fnd_file.new_line(fnd_file.log,1);
2561: raise fnd_api.g_exc_error;

Line 2560: fnd_file.new_line(fnd_file.log,1);

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;
2560: fnd_file.new_line(fnd_file.log,1);
2561: raise fnd_api.g_exc_error;
2562: ELSE
2563: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2564: debug(p_message=>'Create role Relate is Success and Role Relate Id is '||l_role_relate_id,

Line 3067: ---fnd_file.put_line(fnd_file.log,'resource id:' || l_c_resource.resource_id);

3063: --ER # 2669284 . If any change has ben encountered, then audit that resource record and also
3064: --update the jtf_rs_resource_extns.
3065: if (l_is_to_be_updated = 'Y') then
3066:
3067: ---fnd_file.put_line(fnd_file.log,'resource id:' || l_c_resource.resource_id);
3068: select jtf_rs_resource_extn_aud_s.nextval
3069: into l_resource_extn_aud_id
3070: from dual;
3071:

Line 3310: -- fnd_file.put_line(fnd_file.log, sqlerrm);

3306:
3307: EXCEPTION
3308: WHEN fnd_api.g_exc_error
3309: THEN
3310: -- fnd_file.put_line(fnd_file.log, sqlerrm);
3311: ROLLBACK TO update_resource_sp;
3312: WHEN fnd_api.g_exc_unexpected_error
3313: THEN
3314: -- fnd_file.put_line(fnd_file.log, sqlerrm);

Line 3314: -- fnd_file.put_line(fnd_file.log, sqlerrm);

3310: -- fnd_file.put_line(fnd_file.log, sqlerrm);
3311: ROLLBACK TO update_resource_sp;
3312: WHEN fnd_api.g_exc_unexpected_error
3313: THEN
3314: -- fnd_file.put_line(fnd_file.log, sqlerrm);
3315: ROLLBACK TO update_resource_sp;
3316: WHEN OTHERS
3317: THEN
3318: fnd_file.put_line(fnd_file.log, sqlerrm);

Line 3318: fnd_file.put_line(fnd_file.log, sqlerrm);

3314: -- fnd_file.put_line(fnd_file.log, sqlerrm);
3315: ROLLBACK TO update_resource_sp;
3316: WHEN OTHERS
3317: THEN
3318: fnd_file.put_line(fnd_file.log, sqlerrm);
3319: ROLLBACK TO update_resource_sp;
3320: END;
3321:
3322: END LOOP;

Line 3344: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

3340: IF c_ppf%ISOPEN THEN
3341: CLOSE c_ppf;
3342: END IF;
3343:
3344: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
3345: ROLLBACK TO UPDATE_EMPLOYEE_SP;
3346: WHEN OTHERS
3347: THEN
3348:

Line 3365: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

3361: IF c_ppf%ISOPEN THEN
3362: CLOSE c_ppf;
3363: END IF;
3364:
3365: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
3366: ROLLBACK TO UPDATE_EMPLOYEE_SP;
3367:
3368: END update_employee;
3369:

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 3572: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

3568:
3569: EXCEPTION
3570: WHEN fnd_api.g_exc_unexpected_error
3571: THEN
3572: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
3573: WHEN OTHERS
3574: THEN
3575: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
3576: fnd_file.put_line(fnd_file.log, sqlerrm);

Line 3575: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

3571: THEN
3572: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
3573: WHEN OTHERS
3574: THEN
3575: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
3576: fnd_file.put_line(fnd_file.log, sqlerrm);
3577: END update_terminated_employee;
3578:
3579:

Line 3576: fnd_file.put_line(fnd_file.log, sqlerrm);

3572: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
3573: WHEN OTHERS
3574: THEN
3575: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
3576: fnd_file.put_line(fnd_file.log, sqlerrm);
3577: END update_terminated_employee;
3578:
3579:
3580:

Line 3602: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

3598: commit;
3599: EXCEPTION
3600: WHEN fnd_api.g_exc_unexpected_error
3601: THEN
3602: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
3603: WHEN OTHERS
3604: THEN
3605: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
3606: fnd_file.put_line(fnd_file.log, sqlerrm);

Line 3605: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

3601: THEN
3602: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
3603: WHEN OTHERS
3604: THEN
3605: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
3606: fnd_file.put_line(fnd_file.log, sqlerrm);
3607:
3608: END update_emp_phone;
3609:

Line 3606: fnd_file.put_line(fnd_file.log, sqlerrm);

3602: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
3603: WHEN OTHERS
3604: THEN
3605: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
3606: fnd_file.put_line(fnd_file.log, sqlerrm);
3607:
3608: END update_emp_phone;
3609:
3610: PROCEDURE synchronize_party

Line 3630: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

3626:
3627: EXCEPTION
3628: WHEN fnd_api.g_exc_unexpected_error
3629: THEN
3630: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
3631: WHEN OTHERS
3632: THEN
3633: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
3634:

Line 3633: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

3629: THEN
3630: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
3631: WHEN OTHERS
3632: THEN
3633: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
3634:
3635: END synchronize_party;
3636:
3637: PROCEDURE terminate_partner_rel IS

Line 3726: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

3722:
3723: EXCEPTION
3724: WHEN fnd_api.g_exc_error
3725: THEN
3726: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
3727: ROLLBACK TO TERMINATE_PARTNER_REL_SP;
3728:
3729: WHEN OTHERS
3730: THEN

Line 3731: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

3727: ROLLBACK TO TERMINATE_PARTNER_REL_SP;
3728:
3729: WHEN OTHERS
3730: THEN
3731: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
3732: ROLLBACK TO TERMINATE_PARTNER_REL_SP;
3733: fnd_file.put_line(fnd_file.log, sqlerrm);
3734:
3735: END terminate_partner_rel;

Line 3733: fnd_file.put_line(fnd_file.log, sqlerrm);

3729: WHEN OTHERS
3730: THEN
3731: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
3732: ROLLBACK TO TERMINATE_PARTNER_REL_SP;
3733: fnd_file.put_line(fnd_file.log, sqlerrm);
3734:
3735: END terminate_partner_rel;
3736:
3737:

Line 3886: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

3882: THEN
3883: null;
3884: WHEN OTHERS
3885: THEN
3886: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
3887: fnd_file.put_line(fnd_file.log, sqlerrm);
3888: END;
3889:
3890:

Line 3887: fnd_file.put_line(fnd_file.log, sqlerrm);

3883: null;
3884: WHEN OTHERS
3885: THEN
3886: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
3887: fnd_file.put_line(fnd_file.log, sqlerrm);
3888: END;
3889:
3890:
3891:

Line 3917: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

3913: THEN
3914: null;
3915: WHEN OTHERS
3916: THEN
3917: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
3918: fnd_file.put_line(fnd_file.log, sqlerrm);
3919:
3920: END;
3921:

Line 3918: fnd_file.put_line(fnd_file.log, sqlerrm);

3914: null;
3915: WHEN OTHERS
3916: THEN
3917: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
3918: fnd_file.put_line(fnd_file.log, sqlerrm);
3919:
3920: END;
3921:
3922: for r_res in c_res

Line 3988: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

3984:
3985: EXCEPTION
3986: WHEN OTHERS
3987: THEN
3988: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
3989: fnd_file.put_line(fnd_file.log, sqlerrm);
3990:
3991: END update_party;
3992:

Line 3989: fnd_file.put_line(fnd_file.log, sqlerrm);

3985: EXCEPTION
3986: WHEN OTHERS
3987: THEN
3988: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
3989: fnd_file.put_line(fnd_file.log, sqlerrm);
3990:
3991: END update_party;
3992:
3993:

Line 4014: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

4010:
4011: EXCEPTION
4012: WHEN fnd_api.g_exc_unexpected_error
4013: THEN
4014: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
4015: WHEN OTHERS
4016: THEN
4017: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
4018: END synchronize_supp_contact;

Line 4017: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

4013: THEN
4014: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
4015: WHEN OTHERS
4016: THEN
4017: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
4018: END synchronize_supp_contact;
4019:
4020:
4021: PROCEDURE update_supp_contact

Line 4150: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

4146:
4147: EXCEPTION
4148: WHEN fnd_api.g_exc_unexpected_error
4149: THEN
4150: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
4151: WHEN OTHERS
4152: THEN
4153: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
4154: end update_supp_contact;

Line 4153: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

4149: THEN
4150: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
4151: WHEN OTHERS
4152: THEN
4153: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
4154: end update_supp_contact;
4155:
4156:
4157: PROCEDURE terminate_supplier_contact IS

Line 4223: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

4219:
4220: EXCEPTION
4221: WHEN fnd_api.g_exc_error
4222: THEN
4223: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
4224: ROLLBACK TO TERMINATE_SUPPLIER_CONTACT_SP;
4225:
4226: WHEN OTHERS
4227: THEN

Line 4228: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

4224: ROLLBACK TO TERMINATE_SUPPLIER_CONTACT_SP;
4225:
4226: WHEN OTHERS
4227: THEN
4228: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
4229: ROLLBACK TO TERMINATE_SUPPLIER_CONTACT_SP;
4230: fnd_file.put_line(fnd_file.log, sqlerrm);
4231:
4232: END terminate_supplier_contact;

Line 4230: fnd_file.put_line(fnd_file.log, sqlerrm);

4226: WHEN OTHERS
4227: THEN
4228: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
4229: ROLLBACK TO TERMINATE_SUPPLIER_CONTACT_SP;
4230: fnd_file.put_line(fnd_file.log, sqlerrm);
4231:
4232: END terminate_supplier_contact;
4233:
4234:

Line 4247: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

4243: COMMIT;
4244: EXCEPTION
4245: WHEN fnd_api.g_exc_unexpected_error
4246: THEN
4247: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
4248: WHEN OTHERS
4249: THEN
4250: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
4251: fnd_file.put_line(fnd_file.log, sqlerrm);

Line 4250: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

4246: THEN
4247: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
4248: WHEN OTHERS
4249: THEN
4250: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
4251: fnd_file.put_line(fnd_file.log, sqlerrm);
4252: END update_username;
4253:
4254:

Line 4251: fnd_file.put_line(fnd_file.log, sqlerrm);

4247: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
4248: WHEN OTHERS
4249: THEN
4250: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
4251: fnd_file.put_line(fnd_file.log, sqlerrm);
4252: END update_username;
4253:
4254:
4255: PROCEDURE update_userid

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 4453: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,

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)));
4455: END LOOP;
4456: END IF;
4457:

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 4508: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,

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)));
4510: END LOOP;
4511: END IF;
4512:

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

Line 4562: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,

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)));
4564: END LOOP;
4565: END IF;
4566:

Line 4581: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

4577:
4578: EXCEPTION
4579: WHEN fnd_api.g_exc_unexpected_error
4580: THEN
4581: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
4582: ROLLBACK TO UPDATE_USERID_SP;
4583: WHEN OTHERS
4584: THEN
4585: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

Line 4585: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

4581: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
4582: ROLLBACK TO UPDATE_USERID_SP;
4583: WHEN OTHERS
4584: THEN
4585: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
4586: ROLLBACK TO UPDATE_USERID_SP;
4587: fnd_file.put_line(fnd_file.log, sqlerrm);
4588: END update_userid;
4589:

Line 4587: fnd_file.put_line(fnd_file.log, sqlerrm);

4583: WHEN OTHERS
4584: THEN
4585: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
4586: ROLLBACK TO UPDATE_USERID_SP;
4587: fnd_file.put_line(fnd_file.log, sqlerrm);
4588: END update_userid;
4589:
4590:
4591: PROCEDURE synchronize_user_name

Line 4613: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

4609: COMMIT;
4610: EXCEPTION
4611: WHEN fnd_api.g_exc_unexpected_error
4612: THEN
4613: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
4614: WHEN OTHERS
4615: THEN
4616: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
4617: END synchronize_user_name;

Line 4616: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);

4612: THEN
4613: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
4614: WHEN OTHERS
4615: THEN
4616: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
4617: END synchronize_user_name;
4618:
4619: END jtf_rs_conc_res_pub;