DBA Data[Home] [Help]

APPS.PO_DOCUMENT_TOTALS_PVT dependencies on PO_LOG

Line 8: PO_LOG.get_package_base('PO_DOCUMENT_TOTALS_PVT');

4: -- Package private constants
5: -------------------------------------------------------------------------------
6: -- Debug constants
7: D_PACKAGE_BASE CONSTANT VARCHAR2(50) :=
8: PO_LOG.get_package_base('PO_DOCUMENT_TOTALS_PVT');
9:
10: -- Shipment type constants
11: C_ship_type_STANDARD CONSTANT
12: PO_LINE_LOCATIONS_ALL.shipment_type%TYPE

Line 181: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountOrdered');

177: , p_doc_revision_num IN NUMBER --default null
178: ) RETURN NUMBER
179: IS
180: d_mod CONSTANT VARCHAR2(100) :=
181: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountOrdered');
182: d_position NUMBER := 0;
183: l_return_val NUMBER := 0;
184: l_precision GL_CURRENCIES.precision%TYPE;
185: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;

Line 188: IF PO_LOG.d_proc THEN

184: l_precision GL_CURRENCIES.precision%TYPE;
185: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
186: BEGIN
187:
188: IF PO_LOG.d_proc THEN
189: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);
190: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);
191: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
192: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);

Line 189: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);

185: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
186: BEGIN
187:
188: IF PO_LOG.d_proc THEN
189: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);
190: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);
191: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
192: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
193: END IF;

Line 190: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);

186: BEGIN
187:
188: IF PO_LOG.d_proc THEN
189: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);
190: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);
191: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
192: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
193: END IF;
194:

Line 191: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);

187:
188: IF PO_LOG.d_proc THEN
189: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);
190: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);
191: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
192: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
193: END IF;
194:
195: do_org_currency_setups(

Line 192: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);

188: IF PO_LOG.d_proc THEN
189: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);
190: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);
191: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
192: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
193: END IF;
194:
195: do_org_currency_setups(
196: p_doc_level => p_doc_level

Line 203: IF PO_LOG.d_stmt THEN

199: , x_min_acct_unit => l_mau
200: );
201:
202: d_position := 10;
203: IF PO_LOG.d_stmt THEN
204: PO_LOG.stmt(d_mod,d_position,'l_precision:',l_precision);
205: PO_LOG.stmt(d_mod,d_position,'l_mau:',l_mau);
206: END IF;
207:

Line 204: PO_LOG.stmt(d_mod,d_position,'l_precision:',l_precision);

200: );
201:
202: d_position := 10;
203: IF PO_LOG.d_stmt THEN
204: PO_LOG.stmt(d_mod,d_position,'l_precision:',l_precision);
205: PO_LOG.stmt(d_mod,d_position,'l_mau:',l_mau);
206: END IF;
207:
208: IF p_doc_level = g_doc_level_HEADER THEN

Line 205: PO_LOG.stmt(d_mod,d_position,'l_mau:',l_mau);

201:
202: d_position := 10;
203: IF PO_LOG.d_stmt THEN
204: PO_LOG.stmt(d_mod,d_position,'l_precision:',l_precision);
205: PO_LOG.stmt(d_mod,d_position,'l_mau:',l_mau);
206: END IF;
207:
208: IF p_doc_level = g_doc_level_HEADER THEN
209:

Line 254: IF PO_LOG.d_stmt THEN

250:
251: ELSE
252:
253: d_position := 40;
254: IF PO_LOG.d_stmt THEN
255: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);
256: END IF;
257:
258: END IF; --p_data_source check

Line 255: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);

251: ELSE
252:
253: d_position := 40;
254: IF PO_LOG.d_stmt THEN
255: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);
256: END IF;
257:
258: END IF; --p_data_source check
259:

Line 304: IF PO_LOG.d_stmt THEN

300:
301: ELSE
302:
303: d_position := 70;
304: IF PO_LOG.d_stmt THEN
305: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);
306: END IF;
307:
308: END IF; --p_data_source check

Line 305: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);

301: ELSE
302:
303: d_position := 70;
304: IF PO_LOG.d_stmt THEN
305: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);
306: END IF;
307:
308: END IF; --p_data_source check
309:

Line 358: IF PO_LOG.d_stmt THEN

354:
355: ELSE
356:
357: d_position := 100;
358: IF PO_LOG.d_stmt THEN
359: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);
360: END IF;
361:
362: END IF; --p_data_source check

Line 359: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);

355: ELSE
356:
357: d_position := 100;
358: IF PO_LOG.d_stmt THEN
359: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);
360: END IF;
361:
362: END IF; --p_data_source check
363:

Line 423: IF PO_LOG.d_stmt THEN

419:
420: ELSE
421:
422: d_position := 130;
423: IF PO_LOG.d_stmt THEN
424: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);
425: END IF;
426:
427: END IF; --p_data_source check

Line 424: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);

420: ELSE
421:
422: d_position := 130;
423: IF PO_LOG.d_stmt THEN
424: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);
425: END IF;
426:
427: END IF; --p_data_source check
428:

Line 432: IF PO_LOG.d_stmt THEN

428:
429: ELSE
430:
431: d_position := 140;
432: IF PO_LOG.d_stmt THEN
433: PO_LOG.stmt(d_mod,d_position,'Invalid doc level: ', p_doc_level);
434: END IF;
435:
436: END IF; --p_doc_level check

Line 433: PO_LOG.stmt(d_mod,d_position,'Invalid doc level: ', p_doc_level);

429: ELSE
430:
431: d_position := 140;
432: IF PO_LOG.d_stmt THEN
433: PO_LOG.stmt(d_mod,d_position,'Invalid doc level: ', p_doc_level);
434: END IF;
435:
436: END IF; --p_doc_level check
437:

Line 438: IF PO_LOG.d_proc THEN

434: END IF;
435:
436: END IF; --p_doc_level check
437:
438: IF PO_LOG.d_proc THEN
439: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);
440: END IF;
441:
442: RETURN l_return_val;

Line 439: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);

435:
436: END IF; --p_doc_level check
437:
438: IF PO_LOG.d_proc THEN
439: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);
440: END IF;
441:
442: RETURN l_return_val;
443:

Line 446: IF PO_LOG.d_exc THEN

442: RETURN l_return_val;
443:
444: EXCEPTION
445: WHEN OTHERS THEN
446: IF PO_LOG.d_exc THEN
447: PO_LOG.exc(d_mod,d_position,NULL);
448: END IF;
449: RAISE;
450: END getAmountOrdered;

Line 447: PO_LOG.exc(d_mod,d_position,NULL);

443:
444: EXCEPTION
445: WHEN OTHERS THEN
446: IF PO_LOG.d_exc THEN
447: PO_LOG.exc(d_mod,d_position,NULL);
448: END IF;
449: RAISE;
450: END getAmountOrdered;
451:

Line 497: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountApprovedForLine');

493: , p_doc_revision_num IN NUMBER --default null
494: ) RETURN NUMBER
495: IS
496: d_mod CONSTANT VARCHAR2(100) :=
497: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountApprovedForLine');
498: d_position NUMBER := 0;
499: l_return_val NUMBER := 0;
500: l_precision GL_CURRENCIES.precision%TYPE;
501: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;

Line 504: IF PO_LOG.d_proc THEN

500: l_precision GL_CURRENCIES.precision%TYPE;
501: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
502: BEGIN
503:
504: IF PO_LOG.d_proc THEN
505: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);
506: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
507: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
508: END IF;

Line 505: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);

501: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
502: BEGIN
503:
504: IF PO_LOG.d_proc THEN
505: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);
506: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
507: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
508: END IF;
509:

Line 506: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);

502: BEGIN
503:
504: IF PO_LOG.d_proc THEN
505: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);
506: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
507: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
508: END IF;
509:
510: do_org_currency_setups(

Line 507: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);

503:
504: IF PO_LOG.d_proc THEN
505: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);
506: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
507: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
508: END IF;
509:
510: do_org_currency_setups(
511: p_doc_level => g_doc_level_LINE

Line 518: IF PO_LOG.d_stmt THEN

514: , x_min_acct_unit => l_mau
515: );
516:
517: d_position := 5;
518: IF PO_LOG.d_stmt THEN
519: PO_LOG.stmt(d_mod,d_position,'l_precision:',l_precision);
520: PO_LOG.stmt(d_mod,d_position,'l_mau:',l_mau);
521: END IF;
522:

Line 519: PO_LOG.stmt(d_mod,d_position,'l_precision:',l_precision);

515: );
516:
517: d_position := 5;
518: IF PO_LOG.d_stmt THEN
519: PO_LOG.stmt(d_mod,d_position,'l_precision:',l_precision);
520: PO_LOG.stmt(d_mod,d_position,'l_mau:',l_mau);
521: END IF;
522:
523: IF p_data_source = g_data_source_TRANSACTION THEN

Line 520: PO_LOG.stmt(d_mod,d_position,'l_mau:',l_mau);

516:
517: d_position := 5;
518: IF PO_LOG.d_stmt THEN
519: PO_LOG.stmt(d_mod,d_position,'l_precision:',l_precision);
520: PO_LOG.stmt(d_mod,d_position,'l_mau:',l_mau);
521: END IF;
522:
523: IF p_data_source = g_data_source_TRANSACTION THEN
524:

Line 542: IF PO_LOG.d_stmt THEN

538: AND nvl(poll.payment_type, 'NULL') IN ('RATE', 'LUMPSUM', 'MILESTONE') --Bug5391045
539: ;
540: EXCEPTION
541: WHEN NO_DATA_FOUND THEN
542: IF PO_LOG.d_stmt THEN
543: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
544: END IF;
545: l_return_val := 0;
546: END;

Line 543: PO_LOG.stmt(d_mod,d_position,'No line locations exist');

539: ;
540: EXCEPTION
541: WHEN NO_DATA_FOUND THEN
542: IF PO_LOG.d_stmt THEN
543: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
544: END IF;
545: l_return_val := 0;
546: END;
547:

Line 576: IF PO_LOG.d_stmt THEN

572: )
573: ;
574: EXCEPTION
575: WHEN NO_DATA_FOUND THEN
576: IF PO_LOG.d_stmt THEN
577: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
578: END IF;
579: l_return_val := 0;
580: END;

Line 577: PO_LOG.stmt(d_mod,d_position,'No line locations exist');

573: ;
574: EXCEPTION
575: WHEN NO_DATA_FOUND THEN
576: IF PO_LOG.d_stmt THEN
577: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
578: END IF;
579: l_return_val := 0;
580: END;
581:

Line 585: IF PO_LOG.d_stmt THEN

581:
582: ELSE
583:
584: d_position := 30;
585: IF PO_LOG.d_stmt THEN
586: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);
587: END IF;
588:
589: END IF;

Line 586: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);

582: ELSE
583:
584: d_position := 30;
585: IF PO_LOG.d_stmt THEN
586: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);
587: END IF;
588:
589: END IF;
590:

Line 591: IF PO_LOG.d_proc THEN

587: END IF;
588:
589: END IF;
590:
591: IF PO_LOG.d_proc THEN
592: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);
593: END IF;
594:
595: RETURN l_return_val;

Line 592: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);

588:
589: END IF;
590:
591: IF PO_LOG.d_proc THEN
592: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);
593: END IF;
594:
595: RETURN l_return_val;
596:

Line 599: IF PO_LOG.d_exc THEN

595: RETURN l_return_val;
596:
597: EXCEPTION
598: WHEN OTHERS THEN
599: IF PO_LOG.d_exc THEN
600: PO_LOG.exc(d_mod,d_position,NULL);
601: END IF;
602: RAISE;
603: END getAmountApprovedForLine;

Line 600: PO_LOG.exc(d_mod,d_position,NULL);

596:
597: EXCEPTION
598: WHEN OTHERS THEN
599: IF PO_LOG.d_exc THEN
600: PO_LOG.exc(d_mod,d_position,NULL);
601: END IF;
602: RAISE;
603: END getAmountApprovedForLine;
604:

Line 650: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountApprovedForHeader');

646: , p_doc_revision_num IN NUMBER --default null
647: ) RETURN NUMBER
648: IS
649: d_mod CONSTANT VARCHAR2(100) :=
650: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountApprovedForHeader');
651: d_position NUMBER := 0;
652: l_return_val NUMBER := 0;
653: l_precision GL_CURRENCIES.precision%TYPE;
654: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;

Line 657: IF PO_LOG.d_proc THEN

653: l_precision GL_CURRENCIES.precision%TYPE;
654: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
655: BEGIN
656:
657: IF PO_LOG.d_proc THEN
658: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);
659: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
660: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
661: END IF;

Line 658: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);

654: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
655: BEGIN
656:
657: IF PO_LOG.d_proc THEN
658: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);
659: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
660: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
661: END IF;
662:

Line 659: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);

655: BEGIN
656:
657: IF PO_LOG.d_proc THEN
658: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);
659: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
660: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
661: END IF;
662:
663: do_org_currency_setups(

Line 660: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);

656:
657: IF PO_LOG.d_proc THEN
658: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);
659: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
660: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
661: END IF;
662:
663: do_org_currency_setups(
664: p_doc_level => g_doc_level_HEADER

Line 671: IF PO_LOG.d_stmt THEN

667: , x_min_acct_unit => l_mau
668: );
669:
670: d_position := 5;
671: IF PO_LOG.d_stmt THEN
672: PO_LOG.stmt(d_mod,d_position,'l_precision:',l_precision);
673: PO_LOG.stmt(d_mod,d_position,'l_mau:',l_mau);
674: END IF;
675:

Line 672: PO_LOG.stmt(d_mod,d_position,'l_precision:',l_precision);

668: );
669:
670: d_position := 5;
671: IF PO_LOG.d_stmt THEN
672: PO_LOG.stmt(d_mod,d_position,'l_precision:',l_precision);
673: PO_LOG.stmt(d_mod,d_position,'l_mau:',l_mau);
674: END IF;
675:
676: IF p_data_source = g_data_source_TRANSACTION THEN

Line 673: PO_LOG.stmt(d_mod,d_position,'l_mau:',l_mau);

669:
670: d_position := 5;
671: IF PO_LOG.d_stmt THEN
672: PO_LOG.stmt(d_mod,d_position,'l_precision:',l_precision);
673: PO_LOG.stmt(d_mod,d_position,'l_mau:',l_mau);
674: END IF;
675:
676: IF p_data_source = g_data_source_TRANSACTION THEN
677:

Line 695: IF PO_LOG.d_stmt THEN

691: AND nvl(poll.payment_type, 'NULL') IN ('RATE', 'LUMPSUM', 'MILESTONE') --Bug5391045
692: ;
693: EXCEPTION
694: WHEN NO_DATA_FOUND THEN
695: IF PO_LOG.d_stmt THEN
696: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
697: END IF;
698: l_return_val := 0;
699: END;

Line 696: PO_LOG.stmt(d_mod,d_position,'No line locations exist');

692: ;
693: EXCEPTION
694: WHEN NO_DATA_FOUND THEN
695: IF PO_LOG.d_stmt THEN
696: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
697: END IF;
698: l_return_val := 0;
699: END;
700:

Line 729: IF PO_LOG.d_stmt THEN

725: )
726: ;
727: EXCEPTION
728: WHEN NO_DATA_FOUND THEN
729: IF PO_LOG.d_stmt THEN
730: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
731: END IF;
732: l_return_val := 0;
733: END;

Line 730: PO_LOG.stmt(d_mod,d_position,'No line locations exist');

726: ;
727: EXCEPTION
728: WHEN NO_DATA_FOUND THEN
729: IF PO_LOG.d_stmt THEN
730: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
731: END IF;
732: l_return_val := 0;
733: END;
734:

Line 738: IF PO_LOG.d_stmt THEN

734:
735: ELSE
736:
737: d_position := 30;
738: IF PO_LOG.d_stmt THEN
739: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);
740: END IF;
741:
742: END IF;

Line 739: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);

735: ELSE
736:
737: d_position := 30;
738: IF PO_LOG.d_stmt THEN
739: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);
740: END IF;
741:
742: END IF;
743:

Line 744: IF PO_LOG.d_proc THEN

740: END IF;
741:
742: END IF;
743:
744: IF PO_LOG.d_proc THEN
745: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);
746: END IF;
747:
748: RETURN l_return_val;

Line 745: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);

741:
742: END IF;
743:
744: IF PO_LOG.d_proc THEN
745: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);
746: END IF;
747:
748: RETURN l_return_val;
749:

Line 752: IF PO_LOG.d_exc THEN

748: RETURN l_return_val;
749:
750: EXCEPTION
751: WHEN OTHERS THEN
752: IF PO_LOG.d_exc THEN
753: PO_LOG.exc(d_mod,d_position,NULL);
754: END IF;
755: RAISE;
756: END getAmountApprovedForHeader;

Line 753: PO_LOG.exc(d_mod,d_position,NULL);

749:
750: EXCEPTION
751: WHEN OTHERS THEN
752: IF PO_LOG.d_exc THEN
753: PO_LOG.exc(d_mod,d_position,NULL);
754: END IF;
755: RAISE;
756: END getAmountApprovedForHeader;
757:

Line 806: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountDeliveredForLine');

802: , p_doc_revision_num IN NUMBER --default null
803: ) RETURN NUMBER
804: IS
805: d_mod CONSTANT VARCHAR2(100) :=
806: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountDeliveredForLine');
807: d_position NUMBER := 0;
808: l_return_val NUMBER := 0;
809: l_precision GL_CURRENCIES.precision%TYPE;
810: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;

Line 813: IF PO_LOG.d_proc THEN

809: l_precision GL_CURRENCIES.precision%TYPE;
810: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
811: BEGIN
812:
813: IF PO_LOG.d_proc THEN
814: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);
815: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
816: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
817: END IF;

Line 814: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);

810: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
811: BEGIN
812:
813: IF PO_LOG.d_proc THEN
814: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);
815: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
816: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
817: END IF;
818:

Line 815: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);

811: BEGIN
812:
813: IF PO_LOG.d_proc THEN
814: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);
815: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
816: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
817: END IF;
818:
819: do_org_currency_setups(

Line 816: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);

812:
813: IF PO_LOG.d_proc THEN
814: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);
815: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
816: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
817: END IF;
818:
819: do_org_currency_setups(
820: p_doc_level => g_doc_level_LINE

Line 827: IF PO_LOG.d_stmt THEN

823: , x_min_acct_unit => l_mau
824: );
825:
826: d_position := 5;
827: IF PO_LOG.d_stmt THEN
828: PO_LOG.stmt(d_mod,d_position,'l_precision:',l_precision);
829: PO_LOG.stmt(d_mod,d_position,'l_mau:',l_mau);
830: END IF;
831:

Line 828: PO_LOG.stmt(d_mod,d_position,'l_precision:',l_precision);

824: );
825:
826: d_position := 5;
827: IF PO_LOG.d_stmt THEN
828: PO_LOG.stmt(d_mod,d_position,'l_precision:',l_precision);
829: PO_LOG.stmt(d_mod,d_position,'l_mau:',l_mau);
830: END IF;
831:
832: IF p_data_source = g_data_source_TRANSACTION THEN

Line 829: PO_LOG.stmt(d_mod,d_position,'l_mau:',l_mau);

825:
826: d_position := 5;
827: IF PO_LOG.d_stmt THEN
828: PO_LOG.stmt(d_mod,d_position,'l_precision:',l_precision);
829: PO_LOG.stmt(d_mod,d_position,'l_mau:',l_mau);
830: END IF;
831:
832: IF p_data_source = g_data_source_TRANSACTION THEN
833:

Line 853: IF PO_LOG.d_stmt THEN

849: AND pod.distribution_type = 'STANDARD'
850: ;
851: EXCEPTION
852: WHEN NO_DATA_FOUND THEN
853: IF PO_LOG.d_stmt THEN
854: PO_LOG.stmt(d_mod,d_position,'No distributions exist');
855: END IF;
856: l_return_val := 0;
857: END;

Line 854: PO_LOG.stmt(d_mod,d_position,'No distributions exist');

850: ;
851: EXCEPTION
852: WHEN NO_DATA_FOUND THEN
853: IF PO_LOG.d_stmt THEN
854: PO_LOG.stmt(d_mod,d_position,'No distributions exist');
855: END IF;
856: l_return_val := 0;
857: END;
858:

Line 896: IF PO_LOG.d_stmt THEN

892: )
893: ;
894: EXCEPTION
895: WHEN NO_DATA_FOUND THEN
896: IF PO_LOG.d_stmt THEN
897: PO_LOG.stmt(d_mod,d_position,'No distributions exist');
898: END IF;
899: l_return_val := 0;
900: END;

Line 897: PO_LOG.stmt(d_mod,d_position,'No distributions exist');

893: ;
894: EXCEPTION
895: WHEN NO_DATA_FOUND THEN
896: IF PO_LOG.d_stmt THEN
897: PO_LOG.stmt(d_mod,d_position,'No distributions exist');
898: END IF;
899: l_return_val := 0;
900: END;
901:

Line 905: IF PO_LOG.d_stmt THEN

901:
902: ELSE
903:
904: d_position := 30;
905: IF PO_LOG.d_stmt THEN
906: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);
907: END IF;
908:
909: END IF;

Line 906: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);

902: ELSE
903:
904: d_position := 30;
905: IF PO_LOG.d_stmt THEN
906: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);
907: END IF;
908:
909: END IF;
910:

Line 911: IF PO_LOG.d_proc THEN

907: END IF;
908:
909: END IF;
910:
911: IF PO_LOG.d_proc THEN
912: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);
913: END IF;
914:
915: RETURN l_return_val;

Line 912: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);

908:
909: END IF;
910:
911: IF PO_LOG.d_proc THEN
912: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);
913: END IF;
914:
915: RETURN l_return_val;
916:

Line 919: IF PO_LOG.d_exc THEN

915: RETURN l_return_val;
916:
917: EXCEPTION
918: WHEN OTHERS THEN
919: IF PO_LOG.d_exc THEN
920: PO_LOG.exc(d_mod,d_position,NULL);
921: END IF;
922: RAISE;
923: END getAmountDeliveredForLine;

Line 920: PO_LOG.exc(d_mod,d_position,NULL);

916:
917: EXCEPTION
918: WHEN OTHERS THEN
919: IF PO_LOG.d_exc THEN
920: PO_LOG.exc(d_mod,d_position,NULL);
921: END IF;
922: RAISE;
923: END getAmountDeliveredForLine;
924:

Line 973: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountDeliveredForHeader');

969: , p_doc_revision_num IN NUMBER --default null
970: ) RETURN NUMBER
971: IS
972: d_mod CONSTANT VARCHAR2(100) :=
973: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountDeliveredForHeader');
974: d_position NUMBER := 0;
975: l_return_val NUMBER := 0;
976: l_precision GL_CURRENCIES.precision%TYPE;
977: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;

Line 980: IF PO_LOG.d_proc THEN

976: l_precision GL_CURRENCIES.precision%TYPE;
977: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
978: BEGIN
979:
980: IF PO_LOG.d_proc THEN
981: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);
982: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
983: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
984: END IF;

Line 981: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);

977: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
978: BEGIN
979:
980: IF PO_LOG.d_proc THEN
981: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);
982: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
983: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
984: END IF;
985:

Line 982: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);

978: BEGIN
979:
980: IF PO_LOG.d_proc THEN
981: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);
982: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
983: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
984: END IF;
985:
986: do_org_currency_setups(

Line 983: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);

979:
980: IF PO_LOG.d_proc THEN
981: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);
982: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
983: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
984: END IF;
985:
986: do_org_currency_setups(
987: p_doc_level => g_doc_level_HEADER

Line 994: IF PO_LOG.d_stmt THEN

990: , x_min_acct_unit => l_mau
991: );
992:
993: d_position := 5;
994: IF PO_LOG.d_stmt THEN
995: PO_LOG.stmt(d_mod,d_position,'l_precision:',l_precision);
996: PO_LOG.stmt(d_mod,d_position,'l_mau:',l_mau);
997: END IF;
998:

Line 995: PO_LOG.stmt(d_mod,d_position,'l_precision:',l_precision);

991: );
992:
993: d_position := 5;
994: IF PO_LOG.d_stmt THEN
995: PO_LOG.stmt(d_mod,d_position,'l_precision:',l_precision);
996: PO_LOG.stmt(d_mod,d_position,'l_mau:',l_mau);
997: END IF;
998:
999: IF p_data_source = g_data_source_TRANSACTION THEN

Line 996: PO_LOG.stmt(d_mod,d_position,'l_mau:',l_mau);

992:
993: d_position := 5;
994: IF PO_LOG.d_stmt THEN
995: PO_LOG.stmt(d_mod,d_position,'l_precision:',l_precision);
996: PO_LOG.stmt(d_mod,d_position,'l_mau:',l_mau);
997: END IF;
998:
999: IF p_data_source = g_data_source_TRANSACTION THEN
1000:

Line 1020: IF PO_LOG.d_stmt THEN

1016: AND pod.distribution_type = 'STANDARD'
1017: ;
1018: EXCEPTION
1019: WHEN NO_DATA_FOUND THEN
1020: IF PO_LOG.d_stmt THEN
1021: PO_LOG.stmt(d_mod,d_position,'No distributions exist');
1022: END IF;
1023: l_return_val := 0;
1024: END;

Line 1021: PO_LOG.stmt(d_mod,d_position,'No distributions exist');

1017: ;
1018: EXCEPTION
1019: WHEN NO_DATA_FOUND THEN
1020: IF PO_LOG.d_stmt THEN
1021: PO_LOG.stmt(d_mod,d_position,'No distributions exist');
1022: END IF;
1023: l_return_val := 0;
1024: END;
1025:

Line 1063: IF PO_LOG.d_stmt THEN

1059: )
1060: ;
1061: EXCEPTION
1062: WHEN NO_DATA_FOUND THEN
1063: IF PO_LOG.d_stmt THEN
1064: PO_LOG.stmt(d_mod,d_position,'No distributions exist');
1065: END IF;
1066: l_return_val := 0;
1067: END;

Line 1064: PO_LOG.stmt(d_mod,d_position,'No distributions exist');

1060: ;
1061: EXCEPTION
1062: WHEN NO_DATA_FOUND THEN
1063: IF PO_LOG.d_stmt THEN
1064: PO_LOG.stmt(d_mod,d_position,'No distributions exist');
1065: END IF;
1066: l_return_val := 0;
1067: END;
1068:

Line 1072: IF PO_LOG.d_stmt THEN

1068:
1069: ELSE
1070:
1071: d_position := 30;
1072: IF PO_LOG.d_stmt THEN
1073: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);
1074: END IF;
1075:
1076: END IF;

Line 1073: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);

1069: ELSE
1070:
1071: d_position := 30;
1072: IF PO_LOG.d_stmt THEN
1073: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);
1074: END IF;
1075:
1076: END IF;
1077:

Line 1078: IF PO_LOG.d_proc THEN

1074: END IF;
1075:
1076: END IF;
1077:
1078: IF PO_LOG.d_proc THEN
1079: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);
1080: END IF;
1081:
1082: RETURN l_return_val;

Line 1079: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);

1075:
1076: END IF;
1077:
1078: IF PO_LOG.d_proc THEN
1079: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);
1080: END IF;
1081:
1082: RETURN l_return_val;
1083:

Line 1086: IF PO_LOG.d_exc THEN

1082: RETURN l_return_val;
1083:
1084: EXCEPTION
1085: WHEN OTHERS THEN
1086: IF PO_LOG.d_exc THEN
1087: PO_LOG.exc(d_mod,d_position,NULL);
1088: END IF;
1089: RAISE;
1090: END getAmountDeliveredForHeader;

Line 1087: PO_LOG.exc(d_mod,d_position,NULL);

1083:
1084: EXCEPTION
1085: WHEN OTHERS THEN
1086: IF PO_LOG.d_exc THEN
1087: PO_LOG.exc(d_mod,d_position,NULL);
1088: END IF;
1089: RAISE;
1090: END getAmountDeliveredForHeader;
1091:

Line 1137: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountBilledForLine');

1133: , p_doc_revision_num IN NUMBER --default null
1134: ) RETURN NUMBER
1135: IS
1136: d_mod CONSTANT VARCHAR2(100) :=
1137: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountBilledForLine');
1138: d_position NUMBER := 0;
1139: l_return_val NUMBER := 0;
1140: l_org_id PO_LINES_ALL.org_id%type;
1141: BEGIN

Line 1143: IF PO_LOG.d_proc THEN

1139: l_return_val NUMBER := 0;
1140: l_org_id PO_LINES_ALL.org_id%type;
1141: BEGIN
1142:
1143: IF PO_LOG.d_proc THEN
1144: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);
1145: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
1146: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
1147: END IF;

Line 1144: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);

1140: l_org_id PO_LINES_ALL.org_id%type;
1141: BEGIN
1142:
1143: IF PO_LOG.d_proc THEN
1144: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);
1145: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
1146: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
1147: END IF;
1148:

Line 1145: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);

1141: BEGIN
1142:
1143: IF PO_LOG.d_proc THEN
1144: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);
1145: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
1146: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
1147: END IF;
1148:
1149: d_position := 10;

Line 1146: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);

1142:
1143: IF PO_LOG.d_proc THEN
1144: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);
1145: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
1146: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
1147: END IF;
1148:
1149: d_position := 10;
1150:

Line 1157: IF PO_LOG.d_stmt THEN

1153: FROM po_lines_all pol
1154: WHERE pol.po_line_id = p_line_id;
1155:
1156: d_position := 20;
1157: IF PO_LOG.d_stmt THEN
1158: PO_LOG.stmt(d_mod,d_position,'l_org_id:',l_org_id);
1159: END IF;
1160:
1161: PO_MOAC_UTILS_PVT.set_org_context(l_org_id);

Line 1158: PO_LOG.stmt(d_mod,d_position,'l_org_id:',l_org_id);

1154: WHERE pol.po_line_id = p_line_id;
1155:
1156: d_position := 20;
1157: IF PO_LOG.d_stmt THEN
1158: PO_LOG.stmt(d_mod,d_position,'l_org_id:',l_org_id);
1159: END IF;
1160:
1161: PO_MOAC_UTILS_PVT.set_org_context(l_org_id);
1162:

Line 1176: IF PO_LOG.d_stmt THEN

1172: AND poll.shipment_type = 'STANDARD'
1173: ;
1174: EXCEPTION
1175: WHEN NO_DATA_FOUND THEN
1176: IF PO_LOG.d_stmt THEN
1177: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
1178: END IF;
1179: l_return_val := 0;
1180: END;

Line 1177: PO_LOG.stmt(d_mod,d_position,'No line locations exist');

1173: ;
1174: EXCEPTION
1175: WHEN NO_DATA_FOUND THEN
1176: IF PO_LOG.d_stmt THEN
1177: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
1178: END IF;
1179: l_return_val := 0;
1180: END;
1181:

Line 1204: IF PO_LOG.d_stmt THEN

1200: )
1201: ;
1202: EXCEPTION
1203: WHEN NO_DATA_FOUND THEN
1204: IF PO_LOG.d_stmt THEN
1205: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
1206: END IF;
1207: l_return_val := 0;
1208: END;

Line 1205: PO_LOG.stmt(d_mod,d_position,'No line locations exist');

1201: ;
1202: EXCEPTION
1203: WHEN NO_DATA_FOUND THEN
1204: IF PO_LOG.d_stmt THEN
1205: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
1206: END IF;
1207: l_return_val := 0;
1208: END;
1209:

Line 1213: IF PO_LOG.d_stmt THEN

1209:
1210: ELSE
1211:
1212: d_position := 50;
1213: IF PO_LOG.d_stmt THEN
1214: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);
1215: END IF;
1216:
1217: END IF;

Line 1214: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);

1210: ELSE
1211:
1212: d_position := 50;
1213: IF PO_LOG.d_stmt THEN
1214: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);
1215: END IF;
1216:
1217: END IF;
1218:

Line 1219: IF PO_LOG.d_proc THEN

1215: END IF;
1216:
1217: END IF;
1218:
1219: IF PO_LOG.d_proc THEN
1220: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);
1221: END IF;
1222:
1223: RETURN l_return_val;

Line 1220: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);

1216:
1217: END IF;
1218:
1219: IF PO_LOG.d_proc THEN
1220: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);
1221: END IF;
1222:
1223: RETURN l_return_val;
1224:

Line 1227: IF PO_LOG.d_exc THEN

1223: RETURN l_return_val;
1224:
1225: EXCEPTION
1226: WHEN OTHERS THEN
1227: IF PO_LOG.d_exc THEN
1228: PO_LOG.exc(d_mod,d_position,NULL);
1229: END IF;
1230: RAISE;
1231: END getAmountBilledForLine;

Line 1228: PO_LOG.exc(d_mod,d_position,NULL);

1224:
1225: EXCEPTION
1226: WHEN OTHERS THEN
1227: IF PO_LOG.d_exc THEN
1228: PO_LOG.exc(d_mod,d_position,NULL);
1229: END IF;
1230: RAISE;
1231: END getAmountBilledForLine;
1232:

Line 1278: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountBilledForHeader');

1274: , p_doc_revision_num IN NUMBER --default null
1275: ) RETURN NUMBER
1276: IS
1277: d_mod CONSTANT VARCHAR2(100) :=
1278: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountBilledForHeader');
1279: d_position NUMBER := 0;
1280: l_return_val NUMBER := 0;
1281: l_org_id PO_HEADERS_ALL.org_id%type;
1282: BEGIN

Line 1284: IF PO_LOG.d_proc THEN

1280: l_return_val NUMBER := 0;
1281: l_org_id PO_HEADERS_ALL.org_id%type;
1282: BEGIN
1283:
1284: IF PO_LOG.d_proc THEN
1285: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);
1286: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
1287: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
1288: END IF;

Line 1285: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);

1281: l_org_id PO_HEADERS_ALL.org_id%type;
1282: BEGIN
1283:
1284: IF PO_LOG.d_proc THEN
1285: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);
1286: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
1287: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
1288: END IF;
1289:

Line 1286: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);

1282: BEGIN
1283:
1284: IF PO_LOG.d_proc THEN
1285: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);
1286: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
1287: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
1288: END IF;
1289:
1290: d_position := 10;

Line 1287: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);

1283:
1284: IF PO_LOG.d_proc THEN
1285: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);
1286: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
1287: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
1288: END IF;
1289:
1290: d_position := 10;
1291:

Line 1299: IF PO_LOG.d_stmt THEN

1295: WHERE poh.po_header_id = p_header_id
1296: ;
1297:
1298: d_position := 20;
1299: IF PO_LOG.d_stmt THEN
1300: PO_LOG.stmt(d_mod,d_position,'l_org_id:',l_org_id);
1301: END IF;
1302:
1303: PO_MOAC_UTILS_PVT.set_org_context(l_org_id);

Line 1300: PO_LOG.stmt(d_mod,d_position,'l_org_id:',l_org_id);

1296: ;
1297:
1298: d_position := 20;
1299: IF PO_LOG.d_stmt THEN
1300: PO_LOG.stmt(d_mod,d_position,'l_org_id:',l_org_id);
1301: END IF;
1302:
1303: PO_MOAC_UTILS_PVT.set_org_context(l_org_id);
1304:

