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_CROSS_REFERENCES_PVT dependencies on ERROR_HANDLER

Line 5: -- Debug Profile option used to write Error_Handler.Write_Debug --

1: PACKAGE BODY mtl_cross_references_pvt AS
2: /* $Header: INVVXRFB.pls 120.16.12020000.2 2012/10/03 11:44:28 ccsingh ship $ */
3:
4: -------------------------------------------------------------------------
5: -- Debug Profile option used to write Error_Handler.Write_Debug --
6: -- Profile option name = INV_DEBUG_TRACE ; --
7: -- User Profile Option Name = INV: Debug Trace --
8: -- Values: 1 (True) ; 0 (False) --
9: -------------------------------------------------------------------------

Line 44: ,x_message_list OUT NOCOPY Error_Handler.Error_Tbl_Type) IS

40: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
41: ,p_XRef_Tbl IN OUT NOCOPY MTL_CROSS_REFERENCES_PUB.XRef_Tbl_Type
42: ,x_return_status OUT NOCOPY VARCHAR2
43: ,x_msg_count OUT NOCOPY NUMBER
44: ,x_message_list OUT NOCOPY Error_Handler.Error_Tbl_Type) IS
45:
46: -- Local variable Declarations
47: --l_api_name VARCHAR2(30) :='Process_XRef';
48: l_exists VARCHAR(1);

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

56: l_rev_id_invalid VARCHAR(1); /*bug 14138918*/
57:
58: l_XRef_Rec MTL_CROSS_REFERENCES_PUB.XRef_Rec_Type; -- Declaring the record type object
59: l_XRef_Tbl MTL_CROSS_REFERENCES_PUB.XRef_Tbl_Type; -- Declaring local table object
60: l_Token_Tbl Error_Handler.Token_Tbl_Type; -- For passing token in error msgs
61: l_msg_count NUMBER:=0;
62: returned_cross_ref_id NUMBER;
63: returned_object_version_number NUMBER;
64:

Line 147: Error_Handler.Initialize;

143: l_pim_exists := 'y';
144:
145: -- Initialize message list
146: IF FND_API.To_Boolean (p_init_msg_list) THEN
147: Error_Handler.Initialize;
148: END IF;
149: G_Xref_Indx := 0; -- making sure record index is reset
150: Write_Debug('Starting to process cross reference records...');
151: -- Looping all the records

Line 165: Error_Handler.Add_Error_Message

161: (l_XRef_Rec.Transaction_Type <> 'CREATE' AND l_XRef_Rec.Transaction_Type <> 'UPDATE' AND
162: l_XRef_Rec.Transaction_Type <> 'DELETE') THEN
163:
164: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
165: Error_Handler.Add_Error_Message
166: (
167: p_message_name => 'INV_XREF_INVALID_TRANS_TYPE'
168: ,p_application_id => 'INV'
169: ,p_message_type => 'E'

Line 216: Error_Handler.Add_Error_Message

212: ,p_instance_pk1_value => l_XRef_Rec.Inventory_item_id
213: ,p_instance_pk2_value => FND_GLOBAL.org_id
214: ,P_User_Id => FND_GLOBAL.user_id) <> 'T' THEN
215:
216: Error_Handler.Add_Error_Message
217: (
218: p_message_name => 'INV_IOI_ITEM_UPDATE_PRIV'
219: ,p_application_id => 'INV'
220: ,p_message_type => 'E'

Line 240: Error_Handler.Add_Error_Message

236: WHERE inventory_item_id =l_XRef_Rec.Inventory_Item_Id;
237: EXCEPTION
238: WHEN NO_DATA_FOUND THEN
239: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
240: Error_Handler.Add_Error_Message
241: (
242: p_message_name => 'INV-NO ITEM RECORD'
243: ,p_application_id => 'INV'
244: ,p_message_type => 'E'

Line 260: Error_Handler.Add_Error_Message

256:
257: IF l_XRef_rec.org_independent_flag NOT IN ('Y','N',FND_API.G_MISS_CHAR) THEN
258:
259: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
260: Error_Handler.Add_Error_Message
261: (
262: p_message_name => 'INV_XREF_INVALID_ORG_FLAG'
263: ,p_application_id => 'INV'
264: ,p_message_type => 'E'

Line 276: Error_Handler.Add_Error_Message

272: -- SS_ITEM_XREF not supported.
273: IF l_XRef_rec.Cross_Reference_Type ='SS_ITEM_XREF' THEN
274:
275: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
276: Error_Handler.Add_Error_Message
277: (
278: p_message_name => 'INV_XREF_INVALID_TYPES'
279: ,p_application_id => 'INV'
280: ,p_message_type => 'E'

Line 303: Error_Handler.Add_Error_Message

299: l_XRef_Rec.x_return_status :=FND_API.g_RET_STS_ERROR;
300: l_Token_Tbl(1).Token_Name := 'CROSS_REFERENCE_TYPE';
301: l_Token_Tbl(1).Token_Value := l_XRef_Rec.Cross_Reference_Type;
302: l_Token_Tbl(1).Translate := FALSE;
303: Error_Handler.Add_Error_Message
304: (
305: p_message_name => 'INV_XREF_TYPE_INACTIVE'
306: ,p_application_id => 'INV'
307: ,p_token_tbl => l_Token_Tbl

Line 327: Error_Handler.Add_Error_Message

323: OR l_XRef_Rec.Cross_Reference_Type IS NULL OR l_XRef_Rec.Cross_Reference_Type =FND_API.G_MISS_CHAR
324: OR l_XRef_Rec.Cross_Reference IS NULL OR l_XRef_Rec.Cross_Reference=FND_API.G_MISS_CHAR THEN
325:
326: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
327: Error_Handler.Add_Error_Message
328: (
329: p_message_name => 'INV_XREF_NULL_COLS'
330: ,p_application_id => 'INV'
331: ,p_message_type => 'E'

Line 345: Error_Handler.Add_Error_Message

341: AND l_XRef_Rec.Organization_Id <>FND_API.G_MISS_NUM THEN
342:
343: IF l_XRef_Rec.Org_Independent_Flag='Y' THEN
344: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
345: Error_Handler.Add_Error_Message
346: (
347: p_message_name => 'INV_XREF_ORG_FLAG'
348: ,p_application_id => 'INV'
349: ,p_message_type => 'E'

Line 367: Error_Handler.Add_Error_Message

363: OR l_XRef_Rec.Org_Independent_Flag=FND_API.G_MISS_CHAR
364: OR l_XRef_Rec.Org_Independent_Flag <>'Y' THEN
365:
366: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
367: Error_Handler.Add_Error_Message
368: (
369: p_message_name => 'INV_XREF_NULL_ORG'
370: ,p_application_id => 'INV'
371: ,p_message_type => 'E'

Line 392: Error_Handler.Add_Error_Message

388: AND Organization_id = l_XRef_Rec.Organization_Id;
389: EXCEPTION
390: WHEN NO_DATA_FOUND THEN
391: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
392: Error_Handler.Add_Error_Message
393: (
394: p_message_name => 'INV_INVALID_ITEM_ORG'
395: ,p_application_id => 'INV'
396: ,p_message_type => 'E'

Line 413: Error_Handler.Add_Error_Message

409:
410: IF NVL(FND_PROFILE.VALUE('INV:GTIN_CROSS_REFERENCE_TYPE'),FND_API.G_MISS_CHAR) <> l_XRef_rec.Cross_Reference_Type THEN /* bug 14138918 */
411:
412: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
413: Error_Handler.Add_Error_Message
414: (
415: p_message_name => 'INV_XREF_INVALID_COLUMN_VALUE'
416: ,p_application_id => 'INV'
417: ,p_message_type => 'E'

Line 442: Error_Handler.Add_Error_Message

438: EXCEPTION
439: WHEN No_Data_Found THEN
440:
441: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
442: Error_Handler.Add_Error_Message
443: (
444: p_message_name => 'INV_CCEOI_INVALID_UOM'
445: ,p_application_id => 'INV'
446: ,p_message_type => 'E'

Line 469: Error_Handler.Add_Error_Message

465: OR (l_XRef_Rec.Organization_Id IS NULL OR l_XRef_Rec.Organization_Id = FND_API.G_MISS_NUM)
466: THEN /* bug 14138918 */
467:
468: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
469: Error_Handler.Add_Error_Message
470: (
471: p_message_name => 'INV_XREF_INVALID_COLUMN_VALUE'
472: ,p_application_id => 'INV'
473: ,p_message_type => 'E'

Line 496: Error_Handler.Add_Error_Message

492: EXCEPTION
493: WHEN No_Data_Found THEN
494:
495: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
496: Error_Handler.Add_Error_Message
497: (
498: p_message_name => 'INV_INT_REVCODE'
499: ,p_application_id => 'INV'
500: ,p_message_type => 'E'

Line 536: Error_Handler.Add_Error_Message

532: l_Token_Tbl(3).Token_Value := l_XRef_Rec.CROSS_REFERENCE;
533: l_Token_Tbl(3).Translate := FALSE;
534:
535: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
536: Error_Handler.Add_Error_Message
537: (
538: p_message_name => 'INV_XREF_PRIMARY_KEY_VIOLATED'
539: ,p_application_id => 'INV'
540: ,p_token_tbl => l_Token_Tbl

Line 682: Error_Handler.Add_Error_Message

678: -- Current cols should not be NULL.
679: IF l_XRef_Rec.CROSS_REFERENCE_ID =FND_API.G_MISS_NUM THEN
680:
681: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR; -- assigning the record status as error
682: Error_Handler.Add_Error_Message
683: (
684: p_message_name => 'INV_XREF_ID_NULL'
685: ,p_application_id => 'INV'
686: ,p_message_type => 'E'

Line 702: Error_Handler.Add_Error_Message

698: OR l_XRef_Rec.Cross_Reference_Type IS NULL
699: OR l_XRef_Rec.Cross_Reference IS NULL THEN
700:
701: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR; -- assigning the record status as error
702: Error_Handler.Add_Error_Message
703: (
704: p_message_name => 'INV_XREF_NULL_COLS'
705: ,p_application_id => 'INV'
706: ,p_message_type => 'E'

Line 720: Error_Handler.Add_Error_Message

716: OPEN mtl_xref_cur(l_XRef_Rec.CROSS_REFERENCE_ID);
717: FETCH mtl_xref_cur INTO l_mtl_XRef_rec;
718: IF mtl_xref_cur%NOTFOUND THEN
719: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
720: Error_Handler.Add_Error_Message
721: (
722: p_message_name => 'INV_XREF_ID_NOTEXISTS'
723: ,p_application_id => 'INV'
724: ,p_message_type => 'E'

Line 787: Error_Handler.Add_Error_Message

783: IF l_XRef_Rec.Organization_Id IS NOT NULL THEN
784:
785: IF l_XRef_Rec.Org_Independent_Flag='Y' THEN
786: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
787: Error_Handler.Add_Error_Message
788: (
789: p_message_name => 'INV_XREF_ORG_FLAG'
790: ,p_application_id => 'INV'
791: ,p_message_type => 'E'

Line 807: Error_Handler.Add_Error_Message

803: IF l_XRef_Rec.Org_Independent_Flag IS NULL
804: OR l_XRef_Rec.Org_Independent_Flag = FND_API.G_MISS_CHAR THEN
805:
806: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
807: Error_Handler.Add_Error_Message
808: (
809: p_message_name => 'INV_XREF_NULL_ORG'
810: ,p_application_id => 'INV'
811: ,p_message_type => 'E'

Line 833: Error_Handler.Add_Error_Message

829: AND Organization_id = l_XRef_Rec.Organization_Id;
830: EXCEPTION
831: WHEN NO_DATA_FOUND THEN
832: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
833: Error_Handler.Add_Error_Message
834: (
835: p_message_name => 'INV_INVALID_ITEM_ORG'
836: ,p_application_id => 'INV'
837: ,p_message_type => 'E'

Line 853: Error_Handler.Add_Error_Message

849: AND l_XRef_Rec.Uom_Code <> FND_API.G_MISS_CHAR) THEN
850:
851: IF NVL(FND_PROFILE.VALUE('INV:GTIN_CROSS_REFERENCE_TYPE'),FND_API.G_MISS_CHAR) <> l_mtl_XRef_rec.CROSS_REFERENCE_TYPE THEN /* bug 14138918 */
852: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
853: Error_Handler.Add_Error_Message
854: (
855: p_message_name => 'INV_XREF_INVALID_COLUMN_VALUE'
856: ,p_application_id => 'INV'
857: ,p_message_type => 'E'

Line 879: Error_Handler.Add_Error_Message

875: EXCEPTION
876: WHEN No_Data_Found THEN
877:
878: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
879: Error_Handler.Add_Error_Message
880: (
881: p_message_name => 'INV_CCEOI_INVALID_UOM'
882: ,p_application_id => 'INV'
883: ,p_message_type => 'E'

Line 906: Error_Handler.Add_Error_Message

902: OR ((l_XRef_Rec.Organization_Id = FND_API.G_MISS_NUM) AND (l_mtl_XRef_rec.Organization_Id IS NULL ))
903: THEN /* bug 14138918 */
904:
905: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
906: Error_Handler.Add_Error_Message
907: (
908: p_message_name => 'INV_XREF_INVALID_COLUMN_VALUE'
909: ,p_application_id => 'INV'
910: ,p_message_type => 'E'

Line 932: Error_Handler.Add_Error_Message

928:
929: EXCEPTION
930: WHEN No_Data_Found THEN
931: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
932: Error_Handler.Add_Error_Message
933: (
934: p_message_name => 'INV_INT_REVCODE'
935: ,p_application_id => 'INV'
936: ,p_message_type => 'E'

Line 998: Error_Handler.Add_Error_Message

994: l_Token_Tbl(3).Token_Name := 'CROSS_REFERENCE';
995: l_Token_Tbl(3).Token_Value := l_XRef_Rec.Cross_Reference;
996: l_Token_Tbl(3).Translate := FALSE;
997:
998: Error_Handler.Add_Error_Message
999: (
1000: p_message_name => 'INV_XREF_PRIMARY_KEY_VIOLATED'
1001: ,p_application_id => 'INV'
1002: ,p_token_tbl => l_Token_Tbl

Line 1083: Error_Handler.Add_Error_Message

1079: -- current cols should not be NULL.
1080: IF l_XRef_Rec.CROSS_REFERENCE_ID =FND_API.G_MISS_NUM THEN
1081:
1082: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR; -- assigning the record status as error
1083: Error_Handler.Add_Error_Message
1084: (
1085: p_message_name => 'INV_XREF_ID_NULL'
1086: ,p_application_id => 'INV'
1087: ,p_message_type => 'E'

Line 1101: Error_Handler.Add_Error_Message

1097: FETCH mtl_xref_cur INTO l_mtl_XRef_rec;
1098: IF mtl_xref_cur%NOTFOUND THEN
1099:
1100: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
1101: Error_Handler.Add_Error_Message
1102: (
1103: p_message_name => 'INV_XREF_ID_NOTEXISTS'
1104: ,p_application_id => 'INV'
1105: ,p_message_type => 'E'

Line 1150: Error_Handler.Get_Entity_Message(G_Entity_Code, x_message_list);

1146: EXCEPTION
1147: WHEN VALIDATION_ERROR THEN
1148: X_return_status:= FND_API.g_RET_STS_ERROR;
1149: l_msg_count := l_msg_count +1;
1150: Error_Handler.Get_Entity_Message(G_Entity_Code, x_message_list);
1151: ROLLBACK TO MTL_CROSS_REFERENCES_PVT; -- rolling back to savepoint
1152:
1153: WHEN UNEXP_VALIDATION_ERROR THEN
1154: X_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;

Line 1156: Error_Handler.Get_Entity_Message(G_Entity_Code, x_message_list);

1152:
1153: WHEN UNEXP_VALIDATION_ERROR THEN
1154: X_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1155: l_msg_count := l_msg_count +1;
1156: Error_Handler.Get_Entity_Message(G_Entity_Code, x_message_list);
1157: ROLLBACK TO MTL_CROSS_REFERENCES_PVT; -- rolling back to savepoint
1158:
1159: WHEN resource_busy THEN
1160: Error_Handler.Add_Error_Message

Line 1160: Error_Handler.Add_Error_Message

1156: Error_Handler.Get_Entity_Message(G_Entity_Code, x_message_list);
1157: ROLLBACK TO MTL_CROSS_REFERENCES_PVT; -- rolling back to savepoint
1158:
1159: WHEN resource_busy THEN
1160: Error_Handler.Add_Error_Message
1161: (
1162: p_message_name => 'INV_XREF_RECORD_LOCKED'
1163: ,p_application_id => 'INV'
1164: ,p_message_type => 'E'

Line 1186: Error_Handler.Add_Error_Message

1182: l_Token_Tbl(3).Token_Name := 'ERROR_TEXT';
1183: l_Token_Tbl(3).Token_Value := SQLERRM;
1184: l_Token_Tbl(3).Translate := FALSE;
1185:
1186: Error_Handler.Add_Error_Message
1187: (
1188: p_message_name => 'INV_ITEM_UNEXPECTED_ERROR'
1189: ,p_application_id => 'INV'
1190: ,p_token_tbl => l_Token_Tbl

Line 1199: Error_Handler.Get_Entity_Message(G_Entity_Code, x_message_list);

1195: );
1196: l_XRef_Rec.x_return_status:=FND_API.g_RET_STS_ERROR;
1197: X_return_status:= FND_API.g_RET_STS_ERROR;
1198: l_msg_count := l_msg_count +1;
1199: Error_Handler.Get_Entity_Message(G_Entity_Code, x_message_list);
1200: ROLLBACK TO MTL_CROSS_REFERENCES_PVT; -- rolling back to savepoint
1201:
1202: END; -- internal begin
1203: END LOOP; -- p_XRef_Tbl

Line 1235: l_Token_Tbl Error_Handler.Token_Tbl_Type;

1231: l_item_revision_exists VARCHAR(1);
1232: l_uom_exists VARCHAR(1);
1233: l_gtin_packitem_exists VARCHAR(1);
1234: l_gtin_num_return_status VARCHAR2(255);
1235: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1236: l_msg_count NUMBER;
1237: l_master_org NUMBER;
1238: GTIN_VALIDATION_ERROR EXCEPTION;
1239:

Line 1250: Error_Handler.Initialize;

1246: x_return_status := FND_API.G_RET_STS_SUCCESS;
1247: l_master_org := -1;
1248: -- Initialize message list
1249: IF FND_API.To_Boolean (p_init_msg_list) THEN
1250: Error_Handler.Initialize;
1251: END IF;
1252:
1253: -- if msg list is to be initialized and changes to be commited, then this procedure
1254: -- is being called alone, therefore setting the the global index count to 1 for the

Line 1270: Error_Handler.Add_Error_message

1266: IF (l_GTIN_XRef_Rec.UOM_CODE = FND_API.G_MISS_CHAR
1267: OR l_GTIN_XRef_Rec.UOM_CODE IS NULL) AND
1268: l_GTIN_XRef_Rec.TRANSACTION_TYPE = 'CREATE' THEN
1269:
1270: Error_Handler.Add_Error_message
1271: (
1272: p_message_name => 'EGO_GTIN_UOM_INVALID'
1273: ,p_application_id => 'EGO'
1274: ,p_message_type => 'E'

Line 1301: Error_Handler.Add_Error_message

1297: l_Token_Tbl(1).Token_Name := 'UOM_CODE';
1298: l_Token_Tbl(1).Token_Value := l_GTIN_XRef_Rec.UOM_CODE;
1299: L_TOKEN_TBL(1).TRANSLATE := FALSE;
1300:
1301: Error_Handler.Add_Error_message
1302: (
1303: p_message_name => 'EGO_REL_ITEMS_UOM_NOTEXIST'
1304: ,p_application_id => 'EGO'
1305: ,p_token_tbl => l_Token_Tbl

Line 1338: Error_Handler.Add_Error_message

1334: l_Token_Tbl(2).Token_Value := l_GTIN_XRef_Rec.UOM_CODE;
1335: l_Token_Tbl(2).Translate := FALSE;
1336:
1337:
1338: Error_Handler.Add_Error_message
1339: (
1340: p_message_name => 'EGO_GTIN_XREF_DUPLICATE_UOM'
1341: ,p_application_id => 'EGO'
1342: ,p_token_tbl => l_Token_Tbl

Line 1383: Error_Handler.Add_Error_message

1379: l_Token_Tbl(2).Token_Name := 'GTIN';
1380: l_Token_Tbl(2).Token_Value := l_GTIN_XRef_Rec.CROSS_REFERENCE;
1381: l_Token_Tbl(2).Translate := FALSE;
1382:
1383: Error_Handler.Add_Error_message
1384: (
1385: p_message_name => 'EGO_GTIN_EXISTS_WITH_PACKITEM'
1386: ,p_application_id => 'EGO'
1387: ,p_token_tbl => l_Token_Tbl

Line 1416: Error_Handler.Add_Error_message

1412: AND REVISION_ID = l_GTIN_XRef_Rec.REVISION_ID
1413: AND ORGANIZATION_ID = l_GTIN_XRef_Rec.ORGANIZATION_ID;
1414: EXCEPTION
1415: WHEN NO_DATA_FOUND THEN
1416: Error_Handler.Add_Error_message
1417: (
1418: p_message_name => 'EGO_GTIN_ITEM_REVISION_EXISTS'
1419: ,p_application_id => 'EGO'
1420: ,p_message_type => 'E'

Line 1441: Error_Handler.Add_Error_message

1437: AND i.organization_id = p.organization_id
1438: AND i.inventory_item_id = l_GTIN_XRef_Rec.INVENTORY_ITEM_ID;
1439: EXCEPTION
1440: WHEN No_Data_Found THEN
1441: Error_Handler.Add_Error_message
1442: (
1443: p_message_name => 'EGO_GTIN_ITEM_REVISION_EXISTS'
1444: ,p_application_id => 'EGO'
1445: ,p_message_type => 'E'

Line 1461: Error_Handler.Add_Error_message

1457: AND REVISION_ID = l_GTIN_XRef_Rec.REVISION_ID
1458: AND ORGANIZATION_ID = l_master_org;
1459: EXCEPTION
1460: WHEN NO_DATA_FOUND THEN
1461: Error_Handler.Add_Error_message
1462: (
1463: p_message_name => 'EGO_GTIN_ITEM_REVISION_EXISTS'
1464: ,p_application_id => 'EGO'
1465: ,p_message_type => 'E'

Line 1507: Error_Handler.Add_Error_Message

1503: l_Token_Tbl(3).Token_Name := 'ERROR_TEXT';
1504: l_Token_Tbl(3).Token_Value := SQLERRM;
1505: l_Token_Tbl(3).Translate := FALSE;
1506:
1507: Error_Handler.Add_Error_Message
1508: (
1509: p_message_name => 'INV_ITEM_UNEXPECTED_ERROR'
1510: ,p_application_id => 'INV'
1511: ,p_token_tbl => l_Token_Tbl

Line 1555: Error_Handler.Add_Error_message

1551: BEGIN
1552: l_gtin := To_Number(l_GTIN_XRef_Number);
1553: EXCEPTION
1554: WHEN Value_Error THEN
1555: Error_Handler.Add_Error_message
1556: (
1557: p_message_name => 'EGO_GTIN_NOT_NUMBER'
1558: ,p_application_id => 'EGO'
1559: ,p_message_type => 'E'

Line 1570: Error_Handler.Add_Error_message

1566:
1567: -- 2. Length must be 14
1568: IF Length(p_GTIN_XRef_Number) <> 14 THEN
1569:
1570: Error_Handler.Add_Error_message
1571: (
1572: p_message_name => 'EGO_GTIN_LENGTH_NOT_CORRECT'
1573: ,p_application_id => 'EGO'
1574: ,p_message_type => 'E'

Line 1584: Error_Handler.Add_Error_message

1580: END IF;
1581:
1582: -- 3. Check (14th) digit validity
1583: IF EGO_GTIN_ATTRS_PVT.Is_Check_Digit_Invalid(l_GTIN_XRef_Number) THEN
1584: Error_Handler.Add_Error_message
1585: (
1586: p_message_name => 'EGO_GTIN_CHECKDIGIT_INVALID'
1587: ,p_application_id => 'EGO'
1588: ,p_message_type => 'E'

Line 1599: Error_Handler.Add_Error_message

1595:
1596: -- 4. Cannot contain more than six leading zeros
1597: IF SubStr(l_GTIN_XRef_Number, 1, 7) = '0000000' THEN
1598:
1599: Error_Handler.Add_Error_message
1600: (
1601: p_message_name => 'EGO_GTIN_LEADING_ZERO_INVALID'
1602: ,p_application_id => 'EGO'
1603: ,p_message_type => 'E'

Line 1614: Error_Handler.Add_Error_message

1610:
1611: -- 5. Third digit from left must be 0,1,3,6,7,8,9 when the second digit from the left is 0
1612: IF SUBSTR(l_GTIN_XRef_Number, 2, 1) = '0' AND
1613: SUBSTR(l_GTIN_XRef_Number, 3, 1) NOT IN ('0', '1', '3', '6', '7', '8', '9') THEN
1614: Error_Handler.Add_Error_message
1615: (
1616: p_message_name => 'EGO_GTIN_THIRD_DIGIT_INVALID'
1617: ,p_application_id => 'EGO'
1618: ,p_message_type => 'E'

Line 1629: Error_Handler.Add_Error_message

1625:
1626: -- 6. If has six leading zeros in a RCI message, digits 7-9 must be between 301-968
1627: IF SUBSTR(l_GTIN_XRef_Number, 1, 6) = '000000' AND
1628: TO_NUMBER(SUBSTR(l_GTIN_XRef_Number, 7, 3)) NOT BETWEEN 301 AND 968 THEN
1629: Error_Handler.Add_Error_message
1630: (
1631: p_message_name => 'EGO_GTIN_7TO9DIGIT_INVALID'
1632: ,p_application_id => 'EGO'
1633: ,p_message_type => 'E'

Line 1643: Error_Handler.Add_Error_message

1639: END IF;
1640:
1641: -- 7. If submitted in RCI messages, cannot contain values 0980-0989 or 099 in the first 4 digits
1642: IF SUBSTR(l_GTIN_XRef_Number, 1, 3) IN ('098', '099') THEN
1643: Error_Handler.Add_Error_message
1644: (
1645: p_message_name => 'EGO_GTIN_0TO4_DIGIT_INVALID'
1646: ,p_application_id => 'EGO'
1647: ,p_message_type => 'E'

Line 1658: Error_Handler.Add_Error_message

1654:
1655: -- 8. If submitted in RCI messages, cannot contain values 02, 04, 05, and 10-29 in the second and third digits from the left
1656: IF SUBSTR(l_GTIN_XRef_Number, 2, 2) IN ('02', '04', '05') OR
1657: TO_NUMBER(SUBSTR(l_GTIN_XRef_Number, 2, 2)) BETWEEN 10 AND 29 THEN
1658: Error_Handler.Add_Error_message
1659: (
1660: p_message_name => 'EGO_GTIN_2TO3_DIGIT_INVALID'
1661: ,p_application_id => 'EGO'
1662: ,p_message_type => 'E'

Line 1690: l_msg_list Error_Handler.Error_Tbl_Type;

1686: p_data_set_id IN NUMBER,
1687: p_del_rec_flag IN NUMBER := 1) IS
1688:
1689: l_return_status VARCHAR2(1);
1690: l_msg_list Error_Handler.Error_Tbl_Type;
1691: l_msg Error_Handler.Error_Rec_Type;
1692: l_XRef_Tbl MTL_CROSS_REFERENCES_PUB.XRef_Tbl_Type;
1693: l_XRef_Rec MTL_CROSS_REFERENCES_PUB.XRef_Rec_Type;
1694: L_MSG_COUNT number;

Line 1691: l_msg Error_Handler.Error_Rec_Type;

1687: p_del_rec_flag IN NUMBER := 1) IS
1688:
1689: l_return_status VARCHAR2(1);
1690: l_msg_list Error_Handler.Error_Tbl_Type;
1691: l_msg Error_Handler.Error_Rec_Type;
1692: l_XRef_Tbl MTL_CROSS_REFERENCES_PUB.XRef_Tbl_Type;
1693: l_XRef_Rec MTL_CROSS_REFERENCES_PUB.XRef_Rec_Type;
1694: L_MSG_COUNT number;
1695: l_uom_code VARCHAR2(3);

Line 1736: Error_Handler.Initialize;

1732:
1733: L_PROC_REC_COUNT := 0;
1734:
1735: FOR L_MTL_XREF_REC IN C_INTF_ROWS(P_DATA_SET_ID) LOOP
1736: Error_Handler.Initialize;
1737: l_proc_rec_count := +1;
1738: L_UOM_CODE := L_MTL_XREF_REC.UOM_CODE;
1739:
1740: IF l_uom_code IS NULL

Line 1773: Error_Handler.Add_Error_message

1769: IF l_mtl_xref_rec.ORGANIZATION_ID IS NOT NULL THEN
1770: IF (l_mtl_xref_rec.ORGANIZATION_ID <> p_organization_id) THEN
1771:
1772: l_return_status := FND_API.g_RET_STS_ERROR;
1773: Error_Handler.Add_Error_message
1774: (
1775: p_message_name => 'EGO_ASSOC_INVALID_ORG'
1776: ,p_application_id => 'EGO'
1777: ,p_message_type => 'E'

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

1780: ,p_table_name => 'MTL_CROSS_REFERENCES_INTERFACE'
1781: );
1782:
1783: l_msg_count := 1;
1784: Error_Handler.Get_Entity_Message(G_Entity_Code, l_msg_list);
1785:
1786: END IF;
1787: END IF;
1788:

Line 1796: Error_Handler.Add_Error_message

1792: EXCEPTION
1793: WHEN NO_DATA_FOUND THEN
1794:
1795: l_return_status := FND_API.g_RET_STS_ERROR;
1796: Error_Handler.Add_Error_message
1797: (
1798: p_message_name => 'EGO_ASSOC_INVALID_ORG'
1799: ,p_application_id => 'EGO'
1800: ,p_message_type => 'E'

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

1803: ,p_table_name => 'MTL_CROSS_REFERENCES_INTERFACE'
1804: );
1805:
1806: l_msg_count := 1;
1807: Error_Handler.Get_Entity_Message(G_Entity_Code, l_msg_list);
1808:
1809: END;
1810:
1811: END IF;

Line 1830: Error_Handler.Add_Error_message

1826:
1827:
1828: l_return_status := FND_API.g_RET_STS_ERROR;
1829:
1830: Error_Handler.Add_Error_message
1831: (
1832: p_message_name => 'EGO_INVALID_ITEM_SEGMENTS'
1833: ,p_application_id => 'EGO'
1834: ,p_message_type => 'E'

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

1837: ,p_table_name => 'MTL_CROSS_REFERENCES_INTERFACE'
1838: );
1839:
1840: l_msg_count := 1;
1841: Error_Handler.Get_Entity_Message(G_Entity_Code, l_msg_list);
1842:
1843: END IF;
1844: END IF;
1845:

Line 1852: Error_Handler.Add_Error_message

1848: EXCEPTION
1849: WHEN NO_DATA_FOUND THEN
1850:
1851: l_return_status := FND_API.g_RET_STS_ERROR;
1852: Error_Handler.Add_Error_message
1853: (
1854: p_message_name => 'EGO_INVALID_ITEM_SEGMENTS'
1855: ,p_application_id => 'EGO'
1856: ,p_message_type => 'E'

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

1858: ,p_entity_index => 1
1859: ,p_table_name => 'MTL_CROSS_REFERENCES_INTERFACE'
1860: );
1861: l_msg_count := 1;
1862: Error_Handler.Get_Entity_Message(G_Entity_Code, l_msg_list);
1863:
1864: END;
1865:
1866: END IF;

Line 1888: Error_Handler.Add_Error_message

1884: IF (l_mtl_xref_rec.revision_id <> p_revision_id) THEN
1885:
1886: l_return_status := FND_API.g_RET_STS_ERROR;
1887:
1888: Error_Handler.Add_Error_message
1889: (
1890: p_message_name => 'INV_ITM_INVALID_REVISION_CODE'
1891: ,p_application_id => 'INV'
1892: ,p_message_type => 'E'

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

1895: ,p_table_name => 'MTL_CROSS_REFERENCES_INTERFACE'
1896: );
1897:
1898: l_msg_count := 1;
1899: Error_Handler.Get_Entity_Message(G_Entity_Code, l_msg_list);
1900:
1901: END IF;
1902: END IF;
1903:

Line 1909: Error_Handler.Add_Error_message

1905: EXCEPTION
1906: WHEN NO_DATA_FOUND THEN
1907:
1908: l_return_status := FND_API.g_RET_STS_ERROR;
1909: Error_Handler.Add_Error_message
1910: (
1911: p_message_name => 'INV_ITM_INVALID_REVISION_CODE'
1912: ,p_application_id => 'INV'
1913: ,p_message_type => 'E'

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

1915: ,p_entity_index => 1
1916: ,p_table_name => 'MTL_CROSS_REFERENCES_INTERFACE'
1917: );
1918: l_msg_count := 1;
1919: Error_Handler.Get_Entity_Message(G_Entity_Code, l_msg_list);
1920:
1921: END;
1922:
1923: END IF;