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

Line 26: INL_LOGGING_PVT.Log_BeginProc (

22: l_return_status VARCHAR2(1);
23: BEGIN
24:
25: -- Standard Beginning of Procedure/Function Logging
26: INL_LOGGING_PVT.Log_BeginProc (
27: p_module_name => g_module_name,
28: p_procedure_name => l_proc_name
29: );
30:

Line 36: INL_LOGGING_PVT.Log_Statement (

32: x_return_status := FND_API.G_RET_STS_SUCCESS;
33:
34: --Deleting all Tax records
35: l_debug_info := 'Deleting Tax records.';
36: INL_LOGGING_PVT.Log_Statement (
37: p_module_name => g_module_name,
38: p_procedure_name => l_proc_name,
39: p_debug_info => l_debug_info
40: );

Line 61: INL_LOGGING_PVT.Log_Statement (

57: ;
58:
59: --Deleting all association records from Taxes
60: l_debug_info := 'Deleting association records.';
61: INL_LOGGING_PVT.Log_Statement (
62: p_module_name => g_module_name,
63: p_procedure_name => l_proc_name,
64: p_debug_info => l_debug_info
65: );

Line 74: INL_LOGGING_PVT.Log_EndProc (

70: FROM inl_tax_lines tl
71: WHERE assoc.from_parent_table_id = tl.tax_line_id)
72: ;
73: -- Standard End of Procedure/Function Logging
74: INL_LOGGING_PVT.Log_EndProc (
75: p_module_name => g_module_name,
76: p_procedure_name => l_proc_name
77: );
78:

Line 82: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,

78:
79: EXCEPTION
80: WHEN FND_API.G_EXC_ERROR THEN
81: -- Standard Expected Error Logging
82: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
83: p_procedure_name => l_proc_name);
84: x_return_status := FND_API.G_RET_STS_ERROR;
85: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
86: -- Standard Unexpected Error Logging

Line 87: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

83: p_procedure_name => l_proc_name);
84: x_return_status := FND_API.G_RET_STS_ERROR;
85: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
86: -- Standard Unexpected Error Logging
87: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
88: p_procedure_name => l_proc_name);
89: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
90: WHEN OTHERS THEN
91: -- Standard Unexpected Error Logging

Line 92: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

88: p_procedure_name => l_proc_name);
89: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
90: WHEN OTHERS THEN
91: -- Standard Unexpected Error Logging
92: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
93: p_procedure_name => l_proc_name);
94: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
95: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
96: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,l_proc_name);

Line 146: INL_LOGGING_PVT.Log_BeginProc (

142: l_proration_rate NUMBER;
143: BEGIN
144:
145: -- Standard Beginning of Procedure/Function Logging
146: INL_LOGGING_PVT.Log_BeginProc (
147: p_module_name => g_module_name,
148: p_procedure_name => l_proc_name
149: );
150:

Line 156: INL_LOGGING_PVT.Log_Statement (

152: x_return_status := FND_API.G_RET_STS_SUCCESS;
153:
154: --Getting PO_LINE_LOCATION data
155: l_debug_info := 'Getting PO_LINE_LOCATION data';
156: INL_LOGGING_PVT.Log_Statement (
157: p_module_name => g_module_name,
158: p_procedure_name => l_proc_name,
159: p_debug_info => l_debug_info
160: );

Line 187: INL_LOGGING_PVT.Log_Statement (

183: END IF;
184:
185: --Verify if currency convertion is required
186: l_debug_info := 'Verify if currency convertion is required';
187: INL_LOGGING_PVT.Log_Statement (
188: p_module_name => g_module_name,
189: p_procedure_name => l_proc_name,
190: p_debug_info => l_debug_info
191: );

Line 195: INL_LOGGING_PVT.Log_Statement (

191: );
192: IF p_sl_currency_code <> l_po_curr_code THEN
193: --Use LCM INL_LANDEDCOST_PVT.Converted_Amt to get the converted amount
194: l_debug_info := 'Use LCM INL_LANDEDCOST_PVT.Converted_Amt to get the converted amount';
195: INL_LOGGING_PVT.Log_Statement (
196: p_module_name => g_module_name,
197: p_procedure_name => l_proc_name,
198: p_debug_info => l_debug_info
199: );

Line 201: INL_LOGGING_PVT.Log_Variable (

197: p_procedure_name => l_proc_name,
198: p_debug_info => l_debug_info
199: );
200: l_debug_info := 'l_amt';
201: INL_LOGGING_PVT.Log_Variable (
202: p_module_name => g_module_name,
203: p_procedure_name => l_proc_name,
204: p_var_name => l_debug_info,
205: p_var_value => l_amt

Line 208: INL_LOGGING_PVT.Log_Variable (

204: p_var_name => l_debug_info,
205: p_var_value => l_amt
206: );
207: l_debug_info := 'l_po_curr_code';
208: INL_LOGGING_PVT.Log_Variable (
209: p_module_name => g_module_name,
210: p_procedure_name => l_proc_name,
211: p_var_name => l_debug_info,
212: p_var_value => l_po_curr_code

Line 215: INL_LOGGING_PVT.Log_Variable (

211: p_var_name => l_debug_info,
212: p_var_value => l_po_curr_code
213: );
214: l_debug_info := 'p_sl_currency_code';
215: INL_LOGGING_PVT.Log_Variable (
216: p_module_name => g_module_name,
217: p_procedure_name => l_proc_name,
218: p_var_name => l_debug_info,
219: p_var_value => p_sl_currency_code

Line 222: INL_LOGGING_PVT.Log_Variable (

218: p_var_name => l_debug_info,
219: p_var_value => p_sl_currency_code
220: );
221: l_debug_info := 'nvl(l_po_curr_rate_type, p_sl_currency_conversion_type)';
222: INL_LOGGING_PVT.Log_Variable (
223: p_module_name => g_module_name,
224: p_procedure_name => l_proc_name,
225: p_var_name => l_debug_info,
226: p_var_value => nvl(l_po_curr_rate_type, p_sl_currency_conversion_type)

Line 229: INL_LOGGING_PVT.Log_Variable (

225: p_var_name => l_debug_info,
226: p_var_value => nvl(l_po_curr_rate_type, p_sl_currency_conversion_type)
227: );
228: l_debug_info := 'nvl(l_po_curr_rate_date, p_sl_currency_conversion_date)';
229: INL_LOGGING_PVT.Log_Variable (
230: p_module_name => g_module_name,
231: p_procedure_name => l_proc_name,
232: p_var_name => l_debug_info,
233: p_var_value => nvl(l_po_curr_rate_date, p_sl_currency_conversion_date)

Line 244: INL_LOGGING_PVT.Log_Variable (

240: p_currency_conversion_date => nvl(l_po_curr_rate_date, p_sl_currency_conversion_date)
241: )
242: ;
243: l_debug_info := 'l_amt';
244: INL_LOGGING_PVT.Log_Variable (
245: p_module_name => g_module_name,
246: p_procedure_name => l_proc_name,
247: p_var_name => l_debug_info,
248: p_var_value => l_amt

Line 254: INL_LOGGING_PVT.Log_Statement (

250:
251: END IF;
252: --Calculates the proration rate
253: l_debug_info := 'Calculates the proration rate';
254: INL_LOGGING_PVT.Log_Statement (
255: p_module_name => g_module_name,
256: p_procedure_name => l_proc_name,
257: p_debug_info => l_debug_info
258: );

Line 263: INL_LOGGING_PVT.Log_Statement (

259: l_proration_rate := (p_sl_txn_unit_price*p_sl_txn_qty) / l_amt;
260:
261: --Calculates the proration of tax
262: l_debug_info := 'Calculates the proration of tax (proration_rate= '||l_proration_rate||')';
263: INL_LOGGING_PVT.Log_Statement (
264: p_module_name => g_module_name,
265: p_procedure_name => l_proc_name,
266: p_debug_info => l_debug_info
267: );

Line 271: INL_LOGGING_PVT.Log_Variable (

267: );
268:
269: x_rec_tax_amt := x_rec_tax_amt * l_proration_rate;
270: l_debug_info := 'x_rec_tax_amt';
271: INL_LOGGING_PVT.Log_Variable (
272: p_module_name => g_module_name,
273: p_procedure_name => l_proc_name,
274: p_var_name => l_debug_info,
275: p_var_value => x_rec_tax_amt

Line 280: INL_LOGGING_PVT.Log_Variable (

276: );
277:
278: x_tax_amt := x_tax_amt * l_proration_rate;
279: l_debug_info := 'x_tax_amt';
280: INL_LOGGING_PVT.Log_Variable (
281: p_module_name => g_module_name,
282: p_procedure_name => l_proc_name,
283: p_var_name => l_debug_info,
284: p_var_value => x_tax_amt

Line 288: INL_LOGGING_PVT.Log_EndProc (

284: p_var_value => x_tax_amt
285: );
286:
287: -- Standard End of Procedure/Function Logging
288: INL_LOGGING_PVT.Log_EndProc (
289: p_module_name => g_module_name,
290: p_procedure_name => l_proc_name
291: );
292:

Line 296: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,

292:
293: EXCEPTION
294: WHEN FND_API.G_EXC_ERROR THEN
295: -- Standard Expected Error Logging
296: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
297: p_procedure_name => l_proc_name);
298: x_return_status := FND_API.G_RET_STS_ERROR;
299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
300: -- Standard Unexpected Error Logging

Line 301: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

297: p_procedure_name => l_proc_name);
298: x_return_status := FND_API.G_RET_STS_ERROR;
299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
300: -- Standard Unexpected Error Logging
301: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
302: p_procedure_name => l_proc_name);
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304: WHEN OTHERS THEN
305: -- Standard Unexpected Error Logging

Line 306: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

302: p_procedure_name => l_proc_name);
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304: WHEN OTHERS THEN
305: -- Standard Unexpected Error Logging
306: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
307: p_procedure_name => l_proc_name);
308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
309: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
310: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,l_proc_name);

Line 409: INL_LOGGING_PVT.Log_BeginProc (

405: l_tax_amt_prorated NUMBER;
406: l_rec_tax_amt_prorated NUMBER;
407: BEGIN
408: -- Standard Beginning of Procedure/Function Logging
409: INL_LOGGING_PVT.Log_BeginProc (
410: p_module_name => g_module_name,
411: p_procedure_name => l_proc_name
412: );
413:

Line 419: INL_LOGGING_PVT.Log_Statement (

415: x_return_status := FND_API.G_RET_STS_SUCCESS;
416:
417: --Uses the zlines cursor
418: l_debug_info := 'Uses the zlines cursor ';
419: INL_LOGGING_PVT.Log_Statement (
420: p_module_name => g_module_name,
421: p_procedure_name => l_proc_name,
422: p_debug_info => l_debug_info
423: );

Line 453: INL_LOGGING_PVT.Log_Variable (

449: l_tax_amt_prorated := zlines_tbl(i).tax_amt_tax_curr;
450: l_rec_tax_amt_prorated := zlines_tbl(i).rec_tax_amt_tax_curr;
451:
452: l_debug_info := 'l_tax_amt_prorated';
453: INL_LOGGING_PVT.Log_Variable (
454: p_module_name => g_module_name,
455: p_procedure_name => l_proc_name,
456: p_var_name => l_debug_info,
457: p_var_value => l_tax_amt_prorated

Line 461: INL_LOGGING_PVT.Log_Variable (

457: p_var_value => l_tax_amt_prorated
458: );
459:
460: l_debug_info := 'l_rec_tax_amt_prorated';
461: INL_LOGGING_PVT.Log_Variable (
462: p_module_name => g_module_name,
463: p_procedure_name => l_proc_name,
464: p_var_name => l_debug_info,
465: p_var_value => l_rec_tax_amt_prorated

Line 488: INL_LOGGING_PVT.Log_Variable (

484: END IF;
485:
486:
487: l_debug_info := 'l_tax_amt_prorated';
488: INL_LOGGING_PVT.Log_Variable (
489: p_module_name => g_module_name,
490: p_procedure_name => l_proc_name,
491: p_var_name => l_debug_info,
492: p_var_value => l_tax_amt_prorated

Line 496: INL_LOGGING_PVT.Log_Variable (

492: p_var_value => l_tax_amt_prorated
493: );
494:
495: l_debug_info := 'l_rec_tax_amt_prorated';
496: INL_LOGGING_PVT.Log_Variable (
497: p_module_name => g_module_name,
498: p_procedure_name => l_proc_name,
499: p_var_name => l_debug_info,
500: p_var_value => l_rec_tax_amt_prorated

Line 510: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,

506: END LOOP;
507: END IF;
508:
509: -- Standard End of Procedure/Function Logging
510: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
511: p_procedure_name => l_proc_name);
512:
513:
514: EXCEPTION

Line 517: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,

513:
514: EXCEPTION
515: WHEN FND_API.G_EXC_ERROR THEN
516: -- Standard Expected Error Logging
517: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
518: p_procedure_name => l_proc_name);
519: x_return_status := FND_API.G_RET_STS_ERROR;
520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
521: -- Standard Unexpected Error Logging

Line 522: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

518: p_procedure_name => l_proc_name);
519: x_return_status := FND_API.G_RET_STS_ERROR;
520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
521: -- Standard Unexpected Error Logging
522: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
523: p_procedure_name => l_proc_name);
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
525: WHEN OTHERS THEN
526: -- Standard Unexpected Error Logging

Line 527: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

523: p_procedure_name => l_proc_name);
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
525: WHEN OTHERS THEN
526: -- Standard Unexpected Error Logging
527: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
528: p_procedure_name => l_proc_name);
529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
530: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
531: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,l_proc_name);

Line 587: INL_LOGGING_PVT.Log_BeginProc (

583:
584: BEGIN
585:
586: -- Standard Beginning of Procedure/Function Logging
587: INL_LOGGING_PVT.Log_BeginProc (
588: p_module_name => g_module_name,
589: p_procedure_name => l_api_name
590: );
591:

Line 615: INL_LOGGING_PVT.Log_Statement (

611: x_return_status := FND_API.G_RET_STS_SUCCESS;
612:
613: l_debug_info := 'Step 1a: Delete data from previous tax Generation/Calculation';
614: -- logging message
615: INL_LOGGING_PVT.Log_Statement (
616: p_module_name => g_module_name,
617: p_procedure_name => l_api_name,
618: p_debug_info => l_debug_info
619: );

Line 633: INL_LOGGING_PVT.Log_Statement (

629: END IF;
630:
631: -- Getting all Shipment Information to send to Hook
632: l_debug_info := 'Getting all Shipment Information to send to Hook';
633: INL_LOGGING_PVT.Log_Statement (
634: p_module_name => g_module_name,
635: p_procedure_name => l_api_name,
636: p_debug_info => l_debug_info);
637:

Line 640: INL_LOGGING_PVT.Log_Statement (

636: p_debug_info => l_debug_info);
637:
638:
639: l_debug_info := 'Getting Shipment Header Information.';
640: INL_LOGGING_PVT.Log_Statement (
641: p_module_name => g_module_name,
642: p_procedure_name => l_api_name,
643: p_debug_info => l_debug_info
644: );

Line 652: INL_LOGGING_PVT.Log_Statement (

648: CLOSE Shipment_Header;
649:
650: --Getting Shipment Line Group Information
651: l_debug_info := 'Getting Shipment Line Group Information.';
652: INL_LOGGING_PVT.Log_Statement (
653: p_module_name => g_module_name,
654: p_procedure_name => l_api_name,
655: p_debug_info => l_debug_info
656: );

Line 665: INL_LOGGING_PVT.Log_Statement (

661: WHERE lg.ship_header_id = p_ship_header_id
662: order by ship_line_group_id;
663:
664: l_debug_info := sql%rowcount||' records have been retrieved.';
665: INL_LOGGING_PVT.Log_Statement (
666: p_module_name => g_module_name,
667: p_procedure_name => l_api_name,
668: p_debug_info => l_debug_info
669: );

Line 673: INL_LOGGING_PVT.Log_Statement (

669: );
670:
671: --Getting Shipment Line Information
672: l_debug_info := 'Getting Shipment Line Information.';
673: INL_LOGGING_PVT.Log_Statement (
674: p_module_name => g_module_name,
675: p_procedure_name => l_api_name,
676: p_debug_info => l_debug_info
677: );

Line 686: INL_LOGGING_PVT.Log_Statement (

682: WHERE sl.ship_header_id = p_ship_header_id
683: order by sl.ship_line_group_id, sl.ship_line_id;
684:
685: l_debug_info := sql%rowcount||' records have been retrieved.';
686: INL_LOGGING_PVT.Log_Statement (
687: p_module_name => g_module_name,
688: p_procedure_name => l_api_name,
689: p_debug_info => l_debug_info
690: );

Line 694: INL_LOGGING_PVT.Log_Statement (

690: );
691:
692: --Getting Charge Line Information
693: l_debug_info := 'Getting Charge Line Information.';
694: INL_LOGGING_PVT.Log_Statement (
695: p_module_name => g_module_name,
696: p_procedure_name => l_api_name,
697: p_debug_info => l_debug_info
698: );

Line 707: INL_LOGGING_PVT.Log_Statement (

703: ;
704: CLOSE charge_ln;
705:
706: l_debug_info := sql%rowcount||' records have been retrieved.';
707: INL_LOGGING_PVT.Log_Statement (
708: p_module_name => g_module_name,
709: p_procedure_name => l_api_name,
710: p_debug_info => l_debug_info
711: );

Line 714: INL_LOGGING_PVT.Log_Statement (

710: p_debug_info => l_debug_info
711: );
712:
713: l_debug_info := ' Generating taxes from hook (inl_custom_pub.Get_Taxes).';
714: INL_LOGGING_PVT.Log_Statement (
715: p_module_name => g_module_name,
716: p_procedure_name => l_api_name,
717: p_debug_info => l_debug_info
718: );

Line 739: INL_LOGGING_PVT.Log_Statement (

735: END IF;
736:
737: IF NOT (l_override_default_processing) THEN
738: l_debug_info := 'Calls the rotine to generate tax according parameter: ';
739: INL_LOGGING_PVT.Log_Statement (
740: p_module_name => g_module_name,
741: p_procedure_name=> l_api_name,
742: p_debug_info => l_debug_info
743: );

Line 762: INL_LOGGING_PVT.Log_Statement (

758:
759: IF ( NVL(l_tax_ln_tbl.COUNT,0) > 0) THEN
760: -- Persists the generated taxes
761: l_debug_info := 'Persists the generated taxes';
762: INL_LOGGING_PVT.Log_Statement (
763: p_module_name => g_module_name,
764: p_procedure_name => l_api_name,
765: p_debug_info => l_debug_info
766: );

Line 771: INL_LOGGING_PVT.Log_Statement (

767:
768: FOR i IN l_tax_ln_tbl.FIRST..l_tax_ln_tbl.LAST LOOP
769: --Insert IN INL_TAX_LINES getting ID from sequence
770: l_debug_info := 'Insert IN INL_TAX_LINES getting ID from sequence';
771: INL_LOGGING_PVT.Log_Statement (
772: p_module_name => g_module_name,
773: p_procedure_name => l_api_name,
774: p_debug_info => l_debug_info
775: );

Line 789: INL_LOGGING_PVT.Log_Statement (

785: ;
786:
787: --Inserting record in INL_TAX_LINES
788: l_debug_info := 'Inserting record in INL_TAX_LINES';
789: INL_LOGGING_PVT.Log_Statement (
790: p_module_name => g_module_name,
791: p_procedure_name => l_api_name,
792: p_debug_info => l_debug_info
793: );

Line 840: INL_LOGGING_PVT.Log_Statement (

836: fnd_global.login_id /* 21 */
837: );
838: --Inserting record in INL_ASSOCIATIONS
839: l_debug_info := 'Inserting record in INL_ASSOCIATIONS';
840: INL_LOGGING_PVT.Log_Statement (
841: p_module_name => g_module_name,
842: p_procedure_name => l_api_name,
843: p_debug_info => l_debug_info
844: );

Line 891: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,

887: p_count => x_msg_count,
888: p_data => x_msg_data);
889:
890: -- Standard End of Procedure/Function Logging
891: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
892: p_procedure_name => l_api_name);
893:
894: EXCEPTION
895: WHEN FND_API.G_EXC_ERROR THEN

Line 897: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,

893:
894: EXCEPTION
895: WHEN FND_API.G_EXC_ERROR THEN
896: -- Standard Expected Error Logging
897: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
898: p_procedure_name => l_api_name);
899: ROLLBACK TO Generate_Taxes_PVT;
900: x_return_status := FND_API.G_RET_STS_ERROR;
901: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

Line 906: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

902: p_count => x_msg_count,
903: p_data => x_msg_data);
904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
905: -- Standard Unexpected Error Logging
906: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
907: p_procedure_name => l_api_name);
908: ROLLBACK TO Generate_Taxes_PVT;
909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
910: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

Line 915: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

911: p_count => x_msg_count,
912: p_data => x_msg_data);
913: WHEN OTHERS THEN
914: -- Standard Unexpected Error Logging
915: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
916: p_procedure_name => l_api_name);
917: ROLLBACK TO Generate_Taxes_PVT;
918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
919: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

959: l_category_code VARCHAR2(100);
960:
961: BEGIN
962: -- logging message
963: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
964: p_procedure_name => l_function_name);
965:
966: x_return_status := FND_API.G_RET_STS_SUCCESS;
967:

Line 971: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,

967:
968: -- get category to derivate Event_Class_Code
969: x_Event_Class_Code := 'ARRIVALS';
970: -- logging message
971: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
972: p_procedure_name => l_function_name);
973: EXCEPTION
974: WHEN FND_API.G_EXC_ERROR THEN
975: -- logging message

Line 976: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,

972: p_procedure_name => l_function_name);
973: EXCEPTION
974: WHEN FND_API.G_EXC_ERROR THEN
975: -- logging message
976: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
977: p_procedure_name => l_function_name);
978: x_return_status := FND_API.G_RET_STS_ERROR;
979: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
980: -- logging message

Line 981: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

977: p_procedure_name => l_function_name);
978: x_return_status := FND_API.G_RET_STS_ERROR;
979: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
980: -- logging message
981: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
982: p_procedure_name => l_function_name);
983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
984: WHEN OTHERS THEN
985: -- logging message

Line 986: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

982: p_procedure_name => l_function_name);
983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
984: WHEN OTHERS THEN
985: -- logging message
986: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
987: p_procedure_name => l_function_name);
988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
989: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
990: THEN

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

1019: l_debug_info VARCHAR2(240);
1020: l_function_name CONSTANT VARCHAR2(100) := 'Get_Po_Info ';
1021: BEGIN
1022: -- logging message
1023: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
1024: p_procedure_name => l_function_name);
1025:
1026: x_return_status := FND_API.G_RET_STS_SUCCESS;
1027: -- get PO_Header_id

Line 1036: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,

1032: AND pll.po_header_id = ph.po_header_id
1033: AND rownum = 1;
1034:
1035: -- logging message
1036: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
1037: p_procedure_name => l_function_name);
1038:
1039: EXCEPTION
1040: WHEN FND_API.G_EXC_ERROR THEN

Line 1042: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,

1038:
1039: EXCEPTION
1040: WHEN FND_API.G_EXC_ERROR THEN
1041: -- logging message
1042: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1043: p_procedure_name => l_function_name);
1044: x_return_status := FND_API.G_RET_STS_ERROR;
1045: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1046: -- logging message

Line 1047: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

1043: p_procedure_name => l_function_name);
1044: x_return_status := FND_API.G_RET_STS_ERROR;
1045: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1046: -- logging message
1047: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1048: p_procedure_name => l_function_name);
1049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1050: WHEN OTHERS THEN
1051: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

Line 1051: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

1047: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1048: p_procedure_name => l_function_name);
1049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1050: WHEN OTHERS THEN
1051: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1052: p_procedure_name => l_function_name);
1053: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1054: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1055: THEN

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

1096: l_doc_level_recalc_flag VARCHAR2(1):='Y';
1097: l_step VARCHAR2(10);
1098: BEGIN
1099: -- logging message
1100: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
1101: p_procedure_name => l_function_name);
1102:
1103: x_return_status := FND_API.G_RET_STS_SUCCESS;
1104:

Line 1113: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1109: -------------------------------------------------------------------
1110: l_debug_info := 'Step 6: Get Ship to party id';
1111: -------------------------------------------------------------------
1112: -- logging message
1113: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1114: p_procedure_name => l_function_name,
1115: p_debug_info => l_debug_info);
1116:
1117: l_ship_to_organization_id := l_ship_header_rec.organization_id;

Line 1123: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1119: -------------------------------------------------------------------
1120: l_debug_info := 'Step 7: Get ledger_id. l_ship_header_rec.inv_org_id: '||l_ship_header_rec.organization_id;
1121: -------------------------------------------------------------------
1122: -- logging message
1123: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1124: p_procedure_name => l_function_name,
1125: p_debug_info => l_debug_info);
1126: l_step:='02';
1127: SELECT ood.set_of_books_id

Line 1136: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1132: l_step:='02a';
1133: -------------------------------------------------------------------
1134: l_debug_info := 'Step 7a: Get tax_event_type_code';
1135: -- logging message
1136: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1137: p_procedure_name => l_function_name,
1138: p_debug_info => l_debug_info);
1139: -------------------------------------------------------------------
1140: IF p_etax_already_called_flag = 'Y' THEN

Line 1153: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1149: l_debug_info := 'Step 8: Populate zx_trx_headers_gt';
1150: -------------------------------------------------------------------
1151: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1152: -- logging message
1153: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1154: p_procedure_name => l_function_name,
1155: p_debug_info => l_debug_info);
1156: -- Delete records of the current shipment
1157: DELETE FROM zx_trx_headers_gt

Line 1329: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,

1325: );
1326: l_step:='05';
1327: END IF;
1328: -- logging message
1329: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
1330: p_procedure_name => l_function_name);
1331:
1332: EXCEPTION
1333: WHEN FND_API.G_EXC_ERROR THEN

Line 1335: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,

1331:
1332: EXCEPTION
1333: WHEN FND_API.G_EXC_ERROR THEN
1334: -- logging message
1335: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1336: p_procedure_name => l_function_name||l_step);
1337: x_return_status := FND_API.G_RET_STS_ERROR;
1338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1339: -- logging message

Line 1340: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

1336: p_procedure_name => l_function_name||l_step);
1337: x_return_status := FND_API.G_RET_STS_ERROR;
1338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1339: -- logging message
1340: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1341: p_procedure_name => l_function_name||l_step);
1342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1343: WHEN OTHERS THEN
1344: -- logging message

Line 1345: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

1341: p_procedure_name => l_function_name||l_step);
1342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1343: WHEN OTHERS THEN
1344: -- logging message
1345: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1346: p_procedure_name => l_function_name||l_step);
1347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1348: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1349: THEN

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

1409: l_minimum_accountable_unit NUMBER;
1410:
1411: BEGIN
1412: -- logging message
1413: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
1414: p_procedure_name => l_function_name);
1415:
1416: x_return_status := FND_API.G_RET_STS_SUCCESS;
1417: -----------------------------------------------------------------

Line 1420: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1416: x_return_status := FND_API.G_RET_STS_SUCCESS;
1417: -----------------------------------------------------------------
1418: l_debug_info := 'IN Populating shipment lines collection';
1419: -- logging message
1420: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1421: p_procedure_name => l_function_name,
1422: p_debug_info => l_debug_info);
1423: -----------------------------------------------------------------
1424: l_debug_info := 'Step 1: Get l_bill_to_location_id for org_id';

Line 1426: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1422: p_debug_info => l_debug_info);
1423: -----------------------------------------------------------------
1424: l_debug_info := 'Step 1: Get l_bill_to_location_id for org_id';
1425: -- logging message
1426: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1427: p_procedure_name => l_function_name,
1428: p_debug_info => l_debug_info);
1429: ----------------------------------------------------------------------
1430: -- if is a dispatch the location is the same from ship from in a Arrival

Line 1435: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1431: -- else it is null
1432: ----------------------------------------------------------------------
1433: l_debug_info := 'Step 2: Go through taxable lines'||' l_ship_line_list.COUNT: '||l_ship_line_list.COUNT;
1434: -- logging message
1435: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1436: p_procedure_name => l_function_name,
1437: p_debug_info => l_debug_info);
1438: ----------------------------------------------------------------------
1439: IF ( l_ship_line_list.COUNT > 0) THEN

Line 1460: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

1456: WHEN OTHERS THEN
1457: IF (SQLCODE <> -20001) THEN
1458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1459: -- logging message
1460: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1461: p_procedure_name => l_function_name);
1462: END IF;
1463: APP_EXCEPTION.RAISE_EXCEPTION;
1464: END;

Line 1501: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1497: END IF;
1498: ----------------------------------------------------------------------
1499: l_debug_info := 'Step 6: Get fob_lookup_code from po_vendor_sites';
1500: -- logging message
1501: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1502: p_procedure_name => l_function_name,
1503: p_debug_info => l_debug_info);
1504: ----------------------------------------------------------------------
1505: BEGIN

Line 1519: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1515: -------------------------------------------------------------------
1516: l_debug_info := 'Step 7: Get ship_line_type_code and default Fiscal Classifications for line number:'||
1517: l_ship_line_list(i).ship_line_num;
1518: -- logging message
1519: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1520: p_procedure_name => l_function_name,
1521: p_debug_info => l_debug_info);
1522: -------------------------------------------------------------------
1523: IF l_ship_line_list(i).source = 'CHARGE' THEN

Line 1535: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1531: ||'l_ship_line_list(i).tax_already_calculated_flag'|| l_ship_line_list(i).tax_already_calculated_flag
1532: ;
1533:
1534: -- logging message
1535: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1536: p_procedure_name => l_function_name,
1537: p_debug_info => l_debug_info);
1538: -------------------------------------------------------------------
1539: IF nvl(l_ship_line_list(i).tax_already_calculated_flag,'N') = 'Y' THEN

Line 1547: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1543: END IF;
1544: ------------------------------------------------------------------
1545: l_debug_info := 'Step 9: Get Additional PO matched info (l_line_level_action = '||l_line_level_action||')';
1546: -- logging message
1547: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1548: p_procedure_name => l_function_name,
1549: p_debug_info => l_debug_info);
1550: ------------------------------------------------------------------
1551: -- For now src_type_code can be PO = PO Shipment, RMA = Return Material Authorization Line OR IR = Internal Requisition

Line 1593: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1589: END IF;
1590: ------------------------------------------------------------------
1591: l_debug_info := 'Step 9: Get line_amt_includes_tax_flag';
1592: -- logging message
1593: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1594: p_procedure_name => l_function_name,
1595: p_debug_info => l_debug_info);
1596: ------------------------------------------------------------------
1597: l_line_amt_includes_tax_flag := 'S';

Line 1607: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1603: l_line_amount := nvl(l_ship_line_list(i).unit_price * l_ship_line_list(i).line_qty,0);
1604: ------------------------------------------------------------------
1605: l_debug_info := 'Step 10.1: Get line_class';
1606: -- logging message
1607: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1608: p_procedure_name => l_function_name,
1609: p_debug_info => l_debug_info);
1610: ------------------------------------------------------------------
1611: l_line_Class := 'STANDARD'; -- Possible values are 'STANDARD', 'ADJUSTMENT', 'APPLICATION', 'UNAPPLICATION', 'AMOUNT_MATCHED'

Line 1615: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1611: l_line_Class := 'STANDARD'; -- Possible values are 'STANDARD', 'ADJUSTMENT', 'APPLICATION', 'UNAPPLICATION', 'AMOUNT_MATCHED'
1612: ------------------------------------------------------------------
1613: l_debug_info := 'Step 12: Populate pl/sql table';
1614: -- logging message
1615: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1616: p_procedure_name => l_function_name,
1617: p_debug_info => l_debug_info);
1618: ------------------------------------------------------------------
1619: -- Will populate a dinamic table to include in zx_transaction_lines_gt

Line 1685: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1681: trans_lines(i).input_tax_classification_code := l_ship_line_list(i).tax_classification_code;
1682: ------------------------------------------------------------------
1683: l_debug_info := 'Step 14: Populate pl/sql table: trans_lines(i).trx_line_id='||trans_lines(i).trx_line_id;
1684: -- logging message
1685: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1686: p_procedure_name => l_function_name,
1687: p_debug_info => l_debug_info);
1688: ------------------------------------------------------------------
1689: END IF;

Line 1700: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1696: -------------------------------------------------------------------
1697: l_debug_info := 'Step 15: Bulk Insert into global temp table';
1698: -------------------------------------------------------------------
1699: -- logging message
1700: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1701: p_procedure_name => l_function_name,
1702: p_debug_info => l_debug_info);
1703: -- populate the table
1704: FORALL m IN trans_lines.FIRST..trans_lines.LAST

Line 1711: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

1707: -------------------------------------------------------------------
1708:
1709: l_debug_info := 'Step 15: Populate pl/sql table inserted: '||sql%rowcount||' line(s)';
1710: -- logging message
1711: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1712: p_procedure_name => l_function_name,
1713: p_debug_info => l_debug_info);
1714: -------------------------------------------------------------------
1715: END IF;

Line 1717: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,

1713: p_debug_info => l_debug_info);
1714: -------------------------------------------------------------------
1715: END IF;
1716: -- logging message
1717: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
1718: p_procedure_name => l_function_name);
1719:
1720: EXCEPTION
1721: WHEN FND_API.G_EXC_ERROR THEN

Line 1723: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,

1719:
1720: EXCEPTION
1721: WHEN FND_API.G_EXC_ERROR THEN
1722: -- logging message
1723: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1724: p_procedure_name => l_function_name);
1725: x_return_status := FND_API.G_RET_STS_ERROR;
1726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1727: -- logging message

Line 1728: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

1724: p_procedure_name => l_function_name);
1725: x_return_status := FND_API.G_RET_STS_ERROR;
1726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1727: -- logging message
1728: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1729: p_procedure_name => l_function_name);
1730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1731: WHEN OTHERS THEN
1732: -- logging message

Line 1733: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

1729: p_procedure_name => l_function_name);
1730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1731: WHEN OTHERS THEN
1732: -- logging message
1733: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1734: p_procedure_name => l_function_name);
1735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1736: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1737: THEN

Line 1775: INL_LOGGING_PVT.Log_BeginProc (

1771: l_allocation_uom_code VARCHAR2(30) := NULL;
1772: l_proc VARCHAR2(1):='N';
1773: BEGIN
1774: -- logging message
1775: INL_LOGGING_PVT.Log_BeginProc (
1776: p_module_name => g_module_name,
1777: p_procedure_name => l_procedure_name
1778: );
1779:

Line 1815: INL_LOGGING_PVT.Log_Statement (

1811: IF l_proc = 'N' THEN
1812: l_proc := 'Y';
1813: -- logging message
1814: l_debug_info := 'It will mark the calculated line: curTax';
1815: INL_LOGGING_PVT.Log_Statement (
1816: p_module_name => g_module_name,
1817: p_procedure_name => l_procedure_name,
1818: p_debug_info => l_debug_info
1819: );

Line 1824: INL_LOGGING_PVT.Log_Statement (

1820: END IF;
1821: -----------------------------------------------------------------
1822: l_debug_info := 'Step 6a: Persisting zl.tax_code: '||curTax.tax_code||' zl.tax_line_id:'||curTax.tax_line_id;
1823: -- logging message
1824: INL_LOGGING_PVT.Log_Statement (
1825: p_module_name => g_module_name,
1826: p_procedure_name => l_procedure_name,
1827: p_debug_info => l_debug_info
1828: );

Line 1835: INL_LOGGING_PVT.Log_Statement (

1831: l_debug_info := ' P_Ship_Header_Id: '||p_ship_Header_Id
1832: ||' zl.tax_line_id: '||curTax.tax_line_id
1833: ;
1834: -- logging message
1835: INL_LOGGING_PVT.Log_Statement (
1836: p_module_name => g_module_name,
1837: p_procedure_name => l_procedure_name,
1838: p_debug_info => l_debug_info
1839: );

Line 1886: INL_LOGGING_PVT.Log_Statement (

1882: );
1883: -----------------------------------------------------------------
1884: l_debug_info := 'Step 6b: Persisting zl.tax_code(Associations): '||curTax.tax_code||' zl.tax_line_id:'||curTax.tax_line_id;
1885: -- logging message
1886: INL_LOGGING_PVT.Log_Statement (
1887: p_module_name => g_module_name,
1888: p_procedure_name => l_procedure_name,
1889: p_debug_info => l_debug_info
1890: );

Line 1937: INL_LOGGING_PVT.Log_EndProc (

1933: FROM inl_associations assoc
1934: WHERE assoc.from_parent_table_name = 'INL_CHARGE_LINES'
1935: AND assoc.ship_header_id = p_ship_header_id);
1936: -- logging message
1937: INL_LOGGING_PVT.Log_EndProc (
1938: p_module_name => g_module_name,
1939: p_procedure_name => l_procedure_name
1940: );
1941:

Line 1945: INL_LOGGING_PVT.Log_ExpecError (

1941:
1942: EXCEPTION
1943: WHEN FND_API.G_EXC_ERROR THEN
1944: -- logging message
1945: INL_LOGGING_PVT.Log_ExpecError (
1946: p_module_name => g_module_name,
1947: p_procedure_name => l_procedure_name
1948: );
1949: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1952: INL_LOGGING_PVT.Log_UnexpecError (

1948: );
1949: x_return_status := FND_API.G_RET_STS_ERROR;
1950: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1951: -- logging message
1952: INL_LOGGING_PVT.Log_UnexpecError (
1953: p_module_name => g_module_name,
1954: p_procedure_name => l_procedure_name
1955: );
1956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1959: INL_LOGGING_PVT.Log_UnexpecError (

1955: );
1956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1957: WHEN OTHERS THEN
1958: -- logging message
1959: INL_LOGGING_PVT.Log_UnexpecError (
1960: p_module_name => g_module_name,
1961: p_procedure_name => l_procedure_name
1962: );
1963: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2024: INL_LOGGING_PVT.Log_BeginProc (

2020:
2021:
2022: BEGIN
2023: -- logging message
2024: INL_LOGGING_PVT.Log_BeginProc (
2025: p_module_name => g_module_name,
2026: p_procedure_name => l_api_name
2027: );
2028:

Line 2041: INL_LOGGING_PVT.Log_Statement (

2037: -------------------------------------------------------------------
2038: l_debug_info := 'FND_API.Compatible_API_Call';
2039: -------------------------------------------------------------------
2040: -- logging message
2041: INL_LOGGING_PVT.Log_Statement (
2042: p_module_name => g_module_name,
2043: p_procedure_name => l_api_name,
2044: p_debug_info => l_debug_info
2045: );

Line 2070: INL_LOGGING_PVT.Log_Statement (

2066: -------------------------------------------------------------------
2067: l_debug_info := 'Step 0: Get Entity Code mapping on eBTax';
2068: -------------------------------------------------------------------
2069: -- logging message
2070: INL_LOGGING_PVT.Log_Statement (
2071: p_module_name => g_module_name,
2072: p_procedure_name => l_api_name,
2073: p_debug_info => l_debug_info
2074: );

Line 2083: INL_LOGGING_PVT.Log_Statement (

2079: AND ROWNUM = 1;
2080: -----------------------------------------------------------------
2081: l_debug_info := 'Step 1: call LCM Calculation for all types of lines';
2082: -- logging message
2083: INL_LOGGING_PVT.Log_Statement (
2084: p_module_name => g_module_name,
2085: p_procedure_name => l_api_name,
2086: p_debug_info => l_debug_info
2087: );

Line 2092: INL_LOGGING_PVT.Log_Statement (

2088: -----------------------------------------------------------------
2089: IF ( l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2090: l_debug_info := 'Step 1a: Delete data from previous tax Generation/Calculation';
2091: -- logging message
2092: INL_LOGGING_PVT.Log_Statement (
2093: p_module_name => g_module_name,
2094: p_procedure_name => l_api_name,
2095: p_debug_info => l_debug_info
2096: );

Line 2109: INL_LOGGING_PVT.Log_Statement (

2105: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2106: END IF;
2107: -----------------------------------------------------------------
2108: l_debug_info := 'Step 2: Populating shipment header local record';
2109: INL_LOGGING_PVT.Log_Statement (
2110: p_module_name => g_module_name,
2111: p_procedure_name => l_api_name,
2112: p_debug_info => l_debug_info
2113: );

Line 2124: INL_LOGGING_PVT.Log_Statement (

2120: END;
2121: -----------------------------------------------------------------
2122: l_debug_info := 'Step 2a: Populating shipment lines collection';
2123: -- logging message
2124: INL_LOGGING_PVT.Log_Statement (
2125: p_module_name => g_module_name,
2126: p_procedure_name => l_api_name,
2127: p_debug_info => l_debug_info
2128: );

Line 2165: INL_LOGGING_PVT.Log_Statement (

2161: ||' application_id: 9004'
2162: ||' event_class_code: '||l_event_class_code
2163: ||' entity_code: '||G_ENTITY_CODE;
2164: -- logging message
2165: INL_LOGGING_PVT.Log_Statement (
2166: p_module_name => g_module_name,
2167: p_procedure_name => l_api_name,
2168: p_debug_info => l_debug_info
2169: );

Line 2186: INL_LOGGING_PVT.Log_Statement (

2182: END;
2183: -----------------------------------------------------------------
2184: l_debug_info := 'Step 3: Populate Header';
2185: -- logging message
2186: INL_LOGGING_PVT.Log_Statement (
2187: p_module_name => g_module_name,
2188: p_procedure_name => l_api_name,
2189: p_debug_info => l_debug_info
2190: );

Line 2210: INL_LOGGING_PVT.Log_Statement (

2206: END IF;
2207: -----------------------------------------------------------------
2208: l_debug_info := 'Step 4: Populate TRX lines';
2209: -- logging message
2210: INL_LOGGING_PVT.Log_Statement (
2211: p_module_name => g_module_name,
2212: p_procedure_name => l_api_name,
2213: p_debug_info => l_debug_info
2214: );

Line 2234: INL_LOGGING_PVT.Log_APICallIn (

2230:
2231:
2232: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2233: -- logging message
2234: INL_LOGGING_PVT.Log_APICallIn (
2235: p_module_name => g_module_name,
2236: p_procedure_name => l_api_name,
2237: p_call_api_name => 'ZX_API_PUB.Calculate_Tax',
2238: p_in_param_name1 => 'p_api_version',

Line 2266: INL_LOGGING_PVT.Log_APICallOut (

2262: x_msg_data => l_msg_data
2263: );
2264:
2265: -- logging message
2266: INL_LOGGING_PVT.Log_APICallOut (
2267: p_module_name => g_module_name,
2268: p_procedure_name => l_api_name,
2269: p_call_api_name => 'ZX_API_PUB.Calculate_Tax',
2270: p_out_param_name1 => 'l_return_status',

Line 2287: INL_LOGGING_PVT.Log_Statement (

2283:
2284: -----------------------------------------------------------------
2285: l_debug_info := 'Step 6: Adjust_Tax_Lines to Persist tax records in INL_ASSOCIATIONS and INL_TAX_LINES';
2286: -- logging message
2287: INL_LOGGING_PVT.Log_Statement (
2288: p_module_name => g_module_name,
2289: p_procedure_name => l_api_name,
2290: p_debug_info => l_debug_info);
2291: -----------------------------------------------------------------

Line 2304: INL_LOGGING_PVT.Log_Statement (

2300:
2301: -----------------------------------------------------------------
2302: l_debug_info := 'Step 7: call LCM Calculation for tax lines';
2303: -- logging message
2304: INL_LOGGING_PVT.Log_Statement (
2305: p_module_name => g_module_name,
2306: p_procedure_name => l_api_name,
2307: p_debug_info => l_debug_info
2308: );

Line 2331: INL_LOGGING_PVT.Log_EndProc (

2327: p_encoded => FND_API.g_false,
2328: p_count => x_msg_count,
2329: p_data => x_msg_data);
2330:
2331: INL_LOGGING_PVT.Log_EndProc (
2332: p_module_name => g_module_name,
2333: p_procedure_name => l_api_name);
2334: EXCEPTION
2335: WHEN FND_API.G_EXC_ERROR THEN

Line 2336: INL_LOGGING_PVT.Log_ExpecError (

2332: p_module_name => g_module_name,
2333: p_procedure_name => l_api_name);
2334: EXCEPTION
2335: WHEN FND_API.G_EXC_ERROR THEN
2336: INL_LOGGING_PVT.Log_ExpecError (
2337: p_module_name => g_module_name,
2338: p_procedure_name => l_api_name);
2339: ROLLBACK TO Calculate_Tax_PVT;
2340: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2346: INL_LOGGING_PVT.Log_UnexpecError (

2342: p_encoded => FND_API.g_false,
2343: p_count => x_msg_count,
2344: p_data => x_msg_data);
2345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2346: INL_LOGGING_PVT.Log_UnexpecError (
2347: p_module_name => g_module_name,
2348: p_procedure_name => l_api_name);
2349: ROLLBACK TO Calculate_Tax_PVT;
2350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2357: INL_LOGGING_PVT.Log_UnexpecError (

2353: p_count => x_msg_count,
2354: p_data => x_msg_data);
2355: WHEN OTHERS THEN
2356: -- logging message
2357: INL_LOGGING_PVT.Log_UnexpecError (
2358: p_module_name => g_module_name,
2359: p_procedure_name => l_api_name);
2360: ROLLBACK TO Calculate_Tax_PVT;
2361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

2429: l_po_country_code VARCHAR2(20);
2430: BEGIN
2431:
2432: -- Standard Beginning of Procedure/Function Logging
2433: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
2434: p_procedure_name => l_api_name);
2435:
2436: -- Standard Start of API savepoint
2437: SAVEPOINT Get_DefaultTaxDetAttribs_PVT;

Line 2461: INL_LOGGING_PVT.Log_Statement (

2457: BEGIN
2458:
2459: l_debug_info := 'p_source_type_code: ' || p_source_type_code;
2460: -- logging message
2461: INL_LOGGING_PVT.Log_Statement (
2462: p_module_name => g_module_name,
2463: p_procedure_name => l_api_name,
2464: p_debug_info => l_debug_info);
2465:

Line 2496: INL_LOGGING_PVT.Log_Statement (

2492: END;
2493:
2494: l_debug_info := 'l_po_country_code: ' || l_po_country_code;
2495: -- logging message
2496: INL_LOGGING_PVT.Log_Statement (
2497: p_module_name => g_module_name,
2498: p_procedure_name => l_api_name,
2499: p_debug_info => l_debug_info);
2500:

Line 2503: INL_LOGGING_PVT.Log_Statement (

2499: p_debug_info => l_debug_info);
2500:
2501: l_debug_info := 'p_country_code: ' || p_country_code;
2502: -- logging message
2503: INL_LOGGING_PVT.Log_Statement (
2504: p_module_name => g_module_name,
2505: p_procedure_name => l_api_name,
2506: p_debug_info => l_debug_info);
2507:

Line 2581: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,

2577: p_count => x_msg_count,
2578: p_data => x_msg_data);
2579:
2580: -- Standard End of Procedure/Function Logging
2581: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
2582: p_procedure_name => l_api_name);
2583:
2584:
2585: EXCEPTION

Line 2588: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,

2584:
2585: EXCEPTION
2586: WHEN FND_API.G_EXC_ERROR THEN
2587: -- Standard Expected Error Logging
2588: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
2589: p_procedure_name => l_api_name);
2590: ROLLBACK TO Get_DefaultTaxDetAttribs_PVT;
2591: x_return_status := FND_API.G_RET_STS_ERROR;
2592: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

Line 2597: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

2593: p_count => x_msg_count,
2594: p_data => x_msg_data);
2595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2596: -- Standard Unexpected Error Logging
2597: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
2598: p_procedure_name => l_api_name);
2599: ROLLBACK TO Get_DefaultTaxDetAttribs_PVT;
2600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2601: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

Line 2606: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,

2602: p_count => x_msg_count,
2603: p_data => x_msg_data);
2604: WHEN OTHERS THEN
2605: -- Standard Unexpected Error Logging
2606: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
2607: p_procedure_name => l_api_name);
2608: ROLLBACK TO Get_DefaultTaxDetAttribs_PVT;
2609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2610: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)