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 2855: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PROJECT_UPDATE');

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

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

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

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

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

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

2884: x_msg_data => l_msg_data
2885: );
2886:
2887: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2888: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_OM_PROCESS_LINE');
2889: FND_MSG_PUB.ADD;
2890: RAISE CREATE_ORDER;
2891: END IF;
2892:

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

2983: WHERE a.line_id = b.order_line_id
2984: AND b.estimate_detail_id = p_product_txn_rec.estimate_detail_id;
2985: EXCEPTION
2986: WHEN NO_DATA_FOUND THEN
2987: FND_MESSAGE.SET_NAME('CSD','CSD_API_BOOKING_FAILED'); /*Fixed for bug#5147030 message changed*/
2988: /*
2989: Fnd_Message.SET_NAME('CSD',
2990: 'CSD_INV_EST_DETAIL_ID');
2991: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',

Line 2989: Fnd_Message.SET_NAME('CSD',

2985: EXCEPTION
2986: WHEN NO_DATA_FOUND THEN
2987: FND_MESSAGE.SET_NAME('CSD','CSD_API_BOOKING_FAILED'); /*Fixed for bug#5147030 message changed*/
2988: /*
2989: Fnd_Message.SET_NAME('CSD',
2990: 'CSD_INV_EST_DETAIL_ID');
2991: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',
2992: p_product_txn_rec.estimate_detail_id); */
2993: Fnd_Msg_Pub.ADD;

Line 2991: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',

2987: FND_MESSAGE.SET_NAME('CSD','CSD_API_BOOKING_FAILED'); /*Fixed for bug#5147030 message changed*/
2988: /*
2989: Fnd_Message.SET_NAME('CSD',
2990: 'CSD_INV_EST_DETAIL_ID');
2991: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',
2992: p_product_txn_rec.estimate_detail_id); */
2993: Fnd_Msg_Pub.ADD;
2994: Debug('Invalid estimate detail id = ' ||
2995: p_product_txn_rec.estimate_detail_id,

Line 3029: Fnd_Message.SET_NAME('CSD',

3025: FROM oe_order_lines_all
3026: WHERE line_id = l_order_line_id;
3027: EXCEPTION
3028: WHEN NO_DATA_FOUND THEN
3029: Fnd_Message.SET_NAME('CSD',
3030: 'CSD_API_SALES_REP_MISSING');
3031: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',
3032: l_order_line_id);
3033: Fnd_Msg_Pub.ADD;

Line 3031: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',

3027: EXCEPTION
3028: WHEN NO_DATA_FOUND THEN
3029: Fnd_Message.SET_NAME('CSD',
3030: 'CSD_API_SALES_REP_MISSING');
3031: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',
3032: l_order_line_id);
3033: Fnd_Msg_Pub.ADD;
3034: Debug('Sales rep missing for Line Id=' ||
3035: l_order_line_id,

Line 3047: Fnd_Message.SET_NAME('CSD',

3043: END;
3044:
3045: IF l_ship_from_org_id IS NULL
3046: THEN
3047: Fnd_Message.SET_NAME('CSD',
3048: 'CSD_API_SHIP_FROM_ORG_MISSING');
3049: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',
3050: l_order_line_id);
3051: Fnd_Msg_Pub.ADD;

Line 3049: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',

3045: IF l_ship_from_org_id IS NULL
3046: THEN
3047: Fnd_Message.SET_NAME('CSD',
3048: 'CSD_API_SHIP_FROM_ORG_MISSING');
3049: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',
3050: l_order_line_id);
3051: Fnd_Msg_Pub.ADD;
3052: Debug('Ship from Org Id missing for Line id=' ||
3053: l_order_line_id,

Line 3061: Fnd_Message.SET_NAME('CSD',

3057: END IF;
3058:
3059: IF l_unit_selling_price IS NULL
3060: THEN
3061: Fnd_Message.SET_NAME('CSD',
3062: 'CSD_API_PRICE_MISSING');
3063: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',
3064: l_order_line_id);
3065: Fnd_Msg_Pub.ADD;

Line 3063: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',

3059: IF l_unit_selling_price IS NULL
3060: THEN
3061: Fnd_Message.SET_NAME('CSD',
3062: 'CSD_API_PRICE_MISSING');
3063: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',
3064: l_order_line_id);
3065: Fnd_Msg_Pub.ADD;
3066: Debug('Unit selling Price missing for Line id=' ||
3067: l_order_line_id,

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

3098: if (l_project_count >= 1) then
3099: l_Line_Tbl_Type(1).project_id := p_product_txn_rec.project_id;
3100: l_Line_Tbl_Type(1).task_id := p_product_txn_rec.task_id;
3101: else
3102: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PROJECT_UPDATE');
3103: FND_MESSAGE.SET_TOKEN('project_id',p_product_txn_rec.project_id);
3104: FND_MESSAGE.SET_TOKEN('ship_from_org_id',l_ship_from_org_id);
3105: FND_MSG_PUB.ADD;
3106: RAISE BOOK_ORDER;

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

3099: l_Line_Tbl_Type(1).project_id := p_product_txn_rec.project_id;
3100: l_Line_Tbl_Type(1).task_id := p_product_txn_rec.task_id;
3101: else
3102: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PROJECT_UPDATE');
3103: FND_MESSAGE.SET_TOKEN('project_id',p_product_txn_rec.project_id);
3104: FND_MESSAGE.SET_TOKEN('ship_from_org_id',l_ship_from_org_id);
3105: FND_MSG_PUB.ADD;
3106: RAISE BOOK_ORDER;
3107: end if;

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

3100: l_Line_Tbl_Type(1).task_id := p_product_txn_rec.task_id;
3101: else
3102: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PROJECT_UPDATE');
3103: FND_MESSAGE.SET_TOKEN('project_id',p_product_txn_rec.project_id);
3104: FND_MESSAGE.SET_TOKEN('ship_from_org_id',l_ship_from_org_id);
3105: FND_MSG_PUB.ADD;
3106: RAISE BOOK_ORDER;
3107: end if;
3108: end if;

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

3131: x_msg_data => l_msg_data
3132: );
3133:
3134: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3135: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_OM_PROCESS_LINE');
3136: FND_MSG_PUB.ADD;
3137: RAISE BOOK_ORDER;
3138: END IF;
3139: end if; -- order line is not null

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

