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.CSD_LOGISTICS_UTIL dependencies on FND_MESSAGE

Line 68: -- FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_PRICE_LIST_ID');

64: -- IF (g_debug > 0 ) THEN
65: -- debug('price list Not found');
66: -- END IF;
67: --
68: -- FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_PRICE_LIST_ID');
69: -- FND_MESSAGE.SET_TOKEN('PRICE_LIST_ID',p_price_list_id);
70: -- FND_MSG_PUB.ADD;
71: --
72: -- RAISE FND_API.G_EXC_ERROR;

Line 69: -- FND_MESSAGE.SET_TOKEN('PRICE_LIST_ID',p_price_list_id);

65: -- debug('price list Not found');
66: -- END IF;
67: --
68: -- FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_PRICE_LIST_ID');
69: -- FND_MESSAGE.SET_TOKEN('PRICE_LIST_ID',p_price_list_id);
70: -- FND_MSG_PUB.ADD;
71: --
72: -- RAISE FND_API.G_EXC_ERROR;
73: --

Line 80: -- FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_PRICE_LIST_ID');

76: -- IF (g_debug > 0 ) THEN
77: -- debug('Too many price lists found');
78: -- END IF;
79: --
80: -- FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_PRICE_LIST_ID');
81: -- FND_MESSAGE.SET_TOKEN('PRICE_LIST_ID',p_price_list_id);
82: -- FND_MSG_PUB.ADD;
83: --
84: -- RAISE FND_API.G_EXC_ERROR;

Line 81: -- FND_MESSAGE.SET_TOKEN('PRICE_LIST_ID',p_price_list_id);

77: -- debug('Too many price lists found');
78: -- END IF;
79: --
80: -- FND_MESSAGE.SET_NAME('CSD','CSD_API_INV_PRICE_LIST_ID');
81: -- FND_MESSAGE.SET_TOKEN('PRICE_LIST_ID',p_price_list_id);
82: -- FND_MSG_PUB.ADD;
83: --
84: -- RAISE FND_API.G_EXC_ERROR;
85: --

Line 177: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_ITEM');

173: TRUNC(NVL(m.end_date_active, SYSDATE));
174:
175: EXCEPTION
176: WHEN OTHERS THEN
177: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_ITEM');
178: Fnd_Message.SET_TOKEN('ITEM_ID', p_Inventory_Item_ID);
179: Fnd_Msg_Pub.ADD;
180: IF (g_debug > 0)
181: THEN

Line 178: Fnd_Message.SET_TOKEN('ITEM_ID', p_Inventory_Item_ID);

174:
175: EXCEPTION
176: WHEN OTHERS THEN
177: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_ITEM');
178: Fnd_Message.SET_TOKEN('ITEM_ID', p_Inventory_Item_ID);
179: Fnd_Msg_Pub.ADD;
180: IF (g_debug > 0)
181: THEN
182: Csd_Gen_Utility_Pvt.ADD('Inventory_Item_id is invalid');

Line 242: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_TXNBILLING_TYPE_ID');

238: EXCEPTION
239:
240: WHEN NO_DATA_FOUND THEN
241: --JG:02/25: Corrected message code.
242: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_TXNBILLING_TYPE_ID');
243: Fnd_Message.SET_TOKEN('TXN_BILLING_TYPE_ID',
244: p_txn_billing_type_id);
245: Fnd_Msg_Pub.ADD;
246:

Line 243: Fnd_Message.SET_TOKEN('TXN_BILLING_TYPE_ID',

239:
240: WHEN NO_DATA_FOUND THEN
241: --JG:02/25: Corrected message code.
242: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_TXNBILLING_TYPE_ID');
243: Fnd_Message.SET_TOKEN('TXN_BILLING_TYPE_ID',
244: p_txn_billing_type_id);
245: Fnd_Msg_Pub.ADD;
246:
247: IF (g_debug > 0)

Line 295: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_REVISION_1');

291: THEN
292: Csd_Gen_Utility_Pvt.ADD('revision Not found');
293: END IF;
294:
295: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_REVISION_1');
296: -- FND_MESSAGE.SET_TOKEN('ITEM',l_Concatenated_Segments);
297: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);
298: Fnd_Message.SET_TOKEN('REVISION', p_revision);
299: Fnd_Msg_Pub.ADD;

Line 296: -- FND_MESSAGE.SET_TOKEN('ITEM',l_Concatenated_Segments);

292: Csd_Gen_Utility_Pvt.ADD('revision Not found');
293: END IF;
294:
295: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_REVISION_1');
296: -- FND_MESSAGE.SET_TOKEN('ITEM',l_Concatenated_Segments);
297: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);
298: Fnd_Message.SET_TOKEN('REVISION', p_revision);
299: Fnd_Msg_Pub.ADD;
300:

Line 297: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);

293: END IF;
294:
295: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_REVISION_1');
296: -- FND_MESSAGE.SET_TOKEN('ITEM',l_Concatenated_Segments);
297: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);
298: Fnd_Message.SET_TOKEN('REVISION', p_revision);
299: Fnd_Msg_Pub.ADD;
300:
301: RAISE Fnd_Api.G_EXC_ERROR;

Line 298: Fnd_Message.SET_TOKEN('REVISION', p_revision);

294:
295: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_REVISION_1');
296: -- FND_MESSAGE.SET_TOKEN('ITEM',l_Concatenated_Segments);
297: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);
298: Fnd_Message.SET_TOKEN('REVISION', p_revision);
299: Fnd_Msg_Pub.ADD;
300:
301: RAISE Fnd_Api.G_EXC_ERROR;
302:

Line 368: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_INSTANCE_ID');

364: Csd_Gen_Utility_Pvt.ADD('instance number Not found');
365: END IF;
366:
367: --JG:02/25: Corrected message code. Removed space at the end.
368: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_INSTANCE_ID');
369: -- Using concatenated segments instead of item ID
370: -- FND_MESSAGE.SET_TOKEN('ITEM_ID',p_inventory_item_id);
371: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);
372: Fnd_Message.SET_TOKEN('INSTANCE_ID', p_Instance_ID);

Line 370: -- FND_MESSAGE.SET_TOKEN('ITEM_ID',p_inventory_item_id);

366:
367: --JG:02/25: Corrected message code. Removed space at the end.
368: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_INSTANCE_ID');
369: -- Using concatenated segments instead of item ID
370: -- FND_MESSAGE.SET_TOKEN('ITEM_ID',p_inventory_item_id);
371: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);
372: Fnd_Message.SET_TOKEN('INSTANCE_ID', p_Instance_ID);
373: Fnd_Msg_Pub.ADD;
374:

Line 371: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);

367: --JG:02/25: Corrected message code. Removed space at the end.
368: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_INSTANCE_ID');
369: -- Using concatenated segments instead of item ID
370: -- FND_MESSAGE.SET_TOKEN('ITEM_ID',p_inventory_item_id);
371: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);
372: Fnd_Message.SET_TOKEN('INSTANCE_ID', p_Instance_ID);
373: Fnd_Msg_Pub.ADD;
374:
375: RAISE Fnd_Api.G_EXC_ERROR;

Line 372: Fnd_Message.SET_TOKEN('INSTANCE_ID', p_Instance_ID);

368: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_INSTANCE_ID');
369: -- Using concatenated segments instead of item ID
370: -- FND_MESSAGE.SET_TOKEN('ITEM_ID',p_inventory_item_id);
371: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);
372: Fnd_Message.SET_TOKEN('INSTANCE_ID', p_Instance_ID);
373: Fnd_Msg_Pub.ADD;
374:
375: RAISE Fnd_Api.G_EXC_ERROR;
376:

Line 417: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_LOTNUMBER');

413: THEN
414: Csd_Gen_Utility_Pvt.ADD('Lot Number Not found');
415: END IF;
416:
417: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_LOTNUMBER');
418: -- FND_MESSAGE.SET_TOKEN('ITEM',l_Concatenated_Segments);
419: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);
420: Fnd_Message.SET_TOKEN('LOT_NUMBER', p_Lot_Number);
421: Fnd_Msg_Pub.ADD;

Line 418: -- FND_MESSAGE.SET_TOKEN('ITEM',l_Concatenated_Segments);

414: Csd_Gen_Utility_Pvt.ADD('Lot Number Not found');
415: END IF;
416:
417: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_LOTNUMBER');
418: -- FND_MESSAGE.SET_TOKEN('ITEM',l_Concatenated_Segments);
419: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);
420: Fnd_Message.SET_TOKEN('LOT_NUMBER', p_Lot_Number);
421: Fnd_Msg_Pub.ADD;
422:

Line 419: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);

415: END IF;
416:
417: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_LOTNUMBER');
418: -- FND_MESSAGE.SET_TOKEN('ITEM',l_Concatenated_Segments);
419: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);
420: Fnd_Message.SET_TOKEN('LOT_NUMBER', p_Lot_Number);
421: Fnd_Msg_Pub.ADD;
422:
423: RAISE Fnd_Api.G_EXC_ERROR;

Line 420: Fnd_Message.SET_TOKEN('LOT_NUMBER', p_Lot_Number);

