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);
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
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;
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;
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;
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:
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);
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
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;
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;
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;
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:
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);
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
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;
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;
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;
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: /*
1193:
1194: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
1195: IF FND_API.To_boolean(P_INIT_MSG_LIST)
1196: THEN
1197: FND_MSG_PUB.Initialize;
1198: END IF;
1199:
1200: l_date := sysdate;
1201: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
1716: THEN
1717: COMMIT WORK;
1718: END IF;
1719:
1720: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1721:
1722:
1723: EXCEPTION
1724: WHEN fnd_api.g_exc_unexpected_error
1725: THEN
1726: ROLLBACK TO resource_extn_audit;
1727: x_return_status := fnd_api.g_ret_sts_unexp_error;
1728: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
1729: FND_MSG_PUB.add;
1730: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1731: WHEN OTHERS
1732: THEN
1733: ROLLBACK TO resource_extn_audit;
1726: ROLLBACK TO resource_extn_audit;
1727: x_return_status := fnd_api.g_ret_sts_unexp_error;
1728: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
1729: FND_MSG_PUB.add;
1730: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1731: WHEN OTHERS
1732: THEN
1733: ROLLBACK TO resource_extn_audit;
1734: x_return_status := fnd_api.g_ret_sts_unexp_error;
1732: THEN
1733: ROLLBACK TO resource_extn_audit;
1734: x_return_status := fnd_api.g_ret_sts_unexp_error;
1735: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
1736: FND_MSG_PUB.add;
1737: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1738:
1739:
1740: END UPDATE_RESOURCE;
1733: ROLLBACK TO resource_extn_audit;
1734: x_return_status := fnd_api.g_ret_sts_unexp_error;
1735: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
1736: FND_MSG_PUB.add;
1737: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1738:
1739:
1740: END UPDATE_RESOURCE;
1741:
1909:
1910: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
1911: IF FND_API.To_boolean(P_INIT_MSG_LIST)
1912: THEN
1913: FND_MSG_PUB.Initialize;
1914: END IF;
1915:
1916: l_date := sysdate;
1917: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);
2125: THEN
2126: COMMIT WORK;
2127: END IF;
2128:
2129: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2130:
2131:
2132: EXCEPTION
2133: WHEN fnd_api.g_exc_unexpected_error
2134: THEN
2135: ROLLBACK TO resource_extn_audit;
2136: x_return_status := fnd_api.g_ret_sts_unexp_error;
2137: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
2138: FND_MSG_PUB.add;
2139: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2140: WHEN OTHERS
2141: THEN
2142: ROLLBACK TO resource_extn_audit;
2135: ROLLBACK TO resource_extn_audit;
2136: x_return_status := fnd_api.g_ret_sts_unexp_error;
2137: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
2138: FND_MSG_PUB.add;
2139: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2140: WHEN OTHERS
2141: THEN
2142: ROLLBACK TO resource_extn_audit;
2143: x_return_status := fnd_api.g_ret_sts_unexp_error;
2141: THEN
2142: ROLLBACK TO resource_extn_audit;
2143: x_return_status := fnd_api.g_ret_sts_unexp_error;
2144: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
2145: FND_MSG_PUB.add;
2146: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2147:
2148:
2149: END DELETE_RESOURCE;
2142: ROLLBACK TO resource_extn_audit;
2143: x_return_status := fnd_api.g_ret_sts_unexp_error;
2144: fnd_message.set_name ('JTF', 'JTF_RS_RES_AUD_AUD_ERR');
2145: FND_MSG_PUB.add;
2146: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2147:
2148:
2149: END DELETE_RESOURCE;
2150: END; -- Package Body JTF_RS_RESOURCE_EXTNS_AUD_PVT