103:
104: /*------------------------------------------------------------------
105: -- Comment Out
106: -- BEGIN
107: -- FND Standard Log
108: -- FND_LOG.LEVEL_UNEXPECTED;
109: -- FND_LOG.LEVEL_ERROR;
110: -- FND_LOG.LEVEL_EXCEPTION;
111: -- FND_LOG.LEVEL_EVENT;
888:
889: BEGIN
890:
891:
892: -- Standard Start of API savepoint
893: SAVEPOINT WRITE_MSG_TO_INTF_TBL;
894:
895: -- Standard call to check for call compatibility.
896: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
891:
892: -- Standard Start of API savepoint
893: SAVEPOINT WRITE_MSG_TO_INTF_TBL;
894:
895: -- Standard call to check for call compatibility.
896: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
897: p_api_version ,
898: l_api_name ,
899: G_PKG_NAME )
955:
956: -- End of API body.
957:
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
966: ( p_count => x_msg_count ,
967: p_data => x_msg_data
968: );
1075:
1076: BEGIN
1077:
1078:
1079: -- Standard Start of API savepoint
1080: SAVEPOINT VALIDATE_RECORDS;
1081:
1082: -- Standard call to check for call compatibility.
1083: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1078:
1079: -- Standard Start of API savepoint
1080: SAVEPOINT VALIDATE_RECORDS;
1081:
1082: -- Standard call to check for call compatibility.
1083: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1084: p_api_version ,
1085: l_api_name ,
1086: G_PKG_NAME )
1304:
1305: -- End of API body.
1306:
1307:
1308: -- Standard check of l_commit.
1309: IF FND_API.To_Boolean( l_commit ) THEN
1310: COMMIT WORK;
1311: END IF;
1312:
1309: IF FND_API.To_Boolean( l_commit ) THEN
1310: COMMIT WORK;
1311: END IF;
1312:
1313: -- Standard call to get message count and if count is 1, get message info.
1314: FND_MSG_PUB.Count_And_Get
1315: ( p_count => x_msg_count ,
1316: p_data => x_msg_data
1317: );
1908:
1909:
1910: BEGIN
1911:
1912: -- Standard Start of API savepoint
1913: SAVEPOINT VALIDATE_GDSN_ATTR_CHGS;
1914:
1915: -- Standard call to check for call compatibility.
1916: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1911:
1912: -- Standard Start of API savepoint
1913: SAVEPOINT VALIDATE_GDSN_ATTR_CHGS;
1914:
1915: -- Standard call to check for call compatibility.
1916: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1917: p_api_version ,
1918: l_api_name ,
1919: G_PKG_NAME )
2188:
2189: -- End of API body.
2190:
2191:
2192: -- Standard check of l_commit.
2193: IF FND_API.To_Boolean( l_commit ) THEN
2194: COMMIT WORK;
2195: END IF;
2196:
2193: IF FND_API.To_Boolean( l_commit ) THEN
2194: COMMIT WORK;
2195: END IF;
2196:
2197: -- Standard call to get message count and if count is 1, get message info.
2198: FND_MSG_PUB.Count_And_Get
2199: ( p_count => x_msg_count ,
2200: p_data => x_msg_data
2201: );
2326:
2327:
2328: BEGIN
2329:
2330: -- Standard Start of API savepoint
2331: SAVEPOINT POPULATE_MFGPARTNUM_INTF;
2332:
2333: -- Standard call to check for call compatibility.
2334: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2329:
2330: -- Standard Start of API savepoint
2331: SAVEPOINT POPULATE_MFGPARTNUM_INTF;
2332:
2333: -- Standard call to check for call compatibility.
2334: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2335: p_api_version ,
2336: l_api_name ,
2337: G_PKG_NAME )
2646:
2647: -- End of API body.
2648:
2649:
2650: -- Standard check of p_commit.
2651: IF FND_API.To_Boolean( p_commit ) THEN
2652: COMMIT WORK;
2653: END IF;
2654:
2651: IF FND_API.To_Boolean( p_commit ) THEN
2652: COMMIT WORK;
2653: END IF;
2654:
2655: -- Standard call to get message count and if count is 1, get message info.
2656: FND_MSG_PUB.Count_And_Get
2657: ( p_count => x_msg_count ,
2658: p_data => x_msg_data
2659: );
2810: l_inventory_item_id NUMBER ;
2811:
2812: BEGIN
2813:
2814: -- Standard Start of API savepoint
2815: SAVEPOINT POPULATE_EXISTING_CHANGE;
2816:
2817: -- Standard call to check for call compatibility.
2818: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2813:
2814: -- Standard Start of API savepoint
2815: SAVEPOINT POPULATE_EXISTING_CHANGE;
2816:
2817: -- Standard call to check for call compatibility.
2818: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2819: p_api_version ,
2820: l_api_name ,
2821: G_PKG_NAME )
3129:
3130: -- End of API body.
3131:
3132:
3133: -- Standard check of p_commit.
3134: IF FND_API.To_Boolean( p_commit ) THEN
3135: COMMIT WORK;
3136: END IF;
3137:
3134: IF FND_API.To_Boolean( p_commit ) THEN
3135: COMMIT WORK;
3136: END IF;
3137:
3138: -- Standard call to get message count and if count is 1, get message info.
3139: FND_MSG_PUB.Count_And_Get
3140: ( p_count => x_msg_count ,
3141: p_data => x_msg_data
3142: );
3286: l_error_msg VARCHAR2(2000) ;
3287:
3288: BEGIN
3289:
3290: -- Standard Start of API savepoint
3291: SAVEPOINT POPULATE_EXISTING_REV_ITEMS;
3292:
3293: -- Standard call to check for call compatibility.
3294: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
3289:
3290: -- Standard Start of API savepoint
3291: SAVEPOINT POPULATE_EXISTING_REV_ITEMS;
3292:
3293: -- Standard call to check for call compatibility.
3294: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
3295: p_api_version ,
3296: l_api_name ,
3297: G_PKG_NAME )
3552:
3553: -- End of API body.
3554:
3555:
3556: -- Standard check of p_commit.
3557: IF FND_API.To_Boolean( p_commit ) THEN
3558: COMMIT WORK;
3559: END IF;
3560:
3557: IF FND_API.To_Boolean( p_commit ) THEN
3558: COMMIT WORK;
3559: END IF;
3560:
3561: -- Standard call to get message count and if count is 1, get message info.
3562: FND_MSG_PUB.Count_And_Get
3563: ( p_count => x_msg_count ,
3564: p_data => x_msg_data
3565: );
3713: l_error_msg VARCHAR2(2000) ;
3714:
3715: BEGIN
3716:
3717: -- Standard Start of API savepoint
3718: SAVEPOINT UPDATE_PROCESS_STATUS;
3719:
3720: -- Standard call to check for call compatibility.
3721: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
3716:
3717: -- Standard Start of API savepoint
3718: SAVEPOINT UPDATE_PROCESS_STATUS;
3719:
3720: -- Standard call to check for call compatibility.
3721: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
3722: p_api_version ,
3723: l_api_name ,
3724: G_PKG_NAME )
3826: END LOOP ;
3827: -- End of API body.
3828:
3829:
3830: -- Standard check of p_commit.
3831: IF FND_API.To_Boolean( p_commit ) THEN
3832: COMMIT WORK;
3833: END IF;
3834:
3831: IF FND_API.To_Boolean( p_commit ) THEN
3832: COMMIT WORK;
3833: END IF;
3834:
3835: -- Standard call to get message count and if count is 1, get message info.
3836: FND_MSG_PUB.Count_And_Get
3837: ( p_count => x_msg_count ,
3838: p_data => x_msg_data
3839: );
4185: l_from_end_item_rev_id NUMBER;
4186:
4187: BEGIN
4188:
4189: -- Standard Start of API savepoint
4190: SAVEPOINT CREATE_ORPHAN_COMPONENT_INTF;
4191:
4192: -- Standard call to check for call compatibility.
4193: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
4188:
4189: -- Standard Start of API savepoint
4190: SAVEPOINT CREATE_ORPHAN_COMPONENT_INTF;
4191:
4192: -- Standard call to check for call compatibility.
4193: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
4194: p_api_version ,
4195: l_api_name ,
4196: G_PKG_NAME )
4365: );
4366: Write_Debug('Done Inserting data into interface tables:');
4367: -- End of API body.
4368:
4369: -- Standard check of p_commit.
4370: IF FND_API.To_Boolean( p_commit ) THEN
4371: COMMIT WORK;
4372: END IF;
4373:
4370: IF FND_API.To_Boolean( p_commit ) THEN
4371: COMMIT WORK;
4372: END IF;
4373:
4374: -- Standard call to get message count and if count is 1, get message info.
4375: FND_MSG_PUB.Count_And_Get
4376: ( p_count => x_msg_count ,
4377: p_data => x_msg_data
4378: );
4474: l_effectivity_control NUMBER;
4475: l_alt_bom_designator VARCHAR2(30);
4476: BEGIN
4477:
4478: -- Standard Start of API savepoint
4479: SAVEPOINT CREATE_ORPHAN_HEADER_INTF;
4480:
4481: -- Standard call to check for call compatibility.
4482: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
4477:
4478: -- Standard Start of API savepoint
4479: SAVEPOINT CREATE_ORPHAN_HEADER_INTF;
4480:
4481: -- Standard call to check for call compatibility.
4482: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
4483: p_api_version ,
4484: l_api_name ,
4485: G_PKG_NAME )
4576: );
4577: Write_Debug('Done Inserting data into interface tables:');
4578: -- End of API body.
4579:
4580: -- Standard check of p_commit.
4581: IF FND_API.To_Boolean( p_commit ) THEN
4582: COMMIT WORK;
4583: END IF;
4584:
4581: IF FND_API.To_Boolean( p_commit ) THEN
4582: COMMIT WORK;
4583: END IF;
4584:
4585: -- Standard call to get message count and if count is 1, get message info.
4586: FND_MSG_PUB.Count_And_Get
4587: ( p_count => x_msg_count ,
4588: p_data => x_msg_data
4589: );
4684: l_commit VARCHAR2(1) ;
4685:
4686: BEGIN
4687:
4688: -- Standard Start of API savepoint
4689: SAVEPOINT PREPROCESS_COMP_CHILD_ROWS;
4690:
4691: -- Standard call to check for call compatibility.
4692: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
4687:
4688: -- Standard Start of API savepoint
4689: SAVEPOINT PREPROCESS_COMP_CHILD_ROWS;
4690:
4691: -- Standard call to check for call compatibility.
4692: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
4693: p_api_version ,
4694: l_api_name ,
4695: G_PKG_NAME )
4784: AND transaction_type in ('CREATE', 'UPDATE', 'DELETE');
4785:
4786: -- End of API body.
4787:
4788: -- Standard check of p_commit.
4789: IF FND_API.To_Boolean( p_commit ) THEN
4790: COMMIT WORK;
4791: END IF;
4792:
4789: IF FND_API.To_Boolean( p_commit ) THEN
4790: COMMIT WORK;
4791: END IF;
4792:
4793: -- Standard call to get message count and if count is 1, get message info.
4794: FND_MSG_PUB.Count_And_Get
4795: ( p_count => x_msg_count ,
4796: p_data => x_msg_data
4797: );
4922: l_change_transaction_type VARCHAR2(10);
4923:
4924: BEGIN
4925:
4926: -- Standard Start of API savepoint
4927: SAVEPOINT PREPROCESS_BOM_INTERFACE_ROWS;
4928:
4929: -- Standard call to check for call compatibility.
4930: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
4925:
4926: -- Standard Start of API savepoint
4927: SAVEPOINT PREPROCESS_BOM_INTERFACE_ROWS;
4928:
4929: -- Standard call to check for call compatibility.
4930: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
4931: p_api_version ,
4932: l_api_name ,
4933: G_PKG_NAME )
5213: Write_Debug('After Updating All Interface records . . .. ' );
5214:
5215: -- End of API body.
5216:
5217: -- Standard check of p_commit.
5218: IF FND_API.To_Boolean( p_commit ) THEN
5219: COMMIT WORK;
5220: END IF;
5221:
5218: IF FND_API.To_Boolean( p_commit ) THEN
5219: COMMIT WORK;
5220: END IF;
5221:
5222: -- Standard call to get message count and if count is 1, get message info.
5223: FND_MSG_PUB.Count_And_Get
5224: ( p_count => x_msg_count ,
5225: p_data => x_msg_data
5226: );
5347: --End code change for bug 9398720
5348:
5349: BEGIN
5350:
5351: -- Standard Start of API savepoint
5352: SAVEPOINT INSERT_IMPORTED_CHANGE_HISTORY;
5353:
5354: -- Standard call to check for call compatibility.
5355: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
5350:
5351: -- Standard Start of API savepoint
5352: SAVEPOINT INSERT_IMPORTED_CHANGE_HISTORY;
5353:
5354: -- Standard call to check for call compatibility.
5355: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
5356: p_api_version ,
5357: l_api_name ,
5358: G_PKG_NAME )
5471: END LOOP ;
5472: -- End of API body.
5473:
5474:
5475: -- Standard check of p_commit.
5476: IF FND_API.To_Boolean( p_commit ) THEN
5477: COMMIT WORK;
5478: END IF;
5479:
5476: IF FND_API.To_Boolean( p_commit ) THEN
5477: COMMIT WORK;
5478: END IF;
5479:
5480: -- Standard call to get message count and if count is 1, get message info.
5481: FND_MSG_PUB.Count_And_Get
5482: ( p_count => x_msg_count ,
5483: p_data => x_msg_data
5484: );