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 91: -- Function : Insert errors in INL_SHIP_HOLDS

87: --Bug#13987019 END
88: */
89: -- Utl name : Handle_ShipError
90: -- Type : Private
91: -- Function : Insert errors in INL_SHIP_HOLDS
92: -- Pre-reqs : None
93: -- Parameters :
94: -- IN : p_ship_header_id IN NUMBER ,
95: -- p_ship_line_id IN NUMBER,

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

151: INL_LOGGING_PVT.Log_BeginProc ( p_module_name => g_module_name,
152: p_procedure_name => l_program_name) ;
153: -- Initialize return status to success
154: x_return_status := L_FND_RET_STS_SUCCESS;
155: l_debug_info := 'Insert error details in inl_ship_holds.';
156: INL_LOGGING_PVT.Log_Statement (
157: p_module_name => g_module_name,
158: p_procedure_name => l_program_name,
159: p_debug_info => l_debug_info

Line 162: INTO inl_ship_holds

158: p_procedure_name => l_program_name,
159: p_debug_info => l_debug_info
160: ) ;
161: INSERT
162: INTO inl_ship_holds
163: (
164: ship_hold_id , /* 01 */
165: ship_header_id , /* 02 */
166: ship_line_id , /* 03 */

Line 197: inl_ship_holds_s.NEXTVAL , /* 01 */

193: request_id /* 30 */
194: )
195: VALUES
196: (
197: inl_ship_holds_s.NEXTVAL , /* 01 */
198: p_ship_header_id , /* 02 */
199: p_ship_line_id , /* 03 */
200: p_table_name , /* 04 */
201: p_column_name , /* 05 */

Line 305: DELETE FROM inl_ship_holds

301: p_procedure_name => l_program_name,
302: p_debug_info => l_debug_info
303: ) ;
304: IF p_ship_line_id IS NULL AND p_charge_line_id IS NULL THEN
305: DELETE FROM inl_ship_holds
306: WHERE ship_header_id = p_ship_header_id;
307: ELSE
308: IF p_ship_line_id IS NOT NULL THEN
309: DELETE

Line 310: FROM inl_ship_holds

306: WHERE ship_header_id = p_ship_header_id;
307: ELSE
308: IF p_ship_line_id IS NOT NULL THEN
309: DELETE
310: FROM inl_ship_holds
311: WHERE ship_header_id = p_ship_header_id
312: AND ship_line_id = p_ship_line_id;
313: END IF;
314: IF p_charge_line_id IS NOT NULL THEN

Line 316: FROM inl_ship_holds

312: AND ship_line_id = p_ship_line_id;
313: END IF;
314: IF p_charge_line_id IS NOT NULL THEN
315: DELETE
316: FROM inl_ship_holds
317: WHERE ship_header_id = p_ship_header_id
318: AND ship_line_id = p_charge_line_id;
319: END IF;
320: END IF;

Line 1329: -- INCLUDE A LINE IN INL_SHIP_HOLdS

1325: IF NVL (p_primary_qty, 0) = 0 THEN
1326: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_SHIP_LN_QTY_ZERO') ;
1327: FND_MESSAGE.SET_TOKEN ('SHIP_LINE_NUM', p_ship_line_num) ;
1328: FND_MSG_PUB.ADD;
1329: -- INCLUDE A LINE IN INL_SHIP_HOLdS
1330: Handle_ShipError (
1331: p_ship_header_id => p_ship_header_id,
1332: p_ship_line_id => p_ship_line_id,
1333: p_charge_line_id => NULL,

Line 1489: -- INCLUDE A LINE IN INL_SHIP_HOLdS

1485: FND_MESSAGE.SET_TOKEN ('SHIP_LINE_NUM', p_ship_line_num) ;
1486: FND_MESSAGE.SET_TOKEN ('QTY', l_msg_tolerable_qty) ;
1487: FND_MESSAGE.SET_TOKEN ('UOM', l_msg_uom_tl) ;
1488: FND_MSG_PUB.ADD;
1489: -- INCLUDE A LINE IN INL_SHIP_HOLdS
1490: Handle_ShipError (
1491: p_ship_header_id => p_ship_header_id,
1492: p_ship_line_id => p_ship_line_id,
1493: p_charge_line_id => NULL,

Line 1615: --INCLUDE A LINE IN INL_SHIP_HOLdS

1611: FND_MSG_PUB.ADD;*/
1612:
1613:
1614:
1615: --INCLUDE A LINE IN INL_SHIP_HOLdS
1616: Handle_ShipError (
1617: p_ship_header_id => p_ship_header_id,
1618: p_ship_line_id => p_ship_line_id,
1619: p_charge_line_id => NULL,

Line 1954: -- INCLUDE A LINE IN INL_SHIP_HOLdS

1950: x_return_validation_status := 'FALSE'; -- SCM-051
1951: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_NOT_DEF_PO_PRICE_TOLER') ;
1952: FND_MESSAGE.SET_TOKEN ('SHIPLN_NUM', p_ship_line_num) ;
1953: FND_MSG_PUB.ADD;
1954: -- INCLUDE A LINE IN INL_SHIP_HOLdS
1955: Handle_ShipError (
1956: p_ship_header_id => p_ship_header_id,
1957: p_ship_line_id => p_ship_line_id,
1958: p_charge_line_id => NULL,

Line 1992: -- INCLUDE A LINE IN INL_SHIP_HOLdS

1988: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_PO_PRICE_TOLER') ;
1989: FND_MESSAGE.SET_TOKEN ('SHIPLN_NUM', p_ship_line_num) ;
1990: FND_MESSAGE.SET_TOKEN ('TOLER', l_po_price_toler_perc) ;
1991: FND_MSG_PUB.ADD;
1992: -- INCLUDE A LINE IN INL_SHIP_HOLdS
1993: Handle_ShipError (
1994: p_ship_header_id => p_ship_header_id,
1995: p_ship_line_id => p_ship_line_id,
1996: p_charge_line_id => NULL,

Line 2531: -- INCLUDE A LINE IN INL_SHIP_HOLdS

2527: IF l_ch_lines_rec.currency_code <> p_functional_currency_code AND p_foreign_currency_flag = 'N' THEN
2528: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_FRGN_CUR') ;
2529: FND_MESSAGE.SET_TOKEN ('CLNUM', l_ch_lines_rec.charge_line_num) ;
2530: FND_MSG_PUB.ADD;
2531: -- INCLUDE A LINE IN INL_SHIP_HOLdS
2532: Handle_ShipError (
2533: p_ship_header_id => p_ship_header_id,
2534: p_ship_line_id => NULL,
2535: p_charge_line_id => l_ch_lines_rec.charge_line_id,

Line 2656: -- INCLUDE A LINE IN INL_SHIP_HOLdS

2652: FND_MESSAGE.SET_TOKEN ('SHIPLN_NUM', p_ship_line_num) ;
2653: FND_MESSAGE.SET_TOKEN ('LCM_OPUNIT', l_lcm_org_name) ;
2654: FND_MESSAGE.SET_TOKEN ('PO_OPUNIT', l_po_org_name) ;
2655: FND_MSG_PUB.ADD;
2656: -- INCLUDE A LINE IN INL_SHIP_HOLdS
2657: Handle_ShipError (
2658: p_ship_header_id => p_ship_header_id,
2659: p_ship_line_id => p_ship_line_id,
2660: p_charge_line_id => NULL,

Line 2782: -- INCLUDE A LINE IN INL_SHIP_HOLDS

2778: FND_MESSAGE.SET_TOKEN ('GROUP_REF', p_group_reference) ;
2779: FND_MESSAGE.SET_TOKEN ('PARTY_SITE', p_party_site_name) ;
2780: FND_MESSAGE.SET_TOKEN ('SHIP_TYPE', p_ship_type_code) ;
2781: FND_MSG_PUB.ADD;
2782: -- INCLUDE A LINE IN INL_SHIP_HOLDS
2783: Handle_ShipError (
2784: p_ship_header_id => p_ship_header_id,
2785: p_ship_line_id => NULL,
2786: p_charge_line_id => NULL,

Line 3496: -- INCLUDE A LINE IN INL_SHIP_HOLDS

3492: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_ASSOC_ALLOC_FLAG_DISAB') ;
3493: FND_MESSAGE.SET_TOKEN ('SHIPLN_NUM', p_ship_line_num) ;
3494: FND_MESSAGE.SET_TOKEN ('SHIPLN_TYPE', p_ship_line_type_code) ;
3495: FND_MSG_PUB.ADD;
3496: -- INCLUDE A LINE IN INL_SHIP_HOLDS
3497: Handle_ShipError (
3498: p_ship_header_id => p_ship_header_id,
3499: p_ship_line_id => p_ship_line_id,
3500: p_charge_line_id => NULL,

Line 3705: -- INCLUDE A LINE IN INL_SHIP_HOLdS

3701: p_module_name => g_module_name,
3702: p_procedure_name => l_program_name,
3703: p_var_name => 'l_ship_lines_rec.ship_line_source_id',
3704: p_var_value => l_ship_lines_rec.ship_line_source_id) ;
3705: -- INCLUDE A LINE IN INL_SHIP_HOLdS
3706: Handle_ShipError (
3707: p_ship_header_id => p_ship_header_id,
3708: p_ship_line_id => NULL,
3709: p_charge_line_id => NULL,

Line 3993: -- INCLUDE A LINE IN INL_SHIP_HOLdS

3989: p_module_name => g_module_name,
3990: p_procedure_name => l_program_name,
3991: p_var_name => 'l_ship_date',
3992: p_var_value => TO_CHAR (l_ship_date)) ;
3993: -- INCLUDE A LINE IN INL_SHIP_HOLdS
3994: Handle_ShipError (
3995: p_ship_header_id => p_ship_header_id,
3996: p_ship_line_id => NULL,
3997: p_charge_line_id => NULL,

Line 4060: -- INCLUDE A LINE IN INL_SHIP_HOLdS

4056: p_module_name => g_module_name,
4057: p_procedure_name => l_program_name,
4058: p_var_name => 'l_ship_date',
4059: p_var_value => TO_CHAR (l_ship_date)) ;
4060: -- INCLUDE A LINE IN INL_SHIP_HOLdS
4061: Handle_ShipError (
4062: p_ship_header_id => p_ship_header_id,
4063: p_ship_line_id => NULL,
4064: p_charge_line_id => NULL,

Line 4102: -- INCLUDE A LINE IN INL_SHIP_HOLDS

4098: IF l_group_line_num IS NOT NULL THEN
4099: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_NO_SHIP_LN_GRP_NUM');
4100: FND_MESSAGE.SET_TOKEN('LINE_GROUP_NUM',l_group_line_num);
4101: FND_MSG_PUB.ADD;
4102: -- INCLUDE A LINE IN INL_SHIP_HOLDS
4103: Handle_ShipError (
4104: p_ship_header_id => p_ship_header_id,
4105: p_ship_line_id => NULL,
4106: p_charge_line_id => NULL,

Line 4134: -- INCLUDE A LINE IN INL_SHIP_HOLDS

4130: END IF;
4131: ELSE -- Bug 12630218 Shipment has no Group Lines
4132: FND_MESSAGE.SET_NAME ('INL', 'INL_ERR_CHK_NO_SHIP_LN');
4133: FND_MSG_PUB.ADD;
4134: -- INCLUDE A LINE IN INL_SHIP_HOLDS
4135: Handle_ShipError (
4136: p_ship_header_id => p_ship_header_id,
4137: p_ship_line_id => NULL,
4138: p_charge_line_id => NULL,

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

4406: RAISE L_FND_EXC_UNEXPECTED_ERROR;
4407: END IF;
4408: -- Initialize API return status to success
4409: x_return_status := L_FND_RET_STS_SUCCESS;
4410: l_debug_info := 'Reset errors in inl_ship_holds table';
4411: INL_LOGGING_PVT.Log_Statement (
4412: p_module_name => g_module_name,
4413: p_procedure_name => l_api_name,
4414: p_debug_info => l_debug_info