DBA Data[Home] [Help]

APPS.CSD_MASS_RCV_PVT dependencies on FND_MESSAGE

Line 176: fnd_message.set_name ('CSD', 'CSD_INVALID_REPAIR_ORDER');

172:
173: --Validations: If te status of repair order is not 'Draft' then raise error.
174: IF NVL (l_repair_line_status, ' ') <> c_draft_status
175: THEN
176: fnd_message.set_name ('CSD', 'CSD_INVALID_REPAIR_ORDER');
177: fnd_msg_pub.ADD;
178: RAISE fnd_api.g_exc_error;
179: END IF;
180:

Line 436: fnd_message.set_name ('CSD', 'CSD_NO_SERIAL_NUMBERS');

432: END IF;
433:
434: IF (l_count_sn = 0)
435: THEN
436: fnd_message.set_name ('CSD', 'CSD_NO_SERIAL_NUMBERS');
437: fnd_msg_pub.ADD;
438: RAISE fnd_api.g_exc_error;
439: END IF;
440:

Line 748: fnd_message.set_name ('CSD', 'CSD_API_INV_REP_LINE_ID');

744: l_repair_order_rec.attribute30;
745:
746: IF (cur_repair_order%NOTFOUND)
747: THEN
748: fnd_message.set_name ('CSD', 'CSD_API_INV_REP_LINE_ID');
749: fnd_message.set_token ('REPAIR_LINE_ID',
750: p_repair_line_id
751: );
752: fnd_msg_pub.ADD;

Line 749: fnd_message.set_token ('REPAIR_LINE_ID',

745:
746: IF (cur_repair_order%NOTFOUND)
747: THEN
748: fnd_message.set_name ('CSD', 'CSD_API_INV_REP_LINE_ID');
749: fnd_message.set_token ('REPAIR_LINE_ID',
750: p_repair_line_id
751: );
752: fnd_msg_pub.ADD;
753: CLOSE cur_repair_order;

Line 778: FND_MESSAGE.SET_NAME('CSD','CSD_API_REPAIR_TYPE_ID');

774: INTO l_repair_type_ref;
775:
776: IF (cur_repair_type_ref%NOTFOUND)
777: THEN
778: FND_MESSAGE.SET_NAME('CSD','CSD_API_REPAIR_TYPE_ID');
779: FND_MESSAGE.SET_TOKEN('REPAIR_TYPE_ID',l_repair_order_rec.repair_type_id);
780: FND_MSG_PUB.Add;
781: CLOSE cur_repair_type_ref;
782: RAISE fnd_api.g_exc_error;

Line 779: FND_MESSAGE.SET_TOKEN('REPAIR_TYPE_ID',l_repair_order_rec.repair_type_id);

775:
776: IF (cur_repair_type_ref%NOTFOUND)
777: THEN
778: FND_MESSAGE.SET_NAME('CSD','CSD_API_REPAIR_TYPE_ID');
779: FND_MESSAGE.SET_TOKEN('REPAIR_TYPE_ID',l_repair_order_rec.repair_type_id);
780: FND_MSG_PUB.Add;
781: CLOSE cur_repair_type_ref;
782: RAISE fnd_api.g_exc_error;
783: END IF;

Line 799: FND_MESSAGE.SET_NAME('CSD','ERROR_MSG');

795:
796: /*
797: IF(p_repair_order_rec.SERIAL_NUMBER = 'SN_ERR') THEN
798: dbms_output.put_line('Error condition');
799: FND_MESSAGE.SET_NAME('CSD','ERROR_MSG');
800: FND_MSG_PUB.ADD;
801: RAISE FND_API.G_EXC_ERROR;
802: END IF;
803: */

Line 1280: fnd_message.set_name ('CSD', 'CSD_API_INV_REP_LINE_ID');

1276: l_orig_src_line_id;
1277:
1278: IF (cur_ro_details%NOTFOUND)
1279: THEN
1280: fnd_message.set_name ('CSD', 'CSD_API_INV_REP_LINE_ID');
1281: fnd_message.set_token ('REPAIR_LINE_ID',
1282: p_product_txn_rec.repair_line_id
1283: );
1284: fnd_msg_pub.ADD;

Line 1281: fnd_message.set_token ('REPAIR_LINE_ID',

1277:
1278: IF (cur_ro_details%NOTFOUND)
1279: THEN
1280: fnd_message.set_name ('CSD', 'CSD_API_INV_REP_LINE_ID');
1281: fnd_message.set_token ('REPAIR_LINE_ID',
1282: p_product_txn_rec.repair_line_id
1283: );
1284: fnd_msg_pub.ADD;
1285:

Line 1400: fnd_message.set_name ('CSD', 'CSD_API_CONTRACT_MISSING');

1396: l_txn_group_id;
1397:
1398: IF (cur_coverage_details%NOTFOUND)
1399: THEN
1400: fnd_message.set_name ('CSD', 'CSD_API_CONTRACT_MISSING');
1401: fnd_message.set_token ('CONTRACT_LINE_ID',
1402: p_product_txn_rec.contract_id
1403: );
1404: fnd_msg_pub.ADD;

Line 1401: fnd_message.set_token ('CONTRACT_LINE_ID',

1397:
1398: IF (cur_coverage_details%NOTFOUND)
1399: THEN
1400: fnd_message.set_name ('CSD', 'CSD_API_CONTRACT_MISSING');
1401: fnd_message.set_token ('CONTRACT_LINE_ID',
1402: p_product_txn_rec.contract_id
1403: );
1404: fnd_msg_pub.ADD;
1405:

Line 1439: fnd_message.set_name ('CSD', 'CSD_API_PARTY_MISSING');

1435: INTO l_party_id, l_account_id;
1436:
1437: IF (cur_cust_details%NOTFOUND OR l_party_id IS NULL)
1438: THEN
1439: fnd_message.set_name ('CSD', 'CSD_API_PARTY_MISSING');
1440: fnd_message.set_token ('INCIDENT_ID', l_incident_id);
1441: fnd_msg_pub.ADD;
1442:
1443: CLOSE cur_cust_details;

Line 1440: fnd_message.set_token ('INCIDENT_ID', l_incident_id);

1436:
1437: IF (cur_cust_details%NOTFOUND OR l_party_id IS NULL)
1438: THEN
1439: fnd_message.set_name ('CSD', 'CSD_API_PARTY_MISSING');
1440: fnd_message.set_token ('INCIDENT_ID', l_incident_id);
1441: fnd_msg_pub.ADD;
1442:
1443: CLOSE cur_cust_details;
1444:

Line 1490: fnd_message.set_name ('CSD', 'CSD_API_LINE_TYPE_MISSING');

1486: -- If line_type_id Or line_category_code is null
1487: -- then raise error
1488: IF (l_line_type_id IS NULL OR l_line_category_code IS NULL)
1489: THEN
1490: fnd_message.set_name ('CSD', 'CSD_API_LINE_TYPE_MISSING');
1491: fnd_message.set_token ('TXN_BILLING_TYPE_ID',
1492: p_product_txn_rec.txn_billing_type_id
1493: );
1494: fnd_msg_pub.ADD;

Line 1491: fnd_message.set_token ('TXN_BILLING_TYPE_ID',

1487: -- then raise error
1488: IF (l_line_type_id IS NULL OR l_line_category_code IS NULL)
1489: THEN
1490: fnd_message.set_name ('CSD', 'CSD_API_LINE_TYPE_MISSING');
1491: fnd_message.set_token ('TXN_BILLING_TYPE_ID',
1492: p_product_txn_rec.txn_billing_type_id
1493: );
1494: fnd_msg_pub.ADD;
1495: RAISE fnd_api.g_exc_error;

Line 1513: fnd_message.set_name ('CSD', 'CSD_API_SERIAL_NUM_MISSING');

1509: AND p_product_txn_rec.process_txn_flag = 'Y'
1510: )
1511: )
1512: THEN
1513: fnd_message.set_name ('CSD', 'CSD_API_SERIAL_NUM_MISSING');
1514: fnd_message.set_token ('INVENTORY_ITEM_ID',
1515: p_product_txn_rec.inventory_item_id
1516: );
1517: fnd_msg_pub.ADD;

Line 1514: fnd_message.set_token ('INVENTORY_ITEM_ID',

1510: )
1511: )
1512: THEN
1513: fnd_message.set_name ('CSD', 'CSD_API_SERIAL_NUM_MISSING');
1514: fnd_message.set_token ('INVENTORY_ITEM_ID',
1515: p_product_txn_rec.inventory_item_id
1516: );
1517: fnd_msg_pub.ADD;
1518:

Line 1546: fnd_message.set_name ('CSD', 'CSD_API_INV_PRICE_LIST_ID');

1542: INTO l_curr_code;
1543:
1544: IF (cur_pricelist_details%NOTFOUND)
1545: THEN
1546: fnd_message.set_name ('CSD', 'CSD_API_INV_PRICE_LIST_ID');
1547: fnd_message.set_token ('PRICE_LIST_ID',
1548: p_product_txn_rec.price_list_id
1549: );
1550: fnd_msg_pub.ADD;

Line 1547: fnd_message.set_token ('PRICE_LIST_ID',

1543:
1544: IF (cur_pricelist_details%NOTFOUND)
1545: THEN
1546: fnd_message.set_name ('CSD', 'CSD_API_INV_PRICE_LIST_ID');
1547: fnd_message.set_token ('PRICE_LIST_ID',
1548: p_product_txn_rec.price_list_id
1549: );
1550: fnd_msg_pub.ADD;
1551:

Line 1997: fnd_message.set_name ('CSD', 'CSD_ERR_REPAIRS_UPDATE');

1993: WHERE repair_line_id = p_product_txn_rec.repair_line_id;
1994:
1995: IF SQL%NOTFOUND
1996: THEN
1997: fnd_message.set_name ('CSD', 'CSD_ERR_REPAIRS_UPDATE');
1998: fnd_message.set_token ('REPAIR_LINE_ID',
1999: p_product_txn_rec.repair_line_id
2000: );
2001: fnd_msg_pub.ADD;

Line 1998: fnd_message.set_token ('REPAIR_LINE_ID',

1994:
1995: IF SQL%NOTFOUND
1996: THEN
1997: fnd_message.set_name ('CSD', 'CSD_ERR_REPAIRS_UPDATE');
1998: fnd_message.set_token ('REPAIR_LINE_ID',
1999: p_product_txn_rec.repair_line_id
2000: );
2001: fnd_msg_pub.ADD;
2002: RAISE fnd_api.g_exc_error;

Line 2020: fnd_message.set_name ('CSD', 'CSD_ERR_PRD_TXN_UPDATE');

2016: WHERE product_transaction_id = p_product_txn_rec.product_transaction_id;
2017:
2018: IF SQL%NOTFOUND
2019: THEN
2020: fnd_message.set_name ('CSD', 'CSD_ERR_PRD_TXN_UPDATE');
2021: fnd_message.set_token ('PRODUCT_TRANSACTION_ID',
2022: p_product_txn_rec.product_transaction_id
2023: );
2024: fnd_msg_pub.ADD;

Line 2021: fnd_message.set_token ('PRODUCT_TRANSACTION_ID',

2017:
2018: IF SQL%NOTFOUND
2019: THEN
2020: fnd_message.set_name ('CSD', 'CSD_ERR_PRD_TXN_UPDATE');
2021: fnd_message.set_token ('PRODUCT_TRANSACTION_ID',
2022: p_product_txn_rec.product_transaction_id
2023: );
2024: fnd_msg_pub.ADD;
2025: RAISE fnd_api.g_exc_error;

Line 2196: fnd_message.set_name ('CSD', 'CSD_INVALID_SITE_USED_ID');

2192: --px_instance_rec.bill_to_site_use_id;
2193: EXCEPTION
2194: WHEN NO_DATA_FOUND
2195: THEN
2196: fnd_message.set_name ('CSD', 'CSD_INVALID_SITE_USED_ID');
2197: fnd_message.set_token ('BILL_TO_SITE_USE_ID',
2198: px_instance_rec.party_site_use_id
2199: );
2200: --px_instance_rec.bill_to_site_use_id);

Line 2197: fnd_message.set_token ('BILL_TO_SITE_USE_ID',

2193: EXCEPTION
2194: WHEN NO_DATA_FOUND
2195: THEN
2196: fnd_message.set_name ('CSD', 'CSD_INVALID_SITE_USED_ID');
2197: fnd_message.set_token ('BILL_TO_SITE_USE_ID',
2198: px_instance_rec.party_site_use_id
2199: );
2200: --px_instance_rec.bill_to_site_use_id);
2201: RAISE fnd_api.g_exc_error;

Line 2577: fnd_message.set_name ('CSD', 'CSD_ERR_PROD_TXN_STATUS');

2573: AND lookup_code = p_product_txn_rec.prod_txn_status;
2574: EXCEPTION
2575: WHEN OTHERS
2576: THEN
2577: fnd_message.set_name ('CSD', 'CSD_ERR_PROD_TXN_STATUS');
2578: fnd_msg_pub.ADD;
2579: RAISE fnd_api.g_exc_error;
2580: END;
2581: END IF;

Line 2633: fnd_message.set_name ('CSD', 'CSD_API_INV_ITEM_ID');

2629: END IF;
2630: EXCEPTION
2631: WHEN NO_DATA_FOUND
2632: THEN
2633: fnd_message.set_name ('CSD', 'CSD_API_INV_ITEM_ID');
2634: fnd_message.set_token ('INVENTORY_ITEM_ID', p_inv_item_id);
2635: fnd_msg_pub.ADD;
2636: RAISE fnd_api.g_exc_error;
2637: END is_item_pre_serialized;

Line 2634: fnd_message.set_token ('INVENTORY_ITEM_ID', p_inv_item_id);

2630: EXCEPTION
2631: WHEN NO_DATA_FOUND
2632: THEN
2633: fnd_message.set_name ('CSD', 'CSD_API_INV_ITEM_ID');
2634: fnd_message.set_token ('INVENTORY_ITEM_ID', p_inv_item_id);
2635: fnd_msg_pub.ADD;
2636: RAISE fnd_api.g_exc_error;
2637: END is_item_pre_serialized;
2638:

Line 2661: fnd_message.set_name ('CSD', 'CSD_API_INV_ITEM_ID');

2657: END IF;
2658: EXCEPTION
2659: WHEN NO_DATA_FOUND
2660: THEN
2661: fnd_message.set_name ('CSD', 'CSD_API_INV_ITEM_ID');
2662: fnd_message.set_token ('INVENTORY_ITEM_ID', p_inv_item_id);
2663: fnd_msg_pub.ADD;
2664: RAISE fnd_api.g_exc_error;
2665: END is_item_ib_trackable;

Line 2662: fnd_message.set_token ('INVENTORY_ITEM_ID', p_inv_item_id);

2658: EXCEPTION
2659: WHEN NO_DATA_FOUND
2660: THEN
2661: fnd_message.set_name ('CSD', 'CSD_API_INV_ITEM_ID');
2662: fnd_message.set_token ('INVENTORY_ITEM_ID', p_inv_item_id);
2663: fnd_msg_pub.ADD;
2664: RAISE fnd_api.g_exc_error;
2665: END is_item_ib_trackable;
2666:

Line 2730: fnd_message.set_name ('CSD','CSD_API_BOOKING_FAILED'); /*FP Fixed for bug#5147030 message changed*/

2726: INTO p_order_rec.order_header_id, l_order_line_id;
2727:
2728: IF (cur_ord_details%NOTFOUND)
2729: THEN
2730: fnd_message.set_name ('CSD','CSD_API_BOOKING_FAILED'); /*FP Fixed for bug#5147030 message changed*/
2731: /*
2732: fnd_message.set_name ('CSD', 'CSD_API_INV_EST_DETAIL_ID');
2733: fnd_message.set_token ('ESTIMATE_DETAIL_ID', p_est_detail_id);
2734: */

Line 2732: fnd_message.set_name ('CSD', 'CSD_API_INV_EST_DETAIL_ID');

2728: IF (cur_ord_details%NOTFOUND)
2729: THEN
2730: fnd_message.set_name ('CSD','CSD_API_BOOKING_FAILED'); /*FP Fixed for bug#5147030 message changed*/
2731: /*
2732: fnd_message.set_name ('CSD', 'CSD_API_INV_EST_DETAIL_ID');
2733: fnd_message.set_token ('ESTIMATE_DETAIL_ID', p_est_detail_id);
2734: */
2735: fnd_msg_pub.ADD;
2736:

Line 2733: fnd_message.set_token ('ESTIMATE_DETAIL_ID', p_est_detail_id);

2729: THEN
2730: fnd_message.set_name ('CSD','CSD_API_BOOKING_FAILED'); /*FP Fixed for bug#5147030 message changed*/
2731: /*
2732: fnd_message.set_name ('CSD', 'CSD_API_INV_EST_DETAIL_ID');
2733: fnd_message.set_token ('ESTIMATE_DETAIL_ID', p_est_detail_id);
2734: */
2735: fnd_msg_pub.ADD;
2736:
2737: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

Line 2771: fnd_message.set_name ('CSD', 'CSD_API_SALES_REP_MISSING');

2767: INTO l_ship_from_org_id, l_unit_selling_price, p_order_rec.org_id;
2768:
2769: IF (cur_ord_line%NOTFOUND)
2770: THEN
2771: fnd_message.set_name ('CSD', 'CSD_API_SALES_REP_MISSING');
2772: fnd_message.set_token ('ORDER_LINE_ID', l_order_line_id);
2773: fnd_msg_pub.ADD;
2774:
2775: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

Line 2772: fnd_message.set_token ('ORDER_LINE_ID', l_order_line_id);

2768:
2769: IF (cur_ord_line%NOTFOUND)
2770: THEN
2771: fnd_message.set_name ('CSD', 'CSD_API_SALES_REP_MISSING');
2772: fnd_message.set_token ('ORDER_LINE_ID', l_order_line_id);
2773: fnd_msg_pub.ADD;
2774:
2775: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2776: THEN

Line 2804: fnd_message.set_name ('CSD', 'CSD_API_SHIP_FROM_ORG_MISSING');

2800: CLOSE cur_ord_line;
2801:
2802: IF l_ship_from_org_id IS NULL
2803: THEN
2804: fnd_message.set_name ('CSD', 'CSD_API_SHIP_FROM_ORG_MISSING');
2805: fnd_message.set_token ('ORDER_LINE_ID', l_order_line_id);
2806: fnd_msg_pub.ADD;
2807:
2808: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

Line 2805: fnd_message.set_token ('ORDER_LINE_ID', l_order_line_id);

2801:
2802: IF l_ship_from_org_id IS NULL
2803: THEN
2804: fnd_message.set_name ('CSD', 'CSD_API_SHIP_FROM_ORG_MISSING');
2805: fnd_message.set_token ('ORDER_LINE_ID', l_order_line_id);
2806: fnd_msg_pub.ADD;
2807:
2808: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2809: THEN

Line 2822: fnd_message.set_name ('CSD', 'CSD_API_PRICE_MISSING');

2818: END IF;
2819:
2820: IF l_unit_selling_price IS NULL
2821: THEN
2822: fnd_message.set_name ('CSD', 'CSD_API_PRICE_MISSING');
2823: fnd_message.set_token ('ORDER_LINE_ID', l_order_line_id);
2824: fnd_msg_pub.ADD;
2825:
2826: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

Line 2823: fnd_message.set_token ('ORDER_LINE_ID', l_order_line_id);

2819:
2820: IF l_unit_selling_price IS NULL
2821: THEN
2822: fnd_message.set_name ('CSD', 'CSD_API_PRICE_MISSING');
2823: fnd_message.set_token ('ORDER_LINE_ID', l_order_line_id);
2824: fnd_msg_pub.ADD;
2825:
2826: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2827: THEN

Line 2845: fnd_message.set_name ('CSD', 'CSD_INV_ORDER_HEADER_ID');

2841: INTO x_booked_flag;
2842:
2843: IF (cur_ord_hdr%NOTFOUND)
2844: THEN
2845: fnd_message.set_name ('CSD', 'CSD_INV_ORDER_HEADER_ID');
2846: fnd_message.set_token ('ORDER_HEADER_ID',
2847: p_order_rec.order_header_id
2848: );
2849: fnd_msg_pub.ADD;

Line 2846: fnd_message.set_token ('ORDER_HEADER_ID',

2842:
2843: IF (cur_ord_hdr%NOTFOUND)
2844: THEN
2845: fnd_message.set_name ('CSD', 'CSD_INV_ORDER_HEADER_ID');
2846: fnd_message.set_token ('ORDER_HEADER_ID',
2847: p_order_rec.order_header_id
2848: );
2849: fnd_msg_pub.ADD;
2850: