DBA Data[Home] [Help]

APPS.CSD_PROCESS_PVT dependencies on FND_MESSAGE

Line 925: Fnd_Message.SET_NAME('CSD', 'CSD_INV_DELIVERY_ID');

921: END IF;
922:
923: IF NVL(p_delivery_id, Fnd_Api.G_MISS_NUM) = Fnd_Api.G_MISS_NUM
924: THEN
925: Fnd_Message.SET_NAME('CSD', 'CSD_INV_DELIVERY_ID');
926: Fnd_Message.SET_TOKEN('DELIVERY_ID', p_delivery_id);
927: Fnd_Msg_Pub.ADD;
928: IF (g_debug > 0)
929: THEN

Line 926: Fnd_Message.SET_TOKEN('DELIVERY_ID', p_delivery_id);

922:
923: IF NVL(p_delivery_id, Fnd_Api.G_MISS_NUM) = Fnd_Api.G_MISS_NUM
924: THEN
925: Fnd_Message.SET_NAME('CSD', 'CSD_INV_DELIVERY_ID');
926: Fnd_Message.SET_TOKEN('DELIVERY_ID', p_delivery_id);
927: Fnd_Msg_Pub.ADD;
928: IF (g_debug > 0)
929: THEN
930: Csd_Gen_Utility_Pvt.ADD('Delivery_id is invalid');

Line 942: Fnd_Message.SET_NAME('CSD', 'CSD_INV_DELIVERY_ID');

938: FROM wsh_new_deliveries
939: WHERE delivery_id = p_delivery_id;
940: EXCEPTION
941: WHEN NO_DATA_FOUND THEN
942: Fnd_Message.SET_NAME('CSD', 'CSD_INV_DELIVERY_ID');
943: Fnd_Message.SET_TOKEN('DELIVERY_ID', p_delivery_id);
944: Fnd_Msg_Pub.ADD;
945: IF (g_debug > 0)
946: THEN

Line 943: Fnd_Message.SET_TOKEN('DELIVERY_ID', p_delivery_id);

939: WHERE delivery_id = p_delivery_id;
940: EXCEPTION
941: WHEN NO_DATA_FOUND THEN
942: Fnd_Message.SET_NAME('CSD', 'CSD_INV_DELIVERY_ID');
943: Fnd_Message.SET_TOKEN('DELIVERY_ID', p_delivery_id);
944: Fnd_Msg_Pub.ADD;
945: IF (g_debug > 0)
946: THEN
947: Csd_Gen_Utility_Pvt.ADD('Delivery_id is invalid');

Line 1023: Fnd_Message.SET_NAME('CSD',

1019: Csd_Gen_Utility_Pvt.ADD('Error Msg from Update_Shipping_Attributes');
1020: Csd_Gen_Utility_Pvt.ADD('x_msg_data = ' ||
1021: x_msg_data);
1022: END IF;
1023: Fnd_Message.SET_NAME('CSD',
1024: 'CSD_UPDATE_SHIPPING_FAILED');
1025: Fnd_Message.SET_TOKEN('ERR_MSG', x_msg_data);
1026: Fnd_Msg_Pub.ADD;
1027: RAISE Fnd_Api.G_EXC_ERROR;

Line 1025: Fnd_Message.SET_TOKEN('ERR_MSG', x_msg_data);

1021: x_msg_data);
1022: END IF;
1023: Fnd_Message.SET_NAME('CSD',
1024: 'CSD_UPDATE_SHIPPING_FAILED');
1025: Fnd_Message.SET_TOKEN('ERR_MSG', x_msg_data);
1026: Fnd_Msg_Pub.ADD;
1027: RAISE Fnd_Api.G_EXC_ERROR;
1028: END;
1029:

Line 1130: Fnd_Message.SET_NAME('CSD', 'CSD_SHIP_CONFIRM_FAILED');

1126:
1127: -- Ignore if it is a warning
1128: IF (x_return_status <> Wsh_Util_Core.G_RET_STS_WARNING)
1129: THEN
1130: Fnd_Message.SET_NAME('CSD', 'CSD_SHIP_CONFIRM_FAILED');
1131: Fnd_Message.SET_TOKEN('ERR_MSG', x_msg_data);
1132: Fnd_Msg_Pub.ADD;
1133: RAISE Fnd_Api.G_EXC_ERROR;
1134: END IF;

Line 1131: Fnd_Message.SET_TOKEN('ERR_MSG', x_msg_data);

1127: -- Ignore if it is a warning
1128: IF (x_return_status <> Wsh_Util_Core.G_RET_STS_WARNING)
1129: THEN
1130: Fnd_Message.SET_NAME('CSD', 'CSD_SHIP_CONFIRM_FAILED');
1131: Fnd_Message.SET_TOKEN('ERR_MSG', x_msg_data);
1132: Fnd_Msg_Pub.ADD;
1133: RAISE Fnd_Api.G_EXC_ERROR;
1134: END IF;
1135:

Line 1523: Fnd_Message.SET_NAME('CSD', 'CSD_INV_ORDER_HEADER_ID');

1519:
1520: IF NVL(p_order_rec.order_header_id, Fnd_Api.G_MISS_NUM) =
1521: Fnd_Api.G_MISS_NUM
1522: THEN
1523: Fnd_Message.SET_NAME('CSD', 'CSD_INV_ORDER_HEADER_ID');
1524: Fnd_Message.SET_TOKEN('ORDER_HEADER_ID',
1525: p_order_rec.order_header_id);
1526: Fnd_Msg_Pub.ADD;
1527: Debug('Invalid Order header Id is passed ', l_mod_name, 1);

Line 1524: Fnd_Message.SET_TOKEN('ORDER_HEADER_ID',

1520: IF NVL(p_order_rec.order_header_id, Fnd_Api.G_MISS_NUM) =
1521: Fnd_Api.G_MISS_NUM
1522: THEN
1523: Fnd_Message.SET_NAME('CSD', 'CSD_INV_ORDER_HEADER_ID');
1524: Fnd_Message.SET_TOKEN('ORDER_HEADER_ID',
1525: p_order_rec.order_header_id);
1526: Fnd_Msg_Pub.ADD;
1527: Debug('Invalid Order header Id is passed ', l_mod_name, 1);
1528: RAISE Fnd_Api.G_EXC_ERROR;

Line 1534: Fnd_Message.SET_NAME('CSD', 'CSD_INV_PICKING_RULE_ID');

1530:
1531: IF NVL(p_order_rec.PICKING_RULE_ID, Fnd_Api.G_MISS_NUM) =
1532: Fnd_Api.G_MISS_NUM
1533: THEN
1534: Fnd_Message.SET_NAME('CSD', 'CSD_INV_PICKING_RULE_ID');
1535: Fnd_Message.SET_TOKEN('PICKING_RULE_ID',
1536: p_order_rec.PICKING_RULE_ID);
1537: Fnd_Msg_Pub.ADD;
1538: Debug('Invalid Picking rule Id is passed ', l_mod_name, 1);

Line 1535: Fnd_Message.SET_TOKEN('PICKING_RULE_ID',

1531: IF NVL(p_order_rec.PICKING_RULE_ID, Fnd_Api.G_MISS_NUM) =
1532: Fnd_Api.G_MISS_NUM
1533: THEN
1534: Fnd_Message.SET_NAME('CSD', 'CSD_INV_PICKING_RULE_ID');
1535: Fnd_Message.SET_TOKEN('PICKING_RULE_ID',
1536: p_order_rec.PICKING_RULE_ID);
1537: Fnd_Msg_Pub.ADD;
1538: Debug('Invalid Picking rule Id is passed ', l_mod_name, 1);
1539: RAISE Fnd_Api.G_EXC_ERROR;

Line 1691: Fnd_Message.SET_NAME('CSD', 'CSD_PICK_RELEASE_FAIL');

1687:
1688:
1689: Exception
1690: WHEN OTHERS THEN
1691: Fnd_Message.SET_NAME('CSD', 'CSD_PICK_RELEASE_FAIL');
1692: Fnd_Message.SET_TOKEN('BATCH_NAME', l_batch_name);
1693: Fnd_Msg_Pub.ADD;
1694: Debug(' Picking rules insert failed ',l_mod_name, 1);
1695: RAISE Fnd_Api.G_EXC_ERROR;

Line 1692: Fnd_Message.SET_TOKEN('BATCH_NAME', l_batch_name);

1688:
1689: Exception
1690: WHEN OTHERS THEN
1691: Fnd_Message.SET_NAME('CSD', 'CSD_PICK_RELEASE_FAIL');
1692: Fnd_Message.SET_TOKEN('BATCH_NAME', l_batch_name);
1693: Fnd_Msg_Pub.ADD;
1694: Debug(' Picking rules insert failed ',l_mod_name, 1);
1695: RAISE Fnd_Api.G_EXC_ERROR;
1696: End ;

Line 1756: Fnd_Message.SET_NAME('CSD', 'CSD_PICK_RELEASE_FAIL');

1752: --dbg_print_stack(x_msg_count, l_mod_name);
1753:
1754: IF (x_return_status = Fnd_Api.G_RET_STS_ERROR)
1755: THEN
1756: Fnd_Message.SET_NAME('CSD', 'CSD_PICK_RELEASE_FAIL');
1757: Fnd_Message.SET_TOKEN('BATCH_NAME', l_batch_name);
1758: Fnd_Msg_Pub.ADD;
1759: Debug('WSH_PICK_LIST.RELEASE_BATCH failed for batch : ' ||
1760: l_batch_name,

Line 1757: Fnd_Message.SET_TOKEN('BATCH_NAME', l_batch_name);

1753:
1754: IF (x_return_status = Fnd_Api.G_RET_STS_ERROR)
1755: THEN
1756: Fnd_Message.SET_NAME('CSD', 'CSD_PICK_RELEASE_FAIL');
1757: Fnd_Message.SET_TOKEN('BATCH_NAME', l_batch_name);
1758: Fnd_Msg_Pub.ADD;
1759: Debug('WSH_PICK_LIST.RELEASE_BATCH failed for batch : ' ||
1760: l_batch_name,
1761: l_mod_name,1) ;

Line 1779: Fnd_Message.SET_NAME('CSD', 'CSD_INV_ORDER_HEADER_ID');

1775:
1776: IF NVL(p_order_rec.order_header_id, Fnd_Api.G_MISS_NUM) =
1777: Fnd_Api.G_MISS_NUM
1778: THEN
1779: Fnd_Message.SET_NAME('CSD', 'CSD_INV_ORDER_HEADER_ID');
1780: Fnd_Message.SET_TOKEN('ORDER_HEADER_ID',
1781: p_order_rec.order_header_id);
1782: Fnd_Msg_Pub.ADD;
1783: Debug('Order_header_id is invalid', l_mod_name, 1);

Line 1780: Fnd_Message.SET_TOKEN('ORDER_HEADER_ID',

1776: IF NVL(p_order_rec.order_header_id, Fnd_Api.G_MISS_NUM) =
1777: Fnd_Api.G_MISS_NUM
1778: THEN
1779: Fnd_Message.SET_NAME('CSD', 'CSD_INV_ORDER_HEADER_ID');
1780: Fnd_Message.SET_TOKEN('ORDER_HEADER_ID',
1781: p_order_rec.order_header_id);
1782: Fnd_Msg_Pub.ADD;
1783: Debug('Order_header_id is invalid', l_mod_name, 1);
1784: RAISE Fnd_Api.G_EXC_ERROR;

Line 1944: FND_MESSAGE.SET_NAME('CSD','CSD_API_SERIAL_NUM_REQD');

1940: if i.serial_number_control_code in (2,5,6) then
1941:
1942: if nvl(p_product_txn_rec.source_serial_number,FND_API.G_MISS_CHAR)=FND_API.G_MISS_CHAR then
1943: /* Validation 3 */
1944: FND_MESSAGE.SET_NAME('CSD','CSD_API_SERIAL_NUM_REQD');
1945: FND_MSG_PUB.ADD;
1946: RAISE FND_API.G_EXC_ERROR;
1947: else
1948: l_shipped_serial_number := p_product_txn_rec.source_serial_number;

Line 1962: FND_MESSAGE.SET_NAME('CSD','CSD_SERIAL_NUM_NOT_IN_INVORG');

1958: exception
1959: when no_data_found then
1960: if (i.serial_number_control_code in (2,5)) then
1961: /*Validation 1 */
1962: FND_MESSAGE.SET_NAME('CSD','CSD_SERIAL_NUM_NOT_IN_INVORG');
1963: FND_MESSAGE.SET_TOKEN('SERIAL_NUMBER',l_shipped_serial_number);
1964: FND_MESSAGE.SET_TOKEN('INV_ORG',i.organization_code);
1965: FND_MSG_PUB.ADD;
1966: RAISE FND_API.G_EXC_ERROR;

Line 1963: FND_MESSAGE.SET_TOKEN('SERIAL_NUMBER',l_shipped_serial_number);

1959: when no_data_found then
1960: if (i.serial_number_control_code in (2,5)) then
1961: /*Validation 1 */
1962: FND_MESSAGE.SET_NAME('CSD','CSD_SERIAL_NUM_NOT_IN_INVORG');
1963: FND_MESSAGE.SET_TOKEN('SERIAL_NUMBER',l_shipped_serial_number);
1964: FND_MESSAGE.SET_TOKEN('INV_ORG',i.organization_code);
1965: FND_MSG_PUB.ADD;
1966: RAISE FND_API.G_EXC_ERROR;
1967: else /*if Item is Serialied at SO then user may pass SN that does not resides in any warehouse */

Line 1964: FND_MESSAGE.SET_TOKEN('INV_ORG',i.organization_code);

1960: if (i.serial_number_control_code in (2,5)) then
1961: /*Validation 1 */
1962: FND_MESSAGE.SET_NAME('CSD','CSD_SERIAL_NUM_NOT_IN_INVORG');
1963: FND_MESSAGE.SET_TOKEN('SERIAL_NUMBER',l_shipped_serial_number);
1964: FND_MESSAGE.SET_TOKEN('INV_ORG',i.organization_code);
1965: FND_MSG_PUB.ADD;
1966: RAISE FND_API.G_EXC_ERROR;
1967: else /*if Item is Serialied at SO then user may pass SN that does not resides in any warehouse */
1968: l_SN_at_SO_new_SN_number :=TRUE;

Line 1976: FND_MESSAGE.SET_NAME('CSD','CSD_SUBINV_IS_REQD');

1972:
1973: if ( i.serial_number_control_code =1 or (i.serial_number_control_code=6 and l_SN_at_SO_new_SN_number=TRUE ) ) then
1974: if nvl(p_product_txn_rec.sub_inventory ,FND_API.G_MISS_CHAR)=FND_API.G_MISS_CHAR then
1975: /*Validation 4 */
1976: FND_MESSAGE.SET_NAME('CSD','CSD_SUBINV_IS_REQD');
1977: FND_MSG_PUB.ADD;
1978: RAISE FND_API.G_EXC_ERROR;
1979: end if;
1980:

Line 1993: FND_MESSAGE.SET_NAME('CSD','CSD_SUBINV_NOT_IN_INVORG');

1989:
1990: exception
1991: When no_data_found then
1992: /*Validation 2 */
1993: FND_MESSAGE.SET_NAME('CSD','CSD_SUBINV_NOT_IN_INVORG');
1994: FND_MESSAGE.SET_TOKEN('SUB_INV',p_product_txn_rec.sub_inventory);
1995: FND_MESSAGE.SET_TOKEN('INV_ORG',i.organization_code);
1996: FND_MSG_PUB.ADD;
1997: RAISE FND_API.G_EXC_ERROR;

Line 1994: FND_MESSAGE.SET_TOKEN('SUB_INV',p_product_txn_rec.sub_inventory);

1990: exception
1991: When no_data_found then
1992: /*Validation 2 */
1993: FND_MESSAGE.SET_NAME('CSD','CSD_SUBINV_NOT_IN_INVORG');
1994: FND_MESSAGE.SET_TOKEN('SUB_INV',p_product_txn_rec.sub_inventory);
1995: FND_MESSAGE.SET_TOKEN('INV_ORG',i.organization_code);
1996: FND_MSG_PUB.ADD;
1997: RAISE FND_API.G_EXC_ERROR;
1998: end;

Line 1995: FND_MESSAGE.SET_TOKEN('INV_ORG',i.organization_code);

1991: When no_data_found then
1992: /*Validation 2 */
1993: FND_MESSAGE.SET_NAME('CSD','CSD_SUBINV_NOT_IN_INVORG');
1994: FND_MESSAGE.SET_TOKEN('SUB_INV',p_product_txn_rec.sub_inventory);
1995: FND_MESSAGE.SET_TOKEN('INV_ORG',i.organization_code);
1996: FND_MSG_PUB.ADD;
1997: RAISE FND_API.G_EXC_ERROR;
1998: end;
1999:

Line 2003: FND_MESSAGE.SET_NAME('CSD','CSD_LOT_NUMBER_REQD');

1999:
2000: if i.LOT_CONTROL_CODE =2 then
2001: if nvl(p_product_txn_rec.lot_number,FND_API.G_MISS_CHAR)=FND_API.G_MISS_CHAR then
2002: /*Validation 5 */
2003: FND_MESSAGE.SET_NAME('CSD','CSD_LOT_NUMBER_REQD');
2004: FND_MESSAGE.SET_TOKEN('ITEM',i.item_name);
2005: FND_MSG_PUB.ADD;
2006: RAISE FND_API.G_EXC_ERROR;
2007: else

Line 2004: FND_MESSAGE.SET_TOKEN('ITEM',i.item_name);

2000: if i.LOT_CONTROL_CODE =2 then
2001: if nvl(p_product_txn_rec.lot_number,FND_API.G_MISS_CHAR)=FND_API.G_MISS_CHAR then
2002: /*Validation 5 */
2003: FND_MESSAGE.SET_NAME('CSD','CSD_LOT_NUMBER_REQD');
2004: FND_MESSAGE.SET_TOKEN('ITEM',i.item_name);
2005: FND_MSG_PUB.ADD;
2006: RAISE FND_API.G_EXC_ERROR;
2007: else
2008: l_lot_number:= p_product_txn_rec.lot_number;

Line 2014: FND_MESSAGE.SET_NAME('CSD','CSD_ITEM_REVISION_REQD');

2010: end if;
2011:
2012: if i.REVISION_QTY_CONTROL_CODE =2 then
2013: if nvl(p_product_txn_rec.revision,FND_API.G_MISS_CHAR)=FND_API.G_MISS_CHAR then
2014: FND_MESSAGE.SET_NAME('CSD','CSD_ITEM_REVISION_REQD');
2015: FND_MESSAGE.SET_TOKEN('ITEM',i.item_name);
2016: FND_MSG_PUB.ADD;
2017: RAISE FND_API.G_EXC_ERROR;
2018: else

Line 2015: FND_MESSAGE.SET_TOKEN('ITEM',i.item_name);

2011:
2012: if i.REVISION_QTY_CONTROL_CODE =2 then
2013: if nvl(p_product_txn_rec.revision,FND_API.G_MISS_CHAR)=FND_API.G_MISS_CHAR then
2014: FND_MESSAGE.SET_NAME('CSD','CSD_ITEM_REVISION_REQD');
2015: FND_MESSAGE.SET_TOKEN('ITEM',i.item_name);
2016: FND_MSG_PUB.ADD;
2017: RAISE FND_API.G_EXC_ERROR;
2018: else
2019: l_revision:=p_product_txn_rec.revision;

Line 2085: Fnd_Message.SET_NAME('CSD','CSD_UPDATE_SHIPPING_FAILED');

2081: 1);
2082: Debug('x_msg_data = ' || x_msg_data,
2083: l_mod_name,
2084: 1);
2085: Fnd_Message.SET_NAME('CSD','CSD_UPDATE_SHIPPING_FAILED');
2086: Fnd_Message.SET_TOKEN('ERR_MSG', x_msg_data);
2087: Fnd_Msg_Pub.ADD;
2088: RAISE Fnd_Api.G_EXC_ERROR;
2089: END;

Line 2086: Fnd_Message.SET_TOKEN('ERR_MSG', x_msg_data);

2082: Debug('x_msg_data = ' || x_msg_data,
2083: l_mod_name,
2084: 1);
2085: Fnd_Message.SET_NAME('CSD','CSD_UPDATE_SHIPPING_FAILED');
2086: Fnd_Message.SET_TOKEN('ERR_MSG', x_msg_data);
2087: Fnd_Msg_Pub.ADD;
2088: RAISE Fnd_Api.G_EXC_ERROR;
2089: END;
2090:

Line 2181: Fnd_Message.SET_NAME('CSD',

2177: -- Ignore if it is a warning
2178: IF (x_return_status <>
2179: Wsh_Util_Core.G_RET_STS_WARNING)
2180: THEN
2181: Fnd_Message.SET_NAME('CSD',
2182: 'CSD_SHIP_CONFIRM_FAILED');
2183: Fnd_Message.SET_TOKEN('ERR_MSG', x_msg_data);
2184: Fnd_Msg_Pub.ADD;
2185: RAISE Fnd_Api.G_EXC_ERROR;

Line 2183: Fnd_Message.SET_TOKEN('ERR_MSG', x_msg_data);

2179: Wsh_Util_Core.G_RET_STS_WARNING)
2180: THEN
2181: Fnd_Message.SET_NAME('CSD',
2182: 'CSD_SHIP_CONFIRM_FAILED');
2183: Fnd_Message.SET_TOKEN('ERR_MSG', x_msg_data);
2184: Fnd_Msg_Pub.ADD;
2185: RAISE Fnd_Api.G_EXC_ERROR;
2186: END IF;
2187: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 2505: Fnd_Message.SET_NAME('CSD', 'CSD_INV_PICK_RULE');

2501: FETCH cur_pick_rules
2502: INTO l_tmp_char;
2503: IF (cur_pick_rules%NOTFOUND)
2504: THEN
2505: Fnd_Message.SET_NAME('CSD', 'CSD_INV_PICK_RULE');
2506: Fnd_Msg_Pub.ADD;
2507: RAISE Fnd_Api.G_EXC_ERROR;
2508: END IF;
2509: END IF;

Line 2553: Fnd_Message.SET_NAME('CSD', 'CSD_ERR_PROD_TXN_STATUS');

2549: WHERE lookup_type = 'CSD_PRODUCT_TXN_STATUS'
2550: AND lookup_code = x_product_txn_rec.PROD_TXN_STATUS;
2551: EXCEPTION
2552: WHEN OTHERS THEN
2553: Fnd_Message.SET_NAME('CSD', 'CSD_ERR_PROD_TXN_STATUS');
2554: Fnd_Msg_Pub.ADD;
2555: RAISE Fnd_Api.G_EXC_ERROR;
2556: END;
2557: END IF;

Line 2574: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');

2570: FROM csd_repairs
2571: WHERE repair_line_id = x_product_txn_rec.repair_line_id;
2572: EXCEPTION
2573: WHEN OTHERS THEN
2574: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');
2575: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
2576: x_product_txn_rec.repair_line_id);
2577: Fnd_Msg_Pub.ADD;
2578: RAISE Fnd_Api.G_EXC_ERROR;

Line 2575: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',

2571: WHERE repair_line_id = x_product_txn_rec.repair_line_id;
2572: EXCEPTION
2573: WHEN OTHERS THEN
2574: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');
2575: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
2576: x_product_txn_rec.repair_line_id);
2577: Fnd_Msg_Pub.ADD;
2578: RAISE Fnd_Api.G_EXC_ERROR;
2579: END;

Line 2679: Fnd_Message.SET_NAME('CSD', 'CSD_API_CONTRACT_MISSING');

2675: END IF;
2676: --]
2677: EXCEPTION
2678: WHEN NO_DATA_FOUND THEN
2679: Fnd_Message.SET_NAME('CSD', 'CSD_API_CONTRACT_MISSING');
2680: Fnd_Message.SET_TOKEN('CONTRACT_LINE_ID',
2681: x_product_txn_rec.contract_id);
2682: Fnd_Msg_Pub.ADD;
2683: Debug('Contract Line Id missing', l_mod_name, 1);

Line 2680: Fnd_Message.SET_TOKEN('CONTRACT_LINE_ID',

2676: --]
2677: EXCEPTION
2678: WHEN NO_DATA_FOUND THEN
2679: Fnd_Message.SET_NAME('CSD', 'CSD_API_CONTRACT_MISSING');
2680: Fnd_Message.SET_TOKEN('CONTRACT_LINE_ID',
2681: x_product_txn_rec.contract_id);
2682: Fnd_Msg_Pub.ADD;
2683: Debug('Contract Line Id missing', l_mod_name, 1);
2684: RAISE Fnd_Api.G_EXC_ERROR;

Line 2708: Fnd_Message.SET_NAME('CSD', 'CSD_API_PARTY_MISSING');

2704: FETCH order_rec
2705: INTO l_party_id, l_account_id;
2706: IF (order_rec%NOTFOUND OR l_party_id IS NULL)
2707: THEN
2708: Fnd_Message.SET_NAME('CSD', 'CSD_API_PARTY_MISSING');
2709: Fnd_Message.SET_TOKEN('INCIDENT_ID', l_incident_id);
2710: Fnd_Msg_Pub.ADD;
2711: RAISE Fnd_Api.G_EXC_ERROR;
2712: END IF;

Line 2709: Fnd_Message.SET_TOKEN('INCIDENT_ID', l_incident_id);

2705: INTO l_party_id, l_account_id;
2706: IF (order_rec%NOTFOUND OR l_party_id IS NULL)
2707: THEN
2708: Fnd_Message.SET_NAME('CSD', 'CSD_API_PARTY_MISSING');
2709: Fnd_Message.SET_TOKEN('INCIDENT_ID', l_incident_id);
2710: Fnd_Msg_Pub.ADD;
2711: RAISE Fnd_Api.G_EXC_ERROR;
2712: END IF;
2713: IF order_rec%ISOPEN

Line 2766: Fnd_Message.SET_NAME('CSD', 'CSD_API_LINE_TYPE_MISSING');

2762: -- If line_type_id Or line_category_code is null
2763: -- then raise error
2764: IF (l_line_type_id IS NULL OR l_line_category_code IS NULL)
2765: THEN
2766: Fnd_Message.SET_NAME('CSD', 'CSD_API_LINE_TYPE_MISSING');
2767: Fnd_Message.SET_TOKEN('TXN_BILLING_TYPE_ID',
2768: x_product_txn_rec.txn_billing_type_id);
2769: Fnd_Msg_Pub.ADD;
2770: RAISE Fnd_Api.G_EXC_ERROR;

Line 2767: Fnd_Message.SET_TOKEN('TXN_BILLING_TYPE_ID',

2763: -- then raise error
2764: IF (l_line_type_id IS NULL OR l_line_category_code IS NULL)
2765: THEN
2766: Fnd_Message.SET_NAME('CSD', 'CSD_API_LINE_TYPE_MISSING');
2767: Fnd_Message.SET_TOKEN('TXN_BILLING_TYPE_ID',
2768: x_product_txn_rec.txn_billing_type_id);
2769: Fnd_Msg_Pub.ADD;
2770: RAISE Fnd_Api.G_EXC_ERROR;
2771: END IF;

Line 2784: Fnd_Message.SET_NAME('CSD',

2780: FROM oe_price_lists
2781: WHERE price_list_id = x_product_txn_rec.price_list_id;
2782: EXCEPTION
2783: WHEN NO_DATA_FOUND THEN
2784: Fnd_Message.SET_NAME('CSD',
2785: 'CSD_API_INV_PRICE_LIST_ID');
2786: Fnd_Message.SET_TOKEN('PRICE_LIST_ID',
2787: x_product_txn_rec.price_list_id);
2788: Fnd_Msg_Pub.ADD;

Line 2786: Fnd_Message.SET_TOKEN('PRICE_LIST_ID',

2782: EXCEPTION
2783: WHEN NO_DATA_FOUND THEN
2784: Fnd_Message.SET_NAME('CSD',
2785: 'CSD_API_INV_PRICE_LIST_ID');
2786: Fnd_Message.SET_TOKEN('PRICE_LIST_ID',
2787: x_product_txn_rec.price_list_id);
2788: Fnd_Msg_Pub.ADD;
2789: RAISE Fnd_Api.G_EXC_ERROR;
2790: WHEN TOO_MANY_ROWS THEN

Line 2800: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_CURR_CODE');

2796:
2797: -- If l_curr_code is null then raise error
2798: IF l_curr_code IS NULL
2799: THEN
2800: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_CURR_CODE');
2801: Fnd_Message.SET_TOKEN('PRICE_LIST_ID',
2802: x_product_txn_rec.price_list_id);
2803: Fnd_Msg_Pub.ADD;
2804: RAISE Fnd_Api.G_EXC_ERROR;

Line 2801: Fnd_Message.SET_TOKEN('PRICE_LIST_ID',

2797: -- If l_curr_code is null then raise error
2798: IF l_curr_code IS NULL
2799: THEN
2800: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_CURR_CODE');
2801: Fnd_Message.SET_TOKEN('PRICE_LIST_ID',
2802: x_product_txn_rec.price_list_id);
2803: Fnd_Msg_Pub.ADD;
2804: RAISE Fnd_Api.G_EXC_ERROR;
2805: END IF;

Line 2826: Fnd_Message.SET_NAME('CSD', 'CSD_API_SERIAL_NUM_MISSING');

2822: x_product_txn_rec.action_type NOT IN ('SHIP', 'WALK_IN_ISSUE') AND
2823: (x_product_txn_rec.action_code <> 'LOANER' AND
2824: x_product_txn_rec.action_type <> 'RMA')
2825: THEN
2826: Fnd_Message.SET_NAME('CSD', 'CSD_API_SERIAL_NUM_MISSING');
2827: Fnd_Message.SET_TOKEN('INVENTORY_ITEM_ID',
2828: x_product_txn_rec.inventory_item_id);
2829: Fnd_Msg_Pub.ADD;
2830: Debug('Serial Number missing for inventory_item_id =' ||

Line 2827: Fnd_Message.SET_TOKEN('INVENTORY_ITEM_ID',

2823: (x_product_txn_rec.action_code <> 'LOANER' AND
2824: x_product_txn_rec.action_type <> 'RMA')
2825: THEN
2826: Fnd_Message.SET_NAME('CSD', 'CSD_API_SERIAL_NUM_MISSING');
2827: Fnd_Message.SET_TOKEN('INVENTORY_ITEM_ID',
2828: x_product_txn_rec.inventory_item_id);
2829: Fnd_Msg_Pub.ADD;
2830: Debug('Serial Number missing for inventory_item_id =' ||
2831: x_product_txn_rec.inventory_item_id,

Line 3022: Fnd_Message.SET_NAME('CSD', 'CSD_ERR_REPAIRS_UPDATE');

3018: SET ro_txn_status = 'CHARGE_ENTERED'
3019: WHERE repair_line_id = x_product_txn_rec.REPAIR_LINE_ID;
3020: IF SQL%NOTFOUND
3021: THEN
3022: Fnd_Message.SET_NAME('CSD', 'CSD_ERR_REPAIRS_UPDATE');
3023: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3024: x_product_txn_rec.repair_line_id);
3025: Fnd_Msg_Pub.ADD;
3026: RAISE Fnd_Api.G_EXC_ERROR;

Line 3023: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',

3019: WHERE repair_line_id = x_product_txn_rec.REPAIR_LINE_ID;
3020: IF SQL%NOTFOUND
3021: THEN
3022: Fnd_Message.SET_NAME('CSD', 'CSD_ERR_REPAIRS_UPDATE');
3023: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3024: x_product_txn_rec.repair_line_id);
3025: Fnd_Msg_Pub.ADD;
3026: RAISE Fnd_Api.G_EXC_ERROR;
3027: END IF;

Line 3059: Fnd_Message.SET_NAME('CSD',

3055: AND inventory_item_id =
3056: x_product_txn_rec.inventory_item_id;
3057: EXCEPTION
3058: WHEN NO_DATA_FOUND THEN
3059: Fnd_Message.SET_NAME('CSD',
3060: 'CSD_INVALID_INVENTORY_ITEM');
3061: Fnd_Msg_Pub.ADD;
3062: RAISE CREATE_ORDER;
3063: END;

Line 3078: Fnd_Message.SET_NAME('CSD',

3074: Cs_Std.get_item_valdn_orgzn_id
3075: AND revision = x_product_txn_rec.revision;
3076: EXCEPTION
3077: WHEN NO_DATA_FOUND THEN
3078: Fnd_Message.SET_NAME('CSD',
3079: 'CSD_INVALID_REVISION');
3080: Fnd_Msg_Pub.ADD;
3081: RAISE CREATE_ORDER;
3082: END;

Line 3138: Fnd_Message.SET_NAME('CSD',

3134: WHERE product_transaction_id =
3135: x_product_txn_rec.PRODUCT_TRANSACTION_ID;
3136: IF SQL%NOTFOUND
3137: THEN
3138: Fnd_Message.SET_NAME('CSD',
3139: 'CSD_ERR_PRD_TXN_UPDATE');
3140: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',
3141: x_product_txn_rec.PRODUCT_TRANSACTION_ID);
3142: Fnd_Msg_Pub.ADD;

Line 3140: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',

3136: IF SQL%NOTFOUND
3137: THEN
3138: Fnd_Message.SET_NAME('CSD',
3139: 'CSD_ERR_PRD_TXN_UPDATE');
3140: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',
3141: x_product_txn_rec.PRODUCT_TRANSACTION_ID);
3142: Fnd_Msg_Pub.ADD;
3143: RAISE CREATE_ORDER;
3144: END IF;

Line 3152: Fnd_Message.SET_NAME('CSD',

3148: WHERE repair_line_id =
3149: x_product_txn_rec.REPAIR_LINE_ID;
3150: IF SQL%NOTFOUND
3151: THEN
3152: Fnd_Message.SET_NAME('CSD',
3153: 'CSD_ERR_REPAIRS_UPDATE');
3154: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3155: x_product_txn_rec.repair_line_id);
3156: Fnd_Msg_Pub.ADD;

Line 3154: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',

3150: IF SQL%NOTFOUND
3151: THEN
3152: Fnd_Message.SET_NAME('CSD',
3153: 'CSD_ERR_REPAIRS_UPDATE');
3154: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3155: x_product_txn_rec.repair_line_id);
3156: Fnd_Msg_Pub.ADD;
3157: RAISE CREATE_ORDER;
3158: END IF;

Line 3191: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PROJECT_UPDATE');

3187: if (l_project_count >= 1) then
3188: l_Line_Tbl_Type(1).project_id := x_product_txn_rec.project_id;
3189: l_Line_Tbl_Type(1).task_id := x_product_txn_rec.task_id;
3190: else
3191: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PROJECT_UPDATE');
3192: FND_MESSAGE.SET_TOKEN('project_id',x_product_txn_rec.project_id);
3193: FND_MESSAGE.SET_TOKEN('ship_from_org_id',l_p_ship_from_org_id);
3194: FND_MSG_PUB.ADD;
3195: RAISE CREATE_ORDER;

Line 3192: FND_MESSAGE.SET_TOKEN('project_id',x_product_txn_rec.project_id);

3188: l_Line_Tbl_Type(1).project_id := x_product_txn_rec.project_id;
3189: l_Line_Tbl_Type(1).task_id := x_product_txn_rec.task_id;
3190: else
3191: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PROJECT_UPDATE');
3192: FND_MESSAGE.SET_TOKEN('project_id',x_product_txn_rec.project_id);
3193: FND_MESSAGE.SET_TOKEN('ship_from_org_id',l_p_ship_from_org_id);
3194: FND_MSG_PUB.ADD;
3195: RAISE CREATE_ORDER;
3196: end if;

Line 3193: FND_MESSAGE.SET_TOKEN('ship_from_org_id',l_p_ship_from_org_id);

3189: l_Line_Tbl_Type(1).task_id := x_product_txn_rec.task_id;
3190: else
3191: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PROJECT_UPDATE');
3192: FND_MESSAGE.SET_TOKEN('project_id',x_product_txn_rec.project_id);
3193: FND_MESSAGE.SET_TOKEN('ship_from_org_id',l_p_ship_from_org_id);
3194: FND_MSG_PUB.ADD;
3195: RAISE CREATE_ORDER;
3196: end if;
3197: end if;

Line 3224: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_OM_PROCESS_LINE');

3220: x_msg_data => x_msg_data
3221: );
3222:
3223: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3224: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_OM_PROCESS_LINE');
3225: FND_MSG_PUB.ADD;
3226: RAISE CREATE_ORDER;
3227: END IF;
3228: end if; -- order line is not null

Line 3271: FND_MESSAGE.SET_NAME('CSD','CSD_API_BOOKING_FAILED'); /*FP Fixed for bug#5147030 message changed*/

3267: l_order_rec.order_line_id := l_order_line_id;
3268:
3269: EXCEPTION
3270: WHEN NO_DATA_FOUND THEN
3271: FND_MESSAGE.SET_NAME('CSD','CSD_API_BOOKING_FAILED'); /*FP Fixed for bug#5147030 message changed*/
3272: /*
3273: Fnd_Message.SET_NAME('CSD',
3274: 'CSD_API_INV_EST_DETAIL_ID');
3275: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',

Line 3273: Fnd_Message.SET_NAME('CSD',

3269: EXCEPTION
3270: WHEN NO_DATA_FOUND THEN
3271: FND_MESSAGE.SET_NAME('CSD','CSD_API_BOOKING_FAILED'); /*FP Fixed for bug#5147030 message changed*/
3272: /*
3273: Fnd_Message.SET_NAME('CSD',
3274: 'CSD_API_INV_EST_DETAIL_ID');
3275: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',
3276: x_estimate_detail_id); */
3277: Fnd_Msg_Pub.ADD;

Line 3275: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',

3271: FND_MESSAGE.SET_NAME('CSD','CSD_API_BOOKING_FAILED'); /*FP Fixed for bug#5147030 message changed*/
3272: /*
3273: Fnd_Message.SET_NAME('CSD',
3274: 'CSD_API_INV_EST_DETAIL_ID');
3275: Fnd_Message.SET_TOKEN('ESTIMATE_DETAIL_ID',
3276: x_estimate_detail_id); */
3277: Fnd_Msg_Pub.ADD;
3278: Debug('Sales Order missing for estimate_detail_id =' ||
3279: x_estimate_detail_id,

Line 3310: Fnd_Message.SET_NAME('CSD',

3306: */
3307: /* AND salesrep_id IS NOT NULL; */
3308: EXCEPTION
3309: WHEN NO_DATA_FOUND THEN
3310: Fnd_Message.SET_NAME('CSD',
3311: 'CSD_API_SALES_REP_MISSING');
3312: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',
3313: l_order_line_id);
3314: Fnd_Msg_Pub.ADD;

Line 3312: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',

3308: EXCEPTION
3309: WHEN NO_DATA_FOUND THEN
3310: Fnd_Message.SET_NAME('CSD',
3311: 'CSD_API_SALES_REP_MISSING');
3312: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',
3313: l_order_line_id);
3314: Fnd_Msg_Pub.ADD;
3315: Debug('Sales rep missing for Line_id=' ||
3316: l_order_line_id,

Line 3328: Fnd_Message.SET_NAME('CSD',

3324: END;
3325:
3326: IF l_ship_from_org_id IS NULL
3327: THEN
3328: Fnd_Message.SET_NAME('CSD',
3329: 'CSD_API_SHIP_FROM_ORG_MISSING');
3330: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',
3331: l_order_line_id);
3332: Fnd_Msg_Pub.ADD;

Line 3330: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',

3326: IF l_ship_from_org_id IS NULL
3327: THEN
3328: Fnd_Message.SET_NAME('CSD',
3329: 'CSD_API_SHIP_FROM_ORG_MISSING');
3330: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',
3331: l_order_line_id);
3332: Fnd_Msg_Pub.ADD;
3333: Debug('Ship from Org Id missing for Line_id=' ||
3334: l_order_line_id,

Line 3342: Fnd_Message.SET_NAME('CSD',

3338: END IF;
3339:
3340: IF l_unit_selling_price IS NULL
3341: THEN
3342: Fnd_Message.SET_NAME('CSD',
3343: 'CSD_API_PRICE_MISSING');
3344: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',
3345: l_order_line_id);
3346: Fnd_Msg_Pub.ADD;

Line 3344: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',

3340: IF l_unit_selling_price IS NULL
3341: THEN
3342: Fnd_Message.SET_NAME('CSD',
3343: 'CSD_API_PRICE_MISSING');
3344: Fnd_Message.SET_TOKEN('ORDER_LINE_ID',
3345: l_order_line_id);
3346: Fnd_Msg_Pub.ADD;
3347: Debug('Unit Selling price missing for Line_id=' ||
3348: l_order_line_id,

Line 3405: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PROJECT_UPDATE');

3401: if (l_project_count >= 1) then
3402: l_Line_Tbl_Type(1).project_id := x_product_txn_rec.project_id;
3403: l_Line_Tbl_Type(1).task_id := x_product_txn_rec.task_id;
3404: else
3405: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PROJECT_UPDATE');
3406: FND_MESSAGE.SET_TOKEN('project_id',x_product_txn_rec.project_id);
3407: FND_MESSAGE.SET_TOKEN('ship_from_org_id',l_ship_from_org_id);
3408: FND_MSG_PUB.ADD;
3409: RAISE BOOK_ORDER;

Line 3406: FND_MESSAGE.SET_TOKEN('project_id',x_product_txn_rec.project_id);

3402: l_Line_Tbl_Type(1).project_id := x_product_txn_rec.project_id;
3403: l_Line_Tbl_Type(1).task_id := x_product_txn_rec.task_id;
3404: else
3405: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PROJECT_UPDATE');
3406: FND_MESSAGE.SET_TOKEN('project_id',x_product_txn_rec.project_id);
3407: FND_MESSAGE.SET_TOKEN('ship_from_org_id',l_ship_from_org_id);
3408: FND_MSG_PUB.ADD;
3409: RAISE BOOK_ORDER;
3410: end if;

Line 3407: FND_MESSAGE.SET_TOKEN('ship_from_org_id',l_ship_from_org_id);

3403: l_Line_Tbl_Type(1).task_id := x_product_txn_rec.task_id;
3404: else
3405: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PROJECT_UPDATE');
3406: FND_MESSAGE.SET_TOKEN('project_id',x_product_txn_rec.project_id);
3407: FND_MESSAGE.SET_TOKEN('ship_from_org_id',l_ship_from_org_id);
3408: FND_MSG_PUB.ADD;
3409: RAISE BOOK_ORDER;
3410: end if;
3411: end if;

Line 3438: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_OM_PROCESS_LINE');

3434: x_msg_data => x_msg_data
3435: );
3436:
3437: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3438: FND_MESSAGE.SET_NAME('CSD','CSD_ERR_OM_PROCESS_LINE');
3439: FND_MSG_PUB.ADD;
3440: RAISE BOOK_ORDER;
3441: END IF;
3442: end if; -- order line is not null

Line 3474: -- FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PRD_TXN_UPDATE');

3470: -- SET prod_txn_status = 'BOOKED',
3471: -- book_sales_order_flag = 'Y'
3472: -- WHERE product_transaction_id = x_product_txn_rec.PRODUCT_TRANSACTION_ID;
3473: -- IF SQL%NOTFOUND then
3474: -- FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PRD_TXN_UPDATE');
3475: -- FND_MESSAGE.SET_TOKEN('PRODUCT_TRANSACTION_ID',x_product_txn_rec.PRODUCT_TRANSACTION_ID);
3476: -- FND_MSG_PUB.ADD;
3477: -- RAISE BOOK_ORDER;
3478: -- END IF;

Line 3475: -- FND_MESSAGE.SET_TOKEN('PRODUCT_TRANSACTION_ID',x_product_txn_rec.PRODUCT_TRANSACTION_ID);

3471: -- book_sales_order_flag = 'Y'
3472: -- WHERE product_transaction_id = x_product_txn_rec.PRODUCT_TRANSACTION_ID;
3473: -- IF SQL%NOTFOUND then
3474: -- FND_MESSAGE.SET_NAME('CSD','CSD_ERR_PRD_TXN_UPDATE');
3475: -- FND_MESSAGE.SET_TOKEN('PRODUCT_TRANSACTION_ID',x_product_txn_rec.PRODUCT_TRANSACTION_ID);
3476: -- FND_MSG_PUB.ADD;
3477: -- RAISE BOOK_ORDER;
3478: -- END IF;
3479:

Line 3491: Fnd_Message.SET_NAME('CSD',

3487: WHERE repair_line_id =
3488: x_product_txn_rec.REPAIR_LINE_ID;
3489: IF SQL%NOTFOUND
3490: THEN
3491: Fnd_Message.SET_NAME('CSD',
3492: 'CSD_ERR_REPAIRS_UPDATE');
3493: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3494: x_product_txn_rec.repair_line_id);
3495: Fnd_Msg_Pub.ADD;

Line 3493: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',

3489: IF SQL%NOTFOUND
3490: THEN
3491: Fnd_Message.SET_NAME('CSD',
3492: 'CSD_ERR_REPAIRS_UPDATE');
3493: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3494: x_product_txn_rec.repair_line_id);
3495: Fnd_Msg_Pub.ADD;
3496: RAISE BOOK_ORDER;
3497: END IF;

Line 3538: Fnd_Message.SET_NAME('CSD',

3534: x_product_txn_rec.sub_inventory
3535: AND organization_id = l_ship_from_org_id;
3536: EXCEPTION
3537: WHEN NO_DATA_FOUND THEN
3538: Fnd_Message.SET_NAME('CSD',
3539: 'CSD_API_SUB_INV_MISSING');
3540: Fnd_Message.SET_TOKEN('SUB_INVENTORY',
3541: x_product_txn_rec.sub_inventory);
3542: Fnd_Msg_Pub.ADD;

Line 3540: Fnd_Message.SET_TOKEN('SUB_INVENTORY',

3536: EXCEPTION
3537: WHEN NO_DATA_FOUND THEN
3538: Fnd_Message.SET_NAME('CSD',
3539: 'CSD_API_SUB_INV_MISSING');
3540: Fnd_Message.SET_TOKEN('SUB_INVENTORY',
3541: x_product_txn_rec.sub_inventory);
3542: Fnd_Msg_Pub.ADD;
3543: Debug(x_product_txn_rec.sub_inventory ||
3544: ':Subinventory does not exist',

Line 3605: Fnd_Message.SET_NAME('CSD', 'CSD_SRL_RESERVE_FAILED');

3601: Debug('Calling reserve serial..', l_mod_name, 1);
3602: CSD_LOGISTICS_UTIL.Reserve_serial_number(l_serial_rsv_rec, x_return_status);
3603:
3604: if(x_return_status = FND_API.G_RET_STS_ERROR) THEN
3605: Fnd_Message.SET_NAME('CSD', 'CSD_SRL_RESERVE_FAILED');
3606: Fnd_Msg_Pub.ADD;
3607: RAISE RELEASE_ORDER;
3608: END IF;
3609:

Line 3639: Fnd_Message.SET_NAME('CSD',

3635: FROM wsh_picking_rules
3636: WHERE picking_rule_id = l_picking_rule_id;
3637: EXCEPTION
3638: WHEN NO_DATA_FOUND THEN
3639: Fnd_Message.SET_NAME('CSD',
3640: 'CSD_API_INV_PICKING_RULE_ID');
3641: Fnd_Message.SET_TOKEN('PICKING_RULE_ID',
3642: l_picking_rule_id);
3643: Fnd_Msg_Pub.ADD;

Line 3641: Fnd_Message.SET_TOKEN('PICKING_RULE_ID',

3637: EXCEPTION
3638: WHEN NO_DATA_FOUND THEN
3639: Fnd_Message.SET_NAME('CSD',
3640: 'CSD_API_INV_PICKING_RULE_ID');
3641: Fnd_Message.SET_TOKEN('PICKING_RULE_ID',
3642: l_picking_rule_id);
3643: Fnd_Msg_Pub.ADD;
3644: Debug(l_picking_rule_id ||
3645: ':Picking Rule does not exist ',

Line 3730: Fnd_Message.SET_NAME('CSD',

3726: WHERE product_transaction_id =
3727: x_product_txn_rec.PRODUCT_TRANSACTION_ID;
3728: IF SQL%NOTFOUND
3729: THEN
3730: Fnd_Message.SET_NAME('CSD',
3731: 'CSD_ERR_PRD_TXN_UPDATE');
3732: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',
3733: x_product_txn_rec.PRODUCT_TRANSACTION_ID);
3734: Fnd_Msg_Pub.ADD;

Line 3732: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',

3728: IF SQL%NOTFOUND
3729: THEN
3730: Fnd_Message.SET_NAME('CSD',
3731: 'CSD_ERR_PRD_TXN_UPDATE');
3732: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',
3733: x_product_txn_rec.PRODUCT_TRANSACTION_ID);
3734: Fnd_Msg_Pub.ADD;
3735: RAISE RELEASE_ORDER;
3736: END IF;

Line 3745: Fnd_Message.SET_NAME('CSD',

3741: WHERE repair_line_id =
3742: x_product_txn_rec.REPAIR_LINE_ID;
3743: IF SQL%NOTFOUND
3744: THEN
3745: Fnd_Message.SET_NAME('CSD',
3746: 'CSD_ERR_REPAIRS_UPDATE');
3747: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3748: x_product_txn_rec.repair_line_id);
3749: Fnd_Msg_Pub.ADD;

Line 3747: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',

3743: IF SQL%NOTFOUND
3744: THEN
3745: Fnd_Message.SET_NAME('CSD',
3746: 'CSD_ERR_REPAIRS_UPDATE');
3747: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3748: x_product_txn_rec.repair_line_id);
3749: Fnd_Msg_Pub.ADD;
3750: RAISE RELEASE_ORDER;
3751: END IF;

Line 3765: Fnd_Message.SET_NAME('CSD',

3761: WHERE product_transaction_id =
3762: x_product_txn_rec.PRODUCT_TRANSACTION_ID;
3763: IF SQL%NOTFOUND
3764: THEN
3765: Fnd_Message.SET_NAME('CSD',
3766: 'CSD_ERR_PRD_TXN_UPDATE');
3767: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',
3768: x_product_txn_rec.PRODUCT_TRANSACTION_ID);
3769: Fnd_Msg_Pub.ADD;

Line 3767: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',

3763: IF SQL%NOTFOUND
3764: THEN
3765: Fnd_Message.SET_NAME('CSD',
3766: 'CSD_ERR_PRD_TXN_UPDATE');
3767: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',
3768: x_product_txn_rec.PRODUCT_TRANSACTION_ID);
3769: Fnd_Msg_Pub.ADD;
3770: RAISE RELEASE_ORDER;
3771: END IF;

Line 3780: Fnd_Message.SET_NAME('CSD',

3776: WHERE repair_line_id =
3777: x_product_txn_rec.REPAIR_LINE_ID;
3778: IF SQL%NOTFOUND
3779: THEN
3780: Fnd_Message.SET_NAME('CSD',
3781: 'CSD_ERR_REPAIRS_UPDATE');
3782: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3783: x_product_txn_rec.repair_line_id);
3784: Fnd_Msg_Pub.ADD;

Line 3782: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',

3778: IF SQL%NOTFOUND
3779: THEN
3780: Fnd_Message.SET_NAME('CSD',
3781: 'CSD_ERR_REPAIRS_UPDATE');
3782: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3783: x_product_txn_rec.repair_line_id);
3784: Fnd_Msg_Pub.ADD;
3785: RAISE RELEASE_ORDER;
3786: END IF;

Line 3871: Fnd_Message.SET_NAME('CSD',

3867: WHERE product_transaction_id =
3868: x_product_txn_rec.PRODUCT_TRANSACTION_ID;
3869: IF SQL%NOTFOUND
3870: THEN
3871: Fnd_Message.SET_NAME('CSD',
3872: 'CSD_ERR_PRD_TXN_UPDATE');
3873: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',
3874: x_product_txn_rec.PRODUCT_TRANSACTION_ID);
3875: Fnd_Msg_Pub.ADD;

Line 3873: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',

3869: IF SQL%NOTFOUND
3870: THEN
3871: Fnd_Message.SET_NAME('CSD',
3872: 'CSD_ERR_PRD_TXN_UPDATE');
3873: Fnd_Message.SET_TOKEN('PRODUCT_TRANSACTION_ID',
3874: x_product_txn_rec.PRODUCT_TRANSACTION_ID);
3875: Fnd_Msg_Pub.ADD;
3876: RAISE SHIP_ORDER;
3877: END IF;

Line 3886: Fnd_Message.SET_NAME('CSD',

3882: WHERE repair_line_id =
3883: x_product_txn_rec.REPAIR_LINE_ID;
3884: IF SQL%NOTFOUND
3885: THEN
3886: Fnd_Message.SET_NAME('CSD',
3887: 'CSD_ERR_REPAIRS_UPDATE');
3888: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3889: x_product_txn_rec.repair_line_id);
3890: Fnd_Msg_Pub.ADD;

Line 3888: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',

3884: IF SQL%NOTFOUND
3885: THEN
3886: Fnd_Message.SET_NAME('CSD',
3887: 'CSD_ERR_REPAIRS_UPDATE');
3888: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
3889: x_product_txn_rec.repair_line_id);
3890: Fnd_Msg_Pub.ADD;
3891: RAISE SHIP_ORDER;
3892: END IF;

Line 4240: Fnd_Message.SET_NAME('CSD', 'CSD_ERR_PROD_TXN_STATUS');

4236: WHERE lookup_type = 'CSD_PRODUCT_TXN_STATUS'
4237: AND lookup_code = x_product_txn_rec.PROD_TXN_STATUS;
4238: EXCEPTION
4239: WHEN OTHERS THEN
4240: Fnd_Message.SET_NAME('CSD', 'CSD_ERR_PROD_TXN_STATUS');
4241: Fnd_Msg_Pub.ADD;
4242: RAISE Fnd_Api.G_EXC_ERROR;
4243: END;
4244: END IF;

Line 4255: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');

4251: FROM csd_repairs
4252: WHERE repair_line_id = x_product_txn_rec.repair_line_id;
4253: EXCEPTION
4254: WHEN OTHERS THEN
4255: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');
4256: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
4257: x_product_txn_rec.repair_line_id);
4258: Fnd_Msg_Pub.ADD;
4259: RAISE Fnd_Api.G_EXC_ERROR;

Line 4256: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',

4252: WHERE repair_line_id = x_product_txn_rec.repair_line_id;
4253: EXCEPTION
4254: WHEN OTHERS THEN
4255: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');
4256: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
4257: x_product_txn_rec.repair_line_id);
4258: Fnd_Msg_Pub.ADD;
4259: RAISE Fnd_Api.G_EXC_ERROR;
4260: END;

Line 4308: Fnd_Message.SET_NAME('CSD', 'CSD_API_PARTY_MISSING');

4304: FETCH get_account_details
4305: INTO l_party_id, l_account_id;
4306: IF (get_account_details%NOTFOUND OR l_party_id IS NULL)
4307: THEN
4308: Fnd_Message.SET_NAME('CSD', 'CSD_API_PARTY_MISSING');
4309: Fnd_Message.SET_TOKEN('INCIDENT_ID', l_incident_id);
4310: Fnd_Msg_Pub.ADD;
4311: RAISE Fnd_Api.G_EXC_ERROR;
4312: END IF;

Line 4309: Fnd_Message.SET_TOKEN('INCIDENT_ID', l_incident_id);

4305: INTO l_party_id, l_account_id;
4306: IF (get_account_details%NOTFOUND OR l_party_id IS NULL)
4307: THEN
4308: Fnd_Message.SET_NAME('CSD', 'CSD_API_PARTY_MISSING');
4309: Fnd_Message.SET_TOKEN('INCIDENT_ID', l_incident_id);
4310: Fnd_Msg_Pub.ADD;
4311: RAISE Fnd_Api.G_EXC_ERROR;
4312: END IF;
4313: IF get_account_details%ISOPEN

Line 4358: Fnd_Message.SET_NAME('CSD', 'CSD_API_LINE_TYPE_MISSING');

4354: -- If line_type_id Or line_category_code is null
4355: -- then raise error
4356: IF (l_line_type_id IS NULL OR l_line_category_code IS NULL)
4357: THEN
4358: Fnd_Message.SET_NAME('CSD', 'CSD_API_LINE_TYPE_MISSING');
4359: Fnd_Message.SET_TOKEN('TXN_BILLING_TYPE_ID',
4360: x_product_txn_rec.txn_billing_type_id);
4361: Fnd_Msg_Pub.ADD;
4362: RAISE Fnd_Api.G_EXC_ERROR;

Line 4359: Fnd_Message.SET_TOKEN('TXN_BILLING_TYPE_ID',

4355: -- then raise error
4356: IF (l_line_type_id IS NULL OR l_line_category_code IS NULL)
4357: THEN
4358: Fnd_Message.SET_NAME('CSD', 'CSD_API_LINE_TYPE_MISSING');
4359: Fnd_Message.SET_TOKEN('TXN_BILLING_TYPE_ID',
4360: x_product_txn_rec.txn_billing_type_id);
4361: Fnd_Msg_Pub.ADD;
4362: RAISE Fnd_Api.G_EXC_ERROR;
4363: END IF;

Line 4376: Fnd_Message.SET_NAME('CSD',

4372: FROM oe_price_lists
4373: WHERE price_list_id = x_product_txn_rec.price_list_id;
4374: EXCEPTION
4375: WHEN NO_DATA_FOUND THEN
4376: Fnd_Message.SET_NAME('CSD',
4377: 'CSD_API_INV_PRICE_LIST_ID');
4378: Fnd_Message.SET_TOKEN('PRICE_LIST_ID',
4379: x_product_txn_rec.price_list_id);
4380: Fnd_Msg_Pub.ADD;

Line 4378: Fnd_Message.SET_TOKEN('PRICE_LIST_ID',

4374: EXCEPTION
4375: WHEN NO_DATA_FOUND THEN
4376: Fnd_Message.SET_NAME('CSD',
4377: 'CSD_API_INV_PRICE_LIST_ID');
4378: Fnd_Message.SET_TOKEN('PRICE_LIST_ID',
4379: x_product_txn_rec.price_list_id);
4380: Fnd_Msg_Pub.ADD;
4381: RAISE Fnd_Api.G_EXC_ERROR;
4382: WHEN TOO_MANY_ROWS THEN

Line 4399: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_CURR_CODE');

4395:
4396: -- If l_curr_code is null then raise error
4397: IF l_curr_code IS NULL
4398: THEN
4399: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_CURR_CODE');
4400: Fnd_Message.SET_TOKEN('PRICE_LIST_ID',
4401: x_product_txn_rec.price_list_id);
4402: Fnd_Msg_Pub.ADD;
4403: RAISE Fnd_Api.G_EXC_ERROR;

Line 4400: Fnd_Message.SET_TOKEN('PRICE_LIST_ID',

4396: -- If l_curr_code is null then raise error
4397: IF l_curr_code IS NULL
4398: THEN
4399: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_CURR_CODE');
4400: Fnd_Message.SET_TOKEN('PRICE_LIST_ID',
4401: x_product_txn_rec.price_list_id);
4402: Fnd_Msg_Pub.ADD;
4403: RAISE Fnd_Api.G_EXC_ERROR;
4404: END IF;

Line 4424: Fnd_Message.SET_NAME('CSD', 'CSD_API_SERIAL_NUM_MISSING');

4420: x_product_txn_rec.action_type NOT IN ('SHIP') AND
4421: (x_product_txn_rec.action_code <> 'LOANER' AND
4422: x_product_txn_rec.action_type <>'RMA')
4423: THEN
4424: Fnd_Message.SET_NAME('CSD', 'CSD_API_SERIAL_NUM_MISSING');
4425: Fnd_Message.SET_TOKEN('INVENTORY_ITEM_ID',
4426: x_product_txn_rec.inventory_item_id);
4427: Fnd_Msg_Pub.ADD;
4428: IF (g_debug > 0)

Line 4425: Fnd_Message.SET_TOKEN('INVENTORY_ITEM_ID',

4421: (x_product_txn_rec.action_code <> 'LOANER' AND
4422: x_product_txn_rec.action_type <>'RMA')
4423: THEN
4424: Fnd_Message.SET_NAME('CSD', 'CSD_API_SERIAL_NUM_MISSING');
4425: Fnd_Message.SET_TOKEN('INVENTORY_ITEM_ID',
4426: x_product_txn_rec.inventory_item_id);
4427: Fnd_Msg_Pub.ADD;
4428: IF (g_debug > 0)
4429: THEN

Line 4512: Fnd_Message.SET_NAME('CSD', 'CSD_ERR_REPAIRS_UPDATE');

4508: SET ro_txn_status = 'OM_SUBMITTED'
4509: WHERE repair_line_id = x_product_txn_rec.REPAIR_LINE_ID;
4510: IF SQL%NOTFOUND
4511: THEN
4512: Fnd_Message.SET_NAME('CSD', 'CSD_ERR_REPAIRS_UPDATE');
4513: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
4514: x_product_txn_rec.repair_line_id);
4515: Fnd_Msg_Pub.ADD;
4516: RAISE Fnd_Api.G_EXC_ERROR;

Line 4513: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',

4509: WHERE repair_line_id = x_product_txn_rec.REPAIR_LINE_ID;
4510: IF SQL%NOTFOUND
4511: THEN
4512: Fnd_Message.SET_NAME('CSD', 'CSD_ERR_REPAIRS_UPDATE');
4513: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
4514: x_product_txn_rec.repair_line_id);
4515: Fnd_Msg_Pub.ADD;
4516: RAISE Fnd_Api.G_EXC_ERROR;
4517: END IF;

Line 4981: Fnd_Message.SET_NAME('CSD', 'CSD_API_DELETE_NOT_ALLOWED');

4977: l_delete_allow := 'Y';
4978: EXCEPTION
4979: WHEN NO_DATA_FOUND THEN
4980: l_delete_allow := 'N';
4981: Fnd_Message.SET_NAME('CSD', 'CSD_API_DELETE_NOT_ALLOWED');
4982: --FND_MESSAGE.SET_TOKEN('PRODUCT_TXN_ID',p_product_txn_id);
4983: Fnd_Msg_Pub.ADD;
4984: IF (g_debug > 0)
4985: THEN

Line 4982: --FND_MESSAGE.SET_TOKEN('PRODUCT_TXN_ID',p_product_txn_id);

4978: EXCEPTION
4979: WHEN NO_DATA_FOUND THEN
4980: l_delete_allow := 'N';
4981: Fnd_Message.SET_NAME('CSD', 'CSD_API_DELETE_NOT_ALLOWED');
4982: --FND_MESSAGE.SET_TOKEN('PRODUCT_TXN_ID',p_product_txn_id);
4983: Fnd_Msg_Pub.ADD;
4984: IF (g_debug > 0)
4985: THEN
4986: Csd_Gen_Utility_Pvt.ADD('Product txn is interfaced,so it cannot be deleted');

Line 5279: Fnd_Message.SET_NAME('CSD', 'CSD_API_OM_ERR_MSG');

5275:
5276: -- Api body ends here
5277: IF l_msg_text IS NOT NULL
5278: THEN
5279: Fnd_Message.SET_NAME('CSD', 'CSD_API_OM_ERR_MSG');
5280: Fnd_Message.SET_TOKEN('MSG_DATA', l_msg_text);
5281: Fnd_Msg_Pub.ADD;
5282: END IF;
5283:

Line 5280: Fnd_Message.SET_TOKEN('MSG_DATA', l_msg_text);

5276: -- Api body ends here
5277: IF l_msg_text IS NOT NULL
5278: THEN
5279: Fnd_Message.SET_NAME('CSD', 'CSD_API_OM_ERR_MSG');
5280: Fnd_Message.SET_TOKEN('MSG_DATA', l_msg_text);
5281: Fnd_Msg_Pub.ADD;
5282: END IF;
5283:
5284: -- Standard check of p_commit.

Line 7327: Fnd_Message.SET_NAME('CSD',

7323: X_Msg_Data => l_msg_data);
7324:
7325: IF (l_return_status <> 'S')
7326: THEN
7327: Fnd_Message.SET_NAME('CSD',
7328: 'CSD_API_RO_STAT_UPD_FAIL');
7329: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
7330: ro.repair_line_id);
7331: Fnd_Msg_Pub.ADD;

Line 7329: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',

7325: IF (l_return_status <> 'S')
7326: THEN
7327: Fnd_Message.SET_NAME('CSD',
7328: 'CSD_API_RO_STAT_UPD_FAIL');
7329: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
7330: ro.repair_line_id);
7331: Fnd_Msg_Pub.ADD;
7332: RAISE Fnd_Api.G_EXC_ERROR;
7333: END IF;

Line 7369: Fnd_Message.SET_NAME('CSD',

7365: x_msg_data => l_msg_data);
7366:
7367: IF (l_return_status <> 'S')
7368: THEN
7369: Fnd_Message.SET_NAME('CSD',
7370: 'CSD_API_GRP_STAT_UPD_FAIL');
7371: Fnd_Message.SET_TOKEN('REPAIR_GROUP_ID',
7372: grp.repair_group_id);
7373: Fnd_Msg_Pub.ADD;

Line 7371: Fnd_Message.SET_TOKEN('REPAIR_GROUP_ID',

7367: IF (l_return_status <> 'S')
7368: THEN
7369: Fnd_Message.SET_NAME('CSD',
7370: 'CSD_API_GRP_STAT_UPD_FAIL');
7371: Fnd_Message.SET_TOKEN('REPAIR_GROUP_ID',
7372: grp.repair_group_id);
7373: Fnd_Msg_Pub.ADD;
7374: RAISE Fnd_Api.G_EXC_ERROR;
7375: END IF;

Line 7421: Fnd_Message.SET_NAME('CSD',

7417: X_Msg_Data => l_msg_data);
7418:
7419: IF (l_return_status <> 'S')
7420: THEN
7421: Fnd_Message.SET_NAME('CSD',
7422: 'CSD_API_RO_STAT_UPD_FAIL');
7423: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
7424: ro.repair_line_id);
7425: Fnd_Msg_Pub.ADD;

Line 7423: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',

7419: IF (l_return_status <> 'S')
7420: THEN
7421: Fnd_Message.SET_NAME('CSD',
7422: 'CSD_API_RO_STAT_UPD_FAIL');
7423: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID',
7424: ro.repair_line_id);
7425: Fnd_Msg_Pub.ADD;
7426: RAISE Fnd_Api.G_EXC_ERROR;
7427: END IF;

Line 7464: Fnd_Message.SET_NAME('CSD',

7460: x_msg_data => l_msg_data);
7461:
7462: IF (l_return_status <> 'S')
7463: THEN
7464: Fnd_Message.SET_NAME('CSD',
7465: 'CSD_API_GRP_STAT_UPD_FAIL');
7466: Fnd_Message.SET_TOKEN('REPAIR_GROUP_ID',
7467: grp.repair_group_id);
7468: Fnd_Msg_Pub.ADD;

Line 7466: Fnd_Message.SET_TOKEN('REPAIR_GROUP_ID',

7462: IF (l_return_status <> 'S')
7463: THEN
7464: Fnd_Message.SET_NAME('CSD',
7465: 'CSD_API_GRP_STAT_UPD_FAIL');
7466: Fnd_Message.SET_TOKEN('REPAIR_GROUP_ID',
7467: grp.repair_group_id);
7468: Fnd_Msg_Pub.ADD;
7469: RAISE Fnd_Api.G_EXC_ERROR;
7470: END IF;

Line 7579: Fnd_Message.SET_NAME('CSD',

7575: x_interaction_id => l_interaction_id);
7576:
7577: IF (l_return_status <> 'S')
7578: THEN
7579: Fnd_Message.SET_NAME('CSD',
7580: 'CSD_API_SR_STAT_UPD_FAIL');
7581: Fnd_Message.SET_TOKEN('INCIDENT_ID', p_incident_id);
7582: Fnd_Msg_Pub.ADD;
7583: RAISE Fnd_Api.G_EXC_ERROR;

Line 7581: Fnd_Message.SET_TOKEN('INCIDENT_ID', p_incident_id);

7577: IF (l_return_status <> 'S')
7578: THEN
7579: Fnd_Message.SET_NAME('CSD',
7580: 'CSD_API_SR_STAT_UPD_FAIL');
7581: Fnd_Message.SET_TOKEN('INCIDENT_ID', p_incident_id);
7582: Fnd_Msg_Pub.ADD;
7583: RAISE Fnd_Api.G_EXC_ERROR;
7584: END IF;
7585:

Line 7639: Fnd_Message.SET_NAME('CSD', 'CSD_API_RO_STAT_UPD_FAIL');

7635: X_Msg_Data => l_msg_data);
7636:
7637: IF (l_return_status <> 'S')
7638: THEN
7639: Fnd_Message.SET_NAME('CSD', 'CSD_API_RO_STAT_UPD_FAIL');
7640: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID', p_repair_line_id);
7641: Fnd_Msg_Pub.ADD;
7642: RAISE Fnd_Api.G_EXC_ERROR;
7643: END IF;

Line 7640: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID', p_repair_line_id);

7636:
7637: IF (l_return_status <> 'S')
7638: THEN
7639: Fnd_Message.SET_NAME('CSD', 'CSD_API_RO_STAT_UPD_FAIL');
7640: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID', p_repair_line_id);
7641: Fnd_Msg_Pub.ADD;
7642: RAISE Fnd_Api.G_EXC_ERROR;
7643: END IF;
7644:

Line 7702: Fnd_Message.SET_NAME('CSD',

7698: x_msg_data => l_msg_data);
7699:
7700: IF (l_return_status <> 'S')
7701: THEN
7702: Fnd_Message.SET_NAME('CSD',
7703: 'CSD_API_GRP_STAT_UPD_FAIL');
7704: Fnd_Message.SET_TOKEN('REPAIR_GROUP_ID',
7705: l_repair_group_id);
7706: Fnd_Msg_Pub.ADD;

Line 7704: Fnd_Message.SET_TOKEN('REPAIR_GROUP_ID',

7700: IF (l_return_status <> 'S')
7701: THEN
7702: Fnd_Message.SET_NAME('CSD',
7703: 'CSD_API_GRP_STAT_UPD_FAIL');
7704: Fnd_Message.SET_TOKEN('REPAIR_GROUP_ID',
7705: l_repair_group_id);
7706: Fnd_Msg_Pub.ADD;
7707: RAISE Fnd_Api.G_EXC_ERROR;
7708: END IF;

Line 7815: Fnd_Message.SET_NAME('CSD',

7811: x_interaction_id => l_interaction_id);
7812:
7813: IF (l_return_status <> 'S')
7814: THEN
7815: Fnd_Message.SET_NAME('CSD',
7816: 'CSD_API_SR_STAT_UPD_FAIL');
7817: Fnd_Message.SET_TOKEN('INCIDENT_ID', l_incident_id);
7818: Fnd_Msg_Pub.ADD;
7819: --Bug fix for 3555256 Begin

Line 7817: Fnd_Message.SET_TOKEN('INCIDENT_ID', l_incident_id);

7813: IF (l_return_status <> 'S')
7814: THEN
7815: Fnd_Message.SET_NAME('CSD',
7816: 'CSD_API_SR_STAT_UPD_FAIL');
7817: Fnd_Message.SET_TOKEN('INCIDENT_ID', l_incident_id);
7818: Fnd_Msg_Pub.ADD;
7819: --Bug fix for 3555256 Begin
7820: --RAISE FND_API.G_EXC_ERROR;
7821: Fnd_Msg_Pub.Count_And_Get(p_count => x_msg_count,

Line 8336: Fnd_Message.set_name('CSD', 'CSD_ERR_PROD_TXN_STATUS');

8332: x_product_txn_rec.prod_txn_status);
8333: END IF;
8334: EXCEPTION
8335: WHEN NO_DATA_FOUND THEN
8336: Fnd_Message.set_name('CSD', 'CSD_ERR_PROD_TXN_STATUS');
8337: IF l_exception_level >= l_debug_level
8338: THEN
8339: Fnd_Log.string(l_exception_level,
8340: l_module_name ||

Line 8424: Fnd_Message.set_name('CSD', 'CSD_API_INV_REP_LINE_ID');

8420: FROM csd_repairs
8421: WHERE repair_line_id = l_repair_line_id;
8422: EXCEPTION
8423: WHEN NO_DATA_FOUND THEN
8424: Fnd_Message.set_name('CSD', 'CSD_API_INV_REP_LINE_ID');
8425: Fnd_Message.set_token('REPAIR_LINE_ID',
8426: l_repair_line_id);
8427: Fnd_Msg_Pub.ADD;
8428: IF l_statement_level >= l_debug_level

Line 8425: Fnd_Message.set_token('REPAIR_LINE_ID',

8421: WHERE repair_line_id = l_repair_line_id;
8422: EXCEPTION
8423: WHEN NO_DATA_FOUND THEN
8424: Fnd_Message.set_name('CSD', 'CSD_API_INV_REP_LINE_ID');
8425: Fnd_Message.set_token('REPAIR_LINE_ID',
8426: l_repair_line_id);
8427: Fnd_Msg_Pub.ADD;
8428: IF l_statement_level >= l_debug_level
8429: THEN

Line 8445: Fnd_Message.set_name('CSD', 'CSD_API_INV_SR_ID');

8441: FETCH sr_rec
8442: INTO l_party_id, l_account_id;
8443: CLOSE sr_rec;
8444: ELSE
8445: Fnd_Message.set_name('CSD', 'CSD_API_INV_SR_ID');
8446: Fnd_Message.set_token('INCIDENT_ID', l_incident_id);
8447: Fnd_Msg_Pub.ADD;
8448: IF (g_debug > 0)
8449: THEN

Line 8446: Fnd_Message.set_token('INCIDENT_ID', l_incident_id);

8442: INTO l_party_id, l_account_id;
8443: CLOSE sr_rec;
8444: ELSE
8445: Fnd_Message.set_name('CSD', 'CSD_API_INV_SR_ID');
8446: Fnd_Message.set_token('INCIDENT_ID', l_incident_id);
8447: Fnd_Msg_Pub.ADD;
8448: IF (g_debug > 0)
8449: THEN
8450: Csd_Gen_Utility_Pvt.ADD('incident id missing ');

Line 8518: Fnd_Message.set_name('CSD',

8514: NVL(end_date_active, SYSDATE + 1);
8515: l_order_rec.picking_rule_id := l_picking_rule_id;
8516: EXCEPTION
8517: WHEN NO_DATA_FOUND THEN
8518: Fnd_Message.set_name('CSD',
8519: 'CSD_API_INV_PICKING_RULE_ID');
8520: Fnd_Message.set_token('PICKING_RULE_ID',
8521: l_picking_rule_id);
8522: Fnd_Msg_Pub.ADD;

Line 8520: Fnd_Message.set_token('PICKING_RULE_ID',

8516: EXCEPTION
8517: WHEN NO_DATA_FOUND THEN
8518: Fnd_Message.set_name('CSD',
8519: 'CSD_API_INV_PICKING_RULE_ID');
8520: Fnd_Message.set_token('PICKING_RULE_ID',
8521: l_picking_rule_id);
8522: Fnd_Msg_Pub.ADD;
8523: IF l_exception_level >= l_debug_level
8524: THEN

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

8680: Last_Updated_By = Fnd_Global.User_Id,
8681: Last_Update_login = Fnd_Global.Login_Id
8682: where repair_line_id = x_product_txn_rec.repair_line_id;
8683: if sql%notfound then
8684: fnd_message.set_name('CSD','CSD_ERR_REPAIRS_UPDATE');
8685: fnd_message.set_token('REPAIR_LINE_ID',x_product_txn_rec.repair_line_id);
8686: fnd_msg_pub.add;
8687: raise release_order_excep;
8688: end if;

Line 8685: fnd_message.set_token('REPAIR_LINE_ID',x_product_txn_rec.repair_line_id);

8681: Last_Update_login = Fnd_Global.Login_Id
8682: where repair_line_id = x_product_txn_rec.repair_line_id;
8683: if sql%notfound then
8684: fnd_message.set_name('CSD','CSD_ERR_REPAIRS_UPDATE');
8685: fnd_message.set_token('REPAIR_LINE_ID',x_product_txn_rec.repair_line_id);
8686: fnd_msg_pub.add;
8687: raise release_order_excep;
8688: end if;
8689: ********************************/

Line 8742: -- fnd_message.set_name('csd','csd_release_failed');

8738: AND SOURCE_CODE = 'OE'; /*Fixed for bug#5840654 */
8739: EXCEPTION
8740: WHEN NO_DATA_FOUND THEN
8741: l_allow_ship := C_No;
8742: -- fnd_message.set_name('csd','csd_release_failed');
8743: Fnd_Message.set_name('CSD',
8744: 'CSD_ORDER_LINE_NOT_SHIPABLE');
8745: Fnd_Message.set_token('ORDER_LINE_ID',
8746: l_order_rec.order_line_id);

Line 8743: Fnd_Message.set_name('CSD',

8739: EXCEPTION
8740: WHEN NO_DATA_FOUND THEN
8741: l_allow_ship := C_No;
8742: -- fnd_message.set_name('csd','csd_release_failed');
8743: Fnd_Message.set_name('CSD',
8744: 'CSD_ORDER_LINE_NOT_SHIPABLE');
8745: Fnd_Message.set_token('ORDER_LINE_ID',
8746: l_order_rec.order_line_id);
8747: Fnd_Msg_Pub.ADD;

Line 8745: Fnd_Message.set_token('ORDER_LINE_ID',

8741: l_allow_ship := C_No;
8742: -- fnd_message.set_name('csd','csd_release_failed');
8743: Fnd_Message.set_name('CSD',
8744: 'CSD_ORDER_LINE_NOT_SHIPABLE');
8745: Fnd_Message.set_token('ORDER_LINE_ID',
8746: l_order_rec.order_line_id);
8747: Fnd_Msg_Pub.ADD;
8748: IF l_statement_level >= l_debug_level
8749: THEN

Line 8758: Fnd_Message.set_name('CSD',

8754: ' is not eligible for shipping.');
8755: END IF;
8756: RAISE ship_order_excep;
8757: WHEN TOO_MANY_ROWS THEN
8758: Fnd_Message.set_name('CSD',
8759: 'CSD_TOO_MANY_ROWS_SHIPABLE');
8760: Fnd_Message.set_token('ORDER_LINE_ID',
8761: l_order_rec.order_line_id);
8762: Fnd_Msg_Pub.ADD;

Line 8760: Fnd_Message.set_token('ORDER_LINE_ID',

8756: RAISE ship_order_excep;
8757: WHEN TOO_MANY_ROWS THEN
8758: Fnd_Message.set_name('CSD',
8759: 'CSD_TOO_MANY_ROWS_SHIPABLE');
8760: Fnd_Message.set_token('ORDER_LINE_ID',
8761: l_order_rec.order_line_id);
8762: Fnd_Msg_Pub.ADD;
8763: IF l_statement_level >= l_debug_level
8764: THEN

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

8870: Last_Updated_By = Fnd_Global.User_Id,
8871: Last_Update_login = Fnd_Global.Login_Id
8872: Where repair_line_id = x_product_txn_rec.repair_line_id;
8873: If sql%notfound then
8874: fnd_message.set_name('CSD','CSD_ERR_REPAIRS_UPDATE');
8875: fnd_message.set_token('REPAIR_LINE_ID',x_product_txn_rec.repair_line_id);
8876: fnd_msg_pub.add;
8877: Raise release_order_excep;
8878: End if;

Line 8875: fnd_message.set_token('REPAIR_LINE_ID',x_product_txn_rec.repair_line_id);

8871: Last_Update_login = Fnd_Global.Login_Id
8872: Where repair_line_id = x_product_txn_rec.repair_line_id;
8873: If sql%notfound then
8874: fnd_message.set_name('CSD','CSD_ERR_REPAIRS_UPDATE');
8875: fnd_message.set_token('REPAIR_LINE_ID',x_product_txn_rec.repair_line_id);
8876: fnd_msg_pub.add;
8877: Raise release_order_excep;
8878: End if;
8879: *****************/

Line 9079: Fnd_Message.SET_NAME('CSD',

9075: -- Display message: Repair Order is in status || l_RO_Status. Default product transaction lines are
9076: -- not created.
9077: -- Message Code CSD_RO_NOT_OPEN_NO_PRODTXN_LINES
9078: -- Raise Error message
9079: Fnd_Message.SET_NAME('CSD',
9080: 'CSD_RO_NOT_OPEN_NO_PRODTXN_LNS');
9081: Fnd_Message.SET_TOKEN('RO_NUMBER', l_RO_Number);
9082: Fnd_Message.SET_TOKEN('RO_STATUS', l_RO_Status_Meaning);
9083: Fnd_Msg_Pub.ADD;

Line 9081: Fnd_Message.SET_TOKEN('RO_NUMBER', l_RO_Number);

9077: -- Message Code CSD_RO_NOT_OPEN_NO_PRODTXN_LINES
9078: -- Raise Error message
9079: Fnd_Message.SET_NAME('CSD',
9080: 'CSD_RO_NOT_OPEN_NO_PRODTXN_LNS');
9081: Fnd_Message.SET_TOKEN('RO_NUMBER', l_RO_Number);
9082: Fnd_Message.SET_TOKEN('RO_STATUS', l_RO_Status_Meaning);
9083: Fnd_Msg_Pub.ADD;
9084: RAISE Fnd_Api.G_EXC_ERROR;
9085: END IF;

Line 9082: Fnd_Message.SET_TOKEN('RO_STATUS', l_RO_Status_Meaning);

9078: -- Raise Error message
9079: Fnd_Message.SET_NAME('CSD',
9080: 'CSD_RO_NOT_OPEN_NO_PRODTXN_LNS');
9081: Fnd_Message.SET_TOKEN('RO_NUMBER', l_RO_Number);
9082: Fnd_Message.SET_TOKEN('RO_STATUS', l_RO_Status_Meaning);
9083: Fnd_Msg_Pub.ADD;
9084: RAISE Fnd_Api.G_EXC_ERROR;
9085: END IF;
9086: -- Check if repair Type Ref is Standard

Line 9091: Fnd_Message.SET_NAME('CSD',

9087: IF l_RO_Repair_Type_Ref = C_Repair_TYpe_Ref_Standard
9088: THEN
9089: -- Display message: Default product transaction lines are not created for standard repair type ref
9090: -- CSD_STD_REP_TYPE_NO_PRODUCTXN_LINES
9091: Fnd_Message.SET_NAME('CSD',
9092: 'CSD_STD_REPTYPE_NO_PRODTXN_LNS');
9093: Fnd_Message.SET_TOKEN('RO_NUMBER', l_RO_Number);
9094: Fnd_Msg_Pub.ADD;
9095: RAISE Fnd_Api.G_EXC_ERROR;

Line 9093: Fnd_Message.SET_TOKEN('RO_NUMBER', l_RO_Number);

9089: -- Display message: Default product transaction lines are not created for standard repair type ref
9090: -- CSD_STD_REP_TYPE_NO_PRODUCTXN_LINES
9091: Fnd_Message.SET_NAME('CSD',
9092: 'CSD_STD_REPTYPE_NO_PRODTXN_LNS');
9093: Fnd_Message.SET_TOKEN('RO_NUMBER', l_RO_Number);
9094: Fnd_Msg_Pub.ADD;
9095: RAISE Fnd_Api.G_EXC_ERROR;
9096: END IF;
9097: -- Check Serial control code if quantity is greater then 1

Line 9112: Fnd_Message.SET_NAME('CSD',

9108: THEN
9109: -- Display Message: RO quantity can not be greater then for serial controlled items.
9110: -- CSD_RO_QTY_MORE_FOR_SERIAL_ITEM
9111: -- Raise G_Exc_Error,
9112: Fnd_Message.SET_NAME('CSD',
9113: 'CSD_RO_QTY_MORE_FOR_SRLCT_ITEM');
9114: Fnd_Msg_Pub.ADD;
9115: RAISE Fnd_Api.G_EXC_ERROR;
9116: END IF;

Line 9134: Fnd_Message.SET_NAME('CSD',

9130: FROM Hr_Organization_Units
9131: WHERE Organization_id =
9132: Cs_Std.Get_Item_Valdn_Orgzn_Id;
9133:
9134: Fnd_Message.SET_NAME('CSD',
9135: 'CSD_NO_ITEM_FOR_SRV_VALDN_ORG');
9136: Fnd_Message.Set_Token('ITEM', l_Item_Name);
9137: Fnd_Message.Set_Token('ORG_NAME',
9138: l_Service_Valdn_Org_Name);

Line 9136: Fnd_Message.Set_Token('ITEM', l_Item_Name);

9132: Cs_Std.Get_Item_Valdn_Orgzn_Id;
9133:
9134: Fnd_Message.SET_NAME('CSD',
9135: 'CSD_NO_ITEM_FOR_SRV_VALDN_ORG');
9136: Fnd_Message.Set_Token('ITEM', l_Item_Name);
9137: Fnd_Message.Set_Token('ORG_NAME',
9138: l_Service_Valdn_Org_Name);
9139: Fnd_Msg_Pub.ADD;
9140: RAISE Fnd_Api.G_EXC_ERROR;

Line 9137: Fnd_Message.Set_Token('ORG_NAME',

9133:
9134: Fnd_Message.SET_NAME('CSD',
9135: 'CSD_NO_ITEM_FOR_SRV_VALDN_ORG');
9136: Fnd_Message.Set_Token('ITEM', l_Item_Name);
9137: Fnd_Message.Set_Token('ORG_NAME',
9138: l_Service_Valdn_Org_Name);
9139: Fnd_Msg_Pub.ADD;
9140: RAISE Fnd_Api.G_EXC_ERROR;
9141:

Line 9156: Fnd_Message.SET_NAME('CSD',

9152: -- Default product transaction lines are not created as product transaction lines exist
9153: -- for Repair Order : l_RO_number
9154: -- CSD_RO_HAS_PRODTXN_LINES
9155: -- RAise G_Exc_Error
9156: Fnd_Message.SET_NAME('CSD',
9157: 'CSD_RO_HAS_PRODUCT_TXN_LINES');
9158: Fnd_Message.SET_TOKEN('RO_NUMBER', l_RO_Number);
9159: Fnd_Msg_Pub.ADD;
9160: RAISE Fnd_Api.G_EXC_ERROR;

Line 9158: Fnd_Message.SET_TOKEN('RO_NUMBER', l_RO_Number);

9154: -- CSD_RO_HAS_PRODTXN_LINES
9155: -- RAise G_Exc_Error
9156: Fnd_Message.SET_NAME('CSD',
9157: 'CSD_RO_HAS_PRODUCT_TXN_LINES');
9158: Fnd_Message.SET_TOKEN('RO_NUMBER', l_RO_Number);
9159: Fnd_Msg_Pub.ADD;
9160: RAISE Fnd_Api.G_EXC_ERROR;
9161: END IF;
9162: END;

Line 9167: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');

9163: EXCEPTION
9164: WHEN NO_DATA_FOUND THEN
9165: -- Message Code CSD_REPAIR_LINE_ID_INVALID
9166: -- Display message; Invalid repair line id is passed
9167: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');
9168: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID', P_Repair_Line_ID);
9169: Fnd_Msg_Pub.ADD;
9170: RAISE Fnd_Api.G_EXC_ERROR;
9171: END;

Line 9168: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID', P_Repair_Line_ID);

9164: WHEN NO_DATA_FOUND THEN
9165: -- Message Code CSD_REPAIR_LINE_ID_INVALID
9166: -- Display message; Invalid repair line id is passed
9167: Fnd_Message.SET_NAME('CSD', 'CSD_API_INV_REP_LINE_ID');
9168: Fnd_Message.SET_TOKEN('REPAIR_LINE_ID', P_Repair_Line_ID);
9169: Fnd_Msg_Pub.ADD;
9170: RAISE Fnd_Api.G_EXC_ERROR;
9171: END;
9172: -- Now call Default Product Txn lines API