[Home] [Help]
949: END IF;
950:
951: IF NVL(p_delivery_id, Fnd_Api.G_MISS_NUM) = Fnd_Api.G_MISS_NUM
952: THEN
953: Fnd_Message.SET_NAME('CSD', 'CSD_INV_DELIVERY_ID');
954: Fnd_Message.SET_TOKEN('DELIVERY_ID', p_delivery_id);
955: Fnd_Msg_Pub.ADD;
956: IF (g_debug > 0)
957: THEN
950:
951: IF NVL(p_delivery_id, Fnd_Api.G_MISS_NUM) = Fnd_Api.G_MISS_NUM
952: THEN
953: Fnd_Message.SET_NAME('CSD', 'CSD_INV_DELIVERY_ID');
954: Fnd_Message.SET_TOKEN('DELIVERY_ID', p_delivery_id);
955: Fnd_Msg_Pub.ADD;
956: IF (g_debug > 0)
957: THEN
958: Csd_Gen_Utility_Pvt.ADD('Delivery_id is invalid');
966: FROM wsh_new_deliveries
967: WHERE delivery_id = p_delivery_id;
968: EXCEPTION
969: WHEN NO_DATA_FOUND THEN
970: Fnd_Message.SET_NAME('CSD', 'CSD_INV_DELIVERY_ID');
971: Fnd_Message.SET_TOKEN('DELIVERY_ID', p_delivery_id);
972: Fnd_Msg_Pub.ADD;
973: IF (g_debug > 0)
974: THEN
967: WHERE delivery_id = p_delivery_id;
968: EXCEPTION
969: WHEN NO_DATA_FOUND THEN
970: Fnd_Message.SET_NAME('CSD', 'CSD_INV_DELIVERY_ID');
971: Fnd_Message.SET_TOKEN('DELIVERY_ID', p_delivery_id);
972: Fnd_Msg_Pub.ADD;
973: IF (g_debug > 0)
974: THEN
975: Csd_Gen_Utility_Pvt.ADD('Delivery_id is invalid');
1047: Csd_Gen_Utility_Pvt.ADD('Error Msg from Update_Shipping_Attributes');
1048: Csd_Gen_Utility_Pvt.ADD('x_msg_data = ' ||
1049: x_msg_data);
1050: END IF;
1051: Fnd_Message.SET_NAME('CSD',
1052: 'CSD_UPDATE_SHIPPING_FAILED');
1053: Fnd_Message.SET_TOKEN('ERR_MSG', x_msg_data);
1054: Fnd_Msg_Pub.ADD;
1055: RAISE Fnd_Api.G_EXC_ERROR;
1049: x_msg_data);
1050: END IF;
1051: Fnd_Message.SET_NAME('CSD',
1052: 'CSD_UPDATE_SHIPPING_FAILED');
1053: Fnd_Message.SET_TOKEN('ERR_MSG', x_msg_data);
1054: Fnd_Msg_Pub.ADD;
1055: RAISE Fnd_Api.G_EXC_ERROR;
1056: END;
1057:
1154:
1155: -- Ignore if it is a warning
1156: IF (x_return_status <> Wsh_Util_Core.G_RET_STS_WARNING)
1157: THEN
1158: Fnd_Message.SET_NAME('CSD', 'CSD_SHIP_CONFIRM_FAILED');
1159: Fnd_Message.SET_TOKEN('ERR_MSG', x_msg_data);
1160: Fnd_Msg_Pub.ADD;
1161: RAISE Fnd_Api.G_EXC_ERROR;
1162: END IF;
1155: -- Ignore if it is a warning
1156: IF (x_return_status <> Wsh_Util_Core.G_RET_STS_WARNING)
1157: THEN
1158: Fnd_Message.SET_NAME('CSD', 'CSD_SHIP_CONFIRM_FAILED');
1159: Fnd_Message.SET_TOKEN('ERR_MSG', x_msg_data);
1160: Fnd_Msg_Pub.ADD;
1161: RAISE Fnd_Api.G_EXC_ERROR;
1162: END IF;
1163:
1556:
1557: IF NVL(p_order_rec.order_header_id, Fnd_Api.G_MISS_NUM) =
1558: Fnd_Api.G_MISS_NUM
1559: THEN
1560: Fnd_Message.SET_NAME('CSD', 'CSD_INV_ORDER_HEADER_ID');
1561: Fnd_Message.SET_TOKEN('ORDER_HEADER_ID',
1562: p_order_rec.order_header_id);
1563: Fnd_Msg_Pub.ADD;
1564: Debug('Invalid Order header Id is passed ', l_mod_name, 1);
1557: IF NVL(p_order_rec.order_header_id, Fnd_Api.G_MISS_NUM) =
1558: Fnd_Api.G_MISS_NUM
1559: THEN
1560: Fnd_Message.SET_NAME('CSD', 'CSD_INV_ORDER_HEADER_ID');
1561: Fnd_Message.SET_TOKEN('ORDER_HEADER_ID',
1562: p_order_rec.order_header_id);
1563: Fnd_Msg_Pub.ADD;
1564: Debug('Invalid Order header Id is passed ', l_mod_name, 1);
1565: RAISE Fnd_Api.G_EXC_ERROR;
1567:
1568: IF NVL(p_order_rec.PICKING_RULE_ID, Fnd_Api.G_MISS_NUM) =
1569: Fnd_Api.G_MISS_NUM
1570: THEN
1571: Fnd_Message.SET_NAME('CSD', 'CSD_INV_PICKING_RULE_ID');
1572: Fnd_Message.SET_TOKEN('PICKING_RULE_ID',
1573: p_order_rec.PICKING_RULE_ID);
1574: Fnd_Msg_Pub.ADD;
1575: Debug('Invalid Picking rule Id is passed ', l_mod_name, 1);
1568: IF NVL(p_order_rec.PICKING_RULE_ID, Fnd_Api.G_MISS_NUM) =
1569: Fnd_Api.G_MISS_NUM
1570: THEN
1571: Fnd_Message.SET_NAME('CSD', 'CSD_INV_PICKING_RULE_ID');
1572: Fnd_Message.SET_TOKEN('PICKING_RULE_ID',
1573: p_order_rec.PICKING_RULE_ID);
1574: Fnd_Msg_Pub.ADD;
1575: Debug('Invalid Picking rule Id is passed ', l_mod_name, 1);
1576: RAISE Fnd_Api.G_EXC_ERROR;
1724:
1725:
1726: Exception
1727: WHEN OTHERS THEN
1728: Fnd_Message.SET_NAME('CSD', 'CSD_PICK_RELEASE_FAIL');
1729: Fnd_Message.SET_TOKEN('BATCH_NAME', l_batch_name);
1730: Fnd_Msg_Pub.ADD;
1731: Debug(' Picking rules insert failed ',l_mod_name, 1);
1732: RAISE Fnd_Api.G_EXC_ERROR;
1725:
1726: Exception
1727: WHEN OTHERS THEN
1728: Fnd_Message.SET_NAME('CSD', 'CSD_PICK_RELEASE_FAIL');
1729: Fnd_Message.SET_TOKEN('BATCH_NAME', l_batch_name);
1730: Fnd_Msg_Pub.ADD;
1731: Debug(' Picking rules insert failed ',l_mod_name, 1);
1732: RAISE Fnd_Api.G_EXC_ERROR;
1733: End ;
1797:
1798:
1799: IF (x_return_status = Fnd_Api.G_RET_STS_ERROR)
1800: THEN
1801: Fnd_Message.SET_NAME('CSD', 'CSD_PICK_RELEASE_FAIL');
1802: Fnd_Message.SET_TOKEN('BATCH_NAME', l_batch_name);
1803: Fnd_Msg_Pub.ADD;
1804: Debug('WSH_PICK_LIST.RELEASE_BATCH failed for batch : ' ||
1805: l_batch_name,
1798:
1799: IF (x_return_status = Fnd_Api.G_RET_STS_ERROR)
1800: THEN
1801: Fnd_Message.SET_NAME('CSD', 'CSD_PICK_RELEASE_FAIL');
1802: Fnd_Message.SET_TOKEN('BATCH_NAME', l_batch_name);
1803: Fnd_Msg_Pub.ADD;
1804: Debug('WSH_PICK_LIST.RELEASE_BATCH failed for batch : ' ||
1805: l_batch_name,
1806: l_mod_name,1) ;
1820:
1821: IF NVL(p_order_rec.order_header_id, Fnd_Api.G_MISS_NUM) =
1822: Fnd_Api.G_MISS_NUM
1823: THEN
1824: Fnd_Message.SET_NAME('CSD', 'CSD_INV_ORDER_HEADER_ID');
1825: Fnd_Message.SET_TOKEN('ORDER_HEADER_ID',
1826: p_order_rec.order_header_id);
1827: Fnd_Msg_Pub.ADD;
1828: Debug('Order_header_id is invalid', l_mod_name, 1);
1821: IF NVL(p_order_rec.order_header_id, Fnd_Api.G_MISS_NUM) =
1822: Fnd_Api.G_MISS_NUM
1823: THEN
1824: Fnd_Message.SET_NAME('CSD', 'CSD_INV_ORDER_HEADER_ID');
1825: Fnd_Message.SET_TOKEN('ORDER_HEADER_ID',
1826: p_order_rec.order_header_id);
1827: Fnd_Msg_Pub.ADD;
1828: Debug('Order_header_id is invalid', l_mod_name, 1);
1829: RAISE Fnd_Api.G_EXC_ERROR;
1985: if i.serial_number_control_code in (2,5,6) then
1986:
1987: if nvl(p_product_txn_rec.source_serial_number,FND_API.G_MISS_CHAR)=FND_API.G_MISS_CHAR then
1988: /* Validation 3 */
1989: FND_MESSAGE.SET_NAME('CSD','CSD_API_SERIAL_NUM_REQD');
1990: FND_MSG_PUB.ADD;
1991: RAISE FND_API.G_EXC_ERROR;
1992: else
1993: l_shipped_serial_number := p_product_txn_rec.source_serial_number;
2003: exception
2004: when no_data_found then
2005: if (i.serial_number_control_code in (2,5)) then
2006: /*Validation 1 */
2007: FND_MESSAGE.SET_NAME('CSD','CSD_SERIAL_NUM_NOT_IN_INVORG');
2008: FND_MESSAGE.SET_TOKEN('SERIAL_NUMBER',l_shipped_serial_number);
2009: FND_MESSAGE.SET_TOKEN('INV_ORG',i.organization_code);
2010: FND_MSG_PUB.ADD;
2011: RAISE FND_API.G_EXC_ERROR;
2004: when no_data_found then
2005: if (i.serial_number_control_code in (2,5)) then
2006: /*Validation 1 */
2007: FND_MESSAGE.SET_NAME('CSD','CSD_SERIAL_NUM_NOT_IN_INVORG');
2008: FND_MESSAGE.SET_TOKEN('SERIAL_NUMBER',l_shipped_serial_number);
2009: FND_MESSAGE.SET_TOKEN('INV_ORG',i.organization_code);
2010: FND_MSG_PUB.ADD;
2011: RAISE FND_API.G_EXC_ERROR;
2012: else /*if Item is Serialied at SO then user may pass SN that does not resides in any warehouse */
2005: if (i.serial_number_control_code in (2,5)) then
2006: /*Validation 1 */
2007: FND_MESSAGE.SET_NAME('CSD','CSD_SERIAL_NUM_NOT_IN_INVORG');
2008: FND_MESSAGE.SET_TOKEN('SERIAL_NUMBER',l_shipped_serial_number);
2009: FND_MESSAGE.SET_TOKEN('INV_ORG',i.organization_code);
2010: FND_MSG_PUB.ADD;
2011: RAISE FND_API.G_EXC_ERROR;
2012: else /*if Item is Serialied at SO then user may pass SN that does not resides in any warehouse */
2013: l_SN_at_SO_new_SN_number :=TRUE;
2017:
2018: if ( i.serial_number_control_code =1 or (i.serial_number_control_code=6 and l_SN_at_SO_new_SN_number=TRUE ) ) then
2019: if nvl(p_product_txn_rec.sub_inventory ,FND_API.G_MISS_CHAR)=FND_API.G_MISS_CHAR then
2020: /*Validation 4 */
2021: FND_MESSAGE.SET_NAME('CSD','CSD_SUBINV_IS_REQD');
2022: FND_MSG_PUB.ADD;
2023: RAISE FND_API.G_EXC_ERROR;
2024: end if;
2025:
2034:
2035: exception
2036: When no_data_found then
2037: /*Validation 2 */
2038: FND_MESSAGE.SET_NAME('CSD','CSD_SUBINV_NOT_IN_INVORG');
2039: FND_MESSAGE.SET_TOKEN('SUB_INV',p_product_txn_rec.sub_inventory);
2040: FND_MESSAGE.SET_TOKEN('INV_ORG',i.organization_code);
2041: FND_MSG_PUB.ADD;
2042: RAISE FND_API.G_EXC_ERROR;
2035: exception
2036: When no_data_found then
2037: /*Validation 2 */
2038: FND_MESSAGE.SET_NAME('CSD','CSD_SUBINV_NOT_IN_INVORG');
2039: FND_MESSAGE.SET_TOKEN('SUB_INV',p_product_txn_rec.sub_inventory);
2040: FND_MESSAGE.SET_TOKEN('INV_ORG',i.organization_code);
2041: FND_MSG_PUB.ADD;
2042: RAISE FND_API.G_EXC_ERROR;
2043: end;
2036: When no_data_found then
2037: /*Validation 2 */
2038: FND_MESSAGE.SET_NAME('CSD','CSD_SUBINV_NOT_IN_INVORG');
2039: FND_MESSAGE.SET_TOKEN('SUB_INV',p_product_txn_rec.sub_inventory);
2040: FND_MESSAGE.SET_TOKEN('INV_ORG',i.organization_code);
2041: FND_MSG_PUB.ADD;
2042: RAISE FND_API.G_EXC_ERROR;
2043: end;
2044:
2044:
2045: if i.LOT_CONTROL_CODE =2 then
2046: if nvl(p_product_txn_rec.lot_number,FND_API.G_MISS_CHAR)=FND_API.G_MISS_CHAR then
2047: /*Validation 5 */
2048: FND_MESSAGE.SET_NAME('CSD','CSD_LOT_NUMBER_REQD');
2049: FND_MESSAGE.SET_TOKEN('ITEM',i.item_name);
2050: FND_MSG_PUB.ADD;
2051: RAISE FND_API.G_EXC_ERROR;
2052: else
2045: if i.LOT_CONTROL_CODE =2 then
2046: if nvl(p_product_txn_rec.lot_number,FND_API.G_MISS_CHAR)=FND_API.G_MISS_CHAR then
2047: /*Validation 5 */
2048: FND_MESSAGE.SET_NAME('CSD','CSD_LOT_NUMBER_REQD');
2049: FND_MESSAGE.SET_TOKEN('ITEM',i.item_name);
2050: FND_MSG_PUB.ADD;
2051: RAISE FND_API.G_EXC_ERROR;
2052: else
2053: l_lot_number:= p_product_txn_rec.lot_number;
2055: end if;
2056:
2057: if i.REVISION_QTY_CONTROL_CODE =2 then
2058: if nvl(p_product_txn_rec.revision,FND_API.G_MISS_CHAR)=FND_API.G_MISS_CHAR then
2059: FND_MESSAGE.SET_NAME('CSD','CSD_ITEM_REVISION_REQD');
2060: FND_MESSAGE.SET_TOKEN('ITEM',i.item_name);
2061: FND_MSG_PUB.ADD;
2062: RAISE FND_API.G_EXC_ERROR;
2063: else
2056:
2057: if i.REVISION_QTY_CONTROL_CODE =2 then
2058: if nvl(p_product_txn_rec.revision,FND_API.G_MISS_CHAR)=FND_API.G_MISS_CHAR then
2059: FND_MESSAGE.SET_NAME('CSD','CSD_ITEM_REVISION_REQD');
2060: FND_MESSAGE.SET_TOKEN('ITEM',i.item_name);
2061: FND_MSG_PUB.ADD;
2062: RAISE FND_API.G_EXC_ERROR;
2063: else
2064: l_revision:=p_product_txn_rec.revision;
2130: 1);
2131: Debug('x_msg_data = ' || x_msg_data,
2132: l_mod_name,
2133: 1);
2134: Fnd_Message.SET_NAME('CSD','CSD_UPDATE_SHIPPING_FAILED');
2135: Fnd_Message.SET_TOKEN('ERR_MSG', x_msg_data);
2136: Fnd_Msg_Pub.ADD;
2137: RAISE Fnd_Api.G_EXC_ERROR;
2138: END;
2131: Debug('x_msg_data = ' || x_msg_data,
2132: l_mod_name,
2133: 1);
2134: Fnd_Message.SET_NAME('CSD','CSD_UPDATE_SHIPPING_FAILED');
2135: Fnd_Message.SET_TOKEN('ERR_MSG', x_msg_data);
2136: Fnd_Msg_Pub.ADD;
2137: RAISE Fnd_Api.G_EXC_ERROR;
2138: END;
2139:
2259: when no_data_found then
2260: l_shipped_flag :='Y';
2261: end;
2262: if l_shipped_flag = 'N' then
2263: FND_MESSAGE.SET_NAME('CSD','CSD_SHIP_CONFIRM_FAILED');
2264: FND_MESSAGE.SET_TOKEN('ERR_MSG',x_msg_data);
2265: FND_MSG_PUB.ADD;
2266: RAISE FND_API.G_EXC_ERROR;
2267: end if;
2260: l_shipped_flag :='Y';
2261: end;
2262: if l_shipped_flag = 'N' then
2263: FND_MESSAGE.SET_NAME('CSD','CSD_SHIP_CONFIRM_FAILED');
2264: FND_MESSAGE.SET_TOKEN('ERR_MSG',x_msg_data);
2265: FND_MSG_PUB.ADD;
2266: RAISE FND_API.G_EXC_ERROR;
2267: end if;
2268: END IF;
2584: FETCH cur_pick_rules
2585: INTO l_tmp_char;
2586: IF (cur_pick_rules%NOTFOUND)
2587: THEN
2588: Fnd_Message.SET_NAME('CSD', 'CSD_INV_PICK_RULE');
2589: Fnd_Msg_Pub.ADD;
2590: RAISE Fnd_Api.G_EXC_ERROR;
2591: END IF;
2592: END IF;
2631: WHERE lookup_type = 'CSD_PRODUCT_TXN_STATUS'
2632: AND lookup_code = x_product_txn_rec.PROD_TXN_STATUS;
2633: EXCEPTION
2634: WHEN OTHERS THEN
2635: Fnd_Message.SET_NAME('CSD', 'CSD_ERR_PROD_TXN_STATUS');
2636: Fnd_Msg_Pub.ADD;
2637: RAISE Fnd_Api.G_EXC_ERROR;
2638: END;
2639: END IF;
2652: FROM csd_repairs
2653: WHERE repair_line_id = x_product_txn_rec.repair_line_id;
2654: EXCEPTION
2655: WHEN OTHERS THEN
2656: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');
2657: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
2658: x_product_txn_rec.repair_line_id);
2659: Fnd_Msg_Pub.ADD;
2660: RAISE Fnd_Api.G_EXC_ERROR;
2653: WHERE repair_line_id = x_product_txn_rec.repair_line_id;
2654: EXCEPTION
2655: WHEN OTHERS THEN
2656: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');
2657: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
2658: x_product_txn_rec.repair_line_id);
2659: Fnd_Msg_Pub.ADD;
2660: RAISE Fnd_Api.G_EXC_ERROR;
2661: END;
2757: END IF;
2758: --]
2759: EXCEPTION
2760: WHEN NO_DATA_FOUND THEN
2761: Fnd_Message.SET_NAME('CSD', 'CSD_API_CONTRACT_MISSING');
2762: Fnd_Message.SET_TOKEN('CONTRACT_LINE_ID',
2763: x_product_txn_rec.contract_id);
2764: Fnd_Msg_Pub.ADD;
2765: Debug('Contract Line Id missing', l_mod_name, 1);
2758: --]
2759: EXCEPTION
2760: WHEN NO_DATA_FOUND THEN
2761: Fnd_Message.SET_NAME('CSD', 'CSD_API_CONTRACT_MISSING');
2762: Fnd_Message.SET_TOKEN('CONTRACT_LINE_ID',
2763: x_product_txn_rec.contract_id);
2764: Fnd_Msg_Pub.ADD;
2765: Debug('Contract Line Id missing', l_mod_name, 1);
2766: RAISE Fnd_Api.G_EXC_ERROR;
2786: FETCH order_rec
2787: INTO l_party_id, l_account_id;
2788: IF (order_rec%NOTFOUND OR l_party_id IS NULL)
2789: THEN
2790: Fnd_Message.SET_NAME('CSD', 'CSD_API_PARTY_MISSING');
2791: Fnd_Message.SET_TOKEN('INCIDENT_ID', l_incident_id);
2792: Fnd_Msg_Pub.ADD;
2793: RAISE Fnd_Api.G_EXC_ERROR;
2794: END IF;
2787: INTO l_party_id, l_account_id;
2788: IF (order_rec%NOTFOUND OR l_party_id IS NULL)
2789: THEN
2790: Fnd_Message.SET_NAME('CSD', 'CSD_API_PARTY_MISSING');
2791: Fnd_Message.SET_TOKEN('INCIDENT_ID', l_incident_id);
2792: Fnd_Msg_Pub.ADD;
2793: RAISE Fnd_Api.G_EXC_ERROR;
2794: END IF;
2795: IF order_rec%ISOPEN
2844: -- If line_type_id Or line_category_code is null
2845: -- then raise error
2846: IF (l_line_type_id IS NULL OR l_line_category_code IS NULL)
2847: THEN
2848: Fnd_Message.SET_NAME('CSD', 'CSD_API_LINE_TYPE_MISSING');
2849: Fnd_Message.SET_TOKEN('TXN_BILLING_TYPE_ID',
2850: x_product_txn_rec.txn_billing_type_id);
2851: Fnd_Msg_Pub.ADD;
2852: RAISE Fnd_Api.G_EXC_ERROR;
2845: -- then raise error
2846: IF (l_line_type_id IS NULL OR l_line_category_code IS NULL)
2847: THEN
2848: Fnd_Message.SET_NAME('CSD', 'CSD_API_LINE_TYPE_MISSING');
2849: Fnd_Message.SET_TOKEN('TXN_BILLING_TYPE_ID',
2850: x_product_txn_rec.txn_billing_type_id);
2851: Fnd_Msg_Pub.ADD;
2852: RAISE Fnd_Api.G_EXC_ERROR;
2853: END IF;
2862: FROM oe_price_lists
2863: WHERE price_list_id = x_product_txn_rec.price_list_id;
2864: EXCEPTION
2865: WHEN NO_DATA_FOUND THEN
2866: Fnd_Message.SET_NAME('CSD',
2867: 'CSD_API_INV_PRICE_LIST_ID');
2868: Fnd_Message.SET_TOKEN('PRICE_LIST_ID',
2869: x_product_txn_rec.price_list_id);
2870: Fnd_Msg_Pub.ADD;
2864: EXCEPTION
2865: WHEN NO_DATA_FOUND THEN
2866: Fnd_Message.SET_NAME('CSD',
2867: 'CSD_API_INV_PRICE_LIST_ID');
2868: Fnd_Message.SET_TOKEN('PRICE_LIST_ID',
2869: x_product_txn_rec.price_list_id);
2870: Fnd_Msg_Pub.ADD;
2871: RAISE Fnd_Api.G_EXC_ERROR;
2872: WHEN TOO_MANY_ROWS THEN
2878:
2879: -- If l_curr_code is null then raise error
2880: IF l_curr_code IS NULL
2881: THEN
2882: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_CURR_CODE');
2883: Fnd_Message.SET_TOKEN('PRICE_LIST_ID',
2884: x_product_txn_rec.price_list_id);
2885: Fnd_Msg_Pub.ADD;
2886: RAISE Fnd_Api.G_EXC_ERROR;
2879: -- If l_curr_code is null then raise error
2880: IF l_curr_code IS NULL
2881: THEN
2882: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_CURR_CODE');
2883: Fnd_Message.SET_TOKEN('PRICE_LIST_ID',
2884: x_product_txn_rec.price_list_id);
2885: Fnd_Msg_Pub.ADD;
2886: RAISE Fnd_Api.G_EXC_ERROR;
2887: END IF;
2904: x_product_txn_rec.action_type NOT IN ('SHIP', 'WALK_IN_ISSUE') AND
2905: (x_product_txn_rec.action_code <> 'LOANER' AND
2906: x_product_txn_rec.action_type <> 'RMA')
2907: THEN
2908: Fnd_Message.SET_NAME('CSD', 'CSD_API_SERIAL_NUM_MISSING');
2909: Fnd_Message.SET_TOKEN('INVENTORY_ITEM_ID',
2910: x_product_txn_rec.inventory_item_id);
2911: Fnd_Msg_Pub.ADD;
2912: Debug('Serial Number missing for inventory_item_id =' ||
2905: (x_product_txn_rec.action_code <> 'LOANER' AND
2906: x_product_txn_rec.action_type <> 'RMA')
2907: THEN
2908: Fnd_Message.SET_NAME('CSD', 'CSD_API_SERIAL_NUM_MISSING');
2909: Fnd_Message.SET_TOKEN('INVENTORY_ITEM_ID',
2910: x_product_txn_rec.inventory_item_id);
2911: Fnd_Msg_Pub.ADD;
2912: Debug('Serial Number missing for inventory_item_id =' ||
2913: x_product_txn_rec.inventory_item_id,
3100: SET ro_txn_status = 'CHARGE_ENTERED'
3101: WHERE repair_line_id = x_product_txn_rec.REPAIR_LINE_ID;
3102: IF SQL%NOTFOUND
3103: THEN
3104: Fnd_Message.SET_NAME('CSD', 'CSD_ERR_REPAIRS_UPDATE');
3105: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3106: x_product_txn_rec.repair_line_id);
3107: Fnd_Msg_Pub.ADD;
3108: RAISE Fnd_Api.G_EXC_ERROR;
3101: WHERE repair_line_id = x_product_txn_rec.REPAIR_LINE_ID;
3102: IF SQL%NOTFOUND
3103: THEN
3104: Fnd_Message.SET_NAME('CSD', 'CSD_ERR_REPAIRS_UPDATE');
3105: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3106: x_product_txn_rec.repair_line_id);
3107: Fnd_Msg_Pub.ADD;
3108: RAISE Fnd_Api.G_EXC_ERROR;
3109: END IF;
3137: AND inventory_item_id =
3138: x_product_txn_rec.inventory_item_id;
3139: EXCEPTION
3140: WHEN NO_DATA_FOUND THEN
3141: Fnd_Message.SET_NAME('CSD',
3142: 'CSD_INVALID_INVENTORY_ITEM');
3143: Fnd_Msg_Pub.ADD;
3144: RAISE CREATE_ORDER;
3145: END;
3156: Cs_Std.get_item_valdn_orgzn_id
3157: AND revision = x_product_txn_rec.revision;
3158: EXCEPTION
3159: WHEN NO_DATA_FOUND THEN
3160: Fnd_Message.SET_NAME('CSD',
3161: 'CSD_INVALID_REVISION');
3162: Fnd_Msg_Pub.ADD;
3163: RAISE CREATE_ORDER;
3164: END;
3216: WHERE product_transaction_id =
3217: x_product_txn_rec.PRODUCT_TRANSACTION_ID;
3218: IF SQL%NOTFOUND
3219: THEN
3220: Fnd_Message.SET_NAME('CSD',
3221: 'CSD_ERR_PRD_TXN_UPDATE');
3222: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',
3223: x_product_txn_rec.PRODUCT_TRANSACTION_ID);
3224: Fnd_Msg_Pub.ADD;
3218: IF SQL%NOTFOUND
3219: THEN
3220: Fnd_Message.SET_NAME('CSD',
3221: 'CSD_ERR_PRD_TXN_UPDATE');
3222: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',
3223: x_product_txn_rec.PRODUCT_TRANSACTION_ID);
3224: Fnd_Msg_Pub.ADD;
3225: RAISE CREATE_ORDER;
3226: END IF;
3230: WHERE repair_line_id =
3231: x_product_txn_rec.REPAIR_LINE_ID;
3232: IF SQL%NOTFOUND
3233: THEN
3234: Fnd_Message.SET_NAME('CSD',
3235: 'CSD_ERR_REPAIRS_UPDATE');
3236: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3237: x_product_txn_rec.repair_line_id);
3238: Fnd_Msg_Pub.ADD;
3232: IF SQL%NOTFOUND
3233: THEN
3234: Fnd_Message.SET_NAME('CSD',
3235: 'CSD_ERR_REPAIRS_UPDATE');
3236: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3237: x_product_txn_rec.repair_line_id);
3238: Fnd_Msg_Pub.ADD;
3239: RAISE CREATE_ORDER;
3240: END IF;
3270: if (l_project_count >= 1) then
3271: l_Line_Tbl_Type(1).project_id := x_product_txn_rec.project_id;
3272: l_Line_Tbl_Type(1).task_id := x_product_txn_rec.task_id;
3273: else
3274: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PROJECT_UPDATE');
3275: FND_MESSAGE.SET_TOKEN('project_id',x_product_txn_rec.project_id);
3276: FND_MESSAGE.SET_TOKEN('ship_from_org_id',l_p_ship_from_org_id);
3277: FND_MSG_PUB.ADD;
3278: RAISE CREATE_ORDER;
3271: l_Line_Tbl_Type(1).project_id := x_product_txn_rec.project_id;
3272: l_Line_Tbl_Type(1).task_id := x_product_txn_rec.task_id;
3273: else
3274: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PROJECT_UPDATE');
3275: FND_MESSAGE.SET_TOKEN('project_id',x_product_txn_rec.project_id);
3276: FND_MESSAGE.SET_TOKEN('ship_from_org_id',l_p_ship_from_org_id);
3277: FND_MSG_PUB.ADD;
3278: RAISE CREATE_ORDER;
3279: end if;
3272: l_Line_Tbl_Type(1).task_id := x_product_txn_rec.task_id;
3273: else
3274: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PROJECT_UPDATE');
3275: FND_MESSAGE.SET_TOKEN('project_id',x_product_txn_rec.project_id);
3276: FND_MESSAGE.SET_TOKEN('ship_from_org_id',l_p_ship_from_org_id);
3277: FND_MSG_PUB.ADD;
3278: RAISE CREATE_ORDER;
3279: end if;
3280: end if;
3309: x_msg_data => x_msg_data
3310: );
3311:
3312: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3313: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_OM_PROCESS_LINE');
3314: FND_MSG_PUB.ADD;
3315: RAISE CREATE_ORDER;
3316: END IF;
3317: end if; -- order line is not null
3356: l_order_rec.order_line_id := l_order_line_id;
3357:
3358: EXCEPTION
3359: WHEN NO_DATA_FOUND THEN
3360: FND_MESSAGE.SET_NAME('CSD','CSD_API_BOOKING_FAILED'); /*FP Fixed for bug#5147030 message changed*/
3361: /*
3362: Fnd_Message.SET_NAME('CSD',
3363: 'CSD_API_INV_EST_DETAIL_ID');
3364: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',
3358: EXCEPTION
3359: WHEN NO_DATA_FOUND THEN
3360: FND_MESSAGE.SET_NAME('CSD','CSD_API_BOOKING_FAILED'); /*FP Fixed for bug#5147030 message changed*/
3361: /*
3362: Fnd_Message.SET_NAME('CSD',
3363: 'CSD_API_INV_EST_DETAIL_ID');
3364: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',
3365: x_estimate_detail_id); */
3366: Fnd_Msg_Pub.ADD;
3360: FND_MESSAGE.SET_NAME('CSD','CSD_API_BOOKING_FAILED'); /*FP Fixed for bug#5147030 message changed*/
3361: /*
3362: Fnd_Message.SET_NAME('CSD',
3363: 'CSD_API_INV_EST_DETAIL_ID');
3364: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',
3365: x_estimate_detail_id); */
3366: Fnd_Msg_Pub.ADD;
3367: Debug('Sales Order missing for estimate_detail_id =' ||
3368: x_estimate_detail_id,
3395: */
3396: /* AND salesrep_id IS NOT NULL; */
3397: EXCEPTION
3398: WHEN NO_DATA_FOUND THEN
3399: Fnd_Message.SET_NAME('CSD',
3400: 'CSD_API_SALES_REP_MISSING');
3401: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',
3402: l_order_line_id);
3403: Fnd_Msg_Pub.ADD;
3397: EXCEPTION
3398: WHEN NO_DATA_FOUND THEN
3399: Fnd_Message.SET_NAME('CSD',
3400: 'CSD_API_SALES_REP_MISSING');
3401: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',
3402: l_order_line_id);
3403: Fnd_Msg_Pub.ADD;
3404: Debug('Sales rep missing for Line_id=' ||
3405: l_order_line_id,
3413: END;
3414:
3415: IF l_ship_from_org_id IS NULL
3416: THEN
3417: Fnd_Message.SET_NAME('CSD',
3418: 'CSD_API_SHIP_FROM_ORG_MISSING');
3419: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',
3420: l_order_line_id);
3421: Fnd_Msg_Pub.ADD;
3415: IF l_ship_from_org_id IS NULL
3416: THEN
3417: Fnd_Message.SET_NAME('CSD',
3418: 'CSD_API_SHIP_FROM_ORG_MISSING');
3419: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',
3420: l_order_line_id);
3421: Fnd_Msg_Pub.ADD;
3422: Debug('Ship from Org Id missing for Line_id=' ||
3423: l_order_line_id,
3427: END IF;
3428:
3429: IF l_unit_selling_price IS NULL
3430: THEN
3431: Fnd_Message.SET_NAME('CSD',
3432: 'CSD_API_PRICE_MISSING');
3433: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',
3434: l_order_line_id);
3435: Fnd_Msg_Pub.ADD;
3429: IF l_unit_selling_price IS NULL
3430: THEN
3431: Fnd_Message.SET_NAME('CSD',
3432: 'CSD_API_PRICE_MISSING');
3433: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',
3434: l_order_line_id);
3435: Fnd_Msg_Pub.ADD;
3436: Debug('Unit Selling price missing for Line_id=' ||
3437: l_order_line_id,
3491: if (l_project_count >= 1) then
3492: l_Line_Tbl_Type(1).project_id := x_product_txn_rec.project_id;
3493: l_Line_Tbl_Type(1).task_id := x_product_txn_rec.task_id;
3494: else
3495: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PROJECT_UPDATE');
3496: FND_MESSAGE.SET_TOKEN('project_id',x_product_txn_rec.project_id);
3497: FND_MESSAGE.SET_TOKEN('ship_from_org_id',l_ship_from_org_id);
3498: FND_MSG_PUB.ADD;
3499: RAISE BOOK_ORDER;
3492: l_Line_Tbl_Type(1).project_id := x_product_txn_rec.project_id;
3493: l_Line_Tbl_Type(1).task_id := x_product_txn_rec.task_id;
3494: else
3495: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PROJECT_UPDATE');
3496: FND_MESSAGE.SET_TOKEN('project_id',x_product_txn_rec.project_id);
3497: FND_MESSAGE.SET_TOKEN('ship_from_org_id',l_ship_from_org_id);
3498: FND_MSG_PUB.ADD;
3499: RAISE BOOK_ORDER;
3500: end if;
3493: l_Line_Tbl_Type(1).task_id := x_product_txn_rec.task_id;
3494: else
3495: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PROJECT_UPDATE');
3496: FND_MESSAGE.SET_TOKEN('project_id',x_product_txn_rec.project_id);
3497: FND_MESSAGE.SET_TOKEN('ship_from_org_id',l_ship_from_org_id);
3498: FND_MSG_PUB.ADD;
3499: RAISE BOOK_ORDER;
3500: end if;
3501: end if;
3530: x_msg_data => x_msg_data
3531: );
3532:
3533: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3534: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_OM_PROCESS_LINE');
3535: FND_MSG_PUB.ADD;
3536: RAISE BOOK_ORDER;
3537: END IF;
3538: end if; -- order line is not null
3566: -- SET prod_txn_status = 'BOOKED',
3567: -- book_sales_order_flag = 'Y'
3568: -- WHERE product_transaction_id = x_product_txn_rec.PRODUCT_TRANSACTION_ID;
3569: -- IF SQL%NOTFOUND then
3570: -- FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PRD_TXN_UPDATE');
3571: -- FND_MESSAGE.SET_TOKEN('PRODUCT_TRANSACTION_ID',x_product_txn_rec.PRODUCT_TRANSACTION_ID);
3572: -- FND_MSG_PUB.ADD;
3573: -- RAISE BOOK_ORDER;
3574: -- END IF;
3567: -- book_sales_order_flag = 'Y'
3568: -- WHERE product_transaction_id = x_product_txn_rec.PRODUCT_TRANSACTION_ID;
3569: -- IF SQL%NOTFOUND then
3570: -- FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PRD_TXN_UPDATE');
3571: -- FND_MESSAGE.SET_TOKEN('PRODUCT_TRANSACTION_ID',x_product_txn_rec.PRODUCT_TRANSACTION_ID);
3572: -- FND_MSG_PUB.ADD;
3573: -- RAISE BOOK_ORDER;
3574: -- END IF;
3575:
3583: WHERE repair_line_id =
3584: x_product_txn_rec.REPAIR_LINE_ID;
3585: IF SQL%NOTFOUND
3586: THEN
3587: Fnd_Message.SET_NAME('CSD',
3588: 'CSD_ERR_REPAIRS_UPDATE');
3589: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3590: x_product_txn_rec.repair_line_id);
3591: Fnd_Msg_Pub.ADD;
3585: IF SQL%NOTFOUND
3586: THEN
3587: Fnd_Message.SET_NAME('CSD',
3588: 'CSD_ERR_REPAIRS_UPDATE');
3589: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3590: x_product_txn_rec.repair_line_id);
3591: Fnd_Msg_Pub.ADD;
3592: RAISE BOOK_ORDER;
3593: END IF;
3630: x_product_txn_rec.sub_inventory
3631: AND organization_id = l_ship_from_org_id;
3632: EXCEPTION
3633: WHEN NO_DATA_FOUND THEN
3634: Fnd_Message.SET_NAME('CSD',
3635: 'CSD_API_SUB_INV_MISSING');
3636: Fnd_Message.SET_TOKEN('SUB_INVENTORY',
3637: x_product_txn_rec.sub_inventory);
3638: Fnd_Msg_Pub.ADD;
3632: EXCEPTION
3633: WHEN NO_DATA_FOUND THEN
3634: Fnd_Message.SET_NAME('CSD',
3635: 'CSD_API_SUB_INV_MISSING');
3636: Fnd_Message.SET_TOKEN('SUB_INVENTORY',
3637: x_product_txn_rec.sub_inventory);
3638: Fnd_Msg_Pub.ADD;
3639: Debug(x_product_txn_rec.sub_inventory ||
3640: ':Subinventory does not exist',
3697: Debug('Calling reserve serial..', l_mod_name, 1);
3698: CSD_LOGISTICS_UTIL.Reserve_serial_number(l_serial_rsv_rec, x_return_status);
3699:
3700: if(x_return_status = FND_API.G_RET_STS_ERROR) THEN
3701: Fnd_Message.SET_NAME('CSD', 'CSD_SRL_RESERVE_FAILED');
3702: Fnd_Msg_Pub.ADD;
3703: RAISE RELEASE_ORDER;
3704: END IF;
3705:
3731: FROM wsh_picking_rules
3732: WHERE picking_rule_id = l_picking_rule_id;
3733: EXCEPTION
3734: WHEN NO_DATA_FOUND THEN
3735: Fnd_Message.SET_NAME('CSD',
3736: 'CSD_API_INV_PICKING_RULE_ID');
3737: Fnd_Message.SET_TOKEN('PICKING_RULE_ID',
3738: l_picking_rule_id);
3739: Fnd_Msg_Pub.ADD;
3733: EXCEPTION
3734: WHEN NO_DATA_FOUND THEN
3735: Fnd_Message.SET_NAME('CSD',
3736: 'CSD_API_INV_PICKING_RULE_ID');
3737: Fnd_Message.SET_TOKEN('PICKING_RULE_ID',
3738: l_picking_rule_id);
3739: Fnd_Msg_Pub.ADD;
3740: Debug(l_picking_rule_id ||
3741: ':Picking Rule does not exist ',
3822: WHERE product_transaction_id =
3823: x_product_txn_rec.PRODUCT_TRANSACTION_ID;
3824: IF SQL%NOTFOUND
3825: THEN
3826: Fnd_Message.SET_NAME('CSD',
3827: 'CSD_ERR_PRD_TXN_UPDATE');
3828: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',
3829: x_product_txn_rec.PRODUCT_TRANSACTION_ID);
3830: Fnd_Msg_Pub.ADD;
3824: IF SQL%NOTFOUND
3825: THEN
3826: Fnd_Message.SET_NAME('CSD',
3827: 'CSD_ERR_PRD_TXN_UPDATE');
3828: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',
3829: x_product_txn_rec.PRODUCT_TRANSACTION_ID);
3830: Fnd_Msg_Pub.ADD;
3831: RAISE RELEASE_ORDER;
3832: END IF;
3837: WHERE repair_line_id =
3838: x_product_txn_rec.REPAIR_LINE_ID;
3839: IF SQL%NOTFOUND
3840: THEN
3841: Fnd_Message.SET_NAME('CSD',
3842: 'CSD_ERR_REPAIRS_UPDATE');
3843: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3844: x_product_txn_rec.repair_line_id);
3845: Fnd_Msg_Pub.ADD;
3839: IF SQL%NOTFOUND
3840: THEN
3841: Fnd_Message.SET_NAME('CSD',
3842: 'CSD_ERR_REPAIRS_UPDATE');
3843: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3844: x_product_txn_rec.repair_line_id);
3845: Fnd_Msg_Pub.ADD;
3846: RAISE RELEASE_ORDER;
3847: END IF;
3857: WHERE product_transaction_id =
3858: x_product_txn_rec.PRODUCT_TRANSACTION_ID;
3859: IF SQL%NOTFOUND
3860: THEN
3861: Fnd_Message.SET_NAME('CSD',
3862: 'CSD_ERR_PRD_TXN_UPDATE');
3863: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',
3864: x_product_txn_rec.PRODUCT_TRANSACTION_ID);
3865: Fnd_Msg_Pub.ADD;
3859: IF SQL%NOTFOUND
3860: THEN
3861: Fnd_Message.SET_NAME('CSD',
3862: 'CSD_ERR_PRD_TXN_UPDATE');
3863: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',
3864: x_product_txn_rec.PRODUCT_TRANSACTION_ID);
3865: Fnd_Msg_Pub.ADD;
3866: RAISE RELEASE_ORDER;
3867: END IF;
3872: WHERE repair_line_id =
3873: x_product_txn_rec.REPAIR_LINE_ID;
3874: IF SQL%NOTFOUND
3875: THEN
3876: Fnd_Message.SET_NAME('CSD',
3877: 'CSD_ERR_REPAIRS_UPDATE');
3878: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3879: x_product_txn_rec.repair_line_id);
3880: Fnd_Msg_Pub.ADD;
3874: IF SQL%NOTFOUND
3875: THEN
3876: Fnd_Message.SET_NAME('CSD',
3877: 'CSD_ERR_REPAIRS_UPDATE');
3878: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3879: x_product_txn_rec.repair_line_id);
3880: Fnd_Msg_Pub.ADD;
3881: RAISE RELEASE_ORDER;
3882: END IF;
3963: WHERE product_transaction_id =
3964: x_product_txn_rec.PRODUCT_TRANSACTION_ID;
3965: IF SQL%NOTFOUND
3966: THEN
3967: Fnd_Message.SET_NAME('CSD',
3968: 'CSD_ERR_PRD_TXN_UPDATE');
3969: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',
3970: x_product_txn_rec.PRODUCT_TRANSACTION_ID);
3971: Fnd_Msg_Pub.ADD;
3965: IF SQL%NOTFOUND
3966: THEN
3967: Fnd_Message.SET_NAME('CSD',
3968: 'CSD_ERR_PRD_TXN_UPDATE');
3969: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',
3970: x_product_txn_rec.PRODUCT_TRANSACTION_ID);
3971: Fnd_Msg_Pub.ADD;
3972: RAISE SHIP_ORDER;
3973: END IF;
3978: WHERE repair_line_id =
3979: x_product_txn_rec.REPAIR_LINE_ID;
3980: IF SQL%NOTFOUND
3981: THEN
3982: Fnd_Message.SET_NAME('CSD',
3983: 'CSD_ERR_REPAIRS_UPDATE');
3984: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3985: x_product_txn_rec.repair_line_id);
3986: Fnd_Msg_Pub.ADD;
3980: IF SQL%NOTFOUND
3981: THEN
3982: Fnd_Message.SET_NAME('CSD',
3983: 'CSD_ERR_REPAIRS_UPDATE');
3984: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3985: x_product_txn_rec.repair_line_id);
3986: Fnd_Msg_Pub.ADD;
3987: RAISE SHIP_ORDER;
3988: END IF;
4332: WHERE lookup_type = 'CSD_PRODUCT_TXN_STATUS'
4333: AND lookup_code = x_product_txn_rec.PROD_TXN_STATUS;
4334: EXCEPTION
4335: WHEN OTHERS THEN
4336: Fnd_Message.SET_NAME('CSD', 'CSD_ERR_PROD_TXN_STATUS');
4337: Fnd_Msg_Pub.ADD;
4338: RAISE Fnd_Api.G_EXC_ERROR;
4339: END;
4340: END IF;
4347: FROM csd_repairs
4348: WHERE repair_line_id = x_product_txn_rec.repair_line_id;
4349: EXCEPTION
4350: WHEN OTHERS THEN
4351: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');
4352: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
4353: x_product_txn_rec.repair_line_id);
4354: Fnd_Msg_Pub.ADD;
4355: RAISE Fnd_Api.G_EXC_ERROR;
4348: WHERE repair_line_id = x_product_txn_rec.repair_line_id;
4349: EXCEPTION
4350: WHEN OTHERS THEN
4351: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');
4352: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
4353: x_product_txn_rec.repair_line_id);
4354: Fnd_Msg_Pub.ADD;
4355: RAISE Fnd_Api.G_EXC_ERROR;
4356: END;
4400: FETCH get_account_details
4401: INTO l_party_id, l_account_id;
4402: IF (get_account_details%NOTFOUND OR l_party_id IS NULL)
4403: THEN
4404: Fnd_Message.SET_NAME('CSD', 'CSD_API_PARTY_MISSING');
4405: Fnd_Message.SET_TOKEN('INCIDENT_ID', l_incident_id);
4406: Fnd_Msg_Pub.ADD;
4407: RAISE Fnd_Api.G_EXC_ERROR;
4408: END IF;
4401: INTO l_party_id, l_account_id;
4402: IF (get_account_details%NOTFOUND OR l_party_id IS NULL)
4403: THEN
4404: Fnd_Message.SET_NAME('CSD', 'CSD_API_PARTY_MISSING');
4405: Fnd_Message.SET_TOKEN('INCIDENT_ID', l_incident_id);
4406: Fnd_Msg_Pub.ADD;
4407: RAISE Fnd_Api.G_EXC_ERROR;
4408: END IF;
4409: IF get_account_details%ISOPEN
4450: -- If line_type_id Or line_category_code is null
4451: -- then raise error
4452: IF (l_line_type_id IS NULL OR l_line_category_code IS NULL)
4453: THEN
4454: Fnd_Message.SET_NAME('CSD', 'CSD_API_LINE_TYPE_MISSING');
4455: Fnd_Message.SET_TOKEN('TXN_BILLING_TYPE_ID',
4456: x_product_txn_rec.txn_billing_type_id);
4457: Fnd_Msg_Pub.ADD;
4458: RAISE Fnd_Api.G_EXC_ERROR;
4451: -- then raise error
4452: IF (l_line_type_id IS NULL OR l_line_category_code IS NULL)
4453: THEN
4454: Fnd_Message.SET_NAME('CSD', 'CSD_API_LINE_TYPE_MISSING');
4455: Fnd_Message.SET_TOKEN('TXN_BILLING_TYPE_ID',
4456: x_product_txn_rec.txn_billing_type_id);
4457: Fnd_Msg_Pub.ADD;
4458: RAISE Fnd_Api.G_EXC_ERROR;
4459: END IF;
4468: FROM oe_price_lists
4469: WHERE price_list_id = x_product_txn_rec.price_list_id;
4470: EXCEPTION
4471: WHEN NO_DATA_FOUND THEN
4472: Fnd_Message.SET_NAME('CSD',
4473: 'CSD_API_INV_PRICE_LIST_ID');
4474: Fnd_Message.SET_TOKEN('PRICE_LIST_ID',
4475: x_product_txn_rec.price_list_id);
4476: Fnd_Msg_Pub.ADD;
4470: EXCEPTION
4471: WHEN NO_DATA_FOUND THEN
4472: Fnd_Message.SET_NAME('CSD',
4473: 'CSD_API_INV_PRICE_LIST_ID');
4474: Fnd_Message.SET_TOKEN('PRICE_LIST_ID',
4475: x_product_txn_rec.price_list_id);
4476: Fnd_Msg_Pub.ADD;
4477: RAISE Fnd_Api.G_EXC_ERROR;
4478: WHEN TOO_MANY_ROWS THEN
4491:
4492: -- If l_curr_code is null then raise error
4493: IF l_curr_code IS NULL
4494: THEN
4495: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_CURR_CODE');
4496: Fnd_Message.SET_TOKEN('PRICE_LIST_ID',
4497: x_product_txn_rec.price_list_id);
4498: Fnd_Msg_Pub.ADD;
4499: RAISE Fnd_Api.G_EXC_ERROR;
4492: -- If l_curr_code is null then raise error
4493: IF l_curr_code IS NULL
4494: THEN
4495: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_CURR_CODE');
4496: Fnd_Message.SET_TOKEN('PRICE_LIST_ID',
4497: x_product_txn_rec.price_list_id);
4498: Fnd_Msg_Pub.ADD;
4499: RAISE Fnd_Api.G_EXC_ERROR;
4500: END IF;
4516: x_product_txn_rec.action_type NOT IN ('SHIP') AND
4517: (x_product_txn_rec.action_code <> 'LOANER' AND
4518: x_product_txn_rec.action_type <>'RMA')
4519: THEN
4520: Fnd_Message.SET_NAME('CSD', 'CSD_API_SERIAL_NUM_MISSING');
4521: Fnd_Message.SET_TOKEN('INVENTORY_ITEM_ID',
4522: x_product_txn_rec.inventory_item_id);
4523: Fnd_Msg_Pub.ADD;
4524: IF (g_debug > 0)
4517: (x_product_txn_rec.action_code <> 'LOANER' AND
4518: x_product_txn_rec.action_type <>'RMA')
4519: THEN
4520: Fnd_Message.SET_NAME('CSD', 'CSD_API_SERIAL_NUM_MISSING');
4521: Fnd_Message.SET_TOKEN('INVENTORY_ITEM_ID',
4522: x_product_txn_rec.inventory_item_id);
4523: Fnd_Msg_Pub.ADD;
4524: IF (g_debug > 0)
4525: THEN
4604: SET ro_txn_status = 'OM_SUBMITTED'
4605: WHERE repair_line_id = x_product_txn_rec.REPAIR_LINE_ID;
4606: IF SQL%NOTFOUND
4607: THEN
4608: Fnd_Message.SET_NAME('CSD', 'CSD_ERR_REPAIRS_UPDATE');
4609: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
4610: x_product_txn_rec.repair_line_id);
4611: Fnd_Msg_Pub.ADD;
4612: RAISE Fnd_Api.G_EXC_ERROR;
4605: WHERE repair_line_id = x_product_txn_rec.REPAIR_LINE_ID;
4606: IF SQL%NOTFOUND
4607: THEN
4608: Fnd_Message.SET_NAME('CSD', 'CSD_ERR_REPAIRS_UPDATE');
4609: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
4610: x_product_txn_rec.repair_line_id);
4611: Fnd_Msg_Pub.ADD;
4612: RAISE Fnd_Api.G_EXC_ERROR;
4613: END IF;
4850: p_org_id => l_ship_from_org_id,
4851: p_sub_inv => x_product_txn_rec.sub_inventory,
4852: p_inventory_item_id => x_product_txn_rec.inventory_item_id,
4853: p_serial_number => x_product_txn_rec.source_serial_number ) then
4854: fnd_message.set_name('CSD','CSD_NEG_INV_IN_SHIP');
4855: fnd_message.set_token('SUBINV',x_product_txn_rec.sub_inventory);
4856: fnd_msg_pub.add;
4857: RAISE RELEASE_ORDER;
4858: end if;
4851: p_sub_inv => x_product_txn_rec.sub_inventory,
4852: p_inventory_item_id => x_product_txn_rec.inventory_item_id,
4853: p_serial_number => x_product_txn_rec.source_serial_number ) then
4854: fnd_message.set_name('CSD','CSD_NEG_INV_IN_SHIP');
4855: fnd_message.set_token('SUBINV',x_product_txn_rec.sub_inventory);
4856: fnd_msg_pub.add;
4857: RAISE RELEASE_ORDER;
4858: end if;
4859: end if;
4862: if CSD_PROCESS_UTIL.validate_order_for_holds
4863: ( p_action_type => 'SHIP',
4864: p_order_header_id => l_order_header_id,
4865: p_order_line_id => x_product_txn_rec.order_line_id ) then
4866: fnd_message.set_name('CSD','CSD_OM_ORDER_ON_HOLD');
4867: fnd_message.set_token('ACTION','Shipping');
4868: fnd_message.set_token('ORDER_NUM',x_product_txn_rec.order_number);
4869: fnd_msg_pub.add;
4870: RAISE RELEASE_ORDER;
4863: ( p_action_type => 'SHIP',
4864: p_order_header_id => l_order_header_id,
4865: p_order_line_id => x_product_txn_rec.order_line_id ) then
4866: fnd_message.set_name('CSD','CSD_OM_ORDER_ON_HOLD');
4867: fnd_message.set_token('ACTION','Shipping');
4868: fnd_message.set_token('ORDER_NUM',x_product_txn_rec.order_number);
4869: fnd_msg_pub.add;
4870: RAISE RELEASE_ORDER;
4871: end if;
4864: p_order_header_id => l_order_header_id,
4865: p_order_line_id => x_product_txn_rec.order_line_id ) then
4866: fnd_message.set_name('CSD','CSD_OM_ORDER_ON_HOLD');
4867: fnd_message.set_token('ACTION','Shipping');
4868: fnd_message.set_token('ORDER_NUM',x_product_txn_rec.order_number);
4869: fnd_msg_pub.add;
4870: RAISE RELEASE_ORDER;
4871: end if;
4872: -- end bug fix #7355526, nnadig
5120: l_delete_allow := 'Y';
5121: EXCEPTION
5122: WHEN NO_DATA_FOUND THEN
5123: l_delete_allow := 'N';
5124: Fnd_Message.SET_NAME('CSD', 'CSD_API_DELETE_NOT_ALLOWED');
5125: --FND_MESSAGE.SET_TOKEN('PRODUCT_TXN_ID',p_product_txn_id);
5126: Fnd_Msg_Pub.ADD;
5127: IF (g_debug > 0)
5128: THEN
5121: EXCEPTION
5122: WHEN NO_DATA_FOUND THEN
5123: l_delete_allow := 'N';
5124: Fnd_Message.SET_NAME('CSD', 'CSD_API_DELETE_NOT_ALLOWED');
5125: --FND_MESSAGE.SET_TOKEN('PRODUCT_TXN_ID',p_product_txn_id);
5126: Fnd_Msg_Pub.ADD;
5127: IF (g_debug > 0)
5128: THEN
5129: Csd_Gen_Utility_Pvt.ADD('Product txn is interfaced,so it cannot be deleted');
5430:
5431: -- Api body ends here
5432: IF l_msg_text IS NOT NULL
5433: THEN
5434: Fnd_Message.SET_NAME('CSD', 'CSD_API_OM_ERR_MSG');
5435: Fnd_Message.SET_TOKEN('MSG_DATA', l_msg_text);
5436: Fnd_Msg_Pub.ADD;
5437: END IF;
5438:
5431: -- Api body ends here
5432: IF l_msg_text IS NOT NULL
5433: THEN
5434: Fnd_Message.SET_NAME('CSD', 'CSD_API_OM_ERR_MSG');
5435: Fnd_Message.SET_TOKEN('MSG_DATA', l_msg_text);
5436: Fnd_Msg_Pub.ADD;
5437: END IF;
5438:
5439: -- Standard check of p_commit.
7478: X_Msg_Data => l_msg_data);
7479:
7480: IF (l_return_status <> 'S')
7481: THEN
7482: Fnd_Message.SET_NAME('CSD',
7483: 'CSD_API_RO_STAT_UPD_FAIL');
7484: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
7485: ro.repair_line_id);
7486: Fnd_Msg_Pub.ADD;
7480: IF (l_return_status <> 'S')
7481: THEN
7482: Fnd_Message.SET_NAME('CSD',
7483: 'CSD_API_RO_STAT_UPD_FAIL');
7484: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
7485: ro.repair_line_id);
7486: Fnd_Msg_Pub.ADD;
7487: RAISE Fnd_Api.G_EXC_ERROR;
7488: END IF;
7520: x_msg_data => l_msg_data);
7521:
7522: IF (l_return_status <> 'S')
7523: THEN
7524: Fnd_Message.SET_NAME('CSD',
7525: 'CSD_API_GRP_STAT_UPD_FAIL');
7526: Fnd_Message.SET_TOKEN('REPAIR_GROUP_ID',
7527: grp.repair_group_id);
7528: Fnd_Msg_Pub.ADD;
7522: IF (l_return_status <> 'S')
7523: THEN
7524: Fnd_Message.SET_NAME('CSD',
7525: 'CSD_API_GRP_STAT_UPD_FAIL');
7526: Fnd_Message.SET_TOKEN('REPAIR_GROUP_ID',
7527: grp.repair_group_id);
7528: Fnd_Msg_Pub.ADD;
7529: RAISE Fnd_Api.G_EXC_ERROR;
7530: END IF;
7572: X_Msg_Data => l_msg_data);
7573:
7574: IF (l_return_status <> 'S')
7575: THEN
7576: Fnd_Message.SET_NAME('CSD',
7577: 'CSD_API_RO_STAT_UPD_FAIL');
7578: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
7579: ro.repair_line_id);
7580: Fnd_Msg_Pub.ADD;
7574: IF (l_return_status <> 'S')
7575: THEN
7576: Fnd_Message.SET_NAME('CSD',
7577: 'CSD_API_RO_STAT_UPD_FAIL');
7578: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
7579: ro.repair_line_id);
7580: Fnd_Msg_Pub.ADD;
7581: RAISE Fnd_Api.G_EXC_ERROR;
7582: END IF;
7615: x_msg_data => l_msg_data);
7616:
7617: IF (l_return_status <> 'S')
7618: THEN
7619: Fnd_Message.SET_NAME('CSD',
7620: 'CSD_API_GRP_STAT_UPD_FAIL');
7621: Fnd_Message.SET_TOKEN('REPAIR_GROUP_ID',
7622: grp.repair_group_id);
7623: Fnd_Msg_Pub.ADD;
7617: IF (l_return_status <> 'S')
7618: THEN
7619: Fnd_Message.SET_NAME('CSD',
7620: 'CSD_API_GRP_STAT_UPD_FAIL');
7621: Fnd_Message.SET_TOKEN('REPAIR_GROUP_ID',
7622: grp.repair_group_id);
7623: Fnd_Msg_Pub.ADD;
7624: RAISE Fnd_Api.G_EXC_ERROR;
7625: END IF;
7730: x_interaction_id => l_interaction_id);
7731:
7732: IF (l_return_status <> 'S')
7733: THEN
7734: Fnd_Message.SET_NAME('CSD',
7735: 'CSD_API_SR_STAT_UPD_FAIL');
7736: Fnd_Message.SET_TOKEN('INCIDENT_ID', p_incident_id);
7737: Fnd_Msg_Pub.ADD;
7738: RAISE Fnd_Api.G_EXC_ERROR;
7732: IF (l_return_status <> 'S')
7733: THEN
7734: Fnd_Message.SET_NAME('CSD',
7735: 'CSD_API_SR_STAT_UPD_FAIL');
7736: Fnd_Message.SET_TOKEN('INCIDENT_ID', p_incident_id);
7737: Fnd_Msg_Pub.ADD;
7738: RAISE Fnd_Api.G_EXC_ERROR;
7739: END IF;
7740:
7790: X_Msg_Data => l_msg_data);
7791:
7792: IF (l_return_status <> 'S')
7793: THEN
7794: Fnd_Message.SET_NAME('CSD', 'CSD_API_RO_STAT_UPD_FAIL');
7795: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID', p_repair_line_id);
7796: Fnd_Msg_Pub.ADD;
7797: RAISE Fnd_Api.G_EXC_ERROR;
7798: END IF;
7791:
7792: IF (l_return_status <> 'S')
7793: THEN
7794: Fnd_Message.SET_NAME('CSD', 'CSD_API_RO_STAT_UPD_FAIL');
7795: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID', p_repair_line_id);
7796: Fnd_Msg_Pub.ADD;
7797: RAISE Fnd_Api.G_EXC_ERROR;
7798: END IF;
7799:
7853: x_msg_data => l_msg_data);
7854:
7855: IF (l_return_status <> 'S')
7856: THEN
7857: Fnd_Message.SET_NAME('CSD',
7858: 'CSD_API_GRP_STAT_UPD_FAIL');
7859: Fnd_Message.SET_TOKEN('REPAIR_GROUP_ID',
7860: l_repair_group_id);
7861: Fnd_Msg_Pub.ADD;
7855: IF (l_return_status <> 'S')
7856: THEN
7857: Fnd_Message.SET_NAME('CSD',
7858: 'CSD_API_GRP_STAT_UPD_FAIL');
7859: Fnd_Message.SET_TOKEN('REPAIR_GROUP_ID',
7860: l_repair_group_id);
7861: Fnd_Msg_Pub.ADD;
7862: RAISE Fnd_Api.G_EXC_ERROR;
7863: END IF;
7966: x_interaction_id => l_interaction_id);
7967:
7968: IF (l_return_status <> 'S')
7969: THEN
7970: Fnd_Message.SET_NAME('CSD',
7971: 'CSD_API_SR_STAT_UPD_FAIL');
7972: Fnd_Message.SET_TOKEN('INCIDENT_ID', l_incident_id);
7973: Fnd_Msg_Pub.ADD;
7974: --Bug fix for 3555256 Begin
7968: IF (l_return_status <> 'S')
7969: THEN
7970: Fnd_Message.SET_NAME('CSD',
7971: 'CSD_API_SR_STAT_UPD_FAIL');
7972: Fnd_Message.SET_TOKEN('INCIDENT_ID', l_incident_id);
7973: Fnd_Msg_Pub.ADD;
7974: --Bug fix for 3555256 Begin
7975: --RAISE FND_API.G_EXC_ERROR;
7976: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,
8487: x_product_txn_rec.prod_txn_status);
8488: END IF;
8489: EXCEPTION
8490: WHEN NO_DATA_FOUND THEN
8491: Fnd_Message.set_name('CSD', 'CSD_ERR_PROD_TXN_STATUS');
8492: IF l_exception_level >= l_debug_level
8493: THEN
8494: Fnd_Log.string(l_exception_level,
8495: l_module_name ||
8575: FROM csd_repairs
8576: WHERE repair_line_id = l_repair_line_id;
8577: EXCEPTION
8578: WHEN NO_DATA_FOUND THEN
8579: Fnd_Message.set_name('CSD', 'CSD_API_INV_REP_LINE_ID');
8580: Fnd_Message.set_token('REPAIR_LINE_ID',
8581: l_repair_line_id);
8582: Fnd_Msg_Pub.ADD;
8583: IF l_statement_level >= l_debug_level
8576: WHERE repair_line_id = l_repair_line_id;
8577: EXCEPTION
8578: WHEN NO_DATA_FOUND THEN
8579: Fnd_Message.set_name('CSD', 'CSD_API_INV_REP_LINE_ID');
8580: Fnd_Message.set_token('REPAIR_LINE_ID',
8581: l_repair_line_id);
8582: Fnd_Msg_Pub.ADD;
8583: IF l_statement_level >= l_debug_level
8584: THEN
8596: FETCH sr_rec
8597: INTO l_party_id, l_account_id;
8598: CLOSE sr_rec;
8599: ELSE
8600: Fnd_Message.set_name('CSD', 'CSD_API_INV_SR_ID');
8601: Fnd_Message.set_token('INCIDENT_ID', l_incident_id);
8602: Fnd_Msg_Pub.ADD;
8603: IF (g_debug > 0)
8604: THEN
8597: INTO l_party_id, l_account_id;
8598: CLOSE sr_rec;
8599: ELSE
8600: Fnd_Message.set_name('CSD', 'CSD_API_INV_SR_ID');
8601: Fnd_Message.set_token('INCIDENT_ID', l_incident_id);
8602: Fnd_Msg_Pub.ADD;
8603: IF (g_debug > 0)
8604: THEN
8605: Csd_Gen_Utility_Pvt.ADD('incident id missing ');
8669: NVL(end_date_active, SYSDATE + 1);
8670: l_order_rec.picking_rule_id := l_picking_rule_id;
8671: EXCEPTION
8672: WHEN NO_DATA_FOUND THEN
8673: Fnd_Message.set_name('CSD',
8674: 'CSD_API_INV_PICKING_RULE_ID');
8675: Fnd_Message.set_token('PICKING_RULE_ID',
8676: l_picking_rule_id);
8677: Fnd_Msg_Pub.ADD;
8671: EXCEPTION
8672: WHEN NO_DATA_FOUND THEN
8673: Fnd_Message.set_name('CSD',
8674: 'CSD_API_INV_PICKING_RULE_ID');
8675: Fnd_Message.set_token('PICKING_RULE_ID',
8676: l_picking_rule_id);
8677: Fnd_Msg_Pub.ADD;
8678: IF l_exception_level >= l_debug_level
8679: THEN
8835: Last_Updated_By = Fnd_Global.User_Id,
8836: Last_Update_login = Fnd_Global.Login_Id
8837: where repair_line_id = x_product_txn_rec.repair_line_id;
8838: if sql%notfound then
8839: fnd_message.set_name('CSD','CSD_ERR_REPAIRS_UPDATE');
8840: fnd_message.set_token('REPAIR_LINE_ID',x_product_txn_rec.repair_line_id);
8841: fnd_msg_pub.add;
8842: raise release_order_excep;
8843: end if;
8836: Last_Update_login = Fnd_Global.Login_Id
8837: where repair_line_id = x_product_txn_rec.repair_line_id;
8838: if sql%notfound then
8839: fnd_message.set_name('CSD','CSD_ERR_REPAIRS_UPDATE');
8840: fnd_message.set_token('REPAIR_LINE_ID',x_product_txn_rec.repair_line_id);
8841: fnd_msg_pub.add;
8842: raise release_order_excep;
8843: end if;
8844: ********************************/
8893: AND SOURCE_CODE = 'OE'; /*Fixed for bug#5840654 */
8894: EXCEPTION
8895: WHEN NO_DATA_FOUND THEN
8896: l_allow_ship := C_No;
8897: -- fnd_message.set_name('csd','csd_release_failed');
8898: Fnd_Message.set_name('CSD',
8899: 'CSD_ORDER_LINE_NOT_SHIPABLE');
8900: Fnd_Message.set_token('ORDER_LINE_ID',
8901: l_order_rec.order_line_id);
8894: EXCEPTION
8895: WHEN NO_DATA_FOUND THEN
8896: l_allow_ship := C_No;
8897: -- fnd_message.set_name('csd','csd_release_failed');
8898: Fnd_Message.set_name('CSD',
8899: 'CSD_ORDER_LINE_NOT_SHIPABLE');
8900: Fnd_Message.set_token('ORDER_LINE_ID',
8901: l_order_rec.order_line_id);
8902: Fnd_Msg_Pub.ADD;
8896: l_allow_ship := C_No;
8897: -- fnd_message.set_name('csd','csd_release_failed');
8898: Fnd_Message.set_name('CSD',
8899: 'CSD_ORDER_LINE_NOT_SHIPABLE');
8900: Fnd_Message.set_token('ORDER_LINE_ID',
8901: l_order_rec.order_line_id);
8902: Fnd_Msg_Pub.ADD;
8903: IF l_statement_level >= l_debug_level
8904: THEN
8909: ' is not eligible for shipping.');
8910: END IF;
8911: RAISE ship_order_excep;
8912: WHEN TOO_MANY_ROWS THEN
8913: Fnd_Message.set_name('CSD',
8914: 'CSD_TOO_MANY_ROWS_SHIPABLE');
8915: Fnd_Message.set_token('ORDER_LINE_ID',
8916: l_order_rec.order_line_id);
8917: Fnd_Msg_Pub.ADD;
8911: RAISE ship_order_excep;
8912: WHEN TOO_MANY_ROWS THEN
8913: Fnd_Message.set_name('CSD',
8914: 'CSD_TOO_MANY_ROWS_SHIPABLE');
8915: Fnd_Message.set_token('ORDER_LINE_ID',
8916: l_order_rec.order_line_id);
8917: Fnd_Msg_Pub.ADD;
8918: IF l_statement_level >= l_debug_level
8919: THEN
9025: Last_Updated_By = Fnd_Global.User_Id,
9026: Last_Update_login = Fnd_Global.Login_Id
9027: Where repair_line_id = x_product_txn_rec.repair_line_id;
9028: If sql%notfound then
9029: fnd_message.set_name('CSD','CSD_ERR_REPAIRS_UPDATE');
9030: fnd_message.set_token('REPAIR_LINE_ID',x_product_txn_rec.repair_line_id);
9031: fnd_msg_pub.add;
9032: Raise release_order_excep;
9033: End if;
9026: Last_Update_login = Fnd_Global.Login_Id
9027: Where repair_line_id = x_product_txn_rec.repair_line_id;
9028: If sql%notfound then
9029: fnd_message.set_name('CSD','CSD_ERR_REPAIRS_UPDATE');
9030: fnd_message.set_token('REPAIR_LINE_ID',x_product_txn_rec.repair_line_id);
9031: fnd_msg_pub.add;
9032: Raise release_order_excep;
9033: End if;
9034: *****************/
9230: -- Display message: Repair Order is in status || l_RO_Status. Default product transaction lines are
9231: -- not created.
9232: -- Message Code CSD_RO_NOT_OPEN_NO_PRODTXN_LINES
9233: -- Raise Error message
9234: Fnd_Message.SET_NAME('CSD',
9235: 'CSD_RO_NOT_OPEN_NO_PRODTXN_LNS');
9236: Fnd_Message.SET_TOKEN('RO_NUMBER', l_RO_Number);
9237: Fnd_Message.SET_TOKEN('RO_STATUS', l_RO_Status_Meaning);
9238: Fnd_Msg_Pub.ADD;
9232: -- Message Code CSD_RO_NOT_OPEN_NO_PRODTXN_LINES
9233: -- Raise Error message
9234: Fnd_Message.SET_NAME('CSD',
9235: 'CSD_RO_NOT_OPEN_NO_PRODTXN_LNS');
9236: Fnd_Message.SET_TOKEN('RO_NUMBER', l_RO_Number);
9237: Fnd_Message.SET_TOKEN('RO_STATUS', l_RO_Status_Meaning);
9238: Fnd_Msg_Pub.ADD;
9239: RAISE Fnd_Api.G_EXC_ERROR;
9240: END IF;
9233: -- Raise Error message
9234: Fnd_Message.SET_NAME('CSD',
9235: 'CSD_RO_NOT_OPEN_NO_PRODTXN_LNS');
9236: Fnd_Message.SET_TOKEN('RO_NUMBER', l_RO_Number);
9237: Fnd_Message.SET_TOKEN('RO_STATUS', l_RO_Status_Meaning);
9238: Fnd_Msg_Pub.ADD;
9239: RAISE Fnd_Api.G_EXC_ERROR;
9240: END IF;
9241: -- Check if repair Type Ref is Standard
9242: IF l_RO_Repair_Type_Ref = C_Repair_TYpe_Ref_Standard
9243: THEN
9244: -- Display message: Default product transaction lines are not created for standard repair type ref
9245: -- CSD_STD_REP_TYPE_NO_PRODUCTXN_LINES
9246: Fnd_Message.SET_NAME('CSD',
9247: 'CSD_STD_REPTYPE_NO_PRODTXN_LNS');
9248: Fnd_Message.SET_TOKEN('RO_NUMBER', l_RO_Number);
9249: Fnd_Msg_Pub.ADD;
9250: RAISE Fnd_Api.G_EXC_ERROR;
9244: -- Display message: Default product transaction lines are not created for standard repair type ref
9245: -- CSD_STD_REP_TYPE_NO_PRODUCTXN_LINES
9246: Fnd_Message.SET_NAME('CSD',
9247: 'CSD_STD_REPTYPE_NO_PRODTXN_LNS');
9248: Fnd_Message.SET_TOKEN('RO_NUMBER', l_RO_Number);
9249: Fnd_Msg_Pub.ADD;
9250: RAISE Fnd_Api.G_EXC_ERROR;
9251: END IF;
9252: -- Check Serial control code if quantity is greater then 1
9263: THEN
9264: -- Display Message: RO quantity can not be greater then for serial controlled items.
9265: -- CSD_RO_QTY_MORE_FOR_SERIAL_ITEM
9266: -- Raise G_Exc_Error,
9267: Fnd_Message.SET_NAME('CSD',
9268: 'CSD_RO_QTY_MORE_FOR_SRLCT_ITEM');
9269: Fnd_Msg_Pub.ADD;
9270: RAISE Fnd_Api.G_EXC_ERROR;
9271: END IF;
9285: FROM Hr_Organization_Units
9286: WHERE Organization_id =
9287: Cs_Std.Get_Item_Valdn_Orgzn_Id;
9288:
9289: Fnd_Message.SET_NAME('CSD',
9290: 'CSD_NO_ITEM_FOR_SRV_VALDN_ORG');
9291: Fnd_Message.Set_Token('ITEM', l_Item_Name);
9292: Fnd_Message.Set_Token('ORG_NAME',
9293: l_Service_Valdn_Org_Name);
9287: Cs_Std.Get_Item_Valdn_Orgzn_Id;
9288:
9289: Fnd_Message.SET_NAME('CSD',
9290: 'CSD_NO_ITEM_FOR_SRV_VALDN_ORG');
9291: Fnd_Message.Set_Token('ITEM', l_Item_Name);
9292: Fnd_Message.Set_Token('ORG_NAME',
9293: l_Service_Valdn_Org_Name);
9294: Fnd_Msg_Pub.ADD;
9295: RAISE Fnd_Api.G_EXC_ERROR;
9288:
9289: Fnd_Message.SET_NAME('CSD',
9290: 'CSD_NO_ITEM_FOR_SRV_VALDN_ORG');
9291: Fnd_Message.Set_Token('ITEM', l_Item_Name);
9292: Fnd_Message.Set_Token('ORG_NAME',
9293: l_Service_Valdn_Org_Name);
9294: Fnd_Msg_Pub.ADD;
9295: RAISE Fnd_Api.G_EXC_ERROR;
9296:
9307: -- Default product transaction lines are not created as product transaction lines exist
9308: -- for Repair Order : l_RO_number
9309: -- CSD_RO_HAS_PRODTXN_LINES
9310: -- RAise G_Exc_Error
9311: Fnd_Message.SET_NAME('CSD',
9312: 'CSD_RO_HAS_PRODUCT_TXN_LINES');
9313: Fnd_Message.SET_TOKEN('RO_NUMBER', l_RO_Number);
9314: Fnd_Msg_Pub.ADD;
9315: RAISE Fnd_Api.G_EXC_ERROR;
9309: -- CSD_RO_HAS_PRODTXN_LINES
9310: -- RAise G_Exc_Error
9311: Fnd_Message.SET_NAME('CSD',
9312: 'CSD_RO_HAS_PRODUCT_TXN_LINES');
9313: Fnd_Message.SET_TOKEN('RO_NUMBER', l_RO_Number);
9314: Fnd_Msg_Pub.ADD;
9315: RAISE Fnd_Api.G_EXC_ERROR;
9316: END IF;
9317: END;
9318: EXCEPTION
9319: WHEN NO_DATA_FOUND THEN
9320: -- Message Code CSD_REPAIR_LINE_ID_INVALID
9321: -- Display message; Invalid repair line id is passed
9322: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');
9323: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID', P_Repair_Line_ID);
9324: Fnd_Msg_Pub.ADD;
9325: RAISE Fnd_Api.G_EXC_ERROR;
9326: END;
9319: WHEN NO_DATA_FOUND THEN
9320: -- Message Code CSD_REPAIR_LINE_ID_INVALID
9321: -- Display message; Invalid repair line id is passed
9322: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');
9323: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID', P_Repair_Line_ID);
9324: Fnd_Msg_Pub.ADD;
9325: RAISE Fnd_Api.G_EXC_ERROR;
9326: END;
9327: -- Now call Default Product Txn lines API