DBA Data[Home] [Help]

APPS.INL_SHIPMENT_PVT dependencies on FND_MESSAGE

Line 1152: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_SHIP_LN_QTY_ZERO') ;

1148: -- Initialize API return status to success
1149: x_return_status := FND_API.G_RET_STS_SUCCESS;
1150: -- Check if primary qty is ZERO
1151: IF NVL (p_primary_qty, 0) = 0 THEN
1152: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_SHIP_LN_QTY_ZERO') ;
1153: FND_MESSAGE.SET_TOKEN ('SHIP_LINE_NUM', p_ship_line_num) ;
1154: FND_MSG_PUB.ADD;
1155: -- INCLUDE A LINE IN INL_SHIP_HOLdS
1156: Handle_ShipError ( p_ship_header_id => p_ship_header_id,

Line 1153: FND_MESSAGE.SET_TOKEN ('SHIP_LINE_NUM', p_ship_line_num) ;

1149: x_return_status := FND_API.G_RET_STS_SUCCESS;
1150: -- Check if primary qty is ZERO
1151: IF NVL (p_primary_qty, 0) = 0 THEN
1152: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_SHIP_LN_QTY_ZERO') ;
1153: FND_MESSAGE.SET_TOKEN ('SHIP_LINE_NUM', p_ship_line_num) ;
1154: FND_MSG_PUB.ADD;
1155: -- INCLUDE A LINE IN INL_SHIP_HOLdS
1156: Handle_ShipError ( p_ship_header_id => p_ship_header_id,
1157: p_ship_line_id => p_ship_line_id,

Line 1270: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_SHIP_LN_QTY_TOL_S') ;

1266: WHERE pll.line_location_id = p_ship_line_src_id;
1267: END IF;
1268: IF l_acpt_qty = 'N' THEN
1269: IF (l_shipln_duplicated = TRUE) THEN
1270: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_SHIP_LN_QTY_TOL_S') ;
1271: ELSE
1272: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_SHIP_LN_QTY_TOL') ;
1273: END IF;
1274:

Line 1272: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_SHIP_LN_QTY_TOL') ;

1268: IF l_acpt_qty = 'N' THEN
1269: IF (l_shipln_duplicated = TRUE) THEN
1270: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_SHIP_LN_QTY_TOL_S') ;
1271: ELSE
1272: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_SHIP_LN_QTY_TOL') ;
1273: END IF;
1274:
1275: -- Get the Primary Unit of Measure Description that will be
1276: -- used as the token for the over tolerance error message.

Line 1282: FND_MESSAGE.SET_TOKEN ('SHIP_LINE_NUM', p_ship_line_num) ;

1278: INTO l_primary_uom_tl
1279: FROM mtl_units_of_measure_vl
1280: WHERE uom_code = p_primary_uom_code;
1281:
1282: FND_MESSAGE.SET_TOKEN ('SHIP_LINE_NUM', p_ship_line_num) ;
1283: FND_MESSAGE.SET_TOKEN ('QTY', x_tolerable_quantity) ;
1284: FND_MESSAGE.SET_TOKEN ('UOM', l_primary_uom_tl) ;
1285: FND_MSG_PUB.ADD;
1286: -- INCLUDE A LINE IN INL_SHIP_HOLdS

Line 1283: FND_MESSAGE.SET_TOKEN ('QTY', x_tolerable_quantity) ;

1279: FROM mtl_units_of_measure_vl
1280: WHERE uom_code = p_primary_uom_code;
1281:
1282: FND_MESSAGE.SET_TOKEN ('SHIP_LINE_NUM', p_ship_line_num) ;
1283: FND_MESSAGE.SET_TOKEN ('QTY', x_tolerable_quantity) ;
1284: FND_MESSAGE.SET_TOKEN ('UOM', l_primary_uom_tl) ;
1285: FND_MSG_PUB.ADD;
1286: -- INCLUDE A LINE IN INL_SHIP_HOLdS
1287: Handle_ShipError ( p_ship_header_id => p_ship_header_id,

Line 1284: FND_MESSAGE.SET_TOKEN ('UOM', l_primary_uom_tl) ;

1280: WHERE uom_code = p_primary_uom_code;
1281:
1282: FND_MESSAGE.SET_TOKEN ('SHIP_LINE_NUM', p_ship_line_num) ;
1283: FND_MESSAGE.SET_TOKEN ('QTY', x_tolerable_quantity) ;
1284: FND_MESSAGE.SET_TOKEN ('UOM', l_primary_uom_tl) ;
1285: FND_MSG_PUB.ADD;
1286: -- INCLUDE A LINE IN INL_SHIP_HOLdS
1287: Handle_ShipError ( p_ship_header_id => p_ship_header_id,
1288: p_ship_line_id => p_ship_line_id,

Line 1359: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_SHIP_LN_QTY_OTH_L') ;

1355: )
1356: LOOP
1357: l_msg := ', '||c_ship_num.ship_num;
1358: END LOOP;
1359: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_SHIP_LN_QTY_OTH_L') ;
1360: FND_MESSAGE.SET_TOKEN ('SRC_TYPE', p_ship_line_src_type_code) ;
1361: FND_MESSAGE.SET_TOKEN ('QTY', x_tolerable_quantity) ;
1362: FND_MESSAGE.SET_TOKEN ('UOM', x_unit_of_measure) ;
1363: FND_MESSAGE.SET_TOKEN ('SHIPHS', SUBSTR (l_msg, 3)) ;

Line 1360: FND_MESSAGE.SET_TOKEN ('SRC_TYPE', p_ship_line_src_type_code) ;

1356: LOOP
1357: l_msg := ', '||c_ship_num.ship_num;
1358: END LOOP;
1359: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_SHIP_LN_QTY_OTH_L') ;
1360: FND_MESSAGE.SET_TOKEN ('SRC_TYPE', p_ship_line_src_type_code) ;
1361: FND_MESSAGE.SET_TOKEN ('QTY', x_tolerable_quantity) ;
1362: FND_MESSAGE.SET_TOKEN ('UOM', x_unit_of_measure) ;
1363: FND_MESSAGE.SET_TOKEN ('SHIPHS', SUBSTR (l_msg, 3)) ;
1364: FND_MSG_PUB.ADD;

Line 1361: FND_MESSAGE.SET_TOKEN ('QTY', x_tolerable_quantity) ;

1357: l_msg := ', '||c_ship_num.ship_num;
1358: END LOOP;
1359: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_SHIP_LN_QTY_OTH_L') ;
1360: FND_MESSAGE.SET_TOKEN ('SRC_TYPE', p_ship_line_src_type_code) ;
1361: FND_MESSAGE.SET_TOKEN ('QTY', x_tolerable_quantity) ;
1362: FND_MESSAGE.SET_TOKEN ('UOM', x_unit_of_measure) ;
1363: FND_MESSAGE.SET_TOKEN ('SHIPHS', SUBSTR (l_msg, 3)) ;
1364: FND_MSG_PUB.ADD;
1365: --INCLUDE A LINE IN INL_SHIP_HOLdS

Line 1362: FND_MESSAGE.SET_TOKEN ('UOM', x_unit_of_measure) ;

1358: END LOOP;
1359: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_SHIP_LN_QTY_OTH_L') ;
1360: FND_MESSAGE.SET_TOKEN ('SRC_TYPE', p_ship_line_src_type_code) ;
1361: FND_MESSAGE.SET_TOKEN ('QTY', x_tolerable_quantity) ;
1362: FND_MESSAGE.SET_TOKEN ('UOM', x_unit_of_measure) ;
1363: FND_MESSAGE.SET_TOKEN ('SHIPHS', SUBSTR (l_msg, 3)) ;
1364: FND_MSG_PUB.ADD;
1365: --INCLUDE A LINE IN INL_SHIP_HOLdS
1366: Handle_ShipError ( p_ship_header_id => p_ship_header_id,

Line 1363: FND_MESSAGE.SET_TOKEN ('SHIPHS', SUBSTR (l_msg, 3)) ;

1359: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_SHIP_LN_QTY_OTH_L') ;
1360: FND_MESSAGE.SET_TOKEN ('SRC_TYPE', p_ship_line_src_type_code) ;
1361: FND_MESSAGE.SET_TOKEN ('QTY', x_tolerable_quantity) ;
1362: FND_MESSAGE.SET_TOKEN ('UOM', x_unit_of_measure) ;
1363: FND_MESSAGE.SET_TOKEN ('SHIPHS', SUBSTR (l_msg, 3)) ;
1364: FND_MSG_PUB.ADD;
1365: --INCLUDE A LINE IN INL_SHIP_HOLdS
1366: Handle_ShipError ( p_ship_header_id => p_ship_header_id,
1367: p_ship_line_id => p_ship_line_id,

Line 1552: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_NOT_DEF_PO_PRICE_TOLER') ;

1548: -- Organization, the Shipment Line price is validated
1549: -- to be the same price defined in PO.
1550: IF l_po_price_toler_perc IS NULL THEN
1551: IF (l_p_converted_PUP > l_po_converted_price) THEN
1552: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_NOT_DEF_PO_PRICE_TOLER') ;
1553: FND_MESSAGE.SET_TOKEN ('SHIPLN_NUM', p_ship_line_num) ;
1554: FND_MSG_PUB.ADD;
1555: -- INCLUDE A LINE IN INL_SHIP_HOLdS
1556:

Line 1553: FND_MESSAGE.SET_TOKEN ('SHIPLN_NUM', p_ship_line_num) ;

1549: -- to be the same price defined in PO.
1550: IF l_po_price_toler_perc IS NULL THEN
1551: IF (l_p_converted_PUP > l_po_converted_price) THEN
1552: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_NOT_DEF_PO_PRICE_TOLER') ;
1553: FND_MESSAGE.SET_TOKEN ('SHIPLN_NUM', p_ship_line_num) ;
1554: FND_MSG_PUB.ADD;
1555: -- INCLUDE A LINE IN INL_SHIP_HOLdS
1556:
1557: Handle_ShipError ( p_ship_header_id => p_ship_header_id,

Line 1587: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_PO_PRICE_TOLER') ;

1583: l_actual_price_dif := NVL (l_p_converted_PUP, 0) - NVL (l_po_converted_price, 0) ;
1584: IF l_actual_price_dif > 0 THEN
1585: l_tolerable_dif := (l_po_converted_price / 100) * l_po_price_toler_perc;
1586: IF (l_actual_price_dif > l_tolerable_dif) THEN
1587: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_PO_PRICE_TOLER') ;
1588: FND_MESSAGE.SET_TOKEN ('SHIPLN_NUM', p_ship_line_num) ;
1589: FND_MESSAGE.SET_TOKEN ('TOLER', l_po_price_toler_perc) ;
1590: FND_MSG_PUB.ADD;
1591:

Line 1588: FND_MESSAGE.SET_TOKEN ('SHIPLN_NUM', p_ship_line_num) ;

1584: IF l_actual_price_dif > 0 THEN
1585: l_tolerable_dif := (l_po_converted_price / 100) * l_po_price_toler_perc;
1586: IF (l_actual_price_dif > l_tolerable_dif) THEN
1587: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_PO_PRICE_TOLER') ;
1588: FND_MESSAGE.SET_TOKEN ('SHIPLN_NUM', p_ship_line_num) ;
1589: FND_MESSAGE.SET_TOKEN ('TOLER', l_po_price_toler_perc) ;
1590: FND_MSG_PUB.ADD;
1591:
1592: -- INCLUDE A LINE IN INL_SHIP_HOLdS

Line 1589: FND_MESSAGE.SET_TOKEN ('TOLER', l_po_price_toler_perc) ;

1585: l_tolerable_dif := (l_po_converted_price / 100) * l_po_price_toler_perc;
1586: IF (l_actual_price_dif > l_tolerable_dif) THEN
1587: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_PO_PRICE_TOLER') ;
1588: FND_MESSAGE.SET_TOKEN ('SHIPLN_NUM', p_ship_line_num) ;
1589: FND_MESSAGE.SET_TOKEN ('TOLER', l_po_price_toler_perc) ;
1590: FND_MSG_PUB.ADD;
1591:
1592: -- INCLUDE A LINE IN INL_SHIP_HOLdS
1593: Handle_ShipError ( p_ship_header_id => p_ship_header_id,

Line 1889: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_FRGN_CUR') ;

1885: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
1886: p_procedure_name => l_proc_name,
1887: p_debug_info => l_debug_info) ;
1888: IF l_ch_lines_rec.currency_code <> p_functional_currency_code AND p_foreign_currency_flag = 'N' THEN
1889: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_FRGN_CUR') ;
1890: FND_MESSAGE.SET_TOKEN ('CLNUM', l_ch_lines_rec.charge_line_num) ;
1891: FND_MSG_PUB.ADD;
1892: -- INCLUDE A LINE IN INL_SHIP_HOLdS
1893: Handle_ShipError ( p_ship_header_id => p_ship_header_id,

Line 1890: FND_MESSAGE.SET_TOKEN ('CLNUM', l_ch_lines_rec.charge_line_num) ;

1886: p_procedure_name => l_proc_name,
1887: p_debug_info => l_debug_info) ;
1888: IF l_ch_lines_rec.currency_code <> p_functional_currency_code AND p_foreign_currency_flag = 'N' THEN
1889: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_FRGN_CUR') ;
1890: FND_MESSAGE.SET_TOKEN ('CLNUM', l_ch_lines_rec.charge_line_num) ;
1891: FND_MSG_PUB.ADD;
1892: -- INCLUDE A LINE IN INL_SHIP_HOLdS
1893: Handle_ShipError ( p_ship_header_id => p_ship_header_id,
1894: p_ship_line_id => NULL,

Line 2232: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_INV_SHIP_DATE') ;

2228: IF Validate_InvOpenPeriod ( x_trx_date => TO_CHAR (l_ship_date, 'YYYY-MM-DD'),
2229: x_sob_id => l_sob_id,
2230: x_org_id => l_inv_org_id,
2231: x_return_status => l_return_status) = 'FALSE' THEN
2232: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_INV_SHIP_DATE') ;
2233: FND_MESSAGE.SET_TOKEN ('SHIP_DATE', TO_CHAR (l_ship_date)) ;
2234: FND_MSG_PUB.ADD;
2235:
2236: l_debug_info := 'Transaction period is not open in Inventory.';

Line 2233: FND_MESSAGE.SET_TOKEN ('SHIP_DATE', TO_CHAR (l_ship_date)) ;

2229: x_sob_id => l_sob_id,
2230: x_org_id => l_inv_org_id,
2231: x_return_status => l_return_status) = 'FALSE' THEN
2232: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_INV_SHIP_DATE') ;
2233: FND_MESSAGE.SET_TOKEN ('SHIP_DATE', TO_CHAR (l_ship_date)) ;
2234: FND_MSG_PUB.ADD;
2235:
2236: l_debug_info := 'Transaction period is not open in Inventory.';
2237: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_pkg_name,

Line 2280: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_NO_SHIP_LN') ;

2276: p_procedure_name => l_proc_name,
2277: p_debug_info => l_debug_info) ;
2278:
2279: IF (NOT Has_ShipLine (p_ship_header_id)) THEN
2280: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_NO_SHIP_LN') ;
2281: FND_MSG_PUB.ADD;
2282: -- INCLUDE A LINE IN INL_SHIP_HOLdS
2283: Handle_ShipError ( p_ship_header_id => p_ship_header_id,
2284: p_ship_line_id => NULL,

Line 6862: FND_MESSAGE.SET_NAME ('INL', 'INL_UNEXPECTED_ERR') ;

6858: END IF;
6859: ELSIF (r_affected_ship.ship_status = 'COMPLETED') THEN
6860: Update_PendingMatchingFlag (r_affected_ship.ship_header_id, 'Y', l_return_status) ;
6861: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6862: FND_MESSAGE.SET_NAME ('INL', 'INL_UNEXPECTED_ERR') ;
6863: FND_MSG_PUB.ADD;
6864: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
6865: RAISE FND_API.G_EXC_ERROR;
6866: ELSE