3173: -- SET prod_txn_status = 'BOOKED',
3174: -- book_sales_order_flag = 'Y'
3175: -- WHERE product_transaction_id = x_product_txn_rec.PRODUCT_TRANSACTION_ID;
3176: -- IF SQL%NOTFOUND then
3177: -- FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PRD_TXN_UPDATE');
3178: -- FND_MESSAGE.SET_TOKEN('PRODUCT_TRANSACTION_ID',x_product_txn_rec.PRODUCT_TRANSACTION_ID);
3179: -- FND_MSG_PUB.ADD;
3180: -- RAISE BOOK_ORDER;
3181: -- END IF;

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

3174: -- book_sales_order_flag = 'Y'
3175: -- WHERE product_transaction_id = x_product_txn_rec.PRODUCT_TRANSACTION_ID;
3176: -- IF SQL%NOTFOUND then
3177: -- FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PRD_TXN_UPDATE');
3178: -- FND_MESSAGE.SET_TOKEN('PRODUCT_TRANSACTION_ID',x_product_txn_rec.PRODUCT_TRANSACTION_ID);
3179: -- FND_MSG_PUB.ADD;
3180: -- RAISE BOOK_ORDER;
3181: -- END IF;
3182:

Line 3193: Fnd_Message.SET_NAME('CSD',

3189: WHERE repair_line_id =
3190: p_product_txn_rec.REPAIR_LINE_ID;
3191: IF SQL%NOTFOUND
3192: THEN
3193: Fnd_Message.SET_NAME('CSD',
3194: 'CSD_ERR_REPAIRS_UPDATE');
3195: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3196: p_product_txn_rec.repair_line_id);
3197: Fnd_Msg_Pub.ADD;

Line 3195: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',

3191: IF SQL%NOTFOUND
3192: THEN
3193: Fnd_Message.SET_NAME('CSD',
3194: 'CSD_ERR_REPAIRS_UPDATE');
3195: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3196: p_product_txn_rec.repair_line_id);
3197: Fnd_Msg_Pub.ADD;
3198: RAISE BOOK_ORDER;
3199: END IF;

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

3209: -- SET prod_txn_status = 'BOOKED',
3210: -- book_sales_order_flag = 'Y'
3211: -- WHERE product_transaction_id = x_product_txn_rec.PRODUCT_TRANSACTION_ID;
3212: -- IF SQL%NOTFOUND then
3213: -- FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PRD_TXN_UPDATE');
3214: -- FND_MESSAGE.SET_TOKEN('PRODUCT_TRANSACTION_ID',x_product_txn_rec.PRODUCT_TRANSACTION_ID);
3215: -- FND_MSG_PUB.ADD;
3216: -- RAISE BOOK_ORDER;
3217: -- END IF;

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

3210: -- book_sales_order_flag = 'Y'
3211: -- WHERE product_transaction_id = x_product_txn_rec.PRODUCT_TRANSACTION_ID;
3212: -- IF SQL%NOTFOUND then
3213: -- FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PRD_TXN_UPDATE');
3214: -- FND_MESSAGE.SET_TOKEN('PRODUCT_TRANSACTION_ID',x_product_txn_rec.PRODUCT_TRANSACTION_ID);
3215: -- FND_MSG_PUB.ADD;
3216: -- RAISE BOOK_ORDER;
3217: -- END IF;
3218:

Line 3229: Fnd_Message.SET_NAME('CSD',

3225: WHERE repair_line_id =
3226: p_product_txn_rec.REPAIR_LINE_ID;
3227: IF SQL%NOTFOUND
3228: THEN
3229: Fnd_Message.SET_NAME('CSD',
3230: 'CSD_ERR_REPAIRS_UPDATE');
3231: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3232: p_product_txn_rec.repair_line_id);
3233: Fnd_Msg_Pub.ADD;

Line 3231: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',

3227: IF SQL%NOTFOUND
3228: THEN
3229: Fnd_Message.SET_NAME('CSD',
3230: 'CSD_ERR_REPAIRS_UPDATE');
3231: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3232: p_product_txn_rec.repair_line_id);
3233: Fnd_Msg_Pub.ADD;
3234: RAISE BOOK_ORDER;
3235: END IF;

Line 3368: Fnd_Message.SET_NAME('CSD',

3364: Debug('Calling reserve serial..', l_mod_name, 1);
3365: Reserve_serial_number(l_serial_rsv_rec, l_return_status);
3366:
3367: if(l_return_status = FND_API.G_RET_STS_ERROR) THEN
3368: Fnd_Message.SET_NAME('CSD',
3369: 'CSD_SRL_RESERVE_FAILED');
3370: Fnd_Msg_Pub.ADD;
3371: RAISE RELEASE_ORDER;
3372: END IF;

Line 3407: Fnd_Message.SET_NAME('CSD',

3403: NVL(END_DATE_ACTIVE, SYSDATE + 1);
3404: px_order_rec.picking_rule_id := l_picking_rule_id;
3405: EXCEPTION
3406: WHEN NO_DATA_FOUND THEN
3407: Fnd_Message.SET_NAME('CSD',
3408: 'CSD_API_INV_PICKING_RULE_ID');
3409: Fnd_Message.SET_TOKEN('PICKING_RULE_ID',
3410: px_order_rec.picking_rule_id);
3411: Fnd_Msg_Pub.ADD;

Line 3409: Fnd_Message.SET_TOKEN('PICKING_RULE_ID',

3405: EXCEPTION
3406: WHEN NO_DATA_FOUND THEN
3407: Fnd_Message.SET_NAME('CSD',
3408: 'CSD_API_INV_PICKING_RULE_ID');
3409: Fnd_Message.SET_TOKEN('PICKING_RULE_ID',
3410: px_order_rec.picking_rule_id);
3411: Fnd_Msg_Pub.ADD;
3412: RAISE RELEASE_ORDER;
3413: WHEN TOO_MANY_ROWS THEN

Line 3489: Fnd_Message.SET_NAME('CSD',

3485: AND a.released_status in ('R','B');
3486:
3487: EXCEPTION
3488: WHEN NO_DATA_FOUND THEN
3489: Fnd_Message.SET_NAME('CSD',
3490: 'CSD_INV_EST_DETAIL_ID');
3491: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',
3492: p_product_txn_rec.estimate_detail_id);
3493: Fnd_Msg_Pub.ADD;

Line 3491: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',

3487: EXCEPTION
3488: WHEN NO_DATA_FOUND THEN
3489: Fnd_Message.SET_NAME('CSD',
3490: 'CSD_INV_EST_DETAIL_ID');
3491: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',
3492: p_product_txn_rec.estimate_detail_id);
3493: Fnd_Msg_Pub.ADD;
3494: Debug('Invalid estimate detail ID = ' ||
3495: p_product_txn_rec.estimate_detail_id,

Line 3580: Fnd_Message.SET_NAME('CSD',

3576: AND a.released_status in ('R','B','S');
3577:
3578: EXCEPTION
3579: WHEN NO_DATA_FOUND THEN
3580: Fnd_Message.SET_NAME('CSD',
3581: 'CSD_INV_EST_DETAIL_ID');
3582: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',
3583: p_product_txn_rec.estimate_detail_id);
3584: Fnd_Msg_Pub.ADD;

Line 3582: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',

3578: EXCEPTION
3579: WHEN NO_DATA_FOUND THEN
3580: Fnd_Message.SET_NAME('CSD',
3581: 'CSD_INV_EST_DETAIL_ID');
3582: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',
3583: p_product_txn_rec.estimate_detail_id);
3584: Fnd_Msg_Pub.ADD;
3585: Debug('Invalid estimate detail ID = ' ||
3586: p_product_txn_rec.estimate_detail_id,

Line 3610: Fnd_Message.SET_NAME('CSD',

3606: WHERE product_transaction_id =
3607: p_product_txn_rec.PRODUCT_TRANSACTION_ID;
3608: IF SQL%NOTFOUND
3609: THEN
3610: Fnd_Message.SET_NAME('CSD',
3611: 'CSD_ERR_PRD_TXN_UPDATE');
3612: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',
3613: p_product_txn_rec.PRODUCT_TRANSACTION_ID);
3614: Fnd_Msg_Pub.ADD;

Line 3612: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',

3608: IF SQL%NOTFOUND
3609: THEN
3610: Fnd_Message.SET_NAME('CSD',
3611: 'CSD_ERR_PRD_TXN_UPDATE');
3612: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',
3613: p_product_txn_rec.PRODUCT_TRANSACTION_ID);
3614: Fnd_Msg_Pub.ADD;
3615: RAISE RELEASE_ORDER;
3616: END IF;

Line 3625: Fnd_Message.SET_NAME('CSD',

3621: WHERE repair_line_id =
3622: p_product_txn_rec.REPAIR_LINE_ID;
3623: IF SQL%NOTFOUND
3624: THEN
3625: Fnd_Message.SET_NAME('CSD',
3626: 'CSD_ERR_REPAIRS_UPDATE');
3627: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3628: p_product_txn_rec.repair_line_id);
3629: Fnd_Msg_Pub.ADD;

Line 3627: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',

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

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

3698: AND b.estimate_detail_id = c.estimate_detail_id
3699: AND b.estimate_detail_id = p_product_txn_rec.estimate_detail_id;
3700: EXCEPTION
3701: WHEN NO_DATA_FOUND THEN
3702: FND_MESSAGE.SET_NAME('CSD','CSD_API_SHIPPING_FAILD'); /*Fixed for bug#5147030 message changed*/
3703: /*
3704: Fnd_Message.SET_NAME('CSD',
3705: 'CSD_API_INV_EST_DETAIL_ID');
3706: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',

Line 3704: Fnd_Message.SET_NAME('CSD',

3700: EXCEPTION
3701: WHEN NO_DATA_FOUND THEN
3702: FND_MESSAGE.SET_NAME('CSD','CSD_API_SHIPPING_FAILD'); /*Fixed for bug#5147030 message changed*/
3703: /*
3704: Fnd_Message.SET_NAME('CSD',
3705: 'CSD_API_INV_EST_DETAIL_ID');
3706: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',
3707: p_product_txn_rec.estimate_detail_id);
3708: */

Line 3706: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',

3702: FND_MESSAGE.SET_NAME('CSD','CSD_API_SHIPPING_FAILD'); /*Fixed for bug#5147030 message changed*/
3703: /*
3704: Fnd_Message.SET_NAME('CSD',
3705: 'CSD_API_INV_EST_DETAIL_ID');
3706: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',
3707: p_product_txn_rec.estimate_detail_id);
3708: */
3709: Fnd_Msg_Pub.ADD;
3710: Debug('Invalid Estimate Detail Id = ' ||

Line 3743: Fnd_Message.SET_NAME('CSD',

3739: px_order_rec.order_header_id
3740: AND source_line_id = px_order_rec.order_line_id;
3741: EXCEPTION
3742: WHEN NO_DATA_FOUND THEN
3743: Fnd_Message.SET_NAME('CSD',
3744: 'CSD_RELEASE_FAILED');
3745: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',
3746: px_order_rec.order_line_id);
3747: Fnd_Msg_Pub.ADD;

Line 3745: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',

3741: EXCEPTION
3742: WHEN NO_DATA_FOUND THEN
3743: Fnd_Message.SET_NAME('CSD',
3744: 'CSD_RELEASE_FAILED');
3745: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',
3746: px_order_rec.order_line_id);
3747: Fnd_Msg_Pub.ADD;
3748: RAISE SHIP_ORDER;
3749: WHEN TOO_MANY_ROWS THEN

Line 3796: Fnd_Message.SET_NAME('CSD',

3792: WHERE product_transaction_id =
3793: p_product_txn_rec.PRODUCT_TRANSACTION_ID;
3794: IF SQL%NOTFOUND
3795: THEN
3796: Fnd_Message.SET_NAME('CSD',
3797: 'CSD_ERR_PRD_TXN_UPDATE');
3798: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',
3799: p_product_txn_rec.PRODUCT_TRANSACTION_ID);
3800: Fnd_Msg_Pub.ADD;

Line 3798: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',

3794: IF SQL%NOTFOUND
3795: THEN
3796: Fnd_Message.SET_NAME('CSD',
3797: 'CSD_ERR_PRD_TXN_UPDATE');
3798: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',
3799: p_product_txn_rec.PRODUCT_TRANSACTION_ID);
3800: Fnd_Msg_Pub.ADD;
3801: RAISE SHIP_ORDER;
3802: END IF;

Line 3811: Fnd_Message.SET_NAME('CSD',

3807: WHERE repair_line_id =
3808: p_product_txn_rec.REPAIR_LINE_ID;
3809: IF SQL%NOTFOUND
3810: THEN
3811: Fnd_Message.SET_NAME('CSD',
3812: 'CSD_ERR_REPAIRS_UPDATE');
3813: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3814: p_product_txn_rec.repair_line_id);
3815: Fnd_Msg_Pub.ADD;

Line 3813: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',

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

Line 3832: Fnd_Message.SET_NAME('CSD',

3828: WHERE product_transaction_id =
3829: p_product_txn_rec.PRODUCT_TRANSACTION_ID;
3830: IF SQL%NOTFOUND
3831: THEN
3832: Fnd_Message.SET_NAME('CSD',
3833: 'CSD_ERR_PRD_TXN_UPDATE');
3834: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',
3835: p_product_txn_rec.PRODUCT_TRANSACTION_ID);
3836: Fnd_Msg_Pub.ADD;

Line 3834: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',

3830: IF SQL%NOTFOUND
3831: THEN
3832: Fnd_Message.SET_NAME('CSD',
3833: 'CSD_ERR_PRD_TXN_UPDATE');
3834: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',
3835: p_product_txn_rec.PRODUCT_TRANSACTION_ID);
3836: Fnd_Msg_Pub.ADD;
3837: RAISE SHIP_ORDER;
3838: END IF;

Line 3847: Fnd_Message.SET_NAME('CSD',

3843: WHERE repair_line_id =
3844: p_product_txn_rec.REPAIR_LINE_ID;
3845: IF SQL%NOTFOUND
3846: THEN
3847: Fnd_Message.SET_NAME('CSD',
3848: 'CSD_ERR_REPAIRS_UPDATE');
3849: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3850: p_product_txn_rec.repair_line_id);
3851: Fnd_Msg_Pub.ADD;

Line 3849: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',

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

Line 3868: Fnd_Message.SET_NAME('CSD',

3864: WHERE product_transaction_id =
3865: p_product_txn_rec.PRODUCT_TRANSACTION_ID;
3866: IF SQL%NOTFOUND
3867: THEN
3868: Fnd_Message.SET_NAME('CSD',
3869: 'CSD_ERR_PRD_TXN_UPDATE');
3870: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',
3871: p_product_txn_rec.PRODUCT_TRANSACTION_ID);
3872: Fnd_Msg_Pub.ADD;

Line 3870: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',

3866: IF SQL%NOTFOUND
3867: THEN
3868: Fnd_Message.SET_NAME('CSD',
3869: 'CSD_ERR_PRD_TXN_UPDATE');
3870: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',
3871: p_product_txn_rec.PRODUCT_TRANSACTION_ID);
3872: Fnd_Msg_Pub.ADD;
3873: RAISE SHIP_ORDER;
3874: END IF;

Line 3883: Fnd_Message.SET_NAME('CSD',

3879: WHERE repair_line_id =
3880: p_product_txn_rec.REPAIR_LINE_ID;
3881: IF SQL%NOTFOUND
3882: THEN
3883: Fnd_Message.SET_NAME('CSD',
3884: 'CSD_ERR_REPAIRS_UPDATE');
3885: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3886: p_product_txn_rec.repair_line_id);
3887: Fnd_Msg_Pub.ADD;

Line 3885: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',

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