DBA Data[Home] [Help]

APPS.CSD_LOGISTICS_UTIL dependencies on CSD_GEN_UTILITY_PVT

Line 6: g_debug NUMBER := Csd_Gen_Utility_Pvt.g_debug_level;

2: /* $Header: csdulogb.pls 120.35.12010000.3 2008/11/11 23:20:34 takwong ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_LOGISTICS_UTIL';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdulogs.plb';
6: g_debug NUMBER := Csd_Gen_Utility_Pvt.g_debug_level;
7:
8: -- Define constants here
9: C_ACTION_TYPE_SHIP CONSTANT VARCHAR2(4) := 'SHIP';
10: C_ACTION_TYPE_RMA CONSTANT VARCHAR2(3) := 'RMA';

Line 182: Csd_Gen_Utility_Pvt.ADD('Inventory_Item_id is invalid');

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');
183: END IF;
184:
185: x_return_status := Fnd_Api.G_Ret_Sts_Error;
186:

Line 249: Csd_Gen_Utility_Pvt.ADD('Txn_Billing_Type_id is invalid');

245: Fnd_Msg_Pub.ADD;
246:
247: IF (g_debug > 0)
248: THEN
249: Csd_Gen_Utility_Pvt.ADD('Txn_Billing_Type_id is invalid');
250: END IF;
251:
252: RAISE Fnd_Api.G_EXC_ERROR;
253:

Line 292: Csd_Gen_Utility_Pvt.ADD('revision Not found');

288: -- x_Concatenated_Segments => l_Concatenated_Segments ) ;
289:
290: IF (g_debug > 0)
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);

Line 364: Csd_Gen_Utility_Pvt.ADD('instance number Not found');

360: WHEN NO_DATA_FOUND THEN
361:
362: IF (g_debug > 0)
363: THEN
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');

Line 414: Csd_Gen_Utility_Pvt.ADD('Lot Number Not found');

410: -- x_Concatenated_Segments => l_Concatenated_Segments ) ;
411:
412: IF (g_debug > 0)
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);

Line 471: Csd_Gen_Utility_Pvt.ADD('Serial Number status invalid');

467: Fnd_Msg_Pub.ADD;
468:
469: IF (g_debug > 0)
470: THEN
471: Csd_Gen_Utility_Pvt.ADD('Serial Number status invalid');
472: END IF;
473:
474: RAISE Fnd_Api.G_EXC_ERROR;
475:

Line 528: Csd_Gen_Utility_Pvt.ADD('Reason Code Not found');

524: WHEN NO_DATA_FOUND THEN
525:
526: IF (g_debug > 0)
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);

Line 583: Csd_Gen_Utility_Pvt.ADD('Unit Of Measure Not found');

579: -- x_Concatenated_Segments => l_Concatenated_Segments ) ;
580:
581: IF (g_debug > 0)
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);

Line 649: Csd_Gen_Utility_Pvt.ADD('Party Site ID Not found');

645: CLOSE PS_Cur_Type;
646:
647: IF (g_debug > 0)
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.

Line 1011: Csd_Gen_Utility_Pvt.ADD('Concatenated_Segments Not found');

1007: WHEN NO_DATA_FOUND THEN
1008:
1009: IF (g_debug > 0)
1010: THEN
1011: Csd_Gen_Utility_Pvt.ADD('Concatenated_Segments Not found');
1012: END IF;
1013:
1014: x_Concatenated_Segments := NULL;
1015:

Line 1073: Csd_Gen_Utility_Pvt.ADD('Shipped Serial Number Not found');

1069: THEN
1070:
1071: IF (g_debug > 0)
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

Line 1353: Csd_Gen_Utility_Pvt.ADD('Revision column should be Null');

1349: THEN
1350:
1351: IF (g_debug > 0)
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');

Line 1377: Csd_Gen_Utility_Pvt.ADD('Reason_Code column should be Null for Ship line');

1373: THEN
1374:
1375: IF (g_debug > 0)
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');

Line 1420: Csd_Gen_Utility_Pvt.ADD('non_source_Serial_Number column should be Null for RMA line');

1416: THEN
1417:
1418: IF (g_debug > 0)
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',

Line 1439: Csd_Gen_Utility_Pvt.ADD('non_source_instance_id column should be Null for RMA line');

1435: THEN
1436:
1437: IF (g_debug > 0)
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',

Line 1460: Csd_Gen_Utility_Pvt.ADD('Return_By_Date column should be Null for RMA line');

1456: THEN
1457:
1458: IF (g_debug > 0)
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');