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:
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:
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;
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;
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;
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;
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: */
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;
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:
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;
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:
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;
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:
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;
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;
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;
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:
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;
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:
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;
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;
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;
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;
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);
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;
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;
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;
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:
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;
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:
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: */
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:
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)
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)
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
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)
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
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)
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
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;
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: