eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INL_SHIPMENT_PVT dependencies on INL_SHIP_HOLDS

Line 75: -- Function : Insert errors in INL_SHIP_HOLDS

71: TABLE OF rcv_trx_interface_rec_type INDEX BY BINARY_INTEGER;
72: rcv_trx_interface rcv_trx_interface_tbl;
73: -- Utl name : Handle_ShipError
74: -- Type : Private
75: -- Function : Insert errors in INL_SHIP_HOLDS
76: -- Pre-reqs : None
77: -- Parameters :
78: -- IN : p_ship_header_id IN NUMBER ,
79: -- p_ship_line_id IN NUMBER,

Line 140: l_debug_info := 'Insert error details in inl_ship_holds.';

136: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name,
137: p_procedure_name => l_proc_name) ;
138: -- Initialize return status to success
139: x_return_status := FND_API.G_RET_STS_SUCCESS;
140: l_debug_info := 'Insert error details in inl_ship_holds.';
141: INL_LOGGING_PVT.Log_Statement (
142: p_module_name => g_module_name,
143: p_procedure_name => l_proc_name,
144: p_debug_info => l_debug_info

Line 148: INTO inl_ship_holds

144: p_debug_info => l_debug_info
145: ) ;
146:
147: INSERT
148: INTO inl_ship_holds
149: (
150: ship_hold_id ,
151: ship_header_id ,
152: ship_line_id ,

Line 183: inl_ship_holds_s.NEXTVAL ,

179: request_id
180: )
181: VALUES
182: (
183: inl_ship_holds_s.NEXTVAL ,
184: p_ship_header_id ,
185: p_ship_line_id ,
186: p_table_name ,
187: p_column_name ,

Line 318: DELETE FROM inl_ship_holds WHERE ship_header_id = p_ship_header_id;

314: p_debug_info => l_debug_info
315: ) ;
316:
317: IF p_ship_line_id IS NULL AND p_charge_line_id IS NULL THEN
318: DELETE FROM inl_ship_holds WHERE ship_header_id = p_ship_header_id;
319: ELSE
320: IF p_ship_line_id IS NOT NULL THEN
321: DELETE
322: FROM inl_ship_holds

Line 322: FROM inl_ship_holds

318: DELETE FROM inl_ship_holds WHERE ship_header_id = p_ship_header_id;
319: ELSE
320: IF p_ship_line_id IS NOT NULL THEN
321: DELETE
322: FROM inl_ship_holds
323: WHERE ship_header_id = p_ship_header_id
324: AND ship_line_id = p_ship_line_id;
325: END IF;
326: IF p_charge_line_id IS NOT NULL THEN

Line 328: FROM inl_ship_holds

324: AND ship_line_id = p_ship_line_id;
325: END IF;
326: IF p_charge_line_id IS NOT NULL THEN
327: DELETE
328: FROM inl_ship_holds
329: WHERE ship_header_id = p_ship_header_id
330: AND ship_line_id = p_charge_line_id;
331: END IF;
332: END IF;

Line 1155: -- INCLUDE A LINE IN INL_SHIP_HOLdS

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,
1158: p_charge_line_id => NULL,
1159: p_table_name => 'INL_SHIP_LINES',

Line 1286: -- INCLUDE A LINE IN INL_SHIP_HOLdS

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,
1289: p_charge_line_id => NULL,
1290: p_table_name => 'INL_SHIP_LINES',

Line 1365: --INCLUDE A LINE IN INL_SHIP_HOLdS

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,
1368: p_charge_line_id => NULL,
1369: p_table_name => 'INL_SHIP_LINES',

Line 1555: -- INCLUDE A LINE IN INL_SHIP_HOLdS

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,
1558: p_ship_line_id => p_ship_line_id,
1559: p_charge_line_id => NULL,

Line 1592: -- INCLUDE A LINE IN INL_SHIP_HOLdS

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,
1594: p_ship_line_id => p_ship_line_id,
1595: p_charge_line_id => NULL,
1596: p_table_name => 'INL_SHIP_LINES',

Line 1892: -- INCLUDE A LINE IN INL_SHIP_HOLdS

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,
1895: p_charge_line_id => l_ch_lines_rec.charge_line_id,
1896: p_table_name => 'INL_CHARGE_LINES',

Line 2245: -- INCLUDE A LINE IN INL_SHIP_HOLdS

2241: p_procedure_name => l_proc_name,
2242: p_var_name => 'l_ship_date',
2243: p_var_value => TO_CHAR (l_ship_date)) ;
2244:
2245: -- INCLUDE A LINE IN INL_SHIP_HOLdS
2246: Handle_ShipError ( p_ship_header_id => p_ship_header_id,
2247: p_ship_line_id => NULL,
2248: p_charge_line_id => NULL,
2249: p_table_name => 'INL_SHIP_HEADERS',

Line 2282: -- INCLUDE A LINE IN INL_SHIP_HOLdS

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,
2285: p_charge_line_id => NULL,
2286: p_table_name => 'INL_SHIP_HEADERS',

Line 2525: l_debug_info := 'Reset errors in inl_ship_holds table';

2521:
2522: -- Initialize API return status to success
2523: x_return_status := FND_API.G_RET_STS_SUCCESS;
2524:
2525: l_debug_info := 'Reset errors in inl_ship_holds table';
2526: INL_LOGGING_PVT.Log_Statement ( p_module_name => g_module_name,
2527: p_procedure_name => l_api_name,
2528: p_debug_info => l_debug_info) ;
2529: Reset_ShipError ( p_ship_header_id => p_ship_header_id,