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 2859: FND_MSG_PUB.ADD;

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

Line 2896: FND_MSG_PUB.ADD;

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

Line 3000: Fnd_Msg_Pub.ADD;

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,
3003: l_mod_name,
3004: 1);

Line 3040: Fnd_Msg_Pub.ADD;

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,
3043: l_mod_name,
3044: 1);

Line 3058: Fnd_Msg_Pub.ADD;

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,
3061: l_mod_name,
3062: 1);

Line 3072: Fnd_Msg_Pub.ADD;

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,
3075: l_mod_name,
3076: 1);

Line 3113: FND_MSG_PUB.ADD;

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

Line 3150: FND_MSG_PUB.ADD;

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

Line 3193: -- FND_MSG_PUB.ADD;

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

Line 3211: Fnd_Msg_Pub.ADD;

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;
3214:
3215: ELSIF l_booked_flag = 'Y'

Line 3229: -- FND_MSG_PUB.ADD;

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

Line 3247: Fnd_Msg_Pub.ADD;

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;
3250:
3251: END IF; -- l_booked_flag if condition

Line 3384: Fnd_Msg_Pub.ADD;

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

Line 3425: Fnd_Msg_Pub.ADD;

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

Line 3507: Fnd_Msg_Pub.ADD;

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,
3510: l_mod_name,
3511: 1);

Line 3598: Fnd_Msg_Pub.ADD;

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,
3601: l_mod_name,
3602: 1);

Line 3628: Fnd_Msg_Pub.ADD;

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

Line 3643: Fnd_Msg_Pub.ADD;

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

Line 3723: Fnd_Msg_Pub.ADD;

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 = ' ||
3725: p_product_txn_rec.estimate_detail_id,
3726: l_mod_name,
3727: 1);

Line 3761: Fnd_Msg_Pub.ADD;

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

Line 3814: Fnd_Msg_Pub.ADD;

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

Line 3829: Fnd_Msg_Pub.ADD;

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

Line 3850: Fnd_Msg_Pub.ADD;

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

Line 3865: Fnd_Msg_Pub.ADD;

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;
3868:
3869: ELSIF l_released_status = 'S'

Line 3886: Fnd_Msg_Pub.ADD;

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

Line 3901: Fnd_Msg_Pub.ADD;

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

Line 3990: Fnd_Msg_Pub.initialize;

3986:
3987: -- Initialize message list if p_init_msg_list is set to TRUE.
3988: IF Fnd_Api.to_Boolean(p_init_msg_list)
3989: THEN
3990: Fnd_Msg_Pub.initialize;
3991: oe_Msg_Pub.initialize;
3992: END IF;
3993: -- Initialize API return status to success
3994: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

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

4078: 'cancel_prodtxn completed');
4079: END IF;
4080:
4081: -- Standard call to get message count and IF count is get message info.
4082: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
4083: p_data => x_msg_data);
4084: if(x_msg_count = 0) then
4085: oe_Msg_Pub.Count_And_Get(p_count => x_msg_count,
4086: p_data => x_msg_data);

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

4089: EXCEPTION
4090: WHEN Fnd_Api.g_exc_error THEN
4091: x_return_status := Fnd_Api.g_ret_sts_error;
4092: ROLLBACK TO CANCEL_PRODTXN_PVT;
4093: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
4094: p_data => x_msg_data);
4095: if(x_msg_count = 0) then
4096: oe_Msg_Pub.Count_And_Get(p_count => x_msg_count,
4097: p_data => x_msg_data);

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

4106: --dbms_output.put_line('exec error raised');
4107: WHEN Fnd_Api.g_exc_unexpected_error THEN
4108: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
4109: ROLLBACK TO CANCEL_PRODTXN_PVT;
4110: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
4111: p_data => x_msg_data);
4112: if(x_msg_count = 0) then
4113: oe_Msg_Pub.Count_And_Get(p_count => x_msg_count,
4114: p_data => x_msg_data);

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

4124: WHEN OTHERS THEN
4125: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
4126: ROLLBACK TO CANCEL_PRODTXN_PVT;
4127:
4128: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_unexp_error)
4129: THEN
4130: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);
4131: END IF;
4132:

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

4126: ROLLBACK TO CANCEL_PRODTXN_PVT;
4127:
4128: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_unexp_error)
4129: THEN
4130: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);
4131: END IF;
4132:
4133: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
4134: p_data => x_msg_data);

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

4129: THEN
4130: Fnd_Msg_Pub.add_exc_msg(g_pkg_name, l_api_name);
4131: END IF;
4132:
4133: Fnd_Msg_Pub.count_and_get(p_count => x_msg_count,
4134: p_data => x_msg_data);
4135: if(x_msg_count = 0) then
4136: oe_Msg_Pub.Count_And_Get(p_count => x_msg_count,
4137: p_data => x_msg_data);

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

4158:
4159: begin
4160: IF p_MSG_COUNT > 1 THEN
4161: FOR i IN 1..p_MSG_COUNT LOOP
4162: l_msg := apps.FND_MSG_PUB.Get(i,apps.FND_API.G_FALSE) ;
4163: --dbms_output.put_line('Msg Data : ' || l_msg ) ;
4164: END LOOP ;
4165: ELSE
4166: l_msg := apps.FND_MSG_PUB.Get(1,apps.FND_API.G_FALSE) ;

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

4162: l_msg := apps.FND_MSG_PUB.Get(i,apps.FND_API.G_FALSE) ;
4163: --dbms_output.put_line('Msg Data : ' || l_msg ) ;
4164: END LOOP ;
4165: ELSE
4166: l_msg := apps.FND_MSG_PUB.Get(1,apps.FND_API.G_FALSE) ;
4167: --dbms_output.put_line('Msg Data : ' || l_msg ) ;
4168: END IF ;
4169:
4170: end dbg_print_stack;