DBA Data[Home] [Help]

APPS.JTF_RS_RESOURCE_EXTNS_AUD_PVT dependencies on FND_MSG_PUB

Line 77: FND_MSG_PUB.Initialize;

73:
74: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
75: IF FND_API.To_boolean(P_INIT_MSG_LIST)
76: THEN
77: FND_MSG_PUB.Initialize;
78: END IF;
79:
80: l_date := sysdate;
81: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

Line 164: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

160: THEN
161: COMMIT WORK;
162: END IF;
163:
164: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
165:
166:
167: EXCEPTION
168: WHEN fnd_api.g_exc_unexpected_error

Line 173: FND_MSG_PUB.add;

169: THEN
170: ROLLBACK TO resource_extn_audit;
171: x_return_status := fnd_api.g_ret_sts_unexp_error;
172: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
173: FND_MSG_PUB.add;
174: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
175: WHEN OTHERS
176: THEN
177: ROLLBACK TO resource_extn_audit;

Line 174: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

170: ROLLBACK TO resource_extn_audit;
171: x_return_status := fnd_api.g_ret_sts_unexp_error;
172: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
173: FND_MSG_PUB.add;
174: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
175: WHEN OTHERS
176: THEN
177: ROLLBACK TO resource_extn_audit;
178: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 180: FND_MSG_PUB.add;

176: THEN
177: ROLLBACK TO resource_extn_audit;
178: x_return_status := fnd_api.g_ret_sts_unexp_error;
179: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
180: FND_MSG_PUB.add;
181: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
182:
183:
184: END INSERT_RESOURCE;

Line 181: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

177: ROLLBACK TO resource_extn_audit;
178: x_return_status := fnd_api.g_ret_sts_unexp_error;
179: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
180: FND_MSG_PUB.add;
181: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
182:
183:
184: END INSERT_RESOURCE;
185:

Line 286: FND_MSG_PUB.Initialize;

282:
283: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
284: IF FND_API.To_boolean(P_INIT_MSG_LIST)
285: THEN
286: FND_MSG_PUB.Initialize;
287: END IF;
288:
289: l_date := sysdate;
290: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

Line 441: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

437: THEN
438: COMMIT WORK;
439: END IF;
440:
441: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
442:
443:
444: EXCEPTION
445: WHEN fnd_api.g_exc_unexpected_error

Line 450: FND_MSG_PUB.add;

446: THEN
447: ROLLBACK TO resource_extn_audit;
448: x_return_status := fnd_api.g_ret_sts_unexp_error;
449: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
450: FND_MSG_PUB.add;
451: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
452: WHEN OTHERS
453: THEN
454: ROLLBACK TO resource_extn_audit;

Line 451: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

447: ROLLBACK TO resource_extn_audit;
448: x_return_status := fnd_api.g_ret_sts_unexp_error;
449: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
450: FND_MSG_PUB.add;
451: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
452: WHEN OTHERS
453: THEN
454: ROLLBACK TO resource_extn_audit;
455: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 457: FND_MSG_PUB.add;

453: THEN
454: ROLLBACK TO resource_extn_audit;
455: x_return_status := fnd_api.g_ret_sts_unexp_error;
456: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
457: FND_MSG_PUB.add;
458: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
459:
460:
461: END INSERT_RESOURCE;

Line 458: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

454: ROLLBACK TO resource_extn_audit;
455: x_return_status := fnd_api.g_ret_sts_unexp_error;
456: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
457: FND_MSG_PUB.add;
458: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
459:
460:
461: END INSERT_RESOURCE;
462:

Line 628: FND_MSG_PUB.Initialize;

624:
625: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
626: IF FND_API.To_boolean(P_INIT_MSG_LIST)
627: THEN
628: FND_MSG_PUB.Initialize;
629: END IF;
630:
631: l_date := sysdate;
632: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

Line 864: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

860: THEN
861: COMMIT WORK;
862: END IF;
863:
864: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
865:
866:
867: EXCEPTION
868: WHEN fnd_api.g_exc_unexpected_error

Line 873: FND_MSG_PUB.add;

869: THEN
870: ROLLBACK TO resource_extn_audit;
871: x_return_status := fnd_api.g_ret_sts_unexp_error;
872: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
873: FND_MSG_PUB.add;
874: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
875: WHEN OTHERS
876: THEN
877: ROLLBACK TO resource_extn_audit;

Line 874: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

870: ROLLBACK TO resource_extn_audit;
871: x_return_status := fnd_api.g_ret_sts_unexp_error;
872: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
873: FND_MSG_PUB.add;
874: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
875: WHEN OTHERS
876: THEN
877: ROLLBACK TO resource_extn_audit;
878: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 880: FND_MSG_PUB.add;

876: THEN
877: ROLLBACK TO resource_extn_audit;
878: x_return_status := fnd_api.g_ret_sts_unexp_error;
879: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
880: FND_MSG_PUB.add;
881: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
882:
883:
884: END UPDATE_RESOURCE;

Line 881: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

877: ROLLBACK TO resource_extn_audit;
878: x_return_status := fnd_api.g_ret_sts_unexp_error;
879: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
880: FND_MSG_PUB.add;
881: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
882:
883:
884: END UPDATE_RESOURCE;
885:

Line 1189: FND_MSG_PUB.Initialize;

1185:
1186: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
1187: IF FND_API.To_boolean(P_INIT_MSG_LIST)
1188: THEN
1189: FND_MSG_PUB.Initialize;
1190: END IF;
1191:
1192: l_date := sysdate;
1193: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

Line 1706: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1702: THEN
1703: COMMIT WORK;
1704: END IF;
1705:
1706: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1707:
1708:
1709: EXCEPTION
1710: WHEN fnd_api.g_exc_unexpected_error

Line 1715: FND_MSG_PUB.add;

1711: THEN
1712: ROLLBACK TO resource_extn_audit;
1713: x_return_status := fnd_api.g_ret_sts_unexp_error;
1714: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
1715: FND_MSG_PUB.add;
1716: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1717: WHEN OTHERS
1718: THEN
1719: ROLLBACK TO resource_extn_audit;

Line 1716: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1712: ROLLBACK TO resource_extn_audit;
1713: x_return_status := fnd_api.g_ret_sts_unexp_error;
1714: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
1715: FND_MSG_PUB.add;
1716: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1717: WHEN OTHERS
1718: THEN
1719: ROLLBACK TO resource_extn_audit;
1720: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1722: FND_MSG_PUB.add;

1718: THEN
1719: ROLLBACK TO resource_extn_audit;
1720: x_return_status := fnd_api.g_ret_sts_unexp_error;
1721: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
1722: FND_MSG_PUB.add;
1723: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1724:
1725:
1726: END UPDATE_RESOURCE;

Line 1723: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1719: ROLLBACK TO resource_extn_audit;
1720: x_return_status := fnd_api.g_ret_sts_unexp_error;
1721: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
1722: FND_MSG_PUB.add;
1723: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1724:
1725:
1726: END UPDATE_RESOURCE;
1727:

Line 1899: FND_MSG_PUB.Initialize;

1895:
1896: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
1897: IF FND_API.To_boolean(P_INIT_MSG_LIST)
1898: THEN
1899: FND_MSG_PUB.Initialize;
1900: END IF;
1901:
1902: l_date := sysdate;
1903: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

Line 2115: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

2111: THEN
2112: COMMIT WORK;
2113: END IF;
2114:
2115: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2116:
2117:
2118: EXCEPTION
2119: WHEN fnd_api.g_exc_unexpected_error

Line 2124: FND_MSG_PUB.add;

2120: THEN
2121: ROLLBACK TO resource_extn_audit;
2122: x_return_status := fnd_api.g_ret_sts_unexp_error;
2123: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
2124: FND_MSG_PUB.add;
2125: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2126: WHEN OTHERS
2127: THEN
2128: ROLLBACK TO resource_extn_audit;

Line 2125: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

2121: ROLLBACK TO resource_extn_audit;
2122: x_return_status := fnd_api.g_ret_sts_unexp_error;
2123: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
2124: FND_MSG_PUB.add;
2125: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2126: WHEN OTHERS
2127: THEN
2128: ROLLBACK TO resource_extn_audit;
2129: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2131: FND_MSG_PUB.add;

2127: THEN
2128: ROLLBACK TO resource_extn_audit;
2129: x_return_status := fnd_api.g_ret_sts_unexp_error;
2130: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
2131: FND_MSG_PUB.add;
2132: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2133:
2134:
2135: END DELETE_RESOURCE;

Line 2132: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

2128: ROLLBACK TO resource_extn_audit;
2129: x_return_status := fnd_api.g_ret_sts_unexp_error;
2130: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
2131: FND_MSG_PUB.add;
2132: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2133:
2134:
2135: END DELETE_RESOURCE;
2136: END; -- Package Body JTF_RS_RESOURCE_EXTNS_AUD_PVT