DBA Data[Home] [Help]

APPS.ENG_CHANGE_IMPORT_UTIL dependencies on STANDARD

Line 107: -- FND Standard Log

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;

Line 892: -- Standard Start of API savepoint

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 ,

Line 895: -- Standard call to check for call compatibility.

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 )

Line 959: -- Standard check of p_commit.

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:

Line 964: -- Standard call to get message count and if count is 1, get message info.

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: );

Line 1079: -- Standard Start of API savepoint

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 ,

Line 1082: -- Standard call to check for call compatibility.

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 )

Line 1308: -- Standard check of l_commit.

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:

Line 1313: -- Standard call to get message count and if count is 1, get message info.

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: );

Line 1912: -- Standard Start of API savepoint

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 ,

Line 1915: -- Standard call to check for call compatibility.

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 )

Line 2192: -- Standard check of l_commit.

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:

Line 2197: -- Standard call to get message count and if count is 1, get message info.

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: );

Line 2330: -- Standard Start of API savepoint

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 ,

Line 2333: -- Standard call to check for call compatibility.

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 )

Line 2650: -- Standard check of p_commit.

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:

Line 2655: -- Standard call to get message count and if count is 1, get message info.

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: );

Line 2814: -- Standard Start of API savepoint

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 ,

Line 2817: -- Standard call to check for call compatibility.

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 )

Line 3133: -- Standard check of p_commit.

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:

Line 3138: -- Standard call to get message count and if count is 1, get message info.

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: );

Line 3290: -- Standard Start of API savepoint

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 ,

Line 3293: -- Standard call to check for call compatibility.

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 )

Line 3556: -- Standard check of p_commit.

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:

Line 3561: -- Standard call to get message count and if count is 1, get message info.

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: );

Line 3717: -- Standard Start of API savepoint

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 ,

Line 3720: -- Standard call to check for call compatibility.

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 )

Line 3830: -- Standard check of p_commit.

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:

Line 3835: -- Standard call to get message count and if count is 1, get message info.

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: );

Line 4189: -- Standard Start of API savepoint

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 ,

Line 4192: -- Standard call to check for call compatibility.

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 )

Line 4369: -- Standard check of p_commit.

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:

Line 4374: -- Standard call to get message count and if count is 1, get message info.

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: );

Line 4478: -- Standard Start of API savepoint

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 ,

Line 4481: -- Standard call to check for call compatibility.

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 )

Line 4580: -- Standard check of p_commit.

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:

Line 4585: -- Standard call to get message count and if count is 1, get message info.

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: );

Line 4688: -- Standard Start of API savepoint

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 ,

Line 4691: -- Standard call to check for call compatibility.

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 )

Line 4788: -- Standard check of p_commit.

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:

Line 4793: -- Standard call to get message count and if count is 1, get message info.

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: );

Line 4926: -- Standard Start of API savepoint

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 ,

Line 4929: -- Standard call to check for call compatibility.

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 )

Line 5217: -- Standard check of p_commit.

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:

Line 5222: -- Standard call to get message count and if count is 1, get message info.

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: );

Line 5351: -- Standard Start of API savepoint

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 ,

Line 5354: -- Standard call to check for call compatibility.

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 )

Line 5475: -- Standard check of p_commit.

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:

Line 5480: -- Standard call to get message count and if count is 1, get message info.

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: );