[Home] [Help]
138: l_list_rec c_list_ent_det%ROWTYPE ;
139:
140: BEGIN
141: --
142: -- Standard Start of API savepoint
143: --
144: SAVEPOINT FulFill_OC_PT;
145:
146: --
156: FND_MSG_PUB.initialize;
157: END IF;
158:
159: --
160: -- Standard call to check for call compatibility.
161: --
162: IF NOT FND_API.Compatible_API_Call ( l_api_version,
163: p_api_version,
164: l_api_name,
283: -- END of API body.
284: --
285:
286: --
287: -- Standard call to get message count AND IF count is 1, get message info.
288: --
289: FND_MSG_PUB.Count_AND_Get
290: ( p_count => x_msg_count,
291: p_data => x_msg_data,
478:
479: l_delivery_mode VARCHAR2(30);
480: BEGIN
481: --
482: -- Standard Start of API savepoint
483: --
484: SAVEPOINT Create_FULFILL_PVT;
485:
486: --
497: FND_MSG_PUB.initialize;
498: END IF;
499:
500: --
501: -- Standard call to check for call compatibility.
502: --
503: IF NOT FND_API.Compatible_API_Call ( l_api_version,
504: p_api_version,
505: l_api_name,
675: -- END of API body.
676: --
677:
678: --
679: -- Standard check of p_commit.
680: --
681: IF FND_API.To_Boolean ( p_commit )
682: THEN
683: COMMIT WORK;
683: COMMIT WORK;
684: END IF;
685:
686: --
687: -- Standard call to get message count AND IF count is 1, get message info.
688: --
689: FND_MSG_PUB.Count_AND_Get
690: ( p_count => x_msg_count,
691: p_data => x_msg_data,
787: l_request_history_id NUMBER;
788:
789: BEGIN
790: --
791: -- Standard Start of API savepoint
792: --
793: SAVEPOINT AMS_EXEC_SCHEDULE;
794:
795: --
806: FND_MSG_PUB.initialize;
807: END IF;
808:
809: --
810: -- Standard call to check for call compatibility.
811: --
812: IF NOT FND_API.Compatible_API_Call ( l_api_version,
813: p_api_version,
814: l_api_name,
910:
911: END IF ;
912:
913: --
914: -- Standard check of p_commit.
915: --
916: IF FND_API.To_Boolean ( p_commit )
917: THEN
918: COMMIT WORK;
918: COMMIT WORK;
919: END IF;
920:
921: --
922: -- Standard call to get message count AND IF count is 1, get message info.
923: --
924: FND_MSG_PUB.Count_AND_Get
925: ( p_count => x_msg_count,
926: p_data => x_msg_data,
1085: FND_MSG_PUB.initialize;
1086: END IF;
1087:
1088: --
1089: -- Standard call to check for call compatibility.
1090: --
1091: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1092: p_api_version,
1093: l_api_name,
1219: -- END of API body.
1220: --
1221:
1222: --
1223: -- Standard call to get message count AND IF count is 1, get message info.
1224: --
1225: FND_MSG_PUB.Count_AND_Get
1226: ( p_count => x_msg_count,
1227: p_data => x_msg_data,
1323: FND_MSG_PUB.initialize;
1324: END IF;
1325:
1326: --
1327: -- Standard call to check for call compatibility.
1328: --
1329: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1330: p_api_version,
1331: l_api_name,
1381: -- END of API body.
1382: --
1383:
1384: --
1385: -- Standard call to get message count AND IF count is 1, get message info.
1386: --
1387: FND_MSG_PUB.Count_AND_Get
1388: ( p_count => x_msg_count,
1389: p_data => x_msg_data,
1542: FND_MSG_PUB.initialize;
1543: END IF;
1544:
1545: --
1546: -- Standard call to check for call compatibility.
1547: --
1548: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1549: p_api_version,
1550: l_api_name,
1786: -- END of API body.
1787: --
1788:
1789: --
1790: -- Standard call to get message count AND IF count is 1, get message info.
1791: --
1792: FND_MSG_PUB.Count_AND_Get
1793: ( p_count => x_msg_count,
1794: p_data => x_msg_data,
1971:
1972:
1973: BEGIN
1974: --
1975: -- Standard Start of API savepoint
1976: --
1977: SAVEPOINT Create_FULFILL_PVT;
1978:
1979: --
1990: FND_MSG_PUB.initialize;
1991: END IF;
1992:
1993: --
1994: -- Standard call to check for call compatibility.
1995: --
1996: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1997: p_api_version,
1998: l_api_name,
2206: -- END of API body.
2207: --
2208:
2209: --
2210: -- Standard check of p_commit.
2211: --
2212: IF FND_API.To_Boolean ( p_commit )
2213: THEN
2214: COMMIT WORK;
2214: COMMIT WORK;
2215: END IF;
2216:
2217: --
2218: -- Standard call to get message count AND IF count is 1, get message info.
2219: --
2220: FND_MSG_PUB.Count_AND_Get
2221: ( p_count => x_msg_count,
2222: p_data => x_msg_data,
2491: AMS_Utility_PVT.Debug_Message('Success Flag : '||x_return_status );
2492: END IF;
2493:
2494: --
2495: -- Standard check of p_commit.
2496: --
2497: IF FND_API.To_Boolean ( p_commit )
2498: THEN
2499: COMMIT WORK;
2499: COMMIT WORK;
2500: END IF;
2501:
2502: --
2503: -- Standard call to get message count AND IF count is 1, get message info.
2504: --
2505: FND_MSG_PUB.Count_AND_Get
2506: ( p_count => x_msg_count,
2507: p_data => x_msg_data,
2636: (mes_doc_id, query_id,last_update_date,last_updated_by,creation_date,created_by)
2637: VALUES(p_item_id, p_query_id,SYSDATE,FND_GLOBAL.user_id,SYSDATE,FND_GLOBAL.user_id) ;
2638:
2639: --
2640: -- Standard check of p_commit.
2641: --
2642: IF FND_API.To_Boolean ( p_commit )
2643: THEN
2644: COMMIT WORK;
2644: COMMIT WORK;
2645: END IF;
2646:
2647: --
2648: -- Standard call to get message count AND IF count is 1, get message info.
2649: --
2650: FND_MSG_PUB.Count_AND_Get
2651: ( p_count => x_msg_count,
2652: p_data => x_msg_data,