DBA Data[Home] [Help]

APPS.JTF_RS_CONC_RES_PUB dependencies on FND_MSG_PUB

Line 280: --FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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
283: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
284: --ROLLBACK TO CONC_EMPLOYEE_SP;

Line 285: --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;
288:
289:

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

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);
772: raise fnd_api.g_exc_error;
773: END IF;
774:

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

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);
856: raise fnd_api.g_exc_error;
857: END IF;
858: l_salesrep_extsts := 'Y';

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

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);
907: raise fnd_api.g_exc_error;
908: END IF;
909: end if; -- End of Check for Sales Comp Roles

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

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);
1105: raise fnd_api.g_exc_error;
1106: END IF;
1107:

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

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);
1174: raise fnd_api.g_exc_error;
1175: END IF;
1176: l_salesrep_extsts := 'Y';

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

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

Line 1264: FND_MSG_PUB.count_and_get (p_count => l_msg_count, p_data => l_msg_data);

1260:
1261: END LOOP; -- fetch employee cursor end
1262:
1263:
1264: FND_MSG_PUB.count_and_get (p_count => l_msg_count, p_data => l_msg_data);
1265:
1266: EXCEPTION
1267: WHEN fnd_api.g_exc_error
1268: THEN

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

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);
1468: raise fnd_api.g_exc_error;
1469: END IF;
1470:

Line 1493: FND_MSG_PUB.count_and_get (p_count => l_msg_count, p_data => l_msg_data);

1489: END;
1490:
1491: end loop; -- end of term_emp_cur
1492:
1493: FND_MSG_PUB.count_and_get (p_count => l_msg_count, p_data => l_msg_data);
1494:
1495: EXCEPTION
1496: WHEN fnd_api.g_exc_error
1497: THEN

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

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

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

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

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

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;
2277: ELSE -- r_return_status is success
2278: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

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;
2370: ELSE --r_return_status is success
2371: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

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

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

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;
2562: ELSE
2563: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3721: FND_MSG_PUB.count_and_get (p_count => l_msg_count, p_data => l_msg_data);

3717: END IF;
3718:
3719: END LOOP; -- end of term_part_cur
3720:
3721: FND_MSG_PUB.count_and_get (p_count => l_msg_count, p_data => l_msg_data);
3722:
3723: EXCEPTION
3724: WHEN fnd_api.g_exc_error
3725: THEN

Line 4218: FND_MSG_PUB.count_and_get (p_count => l_msg_count, p_data => l_msg_data);

4214: END IF;
4215:
4216: END LOOP; -- end of term_part_cur
4217:
4218: FND_MSG_PUB.count_and_get (p_count => l_msg_count, p_data => l_msg_data);
4219:
4220: EXCEPTION
4221: WHEN fnd_api.g_exc_error
4222: THEN

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 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 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 4575: FND_MSG_PUB.count_and_get (p_count => l_msg_count, p_data => l_msg_data);

4571: l_count := 1;
4572: END IF;
4573: END LOOP;
4574:
4575: FND_MSG_PUB.count_and_get (p_count => l_msg_count, p_data => l_msg_data);
4576: COMMIT;
4577:
4578: EXCEPTION
4579: WHEN fnd_api.g_exc_unexpected_error