DBA Data[Home] [Help]

APPS.JTF_RS_CONC_RES_PUB dependencies on FND_MSG_PUB

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

218: WHEN fnd_api.g_exc_unexpected_error
219: THEN
220: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
221: ROLLBACK TO CONC_EMPLOYEE_SP;
222: --FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
223: WHEN OTHERS
224: THEN
225: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
226: --ROLLBACK TO CONC_EMPLOYEE_SP;

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

223: WHEN OTHERS
224: THEN
225: fnd_file.put_line(fnd_file.log, sqlcode||':'||sqlerrm);
226: --ROLLBACK TO CONC_EMPLOYEE_SP;
227: --FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
228:
229: END synchronize_employee;
230:
231:

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

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)));
711: END LOOP;
712: fnd_msg_pub.delete_msg;
713: fnd_file.new_line(fnd_file.log,1);

Line 712: fnd_msg_pub.delete_msg;

708: LOOP
709: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
710: p_encoded => fnd_api.g_false)));
711: END LOOP;
712: fnd_msg_pub.delete_msg;
713: fnd_file.new_line(fnd_file.log,1);
714: raise fnd_api.g_exc_error;
715: END IF;
716:

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

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

Line 796: fnd_msg_pub.delete_msg;

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;
796: fnd_msg_pub.delete_msg;
797: fnd_file.new_line(fnd_file.log,1);
798: raise fnd_api.g_exc_error;
799: END IF;
800: l_salesrep_extsts := 'Y';

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

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

Line 847: fnd_msg_pub.delete_msg;

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;
847: fnd_msg_pub.delete_msg;
848: fnd_file.new_line(fnd_file.log,1);
849: raise fnd_api.g_exc_error;
850: END IF;
851: end if; -- End of Check for Sales Comp Roles

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

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)));
1044: END LOOP;
1045: fnd_msg_pub.delete_msg;
1046: fnd_file.new_line(fnd_file.log,1);

Line 1045: fnd_msg_pub.delete_msg;

1041: LOOP
1042: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
1043: p_encoded => fnd_api.g_false)));
1044: END LOOP;
1045: fnd_msg_pub.delete_msg;
1046: fnd_file.new_line(fnd_file.log,1);
1047: raise fnd_api.g_exc_error;
1048: END IF;
1049:

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

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

Line 1114: fnd_msg_pub.delete_msg;

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;
1114: fnd_msg_pub.delete_msg;
1115: fnd_file.new_line(fnd_file.log,1);
1116: raise fnd_api.g_exc_error;
1117: END IF;
1118: l_salesrep_extsts := 'Y';

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

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

Line 1167: fnd_msg_pub.delete_msg;

1163: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,
1164: p_encoded => fnd_api.g_false)));
1165: END LOOP;
1166:
1167: fnd_msg_pub.delete_msg;
1168: fnd_file.new_line(fnd_file.log,1);
1169: raise fnd_api.g_exc_error;
1170: END IF;
1171: end if; -- End of Check for Sales Comp Roles

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

1202:
1203: END LOOP; -- fetch employee cursor end
1204:
1205:
1206: FND_MSG_PUB.count_and_get (p_count => l_msg_count, p_data => l_msg_data);
1207:
1208: EXCEPTION
1209: WHEN fnd_api.g_exc_error
1210: THEN

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

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

Line 1408: fnd_msg_pub.delete_msg;

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;
1408: fnd_msg_pub.delete_msg;
1409: fnd_file.new_line(fnd_file.log,1);
1410: raise fnd_api.g_exc_error;
1411: END IF;
1412:

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

1431: END;
1432:
1433: end loop; -- end of term_emp_cur
1434:
1435: FND_MSG_PUB.count_and_get (p_count => l_msg_count, p_data => l_msg_data);
1436:
1437: EXCEPTION
1438: WHEN fnd_api.g_exc_error
1439: THEN

Line 1911: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,p_encoded => fnd_api.g_false)));

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;
1914: -- CLOSE c_job_id;
1915: fnd_msg_pub.delete_msg;

Line 1915: fnd_msg_pub.delete_msg;

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;
1914: -- CLOSE c_job_id;
1915: fnd_msg_pub.delete_msg;
1916: fnd_file.new_line(fnd_file.log,1);
1917: raise fnd_api.g_exc_error;
1918: END IF;
1919: END IF;

Line 1971: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(j,p_encoded => fnd_api.g_false)));

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

Line 1973: fnd_msg_pub.delete_msg;

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;
1974: fnd_file.new_line(fnd_file.log,1);
1975: raise fnd_api.g_exc_error;
1976: END IF;
1977: END LOOP;

Line 2028: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,p_encoded => fnd_api.g_false)));

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

Line 2030: fnd_msg_pub.delete_msg;

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;
2031: fnd_file.new_line(fnd_file.log,1);
2032: raise fnd_api.g_exc_error;
2033: END IF;
2034: end if; -- Check for Sales Comp Roles and salesrep exists

Line 2084: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(j,p_encoded => fnd_api.g_false)));

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

Line 2086: fnd_msg_pub.delete_msg;

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;
2087: fnd_file.new_line(fnd_file.log,1);
2088: raise fnd_api.g_exc_error;
2089: END IF;
2090: END LOOP;

Line 2141: fnd_file.put_line(fnd_file.log, (fnd_msg_pub.get(i,p_encoded => fnd_api.g_false)));

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

Line 2143: fnd_msg_pub.delete_msg;

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;
2144: fnd_file.new_line(fnd_file.log,1);
2145: raise fnd_api.g_exc_error;
2146: END IF;
2147: end if; -- Check for Sales Comp Roles and salesrep exists

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

3266: END IF;
3267:
3268: END LOOP; -- end of term_part_cur
3269:
3270: FND_MSG_PUB.count_and_get (p_count => l_msg_count, p_data => l_msg_data);
3271:
3272: EXCEPTION
3273: WHEN fnd_api.g_exc_error
3274: THEN

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

3765: END IF;
3766:
3767: END LOOP; -- end of term_part_cur
3768:
3769: FND_MSG_PUB.count_and_get (p_count => l_msg_count, p_data => l_msg_data);
3770:
3771: EXCEPTION
3772: WHEN fnd_api.g_exc_error
3773: THEN

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

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)));
4006: END LOOP;
4007: END IF;
4008:

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

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)));
4061: END LOOP;
4062: END IF;
4063:

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

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)));
4115: END LOOP;
4116: END IF;
4117:

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

4122: l_count := 1;
4123: END IF;
4124: END LOOP;
4125:
4126: FND_MSG_PUB.count_and_get (p_count => l_msg_count, p_data => l_msg_data);
4127: COMMIT;
4128:
4129: EXCEPTION
4130: WHEN fnd_api.g_exc_unexpected_error