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

APPS.PO_PARTIAL_FUNDING_PKG dependencies on PO_LOG

Line 3: d_pkg_name CONSTANT VARCHAR2(50) := po_log.Get_package_base('PO_PARTIAL_FUNDING_PKG');

1: PACKAGE BODY po_partial_funding_pkg AS
2: /* $Header: PO_PARTIAL_FUNDING_PKG.plb 120.12.12020000.3 2013/04/08 09:13:46 dtoshniw ship $ */
3: d_pkg_name CONSTANT VARCHAR2(50) := po_log.Get_package_base('PO_PARTIAL_FUNDING_PKG');
4:
5: /*=======================================================================+
6: | FILENAME
7: | PO_PARTIAL_FUNDING_PKG.plB

Line 29: IF (po_log.d_proc) THEN

25:
26: BEGIN
27: d_progress := 10;
28:
29: IF (po_log.d_proc) THEN
30: po_log.Proc_begin(d_module);
31:
32: po_log.Proc_begin(d_module,'p_Doc_type',p_doc_type);
33:

Line 30: po_log.Proc_begin(d_module);

26: BEGIN
27: d_progress := 10;
28:
29: IF (po_log.d_proc) THEN
30: po_log.Proc_begin(d_module);
31:
32: po_log.Proc_begin(d_module,'p_Doc_type',p_doc_type);
33:
34: po_log.Proc_begin(d_module,'p_Doc_Level_Id',p_doc_level_id);

Line 32: po_log.Proc_begin(d_module,'p_Doc_type',p_doc_type);

28:
29: IF (po_log.d_proc) THEN
30: po_log.Proc_begin(d_module);
31:
32: po_log.Proc_begin(d_module,'p_Doc_type',p_doc_type);
33:
34: po_log.Proc_begin(d_module,'p_Doc_Level_Id',p_doc_level_id);
35: END IF;
36:

Line 34: po_log.Proc_begin(d_module,'p_Doc_Level_Id',p_doc_level_id);

30: po_log.Proc_begin(d_module);
31:
32: po_log.Proc_begin(d_module,'p_Doc_type',p_doc_type);
33:
34: po_log.Proc_begin(d_module,'p_Doc_Level_Id',p_doc_level_id);
35: END IF;
36:
37: d_progress := 20;
38:

Line 57: IF po_log.d_stmt THEN

53: END IF;
54:
55: d_progress := 30;
56:
57: IF po_log.d_stmt THEN
58: po_log.Stmt(d_module,d_progress,'l_Clm_Document: '
59: ||l_clm_document);
60: END IF;
61:

Line 58: po_log.Stmt(d_module,d_progress,'l_Clm_Document: '

54:
55: d_progress := 30;
56:
57: IF po_log.d_stmt THEN
58: po_log.Stmt(d_module,d_progress,'l_Clm_Document: '
59: ||l_clm_document);
60: END IF;
61:
62: RETURN l_clm_document;

Line 69: IF po_log.d_stmt THEN

65: l_clm_document := 'N';
66:
67: RETURN l_clm_document;
68: WHEN OTHERS THEN
69: IF po_log.d_stmt THEN
70: po_log.Stmt(d_module,d_progress,'Error is : ',sqlerrm);
71: END IF;
72: END;
73:

Line 70: po_log.Stmt(d_module,d_progress,'Error is : ',sqlerrm);

66:
67: RETURN l_clm_document;
68: WHEN OTHERS THEN
69: IF po_log.d_stmt THEN
70: po_log.Stmt(d_module,d_progress,'Error is : ',sqlerrm);
71: END IF;
72: END;
73:
74: FUNCTION Is_clm_enabled

Line 90: IF po_log.d_stmt THEN

86:
87: RETURN l_clm_enabled;
88: EXCEPTION
89: WHEN OTHERS THEN
90: IF po_log.d_stmt THEN
91: po_log.Stmt(d_module,d_progress,'Error is : ',sqlerrm);
92: END IF;
93:
94: RETURN l_clm_enabled;

Line 91: po_log.Stmt(d_module,d_progress,'Error is : ',sqlerrm);

87: RETURN l_clm_enabled;
88: EXCEPTION
89: WHEN OTHERS THEN
90: IF po_log.d_stmt THEN
91: po_log.Stmt(d_module,d_progress,'Error is : ',sqlerrm);
92: END IF;
93:
94: RETURN l_clm_enabled;
95: END;

Line 127: IF po_log.d_stmt THEN

123: RETURN l_ACRN_enabled;
124:
125: EXCEPTION
126: WHEN OTHERS THEN
127: IF po_log.d_stmt THEN
128: po_log.Stmt(d_module,d_progress,'Error is : ',sqlerrm);
129: END IF;
130:
131: END;

Line 128: po_log.Stmt(d_module,d_progress,'Error is : ',sqlerrm);

124:
125: EXCEPTION
126: WHEN OTHERS THEN
127: IF po_log.d_stmt THEN
128: po_log.Stmt(d_module,d_progress,'Error is : ',sqlerrm);
129: END IF;
130:
131: END;
132:

Line 154: IF (po_log.d_proc) THEN

150: BEGIN
151:
152: d_progress := 10;
153:
154: IF (po_log.d_proc) THEN
155: po_log.Proc_begin(d_module);
156: po_log.Proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
157: END IF;
158:

Line 155: po_log.Proc_begin(d_module);

151:
152: d_progress := 10;
153:
154: IF (po_log.d_proc) THEN
155: po_log.Proc_begin(d_module);
156: po_log.Proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
157: END IF;
158:
159: SELECT NVL(style_id,-1)

Line 156: po_log.Proc_begin(d_module,'p_doc_header_id',p_doc_header_id);

152: d_progress := 10;
153:
154: IF (po_log.d_proc) THEN
155: po_log.Proc_begin(d_module);
156: po_log.Proc_begin(d_module,'p_doc_header_id',p_doc_header_id);
157: END IF;
158:
159: SELECT NVL(style_id,-1)
160: INTO l_style_id

Line 181: IF (po_log.d_proc) THEN

177: x_return_status => l_return_status);
178:
179: END IF;
180:
181: IF (po_log.d_proc) THEN
182: po_log.Proc_end(d_module,'p_doc_header_id',p_doc_header_id);
183: END IF;
184:
185: EXCEPTION

Line 182: po_log.Proc_end(d_module,'p_doc_header_id',p_doc_header_id);

178:
179: END IF;
180:
181: IF (po_log.d_proc) THEN
182: po_log.Proc_end(d_module,'p_doc_header_id',p_doc_header_id);
183: END IF;
184:
185: EXCEPTION
186: WHEN OTHERS THEN

Line 187: IF (po_log.d_exc) THEN

183: END IF;
184:
185: EXCEPTION
186: WHEN OTHERS THEN
187: IF (po_log.d_exc) THEN
188: po_log.Exc(d_module,d_progress,SQLCODE
189: ||sqlerrm);
190: END IF;
191: END recalculate_pf_attributes;

Line 188: po_log.Exc(d_module,d_progress,SQLCODE

184:
185: EXCEPTION
186: WHEN OTHERS THEN
187: IF (po_log.d_exc) THEN
188: po_log.Exc(d_module,d_progress,SQLCODE
189: ||sqlerrm);
190: END IF;
191: END recalculate_pf_attributes;
192:

Line 373: IF (po_log.d_exc) THEN

369: EXCEPTION
370: WHEN OTHERS THEN
371: x_return_status := fnd_api.g_ret_sts_unexp_error;
372:
373: IF (po_log.d_exc) THEN
374: po_log.Exc(d_module,d_progress,SQLCODE
375: ||sqlerrm);
376:
377: po_log.Proc_end(d_module,'x_return_status',x_return_status);

Line 374: po_log.Exc(d_module,d_progress,SQLCODE

370: WHEN OTHERS THEN
371: x_return_status := fnd_api.g_ret_sts_unexp_error;
372:
373: IF (po_log.d_exc) THEN
374: po_log.Exc(d_module,d_progress,SQLCODE
375: ||sqlerrm);
376:
377: po_log.Proc_end(d_module,'x_return_status',x_return_status);
378: END IF;

Line 377: po_log.Proc_end(d_module,'x_return_status',x_return_status);

373: IF (po_log.d_exc) THEN
374: po_log.Exc(d_module,d_progress,SQLCODE
375: ||sqlerrm);
376:
377: po_log.Proc_end(d_module,'x_return_status',x_return_status);
378: END IF;
379: END updt_funding_info;
380:
381: /*

Line 424: IF (po_log.d_exc) THEN

420: EXCEPTION
421: WHEN OTHERS THEN
422: x_return_status := fnd_api.g_ret_sts_unexp_error;
423:
424: IF (po_log.d_exc) THEN
425: po_log.Exc(d_module,d_progress,SQLCODE
426: ||sqlerrm);
427:
428: po_log.Proc_end(d_module,'x_return_status',x_return_status);

Line 425: po_log.Exc(d_module,d_progress,SQLCODE

421: WHEN OTHERS THEN
422: x_return_status := fnd_api.g_ret_sts_unexp_error;
423:
424: IF (po_log.d_exc) THEN
425: po_log.Exc(d_module,d_progress,SQLCODE
426: ||sqlerrm);
427:
428: po_log.Proc_end(d_module,'x_return_status',x_return_status);
429: END IF;

Line 428: po_log.Proc_end(d_module,'x_return_status',x_return_status);

424: IF (po_log.d_exc) THEN
425: po_log.Exc(d_module,d_progress,SQLCODE
426: ||sqlerrm);
427:
428: po_log.Proc_end(d_module,'x_return_status',x_return_status);
429: END IF;
430: END get_change_in_funds;
431:
432: PROCEDURE Get_qty_amt_funded

Line 472: IF (po_log.d_exc) THEN

468: EXCEPTION
469: WHEN OTHERS THEN
470: x_return_status := fnd_api.g_ret_sts_unexp_error;
471:
472: IF (po_log.d_exc) THEN
473: po_log.Exc(d_module,d_progress,SQLCODE
474: ||sqlerrm);
475:
476: po_log.Proc_end(d_module,'x_return_status',x_return_status);

Line 473: po_log.Exc(d_module,d_progress,SQLCODE

469: WHEN OTHERS THEN
470: x_return_status := fnd_api.g_ret_sts_unexp_error;
471:
472: IF (po_log.d_exc) THEN
473: po_log.Exc(d_module,d_progress,SQLCODE
474: ||sqlerrm);
475:
476: po_log.Proc_end(d_module,'x_return_status',x_return_status);
477: END IF;

Line 476: po_log.Proc_end(d_module,'x_return_status',x_return_status);

472: IF (po_log.d_exc) THEN
473: po_log.Exc(d_module,d_progress,SQLCODE
474: ||sqlerrm);
475:
476: po_log.Proc_end(d_module,'x_return_status',x_return_status);
477: END IF;
478: END get_qty_amt_funded;
479:
480: PROCEDURE Updt_Funds_Split(x_return_status OUT NOCOPY VARCHAR2, p_new_Req_line_id in number)

Line 595: IF po_log.d_stmt THEN

591:
592: IF l_doc_type = 'REQ' THEN
593: d_progress := 15;
594:
595: IF po_log.d_stmt THEN
596: po_log.Stmt(d_module,d_progress,'Document Type : '
597: ||l_doc_type);
598: END IF;
599:

Line 596: po_log.Stmt(d_module,d_progress,'Document Type : '

592: IF l_doc_type = 'REQ' THEN
593: d_progress := 15;
594:
595: IF po_log.d_stmt THEN
596: po_log.Stmt(d_module,d_progress,'Document Type : '
597: ||l_doc_type);
598: END IF;
599:
600: IF l_distribution_id IS NOT NULL THEN

Line 603: IF po_log.d_stmt THEN

599:
600: IF l_distribution_id IS NOT NULL THEN
601: d_progress := 20;
602:
603: IF po_log.d_stmt THEN
604: po_log.Stmt(d_module,d_progress,'Distribution id is not null : '
605: ||l_distribution_id);
606: END IF;
607:

Line 604: po_log.Stmt(d_module,d_progress,'Distribution id is not null : '

600: IF l_distribution_id IS NOT NULL THEN
601: d_progress := 20;
602:
603: IF po_log.d_stmt THEN
604: po_log.Stmt(d_module,d_progress,'Distribution id is not null : '
605: ||l_distribution_id);
606: END IF;
607:
608: SELECT Nvl(funded_value,0)

Line 615: IF po_log.d_stmt THEN

611: WHERE distribution_id = l_distribution_id;
612: ELSIF l_line_id IS NOT NULL THEN
613: d_progress := 25;
614:
615: IF po_log.d_stmt THEN
616: po_log.Stmt(d_module,d_progress,'Line id is not null : '
617: ||l_line_id);
618: END IF;
619:

Line 616: po_log.Stmt(d_module,d_progress,'Line id is not null : '

612: ELSIF l_line_id IS NOT NULL THEN
613: d_progress := 25;
614:
615: IF po_log.d_stmt THEN
616: po_log.Stmt(d_module,d_progress,'Line id is not null : '
617: ||l_line_id);
618: END IF;
619:
620: SELECT Sum(Nvl(funded_value,0))

Line 629: IF po_log.d_stmt THEN

625: AND l.requisition_line_id = l_line_id;
626: ELSIF l_header_id IS NOT NULL THEN
627: d_progress := 30;
628:
629: IF po_log.d_stmt THEN
630: po_log.Stmt(d_module,d_progress,'Header id is not null : '
631: ||l_header_id);
632: END IF;
633:

Line 630: po_log.Stmt(d_module,d_progress,'Header id is not null : '

626: ELSIF l_header_id IS NOT NULL THEN
627: d_progress := 30;
628:
629: IF po_log.d_stmt THEN
630: po_log.Stmt(d_module,d_progress,'Header id is not null : '
631: ||l_header_id);
632: END IF;
633:
634: SELECT Sum(Nvl(funded_value,0))

Line 644: IF po_log.d_stmt THEN

640: END IF;
641: ELSIF l_doc_type = 'PO' THEN
642: d_progress := 35;
643:
644: IF po_log.d_stmt THEN
645: po_log.Stmt(d_module,d_progress,'Document Type is : '
646: ||l_doc_type);
647: END IF;
648:

Line 645: po_log.Stmt(d_module,d_progress,'Document Type is : '

641: ELSIF l_doc_type = 'PO' THEN
642: d_progress := 35;
643:
644: IF po_log.d_stmt THEN
645: po_log.Stmt(d_module,d_progress,'Document Type is : '
646: ||l_doc_type);
647: END IF;
648:
649: IF l_distribution_id IS NOT NULL THEN

Line 652: IF po_log.d_stmt THEN

648:
649: IF l_distribution_id IS NOT NULL THEN
650: d_progress := 40;
651:
652: IF po_log.d_stmt THEN
653: po_log.Stmt(d_module,d_progress,'Distribution id is not null : '
654: ||l_distribution_id);
655: END IF;
656:

Line 653: po_log.Stmt(d_module,d_progress,'Distribution id is not null : '

649: IF l_distribution_id IS NOT NULL THEN
650: d_progress := 40;
651:
652: IF po_log.d_stmt THEN
653: po_log.Stmt(d_module,d_progress,'Distribution id is not null : '
654: ||l_distribution_id);
655: END IF;
656:
657: SELECT Nvl(funded_value,0)

Line 664: IF po_log.d_stmt THEN

660: WHERE po_distribution_id = l_distribution_id;
661: ELSIF l_shipment_id IS NOT NULL THEN
662: d_progress := 45;
663:
664: IF po_log.d_stmt THEN
665: po_log.Stmt(d_module,d_progress,'Shipment id is not null : '
666: ||l_shipment_id);
667: END IF;
668:

Line 665: po_log.Stmt(d_module,d_progress,'Shipment id is not null : '

661: ELSIF l_shipment_id IS NOT NULL THEN
662: d_progress := 45;
663:
664: IF po_log.d_stmt THEN
665: po_log.Stmt(d_module,d_progress,'Shipment id is not null : '
666: ||l_shipment_id);
667: END IF;
668:
669: SELECT Sum(Nvl(funded_value,0))

Line 676: IF po_log.d_stmt THEN

672: WHERE d.line_location_id = l_shipment_id;
673: ELSIF l_line_id IS NOT NULL THEN
674: d_progress := 50;
675:
676: IF po_log.d_stmt THEN
677: po_log.Stmt(d_module,d_progress,'Line id is not null : '
678: ||l_line_id);
679: END IF;
680:

Line 677: po_log.Stmt(d_module,d_progress,'Line id is not null : '

673: ELSIF l_line_id IS NOT NULL THEN
674: d_progress := 50;
675:
676: IF po_log.d_stmt THEN
677: po_log.Stmt(d_module,d_progress,'Line id is not null : '
678: ||l_line_id);
679: END IF;
680:
681: SELECT Sum(Nvl(funded_value,0))

Line 688: IF po_log.d_stmt THEN

684: WHERE d.po_line_id = l_line_id;
685: ELSIF l_header_id IS NOT NULL THEN
686: d_progress := 55;
687:
688: IF po_log.d_stmt THEN
689: po_log.Stmt(d_module,d_progress,'Header id is not null : '
690: ||l_header_id);
691: END IF;
692:

Line 689: po_log.Stmt(d_module,d_progress,'Header id is not null : '

685: ELSIF l_header_id IS NOT NULL THEN
686: d_progress := 55;
687:
688: IF po_log.d_stmt THEN
689: po_log.Stmt(d_module,d_progress,'Header id is not null : '
690: ||l_header_id);
691: END IF;
692:
693: SELECT Sum(Nvl(funded_value,0))

Line 702: IF po_log.d_stmt THEN

698: END IF;
699:
700: d_progress := 60;
701:
702: IF po_log.d_stmt THEN
703: po_log.Stmt(d_module,d_progress,'Funded Value is : '
704: ||l_funded_value);
705: END IF;
706:

Line 703: po_log.Stmt(d_module,d_progress,'Funded Value is : '

699:
700: d_progress := 60;
701:
702: IF po_log.d_stmt THEN
703: po_log.Stmt(d_module,d_progress,'Funded Value is : '
704: ||l_funded_value);
705: END IF;
706:
707: RETURN l_funded_value;

Line 712: IF (po_log.d_exc) THEN

708: EXCEPTION
709: WHEN OTHERS THEN
710: RETURN l_funded_value;
711:
712: IF (po_log.d_exc) THEN
713: po_log.Exc(d_module,d_progress,SQLCODE
714: ||sqlerrm);
715: END IF;
716: END get_funded_value;

Line 713: po_log.Exc(d_module,d_progress,SQLCODE

709: WHEN OTHERS THEN
710: RETURN l_funded_value;
711:
712: IF (po_log.d_exc) THEN
713: po_log.Exc(d_module,d_progress,SQLCODE
714: ||sqlerrm);
715: END IF;
716: END get_funded_value;
717: