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_LANDEDCOST_PUB dependencies on INL_LOGGING_PVT

Line 86: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,

82:
83: BEGIN
84:
85: -- Standard Beginning of Procedure/Function Logging
86: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
87: p_procedure_name => l_proc_name);
88: -- Standard Start of API savepoint
89: SAVEPOINT Get_LandedCost_PVT2;
90:

Line 111: INL_LOGGING_PVT.Log_Statement (

107: x_return_status := FND_API.G_RET_STS_SUCCESS;
108:
109: BEGIN
110: l_debug_info := 'Get landed cost info for ship_header_id: ' || p_ship_header_id;
111: INL_LOGGING_PVT.Log_Statement (
112: p_module_name => g_module_name,
113: p_procedure_name => l_proc_name,
114: p_debug_info => l_debug_info);
115:

Line 121: INL_LOGGING_PVT.Log_Statement (

117: FETCH c_landed_cost BULK COLLECT INTO l_landed_cost_lst;
118: CLOSE c_landed_cost;
119:
120: l_debug_info := l_landed_cost_lst.LAST||' line(s) have been retrieved (l_landed_cost_lst).';
121: INL_LOGGING_PVT.Log_Statement (
122: p_module_name => g_module_name,
123: p_procedure_name => l_proc_name,
124: p_debug_info => l_debug_info
125: ) ;

Line 130: INL_LOGGING_PVT.Log_Variable (

126: IF NVL (l_landed_cost_lst.LAST, 0) > 0 THEN
127:
128: FOR j IN NVL (l_landed_cost_lst.FIRST, 0)..NVL (l_landed_cost_lst.LAST, 0)
129: LOOP
130: INL_LOGGING_PVT.Log_Variable (
131: p_module_name => g_module_name,
132: p_procedure_name => l_proc_name,
133: p_var_name => 'l_landed_cost_lst('||j||').parent_ship_line_id',
134: p_var_value => l_landed_cost_lst(j).parent_ship_line_id

Line 141: INL_LOGGING_PVT.Log_Variable (

137: OR NVL(x_landed_cost_tbl(l_lc_ln_index).ship_line_id,-1) <> l_landed_cost_lst(j).parent_ship_line_id
138: THEN
139: l_first_ln := 1;
140: l_lc_ln_index:=l_lc_ln_index+1;
141: INL_LOGGING_PVT.Log_Variable (
142: p_module_name => g_module_name,
143: p_procedure_name => l_proc_name,
144: p_var_name => 'l_lc_ln_index',
145: p_var_value => l_lc_ln_index

Line 147: INL_LOGGING_PVT.Log_Variable (

143: p_procedure_name => l_proc_name,
144: p_var_name => 'l_lc_ln_index',
145: p_var_value => l_lc_ln_index
146: ) ;
147: INL_LOGGING_PVT.Log_Variable (
148: p_module_name => g_module_name,
149: p_procedure_name => l_proc_name,
150: p_var_name => 'l_landed_cost_lst('||j||').parent_ship_line_id',
151: p_var_value => l_landed_cost_lst(j).parent_ship_line_id

Line 168: INL_LOGGING_PVT.Log_Variable (

164: x_landed_cost_tbl(l_lc_ln_index).actual_charges := 0;
165: x_landed_cost_tbl(l_lc_ln_index).actual_taxes := 0;
166: x_landed_cost_tbl(l_lc_ln_index).actual_unit_landed_cost := 0;
167: END IF;
168: INL_LOGGING_PVT.Log_Variable (
169: p_module_name => g_module_name,
170: p_procedure_name => l_proc_name,
171: p_var_name => 'l_landed_cost_lst('||j||').component_type',
172: p_var_value => l_landed_cost_lst(j).component_type

Line 174: INL_LOGGING_PVT.Log_Variable (

170: p_procedure_name => l_proc_name,
171: p_var_name => 'l_landed_cost_lst('||j||').component_type',
172: p_var_value => l_landed_cost_lst(j).component_type
173: ) ;
174: INL_LOGGING_PVT.Log_Variable (
175: p_module_name => g_module_name,
176: p_procedure_name => l_proc_name,
177: p_var_name => 'l_landed_cost_lst('||j||').ELC',
178: p_var_value => l_landed_cost_lst(j).ELC

Line 180: INL_LOGGING_PVT.Log_Variable (

176: p_procedure_name => l_proc_name,
177: p_var_name => 'l_landed_cost_lst('||j||').ELC',
178: p_var_value => l_landed_cost_lst(j).ELC
179: ) ;
180: INL_LOGGING_PVT.Log_Variable (
181: p_module_name => g_module_name,
182: p_procedure_name => l_proc_name,
183: p_var_name => 'l_landed_cost_lst('||j||').ALC',
184: p_var_value => l_landed_cost_lst(j).ALC

Line 210: INL_LOGGING_PVT.Log_Statement (

206:
207: x_landed_cost_tbl(l_lc_ln_index).actual_taxes :=
208: x_landed_cost_tbl(l_lc_ln_index).actual_taxes + NVL(l_landed_cost_lst(j).ALC,0);
209: ELSE
210: INL_LOGGING_PVT.Log_Statement (
211: p_module_name => g_module_name,
212: p_procedure_name => l_proc_name,
213: p_debug_info => 'unexpected component_type: '||l_landed_cost_lst(j).component_type);
214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 220: INL_LOGGING_PVT.Log_Statement

216: END LOOP;
217: END IF;
218: END;
219: l_debug_info := 'End Loop ';
220: INL_LOGGING_PVT.Log_Statement
221: (p_module_name => g_module_name,
222: p_procedure_name => l_proc_name,
223: p_debug_info => l_debug_info);
224:

Line 237: INL_LOGGING_PVT.Log_EndProc (

233: p_count => x_msg_count,
234: p_data => x_msg_data);
235:
236: -- Standard End of Procedure/Function Logging
237: INL_LOGGING_PVT.Log_EndProc (
238: p_module_name => g_module_name,
239: p_procedure_name => l_proc_name);
240: EXCEPTION
241: WHEN FND_API.G_EXC_ERROR THEN

Line 242: INL_LOGGING_PVT.Log_Statement

238: p_module_name => g_module_name,
239: p_procedure_name => l_proc_name);
240: EXCEPTION
241: WHEN FND_API.G_EXC_ERROR THEN
242: INL_LOGGING_PVT.Log_Statement
243: (p_module_name => g_module_name,
244: p_procedure_name => l_proc_name,
245: p_debug_info => 'G_EXC_ERROR:'||SQLERRM);
246: -- Standard Expected Error Logging

Line 247: INL_LOGGING_PVT.Log_ExpecError (

243: (p_module_name => g_module_name,
244: p_procedure_name => l_proc_name,
245: p_debug_info => 'G_EXC_ERROR:'||SQLERRM);
246: -- Standard Expected Error Logging
247: INL_LOGGING_PVT.Log_ExpecError (
248: p_module_name => g_module_name,
249: p_procedure_name => l_proc_name);
250: ROLLBACK TO Get_LandedCost_PVT2;
251: x_return_status := FND_API.G_RET_STS_ERROR;

Line 257: INL_LOGGING_PVT.Log_Statement

253: p_encoded => FND_API.g_false,
254: p_count => x_msg_count,
255: p_data => x_msg_data);
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
257: INL_LOGGING_PVT.Log_Statement
258: (p_module_name => g_module_name,
259: p_procedure_name => l_proc_name,
260: p_debug_info => 'G_EXC_UNEXPECTED_ERROR:'||SQLERRM);
261: -- Standard Unexpected Error Logging

Line 262: INL_LOGGING_PVT.Log_UnexpecError (

258: (p_module_name => g_module_name,
259: p_procedure_name => l_proc_name,
260: p_debug_info => 'G_EXC_UNEXPECTED_ERROR:'||SQLERRM);
261: -- Standard Unexpected Error Logging
262: INL_LOGGING_PVT.Log_UnexpecError (
263: p_module_name => g_module_name,
264: p_procedure_name => l_proc_name);
265: ROLLBACK TO Get_LandedCost_PVT2;
266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 272: INL_LOGGING_PVT.Log_Statement

268: p_encoded => FND_API.g_false,
269: p_count => x_msg_count,
270: p_data => x_msg_data);
271: WHEN OTHERS THEN
272: INL_LOGGING_PVT.Log_Statement
273: (p_module_name => g_module_name,
274: p_procedure_name => l_proc_name,
275: p_debug_info => 'OTHERS:'||SQLERRM);
276: -- Standard Unexpected Error Logging

Line 277: INL_LOGGING_PVT.Log_UnexpecError (

273: (p_module_name => g_module_name,
274: p_procedure_name => l_proc_name,
275: p_debug_info => 'OTHERS:'||SQLERRM);
276: -- Standard Unexpected Error Logging
277: INL_LOGGING_PVT.Log_UnexpecError (
278: p_module_name => g_module_name,
279: p_procedure_name => l_proc_name);
280: ROLLBACK TO Get_LandedCost_PVT2;
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 395: INL_LOGGING_PVT.Log_BeginProc (

391:
392: BEGIN
393:
394: -- Standard Beginning of Procedure/Function Logging
395: INL_LOGGING_PVT.Log_BeginProc (
396: p_module_name => g_module_name,
397: p_procedure_name => l_proc_name
398: );
399: -- Standard Start of API savepoint

Line 422: INL_LOGGING_PVT.Log_Statement (

418: x_return_status := FND_API.G_RET_STS_SUCCESS;
419:
420: BEGIN
421: l_debug_info := 'Get landed cost info for ship_line_id: ' || p_ship_line_id;
422: INL_LOGGING_PVT.Log_Statement (
423: p_module_name => g_module_name,
424: p_procedure_name => l_proc_name,
425: p_debug_info => l_debug_info);
426:

Line 432: INL_LOGGING_PVT.Log_Statement (

428: FETCH c_landed_cost BULK COLLECT INTO l_landed_cost_lst;
429: CLOSE c_landed_cost;
430:
431: l_debug_info := l_landed_cost_lst.LAST||' line(s) have been retrieved (l_landed_cost_lst).';
432: INL_LOGGING_PVT.Log_Statement (
433: p_module_name => g_module_name,
434: p_procedure_name => l_proc_name,
435: p_debug_info => l_debug_info
436: ) ;

Line 454: INL_LOGGING_PVT.Log_Variable (

450: x_actual_taxes := 0;
451: x_actual_unit_landed_cost := 0;
452: FOR j IN NVL (l_landed_cost_lst.FIRST, 0)..NVL (l_landed_cost_lst.LAST, 0)
453: LOOP
454: INL_LOGGING_PVT.Log_Variable (
455: p_module_name => g_module_name,
456: p_procedure_name => l_proc_name,
457: p_var_name => 'l_landed_cost_lst('||j||').component_type',
458: p_var_value => l_landed_cost_lst(j).component_type

Line 460: INL_LOGGING_PVT.Log_Variable (

456: p_procedure_name => l_proc_name,
457: p_var_name => 'l_landed_cost_lst('||j||').component_type',
458: p_var_value => l_landed_cost_lst(j).component_type
459: ) ;
460: INL_LOGGING_PVT.Log_Variable (
461: p_module_name => g_module_name,
462: p_procedure_name => l_proc_name,
463: p_var_name => 'l_landed_cost_lst('||j||').ELC',
464: p_var_value => l_landed_cost_lst(j).ELC

Line 466: INL_LOGGING_PVT.Log_Variable (

462: p_procedure_name => l_proc_name,
463: p_var_name => 'l_landed_cost_lst('||j||').ELC',
464: p_var_value => l_landed_cost_lst(j).ELC
465: ) ;
466: INL_LOGGING_PVT.Log_Variable (
467: p_module_name => g_module_name,
468: p_procedure_name => l_proc_name,
469: p_var_name => 'l_landed_cost_lst('||j||').ALC',
470: p_var_value => l_landed_cost_lst(j).ALC

Line 496: INL_LOGGING_PVT.Log_Statement (

492:
493: x_actual_taxes :=
494: x_actual_taxes + NVL(l_landed_cost_lst(j).ALC,0);
495: ELSE
496: INL_LOGGING_PVT.Log_Statement (
497: p_module_name => g_module_name,
498: p_procedure_name => l_proc_name,
499: p_debug_info => 'unexpected component_type: '||l_landed_cost_lst(j).component_type);
500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 506: INL_LOGGING_PVT.Log_Variable(

502: END LOOP;
503: END IF;
504: END;
505:
506: INL_LOGGING_PVT.Log_Variable(
507: p_module_name => g_module_name,
508: p_procedure_name => g_module_name,
509: p_var_name => 'x_actual_unit_landed_cost',
510: p_var_value => x_actual_unit_landed_cost);

Line 511: INL_LOGGING_PVT.Log_Variable(

507: p_module_name => g_module_name,
508: p_procedure_name => g_module_name,
509: p_var_name => 'x_actual_unit_landed_cost',
510: p_var_value => x_actual_unit_landed_cost);
511: INL_LOGGING_PVT.Log_Variable(
512: p_module_name => g_module_name,
513: p_procedure_name => g_module_name,
514: p_var_name => 'x_adjustment_num',
515: p_var_value => x_adjustment_num);

Line 529: INL_LOGGING_PVT.Log_EndProc (

525: p_count => x_msg_count,
526: p_data => x_msg_data);
527:
528: -- Standard End of Procedure/Function Logging
529: INL_LOGGING_PVT.Log_EndProc (
530: p_module_name => g_module_name,
531: p_procedure_name => l_proc_name);
532: EXCEPTION
533: WHEN FND_API.G_EXC_ERROR THEN

Line 535: INL_LOGGING_PVT.Log_ExpecError (

531: p_procedure_name => l_proc_name);
532: EXCEPTION
533: WHEN FND_API.G_EXC_ERROR THEN
534: -- Standard Expected Error Logging
535: INL_LOGGING_PVT.Log_ExpecError (
536: p_module_name => g_module_name,
537: p_procedure_name => l_proc_name);
538: ROLLBACK TO Get_LandedCost_PVT3;
539: x_return_status := FND_API.G_RET_STS_ERROR;

Line 546: INL_LOGGING_PVT.Log_UnexpecError (

542: p_count => x_msg_count,
543: p_data => x_msg_data);
544: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
545: -- Standard Unexpected Error Logging
546: INL_LOGGING_PVT.Log_UnexpecError (
547: p_module_name => g_module_name,
548: p_procedure_name => l_proc_name);
549: ROLLBACK TO Get_LandedCost_PVT3;
550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 557: INL_LOGGING_PVT.Log_UnexpecError (

553: p_count => x_msg_count,
554: p_data => x_msg_data);
555: WHEN OTHERS THEN
556: -- Standard Unexpected Error Logging
557: INL_LOGGING_PVT.Log_UnexpecError (
558: p_module_name => g_module_name,
559: p_procedure_name => l_proc_name);
560: ROLLBACK TO Get_LandedCost_PVT3;
561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;