Line 1318: IF PO_LOG.d_stmt THEN

1314: AND poll.shipment_type = 'STANDARD'
1315: ;
1316: EXCEPTION
1317: WHEN NO_DATA_FOUND THEN
1318: IF PO_LOG.d_stmt THEN
1319: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
1320: END IF;
1321: l_return_val := 0;
1322: END;

Line 1319: PO_LOG.stmt(d_mod,d_position,'No line locations exist');

1315: ;
1316: EXCEPTION
1317: WHEN NO_DATA_FOUND THEN
1318: IF PO_LOG.d_stmt THEN
1319: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
1320: END IF;
1321: l_return_val := 0;
1322: END;
1323:

Line 1346: IF PO_LOG.d_stmt THEN

1342: )
1343: ;
1344: EXCEPTION
1345: WHEN NO_DATA_FOUND THEN
1346: IF PO_LOG.d_stmt THEN
1347: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
1348: END IF;
1349: l_return_val := 0;
1350: END;

Line 1347: PO_LOG.stmt(d_mod,d_position,'No line locations exist');

1343: ;
1344: EXCEPTION
1345: WHEN NO_DATA_FOUND THEN
1346: IF PO_LOG.d_stmt THEN
1347: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
1348: END IF;
1349: l_return_val := 0;
1350: END;
1351:

Line 1355: IF PO_LOG.d_stmt THEN

1351:
1352: ELSE
1353:
1354: d_position := 50;
1355: IF PO_LOG.d_stmt THEN
1356: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);
1357: END IF;
1358:
1359: END IF;

Line 1356: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);

1352: ELSE
1353:
1354: d_position := 50;
1355: IF PO_LOG.d_stmt THEN
1356: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);
1357: END IF;
1358:
1359: END IF;
1360:

Line 1361: IF PO_LOG.d_proc THEN

1357: END IF;
1358:
1359: END IF;
1360:
1361: IF PO_LOG.d_proc THEN
1362: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);
1363: END IF;
1364:
1365: RETURN l_return_val;

Line 1362: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);

1358:
1359: END IF;
1360:
1361: IF PO_LOG.d_proc THEN
1362: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);
1363: END IF;
1364:
1365: RETURN l_return_val;
1366:

Line 1369: IF PO_LOG.d_exc THEN

1365: RETURN l_return_val;
1366:
1367: EXCEPTION
1368: WHEN OTHERS THEN
1369: IF PO_LOG.d_exc THEN
1370: PO_LOG.exc(d_mod,d_position,NULL);
1371: END IF;
1372: RAISE;
1373: END getAmountBilledForHeader;

Line 1370: PO_LOG.exc(d_mod,d_position,NULL);

1366:
1367: EXCEPTION
1368: WHEN OTHERS THEN
1369: IF PO_LOG.d_exc THEN
1370: PO_LOG.exc(d_mod,d_position,NULL);
1371: END IF;
1372: RAISE;
1373: END getAmountBilledForHeader;
1374:

Line 1420: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountFinancedForLine');

1416: , p_doc_revision_num IN NUMBER --default null
1417: ) RETURN NUMBER
1418: IS
1419: d_mod CONSTANT VARCHAR2(100) :=
1420: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountFinancedForLine');
1421: d_position NUMBER := 0;
1422: l_return_val NUMBER := 0;
1423: l_org_id PO_LINES_ALL.org_id%type;
1424: BEGIN

Line 1426: IF PO_LOG.d_proc THEN

1422: l_return_val NUMBER := 0;
1423: l_org_id PO_LINES_ALL.org_id%type;
1424: BEGIN
1425:
1426: IF PO_LOG.d_proc THEN
1427: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);
1428: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
1429: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
1430: END IF;

Line 1427: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);

1423: l_org_id PO_LINES_ALL.org_id%type;
1424: BEGIN
1425:
1426: IF PO_LOG.d_proc THEN
1427: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);
1428: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
1429: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
1430: END IF;
1431:

Line 1428: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);

1424: BEGIN
1425:
1426: IF PO_LOG.d_proc THEN
1427: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);
1428: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
1429: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
1430: END IF;
1431:
1432: d_position := 10;

Line 1429: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);

1425:
1426: IF PO_LOG.d_proc THEN
1427: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);
1428: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
1429: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
1430: END IF;
1431:
1432: d_position := 10;
1433:

Line 1440: IF PO_LOG.d_stmt THEN

1436: FROM po_lines_all pol
1437: WHERE pol.po_line_id = p_line_id;
1438:
1439: d_position := 20;
1440: IF PO_LOG.d_stmt THEN
1441: PO_LOG.stmt(d_mod,d_position,'l_org_id:',l_org_id);
1442: END IF;
1443:
1444: PO_MOAC_UTILS_PVT.set_org_context(l_org_id);

Line 1441: PO_LOG.stmt(d_mod,d_position,'l_org_id:',l_org_id);

1437: WHERE pol.po_line_id = p_line_id;
1438:
1439: d_position := 20;
1440: IF PO_LOG.d_stmt THEN
1441: PO_LOG.stmt(d_mod,d_position,'l_org_id:',l_org_id);
1442: END IF;
1443:
1444: PO_MOAC_UTILS_PVT.set_org_context(l_org_id);
1445:

Line 1459: IF PO_LOG.d_stmt THEN

1455: AND poll.shipment_type = 'PREPAYMENT'
1456: ;
1457: EXCEPTION
1458: WHEN NO_DATA_FOUND THEN
1459: IF PO_LOG.d_stmt THEN
1460: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
1461: END IF;
1462: l_return_val := 0;
1463: END;

Line 1460: PO_LOG.stmt(d_mod,d_position,'No line locations exist');

1456: ;
1457: EXCEPTION
1458: WHEN NO_DATA_FOUND THEN
1459: IF PO_LOG.d_stmt THEN
1460: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
1461: END IF;
1462: l_return_val := 0;
1463: END;
1464:

Line 1487: IF PO_LOG.d_stmt THEN

1483: )
1484: ;
1485: EXCEPTION
1486: WHEN NO_DATA_FOUND THEN
1487: IF PO_LOG.d_stmt THEN
1488: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
1489: END IF;
1490: l_return_val := 0;
1491: END;

Line 1488: PO_LOG.stmt(d_mod,d_position,'No line locations exist');

1484: ;
1485: EXCEPTION
1486: WHEN NO_DATA_FOUND THEN
1487: IF PO_LOG.d_stmt THEN
1488: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
1489: END IF;
1490: l_return_val := 0;
1491: END;
1492:

Line 1496: IF PO_LOG.d_stmt THEN

1492:
1493: ELSE
1494:
1495: d_position := 50;
1496: IF PO_LOG.d_stmt THEN
1497: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);
1498: END IF;
1499:
1500: END IF;

Line 1497: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);

1493: ELSE
1494:
1495: d_position := 50;
1496: IF PO_LOG.d_stmt THEN
1497: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);
1498: END IF;
1499:
1500: END IF;
1501:

Line 1502: IF PO_LOG.d_proc THEN

1498: END IF;
1499:
1500: END IF;
1501:
1502: IF PO_LOG.d_proc THEN
1503: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);
1504: END IF;
1505:
1506: RETURN l_return_val;

Line 1503: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);

1499:
1500: END IF;
1501:
1502: IF PO_LOG.d_proc THEN
1503: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);
1504: END IF;
1505:
1506: RETURN l_return_val;
1507:

Line 1510: IF PO_LOG.d_exc THEN

1506: RETURN l_return_val;
1507:
1508: EXCEPTION
1509: WHEN OTHERS THEN
1510: IF PO_LOG.d_exc THEN
1511: PO_LOG.exc(d_mod,d_position,NULL);
1512: END IF;
1513: RAISE;
1514: END getAmountFinancedForLine;

Line 1511: PO_LOG.exc(d_mod,d_position,NULL);

1507:
1508: EXCEPTION
1509: WHEN OTHERS THEN
1510: IF PO_LOG.d_exc THEN
1511: PO_LOG.exc(d_mod,d_position,NULL);
1512: END IF;
1513: RAISE;
1514: END getAmountFinancedForLine;
1515:

Line 1561: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountFinancedForHeader');

1557: , p_doc_revision_num IN NUMBER --default null
1558: ) RETURN NUMBER
1559: IS
1560: d_mod CONSTANT VARCHAR2(100) :=
1561: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountFinancedForHeader');
1562: d_position NUMBER := 0;
1563: l_return_val NUMBER := 0;
1564: l_org_id PO_HEADERS_ALL.org_id%type;
1565: BEGIN

Line 1567: IF PO_LOG.d_proc THEN

1563: l_return_val NUMBER := 0;
1564: l_org_id PO_HEADERS_ALL.org_id%type;
1565: BEGIN
1566:
1567: IF PO_LOG.d_proc THEN
1568: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);
1569: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
1570: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
1571: END IF;

Line 1568: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);

1564: l_org_id PO_HEADERS_ALL.org_id%type;
1565: BEGIN
1566:
1567: IF PO_LOG.d_proc THEN
1568: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);
1569: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
1570: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
1571: END IF;
1572:

Line 1569: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);

1565: BEGIN
1566:
1567: IF PO_LOG.d_proc THEN
1568: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);
1569: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
1570: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
1571: END IF;
1572:
1573: d_position := 10;

Line 1570: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);

1566:
1567: IF PO_LOG.d_proc THEN
1568: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);
1569: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
1570: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
1571: END IF;
1572:
1573: d_position := 10;
1574:

Line 1582: IF PO_LOG.d_stmt THEN

1578: WHERE poh.po_header_id = p_header_id
1579: ;
1580:
1581: d_position := 20;
1582: IF PO_LOG.d_stmt THEN
1583: PO_LOG.stmt(d_mod,d_position,'l_org_id:',l_org_id);
1584: END IF;
1585:
1586: PO_MOAC_UTILS_PVT.set_org_context(l_org_id);

Line 1583: PO_LOG.stmt(d_mod,d_position,'l_org_id:',l_org_id);

1579: ;
1580:
1581: d_position := 20;
1582: IF PO_LOG.d_stmt THEN
1583: PO_LOG.stmt(d_mod,d_position,'l_org_id:',l_org_id);
1584: END IF;
1585:
1586: PO_MOAC_UTILS_PVT.set_org_context(l_org_id);
1587:

Line 1601: IF PO_LOG.d_stmt THEN

1597: AND poll.shipment_type = 'PREPAYMENT'
1598: ;
1599: EXCEPTION
1600: WHEN NO_DATA_FOUND THEN
1601: IF PO_LOG.d_stmt THEN
1602: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
1603: END IF;
1604: l_return_val := 0;
1605: END;

Line 1602: PO_LOG.stmt(d_mod,d_position,'No line locations exist');

1598: ;
1599: EXCEPTION
1600: WHEN NO_DATA_FOUND THEN
1601: IF PO_LOG.d_stmt THEN
1602: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
1603: END IF;
1604: l_return_val := 0;
1605: END;
1606:

Line 1629: IF PO_LOG.d_stmt THEN

1625: )
1626: ;
1627: EXCEPTION
1628: WHEN NO_DATA_FOUND THEN
1629: IF PO_LOG.d_stmt THEN
1630: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
1631: END IF;
1632: l_return_val := 0;
1633: END;

Line 1630: PO_LOG.stmt(d_mod,d_position,'No line locations exist');

1626: ;
1627: EXCEPTION
1628: WHEN NO_DATA_FOUND THEN
1629: IF PO_LOG.d_stmt THEN
1630: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
1631: END IF;
1632: l_return_val := 0;
1633: END;
1634:

Line 1638: IF PO_LOG.d_stmt THEN

1634:
1635: ELSE
1636:
1637: d_position := 50;
1638: IF PO_LOG.d_stmt THEN
1639: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);
1640: END IF;
1641:
1642: END IF;

Line 1639: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);

1635: ELSE
1636:
1637: d_position := 50;
1638: IF PO_LOG.d_stmt THEN
1639: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);
1640: END IF;
1641:
1642: END IF;
1643:

Line 1644: IF PO_LOG.d_proc THEN

1640: END IF;
1641:
1642: END IF;
1643:
1644: IF PO_LOG.d_proc THEN
1645: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);
1646: END IF;
1647:
1648: RETURN l_return_val;

Line 1645: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);

1641:
1642: END IF;
1643:
1644: IF PO_LOG.d_proc THEN
1645: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);
1646: END IF;
1647:
1648: RETURN l_return_val;
1649:

Line 1652: IF PO_LOG.d_exc THEN

1648: RETURN l_return_val;
1649:
1650: EXCEPTION
1651: WHEN OTHERS THEN
1652: IF PO_LOG.d_exc THEN
1653: PO_LOG.exc(d_mod,d_position,NULL);
1654: END IF;
1655: RAISE;
1656: END getAmountFinancedForHeader;

Line 1653: PO_LOG.exc(d_mod,d_position,NULL);

1649:
1650: EXCEPTION
1651: WHEN OTHERS THEN
1652: IF PO_LOG.d_exc THEN
1653: PO_LOG.exc(d_mod,d_position,NULL);
1654: END IF;
1655: RAISE;
1656: END getAmountFinancedForHeader;
1657:

Line 1700: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountRecoupedForLine');

1696: , p_doc_revision_num IN NUMBER --default null
1697: ) RETURN NUMBER
1698: IS
1699: d_mod CONSTANT VARCHAR2(100) :=
1700: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountRecoupedForLine');
1701: d_position NUMBER := 0;
1702: l_return_val NUMBER := 0;
1703: l_org_id PO_LINES_ALL.org_id%type;
1704: BEGIN

Line 1706: IF PO_LOG.d_proc THEN

1702: l_return_val NUMBER := 0;
1703: l_org_id PO_LINES_ALL.org_id%type;
1704: BEGIN
1705:
1706: IF PO_LOG.d_proc THEN
1707: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);
1708: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
1709: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
1710: END IF;

Line 1707: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);

1703: l_org_id PO_LINES_ALL.org_id%type;
1704: BEGIN
1705:
1706: IF PO_LOG.d_proc THEN
1707: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);
1708: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
1709: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
1710: END IF;
1711:

Line 1708: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);

1704: BEGIN
1705:
1706: IF PO_LOG.d_proc THEN
1707: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);
1708: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
1709: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
1710: END IF;
1711:
1712: d_position := 10;

Line 1709: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);

1705:
1706: IF PO_LOG.d_proc THEN
1707: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);
1708: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
1709: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
1710: END IF;
1711:
1712: d_position := 10;
1713:

Line 1720: IF PO_LOG.d_stmt THEN

1716: FROM po_lines_all pol
1717: WHERE pol.po_line_id = p_line_id;
1718:
1719: d_position := 20;
1720: IF PO_LOG.d_stmt THEN
1721: PO_LOG.stmt(d_mod,d_position,'l_org_id:',l_org_id);
1722: END IF;
1723:
1724: PO_MOAC_UTILS_PVT.set_org_context(l_org_id);

Line 1721: PO_LOG.stmt(d_mod,d_position,'l_org_id:',l_org_id);

1717: WHERE pol.po_line_id = p_line_id;
1718:
1719: d_position := 20;
1720: IF PO_LOG.d_stmt THEN
1721: PO_LOG.stmt(d_mod,d_position,'l_org_id:',l_org_id);
1722: END IF;
1723:
1724: PO_MOAC_UTILS_PVT.set_org_context(l_org_id);
1725:

Line 1739: IF PO_LOG.d_stmt THEN

1735: AND poll.shipment_type = 'PREPAYMENT'
1736: ;
1737: EXCEPTION
1738: WHEN NO_DATA_FOUND THEN
1739: IF PO_LOG.d_stmt THEN
1740: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
1741: END IF;
1742: l_return_val := 0;
1743: END;

Line 1740: PO_LOG.stmt(d_mod,d_position,'No line locations exist');

1736: ;
1737: EXCEPTION
1738: WHEN NO_DATA_FOUND THEN
1739: IF PO_LOG.d_stmt THEN
1740: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
1741: END IF;
1742: l_return_val := 0;
1743: END;
1744:

Line 1767: IF PO_LOG.d_stmt THEN

1763: )
1764: ;
1765: EXCEPTION
1766: WHEN NO_DATA_FOUND THEN
1767: IF PO_LOG.d_stmt THEN
1768: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
1769: END IF;
1770: l_return_val := 0;
1771: END;

Line 1768: PO_LOG.stmt(d_mod,d_position,'No line locations exist');

1764: ;
1765: EXCEPTION
1766: WHEN NO_DATA_FOUND THEN
1767: IF PO_LOG.d_stmt THEN
1768: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
1769: END IF;
1770: l_return_val := 0;
1771: END;
1772:

Line 1776: IF PO_LOG.d_stmt THEN

1772:
1773: ELSE
1774:
1775: d_position := 30;
1776: IF PO_LOG.d_stmt THEN
1777: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);
1778: END IF;
1779:
1780: END IF;

Line 1777: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);

1773: ELSE
1774:
1775: d_position := 30;
1776: IF PO_LOG.d_stmt THEN
1777: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);
1778: END IF;
1779:
1780: END IF;
1781:

Line 1782: IF PO_LOG.d_proc THEN

1778: END IF;
1779:
1780: END IF;
1781:
1782: IF PO_LOG.d_proc THEN
1783: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);
1784: END IF;
1785:
1786: RETURN l_return_val;

Line 1783: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);

1779:
1780: END IF;
1781:
1782: IF PO_LOG.d_proc THEN
1783: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);
1784: END IF;
1785:
1786: RETURN l_return_val;
1787:

Line 1790: IF PO_LOG.d_exc THEN

1786: RETURN l_return_val;
1787:
1788: EXCEPTION
1789: WHEN OTHERS THEN
1790: IF PO_LOG.d_exc THEN
1791: PO_LOG.exc(d_mod,d_position,NULL);
1792: END IF;
1793: RAISE;
1794: END getAmountRecoupedForLine;

Line 1791: PO_LOG.exc(d_mod,d_position,NULL);

1787:
1788: EXCEPTION
1789: WHEN OTHERS THEN
1790: IF PO_LOG.d_exc THEN
1791: PO_LOG.exc(d_mod,d_position,NULL);
1792: END IF;
1793: RAISE;
1794: END getAmountRecoupedForLine;
1795:

Line 1838: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountRecoupedForHeader');

1834: , p_doc_revision_num IN NUMBER --default null
1835: ) RETURN NUMBER
1836: IS
1837: d_mod CONSTANT VARCHAR2(100) :=
1838: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountRecoupedForHeader');
1839: d_position NUMBER := 0;
1840: l_return_val NUMBER := 0;
1841: l_org_id PO_HEADERS_ALL.org_id%type;
1842: BEGIN

Line 1844: IF PO_LOG.d_proc THEN

1840: l_return_val NUMBER := 0;
1841: l_org_id PO_HEADERS_ALL.org_id%type;
1842: BEGIN
1843:
1844: IF PO_LOG.d_proc THEN
1845: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);
1846: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
1847: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
1848: END IF;

Line 1845: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);

1841: l_org_id PO_HEADERS_ALL.org_id%type;
1842: BEGIN
1843:
1844: IF PO_LOG.d_proc THEN
1845: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);
1846: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
1847: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
1848: END IF;
1849:

Line 1846: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);

1842: BEGIN
1843:
1844: IF PO_LOG.d_proc THEN
1845: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);
1846: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
1847: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
1848: END IF;
1849:
1850: d_position := 10;

Line 1847: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);

1843:
1844: IF PO_LOG.d_proc THEN
1845: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);
1846: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
1847: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
1848: END IF;
1849:
1850: d_position := 10;
1851:

Line 1859: IF PO_LOG.d_stmt THEN

1855: WHERE poh.po_header_id = p_header_id
1856: ;
1857:
1858: d_position := 20;
1859: IF PO_LOG.d_stmt THEN
1860: PO_LOG.stmt(d_mod,d_position,'l_org_id:',l_org_id);
1861: END IF;
1862:
1863: PO_MOAC_UTILS_PVT.set_org_context(l_org_id);

Line 1860: PO_LOG.stmt(d_mod,d_position,'l_org_id:',l_org_id);

1856: ;
1857:
1858: d_position := 20;
1859: IF PO_LOG.d_stmt THEN
1860: PO_LOG.stmt(d_mod,d_position,'l_org_id:',l_org_id);
1861: END IF;
1862:
1863: PO_MOAC_UTILS_PVT.set_org_context(l_org_id);
1864:

Line 1878: IF PO_LOG.d_stmt THEN

1874: AND poll.shipment_type = 'PREPAYMENT'
1875: ;
1876: EXCEPTION
1877: WHEN NO_DATA_FOUND THEN
1878: IF PO_LOG.d_stmt THEN
1879: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
1880: END IF;
1881: l_return_val := 0;
1882: END;

Line 1879: PO_LOG.stmt(d_mod,d_position,'No line locations exist');

1875: ;
1876: EXCEPTION
1877: WHEN NO_DATA_FOUND THEN
1878: IF PO_LOG.d_stmt THEN
1879: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
1880: END IF;
1881: l_return_val := 0;
1882: END;
1883:

Line 1906: IF PO_LOG.d_stmt THEN

1902: )
1903: ;
1904: EXCEPTION
1905: WHEN NO_DATA_FOUND THEN
1906: IF PO_LOG.d_stmt THEN
1907: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
1908: END IF;
1909: l_return_val := 0;
1910: END;

Line 1907: PO_LOG.stmt(d_mod,d_position,'No line locations exist');

1903: ;
1904: EXCEPTION
1905: WHEN NO_DATA_FOUND THEN
1906: IF PO_LOG.d_stmt THEN
1907: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
1908: END IF;
1909: l_return_val := 0;
1910: END;
1911:

Line 1915: IF PO_LOG.d_stmt THEN

1911:
1912: ELSE
1913:
1914: d_position := 50;
1915: IF PO_LOG.d_stmt THEN
1916: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);
1917: END IF;
1918:
1919: END IF;

Line 1916: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);

1912: ELSE
1913:
1914: d_position := 50;
1915: IF PO_LOG.d_stmt THEN
1916: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);
1917: END IF;
1918:
1919: END IF;
1920:

Line 1921: IF PO_LOG.d_proc THEN

1917: END IF;
1918:
1919: END IF;
1920:
1921: IF PO_LOG.d_proc THEN
1922: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);
1923: END IF;
1924:
1925: RETURN l_return_val;

Line 1922: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);

1918:
1919: END IF;
1920:
1921: IF PO_LOG.d_proc THEN
1922: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);
1923: END IF;
1924:
1925: RETURN l_return_val;
1926:

Line 1929: IF PO_LOG.d_exc THEN

1925: RETURN l_return_val;
1926:
1927: EXCEPTION
1928: WHEN OTHERS THEN
1929: IF PO_LOG.d_exc THEN
1930: PO_LOG.exc(d_mod,d_position,NULL);
1931: END IF;
1932: RAISE;
1933: END getAmountRecoupedForHeader;

Line 1930: PO_LOG.exc(d_mod,d_position,NULL);

1926:
1927: EXCEPTION
1928: WHEN OTHERS THEN
1929: IF PO_LOG.d_exc THEN
1930: PO_LOG.exc(d_mod,d_position,NULL);
1931: END IF;
1932: RAISE;
1933: END getAmountRecoupedForHeader;
1934:

Line 1978: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountRetainedForLine');

1974: , p_doc_revision_num IN NUMBER --default null
1975: ) RETURN NUMBER
1976: IS
1977: d_mod CONSTANT VARCHAR2(100) :=
1978: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountRetainedForLine');
1979: d_position NUMBER := 0;
1980: l_return_val NUMBER := 0;
1981: l_org_id PO_LINES_ALL.org_id%type;
1982: BEGIN

Line 1984: IF PO_LOG.d_proc THEN

1980: l_return_val NUMBER := 0;
1981: l_org_id PO_LINES_ALL.org_id%type;
1982: BEGIN
1983:
1984: IF PO_LOG.d_proc THEN
1985: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);
1986: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
1987: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
1988: END IF;

Line 1985: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);

1981: l_org_id PO_LINES_ALL.org_id%type;
1982: BEGIN
1983:
1984: IF PO_LOG.d_proc THEN
1985: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);
1986: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
1987: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
1988: END IF;
1989:

Line 1986: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);

1982: BEGIN
1983:
1984: IF PO_LOG.d_proc THEN
1985: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);
1986: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
1987: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
1988: END IF;
1989:
1990: d_position := 10;

Line 1987: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);

1983:
1984: IF PO_LOG.d_proc THEN
1985: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);
1986: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
1987: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
1988: END IF;
1989:
1990: d_position := 10;
1991:

Line 1998: IF PO_LOG.d_stmt THEN

1994: FROM po_lines_all pol
1995: WHERE pol.po_line_id = p_line_id;
1996:
1997: d_position := 20;
1998: IF PO_LOG.d_stmt THEN
1999: PO_LOG.stmt(d_mod,d_position,'l_org_id:',l_org_id);
2000: END IF;
2001:
2002: PO_MOAC_UTILS_PVT.set_org_context(l_org_id);

Line 1999: PO_LOG.stmt(d_mod,d_position,'l_org_id:',l_org_id);

1995: WHERE pol.po_line_id = p_line_id;
1996:
1997: d_position := 20;
1998: IF PO_LOG.d_stmt THEN
1999: PO_LOG.stmt(d_mod,d_position,'l_org_id:',l_org_id);
2000: END IF;
2001:
2002: PO_MOAC_UTILS_PVT.set_org_context(l_org_id);
2003:

Line 2018: IF PO_LOG.d_stmt THEN

2014: AND poll.shipment_type = 'STANDARD'
2015: ;
2016: EXCEPTION
2017: WHEN NO_DATA_FOUND THEN
2018: IF PO_LOG.d_stmt THEN
2019: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
2020: END IF;
2021: l_return_val := 0;
2022: END;

Line 2019: PO_LOG.stmt(d_mod,d_position,'No line locations exist');

2015: ;
2016: EXCEPTION
2017: WHEN NO_DATA_FOUND THEN
2018: IF PO_LOG.d_stmt THEN
2019: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
2020: END IF;
2021: l_return_val := 0;
2022: END;
2023:

Line 2047: IF PO_LOG.d_stmt THEN

2043: )
2044: ;
2045: EXCEPTION
2046: WHEN NO_DATA_FOUND THEN
2047: IF PO_LOG.d_stmt THEN
2048: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
2049: END IF;
2050: l_return_val := 0;
2051: END;

Line 2048: PO_LOG.stmt(d_mod,d_position,'No line locations exist');

2044: ;
2045: EXCEPTION
2046: WHEN NO_DATA_FOUND THEN
2047: IF PO_LOG.d_stmt THEN
2048: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
2049: END IF;
2050: l_return_val := 0;
2051: END;
2052:

Line 2056: IF PO_LOG.d_stmt THEN

2052:
2053: ELSE
2054:
2055: d_position := 50;
2056: IF PO_LOG.d_stmt THEN
2057: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);
2058: END IF;
2059:
2060: END IF;

Line 2057: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);

2053: ELSE
2054:
2055: d_position := 50;
2056: IF PO_LOG.d_stmt THEN
2057: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);
2058: END IF;
2059:
2060: END IF;
2061:

Line 2062: IF PO_LOG.d_proc THEN

2058: END IF;
2059:
2060: END IF;
2061:
2062: IF PO_LOG.d_proc THEN
2063: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);
2064: END IF;
2065:
2066: RETURN l_return_val;

Line 2063: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);

2059:
2060: END IF;
2061:
2062: IF PO_LOG.d_proc THEN
2063: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);
2064: END IF;
2065:
2066: RETURN l_return_val;
2067:

Line 2070: IF PO_LOG.d_exc THEN

2066: RETURN l_return_val;
2067:
2068: EXCEPTION
2069: WHEN OTHERS THEN
2070: IF PO_LOG.d_exc THEN
2071: PO_LOG.exc(d_mod,d_position,NULL);
2072: END IF;
2073: RAISE;
2074: END getAmountRetainedForLine;

Line 2071: PO_LOG.exc(d_mod,d_position,NULL);

2067:
2068: EXCEPTION
2069: WHEN OTHERS THEN
2070: IF PO_LOG.d_exc THEN
2071: PO_LOG.exc(d_mod,d_position,NULL);
2072: END IF;
2073: RAISE;
2074: END getAmountRetainedForLine;
2075:

Line 2119: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountRetainedForHeader');

2115: , p_doc_revision_num IN NUMBER --default null
2116: ) RETURN NUMBER
2117: IS
2118: d_mod CONSTANT VARCHAR2(100) :=
2119: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getAmountRetainedForHeader');
2120: d_position NUMBER := 0;
2121: l_return_val NUMBER := 0;
2122: l_org_id PO_HEADERS_ALL.org_id%type;
2123: BEGIN

Line 2125: IF PO_LOG.d_proc THEN

2121: l_return_val NUMBER := 0;
2122: l_org_id PO_HEADERS_ALL.org_id%type;
2123: BEGIN
2124:
2125: IF PO_LOG.d_proc THEN
2126: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);
2127: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
2128: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
2129: END IF;

Line 2126: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);

2122: l_org_id PO_HEADERS_ALL.org_id%type;
2123: BEGIN
2124:
2125: IF PO_LOG.d_proc THEN
2126: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);
2127: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
2128: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
2129: END IF;
2130:

Line 2127: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);

2123: BEGIN
2124:
2125: IF PO_LOG.d_proc THEN
2126: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);
2127: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
2128: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
2129: END IF;
2130:
2131: d_position := 10;

Line 2128: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);

2124:
2125: IF PO_LOG.d_proc THEN
2126: PO_LOG.proc_begin(d_mod,'p_header_id',p_header_id);
2127: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
2128: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
2129: END IF;
2130:
2131: d_position := 10;
2132:

Line 2140: IF PO_LOG.d_stmt THEN

2136: WHERE poh.po_header_id = p_header_id
2137: ;
2138:
2139: d_position := 20;
2140: IF PO_LOG.d_stmt THEN
2141: PO_LOG.stmt(d_mod,d_position,'l_org_id:',l_org_id);
2142: END IF;
2143:
2144: PO_MOAC_UTILS_PVT.set_org_context(l_org_id);

Line 2141: PO_LOG.stmt(d_mod,d_position,'l_org_id:',l_org_id);

2137: ;
2138:
2139: d_position := 20;
2140: IF PO_LOG.d_stmt THEN
2141: PO_LOG.stmt(d_mod,d_position,'l_org_id:',l_org_id);
2142: END IF;
2143:
2144: PO_MOAC_UTILS_PVT.set_org_context(l_org_id);
2145:

Line 2160: IF PO_LOG.d_stmt THEN

2156: AND poll.shipment_type = 'STANDARD'
2157: ;
2158: EXCEPTION
2159: WHEN NO_DATA_FOUND THEN
2160: IF PO_LOG.d_stmt THEN
2161: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
2162: END IF;
2163: l_return_val := 0;
2164: END;

Line 2161: PO_LOG.stmt(d_mod,d_position,'No line locations exist');

2157: ;
2158: EXCEPTION
2159: WHEN NO_DATA_FOUND THEN
2160: IF PO_LOG.d_stmt THEN
2161: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
2162: END IF;
2163: l_return_val := 0;
2164: END;
2165:

Line 2189: IF PO_LOG.d_stmt THEN

2185: )
2186: ;
2187: EXCEPTION
2188: WHEN NO_DATA_FOUND THEN
2189: IF PO_LOG.d_stmt THEN
2190: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
2191: END IF;
2192: l_return_val := 0;
2193: END;

Line 2190: PO_LOG.stmt(d_mod,d_position,'No line locations exist');

2186: ;
2187: EXCEPTION
2188: WHEN NO_DATA_FOUND THEN
2189: IF PO_LOG.d_stmt THEN
2190: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
2191: END IF;
2192: l_return_val := 0;
2193: END;
2194:

Line 2198: IF PO_LOG.d_stmt THEN

2194:
2195: ELSE
2196:
2197: d_position := 50;
2198: IF PO_LOG.d_stmt THEN
2199: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);
2200: END IF;
2201:
2202: END IF;

Line 2199: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);

2195: ELSE
2196:
2197: d_position := 50;
2198: IF PO_LOG.d_stmt THEN
2199: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);
2200: END IF;
2201:
2202: END IF;
2203:

Line 2204: IF PO_LOG.d_proc THEN

2200: END IF;
2201:
2202: END IF;
2203:
2204: IF PO_LOG.d_proc THEN
2205: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);
2206: END IF;
2207:
2208: RETURN l_return_val;

Line 2205: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);

2201:
2202: END IF;
2203:
2204: IF PO_LOG.d_proc THEN
2205: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);
2206: END IF;
2207:
2208: RETURN l_return_val;
2209:

Line 2212: IF PO_LOG.d_exc THEN

2208: RETURN l_return_val;
2209:
2210: EXCEPTION
2211: WHEN OTHERS THEN
2212: IF PO_LOG.d_exc THEN
2213: PO_LOG.exc(d_mod,d_position,NULL);
2214: END IF;
2215: RAISE;
2216: END getAmountRetainedForHeader;

Line 2213: PO_LOG.exc(d_mod,d_position,NULL);

2209:
2210: EXCEPTION
2211: WHEN OTHERS THEN
2212: IF PO_LOG.d_exc THEN
2213: PO_LOG.exc(d_mod,d_position,NULL);
2214: END IF;
2215: RAISE;
2216: END getAmountRetainedForHeader;
2217:

Line 2249: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getLineLocQuantityForLine');

2245: p_line_id IN NUMBER
2246: ) RETURN NUMBER
2247: IS
2248: d_mod CONSTANT VARCHAR2(100) :=
2249: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getLineLocQuantityForLine');
2250: d_position NUMBER := 0;
2251: l_return_val NUMBER := 0;
2252: l_header_id PO_HEADERS_ALL.po_header_id%TYPE;
2253: l_is_complex_work_po BOOLEAN := FALSE;

Line 2256: IF PO_LOG.d_proc THEN

2252: l_header_id PO_HEADERS_ALL.po_header_id%TYPE;
2253: l_is_complex_work_po BOOLEAN := FALSE;
2254: BEGIN
2255:
2256: IF PO_LOG.d_proc THEN
2257: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);
2258: END IF;
2259:
2260: d_position := 10;

Line 2257: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);

2253: l_is_complex_work_po BOOLEAN := FALSE;
2254: BEGIN
2255:
2256: IF PO_LOG.d_proc THEN
2257: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);
2258: END IF;
2259:
2260: d_position := 10;
2261:

Line 2269: IF PO_LOG.d_stmt THEN

2265: WHERE pol.po_line_id = p_line_id
2266: ;
2267:
2268: d_position := 20;
2269: IF PO_LOG.d_stmt THEN
2270: PO_LOG.stmt(d_mod,d_position,'l_header_id:',l_header_id);
2271: END IF;
2272:
2273: l_is_complex_work_po

Line 2270: PO_LOG.stmt(d_mod,d_position,'l_header_id:',l_header_id);

2266: ;
2267:
2268: d_position := 20;
2269: IF PO_LOG.d_stmt THEN
2270: PO_LOG.stmt(d_mod,d_position,'l_header_id:',l_header_id);
2271: END IF;
2272:
2273: l_is_complex_work_po
2274: := PO_COMPLEX_WORK_PVT.is_complex_work_po(l_header_id);

Line 2290: IF PO_LOG.d_stmt THEN

2286: AND poll.shipment_type = 'STANDARD'
2287: ;
2288: EXCEPTION
2289: WHEN NO_DATA_FOUND THEN
2290: IF PO_LOG.d_stmt THEN
2291: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
2292: END IF;
2293: l_return_val := 0;
2294: END;

Line 2291: PO_LOG.stmt(d_mod,d_position,'No line locations exist');

2287: ;
2288: EXCEPTION
2289: WHEN NO_DATA_FOUND THEN
2290: IF PO_LOG.d_stmt THEN
2291: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
2292: END IF;
2293: l_return_val := 0;
2294: END;
2295:

Line 2312: IF PO_LOG.d_proc THEN

2308:
2309: END IF;
2310:
2311:
2312: IF PO_LOG.d_proc THEN
2313: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);
2314: END IF;
2315:
2316: RETURN l_return_val;

Line 2313: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);

2309: END IF;
2310:
2311:
2312: IF PO_LOG.d_proc THEN
2313: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);
2314: END IF;
2315:
2316: RETURN l_return_val;
2317:

Line 2320: IF PO_LOG.d_exc THEN

2316: RETURN l_return_val;
2317:
2318: EXCEPTION
2319: WHEN OTHERS THEN
2320: IF PO_LOG.d_exc THEN
2321: PO_LOG.exc(d_mod,d_position,NULL);
2322: END IF;
2323: RAISE;
2324: END getLineLocQuantityForLine;

Line 2321: PO_LOG.exc(d_mod,d_position,NULL);

2317:
2318: EXCEPTION
2319: WHEN OTHERS THEN
2320: IF PO_LOG.d_exc THEN
2321: PO_LOG.exc(d_mod,d_position,NULL);
2322: END IF;
2323: RAISE;
2324: END getLineLocQuantityForLine;
2325:

Line 2354: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getLineLocAmountForLine');

2350: p_line_id IN NUMBER
2351: ) RETURN NUMBER
2352: IS
2353: d_mod CONSTANT VARCHAR2(100) :=
2354: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getLineLocAmountForLine');
2355: d_position NUMBER := 0;
2356: l_return_val NUMBER := 0;
2357: l_header_id PO_HEADERS_ALL.po_header_id%TYPE;
2358: l_is_complex_work_po BOOLEAN := FALSE;

Line 2363: IF PO_LOG.d_proc THEN

2359: l_precision GL_CURRENCIES.precision%TYPE;
2360: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
2361: BEGIN
2362:
2363: IF PO_LOG.d_proc THEN
2364: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);
2365: END IF;
2366:
2367: do_org_currency_setups(

Line 2364: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);

2360: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
2361: BEGIN
2362:
2363: IF PO_LOG.d_proc THEN
2364: PO_LOG.proc_begin(d_mod,'p_line_id',p_line_id);
2365: END IF;
2366:
2367: do_org_currency_setups(
2368: p_doc_level => g_doc_level_LINE

Line 2375: IF PO_LOG.d_stmt THEN

2371: , x_min_acct_unit => l_mau
2372: );
2373:
2374: d_position := 5;
2375: IF PO_LOG.d_stmt THEN
2376: PO_LOG.stmt(d_mod,d_position,'l_precision:',l_precision);
2377: PO_LOG.stmt(d_mod,d_position,'l_mau:',l_mau);
2378: END IF;
2379:

Line 2376: PO_LOG.stmt(d_mod,d_position,'l_precision:',l_precision);

2372: );
2373:
2374: d_position := 5;
2375: IF PO_LOG.d_stmt THEN
2376: PO_LOG.stmt(d_mod,d_position,'l_precision:',l_precision);
2377: PO_LOG.stmt(d_mod,d_position,'l_mau:',l_mau);
2378: END IF;
2379:
2380: d_position := 10;

Line 2377: PO_LOG.stmt(d_mod,d_position,'l_mau:',l_mau);

2373:
2374: d_position := 5;
2375: IF PO_LOG.d_stmt THEN
2376: PO_LOG.stmt(d_mod,d_position,'l_precision:',l_precision);
2377: PO_LOG.stmt(d_mod,d_position,'l_mau:',l_mau);
2378: END IF;
2379:
2380: d_position := 10;
2381:

Line 2399: IF PO_LOG.d_stmt THEN

2395: AND poll.shipment_type = 'STANDARD'
2396: ;
2397: EXCEPTION
2398: WHEN NO_DATA_FOUND THEN
2399: IF PO_LOG.d_stmt THEN
2400: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
2401: END IF;
2402: l_return_val := 0;
2403: END;

Line 2400: PO_LOG.stmt(d_mod,d_position,'No line locations exist');

2396: ;
2397: EXCEPTION
2398: WHEN NO_DATA_FOUND THEN
2399: IF PO_LOG.d_stmt THEN
2400: PO_LOG.stmt(d_mod,d_position,'No line locations exist');
2401: END IF;
2402: l_return_val := 0;
2403: END;
2404:

Line 2407: IF PO_LOG.d_proc THEN

2403: END;
2404:
2405: d_position := 20;
2406:
2407: IF PO_LOG.d_proc THEN
2408: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);
2409: END IF;
2410:
2411: RETURN l_return_val;

Line 2408: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);

2404:
2405: d_position := 20;
2406:
2407: IF PO_LOG.d_proc THEN
2408: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);
2409: END IF;
2410:
2411: RETURN l_return_val;
2412:

Line 2415: IF PO_LOG.d_exc THEN

2411: RETURN l_return_val;
2412:
2413: EXCEPTION
2414: WHEN OTHERS THEN
2415: IF PO_LOG.d_exc THEN
2416: PO_LOG.exc(d_mod,d_position,NULL);
2417: END IF;
2418: RAISE;
2419: END getLineLocAmountForLine;

Line 2416: PO_LOG.exc(d_mod,d_position,NULL);

2412:
2413: EXCEPTION
2414: WHEN OTHERS THEN
2415: IF PO_LOG.d_exc THEN
2416: PO_LOG.exc(d_mod,d_position,NULL);
2417: END IF;
2418: RAISE;
2419: END getLineLocAmountForLine;
2420:

Line 2449: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getDistQuantityForLineLoc');

2445: p_line_loc_id IN NUMBER
2446: ) RETURN NUMBER
2447: IS
2448: d_mod CONSTANT VARCHAR2(100) :=
2449: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getDistQuantityForLineLoc');
2450: d_position NUMBER := 0;
2451: l_return_val NUMBER := 0;
2452: BEGIN
2453:

Line 2454: IF PO_LOG.d_proc THEN

2450: d_position NUMBER := 0;
2451: l_return_val NUMBER := 0;
2452: BEGIN
2453:
2454: IF PO_LOG.d_proc THEN
2455: PO_LOG.proc_begin(d_mod,'p_line_loc_id',p_line_loc_id);
2456: END IF;
2457:
2458: d_position := 10;

Line 2455: PO_LOG.proc_begin(d_mod,'p_line_loc_id',p_line_loc_id);

2451: l_return_val NUMBER := 0;
2452: BEGIN
2453:
2454: IF PO_LOG.d_proc THEN
2455: PO_LOG.proc_begin(d_mod,'p_line_loc_id',p_line_loc_id);
2456: END IF;
2457:
2458: d_position := 10;
2459:

Line 2468: IF PO_LOG.d_stmt THEN

2464: WHERE pod.line_location_id = p_line_loc_id
2465: ;
2466: EXCEPTION
2467: WHEN NO_DATA_FOUND THEN
2468: IF PO_LOG.d_stmt THEN
2469: PO_LOG.stmt(d_mod,d_position,'No distributions exist');
2470: END IF;
2471: l_return_val := 0;
2472: END;

Line 2469: PO_LOG.stmt(d_mod,d_position,'No distributions exist');

2465: ;
2466: EXCEPTION
2467: WHEN NO_DATA_FOUND THEN
2468: IF PO_LOG.d_stmt THEN
2469: PO_LOG.stmt(d_mod,d_position,'No distributions exist');
2470: END IF;
2471: l_return_val := 0;
2472: END;
2473:

Line 2476: IF PO_LOG.d_proc THEN

2472: END;
2473:
2474: d_position := 20;
2475:
2476: IF PO_LOG.d_proc THEN
2477: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);
2478: END IF;
2479:
2480: RETURN l_return_val;

Line 2477: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);

2473:
2474: d_position := 20;
2475:
2476: IF PO_LOG.d_proc THEN
2477: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);
2478: END IF;
2479:
2480: RETURN l_return_val;
2481:

Line 2484: IF PO_LOG.d_exc THEN

2480: RETURN l_return_val;
2481:
2482: EXCEPTION
2483: WHEN OTHERS THEN
2484: IF PO_LOG.d_exc THEN
2485: PO_LOG.exc(d_mod,d_position,NULL);
2486: END IF;
2487: RAISE;
2488: END getDistQuantityForLineLoc;

Line 2485: PO_LOG.exc(d_mod,d_position,NULL);

2481:
2482: EXCEPTION
2483: WHEN OTHERS THEN
2484: IF PO_LOG.d_exc THEN
2485: PO_LOG.exc(d_mod,d_position,NULL);
2486: END IF;
2487: RAISE;
2488: END getDistQuantityForLineLoc;
2489:

Line 2518: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getDistAmountForLineLoc');

2514: p_line_loc_id IN NUMBER
2515: ) RETURN NUMBER
2516: IS
2517: d_mod CONSTANT VARCHAR2(100) :=
2518: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'getDistAmountForLineLoc');
2519: d_position NUMBER := 0;
2520: l_return_val NUMBER := 0;
2521: BEGIN
2522:

Line 2523: IF PO_LOG.d_proc THEN

2519: d_position NUMBER := 0;
2520: l_return_val NUMBER := 0;
2521: BEGIN
2522:
2523: IF PO_LOG.d_proc THEN
2524: PO_LOG.proc_begin(d_mod,'p_line_loc_id',p_line_loc_id);
2525: END IF;
2526:
2527: d_position := 10;

Line 2524: PO_LOG.proc_begin(d_mod,'p_line_loc_id',p_line_loc_id);

2520: l_return_val NUMBER := 0;
2521: BEGIN
2522:
2523: IF PO_LOG.d_proc THEN
2524: PO_LOG.proc_begin(d_mod,'p_line_loc_id',p_line_loc_id);
2525: END IF;
2526:
2527: d_position := 10;
2528:

Line 2537: IF PO_LOG.d_stmt THEN

2533: WHERE pod.line_location_id = p_line_loc_id
2534: ;
2535: EXCEPTION
2536: WHEN NO_DATA_FOUND THEN
2537: IF PO_LOG.d_stmt THEN
2538: PO_LOG.stmt(d_mod,d_position,'No distributions exist');
2539: END IF;
2540: l_return_val := 0;
2541: END;

Line 2538: PO_LOG.stmt(d_mod,d_position,'No distributions exist');

2534: ;
2535: EXCEPTION
2536: WHEN NO_DATA_FOUND THEN
2537: IF PO_LOG.d_stmt THEN
2538: PO_LOG.stmt(d_mod,d_position,'No distributions exist');
2539: END IF;
2540: l_return_val := 0;
2541: END;
2542:

Line 2545: IF PO_LOG.d_proc THEN

2541: END;
2542:
2543: d_position := 20;
2544:
2545: IF PO_LOG.d_proc THEN
2546: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);
2547: END IF;
2548:
2549: RETURN l_return_val;

Line 2546: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);

2542:
2543: d_position := 20;
2544:
2545: IF PO_LOG.d_proc THEN
2546: PO_LOG.proc_end(d_mod, 'l_return_val', l_return_val);
2547: END IF;
2548:
2549: RETURN l_return_val;
2550:

Line 2553: IF PO_LOG.d_exc THEN

2549: RETURN l_return_val;
2550:
2551: EXCEPTION
2552: WHEN OTHERS THEN
2553: IF PO_LOG.d_exc THEN
2554: PO_LOG.exc(d_mod,d_position,NULL);
2555: END IF;
2556: RAISE;
2557: END getDistAmountForLineLoc;

Line 2554: PO_LOG.exc(d_mod,d_position,NULL);

2550:
2551: EXCEPTION
2552: WHEN OTHERS THEN
2553: IF PO_LOG.d_exc THEN
2554: PO_LOG.exc(d_mod,d_position,NULL);
2555: END IF;
2556: RAISE;
2557: END getDistAmountForLineLoc;
2558:

Line 2600: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'do_org_currency_setups');

2596: , x_currency_precision OUT NOCOPY NUMBER
2597: , x_min_acct_unit OUT NOCOPY NUMBER
2598: ) IS
2599: d_mod CONSTANT VARCHAR2(100) :=
2600: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'do_org_currency_setups');
2601: d_position NUMBER := 0;
2602: l_header_id PO_HEADERS_ALL.po_header_id%type;
2603: l_org_id PO_HEADERS_ALL.org_id%type;
2604: l_po_currency PO_HEADERS_ALL.currency_code%type;

Line 2607: IF PO_LOG.d_proc THEN

2603: l_org_id PO_HEADERS_ALL.org_id%type;
2604: l_po_currency PO_HEADERS_ALL.currency_code%type;
2605: BEGIN
2606:
2607: IF PO_LOG.d_proc THEN
2608: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);
2609: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);
2610: END IF;
2611:

Line 2608: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);

2604: l_po_currency PO_HEADERS_ALL.currency_code%type;
2605: BEGIN
2606:
2607: IF PO_LOG.d_proc THEN
2608: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);
2609: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);
2610: END IF;
2611:
2612: d_position := 10;

Line 2609: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);

2605: BEGIN
2606:
2607: IF PO_LOG.d_proc THEN
2608: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);
2609: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);
2610: END IF;
2611:
2612: d_position := 10;
2613:

Line 2646: IF PO_LOG.d_stmt THEN

2642:
2643: END IF;
2644:
2645: d_position := 60;
2646: IF PO_LOG.d_stmt THEN
2647: PO_LOG.stmt(d_mod,d_position,'l_header_id:',l_header_id);
2648: END IF;
2649:
2650: SELECT poh.currency_code, poh.org_id

Line 2647: PO_LOG.stmt(d_mod,d_position,'l_header_id:',l_header_id);

2643: END IF;
2644:
2645: d_position := 60;
2646: IF PO_LOG.d_stmt THEN
2647: PO_LOG.stmt(d_mod,d_position,'l_header_id:',l_header_id);
2648: END IF;
2649:
2650: SELECT poh.currency_code, poh.org_id
2651: INTO l_po_currency, l_org_id

Line 2657: IF PO_LOG.d_stmt THEN

2653: WHERE poh.po_header_id = l_header_id
2654: ;
2655:
2656: d_position := 70;
2657: IF PO_LOG.d_stmt THEN
2658: PO_LOG.stmt(d_mod,d_position,'l_po_currency:',l_po_currency);
2659: PO_LOG.stmt(d_mod,d_position,'l_org_id:',l_org_id);
2660: END IF;
2661:

Line 2658: PO_LOG.stmt(d_mod,d_position,'l_po_currency:',l_po_currency);

2654: ;
2655:
2656: d_position := 70;
2657: IF PO_LOG.d_stmt THEN
2658: PO_LOG.stmt(d_mod,d_position,'l_po_currency:',l_po_currency);
2659: PO_LOG.stmt(d_mod,d_position,'l_org_id:',l_org_id);
2660: END IF;
2661:
2662: d_position := 80;

Line 2659: PO_LOG.stmt(d_mod,d_position,'l_org_id:',l_org_id);

2655:
2656: d_position := 70;
2657: IF PO_LOG.d_stmt THEN
2658: PO_LOG.stmt(d_mod,d_position,'l_po_currency:',l_po_currency);
2659: PO_LOG.stmt(d_mod,d_position,'l_org_id:',l_org_id);
2660: END IF;
2661:
2662: d_position := 80;
2663: PO_MOAC_UTILS_PVT.set_org_context(l_org_id);

Line 2674: IF PO_LOG.d_proc THEN

2670: );
2671:
2672: d_position := 100;
2673:
2674: IF PO_LOG.d_proc THEN
2675: PO_LOG.proc_end(d_mod,'x_currency_precision:',x_currency_precision);
2676: PO_LOG.proc_end(d_mod,'x_min_acct_unit:', x_min_acct_unit);
2677: END IF;
2678:

Line 2675: PO_LOG.proc_end(d_mod,'x_currency_precision:',x_currency_precision);

2671:
2672: d_position := 100;
2673:
2674: IF PO_LOG.d_proc THEN
2675: PO_LOG.proc_end(d_mod,'x_currency_precision:',x_currency_precision);
2676: PO_LOG.proc_end(d_mod,'x_min_acct_unit:', x_min_acct_unit);
2677: END IF;
2678:
2679: EXCEPTION

Line 2676: PO_LOG.proc_end(d_mod,'x_min_acct_unit:', x_min_acct_unit);

2672: d_position := 100;
2673:
2674: IF PO_LOG.d_proc THEN
2675: PO_LOG.proc_end(d_mod,'x_currency_precision:',x_currency_precision);
2676: PO_LOG.proc_end(d_mod,'x_min_acct_unit:', x_min_acct_unit);
2677: END IF;
2678:
2679: EXCEPTION
2680: WHEN OTHERS THEN

Line 2681: IF PO_LOG.d_exc THEN

2677: END IF;
2678:
2679: EXCEPTION
2680: WHEN OTHERS THEN
2681: IF PO_LOG.d_exc THEN
2682: PO_LOG.exc(d_mod,d_position,NULL);
2683: END IF;
2684: RAISE;
2685: END do_org_currency_setups;

Line 2682: PO_LOG.exc(d_mod,d_position,NULL);

2678:
2679: EXCEPTION
2680: WHEN OTHERS THEN
2681: IF PO_LOG.d_exc THEN
2682: PO_LOG.exc(d_mod,d_position,NULL);
2683: END IF;
2684: RAISE;
2685: END do_org_currency_setups;
2686:

Line 2803: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_order_totals');

2799: x_retainage_released_amount OUT NOCOPY NUMBER
2800: )
2801: IS
2802: d_mod CONSTANT VARCHAR2(100) :=
2803: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_order_totals');
2804: d_position NUMBER := 0;
2805:
2806: BEGIN
2807:

Line 2808: IF PO_LOG.d_proc THEN

2804: d_position NUMBER := 0;
2805:
2806: BEGIN
2807:
2808: IF PO_LOG.d_proc THEN
2809: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2810: PO_LOG.proc_begin(d_mod,'p_doc_subtype',p_doc_subtype);
2811: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);
2812: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);

Line 2809: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);

2805:
2806: BEGIN
2807:
2808: IF PO_LOG.d_proc THEN
2809: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2810: PO_LOG.proc_begin(d_mod,'p_doc_subtype',p_doc_subtype);
2811: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);
2812: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);
2813: END IF;

Line 2810: PO_LOG.proc_begin(d_mod,'p_doc_subtype',p_doc_subtype);

2806: BEGIN
2807:
2808: IF PO_LOG.d_proc THEN
2809: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2810: PO_LOG.proc_begin(d_mod,'p_doc_subtype',p_doc_subtype);
2811: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);
2812: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);
2813: END IF;
2814:

Line 2811: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);

2807:
2808: IF PO_LOG.d_proc THEN
2809: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2810: PO_LOG.proc_begin(d_mod,'p_doc_subtype',p_doc_subtype);
2811: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);
2812: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);
2813: END IF;
2814:
2815: -- Logic: call the PVT signature get_totals

Line 2812: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);

2808: IF PO_LOG.d_proc THEN
2809: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2810: PO_LOG.proc_begin(d_mod,'p_doc_subtype',p_doc_subtype);
2811: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);
2812: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);
2813: END IF;
2814:
2815: -- Logic: call the PVT signature get_totals
2816:

Line 2846: IF PO_LOG.d_proc THEN

2842: );
2843:
2844: d_position := 20;
2845:
2846: IF PO_LOG.d_proc THEN
2847: PO_LOG.proc_end(d_mod,'x_quantity_total',x_quantity_total);
2848: PO_LOG.proc_end(d_mod,'x_amount_total', x_amount_total);
2849: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);
2850: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);

Line 2847: PO_LOG.proc_end(d_mod,'x_quantity_total',x_quantity_total);

2843:
2844: d_position := 20;
2845:
2846: IF PO_LOG.d_proc THEN
2847: PO_LOG.proc_end(d_mod,'x_quantity_total',x_quantity_total);
2848: PO_LOG.proc_end(d_mod,'x_amount_total', x_amount_total);
2849: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);
2850: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);
2851: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);

Line 2848: PO_LOG.proc_end(d_mod,'x_amount_total', x_amount_total);

2844: d_position := 20;
2845:
2846: IF PO_LOG.d_proc THEN
2847: PO_LOG.proc_end(d_mod,'x_quantity_total',x_quantity_total);
2848: PO_LOG.proc_end(d_mod,'x_amount_total', x_amount_total);
2849: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);
2850: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);
2851: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);
2852: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);

Line 2849: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);

2845:
2846: IF PO_LOG.d_proc THEN
2847: PO_LOG.proc_end(d_mod,'x_quantity_total',x_quantity_total);
2848: PO_LOG.proc_end(d_mod,'x_amount_total', x_amount_total);
2849: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);
2850: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);
2851: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);
2852: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);
2853: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);

Line 2850: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);

2846: IF PO_LOG.d_proc THEN
2847: PO_LOG.proc_end(d_mod,'x_quantity_total',x_quantity_total);
2848: PO_LOG.proc_end(d_mod,'x_amount_total', x_amount_total);
2849: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);
2850: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);
2851: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);
2852: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);
2853: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);
2854: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);

Line 2851: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);

2847: PO_LOG.proc_end(d_mod,'x_quantity_total',x_quantity_total);
2848: PO_LOG.proc_end(d_mod,'x_amount_total', x_amount_total);
2849: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);
2850: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);
2851: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);
2852: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);
2853: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);
2854: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);
2855: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);

Line 2852: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);

2848: PO_LOG.proc_end(d_mod,'x_amount_total', x_amount_total);
2849: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);
2850: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);
2851: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);
2852: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);
2853: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);
2854: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);
2855: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);
2856: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);

Line 2853: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);

2849: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);
2850: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);
2851: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);
2852: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);
2853: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);
2854: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);
2855: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);
2856: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);
2857: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);

Line 2854: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);

2850: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);
2851: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);
2852: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);
2853: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);
2854: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);
2855: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);
2856: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);
2857: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);
2858: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);

Line 2855: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);

2851: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);
2852: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);
2853: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);
2854: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);
2855: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);
2856: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);
2857: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);
2858: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);
2859: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);

Line 2856: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);

2852: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);
2853: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);
2854: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);
2855: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);
2856: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);
2857: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);
2858: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);
2859: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);
2860: PO_LOG.proc_end(d_mod,'x_amount_recouped', x_amount_recouped);

Line 2857: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);

2853: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);
2854: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);
2855: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);
2856: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);
2857: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);
2858: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);
2859: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);
2860: PO_LOG.proc_end(d_mod,'x_amount_recouped', x_amount_recouped);
2861: PO_LOG.proc_end(d_mod,'x_retainage_withheld_amount', x_retainage_withheld_amount);

Line 2858: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);

2854: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);
2855: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);
2856: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);
2857: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);
2858: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);
2859: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);
2860: PO_LOG.proc_end(d_mod,'x_amount_recouped', x_amount_recouped);
2861: PO_LOG.proc_end(d_mod,'x_retainage_withheld_amount', x_retainage_withheld_amount);
2862: PO_LOG.proc_end(d_mod,'x_retainage_released_amount', x_retainage_released_amount);

Line 2859: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);

2855: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);
2856: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);
2857: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);
2858: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);
2859: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);
2860: PO_LOG.proc_end(d_mod,'x_amount_recouped', x_amount_recouped);
2861: PO_LOG.proc_end(d_mod,'x_retainage_withheld_amount', x_retainage_withheld_amount);
2862: PO_LOG.proc_end(d_mod,'x_retainage_released_amount', x_retainage_released_amount);
2863: END IF;

Line 2860: PO_LOG.proc_end(d_mod,'x_amount_recouped', x_amount_recouped);

2856: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);
2857: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);
2858: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);
2859: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);
2860: PO_LOG.proc_end(d_mod,'x_amount_recouped', x_amount_recouped);
2861: PO_LOG.proc_end(d_mod,'x_retainage_withheld_amount', x_retainage_withheld_amount);
2862: PO_LOG.proc_end(d_mod,'x_retainage_released_amount', x_retainage_released_amount);
2863: END IF;
2864:

Line 2861: PO_LOG.proc_end(d_mod,'x_retainage_withheld_amount', x_retainage_withheld_amount);

2857: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);
2858: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);
2859: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);
2860: PO_LOG.proc_end(d_mod,'x_amount_recouped', x_amount_recouped);
2861: PO_LOG.proc_end(d_mod,'x_retainage_withheld_amount', x_retainage_withheld_amount);
2862: PO_LOG.proc_end(d_mod,'x_retainage_released_amount', x_retainage_released_amount);
2863: END IF;
2864:
2865: EXCEPTION

Line 2862: PO_LOG.proc_end(d_mod,'x_retainage_released_amount', x_retainage_released_amount);

2858: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);
2859: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);
2860: PO_LOG.proc_end(d_mod,'x_amount_recouped', x_amount_recouped);
2861: PO_LOG.proc_end(d_mod,'x_retainage_withheld_amount', x_retainage_withheld_amount);
2862: PO_LOG.proc_end(d_mod,'x_retainage_released_amount', x_retainage_released_amount);
2863: END IF;
2864:
2865: EXCEPTION
2866: WHEN OTHERS THEN

Line 2867: IF PO_LOG.d_exc THEN

2863: END IF;
2864:
2865: EXCEPTION
2866: WHEN OTHERS THEN
2867: IF PO_LOG.d_exc THEN
2868: PO_LOG.exc(d_mod,d_position,NULL);
2869: END IF;
2870: RAISE;
2871:

Line 2868: PO_LOG.exc(d_mod,d_position,NULL);

2864:
2865: EXCEPTION
2866: WHEN OTHERS THEN
2867: IF PO_LOG.d_exc THEN
2868: PO_LOG.exc(d_mod,d_position,NULL);
2869: END IF;
2870: RAISE;
2871:
2872: END get_order_totals;

Line 2979: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_order_totals_from_archive');

2975: x_retainage_released_amount OUT NOCOPY NUMBER
2976: )
2977: IS
2978: d_mod CONSTANT VARCHAR2(100) :=
2979: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_order_totals_from_archive');
2980: d_position NUMBER := 0;
2981:
2982: l_doc_currency_code GL_CURRENCIES.currency_code%TYPE;
2983: BEGIN

Line 2985: IF PO_LOG.d_proc THEN

2981:
2982: l_doc_currency_code GL_CURRENCIES.currency_code%TYPE;
2983: BEGIN
2984:
2985: IF PO_LOG.d_proc THEN
2986: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2987: PO_LOG.proc_begin(d_mod,'p_doc_subtype',p_doc_subtype);
2988: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);
2989: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);

Line 2986: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);

2982: l_doc_currency_code GL_CURRENCIES.currency_code%TYPE;
2983: BEGIN
2984:
2985: IF PO_LOG.d_proc THEN
2986: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2987: PO_LOG.proc_begin(d_mod,'p_doc_subtype',p_doc_subtype);
2988: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);
2989: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);
2990: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);

Line 2987: PO_LOG.proc_begin(d_mod,'p_doc_subtype',p_doc_subtype);

2983: BEGIN
2984:
2985: IF PO_LOG.d_proc THEN
2986: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2987: PO_LOG.proc_begin(d_mod,'p_doc_subtype',p_doc_subtype);
2988: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);
2989: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);
2990: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
2991: END IF;

Line 2988: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);

2984:
2985: IF PO_LOG.d_proc THEN
2986: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2987: PO_LOG.proc_begin(d_mod,'p_doc_subtype',p_doc_subtype);
2988: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);
2989: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);
2990: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
2991: END IF;
2992:

Line 2989: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);

2985: IF PO_LOG.d_proc THEN
2986: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2987: PO_LOG.proc_begin(d_mod,'p_doc_subtype',p_doc_subtype);
2988: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);
2989: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);
2990: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
2991: END IF;
2992:
2993: -- Logic: call the PVT signature get_totals

Line 2990: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);

2986: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
2987: PO_LOG.proc_begin(d_mod,'p_doc_subtype',p_doc_subtype);
2988: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);
2989: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);
2990: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
2991: END IF;
2992:
2993: -- Logic: call the PVT signature get_totals
2994:

Line 3024: IF PO_LOG.d_proc THEN

3020: );
3021:
3022: d_position := 20;
3023:
3024: IF PO_LOG.d_proc THEN
3025: PO_LOG.proc_end(d_mod,'x_quantity_total',x_quantity_total);
3026: PO_LOG.proc_end(d_mod,'x_amount_total', x_amount_total);
3027: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);
3028: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);

Line 3025: PO_LOG.proc_end(d_mod,'x_quantity_total',x_quantity_total);

3021:
3022: d_position := 20;
3023:
3024: IF PO_LOG.d_proc THEN
3025: PO_LOG.proc_end(d_mod,'x_quantity_total',x_quantity_total);
3026: PO_LOG.proc_end(d_mod,'x_amount_total', x_amount_total);
3027: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);
3028: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);
3029: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);

Line 3026: PO_LOG.proc_end(d_mod,'x_amount_total', x_amount_total);

3022: d_position := 20;
3023:
3024: IF PO_LOG.d_proc THEN
3025: PO_LOG.proc_end(d_mod,'x_quantity_total',x_quantity_total);
3026: PO_LOG.proc_end(d_mod,'x_amount_total', x_amount_total);
3027: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);
3028: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);
3029: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);
3030: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);

Line 3027: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);

3023:
3024: IF PO_LOG.d_proc THEN
3025: PO_LOG.proc_end(d_mod,'x_quantity_total',x_quantity_total);
3026: PO_LOG.proc_end(d_mod,'x_amount_total', x_amount_total);
3027: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);
3028: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);
3029: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);
3030: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);
3031: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);

Line 3028: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);

3024: IF PO_LOG.d_proc THEN
3025: PO_LOG.proc_end(d_mod,'x_quantity_total',x_quantity_total);
3026: PO_LOG.proc_end(d_mod,'x_amount_total', x_amount_total);
3027: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);
3028: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);
3029: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);
3030: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);
3031: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);
3032: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);

Line 3029: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);

3025: PO_LOG.proc_end(d_mod,'x_quantity_total',x_quantity_total);
3026: PO_LOG.proc_end(d_mod,'x_amount_total', x_amount_total);
3027: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);
3028: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);
3029: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);
3030: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);
3031: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);
3032: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);
3033: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);

Line 3030: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);

3026: PO_LOG.proc_end(d_mod,'x_amount_total', x_amount_total);
3027: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);
3028: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);
3029: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);
3030: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);
3031: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);
3032: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);
3033: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);
3034: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);

Line 3031: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);

3027: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);
3028: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);
3029: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);
3030: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);
3031: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);
3032: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);
3033: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);
3034: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);
3035: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);

Line 3032: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);

3028: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);
3029: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);
3030: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);
3031: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);
3032: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);
3033: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);
3034: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);
3035: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);
3036: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);

Line 3033: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);

3029: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);
3030: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);
3031: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);
3032: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);
3033: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);
3034: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);
3035: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);
3036: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);
3037: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);

Line 3034: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);

3030: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);
3031: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);
3032: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);
3033: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);
3034: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);
3035: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);
3036: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);
3037: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);
3038: PO_LOG.proc_end(d_mod,'x_amount_recouped', x_amount_recouped);

Line 3035: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);

3031: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);
3032: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);
3033: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);
3034: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);
3035: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);
3036: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);
3037: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);
3038: PO_LOG.proc_end(d_mod,'x_amount_recouped', x_amount_recouped);
3039: PO_LOG.proc_end(d_mod,'x_retainage_withheld_amount', x_retainage_withheld_amount);

Line 3036: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);

3032: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);
3033: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);
3034: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);
3035: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);
3036: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);
3037: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);
3038: PO_LOG.proc_end(d_mod,'x_amount_recouped', x_amount_recouped);
3039: PO_LOG.proc_end(d_mod,'x_retainage_withheld_amount', x_retainage_withheld_amount);
3040: PO_LOG.proc_end(d_mod,'x_retainage_released_amount', x_retainage_released_amount);

Line 3037: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);

3033: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);
3034: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);
3035: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);
3036: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);
3037: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);
3038: PO_LOG.proc_end(d_mod,'x_amount_recouped', x_amount_recouped);
3039: PO_LOG.proc_end(d_mod,'x_retainage_withheld_amount', x_retainage_withheld_amount);
3040: PO_LOG.proc_end(d_mod,'x_retainage_released_amount', x_retainage_released_amount);
3041: END IF;

Line 3038: PO_LOG.proc_end(d_mod,'x_amount_recouped', x_amount_recouped);

3034: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);
3035: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);
3036: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);
3037: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);
3038: PO_LOG.proc_end(d_mod,'x_amount_recouped', x_amount_recouped);
3039: PO_LOG.proc_end(d_mod,'x_retainage_withheld_amount', x_retainage_withheld_amount);
3040: PO_LOG.proc_end(d_mod,'x_retainage_released_amount', x_retainage_released_amount);
3041: END IF;
3042:

Line 3039: PO_LOG.proc_end(d_mod,'x_retainage_withheld_amount', x_retainage_withheld_amount);

3035: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);
3036: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);
3037: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);
3038: PO_LOG.proc_end(d_mod,'x_amount_recouped', x_amount_recouped);
3039: PO_LOG.proc_end(d_mod,'x_retainage_withheld_amount', x_retainage_withheld_amount);
3040: PO_LOG.proc_end(d_mod,'x_retainage_released_amount', x_retainage_released_amount);
3041: END IF;
3042:
3043: EXCEPTION

Line 3040: PO_LOG.proc_end(d_mod,'x_retainage_released_amount', x_retainage_released_amount);

3036: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);
3037: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);
3038: PO_LOG.proc_end(d_mod,'x_amount_recouped', x_amount_recouped);
3039: PO_LOG.proc_end(d_mod,'x_retainage_withheld_amount', x_retainage_withheld_amount);
3040: PO_LOG.proc_end(d_mod,'x_retainage_released_amount', x_retainage_released_amount);
3041: END IF;
3042:
3043: EXCEPTION
3044: WHEN OTHERS THEN

Line 3045: IF PO_LOG.d_exc THEN

3041: END IF;
3042:
3043: EXCEPTION
3044: WHEN OTHERS THEN
3045: IF PO_LOG.d_exc THEN
3046: PO_LOG.exc(d_mod,d_position,NULL);
3047: END IF;
3048: RAISE;
3049:

Line 3046: PO_LOG.exc(d_mod,d_position,NULL);

3042:
3043: EXCEPTION
3044: WHEN OTHERS THEN
3045: IF PO_LOG.d_exc THEN
3046: PO_LOG.exc(d_mod,d_position,NULL);
3047: END IF;
3048: RAISE;
3049:
3050: END get_order_totals_from_archive;

Line 3163: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_order_totals');

3159: x_retainage_released_amount OUT NOCOPY NUMBER
3160: )
3161: IS
3162: d_mod CONSTANT VARCHAR2(100) :=
3163: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'get_order_totals');
3164: d_position NUMBER := 0;
3165:
3166: l_org_id HR_ALL_ORGANIZATION_UNITS.organization_id%type;
3167: l_distribution_id_tbl po_tbl_number;

Line 3177: IF PO_LOG.d_proc THEN

3173: l_temp_table_row_count NUMBER;
3174:
3175: BEGIN
3176:
3177: IF PO_LOG.d_proc THEN
3178: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3179: PO_LOG.proc_begin(d_mod,'p_doc_subtype',p_doc_subtype);
3180: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);
3181: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);

Line 3178: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);

3174:
3175: BEGIN
3176:
3177: IF PO_LOG.d_proc THEN
3178: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3179: PO_LOG.proc_begin(d_mod,'p_doc_subtype',p_doc_subtype);
3180: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);
3181: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);
3182: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);

Line 3179: PO_LOG.proc_begin(d_mod,'p_doc_subtype',p_doc_subtype);

3175: BEGIN
3176:
3177: IF PO_LOG.d_proc THEN
3178: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3179: PO_LOG.proc_begin(d_mod,'p_doc_subtype',p_doc_subtype);
3180: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);
3181: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);
3182: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
3183: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);

Line 3180: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);

3176:
3177: IF PO_LOG.d_proc THEN
3178: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3179: PO_LOG.proc_begin(d_mod,'p_doc_subtype',p_doc_subtype);
3180: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);
3181: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);
3182: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
3183: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
3184: END IF;

Line 3181: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);

3177: IF PO_LOG.d_proc THEN
3178: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3179: PO_LOG.proc_begin(d_mod,'p_doc_subtype',p_doc_subtype);
3180: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);
3181: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);
3182: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
3183: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
3184: END IF;
3185:

Line 3182: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);

3178: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3179: PO_LOG.proc_begin(d_mod,'p_doc_subtype',p_doc_subtype);
3180: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);
3181: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);
3182: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
3183: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
3184: END IF;
3185:
3186: -- Logic:

Line 3183: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);

3179: PO_LOG.proc_begin(d_mod,'p_doc_subtype',p_doc_subtype);
3180: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);
3181: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);
3182: PO_LOG.proc_begin(d_mod,'p_data_source',p_data_source);
3183: PO_LOG.proc_begin(d_mod,'p_doc_revision_num',p_doc_revision_num);
3184: END IF;
3185:
3186: -- Logic:
3187: -- Based on doc type and doc level, get the list of distribution ids

Line 3286: IF PO_LOG.d_proc THEN

3282: );
3283:
3284: d_position := 60;
3285:
3286: IF PO_LOG.d_proc THEN
3287: PO_LOG.proc_end(d_mod,'x_quantity_total',x_quantity_total);
3288: PO_LOG.proc_end(d_mod,'x_amount_total', x_amount_total);
3289: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);
3290: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);

Line 3287: PO_LOG.proc_end(d_mod,'x_quantity_total',x_quantity_total);

3283:
3284: d_position := 60;
3285:
3286: IF PO_LOG.d_proc THEN
3287: PO_LOG.proc_end(d_mod,'x_quantity_total',x_quantity_total);
3288: PO_LOG.proc_end(d_mod,'x_amount_total', x_amount_total);
3289: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);
3290: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);
3291: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);

Line 3288: PO_LOG.proc_end(d_mod,'x_amount_total', x_amount_total);

3284: d_position := 60;
3285:
3286: IF PO_LOG.d_proc THEN
3287: PO_LOG.proc_end(d_mod,'x_quantity_total',x_quantity_total);
3288: PO_LOG.proc_end(d_mod,'x_amount_total', x_amount_total);
3289: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);
3290: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);
3291: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);
3292: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);

Line 3289: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);

3285:
3286: IF PO_LOG.d_proc THEN
3287: PO_LOG.proc_end(d_mod,'x_quantity_total',x_quantity_total);
3288: PO_LOG.proc_end(d_mod,'x_amount_total', x_amount_total);
3289: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);
3290: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);
3291: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);
3292: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);
3293: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);

Line 3290: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);

3286: IF PO_LOG.d_proc THEN
3287: PO_LOG.proc_end(d_mod,'x_quantity_total',x_quantity_total);
3288: PO_LOG.proc_end(d_mod,'x_amount_total', x_amount_total);
3289: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);
3290: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);
3291: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);
3292: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);
3293: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);
3294: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);

Line 3291: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);

3287: PO_LOG.proc_end(d_mod,'x_quantity_total',x_quantity_total);
3288: PO_LOG.proc_end(d_mod,'x_amount_total', x_amount_total);
3289: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);
3290: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);
3291: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);
3292: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);
3293: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);
3294: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);
3295: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);

Line 3292: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);

3288: PO_LOG.proc_end(d_mod,'x_amount_total', x_amount_total);
3289: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);
3290: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);
3291: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);
3292: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);
3293: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);
3294: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);
3295: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);
3296: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);

Line 3293: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);

3289: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);
3290: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);
3291: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);
3292: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);
3293: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);
3294: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);
3295: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);
3296: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);
3297: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);

Line 3294: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);

3290: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);
3291: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);
3292: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);
3293: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);
3294: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);
3295: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);
3296: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);
3297: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);
3298: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);

Line 3295: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);

3291: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);
3292: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);
3293: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);
3294: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);
3295: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);
3296: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);
3297: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);
3298: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);
3299: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);

Line 3296: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);

3292: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);
3293: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);
3294: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);
3295: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);
3296: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);
3297: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);
3298: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);
3299: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);
3300: PO_LOG.proc_end(d_mod,'x_amount_recouped', x_amount_recouped);

Line 3297: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);

3293: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);
3294: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);
3295: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);
3296: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);
3297: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);
3298: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);
3299: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);
3300: PO_LOG.proc_end(d_mod,'x_amount_recouped', x_amount_recouped);
3301: PO_LOG.proc_end(d_mod,'x_retainage_withheld_amount', x_retainage_withheld_amount);

Line 3298: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);

3294: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);
3295: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);
3296: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);
3297: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);
3298: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);
3299: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);
3300: PO_LOG.proc_end(d_mod,'x_amount_recouped', x_amount_recouped);
3301: PO_LOG.proc_end(d_mod,'x_retainage_withheld_amount', x_retainage_withheld_amount);
3302: PO_LOG.proc_end(d_mod,'x_retainage_released_amount', x_retainage_released_amount);

Line 3299: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);

3295: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);
3296: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);
3297: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);
3298: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);
3299: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);
3300: PO_LOG.proc_end(d_mod,'x_amount_recouped', x_amount_recouped);
3301: PO_LOG.proc_end(d_mod,'x_retainage_withheld_amount', x_retainage_withheld_amount);
3302: PO_LOG.proc_end(d_mod,'x_retainage_released_amount', x_retainage_released_amount);
3303: END IF;

Line 3300: PO_LOG.proc_end(d_mod,'x_amount_recouped', x_amount_recouped);

3296: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);
3297: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);
3298: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);
3299: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);
3300: PO_LOG.proc_end(d_mod,'x_amount_recouped', x_amount_recouped);
3301: PO_LOG.proc_end(d_mod,'x_retainage_withheld_amount', x_retainage_withheld_amount);
3302: PO_LOG.proc_end(d_mod,'x_retainage_released_amount', x_retainage_released_amount);
3303: END IF;
3304:

Line 3301: PO_LOG.proc_end(d_mod,'x_retainage_withheld_amount', x_retainage_withheld_amount);

3297: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);
3298: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);
3299: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);
3300: PO_LOG.proc_end(d_mod,'x_amount_recouped', x_amount_recouped);
3301: PO_LOG.proc_end(d_mod,'x_retainage_withheld_amount', x_retainage_withheld_amount);
3302: PO_LOG.proc_end(d_mod,'x_retainage_released_amount', x_retainage_released_amount);
3303: END IF;
3304:
3305: EXCEPTION

Line 3302: PO_LOG.proc_end(d_mod,'x_retainage_released_amount', x_retainage_released_amount);

3298: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);
3299: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);
3300: PO_LOG.proc_end(d_mod,'x_amount_recouped', x_amount_recouped);
3301: PO_LOG.proc_end(d_mod,'x_retainage_withheld_amount', x_retainage_withheld_amount);
3302: PO_LOG.proc_end(d_mod,'x_retainage_released_amount', x_retainage_released_amount);
3303: END IF;
3304:
3305: EXCEPTION
3306: WHEN OTHERS THEN

Line 3307: IF PO_LOG.d_exc THEN

3303: END IF;
3304:
3305: EXCEPTION
3306: WHEN OTHERS THEN
3307: IF PO_LOG.d_exc THEN
3308: PO_LOG.exc(d_mod,d_position,NULL);
3309: END IF;
3310: RAISE;
3311:

Line 3308: PO_LOG.exc(d_mod,d_position,NULL);

3304:
3305: EXCEPTION
3306: WHEN OTHERS THEN
3307: IF PO_LOG.d_exc THEN
3308: PO_LOG.exc(d_mod,d_position,NULL);
3309: END IF;
3310: RAISE;
3311:
3312: END get_totals;

Line 3374: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'populate_temp_table');

3370: x_count OUT NOCOPY NUMBER
3371: )
3372: IS
3373: d_mod CONSTANT VARCHAR2(100) :=
3374: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'populate_temp_table');
3375: d_position NUMBER := 0;
3376:
3377: l_distribution_id_tbl PO_TBL_NUMBER;
3378: l_distribution_rev_num_tbl po_tbl_number;

Line 3383: IF PO_LOG.d_proc THEN

3379: l_temp_table_key PO_DOCUMENT_TOTALS_GT.key%TYPE;
3380: l_distribution_type_filter PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
3381: BEGIN
3382:
3383: IF PO_LOG.d_proc THEN
3384: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3385: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);
3386: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);
3387: END IF;

Line 3384: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);

3380: l_distribution_type_filter PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
3381: BEGIN
3382:
3383: IF PO_LOG.d_proc THEN
3384: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3385: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);
3386: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);
3387: END IF;
3388:

Line 3385: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);

3381: BEGIN
3382:
3383: IF PO_LOG.d_proc THEN
3384: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3385: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);
3386: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);
3387: END IF;
3388:
3389: d_position := 5;

Line 3386: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);

3382:
3383: IF PO_LOG.d_proc THEN
3384: PO_LOG.proc_begin(d_mod,'p_doc_type',p_doc_type);
3385: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);
3386: PO_LOG.proc_begin(d_mod,'p_doc_level_id',p_doc_level_id);
3387: END IF;
3388:
3389: d_position := 5;
3390:

Line 3481: IF PO_LOG.d_stmt THEN

3477:
3478: x_count := nvl(SQL%ROWCOUNT, 0);
3479:
3480: d_position := 30;
3481: IF PO_LOG.d_stmt THEN
3482: PO_LOG.stmt(d_mod,d_position,'Inserted data - rowcount:',x_count);
3483: END IF;
3484:
3485: ELSIF p_data_source = g_data_source_ARCHIVE THEN

Line 3482: PO_LOG.stmt(d_mod,d_position,'Inserted data - rowcount:',x_count);

3478: x_count := nvl(SQL%ROWCOUNT, 0);
3479:
3480: d_position := 30;
3481: IF PO_LOG.d_stmt THEN
3482: PO_LOG.stmt(d_mod,d_position,'Inserted data - rowcount:',x_count);
3483: END IF;
3484:
3485: ELSIF p_data_source = g_data_source_ARCHIVE THEN
3486:

Line 3584: IF PO_LOG.d_stmt THEN

3580:
3581: x_count := nvl(SQL%ROWCOUNT, 0);
3582:
3583: d_position := 60;
3584: IF PO_LOG.d_stmt THEN
3585: PO_LOG.stmt(d_mod,d_position,'Inserted data - rowcount:',x_count);
3586: END IF;
3587:
3588: ELSE

Line 3585: PO_LOG.stmt(d_mod,d_position,'Inserted data - rowcount:',x_count);

3581: x_count := nvl(SQL%ROWCOUNT, 0);
3582:
3583: d_position := 60;
3584: IF PO_LOG.d_stmt THEN
3585: PO_LOG.stmt(d_mod,d_position,'Inserted data - rowcount:',x_count);
3586: END IF;
3587:
3588: ELSE
3589:

Line 3591: IF PO_LOG.d_stmt THEN

3587:
3588: ELSE
3589:
3590: d_position := 70;
3591: IF PO_LOG.d_stmt THEN
3592: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);
3593: END IF;
3594:
3595: END IF;

Line 3592: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);

3588: ELSE
3589:
3590: d_position := 70;
3591: IF PO_LOG.d_stmt THEN
3592: PO_LOG.stmt(d_mod,d_position,'Invalid data source: ', p_data_source);
3593: END IF;
3594:
3595: END IF;
3596:

Line 3599: IF PO_LOG.d_proc THEN

3595: END IF;
3596:
3597: x_temp_table_key := l_temp_table_key;
3598:
3599: IF PO_LOG.d_proc THEN
3600: PO_LOG.proc_end(d_mod,'x_temp_table_key',x_count);
3601: PO_LOG.proc_end(d_mod,'x_temp_table_key',x_temp_table_key);
3602: END IF;
3603:

Line 3600: PO_LOG.proc_end(d_mod,'x_temp_table_key',x_count);

3596:
3597: x_temp_table_key := l_temp_table_key;
3598:
3599: IF PO_LOG.d_proc THEN
3600: PO_LOG.proc_end(d_mod,'x_temp_table_key',x_count);
3601: PO_LOG.proc_end(d_mod,'x_temp_table_key',x_temp_table_key);
3602: END IF;
3603:
3604: EXCEPTION

Line 3601: PO_LOG.proc_end(d_mod,'x_temp_table_key',x_temp_table_key);

3597: x_temp_table_key := l_temp_table_key;
3598:
3599: IF PO_LOG.d_proc THEN
3600: PO_LOG.proc_end(d_mod,'x_temp_table_key',x_count);
3601: PO_LOG.proc_end(d_mod,'x_temp_table_key',x_temp_table_key);
3602: END IF;
3603:
3604: EXCEPTION
3605: WHEN OTHERS THEN

Line 3606: IF PO_LOG.d_exc THEN

3602: END IF;
3603:
3604: EXCEPTION
3605: WHEN OTHERS THEN
3606: IF PO_LOG.d_exc THEN
3607: PO_LOG.exc(d_mod,d_position,NULL);
3608: END IF;
3609: RAISE;
3610: END populate_temp_table;

Line 3607: PO_LOG.exc(d_mod,d_position,NULL);

3603:
3604: EXCEPTION
3605: WHEN OTHERS THEN
3606: IF PO_LOG.d_exc THEN
3607: PO_LOG.exc(d_mod,d_position,NULL);
3608: END IF;
3609: RAISE;
3610: END populate_temp_table;
3611:

Line 3643: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'prepare_temp_table_data');

3639: p_document_id IN NUMBER
3640: )
3641: IS
3642: d_mod CONSTANT VARCHAR2(100) :=
3643: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'prepare_temp_table_data');
3644: d_position NUMBER := 0;
3645:
3646: l_base_currency_code GL_CURRENCIES.currency_code%TYPE;
3647: l_doc_currency_code GL_CURRENCIES.currency_code%TYPE;

Line 3652: IF PO_LOG.d_proc THEN

3648: l_precision GL_CURRENCIES.precision%TYPE;
3649: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
3650: BEGIN
3651:
3652: IF PO_LOG.d_proc THEN
3653: PO_LOG.proc_begin(d_mod,'p_temp_table_key',p_temp_table_key);
3654: PO_LOG.proc_begin(d_mod,'p_document_id',p_document_id);
3655: END IF;
3656:

Line 3653: PO_LOG.proc_begin(d_mod,'p_temp_table_key',p_temp_table_key);

3649: l_mau GL_CURRENCIES.minimum_accountable_unit%TYPE;
3650: BEGIN
3651:
3652: IF PO_LOG.d_proc THEN
3653: PO_LOG.proc_begin(d_mod,'p_temp_table_key',p_temp_table_key);
3654: PO_LOG.proc_begin(d_mod,'p_document_id',p_document_id);
3655: END IF;
3656:
3657: -- The results will be in PO currency (foreign currency).

Line 3654: PO_LOG.proc_begin(d_mod,'p_document_id',p_document_id);

3650: BEGIN
3651:
3652: IF PO_LOG.d_proc THEN
3653: PO_LOG.proc_begin(d_mod,'p_temp_table_key',p_temp_table_key);
3654: PO_LOG.proc_begin(d_mod,'p_document_id',p_document_id);
3655: END IF;
3656:
3657: -- The results will be in PO currency (foreign currency).
3658: -- arusingh :refactor API to handle release_id case

Line 3722: IF PO_LOG.d_stmt THEN

3718: ;
3719:
3720: d_position := 40;
3721:
3722: IF PO_LOG.d_stmt THEN
3723: PO_LOG.stmt(d_mod,d_position,'Updated amts - rowcount:',SQL%ROWCOUNT);
3724: PO_LOG.proc_end(d_mod);
3725: END IF;
3726:

Line 3723: PO_LOG.stmt(d_mod,d_position,'Updated amts - rowcount:',SQL%ROWCOUNT);

3719:
3720: d_position := 40;
3721:
3722: IF PO_LOG.d_stmt THEN
3723: PO_LOG.stmt(d_mod,d_position,'Updated amts - rowcount:',SQL%ROWCOUNT);
3724: PO_LOG.proc_end(d_mod);
3725: END IF;
3726:
3727: EXCEPTION

Line 3724: PO_LOG.proc_end(d_mod);

3720: d_position := 40;
3721:
3722: IF PO_LOG.d_stmt THEN
3723: PO_LOG.stmt(d_mod,d_position,'Updated amts - rowcount:',SQL%ROWCOUNT);
3724: PO_LOG.proc_end(d_mod);
3725: END IF;
3726:
3727: EXCEPTION
3728: WHEN OTHERS THEN

Line 3729: IF PO_LOG.d_exc THEN

3725: END IF;
3726:
3727: EXCEPTION
3728: WHEN OTHERS THEN
3729: IF PO_LOG.d_exc THEN
3730: PO_LOG.exc(d_mod,d_position,NULL);
3731: END IF;
3732: RAISE;
3733: END prepare_temp_table_data;

Line 3730: PO_LOG.exc(d_mod,d_position,NULL);

3726:
3727: EXCEPTION
3728: WHEN OTHERS THEN
3729: IF PO_LOG.d_exc THEN
3730: PO_LOG.exc(d_mod,d_position,NULL);
3731: END IF;
3732: RAISE;
3733: END prepare_temp_table_data;
3734:

Line 3826: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'calculate_totals');

3822: x_retainage_released_amount OUT NOCOPY NUMBER
3823: )
3824: IS
3825: d_mod CONSTANT VARCHAR2(100) :=
3826: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'calculate_totals');
3827: d_position NUMBER := 0;
3828:
3829: l_quantity_total_actuals NUMBER :=0;
3830: l_quantity_total_financing NUMBER := 0;

Line 3856: IF PO_LOG.d_proc THEN

3852: l_retainage_released_amount NUMBER := 0;
3853: l_is_complex_work_po BOOLEAN := FALSE;
3854: BEGIN
3855:
3856: IF PO_LOG.d_proc THEN
3857: PO_LOG.proc_begin(d_mod,'p_temp_table_key',p_temp_table_key);
3858: PO_LOG.proc_begin(d_mod,'p_document_id',p_document_id);
3859: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);
3860: END IF;

Line 3857: PO_LOG.proc_begin(d_mod,'p_temp_table_key',p_temp_table_key);

3853: l_is_complex_work_po BOOLEAN := FALSE;
3854: BEGIN
3855:
3856: IF PO_LOG.d_proc THEN
3857: PO_LOG.proc_begin(d_mod,'p_temp_table_key',p_temp_table_key);
3858: PO_LOG.proc_begin(d_mod,'p_document_id',p_document_id);
3859: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);
3860: END IF;
3861:

Line 3858: PO_LOG.proc_begin(d_mod,'p_document_id',p_document_id);

3854: BEGIN
3855:
3856: IF PO_LOG.d_proc THEN
3857: PO_LOG.proc_begin(d_mod,'p_temp_table_key',p_temp_table_key);
3858: PO_LOG.proc_begin(d_mod,'p_document_id',p_document_id);
3859: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);
3860: END IF;
3861:
3862: l_is_complex_work_po :=

Line 3859: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);

3855:
3856: IF PO_LOG.d_proc THEN
3857: PO_LOG.proc_begin(d_mod,'p_temp_table_key',p_temp_table_key);
3858: PO_LOG.proc_begin(d_mod,'p_document_id',p_document_id);
3859: PO_LOG.proc_begin(d_mod,'p_doc_level',p_doc_level);
3860: END IF;
3861:
3862: l_is_complex_work_po :=
3863: PO_COMPLEX_WORK_PVT.is_complex_work_po(p_document_id);

Line 3922: IF PO_LOG.d_stmt THEN

3918: WHERE key = p_temp_table_key
3919: ;
3920:
3921: d_position := 20;
3922: IF PO_LOG.d_stmt THEN
3923: PO_LOG.stmt(d_mod,d_position,'Amount totals - rowcount:',SQL%ROWCOUNT);
3924: END IF;
3925:
3926: -- Next, do the calculations for the quantity rows, which is broken into

Line 3923: PO_LOG.stmt(d_mod,d_position,'Amount totals - rowcount:',SQL%ROWCOUNT);

3919: ;
3920:
3921: d_position := 20;
3922: IF PO_LOG.d_stmt THEN
3923: PO_LOG.stmt(d_mod,d_position,'Amount totals - rowcount:',SQL%ROWCOUNT);
3924: END IF;
3925:
3926: -- Next, do the calculations for the quantity rows, which is broken into
3927: -- 2 cases: a summation case and a max-value case

Line 3959: IF PO_LOG.d_stmt THEN

3955: AND nvl(GTT.payment_type, 'NULL') <> C_payment_type_RATE
3956: ;
3957:
3958: d_position := 40;
3959: IF PO_LOG.d_stmt THEN
3960: PO_LOG.stmt(d_mod,d_position,'Sum Qty totals - rowcount:',SQL%ROWCOUNT);
3961: END IF;
3962:
3963: ELSE

Line 3960: PO_LOG.stmt(d_mod,d_position,'Sum Qty totals - rowcount:',SQL%ROWCOUNT);

3956: ;
3957:
3958: d_position := 40;
3959: IF PO_LOG.d_stmt THEN
3960: PO_LOG.stmt(d_mod,d_position,'Sum Qty totals - rowcount:',SQL%ROWCOUNT);
3961: END IF;
3962:
3963: ELSE
3964: -- Qty Milestone Pay Items case for Header, Line, Line Loc level totals

Line 4034: IF PO_LOG.d_stmt THEN

4030: ) GTTSUM
4031: ;
4032:
4033: d_position := 50;
4034: IF PO_LOG.d_stmt THEN
4035: PO_LOG.stmt(d_mod,d_position,'Max Qty totals - rowcount:',SQL%ROWCOUNT);
4036: END IF;
4037:
4038: END IF;

Line 4035: PO_LOG.stmt(d_mod,d_position,'Max Qty totals - rowcount:',SQL%ROWCOUNT);

4031: ;
4032:
4033: d_position := 50;
4034: IF PO_LOG.d_stmt THEN
4035: PO_LOG.stmt(d_mod,d_position,'Max Qty totals - rowcount:',SQL%ROWCOUNT);
4036: END IF;
4037:
4038: END IF;
4039:

Line 4084: IF PO_LOG.d_proc THEN

4080: x_retainage_withheld_amount := l_retainage_withheld_amount;
4081: x_retainage_released_amount := l_retainage_released_amount;
4082:
4083:
4084: IF PO_LOG.d_proc THEN
4085: PO_LOG.proc_end(d_mod,'x_quantity_total',x_quantity_total);
4086: PO_LOG.proc_end(d_mod,'x_amount_total', x_amount_total);
4087: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);
4088: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);

Line 4085: PO_LOG.proc_end(d_mod,'x_quantity_total',x_quantity_total);

4081: x_retainage_released_amount := l_retainage_released_amount;
4082:
4083:
4084: IF PO_LOG.d_proc THEN
4085: PO_LOG.proc_end(d_mod,'x_quantity_total',x_quantity_total);
4086: PO_LOG.proc_end(d_mod,'x_amount_total', x_amount_total);
4087: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);
4088: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);
4089: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);

Line 4086: PO_LOG.proc_end(d_mod,'x_amount_total', x_amount_total);

4082:
4083:
4084: IF PO_LOG.d_proc THEN
4085: PO_LOG.proc_end(d_mod,'x_quantity_total',x_quantity_total);
4086: PO_LOG.proc_end(d_mod,'x_amount_total', x_amount_total);
4087: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);
4088: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);
4089: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);
4090: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);

Line 4087: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);

4083:
4084: IF PO_LOG.d_proc THEN
4085: PO_LOG.proc_end(d_mod,'x_quantity_total',x_quantity_total);
4086: PO_LOG.proc_end(d_mod,'x_amount_total', x_amount_total);
4087: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);
4088: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);
4089: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);
4090: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);
4091: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);

Line 4088: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);

4084: IF PO_LOG.d_proc THEN
4085: PO_LOG.proc_end(d_mod,'x_quantity_total',x_quantity_total);
4086: PO_LOG.proc_end(d_mod,'x_amount_total', x_amount_total);
4087: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);
4088: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);
4089: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);
4090: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);
4091: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);
4092: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);

Line 4089: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);

4085: PO_LOG.proc_end(d_mod,'x_quantity_total',x_quantity_total);
4086: PO_LOG.proc_end(d_mod,'x_amount_total', x_amount_total);
4087: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);
4088: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);
4089: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);
4090: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);
4091: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);
4092: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);
4093: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);

Line 4090: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);

4086: PO_LOG.proc_end(d_mod,'x_amount_total', x_amount_total);
4087: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);
4088: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);
4089: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);
4090: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);
4091: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);
4092: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);
4093: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);
4094: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);

Line 4091: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);

4087: PO_LOG.proc_end(d_mod,'x_quantity_delivered', x_quantity_delivered);
4088: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);
4089: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);
4090: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);
4091: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);
4092: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);
4093: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);
4094: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);
4095: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);

Line 4092: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);

4088: PO_LOG.proc_end(d_mod,'x_amount_delivered', x_amount_delivered);
4089: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);
4090: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);
4091: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);
4092: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);
4093: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);
4094: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);
4095: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);
4096: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);

Line 4093: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);

4089: PO_LOG.proc_end(d_mod,'x_quantity_received', x_quantity_received);
4090: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);
4091: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);
4092: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);
4093: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);
4094: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);
4095: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);
4096: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);
4097: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);

Line 4094: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);

4090: PO_LOG.proc_end(d_mod,'x_amount_received', x_amount_received);
4091: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);
4092: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);
4093: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);
4094: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);
4095: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);
4096: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);
4097: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);
4098: PO_LOG.proc_end(d_mod,'x_amount_recouped', x_amount_recouped);

Line 4095: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);

4091: PO_LOG.proc_end(d_mod,'x_quantity_shipped', x_quantity_shipped);
4092: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);
4093: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);
4094: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);
4095: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);
4096: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);
4097: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);
4098: PO_LOG.proc_end(d_mod,'x_amount_recouped', x_amount_recouped);
4099: PO_LOG.proc_end(d_mod,'x_retainage_withheld_amount', x_retainage_withheld_amount);

Line 4096: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);

4092: PO_LOG.proc_end(d_mod,'x_amount_shipped', x_amount_shipped);
4093: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);
4094: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);
4095: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);
4096: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);
4097: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);
4098: PO_LOG.proc_end(d_mod,'x_amount_recouped', x_amount_recouped);
4099: PO_LOG.proc_end(d_mod,'x_retainage_withheld_amount', x_retainage_withheld_amount);
4100: PO_LOG.proc_end(d_mod,'x_retainage_released_amount', x_retainage_released_amount);

Line 4097: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);

4093: PO_LOG.proc_end(d_mod,'x_quantity_billed', x_quantity_billed);
4094: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);
4095: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);
4096: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);
4097: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);
4098: PO_LOG.proc_end(d_mod,'x_amount_recouped', x_amount_recouped);
4099: PO_LOG.proc_end(d_mod,'x_retainage_withheld_amount', x_retainage_withheld_amount);
4100: PO_LOG.proc_end(d_mod,'x_retainage_released_amount', x_retainage_released_amount);
4101: END IF;

Line 4098: PO_LOG.proc_end(d_mod,'x_amount_recouped', x_amount_recouped);

4094: PO_LOG.proc_end(d_mod,'x_amount_billed', x_amount_billed);
4095: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);
4096: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);
4097: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);
4098: PO_LOG.proc_end(d_mod,'x_amount_recouped', x_amount_recouped);
4099: PO_LOG.proc_end(d_mod,'x_retainage_withheld_amount', x_retainage_withheld_amount);
4100: PO_LOG.proc_end(d_mod,'x_retainage_released_amount', x_retainage_released_amount);
4101: END IF;
4102:

Line 4099: PO_LOG.proc_end(d_mod,'x_retainage_withheld_amount', x_retainage_withheld_amount);

4095: PO_LOG.proc_end(d_mod,'x_quantity_financed', x_quantity_financed);
4096: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);
4097: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);
4098: PO_LOG.proc_end(d_mod,'x_amount_recouped', x_amount_recouped);
4099: PO_LOG.proc_end(d_mod,'x_retainage_withheld_amount', x_retainage_withheld_amount);
4100: PO_LOG.proc_end(d_mod,'x_retainage_released_amount', x_retainage_released_amount);
4101: END IF;
4102:
4103: EXCEPTION

Line 4100: PO_LOG.proc_end(d_mod,'x_retainage_released_amount', x_retainage_released_amount);

4096: PO_LOG.proc_end(d_mod,'x_amount_financed', x_amount_financed);
4097: PO_LOG.proc_end(d_mod,'x_quantity_recouped', x_quantity_recouped);
4098: PO_LOG.proc_end(d_mod,'x_amount_recouped', x_amount_recouped);
4099: PO_LOG.proc_end(d_mod,'x_retainage_withheld_amount', x_retainage_withheld_amount);
4100: PO_LOG.proc_end(d_mod,'x_retainage_released_amount', x_retainage_released_amount);
4101: END IF;
4102:
4103: EXCEPTION
4104: WHEN OTHERS THEN

Line 4105: IF PO_LOG.d_exc THEN

4101: END IF;
4102:
4103: EXCEPTION
4104: WHEN OTHERS THEN
4105: IF PO_LOG.d_exc THEN
4106: PO_LOG.exc(d_mod,d_position,NULL);
4107: END IF;
4108: RAISE;
4109: END calculate_totals;

Line 4106: PO_LOG.exc(d_mod,d_position,NULL);

4102:
4103: EXCEPTION
4104: WHEN OTHERS THEN
4105: IF PO_LOG.d_exc THEN
4106: PO_LOG.exc(d_mod,d_position,NULL);
4107: END IF;
4108: RAISE;
4109: END calculate_totals;
4110:

Line 4137: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'clear_temp_table');

4133: p_temp_table_key IN NUMBER
4134: )
4135: IS
4136: d_mod CONSTANT VARCHAR2(100) :=
4137: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'clear_temp_table');
4138: d_position NUMBER := 0;
4139:
4140: BEGIN
4141:

Line 4142: IF PO_LOG.d_proc THEN

4138: d_position NUMBER := 0;
4139:
4140: BEGIN
4141:
4142: IF PO_LOG.d_proc THEN
4143: PO_LOG.proc_begin(d_mod,'p_temp_table_key',p_temp_table_key);
4144: END IF;
4145:
4146: d_position := 10;

Line 4143: PO_LOG.proc_begin(d_mod,'p_temp_table_key',p_temp_table_key);

4139:
4140: BEGIN
4141:
4142: IF PO_LOG.d_proc THEN
4143: PO_LOG.proc_begin(d_mod,'p_temp_table_key',p_temp_table_key);
4144: END IF;
4145:
4146: d_position := 10;
4147:

Line 4155: IF PO_LOG.d_stmt THEN

4151: WHERE key = p_temp_table_key
4152: ;
4153:
4154: d_position := 20;
4155: IF PO_LOG.d_stmt THEN
4156: PO_LOG.stmt(d_mod,d_position,'Deleted data - rowcount:',SQL%ROWCOUNT);
4157: END IF;
4158:
4159: IF PO_LOG.d_proc THEN

Line 4156: PO_LOG.stmt(d_mod,d_position,'Deleted data - rowcount:',SQL%ROWCOUNT);

4152: ;
4153:
4154: d_position := 20;
4155: IF PO_LOG.d_stmt THEN
4156: PO_LOG.stmt(d_mod,d_position,'Deleted data - rowcount:',SQL%ROWCOUNT);
4157: END IF;
4158:
4159: IF PO_LOG.d_proc THEN
4160: PO_LOG.proc_end(d_mod);

Line 4159: IF PO_LOG.d_proc THEN

4155: IF PO_LOG.d_stmt THEN
4156: PO_LOG.stmt(d_mod,d_position,'Deleted data - rowcount:',SQL%ROWCOUNT);
4157: END IF;
4158:
4159: IF PO_LOG.d_proc THEN
4160: PO_LOG.proc_end(d_mod);
4161: END IF;
4162:
4163: EXCEPTION

Line 4160: PO_LOG.proc_end(d_mod);

4156: PO_LOG.stmt(d_mod,d_position,'Deleted data - rowcount:',SQL%ROWCOUNT);
4157: END IF;
4158:
4159: IF PO_LOG.d_proc THEN
4160: PO_LOG.proc_end(d_mod);
4161: END IF;
4162:
4163: EXCEPTION
4164: WHEN OTHERS THEN

Line 4165: IF PO_LOG.d_exc THEN

4161: END IF;
4162:
4163: EXCEPTION
4164: WHEN OTHERS THEN
4165: IF PO_LOG.d_exc THEN
4166: PO_LOG.exc(d_mod,d_position,NULL);
4167: END IF;
4168: RAISE;
4169: END clear_temp_table;

Line 4166: PO_LOG.exc(d_mod,d_position,NULL);

4162:
4163: EXCEPTION
4164: WHEN OTHERS THEN
4165: IF PO_LOG.d_exc THEN
4166: PO_LOG.exc(d_mod,d_position,NULL);
4167: END IF;
4168: RAISE;
4169: END clear_temp_table;
4170: