57: FROM JTF_IH_OUTCOMES_TL
58: WHERE OUTCOME_ID = l_outcome_id;
59:
60: BEGIN
61: -- Standard start of API savepoint
62: SAVEPOINT INSERT_OUTCOME_PVT;
63:
64: -- Standard call to check for call compatibility
65: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
60: BEGIN
61: -- Standard start of API savepoint
62: SAVEPOINT INSERT_OUTCOME_PVT;
63:
64: -- Standard call to check for call compatibility
65: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
66: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
67: END IF;
68:
169:
170: X_OUTCOME_ID := L_OUTCOME_ID;
171: -- End of API body
172:
173: -- Standard check of p_commit
174: IF FND_API.To_Boolean(p_commit) THEN
175: COMMIT WORK;
176: END IF;
177:
174: IF FND_API.To_Boolean(p_commit) THEN
175: COMMIT WORK;
176: END IF;
177:
178: -- Standard call to get message count and if count is 1, get message info
179: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
180:
181: EXCEPTION
182: WHEN FND_API.G_EXC_ERROR THEN
227: l_msg_count NUMBER;
228: l_msg_data VARCHAR2(32767);
229:
230: BEGIN
231: -- Standard start of API savepoint
232: SAVEPOINT UPDATE_OUTCOME_PVT;
233:
234: -- Standard call to check for call compatibility
235: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
230: BEGIN
231: -- Standard start of API savepoint
232: SAVEPOINT UPDATE_OUTCOME_PVT;
233:
234: -- Standard call to check for call compatibility
235: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
237: END IF;
238:
278: OUTCOME_ID = P_OUTCOME_ID;
279:
280: -- End of API body
281:
282: -- Standard check of p_commit
283: IF FND_API.To_Boolean(p_commit) THEN
284: COMMIT WORK;
285: END IF;
286:
283: IF FND_API.To_Boolean(p_commit) THEN
284: COMMIT WORK;
285: END IF;
286:
287: -- Standard call to get message count and if count is 1, get message info
288: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
289:
290: EXCEPTION
291: WHEN FND_API.G_EXC_ERROR THEN
355: FROM JTF_IH_RESULTS_TL
356: WHERE RESULT_ID = l_RESULT_id;
357:
358: BEGIN
359: -- Standard start of API savepoint
360: SAVEPOINT INSERT_RESULT_PVT;
361:
362: -- Standard call to check for call compatibility
363: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
358: BEGIN
359: -- Standard start of API savepoint
360: SAVEPOINT INSERT_RESULT_PVT;
361:
362: -- Standard call to check for call compatibility
363: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
365: END IF;
366:
465:
466: X_RESULT_ID := L_RESULT_ID;
467: -- End of API body
468:
469: -- Standard check of p_commit
470: IF FND_API.To_Boolean(p_commit) THEN
471: COMMIT WORK;
472: END IF;
473:
470: IF FND_API.To_Boolean(p_commit) THEN
471: COMMIT WORK;
472: END IF;
473:
474: -- Standard call to get message count and if count is 1, get message info
475: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
476:
477: EXCEPTION
478: WHEN FND_API.G_EXC_ERROR THEN
522: l_msg_count NUMBER;
523: l_msg_data VARCHAR2(32767);
524:
525: BEGIN
526: -- Standard start of API savepoint
527: SAVEPOINT UPDATE_RESULT_PVT;
528:
529: -- Standard call to check for call compatibility
530: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
525: BEGIN
526: -- Standard start of API savepoint
527: SAVEPOINT UPDATE_RESULT_PVT;
528:
529: -- Standard call to check for call compatibility
530: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
532: END IF;
533:
572: RESULT_ID = P_RESULT_ID;
573:
574: -- End of API body
575:
576: -- Standard check of p_commit
577: IF FND_API.To_Boolean(p_commit) THEN
578: COMMIT WORK;
579: END IF;
580:
577: IF FND_API.To_Boolean(p_commit) THEN
578: COMMIT WORK;
579: END IF;
580:
581: -- Standard call to get message count and if count is 1, get message info
582: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
583:
584: EXCEPTION
585: WHEN FND_API.G_EXC_ERROR THEN
647: FROM JTF_IH_REASONS_TL
648: WHERE REASON_ID = l_REASON_id;
649:
650: BEGIN
651: -- Standard start of API savepoint
652: SAVEPOINT INSERT_REASON_PVT;
653:
654: -- Standard call to check for call compatibility
655: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
650: BEGIN
651: -- Standard start of API savepoint
652: SAVEPOINT INSERT_REASON_PVT;
653:
654: -- Standard call to check for call compatibility
655: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
657: END IF;
658:
753:
754: X_REASON_ID := L_REASON_ID;
755: -- End of API body
756:
757: -- Standard check of p_commit
758: IF FND_API.To_Boolean(p_commit) THEN
759: COMMIT WORK;
760: END IF;
761:
758: IF FND_API.To_Boolean(p_commit) THEN
759: COMMIT WORK;
760: END IF;
761:
762: -- Standard call to get message count and if count is 1, get message info
763: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
764:
765: EXCEPTION
766: WHEN FND_API.G_EXC_ERROR THEN
808: l_msg_count NUMBER;
809: l_msg_data VARCHAR2(32767);
810:
811: BEGIN
812: -- Standard start of API savepoint
813: SAVEPOINT UPDATE_REASON_PVT;
814:
815: -- Standard call to check for call compatibility
816: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
811: BEGIN
812: -- Standard start of API savepoint
813: SAVEPOINT UPDATE_REASON_PVT;
814:
815: -- Standard call to check for call compatibility
816: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
818: END IF;
819:
856: REASON_ID = P_REASON_ID;
857:
858: -- End of API body
859:
860: -- Standard check of p_commit
861: IF FND_API.To_Boolean(p_commit) THEN
862: COMMIT WORK;
863: END IF;
864:
861: IF FND_API.To_Boolean(p_commit) THEN
862: COMMIT WORK;
863: END IF;
864:
865: -- Standard call to get message count and if count is 1, get message info
866: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
867:
868: EXCEPTION
869: WHEN FND_API.G_EXC_ERROR THEN
905: l_msg_count NUMBER;
906: l_msg_data VARCHAR2(32767);
907:
908: BEGIN
909: -- Standard start of API savepoint
910: SAVEPOINT ALTER_OUTCOME_RESULT_LINK_PVT;
911:
912: -- Standard call to check for call compatibility
913: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
908: BEGIN
909: -- Standard start of API savepoint
910: SAVEPOINT ALTER_OUTCOME_RESULT_LINK_PVT;
911:
912: -- Standard call to check for call compatibility
913: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
915: END IF;
916:
955: end if;
956:
957: -- End of API body
958:
959: -- Standard check of p_commit
960: IF FND_API.To_Boolean(p_commit) THEN
961: COMMIT WORK;
962: END IF;
963:
960: IF FND_API.To_Boolean(p_commit) THEN
961: COMMIT WORK;
962: END IF;
963:
964: -- Standard call to get message count and if count is 1, get message info
965: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
966:
967: EXCEPTION
968: WHEN FND_API.G_EXC_ERROR THEN
1004: l_msg_count NUMBER;
1005: l_msg_data VARCHAR2(32767);
1006:
1007: BEGIN
1008: -- Standard start of API savepoint
1009: SAVEPOINT ALTER_RESULT_REASON_LINK_PVT;
1010:
1011: -- Standard call to check for call compatibility
1012: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1007: BEGIN
1008: -- Standard start of API savepoint
1009: SAVEPOINT ALTER_RESULT_REASON_LINK_PVT;
1010:
1011: -- Standard call to check for call compatibility
1012: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1014: END IF;
1015:
1054: end if;
1055:
1056: -- End of API body
1057:
1058: -- Standard check of p_commit
1059: IF FND_API.To_Boolean(p_commit) THEN
1060: COMMIT WORK;
1061: END IF;
1062:
1059: IF FND_API.To_Boolean(p_commit) THEN
1060: COMMIT WORK;
1061: END IF;
1062:
1063: -- Standard call to get message count and if count is 1, get message info
1064: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1065:
1066: EXCEPTION
1067: WHEN FND_API.G_EXC_ERROR THEN