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 754: fnd_message.set_name ('CSD', 'CSD_API_INV_REP_LINE_ID');

750: l_repair_order_rec.attribute30;
751:
752: IF (cur_repair_order%NOTFOUND)
753: THEN
754: fnd_message.set_name ('CSD', 'CSD_API_INV_REP_LINE_ID');
755: fnd_message.set_token ('REPAIR_LINE_ID',
756: p_repair_line_id
757: );
758: fnd_msg_pub.ADD;

Line 755: fnd_message.set_token ('REPAIR_LINE_ID',

751:
752: IF (cur_repair_order%NOTFOUND)
753: THEN
754: fnd_message.set_name ('CSD', 'CSD_API_INV_REP_LINE_ID');
755: fnd_message.set_token ('REPAIR_LINE_ID',
756: p_repair_line_id
757: );
758: fnd_msg_pub.ADD;
759: CLOSE cur_repair_order;

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

780: INTO l_repair_type_ref;
781:
782: IF (cur_repair_type_ref%NOTFOUND)
783: THEN
784: FND_MESSAGE.SET_NAME('CSD','CSD_API_REPAIR_TYPE_ID');
785: FND_MESSAGE.SET_TOKEN('REPAIR_TYPE_ID',l_repair_order_rec.repair_type_id);
786: FND_MSG_PUB.Add;
787: CLOSE cur_repair_type_ref;
788: RAISE fnd_api.g_exc_error;

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

781:
782: IF (cur_repair_type_ref%NOTFOUND)
783: THEN
784: FND_MESSAGE.SET_NAME('CSD','CSD_API_REPAIR_TYPE_ID');
785: FND_MESSAGE.SET_TOKEN('REPAIR_TYPE_ID',l_repair_order_rec.repair_type_id);
786: FND_MSG_PUB.Add;
787: CLOSE cur_repair_type_ref;
788: RAISE fnd_api.g_exc_error;
789: END IF;

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

801:
802: /*
803: IF(p_repair_order_rec.SERIAL_NUMBER = 'SN_ERR') THEN
804: dbms_output.put_line('Error condition');
805: FND_MESSAGE.SET_NAME('CSD','ERROR_MSG');
806: FND_MSG_PUB.ADD;
807: RAISE FND_API.G_EXC_ERROR;
808: END IF;
809: */

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

1282: l_orig_src_line_id;
1283:
1284: IF (cur_ro_details%NOTFOUND)
1285: THEN
1286: fnd_message.set_name ('CSD', 'CSD_API_INV_REP_LINE_ID');
1287: fnd_message.set_token ('REPAIR_LINE_ID',
1288: p_product_txn_rec.repair_line_id
1289: );
1290: fnd_msg_pub.ADD;

Line 1287: fnd_message.set_token ('REPAIR_LINE_ID',

1283:
1284: IF (cur_ro_details%NOTFOUND)
1285: THEN
1286: fnd_message.set_name ('CSD', 'CSD_API_INV_REP_LINE_ID');
1287: fnd_message.set_token ('REPAIR_LINE_ID',
1288: p_product_txn_rec.repair_line_id
1289: );
1290: fnd_msg_pub.ADD;
1291:

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

1402: l_txn_group_id;
1403:
1404: IF (cur_coverage_details%NOTFOUND)
1405: THEN
1406: fnd_message.set_name ('CSD', 'CSD_API_CONTRACT_MISSING');
1407: fnd_message.set_token ('CONTRACT_LINE_ID',
1408: p_product_txn_rec.contract_id
1409: );
1410: fnd_msg_pub.ADD;

Line 1407: fnd_message.set_token ('CONTRACT_LINE_ID',

1403:
1404: IF (cur_coverage_details%NOTFOUND)
1405: THEN
1406: fnd_message.set_name ('CSD', 'CSD_API_CONTRACT_MISSING');
1407: fnd_message.set_token ('CONTRACT_LINE_ID',
1408: p_product_txn_rec.contract_id
1409: );
1410: fnd_msg_pub.ADD;
1411:

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

1441: INTO l_party_id, l_account_id;
1442:
1443: IF (cur_cust_details%NOTFOUND OR l_party_id IS NULL)
1444: THEN
1445: fnd_message.set_name ('CSD', 'CSD_API_PARTY_MISSING');
1446: fnd_message.set_token ('INCIDENT_ID', l_incident_id);
1447: fnd_msg_pub.ADD;
1448:
1449: CLOSE cur_cust_details;

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

1442:
1443: IF (cur_cust_details%NOTFOUND OR l_party_id IS NULL)
1444: THEN
1445: fnd_message.set_name ('CSD', 'CSD_API_PARTY_MISSING');
1446: fnd_message.set_token ('INCIDENT_ID', l_incident_id);
1447: fnd_msg_pub.ADD;
1448:
1449: CLOSE cur_cust_details;
1450:

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

1492: -- If line_type_id Or line_category_code is null
1493: -- then raise error
1494: IF (l_line_type_id IS NULL OR l_line_category_code IS NULL)
1495: THEN
1496: fnd_message.set_name ('CSD', 'CSD_API_LINE_TYPE_MISSING');
1497: fnd_message.set_token ('TXN_BILLING_TYPE_ID',
1498: p_product_txn_rec.txn_billing_type_id
1499: );
1500: fnd_msg_pub.ADD;

Line 1497: fnd_message.set_token ('TXN_BILLING_TYPE_ID',

1493: -- then raise error
1494: IF (l_line_type_id IS NULL OR l_line_category_code IS NULL)
1495: THEN
1496: fnd_message.set_name ('CSD', 'CSD_API_LINE_TYPE_MISSING');
1497: fnd_message.set_token ('TXN_BILLING_TYPE_ID',
1498: p_product_txn_rec.txn_billing_type_id
1499: );
1500: fnd_msg_pub.ADD;
1501: RAISE fnd_api.g_exc_error;

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

1515: AND p_product_txn_rec.process_txn_flag = 'Y'
1516: )
1517: )
1518: THEN
1519: fnd_message.set_name ('CSD', 'CSD_API_SERIAL_NUM_MISSING');
1520: fnd_message.set_token ('INVENTORY_ITEM_ID',
1521: p_product_txn_rec.inventory_item_id
1522: );
1523: fnd_msg_pub.ADD;

Line 1520: fnd_message.set_token ('INVENTORY_ITEM_ID',

1516: )
1517: )
1518: THEN
1519: fnd_message.set_name ('CSD', 'CSD_API_SERIAL_NUM_MISSING');
1520: fnd_message.set_token ('INVENTORY_ITEM_ID',
1521: p_product_txn_rec.inventory_item_id
1522: );
1523: fnd_msg_pub.ADD;
1524:

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

1548: INTO l_curr_code;
1549:
1550: IF (cur_pricelist_details%NOTFOUND)
1551: THEN
1552: fnd_message.set_name ('CSD', 'CSD_API_INV_PRICE_LIST_ID');
1553: fnd_message.set_token ('PRICE_LIST_ID',
1554: p_product_txn_rec.price_list_id
1555: );
1556: fnd_msg_pub.ADD;

Line 1553: fnd_message.set_token ('PRICE_LIST_ID',

1549:
1550: IF (cur_pricelist_details%NOTFOUND)
1551: THEN
1552: fnd_message.set_name ('CSD', 'CSD_API_INV_PRICE_LIST_ID');
1553: fnd_message.set_token ('PRICE_LIST_ID',
1554: p_product_txn_rec.price_list_id
1555: );
1556: fnd_msg_pub.ADD;
1557:

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

1999: WHERE repair_line_id = p_product_txn_rec.repair_line_id;
2000:
2001: IF SQL%NOTFOUND
2002: THEN
2003: fnd_message.set_name ('CSD', 'CSD_ERR_REPAIRS_UPDATE');
2004: fnd_message.set_token ('REPAIR_LINE_ID',
2005: p_product_txn_rec.repair_line_id
2006: );
2007: fnd_msg_pub.ADD;

Line 2004: fnd_message.set_token ('REPAIR_LINE_ID',

2000:
2001: IF SQL%NOTFOUND
2002: THEN
2003: fnd_message.set_name ('CSD', 'CSD_ERR_REPAIRS_UPDATE');
2004: fnd_message.set_token ('REPAIR_LINE_ID',
2005: p_product_txn_rec.repair_line_id
2006: );
2007: fnd_msg_pub.ADD;
2008: RAISE fnd_api.g_exc_error;

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

2022: WHERE product_transaction_id = p_product_txn_rec.product_transaction_id;
2023:
2024: IF SQL%NOTFOUND
2025: THEN
2026: fnd_message.set_name ('CSD', 'CSD_ERR_PRD_TXN_UPDATE');
2027: fnd_message.set_token ('PRODUCT_TRANSACTION_ID',
2028: p_product_txn_rec.product_transaction_id
2029: );
2030: fnd_msg_pub.ADD;

Line 2027: fnd_message.set_token ('PRODUCT_TRANSACTION_ID',

2023:
2024: IF SQL%NOTFOUND
2025: THEN
2026: fnd_message.set_name ('CSD', 'CSD_ERR_PRD_TXN_UPDATE');
2027: fnd_message.set_token ('PRODUCT_TRANSACTION_ID',
2028: p_product_txn_rec.product_transaction_id
2029: );
2030: fnd_msg_pub.ADD;
2031: RAISE fnd_api.g_exc_error;

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

2198: --px_instance_rec.bill_to_site_use_id;
2199: EXCEPTION
2200: WHEN NO_DATA_FOUND
2201: THEN
2202: fnd_message.set_name ('CSD', 'CSD_INVALID_SITE_USED_ID');
2203: fnd_message.set_token ('BILL_TO_SITE_USE_ID',
2204: px_instance_rec.party_site_use_id
2205: );
2206: --px_instance_rec.bill_to_site_use_id);

Line 2203: fnd_message.set_token ('BILL_TO_SITE_USE_ID',

2199: EXCEPTION
2200: WHEN NO_DATA_FOUND
2201: THEN
2202: fnd_message.set_name ('CSD', 'CSD_INVALID_SITE_USED_ID');
2203: fnd_message.set_token ('BILL_TO_SITE_USE_ID',
2204: px_instance_rec.party_site_use_id
2205: );
2206: --px_instance_rec.bill_to_site_use_id);
2207: RAISE fnd_api.g_exc_error;

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

2590: AND lookup_code = p_product_txn_rec.prod_txn_status;
2591: EXCEPTION
2592: WHEN OTHERS
2593: THEN
2594: fnd_message.set_name ('CSD', 'CSD_ERR_PROD_TXN_STATUS');
2595: fnd_msg_pub.ADD;
2596: RAISE fnd_api.g_exc_error;
2597: END;
2598: END IF;

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

2646: END IF;
2647: EXCEPTION
2648: WHEN NO_DATA_FOUND
2649: THEN
2650: fnd_message.set_name ('CSD', 'CSD_API_INV_ITEM_ID');
2651: fnd_message.set_token ('INVENTORY_ITEM_ID', p_inv_item_id);
2652: fnd_msg_pub.ADD;
2653: RAISE fnd_api.g_exc_error;
2654: END is_item_pre_serialized;

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

2647: EXCEPTION
2648: WHEN NO_DATA_FOUND
2649: THEN
2650: fnd_message.set_name ('CSD', 'CSD_API_INV_ITEM_ID');
2651: fnd_message.set_token ('INVENTORY_ITEM_ID', p_inv_item_id);
2652: fnd_msg_pub.ADD;
2653: RAISE fnd_api.g_exc_error;
2654: END is_item_pre_serialized;
2655:

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

2674: END IF;
2675: EXCEPTION
2676: WHEN NO_DATA_FOUND
2677: THEN
2678: fnd_message.set_name ('CSD', 'CSD_API_INV_ITEM_ID');
2679: fnd_message.set_token ('INVENTORY_ITEM_ID', p_inv_item_id);
2680: fnd_msg_pub.ADD;
2681: RAISE fnd_api.g_exc_error;
2682: END is_item_ib_trackable;

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

2675: EXCEPTION
2676: WHEN NO_DATA_FOUND
2677: THEN
2678: fnd_message.set_name ('CSD', 'CSD_API_INV_ITEM_ID');
2679: fnd_message.set_token ('INVENTORY_ITEM_ID', p_inv_item_id);
2680: fnd_msg_pub.ADD;
2681: RAISE fnd_api.g_exc_error;
2682: END is_item_ib_trackable;
2683:

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

2743: INTO p_order_rec.order_header_id, l_order_line_id;
2744:
2745: IF (cur_ord_details%NOTFOUND)
2746: THEN
2747: fnd_message.set_name ('CSD','CSD_API_BOOKING_FAILED'); /*FP Fixed for bug#5147030 message changed*/
2748: /*
2749: fnd_message.set_name ('CSD', 'CSD_API_INV_EST_DETAIL_ID');
2750: fnd_message.set_token ('ESTIMATE_DETAIL_ID', p_est_detail_id);
2751: */

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

2745: IF (cur_ord_details%NOTFOUND)
2746: THEN
2747: fnd_message.set_name ('CSD','CSD_API_BOOKING_FAILED'); /*FP Fixed for bug#5147030 message changed*/
2748: /*
2749: fnd_message.set_name ('CSD', 'CSD_API_INV_EST_DETAIL_ID');
2750: fnd_message.set_token ('ESTIMATE_DETAIL_ID', p_est_detail_id);
2751: */
2752: fnd_msg_pub.ADD;
2753:

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

2746: THEN
2747: fnd_message.set_name ('CSD','CSD_API_BOOKING_FAILED'); /*FP Fixed for bug#5147030 message changed*/
2748: /*
2749: fnd_message.set_name ('CSD', 'CSD_API_INV_EST_DETAIL_ID');
2750: fnd_message.set_token ('ESTIMATE_DETAIL_ID', p_est_detail_id);
2751: */
2752: fnd_msg_pub.ADD;
2753:
2754: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

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

2784: INTO l_ship_from_org_id, l_unit_selling_price, p_order_rec.org_id;
2785:
2786: IF (cur_ord_line%NOTFOUND)
2787: THEN
2788: fnd_message.set_name ('CSD', 'CSD_API_SALES_REP_MISSING');
2789: fnd_message.set_token ('ORDER_LINE_ID', l_order_line_id);
2790: fnd_msg_pub.ADD;
2791:
2792: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

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

2785:
2786: IF (cur_ord_line%NOTFOUND)
2787: THEN
2788: fnd_message.set_name ('CSD', 'CSD_API_SALES_REP_MISSING');
2789: fnd_message.set_token ('ORDER_LINE_ID', l_order_line_id);
2790: fnd_msg_pub.ADD;
2791:
2792: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2793: THEN

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

2817: CLOSE cur_ord_line;
2818:
2819: IF l_ship_from_org_id IS NULL
2820: THEN
2821: fnd_message.set_name ('CSD', 'CSD_API_SHIP_FROM_ORG_MISSING');
2822: fnd_message.set_token ('ORDER_LINE_ID', l_order_line_id);
2823: fnd_msg_pub.ADD;
2824:
2825: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

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

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

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

2835: END IF;
2836:
2837: IF l_unit_selling_price IS NULL
2838: THEN
2839: fnd_message.set_name ('CSD', 'CSD_API_PRICE_MISSING');
2840: fnd_message.set_token ('ORDER_LINE_ID', l_order_line_id);
2841: fnd_msg_pub.ADD;
2842:
2843: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

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

2836:
2837: IF l_unit_selling_price IS NULL
2838: THEN
2839: fnd_message.set_name ('CSD', 'CSD_API_PRICE_MISSING');
2840: fnd_message.set_token ('ORDER_LINE_ID', l_order_line_id);
2841: fnd_msg_pub.ADD;
2842:
2843: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
2844: THEN

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

2858: INTO x_booked_flag;
2859:
2860: IF (cur_ord_hdr%NOTFOUND)
2861: THEN
2862: fnd_message.set_name ('CSD', 'CSD_INV_ORDER_HEADER_ID');
2863: fnd_message.set_token ('ORDER_HEADER_ID',
2864: p_order_rec.order_header_id
2865: );
2866: fnd_msg_pub.ADD;

Line 2863: fnd_message.set_token ('ORDER_HEADER_ID',

2859:
2860: IF (cur_ord_hdr%NOTFOUND)
2861: THEN
2862: fnd_message.set_name ('CSD', 'CSD_INV_ORDER_HEADER_ID');
2863: fnd_message.set_token ('ORDER_HEADER_ID',
2864: p_order_rec.order_header_id
2865: );
2866: fnd_msg_pub.ADD;
2867: