eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MTL_RELATED_ITEMS_PVT dependencies on MTL_RELATED_ITEMS

Line 1: PACKAGE BODY MTL_RELATED_ITEMS_PVT AS

1: PACKAGE BODY MTL_RELATED_ITEMS_PVT AS
2: /* $Header: INVVRITB.pls 120.16.12020000.3 2013/04/10 09:31:06 ccsingh ship $ */
3:
4: -----------------------------------------------
5: -- Write Debug statements to Concurrent Log --

Line 31: ,p_Rel_Item_Rec IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Rel_Item_Rec_Type

27: -- -----------------------------------------------------------------------------
28: PROCEDURE Process_Rel_Item(
29: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
30: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
31: ,p_Rel_Item_Rec IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Rel_Item_Rec_Type
32: ,p_Pln_Info_Tbl IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Pln_Info_Tbl_Type
33: ,p_Cust_Ref_Tbl IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Cust_Ref_Tbl_Type
34: ,x_return_status OUT NOCOPY VARCHAR2
35: ,x_msg_count OUT NOCOPY NUMBER

Line 32: ,p_Pln_Info_Tbl IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Pln_Info_Tbl_Type

28: PROCEDURE Process_Rel_Item(
29: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
30: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
31: ,p_Rel_Item_Rec IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Rel_Item_Rec_Type
32: ,p_Pln_Info_Tbl IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Pln_Info_Tbl_Type
33: ,p_Cust_Ref_Tbl IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Cust_Ref_Tbl_Type
34: ,x_return_status OUT NOCOPY VARCHAR2
35: ,x_msg_count OUT NOCOPY NUMBER
36: ,x_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type) IS

Line 33: ,p_Cust_Ref_Tbl IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Cust_Ref_Tbl_Type

29: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
30: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
31: ,p_Rel_Item_Rec IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Rel_Item_Rec_Type
32: ,p_Pln_Info_Tbl IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Pln_Info_Tbl_Type
33: ,p_Cust_Ref_Tbl IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Cust_Ref_Tbl_Type
34: ,x_return_status OUT NOCOPY VARCHAR2
35: ,x_msg_count OUT NOCOPY NUMBER
36: ,x_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type) IS
37:

Line 50: l_Rel_Item_Rec MTL_RELATED_ITEMS_PUB.Rel_Item_Rec_Type; -- declaring related items record type

46: l_master_org_exists VARCHAR(1);
47: l_cust_ref_exists VARCHAR(1);
48: l_cust_ref_rel_exists VARCHAR(1);
49:
50: l_Rel_Item_Rec MTL_RELATED_ITEMS_PUB.Rel_Item_Rec_Type; -- declaring related items record type
51: l_Pln_Info_Rec MTL_RELATED_ITEMS_PUB.Pln_Info_Rec_Type; -- declating planning information record type
52: l_Pln_Info_Tbl MTL_RELATED_ITEMS_PUB.Pln_Info_Tbl_Type; -- declaring planning information table type
53: l_Cust_Ref_Rec MTL_RELATED_ITEMS_PUB.Cust_Ref_Rec_Type; -- declating customer reference record type
54: l_Cust_Ref_Tbl MTL_RELATED_ITEMS_PUB.Cust_Ref_Tbl_Type; -- declaring customer reference table type

Line 51: l_Pln_Info_Rec MTL_RELATED_ITEMS_PUB.Pln_Info_Rec_Type; -- declating planning information record type

47: l_cust_ref_exists VARCHAR(1);
48: l_cust_ref_rel_exists VARCHAR(1);
49:
50: l_Rel_Item_Rec MTL_RELATED_ITEMS_PUB.Rel_Item_Rec_Type; -- declaring related items record type
51: l_Pln_Info_Rec MTL_RELATED_ITEMS_PUB.Pln_Info_Rec_Type; -- declating planning information record type
52: l_Pln_Info_Tbl MTL_RELATED_ITEMS_PUB.Pln_Info_Tbl_Type; -- declaring planning information table type
53: l_Cust_Ref_Rec MTL_RELATED_ITEMS_PUB.Cust_Ref_Rec_Type; -- declating customer reference record type
54: l_Cust_Ref_Tbl MTL_RELATED_ITEMS_PUB.Cust_Ref_Tbl_Type; -- declaring customer reference table type
55:

Line 52: l_Pln_Info_Tbl MTL_RELATED_ITEMS_PUB.Pln_Info_Tbl_Type; -- declaring planning information table type

48: l_cust_ref_rel_exists VARCHAR(1);
49:
50: l_Rel_Item_Rec MTL_RELATED_ITEMS_PUB.Rel_Item_Rec_Type; -- declaring related items record type
51: l_Pln_Info_Rec MTL_RELATED_ITEMS_PUB.Pln_Info_Rec_Type; -- declating planning information record type
52: l_Pln_Info_Tbl MTL_RELATED_ITEMS_PUB.Pln_Info_Tbl_Type; -- declaring planning information table type
53: l_Cust_Ref_Rec MTL_RELATED_ITEMS_PUB.Cust_Ref_Rec_Type; -- declating customer reference record type
54: l_Cust_Ref_Tbl MTL_RELATED_ITEMS_PUB.Cust_Ref_Tbl_Type; -- declaring customer reference table type
55:
56: Returned_Row_Id VARCHAR2(30);

Line 53: l_Cust_Ref_Rec MTL_RELATED_ITEMS_PUB.Cust_Ref_Rec_Type; -- declating customer reference record type

49:
50: l_Rel_Item_Rec MTL_RELATED_ITEMS_PUB.Rel_Item_Rec_Type; -- declaring related items record type
51: l_Pln_Info_Rec MTL_RELATED_ITEMS_PUB.Pln_Info_Rec_Type; -- declating planning information record type
52: l_Pln_Info_Tbl MTL_RELATED_ITEMS_PUB.Pln_Info_Tbl_Type; -- declaring planning information table type
53: l_Cust_Ref_Rec MTL_RELATED_ITEMS_PUB.Cust_Ref_Rec_Type; -- declating customer reference record type
54: l_Cust_Ref_Tbl MTL_RELATED_ITEMS_PUB.Cust_Ref_Tbl_Type; -- declaring customer reference table type
55:
56: Returned_Row_Id VARCHAR2(30);
57:

Line 54: l_Cust_Ref_Tbl MTL_RELATED_ITEMS_PUB.Cust_Ref_Tbl_Type; -- declaring customer reference table type

50: l_Rel_Item_Rec MTL_RELATED_ITEMS_PUB.Rel_Item_Rec_Type; -- declaring related items record type
51: l_Pln_Info_Rec MTL_RELATED_ITEMS_PUB.Pln_Info_Rec_Type; -- declating planning information record type
52: l_Pln_Info_Tbl MTL_RELATED_ITEMS_PUB.Pln_Info_Tbl_Type; -- declaring planning information table type
53: l_Cust_Ref_Rec MTL_RELATED_ITEMS_PUB.Cust_Ref_Rec_Type; -- declating customer reference record type
54: l_Cust_Ref_Tbl MTL_RELATED_ITEMS_PUB.Cust_Ref_Tbl_Type; -- declaring customer reference table type
55:
56: Returned_Row_Id VARCHAR2(30);
57:
58:

Line 73: FROM mtl_related_items

69: ,c_related_item_id NUMBER
70: ,c_relationship_type_id NUMBER
71: ,c_organization_id NUMBER) IS
72: SELECT *
73: FROM mtl_related_items
74: WHERE
75: INVENTORY_ITEM_ID = c_inventory_item_id
76: AND RELATED_ITEM_ID = c_related_item_id
77: AND RELATIONSHIP_TYPE_ID = c_relationship_type_id

Line 80: l_mtl_Rel_Item_rec MTL_RELATED_ITEMS%ROWTYPE; -- For fetching the data of above cursor

76: AND RELATED_ITEM_ID = c_related_item_id
77: AND RELATIONSHIP_TYPE_ID = c_relationship_type_id
78: AND ORGANIZATION_ID = c_organization_id;
79:
80: l_mtl_Rel_Item_rec MTL_RELATED_ITEMS%ROWTYPE; -- For fetching the data of above cursor
81:
82:
83: -- cursor for locking the record while updating and deleting
84: CURSOR mtl_rel_item_lock_b

Line 129: FROM MTL_RELATED_ITEMS

125: ,ATTR_DATE8
126: ,ATTR_DATE9
127: ,ATTR_DATE10
128: ,PLANNING_ENABLED_FLAG
129: FROM MTL_RELATED_ITEMS
130: WHERE INVENTORY_ITEM_ID = c_inventory_item_id
131: AND RELATED_ITEM_ID = c_related_item_id
132: AND RELATIONSHIP_TYPE_ID = c_relationship_type_id
133: AND ORGANIZATION_ID = c_organization_id

Line 148: FROM mtl_related_items_pln_info

144: ,c_related_item_id NUMBER
145: ,c_relationship_type_id NUMBER
146: ,c_organization_id NUMBER) IS
147: SELECT *
148: FROM mtl_related_items_pln_info
149: WHERE
150: INVENTORY_ITEM_ID = c_inventory_item_id
151: AND RELATED_ITEM_ID = c_related_item_id
152: AND RELATIONSHIP_TYPE_ID = c_relationship_type_id

Line 163: FROM mtl_related_items_pln_info

159: ,c_relationship_type_id NUMBER
160: ,c_organization_id NUMBER
161: ,c_pln_info_id NUMBER) IS
162: SELECT *
163: FROM mtl_related_items_pln_info
164: WHERE
165: INVENTORY_ITEM_ID = c_inventory_item_id
166: AND RELATED_ITEM_ID = c_related_item_id
167: AND RELATIONSHIP_TYPE_ID = c_relationship_type_id

Line 171: l_mtl_Rel_Item_Pln_Info_rec MTL_RELATED_ITEMS_PLN_INFO%ROWTYPE; -- For fetching the data of above cursor

167: AND RELATIONSHIP_TYPE_ID = c_relationship_type_id
168: AND ORGANIZATION_ID = c_organization_id
169: AND PLN_INFO_ID = c_pln_info_id;
170:
171: l_mtl_Rel_Item_Pln_Info_rec MTL_RELATED_ITEMS_PLN_INFO%ROWTYPE; -- For fetching the data of above cursor
172:
173:
174: -- cursor for locking the record while updating and deleting
175: CURSOR mtl_rel_item_pln_info_lock_b

Line 192: FROM MTL_RELATED_ITEMS_PLN_INFO

188: ,END_DATE
189: ,SUBSTITUTION_SET
190: ,PARTIAL_FULFILLMENT_FLAG
191: ,ALL_CUSTOMERS_FLAG
192: FROM MTL_RELATED_ITEMS_PLN_INFO
193: WHERE
194: INVENTORY_ITEM_ID = c_inventory_item_id
195: AND RELATED_ITEM_ID = c_related_item_id
196: AND RELATIONSHIP_TYPE_ID = c_relationship_type_id

Line 212: FROM mtl_related_items_cust_ref

208: ,c_related_item_id NUMBER
209: ,c_relationship_type_id NUMBER
210: ,c_organization_id NUMBER) IS
211: SELECT *
212: FROM mtl_related_items_cust_ref
213: WHERE
214: INVENTORY_ITEM_ID = c_inventory_item_id
215: AND RELATED_ITEM_ID = c_related_item_id
216: AND RELATIONSHIP_TYPE_ID = C_RELATIONSHIP_TYPE_ID

Line 229: FROM mtl_related_items_cust_ref

225: ,c_pln_info_id NUMBER
226: ,c_customer_id NUMBER
227: ,c_site_use_id NUMBER) IS
228: SELECT *
229: FROM mtl_related_items_cust_ref
230: WHERE
231: INVENTORY_ITEM_ID = c_inventory_item_id
232: AND RELATED_ITEM_ID = c_related_item_id
233: AND RELATIONSHIP_TYPE_ID = c_relationship_type_id

Line 239: l_mtl_Rel_Item_Cust_Ref_rec MTL_RELATED_ITEMS_CUST_REF%ROWTYPE; -- For fetching the data of above cursor

235: AND PLN_INFO_ID = c_pln_info_id
236: AND CUSTOMER_ID = c_customer_id
237: AND SITE_USE_ID = c_site_use_id;
238:
239: l_mtl_Rel_Item_Cust_Ref_rec MTL_RELATED_ITEMS_CUST_REF%ROWTYPE; -- For fetching the data of above cursor
240:
241: -- cursor for locking the record while updating and deleting
242: CURSOR mtl_rel_item_cust_ref_lock_b
243: (c_inventory_item_id NUMBER

Line 260: FROM MTL_RELATED_ITEMS_CUST_REF

256: ,CUSTOMER_ID
257: ,SITE_USE_ID
258: ,START_DATE
259: ,END_DATE
260: FROM MTL_RELATED_ITEMS_CUST_REF
261: WHERE
262: INVENTORY_ITEM_ID = c_inventory_item_id
263: AND RELATED_ITEM_ID = c_related_item_id
264: AND RELATIONSHIP_TYPE_ID = c_relationship_type_id

Line 277: SAVEPOINT MTL_RELATED_ITEMS_PVT;

273:
274:
275: BEGIN
276:
277: SAVEPOINT MTL_RELATED_ITEMS_PVT;
278: x_return_status := FND_API.G_RET_STS_SUCCESS;
279: l_Rel_Item_Rec := p_Rel_Item_Rec;
280: l_Pln_Info_Tbl := p_Pln_Info_Tbl;
281: l_Cust_Ref_Tbl := p_Cust_Ref_Tbl;

Line 384: ,p_table_name => 'MTL_RELATED_ITEMS'

380: ,p_application_id => 'INV'
381: ,p_message_type => 'E'
382: ,p_entity_code => G_Entity_Code
383: ,p_entity_index => 1
384: ,p_table_name => 'MTL_RELATED_ITEMS'
385: );
386: RAISE VALIDATION_ERROR;
387: END IF;
388: END IF;

Line 604: ,p_table_name => 'MTL_RELATED_ITEMS'

600: ,p_application_id => 'EGO'
601: ,p_message_type => 'E'
602: ,p_entity_code => G_Entity_Code
603: ,p_entity_index => 1
604: ,p_table_name => 'MTL_RELATED_ITEMS'
605: );
606: RAISE VALIDATION_ERROR;
607: END IF;
608:

Line 624: ,p_table_name => 'MTL_RELATED_ITEMS'

620: ,p_application_id => 'EGO'
621: ,p_message_type => 'E'
622: ,p_entity_code => G_Entity_Code
623: ,p_entity_index => 1
624: ,p_table_name => 'MTL_RELATED_ITEMS'
625: );
626: RAISE VALIDATION_ERROR;
627: END IF;
628:

Line 749: ,p_table_name => 'MTL_RELATED_ITEMS'

745: ,p_application_id => 'EGO'
746: ,p_message_type => 'E'
747: ,p_entity_code => G_Entity_Code
748: ,p_entity_index => 1
749: ,p_table_name => 'MTL_RELATED_ITEMS'
750: );
751: RAISE VALIDATION_ERROR;
752: END IF;
753:

Line 764: FROM mtl_related_items

760: -- checking that item and relationship type combination is unique
761:
762: BEGIN
763: SELECT 'x' INTO l_rel_exists
764: FROM mtl_related_items
765: WHERE (INVENTORY_ITEM_ID = l_Rel_Item_Rec.INVENTORY_ITEM_ID
766: AND RELATIONSHIP_TYPE_ID= l_Rel_Item_Rec.RELATIONSHIP_TYPE_ID
767: AND RELATED_ITEM_ID = l_Rel_Item_Rec.RELATED_ITEM_ID
768: AND ORGANIZATION_ID = l_Rel_Item_Rec.ORGANIZATION_ID)

Line 869: MTL_RELATED_ITEMS_PKG.INSERT_ROW(

865: FROM dual;
866:
867: Write_Debug('Creating Related Item record...');
868:
869: MTL_RELATED_ITEMS_PKG.INSERT_ROW(
870: X_ROWID => RETURNED_ROW_ID
871: ,X_INVENTORY_ITEM_ID => L_REL_ITEM_REC.INVENTORY_ITEM_ID
872: ,X_ORGANIZATION_ID => L_REL_ITEM_REC.ORGANIZATION_ID
873: ,X_RELATED_ITEM_ID => L_REL_ITEM_REC.RELATED_ITEM_ID

Line 1046: FROM mtl_related_items

1042: THEN
1043:
1044: BEGIN
1045: SELECT 'x' INTO l_rel_exists
1046: FROM mtl_related_items
1047: WHERE (INVENTORY_ITEM_ID = l_Rel_Item_Rec.INVENTORY_ITEM_ID
1048: AND RELATIONSHIP_TYPE_ID= l_Rel_Item_Rec.RELATIONSHIP_TYPE_ID_UPD_VAL
1049: AND RELATED_ITEM_ID = l_Rel_Item_Rec.RELATED_ITEM_ID_UPD_VAL
1050: AND ORGANIZATION_ID = l_Rel_Item_Rec.ORGANIZATION_ID)

Line 1092: FROM MTL_RELATED_ITEMS

1088: END;
1089: END IF;
1090:
1091: BEGIN SELECT ROWID INTO Returned_Row_Id
1092: FROM MTL_RELATED_ITEMS
1093: WHERE INVENTORY_ITEM_ID = L_REL_ITEM_REC.INVENTORY_ITEM_ID
1094: AND ORGANIZATION_ID = L_REL_ITEM_REC.ORGANIZATION_ID
1095: AND RELATED_ITEM_ID = L_REL_ITEM_REC.RELATED_ITEM_ID
1096: AND RELATIONSHIP_TYPE_ID = L_REL_ITEM_REC.RELATIONSHIP_TYPE_ID;

Line 1121: MTL_RELATED_ITEMS_PKG.UPDATE_ROW(

1117:
1118: end if ;
1119:
1120: -- calling update
1121: MTL_RELATED_ITEMS_PKG.UPDATE_ROW(
1122: X_ROWID => Returned_Row_Id
1123: ,X_INVENTORY_ITEM_ID => l_Rel_Item_Rec.Inventory_Item_Id
1124: ,X_ORGANIZATION_ID => l_Rel_Item_Rec.Organization_Id
1125: ,X_RELATED_ITEM_ID => l_Rel_Item_Rec.Related_Item_Id

Line 1222: FROM MTL_RELATED_ITEMS

1218: FETCH mtl_rel_item_lock_b INTO l_lock_b_recinfo;
1219: CLOSE mtl_rel_item_lock_b;
1220:
1221: BEGIN SELECT ROWID INTO Returned_Row_Id
1222: FROM MTL_RELATED_ITEMS
1223: WHERE INVENTORY_ITEM_ID = L_REL_ITEM_REC.INVENTORY_ITEM_ID
1224: AND ORGANIZATION_ID = L_REL_ITEM_REC.ORGANIZATION_ID
1225: AND RELATED_ITEM_ID = L_REL_ITEM_REC.RELATED_ITEM_ID
1226: AND RELATIONSHIP_TYPE_ID = L_REL_ITEM_REC.RELATIONSHIP_TYPE_ID;

Line 1231: Mtl_Related_Items_Pkg.Delete_Row(

1227: END;
1228:
1229: Write_Debug('Deleting Related Item record...');
1230: -- calling delete
1231: Mtl_Related_Items_Pkg.Delete_Row(
1232: X_ROWID => RETURNED_ROW_ID);
1233:
1234: -- raising post business event
1235: BEGIN

Line 1259: MTL_RELATED_ITEMS_PLN_INFO_PKG.LOCK_ROW(

1255: ,l_Rel_Item_Rec.RELATIONSHIP_TYPE_ID
1256: ,l_Rel_Item_Rec.ORGANIZATION_ID) LOOP
1257:
1258: -- locking the row
1259: MTL_RELATED_ITEMS_PLN_INFO_PKG.LOCK_ROW(
1260: P_PLN_INFO_ID => l_mtl_Rel_Item_Pln_Info_rec.Pln_Info_Id
1261: ,P_INVENTORY_ITEM_ID => l_mtl_Rel_Item_Pln_Info_rec.Inventory_Item_Id
1262: ,P_ORGANIZATION_ID => l_mtl_Rel_Item_Pln_Info_rec.Organization_Id
1263: ,P_Related_Item_Id => l_mtl_Rel_Item_Pln_Info_rec.Related_Item_Id

Line 1273: MTL_RELATED_ITEMS_PLN_INFO_PKG.DELETE_ROW(

1269: ,P_ALL_CUSTOMERS_FLAG => l_mtl_Rel_Item_Pln_Info_rec.All_Customers_Flag);
1270:
1271: Write_Debug('Deleting associated substitution set...');
1272:
1273: MTL_RELATED_ITEMS_PLN_INFO_PKG.DELETE_ROW(
1274: P_PLN_INFO_ID => l_mtl_Rel_Item_Pln_Info_rec.Pln_Info_Id
1275: ,P_INVENTORY_ITEM_ID => l_mtl_Rel_Item_Pln_Info_rec.Inventory_Item_Id
1276: ,P_ORGANIZATION_ID => l_mtl_Rel_Item_Pln_Info_rec.Organization_Id
1277: ,P_RELATED_ITEM_ID => l_mtl_Rel_Item_Pln_Info_rec.Related_Item_Id

Line 1292: MTL_RELATED_ITEMS_CUST_REF_PKG.LOCK_ROW(

1288: ,l_Cust_Ref_Rec.RELATIONSHIP_TYPE_ID
1289: ,l_Cust_Ref_Rec.ORGANIZATION_ID) LOOP
1290:
1291: -- locking the row
1292: MTL_RELATED_ITEMS_CUST_REF_PKG.LOCK_ROW(
1293: P_PLN_INFO_ID => l_mtl_Rel_Item_Cust_Ref_rec.Pln_Info_Id
1294: ,P_INVENTORY_ITEM_ID => l_mtl_Rel_Item_Cust_Ref_rec.Inventory_Item_Id
1295: ,P_ORGANIZATION_ID => l_mtl_Rel_Item_Cust_Ref_rec.Organization_Id
1296: ,P_RELATED_ITEM_ID => l_mtl_Rel_Item_Cust_Ref_rec.Related_Item_Id

Line 1306: MTL_RELATED_ITEMS_CUST_REF_PKG.DELETE_ROW(

1302:
1303:
1304: Write_Debug('Deleting associated customer references...');
1305:
1306: MTL_RELATED_ITEMS_CUST_REF_PKG.DELETE_ROW(
1307: P_PLN_INFO_ID => l_mtl_Rel_Item_Cust_Ref_rec.Pln_Info_Id
1308: ,P_INVENTORY_ITEM_ID => l_mtl_Rel_Item_Cust_Ref_rec.Inventory_Item_Id
1309: ,P_ORGANIZATION_ID => l_mtl_Rel_Item_Cust_Ref_rec.Organization_Id
1310: ,P_RELATED_ITEM_ID => l_mtl_Rel_Item_Cust_Ref_rec.Related_Item_Id

Line 1372: ,P_Table_Name => 'MTL_RELATED_ITEMS_PLN_INFO'

1368: ,p_application_id => 'EGO'
1369: ,p_message_type => 'E'
1370: ,p_entity_code => G_Entity_Code
1371: ,p_entity_index => 1
1372: ,P_Table_Name => 'MTL_RELATED_ITEMS_PLN_INFO'
1373: );
1374: RAISE VALIDATION_ERROR;
1375: END IF;
1376:

Line 1414: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'

1410: ,p_application_id => 'EGO'
1411: ,p_message_type => 'E'
1412: ,p_entity_code => G_Entity_Code
1413: ,p_entity_index => l_Pln_Info_Indx
1414: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'
1415: );
1416: RAISE VALIDATION_ERROR;
1417: END IF;
1418:

Line 1435: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'

1431: ,p_application_id => 'EGO'
1432: ,p_message_type => 'E'
1433: ,p_entity_code => G_Entity_Code
1434: ,p_entity_index => l_Pln_Info_Indx
1435: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'
1436: );
1437: CLOSE mtl_pln_info_cur;
1438: RAISE VALIDATION_ERROR;
1439: END IF;

Line 1476: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'

1472: ,p_application_id => 'EGO'
1473: ,p_message_type => 'E'
1474: ,p_entity_code => G_Entity_Code
1475: ,p_entity_index => l_Pln_Info_Indx
1476: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'
1477: );
1478: RAISE VALIDATION_ERROR;
1479: END IF;
1480: END IF;

Line 1493: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'

1489: ,p_application_id => 'EGO'
1490: ,p_message_type => 'E'
1491: ,p_entity_code => G_Entity_Code
1492: ,p_entity_index => l_Pln_Info_Indx
1493: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'
1494: );
1495: RAISE VALIDATION_ERROR;
1496: END IF;
1497: END IF;

Line 1511: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'

1507: ,p_application_id => 'EGO'
1508: ,p_message_type => 'E'
1509: ,p_entity_code => G_Entity_Code
1510: ,p_entity_index => l_Pln_Info_Indx
1511: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'
1512: );
1513: RAISE VALIDATION_ERROR;
1514: END IF;
1515: END IF;

Line 1535: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'

1531: ,p_application_id => 'EGO'
1532: ,p_message_type => 'E'
1533: ,p_entity_code => G_Entity_Code
1534: ,p_entity_index => l_Pln_Info_Indx
1535: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'
1536: );
1537: RAISE VALIDATION_ERROR;
1538: END IF;
1539:

Line 1556: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'

1552: ,p_application_id => 'EGO'
1553: ,p_message_type => 'E'
1554: ,p_entity_code => G_Entity_Code
1555: ,p_entity_index => l_Pln_Info_Indx
1556: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'
1557: );
1558: RAISE VALIDATION_ERROR;
1559: END IF;
1560:

Line 1565: MTL_RELATED_ITEMS_PLN_INFO_PKG.INSERT_ROW(

1561: IF l_Pln_Info_Rec.TRANSACTION_TYPE = 'CREATE' THEN
1562:
1563: Write_Debug('Creating associated substitution set...');
1564:
1565: MTL_RELATED_ITEMS_PLN_INFO_PKG.INSERT_ROW(
1566: P_INVENTORY_ITEM_ID => l_Pln_Info_Rec.Inventory_Item_Id
1567: ,P_ORGANIZATION_ID => l_Pln_Info_Rec.Organization_Id
1568: ,P_RELATED_ITEM_ID => l_Pln_Info_Rec.Related_Item_Id
1569: ,P_RELATIONSHIP_TYPE_ID => l_Pln_Info_Rec.Relationship_Type_Id

Line 1607: MTL_RELATED_ITEMS_PLN_INFO_PKG.UPDATE_ROW(

1603: CLOSE mtl_rel_item_pln_info_lock_b;
1604:
1605: Write_Debug('Updating associated substitution set...');
1606:
1607: MTL_RELATED_ITEMS_PLN_INFO_PKG.UPDATE_ROW(
1608: P_PLN_INFO_ID => l_Pln_Info_Rec.Pln_Info_Id
1609: ,P_INVENTORY_ITEM_ID => l_Pln_Info_Rec.Inventory_Item_Id
1610: ,P_ORGANIZATION_ID => l_Pln_Info_Rec.Organization_Id
1611: ,P_RELATED_ITEM_ID => l_Pln_Info_Rec.Related_Item_Id

Line 1677: ,P_Table_Name => 'MTL_RELATED_ITEMS_PLN_INFO'

1673: ,p_application_id => 'EGO'
1674: ,p_message_type => 'E'
1675: ,p_entity_code => G_Entity_Code
1676: ,p_entity_index => 1
1677: ,P_Table_Name => 'MTL_RELATED_ITEMS_PLN_INFO'
1678: );
1679: RAISE VALIDATION_ERROR;
1680: END IF;
1681:

Line 1710: FROM mtl_related_items_cust_ref

1706: FROM dual;
1707:
1708: -- checking if customer and site combinations already exists
1709: SELECT 'x' INTO l_cust_ref_exists
1710: FROM mtl_related_items_cust_ref
1711: WHERE Inventory_Item_Id = l_Cust_Ref_Rec.INVENTORY_ITEM_ID
1712: AND Related_Item_Id = l_Cust_Ref_Rec.RELATED_ITEM_ID
1713: AND Relationship_Type_Id = l_Cust_Ref_Rec.RELATIONSHIP_TYPE_ID
1714: AND Pln_Info_Id = l_Cust_Ref_Rec.PLN_INFO_ID

Line 1751: ,p_table_name => 'MTL_RELATED_ITEMS_CUST_REF'

1747: ,p_token_tbl => l_Token_Tbl
1748: ,p_message_type => 'E'
1749: ,p_entity_code => G_Entity_Code
1750: ,p_entity_index => l_Cust_Ref_Indx
1751: ,p_table_name => 'MTL_RELATED_ITEMS_CUST_REF'
1752: );
1753: RAISE VALIDATION_ERROR;
1754: END IF;
1755: EXCEPTION

Line 1780: ,p_table_name => 'MTL_RELATED_ITEMS_CUST_REF'

1776: ,p_application_id => 'EGO'
1777: ,p_message_type => 'E'
1778: ,p_entity_code => G_Entity_Code
1779: ,p_entity_index => l_Cust_Ref_Indx
1780: ,p_table_name => 'MTL_RELATED_ITEMS_CUST_REF'
1781: );
1782: CLOSE mtl_cust_ref_cur;
1783: RAISE VALIDATION_ERROR;
1784: END IF;

Line 1838: ,p_table_name => 'MTL_RELATED_ITEMS_CUST_REF'

1834: ,p_application_id => 'EGO'
1835: ,p_message_type => 'E'
1836: ,p_entity_code => G_Entity_Code
1837: ,p_entity_index => l_Cust_Ref_Indx
1838: ,p_table_name => 'MTL_RELATED_ITEMS_CUST_REF'
1839: );
1840: RAISE VALIDATION_ERROR;
1841: END;
1842:

Line 1860: ,p_table_name => 'MTL_RELATED_ITEMS_CUST_REF'

1856: ,p_token_tbl => l_Token_Tbl
1857: ,p_message_type => 'E'
1858: ,p_entity_code => G_Entity_Code
1859: ,p_entity_index => l_Cust_Ref_Indx
1860: ,p_table_name => 'MTL_RELATED_ITEMS_CUST_REF'
1861: );
1862: RAISE VALIDATION_ERROR;
1863: END IF;
1864: END IF;

Line 1878: ,p_table_name => 'MTL_RELATED_ITEMS_CUST_REF'

1874: ,p_token_tbl => l_Token_Tbl
1875: ,p_message_type => 'E'
1876: ,p_entity_code => G_Entity_Code
1877: ,p_entity_index => l_Cust_Ref_Indx
1878: ,p_table_name => 'MTL_RELATED_ITEMS_CUST_REF'
1879: );
1880: RAISE VALIDATION_ERROR;
1881: END IF;
1882: END IF;

Line 1895: ,p_table_name => 'MTL_RELATED_ITEMS_CUST_REF'

1891: ,p_application_id => 'EGO'
1892: ,p_message_type => 'E'
1893: ,p_entity_code => G_Entity_Code
1894: ,p_entity_index => l_Cust_Ref_Indx
1895: ,p_table_name => 'MTL_RELATED_ITEMS_CUST_REF'
1896: );
1897: RAISE VALIDATION_ERROR;
1898: END IF;
1899: END IF;

Line 1908: MTL_RELATED_ITEMS_CUST_REF_PKG.INSERT_ROW(

1904:
1905: Write_Debug('Creating associated customer reference...');
1906:
1907: BEGIN
1908: MTL_RELATED_ITEMS_CUST_REF_PKG.INSERT_ROW(
1909: P_PLN_INFO_ID => l_Cust_Ref_Rec.Pln_Info_Id
1910: ,P_INVENTORY_ITEM_ID => l_Cust_Ref_Rec.Inventory_Item_Id
1911: ,P_ORGANIZATION_ID => l_Cust_Ref_Rec.Organization_Id
1912: ,P_RELATED_ITEM_ID => l_Cust_Ref_Rec.Related_Item_Id

Line 1948: MTL_RELATED_ITEMS_CUST_REF_PKG.UPDATE_ROW(

1944: CLOSE mtl_rel_item_cust_ref_lock_b;
1945:
1946: Write_Debug('Updating associated customer reference...');
1947:
1948: MTL_RELATED_ITEMS_CUST_REF_PKG.UPDATE_ROW(
1949: P_PLN_INFO_ID => l_Cust_Ref_Rec.Pln_Info_Id
1950: ,P_INVENTORY_ITEM_ID => l_Cust_Ref_Rec.Inventory_Item_Id
1951: ,P_ORGANIZATION_ID => l_Cust_Ref_Rec.Organization_Id
1952: ,P_RELATED_ITEM_ID => l_Cust_Ref_Rec.Related_Item_Id

Line 1988: ,p_table_name => 'MTL_RELATED_ITEMS_CUST_REF'

1984: ,p_application_id => 'EGO'
1985: ,p_message_type => 'E'
1986: ,p_entity_code => G_Entity_Code
1987: ,p_entity_index => l_Cust_Ref_Indx
1988: ,p_table_name => 'MTL_RELATED_ITEMS_CUST_REF'
1989: );
1990: CLOSE mtl_cust_ref_cur;
1991: RAISE VALIDATION_ERROR;
1992: END IF;

Line 2008: MTL_RELATED_ITEMS_CUST_REF_PKG.DELETE_ROW(

2004: CLOSE mtl_rel_item_cust_ref_lock_b;
2005:
2006: Write_Debug('Deleting associated customer reference...');
2007: -- calling delete
2008: MTL_RELATED_ITEMS_CUST_REF_PKG.DELETE_ROW(
2009: P_PLN_INFO_ID => l_Cust_Ref_Rec.Pln_Info_Id
2010: ,P_INVENTORY_ITEM_ID => l_Cust_Ref_Rec.Inventory_Item_Id
2011: ,P_ORGANIZATION_ID => l_Cust_Ref_Rec.Organization_Id
2012: ,P_RELATED_ITEM_ID => l_Cust_Ref_Rec.Related_Item_Id

Line 2028: ,p_table_name => 'MTL_RELATED_ITEMS_CUST_REF'

2024: ,p_application_id => 'EGO'
2025: ,p_message_type => 'E'
2026: ,p_entity_code => G_Entity_Code
2027: ,p_entity_index => l_Cust_Ref_Indx
2028: ,p_table_name => 'MTL_RELATED_ITEMS_CUST_REF'
2029: );
2030: RAISE VALIDATION_ERROR;
2031: End If; -- primary keys of cust ref are not provided
2032: END LOOP; -- cust ref loop

Line 2051: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'

2047: ,p_application_id => 'EGO'
2048: ,p_message_type => 'E'
2049: ,p_entity_code => G_Entity_Code
2050: ,p_entity_index => l_Pln_Info_Indx
2051: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'
2052: );
2053: RAISE VALIDATION_ERROR;
2054: END IF;
2055:

Line 2058: FROM mtl_related_items_cust_ref

2054: END IF;
2055:
2056: BEGIN
2057: SELECT 'x' INTO l_cust_ref_exists
2058: FROM mtl_related_items_cust_ref
2059: WHERE (INVENTORY_ITEM_ID = l_Pln_Info_Rec.INVENTORY_ITEM_ID
2060: AND RELATIONSHIP_TYPE_ID= l_Pln_Info_Rec.RELATIONSHIP_TYPE_ID
2061: AND RELATED_ITEM_ID = l_Pln_Info_Rec.RELATED_ITEM_ID
2062: AND ORGANIZATION_ID = l_Pln_Info_Rec.ORGANIZATION_ID

Line 2093: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'

2089: ,p_token_tbl => l_Token_Tbl
2090: ,p_message_type => 'E'
2091: ,p_entity_code => G_Entity_Code
2092: ,p_entity_index => l_Pln_Info_Indx
2093: ,p_table_name => 'MTL_RELATED_ITEMS_PLN_INFO'
2094: );
2095: RAISE VALIDATION_ERROR;
2096: END IF;
2097: EXCEPTION

Line 2103: MTL_RELATED_ITEMS_PLN_INFO_PKG.DELETE_ROW(

2099: -- calling delete
2100:
2101: Write_Debug('Deleting associated substitution set...');
2102:
2103: MTL_RELATED_ITEMS_PLN_INFO_PKG.DELETE_ROW(
2104: P_PLN_INFO_ID => l_Pln_Info_Rec.Pln_Info_Id
2105: ,P_INVENTORY_ITEM_ID => l_Pln_Info_Rec.Inventory_Item_Id
2106: ,P_ORGANIZATION_ID => l_Pln_Info_Rec.Organization_Id
2107: ,P_RELATED_ITEM_ID => l_Pln_Info_Rec.Related_Item_Id

Line 2124: ,P_TABLE_NAME => 'MTL_RELATED_ITEMS_PLN_INFO'

2120: ,p_application_id => 'EGO'
2121: ,p_message_type => 'E'
2122: ,p_entity_code => G_Entity_Code
2123: ,P_ENTITY_INDEX => 1
2124: ,P_TABLE_NAME => 'MTL_RELATED_ITEMS_PLN_INFO'
2125: );
2126: END IF; -- passing in null primary key columns
2127: END LOOP; -- looping planning info
2128: END IF; -- if planning info table is not null

Line 2146: ROLLBACK TO MTL_RELATED_ITEMS_PVT; -- rollback to savepoint

2142: x_return_status:= FND_API.g_RET_STS_ERROR;
2143: l_msg_count := l_msg_count +1;
2144: Error_Handler.Get_Entity_Message(G_Entity_Code, x_msg_list);
2145:
2146: ROLLBACK TO MTL_RELATED_ITEMS_PVT; -- rollback to savepoint
2147: WHEN resource_busy THEN
2148:
2149: Error_Handler.Add_Error_message
2150: (

Line 2160: ROLLBACK TO MTL_RELATED_ITEMS_PVT; -- rollback to savepoint

2156: ,p_entity_index => 1
2157: ,p_table_name => G_Table_Name
2158: );
2159:
2160: ROLLBACK TO MTL_RELATED_ITEMS_PVT; -- rollback to savepoint
2161: x_return_status:= FND_API.g_RET_STS_ERROR;
2162: l_msg_count := l_msg_count +1;
2163: Error_Handler.Get_Entity_Message(G_Entity_Code, x_msg_list);
2164:

Line 2192: ROLLBACK TO MTL_RELATED_ITEMS_PVT; -- rollback to savepoint

2188: x_return_status:= FND_API.g_RET_STS_ERROR;
2189: l_msg_count := l_msg_count +1;
2190: Error_Handler.Get_Entity_Message(G_Entity_Code, x_msg_list);
2191:
2192: ROLLBACK TO MTL_RELATED_ITEMS_PVT; -- rollback to savepoint
2193:
2194: -- //END; -- internal begin for transactions
2195:
2196: p_Rel_Item_Rec := l_Rel_Item_Rec;

Line 2217: -- MTL_RELATED_ITEMS_INTERFACE for processing.

2213: -- -----------------------------------------------------------------------------
2214: -- Procedure Name: Process_Rel_Items_Rows
2215: --
2216: -- Description : Concurrent program to pull rows from
2217: -- MTL_RELATED_ITEMS_INTERFACE for processing.
2218: -- Does not support planning details.
2219: -- -----------------------------------------------------------------------------
2220: PROCEDURE Process_Rel_Items_Rows(
2221: ERRBUF OUT NOCOPY VARCHAR2,

Line 2234: l_Rel_Item_Rec MTL_RELATED_ITEMS_PUB.Rel_Item_Rec_Type;

2230: l_err_text VARCHAR2(255);
2231: l_dummyInt INTEGER;
2232: ret_code NUMBER;
2233: err_msg VARCHAR2(300);
2234: l_Rel_Item_Rec MTL_RELATED_ITEMS_PUB.Rel_Item_Rec_Type;
2235: l_Pln_Info_Tbl MTL_RELATED_ITEMS_PUB.Pln_Info_Tbl_Type;
2236: l_Cust_Ref_Tbl MTL_RELATED_ITEMS_PUB.Cust_Ref_Tbl_Type;
2237: l_proc_rec_count NUMBER;
2238: l_err_count NUMBER; -- to see if error msg exists

Line 2235: l_Pln_Info_Tbl MTL_RELATED_ITEMS_PUB.Pln_Info_Tbl_Type;

2231: l_dummyInt INTEGER;
2232: ret_code NUMBER;
2233: err_msg VARCHAR2(300);
2234: l_Rel_Item_Rec MTL_RELATED_ITEMS_PUB.Rel_Item_Rec_Type;
2235: l_Pln_Info_Tbl MTL_RELATED_ITEMS_PUB.Pln_Info_Tbl_Type;
2236: l_Cust_Ref_Tbl MTL_RELATED_ITEMS_PUB.Cust_Ref_Tbl_Type;
2237: l_proc_rec_count NUMBER;
2238: l_err_count NUMBER; -- to see if error msg exists
2239:

Line 2236: l_Cust_Ref_Tbl MTL_RELATED_ITEMS_PUB.Cust_Ref_Tbl_Type;

2232: ret_code NUMBER;
2233: err_msg VARCHAR2(300);
2234: l_Rel_Item_Rec MTL_RELATED_ITEMS_PUB.Rel_Item_Rec_Type;
2235: l_Pln_Info_Tbl MTL_RELATED_ITEMS_PUB.Pln_Info_Tbl_Type;
2236: l_Cust_Ref_Tbl MTL_RELATED_ITEMS_PUB.Cust_Ref_Tbl_Type;
2237: l_proc_rec_count NUMBER;
2238: l_err_count NUMBER; -- to see if error msg exists
2239:
2240: -- Adding to derive these based on the organization_code , related_item_name and item_number columns

Line 2253: FROM MTL_RELATED_ITEMS_INTERFACE A

2249: -- or all records if parameter is NULL
2250: -- and process flag is 1
2251: CURSOR C_INTF_ROWS(C_DATA_SET_ID NUMBER) IS
2252: SELECT A.ROWID,A.*
2253: FROM MTL_RELATED_ITEMS_INTERFACE A
2254: WHERE DECODE(C_DATA_SET_ID, NULL, -1, A.SET_PROCESS_ID) = NVL(C_DATA_SET_ID, -1)
2255: AND a.PROCESS_FLAG = 1;
2256:
2257: BEGIN

Line 2268: UPDATE MTL_RELATED_ITEMS_INTERFACE

2264:
2265: L_PROC_REC_COUNT := 0;
2266:
2267: FOR L_MTL_REL_ITEM_REC IN C_INTF_ROWS(P_DATA_SET_ID) LOOP
2268: UPDATE MTL_RELATED_ITEMS_INTERFACE
2269: SET TRANSACTION_ID = MTL_RELATED_ITEMS_INTERFACE_S.NEXTVAL,
2270: REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID
2271: WHERE ROWID = l_mtl_Rel_Item_rec.ROWID;
2272: END LOOP;

Line 2269: SET TRANSACTION_ID = MTL_RELATED_ITEMS_INTERFACE_S.NEXTVAL,

2265: L_PROC_REC_COUNT := 0;
2266:
2267: FOR L_MTL_REL_ITEM_REC IN C_INTF_ROWS(P_DATA_SET_ID) LOOP
2268: UPDATE MTL_RELATED_ITEMS_INTERFACE
2269: SET TRANSACTION_ID = MTL_RELATED_ITEMS_INTERFACE_S.NEXTVAL,
2270: REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID
2271: WHERE ROWID = l_mtl_Rel_Item_rec.ROWID;
2272: END LOOP;
2273:

Line 2303: ,p_table_name => 'MTL_RELATED_ITEMS_INTERFACE'

2299: ,p_application_id => 'EGO'
2300: ,p_message_type => 'E'
2301: ,p_entity_code => G_Entity_Code
2302: ,p_entity_index => 1
2303: ,p_table_name => 'MTL_RELATED_ITEMS_INTERFACE'
2304: );
2305:
2306: l_msg_count := 1;
2307: Error_Handler.Get_Entity_Message(G_Entity_Code, l_msg_list);

Line 2326: ,p_table_name => 'MTL_RELATED_ITEMS_INTERFACE'

2322: ,p_application_id => 'EGO'
2323: ,p_message_type => 'E'
2324: ,p_entity_code => G_Entity_Code
2325: ,p_entity_index => 1
2326: ,p_table_name => 'MTL_RELATED_ITEMS_INTERFACE'
2327: );
2328:
2329: l_msg_count := 1;
2330: Error_Handler.Get_Entity_Message(G_Entity_Code, l_msg_list);

Line 2358: ,p_table_name => 'MTL_RELATED_ITEMS_INTERFACE'

2354: ,p_application_id => 'EGO'
2355: ,p_message_type => 'E'
2356: ,p_entity_code => G_Entity_Code
2357: ,p_entity_index => 1
2358: ,p_table_name => 'MTL_RELATED_ITEMS_INTERFACE'
2359: );
2360:
2361: l_msg_count := 1;
2362: Error_Handler.Get_Entity_Message(G_Entity_Code, l_msg_list);

Line 2381: ,p_table_name => 'MTL_RELATED_ITEMS_INTERFACE'

2377: ,p_application_id => 'EGO'
2378: ,p_message_type => 'E'
2379: ,p_entity_code => G_Entity_Code
2380: ,p_entity_index => 1
2381: ,p_table_name => 'MTL_RELATED_ITEMS_INTERFACE'
2382: );
2383: l_msg_count := 1;
2384: Error_Handler.Get_Entity_Message(G_Entity_Code, l_msg_list);
2385:

Line 2412: ,p_table_name => 'MTL_RELATED_ITEMS_INTERFACE'

2408: ,p_application_id => 'EGO'
2409: ,p_message_type => 'E'
2410: ,p_entity_code => G_Entity_Code
2411: ,p_entity_index => 1
2412: ,p_table_name => 'MTL_RELATED_ITEMS_INTERFACE'
2413: );
2414:
2415: l_msg_count := 1;
2416: Error_Handler.Get_Entity_Message(G_Entity_Code, l_msg_list);

Line 2433: ,p_table_name => 'MTL_RELATED_ITEMS_INTERFACE'

2429: ,p_application_id => 'EGO'
2430: ,p_message_type => 'E'
2431: ,p_entity_code => G_Entity_Code
2432: ,p_entity_index => 1
2433: ,p_table_name => 'MTL_RELATED_ITEMS_INTERFACE'
2434: );
2435: l_msg_count := 1;
2436: Error_Handler.Get_Entity_Message(G_Entity_Code, l_msg_list);
2437:

Line 2497: Write_Debug('Calling MTL_RELATED_ITEMS_PVT.Process_Rel_Item for Transaction ' ||To_Char(l_mtl_Rel_Item_rec.Transaction_Id));

2493: --l_Rel_Item_Rec.CREATION_DATE := l_mtl_Rel_Item_rec.CREATION_DATE;
2494: --l_Rel_Item_Rec.CREATED_BY := l_mtl_Rel_Item_rec.CREATED_BY;
2495: --l_Rel_Item_Rec.LAST_UPDATE_LOGIN := l_mtl_Rel_Item_rec.LAST_UPDATE_LOGIN;
2496:
2497: Write_Debug('Calling MTL_RELATED_ITEMS_PVT.Process_Rel_Item for Transaction ' ||To_Char(l_mtl_Rel_Item_rec.Transaction_Id));
2498: MTL_RELATED_ITEMS_PVT.Process_Rel_Item
2499: (
2500: p_commit => FND_API.G_TRUE
2501: ,p_init_msg_list => FND_API.G_TRUE

Line 2498: MTL_RELATED_ITEMS_PVT.Process_Rel_Item

2494: --l_Rel_Item_Rec.CREATED_BY := l_mtl_Rel_Item_rec.CREATED_BY;
2495: --l_Rel_Item_Rec.LAST_UPDATE_LOGIN := l_mtl_Rel_Item_rec.LAST_UPDATE_LOGIN;
2496:
2497: Write_Debug('Calling MTL_RELATED_ITEMS_PVT.Process_Rel_Item for Transaction ' ||To_Char(l_mtl_Rel_Item_rec.Transaction_Id));
2498: MTL_RELATED_ITEMS_PVT.Process_Rel_Item
2499: (
2500: p_commit => FND_API.G_TRUE
2501: ,p_init_msg_list => FND_API.G_TRUE
2502: ,p_Rel_Item_Rec => l_Rel_Item_Rec

Line 2512: UPDATE MTL_RELATED_ITEMS_INTERFACE

2508: );
2509: END IF;
2510:
2511: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2512: UPDATE MTL_RELATED_ITEMS_INTERFACE
2513: SET process_flag = 3
2514: WHERE Transaction_Id = l_mtl_Rel_Item_rec.Transaction_Id;
2515:
2516: -- looping to take out the messages

Line 2534: ,tbl_name => 'MTL_RELATED_ITEMS_INTERFACE'

2530: ,req_id => fnd_global.conc_request_id
2531: ,trans_id => l_mtl_Rel_Item_rec.Transaction_Id
2532: ,error_text => l_msg.message_text
2533: ,p_column_name => null
2534: ,tbl_name => 'MTL_RELATED_ITEMS_INTERFACE'
2535: ,msg_name => l_msg.message_name
2536: ,err_text => l_err_text -- error text out
2537: );
2538: END LOOP;

Line 2546: UPDATE MTL_RELATED_ITEMS_INTERFACE

2542: l_err_count := 1;
2543:
2544: ELSE
2545: Write_Debug('Transaction ' ||To_Char(l_mtl_Rel_Item_rec.Transaction_Id)|| ' has completed successfully.');
2546: UPDATE MTL_RELATED_ITEMS_INTERFACE
2547: SET process_flag = 7
2548: WHERE Transaction_Id = l_mtl_Rel_Item_rec.Transaction_Id;
2549: END IF;
2550: END LOOP;

Line 2593: DELETE FROM MTL_RELATED_ITEMS_INTERFACE

2589:
2590: BEGIN
2591:
2592: LOOP
2593: DELETE FROM MTL_RELATED_ITEMS_INTERFACE
2594: WHERE process_flag = l_process_flag_7
2595: AND set_process_id=p_data_set_id
2596: AND rownum < l_rownum;
2597:

Line 2610: err_text := SUBSTR('MTL_RELATED_ITEMS_PVT.Del_Processed_Recs' || SQLERRM, 1,240);

2606:
2607: EXCEPTION
2608:
2609: WHEN OTHERS THEN
2610: err_text := SUBSTR('MTL_RELATED_ITEMS_PVT.Del_Processed_Recs' || SQLERRM, 1,240);
2611: RETURN (SQLCODE);
2612:
2613: END Del_Processed_Recs;
2614:

Line 2615: END MTL_RELATED_ITEMS_PVT;

2611: RETURN (SQLCODE);
2612:
2613: END Del_Processed_Recs;
2614:
2615: END MTL_RELATED_ITEMS_PVT;
2616: