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 ERROR_HANDLER

Line 36: ,x_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type) IS

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:
38: -- Local variable declariations
39: l_api_name VARCHAR2(30) := 'Process_Rel_Item';
40: l_prod_exists VARCHAR(1); -- for checking security when PIM is installed

Line 59: l_Token_Tbl Error_Handler.Token_Tbl_Type; -- For passing token in error msgs

55:
56: Returned_Row_Id VARCHAR2(30);
57:
58:
59: l_Token_Tbl Error_Handler.Token_Tbl_Type; -- For passing token in error msgs
60: l_msg_count NUMBER;
61: RETURNED_PLN_INFO_ID NUMBER;
62: VALIDATION_ERROR EXCEPTION;
63: resource_busy EXCEPTION;

Line 288: Error_Handler.Initialize;

284:
285:
286: -- Initialize message list
287: IF FND_API.To_Boolean (p_init_msg_list) THEN
288: Error_Handler.Initialize;
289: END IF;
290:
291: Write_Debug('Starting to process Related Item record...');
292:

Line 304: Error_Handler.Add_Error_message

300: l_Rel_Item_Rec.ORGANIZATION_ID IS NULL OR
301: l_Rel_Item_Rec.ORGANIZATION_ID = FND_API.G_MISS_NUM THEN
302:
303: x_return_status := FND_API.G_RET_STS_ERROR;
304: Error_Handler.Add_Error_message
305: (
306: p_message_name => 'EGO_REL_ITEM_NULL_COLS'
307: ,p_application_id => 'EGO'
308: ,p_message_type => 'E'

Line 325: Error_Handler.Add_Error_message

321: l_Rel_Item_Rec.Transaction_Type <> 'UPDATE' AND
322: l_Rel_Item_Rec.Transaction_Type <> 'DELETE') THEN
323:
324: x_return_status := FND_API.G_RET_STS_ERROR;
325: Error_Handler.Add_Error_message
326: (
327: p_message_name => 'EGO_REL_ITEM_INVALID_TRANS_TYP'
328: ,p_application_id => 'EGO'
329: ,p_message_type => 'E'

Line 377: Error_Handler.Add_Error_message

373: ,p_instance_pk1_value => l_Rel_Item_Rec.RELATED_ITEM_ID
374: ,p_instance_pk2_value => FND_GLOBAL.org_id
375: ,P_User_Id => FND_GLOBAL.user_id) <> 'T'
376: THEN
377: Error_Handler.Add_Error_message
378: (
379: p_message_name => 'INV_IOI_ITEM_UPDATE_PRIV'
380: ,p_application_id => 'INV'
381: ,p_message_type => 'E'

Line 409: Error_Handler.Add_Error_message

405: l_Token_Tbl(1).Token_Value := l_Rel_Item_Rec.ORGANIZATION_ID;
406: l_Token_Tbl(1).Translate := FALSE;
407:
408: x_return_status := FND_API.g_RET_STS_ERROR;
409: Error_Handler.Add_Error_message
410: (
411: p_message_name => 'EGO_MASTERORG_NOT_VALID'
412: ,p_application_id => 'EGO'
413: ,p_token_tbl => l_Token_Tbl

Line 442: Error_Handler.Add_Error_message

438: l_Token_Tbl(1).Token_Value := l_Rel_Item_Rec.INVENTORY_ITEM_ID;
439: l_Token_Tbl(1).Translate := FALSE;
440:
441: x_return_status := FND_API.g_RET_STS_ERROR;
442: Error_Handler.Add_Error_message
443: (
444: p_message_name => 'EGO_INV_ITEM_NOT_VALID'
445: ,p_application_id => 'EGO'
446: ,p_token_tbl => l_Token_Tbl

Line 475: Error_Handler.Add_Error_message

471: l_Token_Tbl(1).Token_Value := l_Rel_Item_Rec.RELATED_ITEM_ID;
472: l_Token_Tbl(1).Translate := FALSE;
473:
474: x_return_status := FND_API.g_RET_STS_ERROR;
475: Error_Handler.Add_Error_message
476: (
477: p_message_name => 'EGO_REL_ITEM_NOT_VALID'
478: ,p_application_id => 'EGO'
479: ,p_token_tbl => l_Token_Tbl

Line 506: Error_Handler.Add_Error_message

502: l_Token_Tbl(1).Token_Value := l_Rel_Item_Rec.RELATED_ITEM_ID_UPD_VAL;
503: l_Token_Tbl(1).Translate := FALSE;
504:
505: x_return_status := FND_API.g_RET_STS_ERROR;
506: Error_Handler.Add_Error_message
507: (
508: p_message_name => 'EGO_REL_ITEM_NOT_VALID'
509: ,p_application_id => 'EGO'
510: ,p_token_tbl => l_Token_Tbl

Line 541: Error_Handler.Add_Error_message

537: l_Token_Tbl(1).Token_Value := l_Rel_Item_Rec.RELATIONSHIP_TYPE_ID;
538: L_TOKEN_TBL(1).TRANSLATE := FALSE;
539:
540: x_return_status := FND_API.G_RET_STS_ERROR;
541: Error_Handler.Add_Error_message
542: (
543: p_message_name => 'EGO_REL_TYPE_NOT_VALID'
544: ,P_APPLICATION_ID => 'EGO'
545: ,p_token_tbl => l_Token_Tbl

Line 574: Error_Handler.Add_Error_message

570: l_Token_Tbl(1).Token_Value := l_Rel_Item_Rec.RELATIONSHIP_TYPE_ID_UPD_VAL;
571: L_TOKEN_TBL(1).TRANSLATE := FALSE;
572:
573: x_return_status := FND_API.G_RET_STS_ERROR;
574: Error_Handler.Add_Error_message
575: (
576: p_message_name => 'EGO_REL_TYPE_NOT_VALID'
577: ,P_APPLICATION_ID => 'EGO'
578: ,p_token_tbl => l_Token_Tbl

Line 597: Error_Handler.Add_Error_message

593: END IF;
594:
595: IF l_Rel_Item_Rec.RECIPROCAL_FLAG NOT IN ('Y','N') THEN
596: x_return_status := FND_API.G_RET_STS_ERROR;
597: Error_Handler.Add_Error_message
598: (
599: p_message_name => 'EGO_RECIPROCAL_FLAG_INVALID'
600: ,p_application_id => 'EGO'
601: ,p_message_type => 'E'

Line 617: Error_Handler.Add_Error_message

613: END IF;
614:
615: IF l_Rel_Item_Rec.PLANNING_ENABLED_FLAG NOT IN ('Y','N') THEN
616: x_return_status := FND_API.G_RET_STS_ERROR;
617: Error_Handler.Add_Error_message
618: (
619: p_message_name => 'EGO_PLN_ENABLED_FLAG_INVALID'
620: ,p_application_id => 'EGO'
621: ,p_message_type => 'E'

Line 639: Error_Handler.Add_Error_message

635: -- bug 14403205
636: IF (l_Rel_Item_Rec.INVENTORY_ITEM_ID = l_Rel_Item_Rec.RELATED_ITEM_ID) OR (l_Rel_Item_Rec.INVENTORY_ITEM_ID =
637: l_Rel_Item_Rec.RELATED_ITEM_ID_UPD_VAL) THEN
638: x_return_status := FND_API.G_RET_STS_ERROR;
639: Error_Handler.Add_Error_message
640: (
641: p_message_name => 'EGO_RELATE_TO_SELF'
642: ,p_application_id => 'EGO'
643: ,p_message_type => 'E'

Line 662: Error_Handler.Add_Error_message

658: (l_Rel_Item_Rec.START_DATE <> FND_API.G_MISS_DATE OR
659: l_Rel_Item_Rec.END_DATE <> FND_API.G_MISS_DATE)THEN
660:
661: x_return_status := FND_API.G_RET_STS_ERROR;
662: Error_Handler.Add_Error_message
663: (
664: p_message_name => 'EGO_REL_ITEM_DATE_INACTIVE'
665: ,p_application_id => 'EGO'
666: ,p_message_type => 'E'

Line 687: Error_Handler.Add_Error_message

683: l_Rel_Item_Rec.END_DATE <> FND_API.G_MISS_DATE THEN
684:
685: IF l_Rel_Item_Rec.END_DATE < l_Rel_Item_Rec.START_DATE THEN
686: x_return_status := FND_API.G_RET_STS_ERROR;
687: Error_Handler.Add_Error_message
688: (
689: p_message_name => 'EGO_STARTDATE_PRECEDES_ENDDATE'
690: ,p_application_id => 'EGO'
691: ,p_message_type => 'E'

Line 704: Error_Handler.Add_Error_message

700: IF l_Rel_Item_Rec.START_DATE IS NOT NULL
701: AND l_Rel_Item_Rec.START_DATE <> FND_API.G_MISS_DATE THEN
702: IF l_Rel_Item_Rec.START_DATE < SYSDATE THEN
703: x_return_status := FND_API.G_RET_STS_ERROR;
704: Error_Handler.Add_Error_message
705: (
706: p_message_name => 'EGO_SELECTED_DATE_INVALID'
707: ,p_application_id => 'EGO'
708: ,p_message_type => 'E'

Line 721: Error_Handler.Add_Error_message

717: IF l_Rel_Item_Rec.END_DATE IS NOT NULL
718: AND l_Rel_Item_Rec.END_DATE <> FND_API.G_MISS_DATE THEN
719: IF l_Rel_Item_Rec.END_DATE < SYSDATE THEN
720: x_return_status := FND_API.G_RET_STS_ERROR;
721: Error_Handler.Add_Error_message
722: (
723: p_message_name => 'EGO_SELECTED_DATE_INVALID'
724: ,p_application_id => 'EGO'
725: ,p_message_type => 'E'

Line 742: Error_Handler.Add_Error_message

738: IF l_Rel_Item_Rec.PLANNING_ENABLED_FLAG ='Y' AND
739: (l_Rel_Item_Rec.RELATIONSHIP_TYPE_ID<>2 OR (l_Rel_Item_Rec.RELATIONSHIP_TYPE_ID_UPD_VAL<>2 AND l_Rel_Item_Rec.RELATIONSHIP_TYPE_ID_UPD_VAL<>FND_API.G_MISS_NUM))THEN
740:
741: x_return_status := FND_API.G_RET_STS_ERROR;
742: Error_Handler.Add_Error_message
743: (
744: p_message_name => 'EGO_PLN_FLG_SEL_CONS'
745: ,p_application_id => 'EGO'
746: ,p_message_type => 'E'

Line 788: Error_Handler.Add_Error_message

784: l_Token_Tbl(3).Translate := FALSE;
785:
786:
787: x_return_status:=FND_API.g_RET_STS_ERROR;
788: Error_Handler.Add_Error_message
789: (
790: p_message_name => 'EGO_RELATIONSHIP_EXISTS'
791: ,p_application_id => 'EGO'
792: ,p_token_tbl => l_Token_Tbl

Line 952: Error_Handler.Add_Error_message

948: ,l_Rel_Item_Rec.ORGANIZATION_ID);
949: FETCH mtl_rel_item_cur INTO l_mtl_Rel_Item_rec;
950: IF mtl_rel_item_cur%NOTFOUND THEN
951: x_return_status:=FND_API.G_RET_STS_ERROR;
952: Error_Handler.Add_Error_message
953: (
954: p_message_name => 'EGO_REL_ITEM_NOTEXISTS'
955: ,p_application_id => 'EGO'
956: ,p_message_type => 'E'

Line 1073: Error_Handler.Add_Error_message

1069: l_Token_Tbl(4).Translate := FALSE;
1070:
1071:
1072: x_return_status:=FND_API.g_RET_STS_ERROR;
1073: Error_Handler.Add_Error_message
1074: (
1075: p_message_name => 'EGO_RELATIONSHIP_EXISTS'
1076: ,p_application_id => 'EGO'
1077: ,p_token_tbl => l_Token_Tbl

Line 1197: Error_Handler.Add_Error_message

1193: ,l_Rel_Item_Rec.ORGANIZATION_ID);
1194: FETCH mtl_rel_item_cur INTO l_mtl_Rel_Item_rec;
1195: IF mtl_rel_item_cur%NOTFOUND THEN
1196: x_return_status:=FND_API.G_RET_STS_ERROR;
1197: Error_Handler.Add_Error_message
1198: (
1199: p_message_name => 'EGO_REL_ITEM_NOTEXISTS'
1200: ,p_application_id => 'EGO'
1201: ,p_token_tbl => l_Token_Tbl

Line 1365: Error_Handler.Add_Error_message

1361: l_Pln_Info_Rec.Transaction_Type <> 'UPDATE' AND
1362: l_Pln_Info_Rec.Transaction_Type <> 'DELETE' THEN
1363:
1364: x_return_status := FND_API.G_RET_STS_ERROR;
1365: Error_Handler.Add_Error_message
1366: (
1367: p_message_name => 'EGO_PLN_INFO_INVALID_TRANS_TYP'
1368: ,p_application_id => 'EGO'
1369: ,p_message_type => 'E'

Line 1407: Error_Handler.Add_Error_message

1403: -- must have id if updating
1404: IF l_Pln_Info_Rec.PLN_INFO_ID = FND_API.G_MISS_NUM THEN
1405:
1406: x_return_status:=FND_API.g_RET_STS_ERROR;
1407: Error_Handler.Add_Error_message
1408: (
1409: p_message_name => 'EGO_PLN_INFO_ID_NULL'
1410: ,p_application_id => 'EGO'
1411: ,p_message_type => 'E'

Line 1428: Error_Handler.Add_Error_message

1424: ,l_Pln_Info_Rec.PLN_INFO_ID);
1425: FETCH mtl_pln_info_cur INTO l_mtl_Rel_Item_Pln_Info_rec;
1426: IF mtl_pln_info_cur%NOTFOUND THEN
1427: x_return_status:=FND_API.G_RET_STS_ERROR;
1428: Error_Handler.Add_Error_message
1429: (
1430: p_message_name => 'EGO_PLN_INFO_NOTEXISTS'
1431: ,p_application_id => 'EGO'
1432: ,p_message_type => 'E'

Line 1469: Error_Handler.Add_Error_message

1465: l_Pln_Info_Rec.START_DATE <> FND_API.G_MISS_DATE AND
1466: l_Pln_Info_Rec.END_DATE <> FND_API.G_MISS_DATE THEN
1467: IF l_Pln_Info_Rec.END_DATE < l_Pln_Info_Rec.START_DATE THEN
1468: x_return_status := FND_API.G_RET_STS_ERROR;
1469: Error_Handler.Add_Error_message
1470: (
1471: p_message_name => 'EGO_STARTDATE_PRECEDES_ENDDATE'
1472: ,p_application_id => 'EGO'
1473: ,p_message_type => 'E'

Line 1486: Error_Handler.Add_Error_message

1482: IF l_Pln_Info_Rec.START_DATE IS NOT NULL
1483: AND l_Pln_Info_Rec.START_DATE <> FND_API.G_MISS_DATE THEN
1484: IF l_Pln_Info_Rec.START_DATE < SYSDATE THEN
1485: x_return_status := FND_API.G_RET_STS_ERROR;
1486: Error_Handler.Add_Error_message
1487: (
1488: p_message_name => 'EGO_SELECTED_DATE_INVALID'
1489: ,p_application_id => 'EGO'
1490: ,p_message_type => 'E'

Line 1504: Error_Handler.Add_Error_message

1500: AND l_Pln_Info_Rec.END_DATE <> FND_API.G_MISS_DATE THEN
1501:
1502: IF l_Pln_Info_Rec.END_DATE < SYSDATE THEN
1503: x_return_status := FND_API.G_RET_STS_ERROR;
1504: Error_Handler.Add_Error_message
1505: (
1506: p_message_name => 'EGO_SELECTED_DATE_INVALID'
1507: ,p_application_id => 'EGO'
1508: ,p_message_type => 'E'

Line 1528: Error_Handler.Add_Error_message

1524:
1525: -- Partial fulfillment flag cannot be NULL
1526: IF l_Pln_Info_Rec.Partial_Fulfillment_Flag NOT IN ('Y','N') THEN
1527: x_return_status := FND_API.G_RET_STS_ERROR;
1528: Error_Handler.Add_Error_message
1529: (
1530: p_message_name => 'EGO_PART_FUL_FLAG_INVALID'
1531: ,p_application_id => 'EGO'
1532: ,p_message_type => 'E'

Line 1549: Error_Handler.Add_Error_message

1545:
1546: --??? All customers flag cannot be NULL '
1547: IF l_Pln_Info_Rec.All_Customers_Flag NOT IN ('Y','N',FND_API.G_MISS_CHAR) THEN
1548: x_return_status := FND_API.G_RET_STS_ERROR;
1549: Error_Handler.Add_Error_message
1550: (
1551: p_message_name => 'EGO_ALL_CUSTOMERS_FLAG_INVALID'
1552: ,p_application_id => 'EGO'
1553: ,p_message_type => 'E'

Line 1670: Error_Handler.Add_Error_message

1666: l_Cust_Ref_Rec.Transaction_Type <> 'UPDATE' AND
1667: l_Cust_Ref_Rec.Transaction_Type <> 'DELETE' THEN
1668:
1669: x_return_status := FND_API.G_RET_STS_ERROR;
1670: Error_Handler.Add_Error_message
1671: (
1672: p_message_name => 'EGO_CUST_REF_INVALID_TRANS_TYP'
1673: ,p_application_id => 'EGO'
1674: ,p_message_type => 'E'

Line 1743: Error_Handler.Add_Error_message

1739: l_Token_Tbl(7).Translate := FALSE;
1740:
1741:
1742: x_return_status:=FND_API.g_RET_STS_ERROR;
1743: Error_Handler.Add_Error_message
1744: (
1745: p_message_name => 'EGO_RELATIONSHIP_EXISTS'
1746: ,p_application_id => 'EGO'
1747: ,p_token_tbl => l_Token_Tbl

Line 1773: Error_Handler.Add_Error_message

1769: ,l_Cust_Ref_Rec.SITE_USE_ID);
1770: FETCH mtl_cust_ref_cur INTO l_mtl_Rel_Item_Cust_Ref_rec;
1771: IF mtl_cust_ref_cur%NOTFOUND THEN
1772: x_return_status:=FND_API.G_RET_STS_ERROR;
1773: Error_Handler.Add_Error_message
1774: (
1775: p_message_name => 'EGO_CUST_REF_NOTEXISTS'
1776: ,p_application_id => 'EGO'
1777: ,p_message_type => 'E'

Line 1831: Error_Handler.Add_Error_message

1827: END IF;
1828: EXCEPTION
1829: WHEN No_Data_Found THEN
1830: x_return_status:=FND_API.G_RET_STS_ERROR;
1831: Error_Handler.Add_Error_message
1832: (
1833: p_message_name => 'EGO_CUST_SITE_COMB_NOTEXISTS'
1834: ,p_application_id => 'EGO'
1835: ,p_message_type => 'E'

Line 1852: Error_Handler.Add_Error_message

1848: THEN
1849:
1850: IF l_Cust_Ref_Rec.END_DATE < l_Cust_Ref_Rec.START_DATE THEN
1851: x_return_status := FND_API.G_RET_STS_ERROR;
1852: Error_Handler.Add_Error_message
1853: (
1854: p_message_name => 'EGO_STARTDATE_PRECEDES_ENDDATE'
1855: ,P_Application_Id => 'EGO'
1856: ,p_token_tbl => l_Token_Tbl

Line 1870: Error_Handler.Add_Error_message

1866: IF l_Cust_Ref_Rec.START_DATE IS NOT NULL
1867: AND l_Cust_Ref_Rec.START_DATE <> FND_API.G_MISS_DATE THEN
1868: IF l_Cust_Ref_Rec.START_DATE < SYSDATE THEN
1869: x_return_status := FND_API.G_RET_STS_ERROR;
1870: Error_Handler.Add_Error_message
1871: (
1872: p_message_name => 'EGO_SELECTED_DATE_INVALID'
1873: ,P_Application_Id => 'EGO'
1874: ,p_token_tbl => l_Token_Tbl

Line 1888: Error_Handler.Add_Error_message

1884: IF l_Cust_Ref_Rec.END_DATE IS NOT NULL
1885: AND l_Cust_Ref_Rec.END_DATE <> FND_API.G_MISS_DATE THEN
1886: IF l_Cust_Ref_Rec.END_DATE < SYSDATE THEN
1887: x_return_status := FND_API.G_RET_STS_ERROR;
1888: Error_Handler.Add_Error_message
1889: (
1890: p_message_name => 'EGO_SELECTED_DATE_INVALID'
1891: ,p_application_id => 'EGO'
1892: ,p_message_type => 'E'

Line 1981: Error_Handler.Add_Error_message

1977: ,l_Cust_Ref_Rec.SITE_USE_ID);
1978: FETCH mtl_cust_ref_cur INTO l_mtl_Rel_Item_Cust_Ref_rec;
1979: IF mtl_cust_ref_cur%NOTFOUND THEN
1980: x_return_status:=FND_API.G_RET_STS_ERROR;
1981: Error_Handler.Add_Error_message
1982: (
1983: p_message_name => 'EGO_CUST_REF_NOTEXISTS'
1984: ,p_application_id => 'EGO'
1985: ,p_message_type => 'E'

Line 2021: Error_Handler.Add_Error_message

2017: END IF; -- cust ref delete transaction type
2018: END IF; -- cust ref for plan info rec
2019: ELSE -- if primary keys of cust ref are not provided
2020: x_return_status:=FND_API.g_RET_STS_ERROR;
2021: Error_Handler.Add_Error_message
2022: (
2023: p_message_name => 'EGO_CUST_REF_NULL_COLS'
2024: ,p_application_id => 'EGO'
2025: ,p_message_type => 'E'

Line 2044: Error_Handler.Add_Error_message

2040: -- must have id if deleting
2041: IF l_Pln_Info_Rec.PLN_INFO_ID = FND_API.G_MISS_NUM THEN
2042:
2043: x_return_status:=FND_API.g_RET_STS_ERROR;
2044: Error_Handler.Add_Error_message
2045: (
2046: p_message_name => 'EGO_PLN_INFO_ID_NULL'
2047: ,p_application_id => 'EGO'
2048: ,p_message_type => 'E'

Line 2085: Error_Handler.Add_Error_message

2081: l_Token_Tbl(5).Translate := FALSE;
2082:
2083:
2084: x_return_status:=FND_API.g_RET_STS_ERROR;
2085: Error_Handler.Add_Error_message
2086: (
2087: p_message_name => 'EGO_PLN_INFO_CUST_REF_EXISTS'
2088: ,p_application_id => 'EGO'
2089: ,p_token_tbl => l_Token_Tbl

Line 2117: Error_Handler.Add_Error_message

2113: END IF; -- planning info for specific rel item
2114:
2115: ELSE -- if missing primary key columns
2116: x_return_status := FND_API.G_RET_STS_ERROR;
2117: Error_Handler.Add_Error_message
2118: (
2119: p_message_name => 'EGO_PLN_INFO_NULL_COLS'
2120: ,p_application_id => 'EGO'
2121: ,p_message_type => 'E'

Line 2144: Error_Handler.Get_Entity_Message(G_Entity_Code, x_msg_list);

2140: EXCEPTION
2141: WHEN VALIDATION_ERROR THEN
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:

Line 2149: Error_Handler.Add_Error_message

2145:
2146: ROLLBACK TO MTL_RELATED_ITEMS_PVT; -- rollback to savepoint
2147: WHEN resource_busy THEN
2148:
2149: Error_Handler.Add_Error_message
2150: (
2151: p_message_name => 'EGO_REL_ITEM_RECORD_LOCKED'
2152: ,p_application_id => 'EGO'
2153: ,p_token_tbl => l_Token_Tbl

Line 2163: Error_Handler.Get_Entity_Message(G_Entity_Code, x_msg_list);

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:
2165: WHEN OTHERS THEN
2166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2167: l_Token_Tbl(1).Token_Name := 'PACKAGE_NAME';

Line 2177: Error_Handler.Add_Error_message

2173: l_Token_Tbl(3).Token_Name := 'ERROR_TEXT';
2174: l_Token_Tbl(3).Token_Value := SQLERRM;
2175: l_Token_Tbl(3).Translate := FALSE;
2176:
2177: Error_Handler.Add_Error_message
2178: (
2179: p_message_name => 'INV_ITEM_UNEXPECTED_ERROR'
2180: ,p_application_id => 'INV'
2181: ,p_token_tbl => l_Token_Tbl

Line 2190: Error_Handler.Get_Entity_Message(G_Entity_Code, x_msg_list);

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

Line 2227: l_msg_list Error_Handler.Error_Tbl_Type;

2223: p_data_set_id IN NUMBER,
2224: p_del_rec_flag IN NUMBER := 1) IS
2225:
2226: l_return_status VARCHAR2(1);
2227: l_msg_list Error_Handler.Error_Tbl_Type;
2228: l_msg Error_Handler.Error_Rec_Type;
2229: l_msg_count NUMBER;
2230: l_err_text VARCHAR2(255);
2231: l_dummyInt INTEGER;

Line 2228: l_msg Error_Handler.Error_Rec_Type;

2224: p_del_rec_flag IN NUMBER := 1) IS
2225:
2226: l_return_status VARCHAR2(1);
2227: l_msg_list Error_Handler.Error_Tbl_Type;
2228: l_msg Error_Handler.Error_Rec_Type;
2229: l_msg_count NUMBER;
2230: l_err_text VARCHAR2(255);
2231: l_dummyInt INTEGER;
2232: ret_code NUMBER;

Line 2245: l_Token_Tbl Error_Handler.Token_Tbl_Type; -- For passing token in error msgs

2241:
2242: p_organization_id NUMBER;
2243: p_related_item_id NUMBER;
2244: p_inventory_item_id NUMBER;
2245: l_Token_Tbl Error_Handler.Token_Tbl_Type; -- For passing token in error msgs
2246:
2247: -- cursor for going through the interface table
2248: -- for records where set_process_id is equal to parameter taken in
2249: -- or all records if parameter is NULL

Line 2276: Error_Handler.Initialize; -- Adding this as we now have validations and error handling in the Process_Rel_Items_Rows itself

2272: END LOOP;
2273:
2274: FOR l_mtl_Rel_Item_rec IN c_intf_rows(p_data_set_id) LOOP
2275:
2276: Error_Handler.Initialize; -- Adding this as we now have validations and error handling in the Process_Rel_Items_Rows itself
2277:
2278: l_proc_rec_count := +1;
2279:
2280: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2296: Error_Handler.Add_Error_message

2292: IF l_mtl_Rel_Item_rec.ORGANIZATION_ID IS NOT NULL THEN
2293: IF (l_mtl_Rel_Item_rec.ORGANIZATION_ID <> p_organization_id) THEN
2294:
2295: l_return_status := FND_API.g_RET_STS_ERROR;
2296: Error_Handler.Add_Error_message
2297: (
2298: p_message_name => 'EGO_ASSOC_INVALID_ORG'
2299: ,p_application_id => 'EGO'
2300: ,p_message_type => 'E'

Line 2307: Error_Handler.Get_Entity_Message(G_Entity_Code, l_msg_list);

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);
2308:
2309: END IF;
2310: END IF;
2311:

Line 2319: Error_Handler.Add_Error_message

2315: EXCEPTION
2316: WHEN NO_DATA_FOUND THEN
2317:
2318: l_return_status := FND_API.g_RET_STS_ERROR;
2319: Error_Handler.Add_Error_message
2320: (
2321: p_message_name => 'EGO_ASSOC_INVALID_ORG'
2322: ,p_application_id => 'EGO'
2323: ,p_message_type => 'E'

Line 2330: Error_Handler.Get_Entity_Message(G_Entity_Code, l_msg_list);

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);
2331:
2332: END;
2333:
2334: END IF;

Line 2351: Error_Handler.Add_Error_message

2347: IF l_mtl_Rel_Item_rec.RELATED_ITEM_ID IS NOT NULL THEN
2348: IF (l_mtl_Rel_Item_rec.RELATED_ITEM_ID <> p_related_item_id) THEN
2349:
2350: l_return_status := FND_API.g_RET_STS_ERROR;
2351: Error_Handler.Add_Error_message
2352: (
2353: p_message_name => 'EGO_INVALID_ITEM_SEGMENTS'
2354: ,p_application_id => 'EGO'
2355: ,p_message_type => 'E'

Line 2362: Error_Handler.Get_Entity_Message(G_Entity_Code, l_msg_list);

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);
2363:
2364: END IF;
2365: END IF;
2366:

Line 2374: Error_Handler.Add_Error_message

2370: WHEN NO_DATA_FOUND THEN
2371:
2372:
2373: l_return_status := FND_API.g_RET_STS_ERROR;
2374: Error_Handler.Add_Error_message
2375: (
2376: p_message_name => 'EGO_INVALID_ITEM_SEGMENTS'
2377: ,p_application_id => 'EGO'
2378: ,p_message_type => 'E'

Line 2384: Error_Handler.Get_Entity_Message(G_Entity_Code, l_msg_list);

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:
2386: END;
2387: END IF;
2388: END IF;

Line 2405: Error_Handler.Add_Error_message

2401: IF (l_mtl_Rel_Item_rec.INVENTORY_ITEM_ID <> p_inventory_item_id) THEN
2402:
2403: l_return_status := FND_API.g_RET_STS_ERROR;
2404:
2405: Error_Handler.Add_Error_message
2406: (
2407: p_message_name => 'EGO_INVALID_ITEM_SEGMENTS'
2408: ,p_application_id => 'EGO'
2409: ,p_message_type => 'E'

Line 2416: Error_Handler.Get_Entity_Message(G_Entity_Code, l_msg_list);

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);
2417:
2418: END IF;
2419: END IF;
2420:

Line 2426: Error_Handler.Add_Error_message

2422: EXCEPTION
2423: WHEN NO_DATA_FOUND THEN
2424:
2425: l_return_status := FND_API.g_RET_STS_ERROR;
2426: Error_Handler.Add_Error_message
2427: (
2428: p_message_name => 'EGO_INVALID_ITEM_SEGMENTS'
2429: ,p_application_id => 'EGO'
2430: ,p_message_type => 'E'

Line 2436: Error_Handler.Get_Entity_Message(G_Entity_Code, l_msg_list);

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:
2438: END;
2439:
2440: END IF;