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_MSG_PUB

Line 70: -- FND_MSG_PUB.ADD;

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: --
74: -- WHEN TOO_MANY_ROWS THEN

Line 82: -- FND_MSG_PUB.ADD;

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: --
86: -- END Validate_PriceListID;

Line 179: Fnd_Msg_Pub.ADD;

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');
183: END IF;

Line 187: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,

183: END IF;
184:
185: x_return_status := Fnd_Api.G_Ret_Sts_Error;
186:
187: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
188: p_data => x_msg_data);
189:
190: END Validate_InventoryItemID;
191: /*---------------------------------------------------------------------------*/

Line 245: Fnd_Msg_Pub.ADD;

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)
248: THEN
249: Csd_Gen_Utility_Pvt.ADD('Txn_Billing_Type_id is invalid');

Line 299: Fnd_Msg_Pub.ADD;

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:
303: END Validate_Revision;

Line 373: Fnd_Msg_Pub.ADD;

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:
377: END Validate_Instance_ID;

Line 421: Fnd_Msg_Pub.ADD;

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:
425: END Validate_LotNumber;

Line 467: Fnd_Msg_Pub.ADD;

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
471: Csd_Gen_Utility_Pvt.ADD('Serial Number status invalid');

Line 533: Fnd_Msg_Pub.ADD;

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:
537: END Validate_ReasonCode;

Line 590: Fnd_Msg_Pub.ADD;

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:
594: END Validate_UOM;

Line 657: Fnd_Msg_Pub.ADD;

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:
661: END IF;

Line 1057: Fnd_Msg_Pub.ADD;

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:
1061: END IF;

Line 1081: Fnd_Msg_Pub.ADD;

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:
1085: END IF;

Line 1360: Fnd_Msg_Pub.ADD;

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:
1364: END IF;

Line 1382: Fnd_Msg_Pub.ADD;

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:
1386: END IF;

Line 1426: Fnd_Msg_Pub.ADD;

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:
1429: END IF;
1430: -- non_source_instance_id should be Null for RMA line.

Line 1445: Fnd_Msg_Pub.ADD;

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:
1448: END IF;
1449:

Line 1465: Fnd_Msg_Pub.ADD;

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:
1469: END IF;

Line 1513: Fnd_Msg_Pub.ADD;

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;
1516: IF NVL(p_Upd_ProdTxn_Rec.non_source_Serial_Number,
1517: Fnd_Api.G_MISS_CHAR) <> Fnd_Api.G_MISS_CHAR

Line 1523: Fnd_Msg_Pub.ADD;

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;
1526:
1527: END IF;

Line 1563: Fnd_Msg_Pub.ADD;

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:
1567: END IF;

Line 1586: Fnd_Msg_Pub.ADD;

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;
1589:
1590: END IF;

Line 1604: Fnd_Msg_Pub.ADD;

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;
1607:
1608: END IF;

Line 1689: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,

1685: EXCEPTION
1686:
1687: WHEN Fnd_Api.G_Exc_Error THEN
1688: x_return_status := Fnd_Api.G_Ret_Sts_Error;
1689: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1690: p_data => x_msg_data);
1691:
1692: WHEN OTHERS THEN
1693: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 1694: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_Unexp_Error)

1690: p_data => x_msg_data);
1691:
1692: WHEN OTHERS THEN
1693: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1694: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_Unexp_Error)
1695: THEN
1696: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1697: END IF;
1698: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,

Line 1696: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1692: WHEN OTHERS THEN
1693: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1694: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_Unexp_Error)
1695: THEN
1696: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1697: END IF;
1698: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1699: p_data => x_msg_data);
1700:

Line 1698: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,

1694: IF Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_Unexp_Error)
1695: THEN
1696: Fnd_Msg_Pub.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1697: END IF;
1698: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
1699: p_data => x_msg_data);
1700:
1701: END Validate_ProductTrxnRec;
1702: /*---------------------------------------------------------------------------*/

Line 1958: Fnd_Msg_Pub.ADD;

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);
1962:

Line 1960: Fnd_Msg_Pub.Count_AND_Get(p_count => x_msg_count,

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);
1962:
1963: END Compare_ProductTrxnRec;
1964: /*---------------------------------------------------------------------------*/

Line 2028: Fnd_Msg_Pub.ADD;

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:
2032: END Get_ItemAttributes;

Line 2065: Fnd_Msg_Pub.ADD;

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);
2069: RAISE Fnd_Api.G_EXC_ERROR;

Line 2081: Fnd_Msg_Pub.ADD;

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;
2085:

Line 2231: Fnd_Msg_Pub.ADD;

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;
2235:

Line 2291: Fnd_Msg_Pub.ADD;

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;
2295: --R12 Development pick rule changes End

Line 2429: Fnd_Msg_Pub.ADD;

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,
2432: l_mod_name,
2433: C_STATEMENT_LEVEL);

Line 2686: Fnd_Msg_Pub.ADD;

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',
2688: l_mod_name,
2689: 1);
2690: RAISE CREATE_ORDER;

Line 2736: Fnd_Msg_Pub.ADD;

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;
2739:
2740: IF l_rev_ctl_code = 2

Line 2755: Fnd_Msg_Pub.ADD;

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;
2758: END IF;
2759:

Line 2806: Fnd_Msg_Pub.ADD;

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;
2809:
2810: UPDATE CSD_REPAIRS

Line 2820: Fnd_Msg_Pub.ADD;

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;
2823:
2824: -- swai: bug 6001057

Line 2858: FND_MSG_PUB.ADD;

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;
2862: end if; -- end update project and unit number fields

Line 2889: FND_MSG_PUB.ADD;

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:
2893: end if; -- order line is not null

Line 2993: Fnd_Msg_Pub.ADD;

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,
2996: l_mod_name,
2997: 1);

Line 3033: Fnd_Msg_Pub.ADD;

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,
3036: l_mod_name,
3037: 1);

Line 3051: Fnd_Msg_Pub.ADD;

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,
3054: l_mod_name,
3055: 1);

Line 3065: Fnd_Msg_Pub.ADD;

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,
3068: l_mod_name,
3069: 1);

Line 3105: FND_MSG_PUB.ADD;

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;
3109: end if; -- end update projects fields

Line 3136: FND_MSG_PUB.ADD;

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
3140: end if; -- update OM line criteria

Line 3179: -- FND_MSG_PUB.ADD;

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:
3183: -- Fix for bug#4020651

Line 3197: Fnd_Msg_Pub.ADD;

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;
3200:
3201: ELSIF l_booked_flag = 'Y'

Line 3215: -- FND_MSG_PUB.ADD;

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:
3219: -- Fix for bug#4020651

Line 3233: Fnd_Msg_Pub.ADD;

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;
3236:
3237: END IF; -- l_booked_flag if condition

Line 3370: Fnd_Msg_Pub.ADD;

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;
3373:
3374: END IF;

Line 3411: Fnd_Msg_Pub.ADD;

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
3414: Debug('Too many from release_sales_order1',
3415: l_mod_name,

Line 3493: Fnd_Msg_Pub.ADD;

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,
3496: l_mod_name,
3497: 1);

Line 3584: Fnd_Msg_Pub.ADD;

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,
3587: l_mod_name,
3588: 1);

Line 3614: Fnd_Msg_Pub.ADD;

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;
3617: END IF;
3618:

Line 3629: Fnd_Msg_Pub.ADD;

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;
3632:
3633: END IF;

Line 3709: Fnd_Msg_Pub.ADD;

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 = ' ||
3711: p_product_txn_rec.estimate_detail_id,
3712: l_mod_name,
3713: 1);

Line 3747: Fnd_Msg_Pub.ADD;

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
3750: Debug('Too many from ship_sales_order',
3751: l_mod_name,

Line 3800: Fnd_Msg_Pub.ADD;

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;
3803: END IF;
3804:

Line 3815: Fnd_Msg_Pub.ADD;

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;
3818:
3819: ELSIF l_released_status IN ('I', 'C')

Line 3836: Fnd_Msg_Pub.ADD;

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;
3839: END IF;
3840:

Line 3851: Fnd_Msg_Pub.ADD;

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;
3854:
3855: ELSIF l_released_status = 'S'

Line 3872: Fnd_Msg_Pub.ADD;

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;
3875: END IF;
3876:

Line 3887: Fnd_Msg_Pub.ADD;

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;
3890:
3891: END IF;

Line 3976: Fnd_Msg_Pub.initialize;

3972:
3973: -- Initialize message list if p_init_msg_list is set to TRUE.
3974: IF Fnd_Api.to_Boolean(p_init_msg_list)
3975: THEN
3976: Fnd_Msg_Pub.initialize;
3977: oe_Msg_Pub.initialize;
3978: END IF;
3979: -- Initialize API return status to success
3980: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 4068: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,

4064: 'cancel_prodtxn completed');
4065: END IF;
4066:
4067: -- Standard call to get message count and IF count is get message info.
4068: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
4069: p_data => x_msg_data);
4070: if(x_msg_count = 0) then
4071: oe_Msg_Pub.Count_And_Get(p_count => x_msg_count,
4072: p_data => x_msg_data);

Line 4079: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,

4075: EXCEPTION
4076: WHEN Fnd_Api.g_exc_error THEN
4077: x_return_status := Fnd_Api.g_ret_sts_error;
4078: ROLLBACK TO CANCEL_PRODTXN_PVT;
4079: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
4080: p_data => x_msg_data);
4081: if(x_msg_count = 0) then
4082: oe_Msg_Pub.Count_And_Get(p_count => x_msg_count,
4083: p_data => x_msg_data);

Line 4096: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,

4092: --dbms_output.put_line('exec error raised');
4093: WHEN Fnd_Api.g_exc_unexpected_error THEN
4094: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
4095: ROLLBACK TO CANCEL_PRODTXN_PVT;
4096: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
4097: p_data => x_msg_data);
4098: if(x_msg_count = 0) then
4099: oe_Msg_Pub.Count_And_Get(p_count => x_msg_count,
4100: p_data => x_msg_data);

Line 4114: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_unexp_error)

4110: WHEN OTHERS THEN
4111: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
4112: ROLLBACK TO CANCEL_PRODTXN_PVT;
4113:
4114: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_unexp_error)
4115: THEN
4116: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);
4117: END IF;
4118:

Line 4116: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);

4112: ROLLBACK TO CANCEL_PRODTXN_PVT;
4113:
4114: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_unexp_error)
4115: THEN
4116: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);
4117: END IF;
4118:
4119: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
4120: p_data => x_msg_data);

Line 4119: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,

4115: THEN
4116: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);
4117: END IF;
4118:
4119: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
4120: p_data => x_msg_data);
4121: if(x_msg_count = 0) then
4122: oe_Msg_Pub.Count_And_Get(p_count => x_msg_count,
4123: p_data => x_msg_data);

Line 4148: l_msg := apps.FND_MSG_PUB.Get(i,apps.FND_API.G_FALSE) ;

4144:
4145: begin
4146: IF p_MSG_COUNT > 1 THEN
4147: FOR i IN 1..p_MSG_COUNT LOOP
4148: l_msg := apps.FND_MSG_PUB.Get(i,apps.FND_API.G_FALSE) ;
4149: --dbms_output.put_line('Msg Data : ' || l_msg ) ;
4150: END LOOP ;
4151: ELSE
4152: l_msg := apps.FND_MSG_PUB.Get(1,apps.FND_API.G_FALSE) ;

Line 4152: l_msg := apps.FND_MSG_PUB.Get(1,apps.FND_API.G_FALSE) ;

4148: l_msg := apps.FND_MSG_PUB.Get(i,apps.FND_API.G_FALSE) ;
4149: --dbms_output.put_line('Msg Data : ' || l_msg ) ;
4150: END LOOP ;
4151: ELSE
4152: l_msg := apps.FND_MSG_PUB.Get(1,apps.FND_API.G_FALSE) ;
4153: --dbms_output.put_line('Msg Data : ' || l_msg ) ;
4154: END IF ;
4155:
4156: end dbg_print_stack;