DBA Data[Home] [Help]

APPS.ENG_CHANGE_IMPORT_UTIL dependencies on STANDARD

Line 104: -- FND Standard Log

100:
101: /*------------------------------------------------------------------
102: -- Comment Out
103: -- BEGIN
104: -- FND Standard Log
105: -- FND_LOG.LEVEL_UNEXPECTED;
106: -- FND_LOG.LEVEL_ERROR;
107: -- FND_LOG.LEVEL_EXCEPTION;
108: -- FND_LOG.LEVEL_EVENT;

Line 888: -- Standard Start of API savepoint

884:
885: BEGIN
886:
887:
888: -- Standard Start of API savepoint
889: SAVEPOINT WRITE_MSG_TO_INTF_TBL;
890:
891: -- Standard call to check for call compatibility.
892: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

887:
888: -- Standard Start of API savepoint
889: SAVEPOINT WRITE_MSG_TO_INTF_TBL;
890:
891: -- Standard call to check for call compatibility.
892: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
893: p_api_version ,
894: l_api_name ,
895: G_PKG_NAME )

Line 955: -- Standard check of p_commit.

951:
952: -- End of API body.
953:
954:
955: -- Standard check of p_commit.
956: IF FND_API.To_Boolean( p_commit ) THEN
957: COMMIT WORK;
958: END IF;
959:

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

956: IF FND_API.To_Boolean( p_commit ) THEN
957: COMMIT WORK;
958: END IF;
959:
960: -- Standard call to get message count and if count is 1, get message info.
961: FND_MSG_PUB.Count_And_Get
962: ( p_count => x_msg_count ,
963: p_data => x_msg_data
964: );

Line 1075: -- Standard Start of API savepoint

1071:
1072: BEGIN
1073:
1074:
1075: -- Standard Start of API savepoint
1076: SAVEPOINT VALIDATE_RECORDS;
1077:
1078: -- Standard call to check for call compatibility.
1079: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

1074:
1075: -- Standard Start of API savepoint
1076: SAVEPOINT VALIDATE_RECORDS;
1077:
1078: -- Standard call to check for call compatibility.
1079: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1080: p_api_version ,
1081: l_api_name ,
1082: G_PKG_NAME )

Line 1304: -- Standard check of l_commit.

1300:
1301: -- End of API body.
1302:
1303:
1304: -- Standard check of l_commit.
1305: IF FND_API.To_Boolean( l_commit ) THEN
1306: COMMIT WORK;
1307: END IF;
1308:

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

1305: IF FND_API.To_Boolean( l_commit ) THEN
1306: COMMIT WORK;
1307: END IF;
1308:
1309: -- Standard call to get message count and if count is 1, get message info.
1310: FND_MSG_PUB.Count_And_Get
1311: ( p_count => x_msg_count ,
1312: p_data => x_msg_data
1313: );

Line 1908: -- Standard Start of API savepoint

1904:
1905:
1906: BEGIN
1907:
1908: -- Standard Start of API savepoint
1909: SAVEPOINT VALIDATE_GDSN_ATTR_CHGS;
1910:
1911: -- Standard call to check for call compatibility.
1912: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

1907:
1908: -- Standard Start of API savepoint
1909: SAVEPOINT VALIDATE_GDSN_ATTR_CHGS;
1910:
1911: -- Standard call to check for call compatibility.
1912: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1913: p_api_version ,
1914: l_api_name ,
1915: G_PKG_NAME )

Line 2188: -- Standard check of l_commit.

2184:
2185: -- End of API body.
2186:
2187:
2188: -- Standard check of l_commit.
2189: IF FND_API.To_Boolean( l_commit ) THEN
2190: COMMIT WORK;
2191: END IF;
2192:

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

2189: IF FND_API.To_Boolean( l_commit ) THEN
2190: COMMIT WORK;
2191: END IF;
2192:
2193: -- Standard call to get message count and if count is 1, get message info.
2194: FND_MSG_PUB.Count_And_Get
2195: ( p_count => x_msg_count ,
2196: p_data => x_msg_data
2197: );

Line 2326: -- Standard Start of API savepoint

2322:
2323:
2324: BEGIN
2325:
2326: -- Standard Start of API savepoint
2327: SAVEPOINT POPULATE_MFGPARTNUM_INTF;
2328:
2329: -- Standard call to check for call compatibility.
2330: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

2325:
2326: -- Standard Start of API savepoint
2327: SAVEPOINT POPULATE_MFGPARTNUM_INTF;
2328:
2329: -- Standard call to check for call compatibility.
2330: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2331: p_api_version ,
2332: l_api_name ,
2333: G_PKG_NAME )

Line 2646: -- Standard check of p_commit.

2642:
2643: -- End of API body.
2644:
2645:
2646: -- Standard check of p_commit.
2647: IF FND_API.To_Boolean( p_commit ) THEN
2648: COMMIT WORK;
2649: END IF;
2650:

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

2647: IF FND_API.To_Boolean( p_commit ) THEN
2648: COMMIT WORK;
2649: END IF;
2650:
2651: -- Standard call to get message count and if count is 1, get message info.
2652: FND_MSG_PUB.Count_And_Get
2653: ( p_count => x_msg_count ,
2654: p_data => x_msg_data
2655: );

Line 2805: -- Standard Start of API savepoint

2801: l_error_msg VARCHAR2(2000) ;
2802:
2803: BEGIN
2804:
2805: -- Standard Start of API savepoint
2806: SAVEPOINT POPULATE_EXISTING_CHANGE;
2807:
2808: -- Standard call to check for call compatibility.
2809: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

2804:
2805: -- Standard Start of API savepoint
2806: SAVEPOINT POPULATE_EXISTING_CHANGE;
2807:
2808: -- Standard call to check for call compatibility.
2809: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
2810: p_api_version ,
2811: l_api_name ,
2812: G_PKG_NAME )

Line 3027: -- Standard check of p_commit.

3023:
3024: -- End of API body.
3025:
3026:
3027: -- Standard check of p_commit.
3028: IF FND_API.To_Boolean( p_commit ) THEN
3029: COMMIT WORK;
3030: END IF;
3031:

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

3028: IF FND_API.To_Boolean( p_commit ) THEN
3029: COMMIT WORK;
3030: END IF;
3031:
3032: -- Standard call to get message count and if count is 1, get message info.
3033: FND_MSG_PUB.Count_And_Get
3034: ( p_count => x_msg_count ,
3035: p_data => x_msg_data
3036: );

Line 3184: -- Standard Start of API savepoint

3180: l_error_msg VARCHAR2(2000) ;
3181:
3182: BEGIN
3183:
3184: -- Standard Start of API savepoint
3185: SAVEPOINT POPULATE_EXISTING_REV_ITEMS;
3186:
3187: -- Standard call to check for call compatibility.
3188: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

3183:
3184: -- Standard Start of API savepoint
3185: SAVEPOINT POPULATE_EXISTING_REV_ITEMS;
3186:
3187: -- Standard call to check for call compatibility.
3188: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
3189: p_api_version ,
3190: l_api_name ,
3191: G_PKG_NAME )

Line 3450: -- Standard check of p_commit.

3446:
3447: -- End of API body.
3448:
3449:
3450: -- Standard check of p_commit.
3451: IF FND_API.To_Boolean( p_commit ) THEN
3452: COMMIT WORK;
3453: END IF;
3454:

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

3451: IF FND_API.To_Boolean( p_commit ) THEN
3452: COMMIT WORK;
3453: END IF;
3454:
3455: -- Standard call to get message count and if count is 1, get message info.
3456: FND_MSG_PUB.Count_And_Get
3457: ( p_count => x_msg_count ,
3458: p_data => x_msg_data
3459: );

Line 3611: -- Standard Start of API savepoint

3607: l_error_msg VARCHAR2(2000) ;
3608:
3609: BEGIN
3610:
3611: -- Standard Start of API savepoint
3612: SAVEPOINT UPDATE_PROCESS_STATUS;
3613:
3614: -- Standard call to check for call compatibility.
3615: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

3610:
3611: -- Standard Start of API savepoint
3612: SAVEPOINT UPDATE_PROCESS_STATUS;
3613:
3614: -- Standard call to check for call compatibility.
3615: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
3616: p_api_version ,
3617: l_api_name ,
3618: G_PKG_NAME )

Line 3724: -- Standard check of p_commit.

3720: END LOOP ;
3721: -- End of API body.
3722:
3723:
3724: -- Standard check of p_commit.
3725: IF FND_API.To_Boolean( p_commit ) THEN
3726: COMMIT WORK;
3727: END IF;
3728:

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

3725: IF FND_API.To_Boolean( p_commit ) THEN
3726: COMMIT WORK;
3727: END IF;
3728:
3729: -- Standard call to get message count and if count is 1, get message info.
3730: FND_MSG_PUB.Count_And_Get
3731: ( p_count => x_msg_count ,
3732: p_data => x_msg_data
3733: );

Line 4083: -- Standard Start of API savepoint

4079: l_from_end_item_rev_id NUMBER;
4080:
4081: BEGIN
4082:
4083: -- Standard Start of API savepoint
4084: SAVEPOINT CREATE_ORPHAN_COMPONENT_INTF;
4085:
4086: -- Standard call to check for call compatibility.
4087: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

4082:
4083: -- Standard Start of API savepoint
4084: SAVEPOINT CREATE_ORPHAN_COMPONENT_INTF;
4085:
4086: -- Standard call to check for call compatibility.
4087: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
4088: p_api_version ,
4089: l_api_name ,
4090: G_PKG_NAME )

Line 4263: -- Standard check of p_commit.

4259: );
4260: Write_Debug('Done Inserting data into interface tables:');
4261: -- End of API body.
4262:
4263: -- Standard check of p_commit.
4264: IF FND_API.To_Boolean( p_commit ) THEN
4265: COMMIT WORK;
4266: END IF;
4267:

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

4264: IF FND_API.To_Boolean( p_commit ) THEN
4265: COMMIT WORK;
4266: END IF;
4267:
4268: -- Standard call to get message count and if count is 1, get message info.
4269: FND_MSG_PUB.Count_And_Get
4270: ( p_count => x_msg_count ,
4271: p_data => x_msg_data
4272: );

Line 4372: -- Standard Start of API savepoint

4368: l_effectivity_control NUMBER;
4369: l_alt_bom_designator VARCHAR2(30);
4370: BEGIN
4371:
4372: -- Standard Start of API savepoint
4373: SAVEPOINT CREATE_ORPHAN_HEADER_INTF;
4374:
4375: -- Standard call to check for call compatibility.
4376: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

4371:
4372: -- Standard Start of API savepoint
4373: SAVEPOINT CREATE_ORPHAN_HEADER_INTF;
4374:
4375: -- Standard call to check for call compatibility.
4376: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
4377: p_api_version ,
4378: l_api_name ,
4379: G_PKG_NAME )

Line 4474: -- Standard check of p_commit.

4470: );
4471: Write_Debug('Done Inserting data into interface tables:');
4472: -- End of API body.
4473:
4474: -- Standard check of p_commit.
4475: IF FND_API.To_Boolean( p_commit ) THEN
4476: COMMIT WORK;
4477: END IF;
4478:

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

4475: IF FND_API.To_Boolean( p_commit ) THEN
4476: COMMIT WORK;
4477: END IF;
4478:
4479: -- Standard call to get message count and if count is 1, get message info.
4480: FND_MSG_PUB.Count_And_Get
4481: ( p_count => x_msg_count ,
4482: p_data => x_msg_data
4483: );

Line 4582: -- Standard Start of API savepoint

4578: l_commit VARCHAR2(1) ;
4579:
4580: BEGIN
4581:
4582: -- Standard Start of API savepoint
4583: SAVEPOINT PREPROCESS_COMP_CHILD_ROWS;
4584:
4585: -- Standard call to check for call compatibility.
4586: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

4581:
4582: -- Standard Start of API savepoint
4583: SAVEPOINT PREPROCESS_COMP_CHILD_ROWS;
4584:
4585: -- Standard call to check for call compatibility.
4586: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
4587: p_api_version ,
4588: l_api_name ,
4589: G_PKG_NAME )

Line 4682: -- Standard check of p_commit.

4678: AND transaction_type in ('CREATE', 'UPDATE', 'DELETE');
4679:
4680: -- End of API body.
4681:
4682: -- Standard check of p_commit.
4683: IF FND_API.To_Boolean( p_commit ) THEN
4684: COMMIT WORK;
4685: END IF;
4686:

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

4683: IF FND_API.To_Boolean( p_commit ) THEN
4684: COMMIT WORK;
4685: END IF;
4686:
4687: -- Standard call to get message count and if count is 1, get message info.
4688: FND_MSG_PUB.Count_And_Get
4689: ( p_count => x_msg_count ,
4690: p_data => x_msg_data
4691: );

Line 4820: -- Standard Start of API savepoint

4816: l_change_transaction_type VARCHAR2(10);
4817:
4818: BEGIN
4819:
4820: -- Standard Start of API savepoint
4821: SAVEPOINT PREPROCESS_BOM_INTERFACE_ROWS;
4822:
4823: -- Standard call to check for call compatibility.
4824: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

4819:
4820: -- Standard Start of API savepoint
4821: SAVEPOINT PREPROCESS_BOM_INTERFACE_ROWS;
4822:
4823: -- Standard call to check for call compatibility.
4824: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
4825: p_api_version ,
4826: l_api_name ,
4827: G_PKG_NAME )

Line 5111: -- Standard check of p_commit.

5107: Write_Debug('After Updating All Interface records . . .. ' );
5108:
5109: -- End of API body.
5110:
5111: -- Standard check of p_commit.
5112: IF FND_API.To_Boolean( p_commit ) THEN
5113: COMMIT WORK;
5114: END IF;
5115:

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

5112: IF FND_API.To_Boolean( p_commit ) THEN
5113: COMMIT WORK;
5114: END IF;
5115:
5116: -- Standard call to get message count and if count is 1, get message info.
5117: FND_MSG_PUB.Count_And_Get
5118: ( p_count => x_msg_count ,
5119: p_data => x_msg_data
5120: );

Line 5236: -- Standard Start of API savepoint

5232:
5233:
5234: BEGIN
5235:
5236: -- Standard Start of API savepoint
5237: SAVEPOINT INSERT_IMPORTED_CHANGE_HISTORY;
5238:
5239: -- Standard call to check for call compatibility.
5240: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

5235:
5236: -- Standard Start of API savepoint
5237: SAVEPOINT INSERT_IMPORTED_CHANGE_HISTORY;
5238:
5239: -- Standard call to check for call compatibility.
5240: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
5241: p_api_version ,
5242: l_api_name ,
5243: G_PKG_NAME )

Line 5344: -- Standard check of p_commit.

5340: END LOOP ;
5341: -- End of API body.
5342:
5343:
5344: -- Standard check of p_commit.
5345: IF FND_API.To_Boolean( p_commit ) THEN
5346: COMMIT WORK;
5347: END IF;
5348:

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

5345: IF FND_API.To_Boolean( p_commit ) THEN
5346: COMMIT WORK;
5347: END IF;
5348:
5349: -- Standard call to get message count and if count is 1, get message info.
5350: FND_MSG_PUB.Count_And_Get
5351: ( p_count => x_msg_count ,
5352: p_data => x_msg_data
5353: );