416:
417: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_LOTNUMBER');
418: -- FND_MESSAGE.SET_TOKEN('ITEM',l_Concatenated_Segments);
419: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);
420: Fnd_Message.SET_TOKEN('LOT_NUMBER', p_Lot_Number);
421: Fnd_Msg_Pub.ADD;
422:
423: RAISE Fnd_Api.G_EXC_ERROR;
424:

Line 463: Fnd_Message.SET_NAME('CSD', 'CSD_SERNUM_STATUS_INVALID');

459: -- Get_Concatenated_Segments
460: -- ( p_inventory_item_Id => p_inventory_item_Id,
461: -- x_Concatenated_Segments => l_Concatenated_Segments ) ;
462:
463: Fnd_Message.SET_NAME('CSD', 'CSD_SERNUM_STATUS_INVALID');
464: -- FND_MESSAGE.SET_TOKEN('ITEM',l_Concatenated_Segments);
465: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);
466: Fnd_Message.SET_TOKEN('SERIAL_NUM', p_Serial_Number);
467: Fnd_Msg_Pub.ADD;

Line 464: -- FND_MESSAGE.SET_TOKEN('ITEM',l_Concatenated_Segments);

460: -- ( p_inventory_item_Id => p_inventory_item_Id,
461: -- x_Concatenated_Segments => l_Concatenated_Segments ) ;
462:
463: Fnd_Message.SET_NAME('CSD', 'CSD_SERNUM_STATUS_INVALID');
464: -- FND_MESSAGE.SET_TOKEN('ITEM',l_Concatenated_Segments);
465: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);
466: Fnd_Message.SET_TOKEN('SERIAL_NUM', p_Serial_Number);
467: Fnd_Msg_Pub.ADD;
468:

Line 465: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);

461: -- x_Concatenated_Segments => l_Concatenated_Segments ) ;
462:
463: Fnd_Message.SET_NAME('CSD', 'CSD_SERNUM_STATUS_INVALID');
464: -- FND_MESSAGE.SET_TOKEN('ITEM',l_Concatenated_Segments);
465: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);
466: Fnd_Message.SET_TOKEN('SERIAL_NUM', p_Serial_Number);
467: Fnd_Msg_Pub.ADD;
468:
469: IF (g_debug > 0)

Line 466: Fnd_Message.SET_TOKEN('SERIAL_NUM', p_Serial_Number);

462:
463: Fnd_Message.SET_NAME('CSD', 'CSD_SERNUM_STATUS_INVALID');
464: -- FND_MESSAGE.SET_TOKEN('ITEM',l_Concatenated_Segments);
465: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);
466: Fnd_Message.SET_TOKEN('SERIAL_NUM', p_Serial_Number);
467: Fnd_Msg_Pub.ADD;
468:
469: IF (g_debug > 0)
470: THEN

Line 531: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_REASONCODE');

527: THEN
528: Csd_Gen_Utility_Pvt.ADD('Reason Code Not found');
529: END IF;
530:
531: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_REASONCODE');
532: Fnd_Message.SET_TOKEN('REASON_CODE', p_ReasonCode);
533: Fnd_Msg_Pub.ADD;
534:
535: RAISE Fnd_Api.G_EXC_ERROR;

Line 532: Fnd_Message.SET_TOKEN('REASON_CODE', p_ReasonCode);

528: Csd_Gen_Utility_Pvt.ADD('Reason Code Not found');
529: END IF;
530:
531: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_REASONCODE');
532: Fnd_Message.SET_TOKEN('REASON_CODE', p_ReasonCode);
533: Fnd_Msg_Pub.ADD;
534:
535: RAISE Fnd_Api.G_EXC_ERROR;
536:

Line 586: Fnd_Message.SET_NAME('CSD', 'CSD_API_INVALID_UOM');

582: THEN
583: Csd_Gen_Utility_Pvt.ADD('Unit Of Measure Not found');
584: END IF;
585:
586: Fnd_Message.SET_NAME('CSD', 'CSD_API_INVALID_UOM');
587: --FND_MESSAGE.SET_TOKEN('ITEM',l_Concatenated_Segments);
588: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);
589: Fnd_Message.SET_TOKEN('UOM', p_Unit_Of_Measure);
590: Fnd_Msg_Pub.ADD;

Line 587: --FND_MESSAGE.SET_TOKEN('ITEM',l_Concatenated_Segments);

583: Csd_Gen_Utility_Pvt.ADD('Unit Of Measure Not found');
584: END IF;
585:
586: Fnd_Message.SET_NAME('CSD', 'CSD_API_INVALID_UOM');
587: --FND_MESSAGE.SET_TOKEN('ITEM',l_Concatenated_Segments);
588: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);
589: Fnd_Message.SET_TOKEN('UOM', p_Unit_Of_Measure);
590: Fnd_Msg_Pub.ADD;
591:

Line 588: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);

584: END IF;
585:
586: Fnd_Message.SET_NAME('CSD', 'CSD_API_INVALID_UOM');
587: --FND_MESSAGE.SET_TOKEN('ITEM',l_Concatenated_Segments);
588: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);
589: Fnd_Message.SET_TOKEN('UOM', p_Unit_Of_Measure);
590: Fnd_Msg_Pub.ADD;
591:
592: RAISE Fnd_Api.G_EXC_ERROR;

Line 589: Fnd_Message.SET_TOKEN('UOM', p_Unit_Of_Measure);

585:
586: Fnd_Message.SET_NAME('CSD', 'CSD_API_INVALID_UOM');
587: --FND_MESSAGE.SET_TOKEN('ITEM',l_Concatenated_Segments);
588: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);
589: Fnd_Message.SET_TOKEN('UOM', p_Unit_Of_Measure);
590: Fnd_Msg_Pub.ADD;
591:
592: RAISE Fnd_Api.G_EXC_ERROR;
593:

Line 652: Fnd_Message.SET_NAME('CSD', 'CSD_API_INVALID_SITE_USE_ID');

648: THEN
649: Csd_Gen_Utility_Pvt.ADD('Party Site ID Not found');
650: END IF;
651:
652: Fnd_Message.SET_NAME('CSD', 'CSD_API_INVALID_SITE_USE_ID');
653: --SU: Following tokens are added as they are necessary for complete message.
654: Fnd_Message.SET_TOKEN('PARTY_ID', p_Party_ID);
655: Fnd_Message.SET_TOKEN('PARTY_SITE_ID', p_Party_Site_ID);
656: Fnd_Message.SET_TOKEN('SITE_USE_TYPE', p_Site_Use_Type);

Line 654: Fnd_Message.SET_TOKEN('PARTY_ID', p_Party_ID);

650: END IF;
651:
652: Fnd_Message.SET_NAME('CSD', 'CSD_API_INVALID_SITE_USE_ID');
653: --SU: Following tokens are added as they are necessary for complete message.
654: Fnd_Message.SET_TOKEN('PARTY_ID', p_Party_ID);
655: Fnd_Message.SET_TOKEN('PARTY_SITE_ID', p_Party_Site_ID);
656: Fnd_Message.SET_TOKEN('SITE_USE_TYPE', p_Site_Use_Type);
657: Fnd_Msg_Pub.ADD;
658:

Line 655: Fnd_Message.SET_TOKEN('PARTY_SITE_ID', p_Party_Site_ID);

651:
652: Fnd_Message.SET_NAME('CSD', 'CSD_API_INVALID_SITE_USE_ID');
653: --SU: Following tokens are added as they are necessary for complete message.
654: Fnd_Message.SET_TOKEN('PARTY_ID', p_Party_ID);
655: Fnd_Message.SET_TOKEN('PARTY_SITE_ID', p_Party_Site_ID);
656: Fnd_Message.SET_TOKEN('SITE_USE_TYPE', p_Site_Use_Type);
657: Fnd_Msg_Pub.ADD;
658:
659: RAISE Fnd_Api.G_EXC_ERROR;

Line 656: Fnd_Message.SET_TOKEN('SITE_USE_TYPE', p_Site_Use_Type);

652: Fnd_Message.SET_NAME('CSD', 'CSD_API_INVALID_SITE_USE_ID');
653: --SU: Following tokens are added as they are necessary for complete message.
654: Fnd_Message.SET_TOKEN('PARTY_ID', p_Party_ID);
655: Fnd_Message.SET_TOKEN('PARTY_SITE_ID', p_Party_Site_ID);
656: Fnd_Message.SET_TOKEN('SITE_USE_TYPE', p_Site_Use_Type);
657: Fnd_Msg_Pub.ADD;
658:
659: RAISE Fnd_Api.G_EXC_ERROR;
660:

Line 1054: Fnd_Message.SET_NAME('CSD', 'CSD_SERNUM_STATUS_INVALID');

1050:
1051: IF l_Current_Status <> (C_Status_In_Stores)
1052: THEN
1053:
1054: Fnd_Message.SET_NAME('CSD', 'CSD_SERNUM_STATUS_INVALID');
1055: Fnd_Message.SET_TOKEN('ITEM', p_inventory_item_id);
1056: Fnd_Message.SET_TOKEN('SERIAL_NUM', p_Serial_Number);
1057: Fnd_Msg_Pub.ADD;
1058:

Line 1055: Fnd_Message.SET_TOKEN('ITEM', p_inventory_item_id);

1051: IF l_Current_Status <> (C_Status_In_Stores)
1052: THEN
1053:
1054: Fnd_Message.SET_NAME('CSD', 'CSD_SERNUM_STATUS_INVALID');
1055: Fnd_Message.SET_TOKEN('ITEM', p_inventory_item_id);
1056: Fnd_Message.SET_TOKEN('SERIAL_NUM', p_Serial_Number);
1057: Fnd_Msg_Pub.ADD;
1058:
1059: RAISE Fnd_Api.G_EXC_ERROR;

Line 1056: Fnd_Message.SET_TOKEN('SERIAL_NUM', p_Serial_Number);

1052: THEN
1053:
1054: Fnd_Message.SET_NAME('CSD', 'CSD_SERNUM_STATUS_INVALID');
1055: Fnd_Message.SET_TOKEN('ITEM', p_inventory_item_id);
1056: Fnd_Message.SET_TOKEN('SERIAL_NUM', p_Serial_Number);
1057: Fnd_Msg_Pub.ADD;
1058:
1059: RAISE Fnd_Api.G_EXC_ERROR;
1060:

Line 1076: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_SERIAL_NUMBER');

1072: THEN
1073: Csd_Gen_Utility_Pvt.ADD('Shipped Serial Number Not found');
1074: END IF;
1075:
1076: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_SERIAL_NUMBER');
1077: -- Using concatenated segments instead of item ID
1078: -- FND_MESSAGE.SET_TOKEN('ITEM_ID',p_inventory_item_id);
1079: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);
1080: Fnd_Message.SET_TOKEN('SERIAL_NUM', p_Serial_Number);

Line 1078: -- FND_MESSAGE.SET_TOKEN('ITEM_ID',p_inventory_item_id);

1074: END IF;
1075:
1076: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_SERIAL_NUMBER');
1077: -- Using concatenated segments instead of item ID
1078: -- FND_MESSAGE.SET_TOKEN('ITEM_ID',p_inventory_item_id);
1079: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);
1080: Fnd_Message.SET_TOKEN('SERIAL_NUM', p_Serial_Number);
1081: Fnd_Msg_Pub.ADD;
1082:

Line 1079: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);

1075:
1076: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_SERIAL_NUMBER');
1077: -- Using concatenated segments instead of item ID
1078: -- FND_MESSAGE.SET_TOKEN('ITEM_ID',p_inventory_item_id);
1079: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);
1080: Fnd_Message.SET_TOKEN('SERIAL_NUM', p_Serial_Number);
1081: Fnd_Msg_Pub.ADD;
1082:
1083: RAISE Fnd_Api.G_EXC_ERROR;

Line 1080: Fnd_Message.SET_TOKEN('SERIAL_NUM', p_Serial_Number);

1076: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_SERIAL_NUMBER');
1077: -- Using concatenated segments instead of item ID
1078: -- FND_MESSAGE.SET_TOKEN('ITEM_ID',p_inventory_item_id);
1079: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);
1080: Fnd_Message.SET_TOKEN('SERIAL_NUM', p_Serial_Number);
1081: Fnd_Msg_Pub.ADD;
1082:
1083: RAISE Fnd_Api.G_EXC_ERROR;
1084:

Line 1356: Fnd_Message.SET_NAME('CSD',

1352: THEN
1353: Csd_Gen_Utility_Pvt.ADD('Revision column should be Null');
1354: END IF;
1355:
1356: Fnd_Message.SET_NAME('CSD',
1357: 'CSD_ATTRB_VALUE_NOT_EXPECTED');
1358:
1359: Fnd_Message.SET_TOKEN('ATTRIBUTE', 'Revision');
1360: Fnd_Msg_Pub.ADD;

Line 1359: Fnd_Message.SET_TOKEN('ATTRIBUTE', 'Revision');

1355:
1356: Fnd_Message.SET_NAME('CSD',
1357: 'CSD_ATTRB_VALUE_NOT_EXPECTED');
1358:
1359: Fnd_Message.SET_TOKEN('ATTRIBUTE', 'Revision');
1360: Fnd_Msg_Pub.ADD;
1361:
1362: RAISE Fnd_Api.G_EXC_ERROR;
1363:

Line 1380: Fnd_Message.SET_NAME('CSD', 'CSD_ATTRB_VALUE_NOT_EXPECTED');

1376: THEN
1377: Csd_Gen_Utility_Pvt.ADD('Reason_Code column should be Null for Ship line');
1378: END IF;
1379:
1380: Fnd_Message.SET_NAME('CSD', 'CSD_ATTRB_VALUE_NOT_EXPECTED');
1381: Fnd_Message.SET_TOKEN('ATTRIBUTE', 'Return Reason Code');
1382: Fnd_Msg_Pub.ADD;
1383:
1384: RAISE Fnd_Api.G_EXC_ERROR;

Line 1381: Fnd_Message.SET_TOKEN('ATTRIBUTE', 'Return Reason Code');

1377: Csd_Gen_Utility_Pvt.ADD('Reason_Code column should be Null for Ship line');
1378: END IF;
1379:
1380: Fnd_Message.SET_NAME('CSD', 'CSD_ATTRB_VALUE_NOT_EXPECTED');
1381: Fnd_Message.SET_TOKEN('ATTRIBUTE', 'Return Reason Code');
1382: Fnd_Msg_Pub.ADD;
1383:
1384: RAISE Fnd_Api.G_EXC_ERROR;
1385:

Line 1423: Fnd_Message.SET_NAME('CSD', 'CSD_ATTRB_VALUE_NOT_EXPECTED');

1419: THEN
1420: Csd_Gen_Utility_Pvt.ADD('non_source_Serial_Number column should be Null for RMA line');
1421: END IF;
1422:
1423: Fnd_Message.SET_NAME('CSD', 'CSD_ATTRB_VALUE_NOT_EXPECTED');
1424: Fnd_Message.SET_TOKEN('ATTRIBUTE',
1425: 'non source Serial Number');
1426: Fnd_Msg_Pub.ADD;
1427: RAISE Fnd_Api.G_EXC_ERROR;

Line 1424: Fnd_Message.SET_TOKEN('ATTRIBUTE',

1420: Csd_Gen_Utility_Pvt.ADD('non_source_Serial_Number column should be Null for RMA line');
1421: END IF;
1422:
1423: Fnd_Message.SET_NAME('CSD', 'CSD_ATTRB_VALUE_NOT_EXPECTED');
1424: Fnd_Message.SET_TOKEN('ATTRIBUTE',
1425: 'non source Serial Number');
1426: Fnd_Msg_Pub.ADD;
1427: RAISE Fnd_Api.G_EXC_ERROR;
1428:

Line 1442: Fnd_Message.SET_NAME('CSD', 'CSD_ATTRB_VALUE_NOT_EXPECTED');

1438: THEN
1439: Csd_Gen_Utility_Pvt.ADD('non_source_instance_id column should be Null for RMA line');
1440: END IF;
1441:
1442: Fnd_Message.SET_NAME('CSD', 'CSD_ATTRB_VALUE_NOT_EXPECTED');
1443: Fnd_Message.SET_TOKEN('ATTRIBUTE',
1444: 'non source instance_id');
1445: Fnd_Msg_Pub.ADD;
1446: RAISE Fnd_Api.G_EXC_ERROR;

Line 1443: Fnd_Message.SET_TOKEN('ATTRIBUTE',

1439: Csd_Gen_Utility_Pvt.ADD('non_source_instance_id column should be Null for RMA line');
1440: END IF;
1441:
1442: Fnd_Message.SET_NAME('CSD', 'CSD_ATTRB_VALUE_NOT_EXPECTED');
1443: Fnd_Message.SET_TOKEN('ATTRIBUTE',
1444: 'non source instance_id');
1445: Fnd_Msg_Pub.ADD;
1446: RAISE Fnd_Api.G_EXC_ERROR;
1447:

Line 1463: Fnd_Message.SET_NAME('CSD', 'CSD_ATTRB_VALUE_NOT_EXPECTED');

1459: THEN
1460: Csd_Gen_Utility_Pvt.ADD('Return_By_Date column should be Null for RMA line');
1461: END IF;
1462:
1463: Fnd_Message.SET_NAME('CSD', 'CSD_ATTRB_VALUE_NOT_EXPECTED');
1464: Fnd_Message.SET_TOKEN('ATTRIBUTE', 'Return By Date');
1465: Fnd_Msg_Pub.ADD;
1466:
1467: RAISE Fnd_Api.G_EXC_ERROR;

Line 1464: Fnd_Message.SET_TOKEN('ATTRIBUTE', 'Return By Date');

1460: Csd_Gen_Utility_Pvt.ADD('Return_By_Date column should be Null for RMA line');
1461: END IF;
1462:
1463: Fnd_Message.SET_NAME('CSD', 'CSD_ATTRB_VALUE_NOT_EXPECTED');
1464: Fnd_Message.SET_TOKEN('ATTRIBUTE', 'Return By Date');
1465: Fnd_Msg_Pub.ADD;
1466:
1467: RAISE Fnd_Api.G_EXC_ERROR;
1468:

Line 1509: Fnd_Message.SET_NAME('CSD',

1505: -- attribute value not expected.
1506: IF NVL(p_Upd_ProdTxn_Rec.source_Serial_Number,
1507: Fnd_Api.G_MISS_CHAR) <> Fnd_Api.G_MISS_CHAR
1508: THEN
1509: Fnd_Message.SET_NAME('CSD',
1510: 'CSD_ATTRB_VALUE_NOT_EXPECTED');
1511: Fnd_Message.SET_TOKEN('ATTRIBUTE',
1512: 'source_Serial Number');
1513: Fnd_Msg_Pub.ADD;

Line 1511: Fnd_Message.SET_TOKEN('ATTRIBUTE',

1507: Fnd_Api.G_MISS_CHAR) <> Fnd_Api.G_MISS_CHAR
1508: THEN
1509: Fnd_Message.SET_NAME('CSD',
1510: 'CSD_ATTRB_VALUE_NOT_EXPECTED');
1511: Fnd_Message.SET_TOKEN('ATTRIBUTE',
1512: 'source_Serial Number');
1513: Fnd_Msg_Pub.ADD;
1514: RAISE Fnd_Api.G_EXC_ERROR;
1515: END IF;

Line 1519: Fnd_Message.SET_NAME('CSD',

1515: END IF;
1516: IF NVL(p_Upd_ProdTxn_Rec.non_source_Serial_Number,
1517: Fnd_Api.G_MISS_CHAR) <> Fnd_Api.G_MISS_CHAR
1518: THEN
1519: Fnd_Message.SET_NAME('CSD',
1520: 'CSD_ATTRB_VALUE_NOT_EXPECTED');
1521: Fnd_Message.SET_TOKEN('ATTRIBUTE',
1522: 'non_source_Serial Number');
1523: Fnd_Msg_Pub.ADD;

Line 1521: Fnd_Message.SET_TOKEN('ATTRIBUTE',

1517: Fnd_Api.G_MISS_CHAR) <> Fnd_Api.G_MISS_CHAR
1518: THEN
1519: Fnd_Message.SET_NAME('CSD',
1520: 'CSD_ATTRB_VALUE_NOT_EXPECTED');
1521: Fnd_Message.SET_TOKEN('ATTRIBUTE',
1522: 'non_source_Serial Number');
1523: Fnd_Msg_Pub.ADD;
1524: RAISE Fnd_Api.G_EXC_ERROR;
1525: END IF;

Line 1560: Fnd_Message.SET_NAME('CSD',

1556: ELSE
1557: IF NVL(p_Upd_ProdTxn_Rec.source_Instance_id,
1558: Fnd_Api.G_MISS_NUM) <> Fnd_Api.G_MISS_NUM
1559: THEN
1560: Fnd_Message.SET_NAME('CSD',
1561: 'CSD_ATTRB_VALUE_NOT_EXPECTED');
1562: Fnd_Message.SET_TOKEN('ATTRIBUTE', 'Instance Id');
1563: Fnd_Msg_Pub.ADD;
1564: RAISE Fnd_Api.G_EXC_ERROR;

Line 1562: Fnd_Message.SET_TOKEN('ATTRIBUTE', 'Instance Id');

1558: Fnd_Api.G_MISS_NUM) <> Fnd_Api.G_MISS_NUM
1559: THEN
1560: Fnd_Message.SET_NAME('CSD',
1561: 'CSD_ATTRB_VALUE_NOT_EXPECTED');
1562: Fnd_Message.SET_TOKEN('ATTRIBUTE', 'Instance Id');
1563: Fnd_Msg_Pub.ADD;
1564: RAISE Fnd_Api.G_EXC_ERROR;
1565: END IF;
1566:

Line 1579: Fnd_Message.SET_NAME('CSD',

1575: IF NVL(p_Product_Txn_Rec.source_Serial_Number, '-') <>
1576: NVL(l_Serial_Number, '-')
1577: THEN
1578:
1579: Fnd_Message.SET_NAME('CSD',
1580: 'CSD_SRNUM_INST_NUM_MISMATCH');
1581: -- Using concatenated segments instead of item ID
1582: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);
1583: Fnd_Message.SET_TOKEN('SERIAL_NUM', l_Serial_Number);

Line 1582: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);

1578:
1579: Fnd_Message.SET_NAME('CSD',
1580: 'CSD_SRNUM_INST_NUM_MISMATCH');
1581: -- Using concatenated segments instead of item ID
1582: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);
1583: Fnd_Message.SET_TOKEN('SERIAL_NUM', l_Serial_Number);
1584: Fnd_Message.SET_TOKEN('INSTANCE_NUM',
1585: l_Instance_Number);
1586: Fnd_Msg_Pub.ADD;

Line 1583: Fnd_Message.SET_TOKEN('SERIAL_NUM', l_Serial_Number);

1579: Fnd_Message.SET_NAME('CSD',
1580: 'CSD_SRNUM_INST_NUM_MISMATCH');
1581: -- Using concatenated segments instead of item ID
1582: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);
1583: Fnd_Message.SET_TOKEN('SERIAL_NUM', l_Serial_Number);
1584: Fnd_Message.SET_TOKEN('INSTANCE_NUM',
1585: l_Instance_Number);
1586: Fnd_Msg_Pub.ADD;
1587:

Line 1584: Fnd_Message.SET_TOKEN('INSTANCE_NUM',

1580: 'CSD_SRNUM_INST_NUM_MISMATCH');
1581: -- Using concatenated segments instead of item ID
1582: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);
1583: Fnd_Message.SET_TOKEN('SERIAL_NUM', l_Serial_Number);
1584: Fnd_Message.SET_TOKEN('INSTANCE_NUM',
1585: l_Instance_Number);
1586: Fnd_Msg_Pub.ADD;
1587:
1588: RAISE Fnd_Api.G_EXC_ERROR;

Line 1596: Fnd_Message.SET_NAME('CSD',

1592: IF NVL(p_Product_Txn_Rec.non_source_Serial_Number, '-') <>
1593: NVL(l_non_src_Serial_Number, '-')
1594: THEN
1595:
1596: Fnd_Message.SET_NAME('CSD',
1597: 'CSD_SRNUM_INST_NUM_MISMATCH');
1598: -- Using concatenated segments instead of item ID
1599: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);
1600: Fnd_Message.SET_TOKEN('SERIAL_NUM',

Line 1599: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);

1595:
1596: Fnd_Message.SET_NAME('CSD',
1597: 'CSD_SRNUM_INST_NUM_MISMATCH');
1598: -- Using concatenated segments instead of item ID
1599: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);
1600: Fnd_Message.SET_TOKEN('SERIAL_NUM',
1601: l_non_src_Serial_Number);
1602: Fnd_Message.SET_TOKEN('INSTANCE_NUM',
1603: l_non_src_Instance_Number);

Line 1600: Fnd_Message.SET_TOKEN('SERIAL_NUM',

1596: Fnd_Message.SET_NAME('CSD',
1597: 'CSD_SRNUM_INST_NUM_MISMATCH');
1598: -- Using concatenated segments instead of item ID
1599: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);
1600: Fnd_Message.SET_TOKEN('SERIAL_NUM',
1601: l_non_src_Serial_Number);
1602: Fnd_Message.SET_TOKEN('INSTANCE_NUM',
1603: l_non_src_Instance_Number);
1604: Fnd_Msg_Pub.ADD;

Line 1602: Fnd_Message.SET_TOKEN('INSTANCE_NUM',

1598: -- Using concatenated segments instead of item ID
1599: Fnd_Message.SET_TOKEN('ITEM', g_Concatenated_Segments);
1600: Fnd_Message.SET_TOKEN('SERIAL_NUM',
1601: l_non_src_Serial_Number);
1602: Fnd_Message.SET_TOKEN('INSTANCE_NUM',
1603: l_non_src_Instance_Number);
1604: Fnd_Msg_Pub.ADD;
1605:
1606: RAISE Fnd_Api.G_EXC_ERROR;

Line 1954: Fnd_Message.SET_NAME('CSD', 'CSD_PRODTXN_ATTRB_CHANGED');

1950:
1951: EXCEPTION
1952: WHEN Fnd_Api.G_EXC_ERROR THEN
1953: --JG:02/25: Corrected message code. Removed space at the end.
1954: Fnd_Message.SET_NAME('CSD', 'CSD_PRODTXN_ATTRB_CHANGED');
1955: Fnd_Message.SET_TOKEN('PRODTXN_STATUS',
1956: l_ProdTxnStatus_Meaning);
1957: Fnd_Message.SET_TOKEN('ATTRB', l_Attribute);
1958: Fnd_Msg_Pub.ADD;

Line 1955: Fnd_Message.SET_TOKEN('PRODTXN_STATUS',

1951: EXCEPTION
1952: WHEN Fnd_Api.G_EXC_ERROR THEN
1953: --JG:02/25: Corrected message code. Removed space at the end.
1954: Fnd_Message.SET_NAME('CSD', 'CSD_PRODTXN_ATTRB_CHANGED');
1955: Fnd_Message.SET_TOKEN('PRODTXN_STATUS',
1956: l_ProdTxnStatus_Meaning);
1957: Fnd_Message.SET_TOKEN('ATTRB', l_Attribute);
1958: Fnd_Msg_Pub.ADD;
1959: x_return_status := Fnd_Api.G_Ret_Sts_Error;

Line 1957: Fnd_Message.SET_TOKEN('ATTRB', l_Attribute);

1953: --JG:02/25: Corrected message code. Removed space at the end.
1954: Fnd_Message.SET_NAME('CSD', 'CSD_PRODTXN_ATTRB_CHANGED');
1955: Fnd_Message.SET_TOKEN('PRODTXN_STATUS',
1956: l_ProdTxnStatus_Meaning);
1957: Fnd_Message.SET_TOKEN('ATTRB', l_Attribute);
1958: Fnd_Msg_Pub.ADD;
1959: x_return_status := Fnd_Api.G_Ret_Sts_Error;
1960: Fnd_Msg_Pub.Count_AND_Get(p_count => x_msg_count,
1961: p_data => x_msg_data);

Line 2026: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_ITEM');

2022: AND organization_id = p_Inv_Org_id;
2023:
2024: EXCEPTION
2025: WHEN OTHERS THEN
2026: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_ITEM');
2027: Fnd_Message.SET_TOKEN('ITEM_ID', p_Inventory_Item_Id);
2028: Fnd_Msg_Pub.ADD;
2029:
2030: RAISE Fnd_Api.G_EXC_ERROR;

Line 2027: Fnd_Message.SET_TOKEN('ITEM_ID', p_Inventory_Item_Id);

2023:
2024: EXCEPTION
2025: WHEN OTHERS THEN
2026: Fnd_Message.SET_NAME('CSD', 'CSD_INVALID_ITEM');
2027: Fnd_Message.SET_TOKEN('ITEM_ID', p_Inventory_Item_Id);
2028: Fnd_Msg_Pub.ADD;
2029:
2030: RAISE Fnd_Api.G_EXC_ERROR;
2031:

Line 2063: Fnd_Message.SET_NAME('CSD', 'CSD_INV_REP_LINE_ID');

2059: FROM CSD_REPAIRS
2060: WHERE repair_line_id = p_repair_line_id;
2061: EXCEPTION
2062: WHEN OTHERS THEN
2063: Fnd_Message.SET_NAME('CSD', 'CSD_INV_REP_LINE_ID');
2064: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID', p_repair_line_id);
2065: Fnd_Msg_Pub.ADD;
2066: Debug('Invalid repair line id =' || p_repair_line_id,
2067: l_mod_name,

Line 2064: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID', p_repair_line_id);

2060: WHERE repair_line_id = p_repair_line_id;
2061: EXCEPTION
2062: WHEN OTHERS THEN
2063: Fnd_Message.SET_NAME('CSD', 'CSD_INV_REP_LINE_ID');
2064: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID', p_repair_line_id);
2065: Fnd_Msg_Pub.ADD;
2066: Debug('Invalid repair line id =' || p_repair_line_id,
2067: l_mod_name,
2068: 1);

Line 2079: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_SR_ID');

2075: FETCH cur_order_rec
2076: INTO x_order_rec.party_id, x_order_rec.account_id;
2077: CLOSE cur_order_rec;
2078: ELSE
2079: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_SR_ID');
2080: Fnd_Message.SET_TOKEN('INCIDENT_ID', l_incident_id);
2081: Fnd_Msg_Pub.ADD;
2082: Debug('incident Id missing ', l_mod_name, 1);
2083: RAISE Fnd_Api.G_EXC_ERROR;

Line 2080: Fnd_Message.SET_TOKEN('INCIDENT_ID', l_incident_id);

2076: INTO x_order_rec.party_id, x_order_rec.account_id;
2077: CLOSE cur_order_rec;
2078: ELSE
2079: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_SR_ID');
2080: Fnd_Message.SET_TOKEN('INCIDENT_ID', l_incident_id);
2081: Fnd_Msg_Pub.ADD;
2082: Debug('incident Id missing ', l_mod_name, 1);
2083: RAISE Fnd_Api.G_EXC_ERROR;
2084: END IF;

Line 2230: Fnd_Message.SET_NAME('CSD', 'CSD_ERR_PROD_TXN_STATUS');

2226: WHERE lookup_type = 'CSD_PRODUCT_TXN_STATUS'
2227: AND lookup_code = p_product_txn_rec.PROD_TXN_STATUS;
2228: EXCEPTION
2229: WHEN NO_DATA_FOUND THEN
2230: Fnd_Message.SET_NAME('CSD', 'CSD_ERR_PROD_TXN_STATUS');
2231: Fnd_Msg_Pub.ADD;
2232: RAISE Fnd_Api.G_EXC_ERROR;
2233: END;
2234: END IF;

Line 2290: Fnd_Message.SET_NAME('CSD', 'CSD_INV_PICK_RULE');

2286: FETCH cur_pick_rules
2287: INTO l_tmp_char;
2288: IF (cur_pick_rules%NOTFOUND)
2289: THEN
2290: Fnd_Message.SET_NAME('CSD', 'CSD_INV_PICK_RULE');
2291: Fnd_Msg_Pub.ADD;
2292: RAISE Fnd_Api.G_EXC_ERROR;
2293: END IF;
2294: END IF;

Line 2426: Fnd_Message.SET_NAME('CSD', 'CSD_API_SERIAL_NUM_MISSING');

2422: ('SHIP', 'WALK_IN_ISSUE') AND
2423: (p_product_txn_rec.action_code <> 'LOANER' AND
2424: p_product_txn_rec.action_type <> 'RMA')
2425: THEN
2426: Fnd_Message.SET_NAME('CSD', 'CSD_API_SERIAL_NUM_MISSING');
2427: Fnd_Message.SET_TOKEN('INVENTORY_ITEM_ID',
2428: p_product_txn_rec.inventory_item_id);
2429: Fnd_Msg_Pub.ADD;
2430: Debug('Serial Number missing for inventory_item_id =' ||

Line 2427: Fnd_Message.SET_TOKEN('INVENTORY_ITEM_ID',

2423: (p_product_txn_rec.action_code <> 'LOANER' AND
2424: p_product_txn_rec.action_type <> 'RMA')
2425: THEN
2426: Fnd_Message.SET_NAME('CSD', 'CSD_API_SERIAL_NUM_MISSING');
2427: Fnd_Message.SET_TOKEN('INVENTORY_ITEM_ID',
2428: p_product_txn_rec.inventory_item_id);
2429: Fnd_Msg_Pub.ADD;
2430: Debug('Serial Number missing for inventory_item_id =' ||
2431: p_product_txn_rec.inventory_item_id,

Line 2679: FND_MESSAGE.SET_NAME('CSD','CSD_API_INTERFACE_FAILED'); /Fixed for bug#5147030 message changed/

2675: WHERE estimate_detail_id = p_prodtxn_db_attr.est_detail_id
2676: AND order_line_id IS NULL;
2677: EXCEPTION
2678: WHEN NO_DATA_FOUND THEN
2679: FND_MESSAGE.SET_NAME('CSD','CSD_API_INTERFACE_FAILED'); /*Fixed for bug#5147030 message changed*/
2680:
2681: /*Fnd_Message.SET_NAME('CSD',
2682: 'CSD_API_INV_EST_DETAIL_ID');
2683: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',

Line 2681: /*Fnd_Message.SET_NAME('CSD',

2677: EXCEPTION
2678: WHEN NO_DATA_FOUND THEN
2679: FND_MESSAGE.SET_NAME('CSD','CSD_API_INTERFACE_FAILED'); /*Fixed for bug#5147030 message changed*/
2680:
2681: /*Fnd_Message.SET_NAME('CSD',
2682: 'CSD_API_INV_EST_DETAIL_ID');
2683: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',
2684: p_prodtxn_db_attr.est_detail_id);
2685: */

Line 2683: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',

2679: FND_MESSAGE.SET_NAME('CSD','CSD_API_INTERFACE_FAILED'); /*Fixed for bug#5147030 message changed*/
2680:
2681: /*Fnd_Message.SET_NAME('CSD',
2682: 'CSD_API_INV_EST_DETAIL_ID');
2683: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',
2684: p_prodtxn_db_attr.est_detail_id);
2685: */
2686: Fnd_Msg_Pub.ADD;
2687: Debug('Sales Order may be interfaced already',

Line 2734: Fnd_Message.SET_NAME('CSD',

2730: AND inventory_item_id =
2731: p_product_txn_rec.inventory_item_id;
2732: EXCEPTION
2733: WHEN NO_DATA_FOUND THEN
2734: Fnd_Message.SET_NAME('CSD',
2735: 'CSD_INVALID_INVENTORY_ITEM');
2736: Fnd_Msg_Pub.ADD;
2737: RAISE CREATE_ORDER;
2738: END;

Line 2753: Fnd_Message.SET_NAME('CSD',

2749: Cs_Std.get_item_valdn_orgzn_id
2750: AND revision = p_product_txn_rec.revision;
2751: EXCEPTION
2752: WHEN NO_DATA_FOUND THEN
2753: Fnd_Message.SET_NAME('CSD',
2754: 'CSD_INVALID_REVISION');
2755: Fnd_Msg_Pub.ADD;
2756: RAISE CREATE_ORDER;
2757: END;

Line 2802: Fnd_Message.SET_NAME('CSD',

2798: WHERE product_transaction_id =
2799: p_product_txn_rec.PRODUCT_TRANSACTION_ID;
2800: IF SQL%NOTFOUND
2801: THEN
2802: Fnd_Message.SET_NAME('CSD',
2803: 'CSD_ERR_PRD_TXN_UPDATE');
2804: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',
2805: p_product_txn_rec.PRODUCT_TRANSACTION_ID);
2806: Fnd_Msg_Pub.ADD;

Line 2804: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',

2800: IF SQL%NOTFOUND
2801: THEN
2802: Fnd_Message.SET_NAME('CSD',
2803: 'CSD_ERR_PRD_TXN_UPDATE');
2804: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',
2805: p_product_txn_rec.PRODUCT_TRANSACTION_ID);
2806: Fnd_Msg_Pub.ADD;
2807: RAISE CREATE_ORDER;
2808: END IF;

Line 2816: Fnd_Message.SET_NAME('CSD',

2812: WHERE repair_line_id =
2813: p_product_txn_rec.REPAIR_LINE_ID;
2814: IF SQL%NOTFOUND
2815: THEN
2816: Fnd_Message.SET_NAME('CSD',
2817: 'CSD_ERR_REPAIRS_UPDATE');
2818: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
2819: p_product_txn_rec.repair_line_id);
2820: Fnd_Msg_Pub.ADD;

Line 2818: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',

2814: IF SQL%NOTFOUND
2815: THEN
2816: Fnd_Message.SET_NAME('CSD',
2817: 'CSD_ERR_REPAIRS_UPDATE');
2818: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
2819: p_product_txn_rec.repair_line_id);
2820: Fnd_Msg_Pub.ADD;
2821: RAISE CREATE_ORDER;
2822: END IF;

Line 2856: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PROJECT_UPDATE');

2852: if (l_project_count >= 1) then
2853: l_Line_Tbl_Type(1).project_id := p_product_txn_rec.project_id;
2854: l_Line_Tbl_Type(1).task_id := p_product_txn_rec.task_id;
2855: else
2856: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PROJECT_UPDATE');
2857: FND_MESSAGE.SET_TOKEN('project_id',p_product_txn_rec.project_id);
2858: FND_MESSAGE.SET_TOKEN('ship_from_org_id',l_p_ship_from_org_id);
2859: FND_MSG_PUB.ADD;
2860: RAISE CREATE_ORDER;

Line 2857: FND_MESSAGE.SET_TOKEN('project_id',p_product_txn_rec.project_id);

2853: l_Line_Tbl_Type(1).project_id := p_product_txn_rec.project_id;
2854: l_Line_Tbl_Type(1).task_id := p_product_txn_rec.task_id;
2855: else
2856: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PROJECT_UPDATE');
2857: FND_MESSAGE.SET_TOKEN('project_id',p_product_txn_rec.project_id);
2858: FND_MESSAGE.SET_TOKEN('ship_from_org_id',l_p_ship_from_org_id);
2859: FND_MSG_PUB.ADD;
2860: RAISE CREATE_ORDER;
2861: end if;

Line 2858: FND_MESSAGE.SET_TOKEN('ship_from_org_id',l_p_ship_from_org_id);

2854: l_Line_Tbl_Type(1).task_id := p_product_txn_rec.task_id;
2855: else
2856: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PROJECT_UPDATE');
2857: FND_MESSAGE.SET_TOKEN('project_id',p_product_txn_rec.project_id);
2858: FND_MESSAGE.SET_TOKEN('ship_from_org_id',l_p_ship_from_org_id);
2859: FND_MSG_PUB.ADD;
2860: RAISE CREATE_ORDER;
2861: end if;
2862: end if;

Line 2895: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_OM_PROCESS_LINE');

2891: x_msg_data => l_msg_data
2892: );
2893:
2894: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2895: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_OM_PROCESS_LINE');
2896: FND_MSG_PUB.ADD;
2897: RAISE CREATE_ORDER;
2898: END IF;
2899:

Line 2994: FND_MESSAGE.SET_NAME('CSD','CSD_API_BOOKING_FAILED'); /Fixed for bug#5147030 message changed/

2990: WHERE a.line_id = b.order_line_id
2991: AND b.estimate_detail_id = p_product_txn_rec.estimate_detail_id;
2992: EXCEPTION
2993: WHEN NO_DATA_FOUND THEN
2994: FND_MESSAGE.SET_NAME('CSD','CSD_API_BOOKING_FAILED'); /*Fixed for bug#5147030 message changed*/
2995: /*
2996: Fnd_Message.SET_NAME('CSD',
2997: 'CSD_INV_EST_DETAIL_ID');
2998: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',

Line 2996: Fnd_Message.SET_NAME('CSD',

2992: EXCEPTION
2993: WHEN NO_DATA_FOUND THEN
2994: FND_MESSAGE.SET_NAME('CSD','CSD_API_BOOKING_FAILED'); /*Fixed for bug#5147030 message changed*/
2995: /*
2996: Fnd_Message.SET_NAME('CSD',
2997: 'CSD_INV_EST_DETAIL_ID');
2998: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',
2999: p_product_txn_rec.estimate_detail_id); */
3000: Fnd_Msg_Pub.ADD;

Line 2998: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',

2994: FND_MESSAGE.SET_NAME('CSD','CSD_API_BOOKING_FAILED'); /*Fixed for bug#5147030 message changed*/
2995: /*
2996: Fnd_Message.SET_NAME('CSD',
2997: 'CSD_INV_EST_DETAIL_ID');
2998: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',
2999: p_product_txn_rec.estimate_detail_id); */
3000: Fnd_Msg_Pub.ADD;
3001: Debug('Invalid estimate detail id = ' ||
3002: p_product_txn_rec.estimate_detail_id,

Line 3036: Fnd_Message.SET_NAME('CSD',

3032: FROM oe_order_lines_all
3033: WHERE line_id = l_order_line_id;
3034: EXCEPTION
3035: WHEN NO_DATA_FOUND THEN
3036: Fnd_Message.SET_NAME('CSD',
3037: 'CSD_API_SALES_REP_MISSING');
3038: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',
3039: l_order_line_id);
3040: Fnd_Msg_Pub.ADD;

Line 3038: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',

3034: EXCEPTION
3035: WHEN NO_DATA_FOUND THEN
3036: Fnd_Message.SET_NAME('CSD',
3037: 'CSD_API_SALES_REP_MISSING');
3038: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',
3039: l_order_line_id);
3040: Fnd_Msg_Pub.ADD;
3041: Debug('Sales rep missing for Line Id=' ||
3042: l_order_line_id,

Line 3054: Fnd_Message.SET_NAME('CSD',

3050: END;
3051:
3052: IF l_ship_from_org_id IS NULL
3053: THEN
3054: Fnd_Message.SET_NAME('CSD',
3055: 'CSD_API_SHIP_FROM_ORG_MISSING');
3056: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',
3057: l_order_line_id);
3058: Fnd_Msg_Pub.ADD;

Line 3056: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',

3052: IF l_ship_from_org_id IS NULL
3053: THEN
3054: Fnd_Message.SET_NAME('CSD',
3055: 'CSD_API_SHIP_FROM_ORG_MISSING');
3056: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',
3057: l_order_line_id);
3058: Fnd_Msg_Pub.ADD;
3059: Debug('Ship from Org Id missing for Line id=' ||
3060: l_order_line_id,

Line 3068: Fnd_Message.SET_NAME('CSD',

3064: END IF;
3065:
3066: IF l_unit_selling_price IS NULL
3067: THEN
3068: Fnd_Message.SET_NAME('CSD',
3069: 'CSD_API_PRICE_MISSING');
3070: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',
3071: l_order_line_id);
3072: Fnd_Msg_Pub.ADD;

Line 3070: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',

3066: IF l_unit_selling_price IS NULL
3067: THEN
3068: Fnd_Message.SET_NAME('CSD',
3069: 'CSD_API_PRICE_MISSING');
3070: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',
3071: l_order_line_id);
3072: Fnd_Msg_Pub.ADD;
3073: Debug('Unit selling Price missing for Line id=' ||
3074: l_order_line_id,

Line 3110: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PROJECT_UPDATE');

3106: if (l_project_count >= 1) then
3107: l_Line_Tbl_Type(1).project_id := p_product_txn_rec.project_id;
3108: l_Line_Tbl_Type(1).task_id := p_product_txn_rec.task_id;
3109: else
3110: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PROJECT_UPDATE');
3111: FND_MESSAGE.SET_TOKEN('project_id',p_product_txn_rec.project_id);
3112: FND_MESSAGE.SET_TOKEN('ship_from_org_id',l_ship_from_org_id);
3113: FND_MSG_PUB.ADD;
3114: RAISE BOOK_ORDER;

Line 3111: FND_MESSAGE.SET_TOKEN('project_id',p_product_txn_rec.project_id);

3107: l_Line_Tbl_Type(1).project_id := p_product_txn_rec.project_id;
3108: l_Line_Tbl_Type(1).task_id := p_product_txn_rec.task_id;
3109: else
3110: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PROJECT_UPDATE');
3111: FND_MESSAGE.SET_TOKEN('project_id',p_product_txn_rec.project_id);
3112: FND_MESSAGE.SET_TOKEN('ship_from_org_id',l_ship_from_org_id);
3113: FND_MSG_PUB.ADD;
3114: RAISE BOOK_ORDER;
3115: end if;

Line 3112: FND_MESSAGE.SET_TOKEN('ship_from_org_id',l_ship_from_org_id);

3108: l_Line_Tbl_Type(1).task_id := p_product_txn_rec.task_id;
3109: else
3110: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PROJECT_UPDATE');
3111: FND_MESSAGE.SET_TOKEN('project_id',p_product_txn_rec.project_id);
3112: FND_MESSAGE.SET_TOKEN('ship_from_org_id',l_ship_from_org_id);
3113: FND_MSG_PUB.ADD;
3114: RAISE BOOK_ORDER;
3115: end if;
3116: end if;

Line 3149: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_OM_PROCESS_LINE');

3145: x_msg_data => l_msg_data
3146: );
3147:
3148: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3149: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_OM_PROCESS_LINE');
3150: FND_MSG_PUB.ADD;
3151: RAISE BOOK_ORDER;
3152: END IF;
3153: end if; -- order line is not null

Line 3191: -- FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PRD_TXN_UPDATE');

3187: -- SET prod_txn_status = 'BOOKED',
3188: -- book_sales_order_flag = 'Y'
3189: -- WHERE product_transaction_id = x_product_txn_rec.PRODUCT_TRANSACTION_ID;
3190: -- IF SQL%NOTFOUND then
3191: -- FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PRD_TXN_UPDATE');
3192: -- FND_MESSAGE.SET_TOKEN('PRODUCT_TRANSACTION_ID',x_product_txn_rec.PRODUCT_TRANSACTION_ID);
3193: -- FND_MSG_PUB.ADD;
3194: -- RAISE BOOK_ORDER;
3195: -- END IF;

Line 3192: -- FND_MESSAGE.SET_TOKEN('PRODUCT_TRANSACTION_ID',x_product_txn_rec.PRODUCT_TRANSACTION_ID);

3188: -- book_sales_order_flag = 'Y'
3189: -- WHERE product_transaction_id = x_product_txn_rec.PRODUCT_TRANSACTION_ID;
3190: -- IF SQL%NOTFOUND then
3191: -- FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PRD_TXN_UPDATE');
3192: -- FND_MESSAGE.SET_TOKEN('PRODUCT_TRANSACTION_ID',x_product_txn_rec.PRODUCT_TRANSACTION_ID);
3193: -- FND_MSG_PUB.ADD;
3194: -- RAISE BOOK_ORDER;
3195: -- END IF;
3196:

Line 3207: Fnd_Message.SET_NAME('CSD',

3203: WHERE repair_line_id =
3204: p_product_txn_rec.REPAIR_LINE_ID;
3205: IF SQL%NOTFOUND
3206: THEN
3207: Fnd_Message.SET_NAME('CSD',
3208: 'CSD_ERR_REPAIRS_UPDATE');
3209: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3210: p_product_txn_rec.repair_line_id);
3211: Fnd_Msg_Pub.ADD;

Line 3209: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',

3205: IF SQL%NOTFOUND
3206: THEN
3207: Fnd_Message.SET_NAME('CSD',
3208: 'CSD_ERR_REPAIRS_UPDATE');
3209: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3210: p_product_txn_rec.repair_line_id);
3211: Fnd_Msg_Pub.ADD;
3212: RAISE BOOK_ORDER;
3213: END IF;

Line 3227: -- FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PRD_TXN_UPDATE');

3223: -- SET prod_txn_status = 'BOOKED',
3224: -- book_sales_order_flag = 'Y'
3225: -- WHERE product_transaction_id = x_product_txn_rec.PRODUCT_TRANSACTION_ID;
3226: -- IF SQL%NOTFOUND then
3227: -- FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PRD_TXN_UPDATE');
3228: -- FND_MESSAGE.SET_TOKEN('PRODUCT_TRANSACTION_ID',x_product_txn_rec.PRODUCT_TRANSACTION_ID);
3229: -- FND_MSG_PUB.ADD;
3230: -- RAISE BOOK_ORDER;
3231: -- END IF;

Line 3228: -- FND_MESSAGE.SET_TOKEN('PRODUCT_TRANSACTION_ID',x_product_txn_rec.PRODUCT_TRANSACTION_ID);

3224: -- book_sales_order_flag = 'Y'
3225: -- WHERE product_transaction_id = x_product_txn_rec.PRODUCT_TRANSACTION_ID;
3226: -- IF SQL%NOTFOUND then
3227: -- FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PRD_TXN_UPDATE');
3228: -- FND_MESSAGE.SET_TOKEN('PRODUCT_TRANSACTION_ID',x_product_txn_rec.PRODUCT_TRANSACTION_ID);
3229: -- FND_MSG_PUB.ADD;
3230: -- RAISE BOOK_ORDER;
3231: -- END IF;
3232:

Line 3243: Fnd_Message.SET_NAME('CSD',

3239: WHERE repair_line_id =
3240: p_product_txn_rec.REPAIR_LINE_ID;
3241: IF SQL%NOTFOUND
3242: THEN
3243: Fnd_Message.SET_NAME('CSD',
3244: 'CSD_ERR_REPAIRS_UPDATE');
3245: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3246: p_product_txn_rec.repair_line_id);
3247: Fnd_Msg_Pub.ADD;

Line 3245: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',

3241: IF SQL%NOTFOUND
3242: THEN
3243: Fnd_Message.SET_NAME('CSD',
3244: 'CSD_ERR_REPAIRS_UPDATE');
3245: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3246: p_product_txn_rec.repair_line_id);
3247: Fnd_Msg_Pub.ADD;
3248: RAISE BOOK_ORDER;
3249: END IF;

Line 3382: Fnd_Message.SET_NAME('CSD',

3378: Debug('Calling reserve serial..', l_mod_name, 1);
3379: Reserve_serial_number(l_serial_rsv_rec, l_return_status);
3380:
3381: if(l_return_status = FND_API.G_RET_STS_ERROR) THEN
3382: Fnd_Message.SET_NAME('CSD',
3383: 'CSD_SRL_RESERVE_FAILED');
3384: Fnd_Msg_Pub.ADD;
3385: RAISE RELEASE_ORDER;
3386: END IF;

Line 3421: Fnd_Message.SET_NAME('CSD',

3417: NVL(END_DATE_ACTIVE, SYSDATE + 1);
3418: px_order_rec.picking_rule_id := l_picking_rule_id;
3419: EXCEPTION
3420: WHEN NO_DATA_FOUND THEN
3421: Fnd_Message.SET_NAME('CSD',
3422: 'CSD_API_INV_PICKING_RULE_ID');
3423: Fnd_Message.SET_TOKEN('PICKING_RULE_ID',
3424: px_order_rec.picking_rule_id);
3425: Fnd_Msg_Pub.ADD;

Line 3423: Fnd_Message.SET_TOKEN('PICKING_RULE_ID',

3419: EXCEPTION
3420: WHEN NO_DATA_FOUND THEN
3421: Fnd_Message.SET_NAME('CSD',
3422: 'CSD_API_INV_PICKING_RULE_ID');
3423: Fnd_Message.SET_TOKEN('PICKING_RULE_ID',
3424: px_order_rec.picking_rule_id);
3425: Fnd_Msg_Pub.ADD;
3426: RAISE RELEASE_ORDER;
3427: WHEN TOO_MANY_ROWS THEN

Line 3503: Fnd_Message.SET_NAME('CSD',

3499: AND a.released_status in ('R','B');
3500:
3501: EXCEPTION
3502: WHEN NO_DATA_FOUND THEN
3503: Fnd_Message.SET_NAME('CSD',
3504: 'CSD_INV_EST_DETAIL_ID');
3505: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',
3506: p_product_txn_rec.estimate_detail_id);
3507: Fnd_Msg_Pub.ADD;

Line 3505: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',

3501: EXCEPTION
3502: WHEN NO_DATA_FOUND THEN
3503: Fnd_Message.SET_NAME('CSD',
3504: 'CSD_INV_EST_DETAIL_ID');
3505: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',
3506: p_product_txn_rec.estimate_detail_id);
3507: Fnd_Msg_Pub.ADD;
3508: Debug('Invalid estimate detail ID = ' ||
3509: p_product_txn_rec.estimate_detail_id,

Line 3594: Fnd_Message.SET_NAME('CSD',

3590: AND a.released_status in ('R','B','S');
3591:
3592: EXCEPTION
3593: WHEN NO_DATA_FOUND THEN
3594: Fnd_Message.SET_NAME('CSD',
3595: 'CSD_INV_EST_DETAIL_ID');
3596: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',
3597: p_product_txn_rec.estimate_detail_id);
3598: Fnd_Msg_Pub.ADD;

Line 3596: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',

3592: EXCEPTION
3593: WHEN NO_DATA_FOUND THEN
3594: Fnd_Message.SET_NAME('CSD',
3595: 'CSD_INV_EST_DETAIL_ID');
3596: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',
3597: p_product_txn_rec.estimate_detail_id);
3598: Fnd_Msg_Pub.ADD;
3599: Debug('Invalid estimate detail ID = ' ||
3600: p_product_txn_rec.estimate_detail_id,

Line 3624: Fnd_Message.SET_NAME('CSD',

3620: WHERE product_transaction_id =
3621: p_product_txn_rec.PRODUCT_TRANSACTION_ID;
3622: IF SQL%NOTFOUND
3623: THEN
3624: Fnd_Message.SET_NAME('CSD',
3625: 'CSD_ERR_PRD_TXN_UPDATE');
3626: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',
3627: p_product_txn_rec.PRODUCT_TRANSACTION_ID);
3628: Fnd_Msg_Pub.ADD;

Line 3626: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',

3622: IF SQL%NOTFOUND
3623: THEN
3624: Fnd_Message.SET_NAME('CSD',
3625: 'CSD_ERR_PRD_TXN_UPDATE');
3626: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',
3627: p_product_txn_rec.PRODUCT_TRANSACTION_ID);
3628: Fnd_Msg_Pub.ADD;
3629: RAISE RELEASE_ORDER;
3630: END IF;

Line 3639: Fnd_Message.SET_NAME('CSD',

3635: WHERE repair_line_id =
3636: p_product_txn_rec.REPAIR_LINE_ID;
3637: IF SQL%NOTFOUND
3638: THEN
3639: Fnd_Message.SET_NAME('CSD',
3640: 'CSD_ERR_REPAIRS_UPDATE');
3641: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3642: p_product_txn_rec.repair_line_id);
3643: Fnd_Msg_Pub.ADD;

Line 3641: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',

3637: IF SQL%NOTFOUND
3638: THEN
3639: Fnd_Message.SET_NAME('CSD',
3640: 'CSD_ERR_REPAIRS_UPDATE');
3641: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3642: p_product_txn_rec.repair_line_id);
3643: Fnd_Msg_Pub.ADD;
3644: RAISE RELEASE_ORDER;
3645: END IF;

Line 3716: FND_MESSAGE.SET_NAME('CSD','CSD_API_SHIPPING_FAILD'); /Fixed for bug#5147030 message changed/

3712: AND b.estimate_detail_id = c.estimate_detail_id
3713: AND b.estimate_detail_id = p_product_txn_rec.estimate_detail_id;
3714: EXCEPTION
3715: WHEN NO_DATA_FOUND THEN
3716: FND_MESSAGE.SET_NAME('CSD','CSD_API_SHIPPING_FAILD'); /*Fixed for bug#5147030 message changed*/
3717: /*
3718: Fnd_Message.SET_NAME('CSD',
3719: 'CSD_API_INV_EST_DETAIL_ID');
3720: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',

Line 3718: Fnd_Message.SET_NAME('CSD',

3714: EXCEPTION
3715: WHEN NO_DATA_FOUND THEN
3716: FND_MESSAGE.SET_NAME('CSD','CSD_API_SHIPPING_FAILD'); /*Fixed for bug#5147030 message changed*/
3717: /*
3718: Fnd_Message.SET_NAME('CSD',
3719: 'CSD_API_INV_EST_DETAIL_ID');
3720: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',
3721: p_product_txn_rec.estimate_detail_id);
3722: */

Line 3720: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',

3716: FND_MESSAGE.SET_NAME('CSD','CSD_API_SHIPPING_FAILD'); /*Fixed for bug#5147030 message changed*/
3717: /*
3718: Fnd_Message.SET_NAME('CSD',
3719: 'CSD_API_INV_EST_DETAIL_ID');
3720: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',
3721: p_product_txn_rec.estimate_detail_id);
3722: */
3723: Fnd_Msg_Pub.ADD;
3724: Debug('Invalid Estimate Detail Id = ' ||

Line 3757: Fnd_Message.SET_NAME('CSD',

3753: px_order_rec.order_header_id
3754: AND source_line_id = px_order_rec.order_line_id;
3755: EXCEPTION
3756: WHEN NO_DATA_FOUND THEN
3757: Fnd_Message.SET_NAME('CSD',
3758: 'CSD_RELEASE_FAILED');
3759: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',
3760: px_order_rec.order_line_id);
3761: Fnd_Msg_Pub.ADD;

Line 3759: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',

3755: EXCEPTION
3756: WHEN NO_DATA_FOUND THEN
3757: Fnd_Message.SET_NAME('CSD',
3758: 'CSD_RELEASE_FAILED');
3759: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',
3760: px_order_rec.order_line_id);
3761: Fnd_Msg_Pub.ADD;
3762: RAISE SHIP_ORDER;
3763: WHEN TOO_MANY_ROWS THEN

Line 3810: Fnd_Message.SET_NAME('CSD',

3806: WHERE product_transaction_id =
3807: p_product_txn_rec.PRODUCT_TRANSACTION_ID;
3808: IF SQL%NOTFOUND
3809: THEN
3810: Fnd_Message.SET_NAME('CSD',
3811: 'CSD_ERR_PRD_TXN_UPDATE');
3812: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',
3813: p_product_txn_rec.PRODUCT_TRANSACTION_ID);
3814: Fnd_Msg_Pub.ADD;

Line 3812: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',

3808: IF SQL%NOTFOUND
3809: THEN
3810: Fnd_Message.SET_NAME('CSD',
3811: 'CSD_ERR_PRD_TXN_UPDATE');
3812: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',
3813: p_product_txn_rec.PRODUCT_TRANSACTION_ID);
3814: Fnd_Msg_Pub.ADD;
3815: RAISE SHIP_ORDER;
3816: END IF;

Line 3825: Fnd_Message.SET_NAME('CSD',

3821: WHERE repair_line_id =
3822: p_product_txn_rec.REPAIR_LINE_ID;
3823: IF SQL%NOTFOUND
3824: THEN
3825: Fnd_Message.SET_NAME('CSD',
3826: 'CSD_ERR_REPAIRS_UPDATE');
3827: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3828: p_product_txn_rec.repair_line_id);
3829: Fnd_Msg_Pub.ADD;

Line 3827: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',

3823: IF SQL%NOTFOUND
3824: THEN
3825: Fnd_Message.SET_NAME('CSD',
3826: 'CSD_ERR_REPAIRS_UPDATE');
3827: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3828: p_product_txn_rec.repair_line_id);
3829: Fnd_Msg_Pub.ADD;
3830: RAISE SHIP_ORDER;
3831: END IF;

Line 3846: Fnd_Message.SET_NAME('CSD',

3842: WHERE product_transaction_id =
3843: p_product_txn_rec.PRODUCT_TRANSACTION_ID;
3844: IF SQL%NOTFOUND
3845: THEN
3846: Fnd_Message.SET_NAME('CSD',
3847: 'CSD_ERR_PRD_TXN_UPDATE');
3848: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',
3849: p_product_txn_rec.PRODUCT_TRANSACTION_ID);
3850: Fnd_Msg_Pub.ADD;

Line 3848: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',

3844: IF SQL%NOTFOUND
3845: THEN
3846: Fnd_Message.SET_NAME('CSD',
3847: 'CSD_ERR_PRD_TXN_UPDATE');
3848: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',
3849: p_product_txn_rec.PRODUCT_TRANSACTION_ID);
3850: Fnd_Msg_Pub.ADD;
3851: RAISE SHIP_ORDER;
3852: END IF;

Line 3861: Fnd_Message.SET_NAME('CSD',

3857: WHERE repair_line_id =
3858: p_product_txn_rec.REPAIR_LINE_ID;
3859: IF SQL%NOTFOUND
3860: THEN
3861: Fnd_Message.SET_NAME('CSD',
3862: 'CSD_ERR_REPAIRS_UPDATE');
3863: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3864: p_product_txn_rec.repair_line_id);
3865: Fnd_Msg_Pub.ADD;

Line 3863: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',

3859: IF SQL%NOTFOUND
3860: THEN
3861: Fnd_Message.SET_NAME('CSD',
3862: 'CSD_ERR_REPAIRS_UPDATE');
3863: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3864: p_product_txn_rec.repair_line_id);
3865: Fnd_Msg_Pub.ADD;
3866: RAISE SHIP_ORDER;
3867: END IF;

Line 3882: Fnd_Message.SET_NAME('CSD',

3878: WHERE product_transaction_id =
3879: p_product_txn_rec.PRODUCT_TRANSACTION_ID;
3880: IF SQL%NOTFOUND
3881: THEN
3882: Fnd_Message.SET_NAME('CSD',
3883: 'CSD_ERR_PRD_TXN_UPDATE');
3884: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',
3885: p_product_txn_rec.PRODUCT_TRANSACTION_ID);
3886: Fnd_Msg_Pub.ADD;

Line 3884: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',

3880: IF SQL%NOTFOUND
3881: THEN
3882: Fnd_Message.SET_NAME('CSD',
3883: 'CSD_ERR_PRD_TXN_UPDATE');
3884: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',
3885: p_product_txn_rec.PRODUCT_TRANSACTION_ID);
3886: Fnd_Msg_Pub.ADD;
3887: RAISE SHIP_ORDER;
3888: END IF;

Line 3897: Fnd_Message.SET_NAME('CSD',

3893: WHERE repair_line_id =
3894: p_product_txn_rec.REPAIR_LINE_ID;
3895: IF SQL%NOTFOUND
3896: THEN
3897: Fnd_Message.SET_NAME('CSD',
3898: 'CSD_ERR_REPAIRS_UPDATE');
3899: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3900: p_product_txn_rec.repair_line_id);
3901: Fnd_Msg_Pub.ADD;

Line 3899: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',

3895: IF SQL%NOTFOUND
3896: THEN
3897: Fnd_Message.SET_NAME('CSD',
3898: 'CSD_ERR_REPAIRS_UPDATE');
3899: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3900: p_product_txn_rec.repair_line_id);
3901: Fnd_Msg_Pub.ADD;
3902: RAISE SHIP_ORDER;
3903: END IF;