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_LINK_REQ_DIST_PVT dependencies on PO_LOG

Line 6: PO_LOG.GET_PACKAGE_BASE('PO_LINK_REQ_DIST_PVT');

2: /* $Header: PO_LINK_REQ_DIST_PVT.plb 120.17.12020000.4 2013/02/27 18:55:34 akyanama ship $ */
3:
4:
5: D_PKG_NAME CONSTANT VARCHAR2(50) :=
6: PO_LOG.GET_PACKAGE_BASE('PO_LINK_REQ_DIST_PVT');
7:
8: G_GL_DATE DATE;
9: G_PREVIOUS_GL_DATE DATE ;
10: G_GL_PERIOD_NAME VARCHAR2(30);

Line 22: IF PO_LOG.D_STMT THEN

18: )
19: IS
20: BEGIN
21: -- WRITE THE MESSAGE TO THE FND LOG, IF ENABLED.
22: IF PO_LOG.D_STMT THEN
23: PO_LOG.STMT(P_MODULE, P_PROGRESS, P_MSG);
24: END IF;
25:
26:

Line 23: PO_LOG.STMT(P_MODULE, P_PROGRESS, P_MSG);

19: IS
20: BEGIN
21: -- WRITE THE MESSAGE TO THE FND LOG, IF ENABLED.
22: IF PO_LOG.D_STMT THEN
23: PO_LOG.STMT(P_MODULE, P_PROGRESS, P_MSG);
24: END IF;
25:
26:
27: END DEBUG;

Line 38: IF (PO_LOG.D_PROC) THEN

34: D_POSITION NUMBER;
35:
36: BEGIN
37: D_POSITION := 0;
38: IF (PO_LOG.D_PROC) THEN
39: PO_LOG.PROC_BEGIN(D_MODULE,'G_GL_PERIOD_NAME',G_GL_PERIOD_NAME);
40: END IF;
41:
42: D_POSITION := 10;

Line 39: PO_LOG.PROC_BEGIN(D_MODULE,'G_GL_PERIOD_NAME',G_GL_PERIOD_NAME);

35:
36: BEGIN
37: D_POSITION := 0;
38: IF (PO_LOG.D_PROC) THEN
39: PO_LOG.PROC_BEGIN(D_MODULE,'G_GL_PERIOD_NAME',G_GL_PERIOD_NAME);
40: END IF;
41:
42: D_POSITION := 10;
43: IF (PO_LOG.D_PROC) THEN

Line 43: IF (PO_LOG.D_PROC) THEN

39: PO_LOG.PROC_BEGIN(D_MODULE,'G_GL_PERIOD_NAME',G_GL_PERIOD_NAME);
40: END IF;
41:
42: D_POSITION := 10;
43: IF (PO_LOG.D_PROC) THEN
44: PO_LOG.PROC_END(D_MODULE);
45: END IF;
46:
47: RETURN G_GL_PERIOD_NAME;

Line 44: PO_LOG.PROC_END(D_MODULE);

40: END IF;
41:
42: D_POSITION := 10;
43: IF (PO_LOG.D_PROC) THEN
44: PO_LOG.PROC_END(D_MODULE);
45: END IF;
46:
47: RETURN G_GL_PERIOD_NAME;
48:

Line 64: IF (PO_LOG.D_PROC) THEN

60:
61: BEGIN
62:
63: D_POSITION := 0;
64: IF (PO_LOG.D_PROC) THEN
65:
66: PO_LOG.PROC_BEGIN(D_MODULE,'p_gl_date,p_sob_id, G_PREVIOUS_GL_DATE :',p_gl_date||' ,'||p_sob_id||' ,'||G_PREVIOUS_GL_DATE);
67:
68: END IF;

Line 66: PO_LOG.PROC_BEGIN(D_MODULE,'p_gl_date,p_sob_id, G_PREVIOUS_GL_DATE :',p_gl_date||' ,'||p_sob_id||' ,'||G_PREVIOUS_GL_DATE);

62:
63: D_POSITION := 0;
64: IF (PO_LOG.D_PROC) THEN
65:
66: PO_LOG.PROC_BEGIN(D_MODULE,'p_gl_date,p_sob_id, G_PREVIOUS_GL_DATE :',p_gl_date||' ,'||p_sob_id||' ,'||G_PREVIOUS_GL_DATE);
67:
68: END IF;
69:
70: l_gl_date := p_gl_date;

Line 91: IF (PO_LOG.D_PROC) THEN

87: DEBUG(D_MODULE, D_POSITION, 'l_gl_date: '||l_gl_date ||'G_GL_DATE: '||G_GL_DATE || ' G_GL_PERIOD_NAME:'||G_GL_PERIOD_NAME);
88:
89:
90: D_POSITION := 30;
91: IF (PO_LOG.D_PROC) THEN
92: PO_LOG.PROC_END(D_MODULE);
93: END IF;
94:
95:

Line 92: PO_LOG.PROC_END(D_MODULE);

88:
89:
90: D_POSITION := 30;
91: IF (PO_LOG.D_PROC) THEN
92: PO_LOG.PROC_END(D_MODULE);
93: END IF;
94:
95:
96: RETURN G_GL_DATE;

Line 190: IF (PO_LOG.D_PROC) THEN

186:
187: BEGIN
188:
189: D_POSITION := 0;
190: IF (PO_LOG.D_PROC) THEN
191: PO_LOG.PROC_BEGIN(D_MODULE,'P_TOTAL_DIST_AMT_REQUIRED',P_TOTAL_DIST_AMT_REQUIRED);
192: PO_LOG.PROC_BEGIN(D_MODULE,'P_TOTAL_FUNDS_TO_USE',P_TOTAL_FUNDS_TO_USE);
193:
194: END IF;

Line 191: PO_LOG.PROC_BEGIN(D_MODULE,'P_TOTAL_DIST_AMT_REQUIRED',P_TOTAL_DIST_AMT_REQUIRED);

187: BEGIN
188:
189: D_POSITION := 0;
190: IF (PO_LOG.D_PROC) THEN
191: PO_LOG.PROC_BEGIN(D_MODULE,'P_TOTAL_DIST_AMT_REQUIRED',P_TOTAL_DIST_AMT_REQUIRED);
192: PO_LOG.PROC_BEGIN(D_MODULE,'P_TOTAL_FUNDS_TO_USE',P_TOTAL_FUNDS_TO_USE);
193:
194: END IF;
195: --DBMS_OUTPUT.PUT_LINE('1');

Line 192: PO_LOG.PROC_BEGIN(D_MODULE,'P_TOTAL_FUNDS_TO_USE',P_TOTAL_FUNDS_TO_USE);

188:
189: D_POSITION := 0;
190: IF (PO_LOG.D_PROC) THEN
191: PO_LOG.PROC_BEGIN(D_MODULE,'P_TOTAL_DIST_AMT_REQUIRED',P_TOTAL_DIST_AMT_REQUIRED);
192: PO_LOG.PROC_BEGIN(D_MODULE,'P_TOTAL_FUNDS_TO_USE',P_TOTAL_FUNDS_TO_USE);
193:
194: END IF;
195: --DBMS_OUTPUT.PUT_LINE('1');
196:

Line 952: IF (PO_LOG.D_PROC) THEN

948:
949: END LOOP;
950:
951: D_POSITION := 240;
952: IF (PO_LOG.D_PROC) THEN
953: PO_LOG.PROC_END(D_MODULE);
954: END IF;
955:
956:

Line 953: PO_LOG.PROC_END(D_MODULE);

949: END LOOP;
950:
951: D_POSITION := 240;
952: IF (PO_LOG.D_PROC) THEN
953: PO_LOG.PROC_END(D_MODULE);
954: END IF;
955:
956:
957: EXCEPTION

Line 1055: IF (PO_LOG.D_PROC) THEN

1051:
1052: BEGIN
1053:
1054: D_POSITION := 0;
1055: IF (PO_LOG.D_PROC) THEN
1056: PO_LOG.PROC_BEGIN(D_MODULE,'1',1);
1057: END IF;
1058:
1059: IF (X_RESULTS IS NULL) THEN

Line 1056: PO_LOG.PROC_BEGIN(D_MODULE,'1',1);

1052: BEGIN
1053:
1054: D_POSITION := 0;
1055: IF (PO_LOG.D_PROC) THEN
1056: PO_LOG.PROC_BEGIN(D_MODULE,'1',1);
1057: END IF;
1058:
1059: IF (X_RESULTS IS NULL) THEN
1060: X_RESULTS := PO_MULTI_MOD_VAL_RESULTS_TYPE.NEW_INSTANCE();

Line 1585: IF (PO_LOG.D_PROC) THEN

1581:
1582: END LOOP;
1583: CLOSE GT_ZERO_VALIDATION_REFCUR;
1584:
1585: IF (PO_LOG.D_PROC) THEN
1586: PO_LOG.PROC_END(D_MODULE);
1587: END IF;
1588:
1589: EXCEPTION

Line 1586: PO_LOG.PROC_END(D_MODULE);

1582: END LOOP;
1583: CLOSE GT_ZERO_VALIDATION_REFCUR;
1584:
1585: IF (PO_LOG.D_PROC) THEN
1586: PO_LOG.PROC_END(D_MODULE);
1587: END IF;
1588:
1589: EXCEPTION
1590: WHEN OTHERS THEN

Line 1626: IF (PO_LOG.D_PROC) THEN

1622:
1623: -- ADDED CALL TO JG_GLOBE_UTIL_PKG.PROCESS_PO_GLOBE_EVENT
1624:
1625: D_POSITION := 0;
1626: IF (PO_LOG.D_PROC) THEN
1627: PO_LOG.PROC_BEGIN(D_MODULE,'LEVEL_TYPE',LEVEL_TYPE);
1628: PO_LOG.PROC_BEGIN(D_MODULE,'LEVEL_ID',LEVEL_ID);
1629: END IF;
1630:

Line 1627: PO_LOG.PROC_BEGIN(D_MODULE,'LEVEL_TYPE',LEVEL_TYPE);

1623: -- ADDED CALL TO JG_GLOBE_UTIL_PKG.PROCESS_PO_GLOBE_EVENT
1624:
1625: D_POSITION := 0;
1626: IF (PO_LOG.D_PROC) THEN
1627: PO_LOG.PROC_BEGIN(D_MODULE,'LEVEL_TYPE',LEVEL_TYPE);
1628: PO_LOG.PROC_BEGIN(D_MODULE,'LEVEL_ID',LEVEL_ID);
1629: END IF;
1630:
1631: ---------------------------------------------------

Line 1628: PO_LOG.PROC_BEGIN(D_MODULE,'LEVEL_ID',LEVEL_ID);

1624:
1625: D_POSITION := 0;
1626: IF (PO_LOG.D_PROC) THEN
1627: PO_LOG.PROC_BEGIN(D_MODULE,'LEVEL_TYPE',LEVEL_TYPE);
1628: PO_LOG.PROC_BEGIN(D_MODULE,'LEVEL_ID',LEVEL_ID);
1629: END IF;
1630:
1631: ---------------------------------------------------
1632: -- EXECUTE DYNAMICALLY THE REGIONAL PROCEDURE

Line 1652: IF (PO_LOG.D_PROC) THEN

1648: -- CLOSE THE CURSOR
1649: DBMS_SQL.CLOSE_CURSOR(L_CURSOR);
1650:
1651: D_POSITION := 010;
1652: IF (PO_LOG.D_PROC) THEN
1653: PO_LOG.PROC_END(D_MODULE);
1654: END IF;
1655:
1656:

Line 1653: PO_LOG.PROC_END(D_MODULE);

1649: DBMS_SQL.CLOSE_CURSOR(L_CURSOR);
1650:
1651: D_POSITION := 010;
1652: IF (PO_LOG.D_PROC) THEN
1653: PO_LOG.PROC_END(D_MODULE);
1654: END IF;
1655:
1656:
1657: EXCEPTION

Line 1724: IF (PO_LOG.D_STMT) THEN

1720:
1721:
1722: -- CALLING BUIL_ACRN API
1723:
1724: IF (PO_LOG.D_STMT) THEN
1725: PO_LOG.STMT(L_MODULE||L_API_NAME, L_PROGRESS, 'CALLING BUILD_ACRN');
1726: END IF;
1727:
1728: PO_ACCOUNT_HELPER.BUILD_ACRN

Line 1725: PO_LOG.STMT(L_MODULE||L_API_NAME, L_PROGRESS, 'CALLING BUILD_ACRN');

1721:
1722: -- CALLING BUIL_ACRN API
1723:
1724: IF (PO_LOG.D_STMT) THEN
1725: PO_LOG.STMT(L_MODULE||L_API_NAME, L_PROGRESS, 'CALLING BUILD_ACRN');
1726: END IF;
1727:
1728: PO_ACCOUNT_HELPER.BUILD_ACRN
1729: (PO_AUTOCREATE_PARAMS.G_PO_HEADER_ID, L_DIST_ID_TBL, L_CHARGE_ACC_TBL, L_ACRN_TBL,

Line 1735: IF (PO_LOG.D_STMT) THEN

1731: X_ACRN_TBL, X_RETURN_STATUS, X_RETURN_MESSAGE, X_MESSAGE_TOKEN);
1732:
1733: L_ACRN_TBL := X_ACRN_TBL;
1734:
1735: IF (PO_LOG.D_STMT) THEN
1736: PO_LOG.STMT(L_MODULE||L_API_NAME, L_PROGRESS, 'AFTER BUILD_ACRN');
1737: END IF;
1738:
1739:

Line 1736: PO_LOG.STMT(L_MODULE||L_API_NAME, L_PROGRESS, 'AFTER BUILD_ACRN');

1732:
1733: L_ACRN_TBL := X_ACRN_TBL;
1734:
1735: IF (PO_LOG.D_STMT) THEN
1736: PO_LOG.STMT(L_MODULE||L_API_NAME, L_PROGRESS, 'AFTER BUILD_ACRN');
1737: END IF;
1738:
1739:
1740: IF (L_DRAFT_ID <> -1 ) THEN

Line 1762: IF (PO_LOG.D_EXC) THEN

1758: END IF;
1759:
1760: EXCEPTION
1761: WHEN OTHERS THEN
1762: IF (PO_LOG.D_EXC) THEN
1763: PO_LOG.EXC(L_MODULE, L_PROGRESS, SQLCODE||SQLERRM);
1764: END IF;
1765:
1766: RAISE;

Line 1763: PO_LOG.EXC(L_MODULE, L_PROGRESS, SQLCODE||SQLERRM);

1759:
1760: EXCEPTION
1761: WHEN OTHERS THEN
1762: IF (PO_LOG.D_EXC) THEN
1763: PO_LOG.EXC(L_MODULE, L_PROGRESS, SQLCODE||SQLERRM);
1764: END IF;
1765:
1766: RAISE;
1767:

Line 1813: IF (PO_LOG.D_PROC) THEN

1809:
1810: BEGIN
1811:
1812: D_POSITION := 0;
1813: IF (PO_LOG.D_PROC) THEN
1814: PO_LOG.PROC_BEGIN(D_MODULE,'1',1);
1815: END IF;
1816:
1817: SELECT INDEX_NUM2, NUM1 INTO L_DRAFT_ID, L_HEADER_ID

Line 1814: PO_LOG.PROC_BEGIN(D_MODULE,'1',1);

1810: BEGIN
1811:
1812: D_POSITION := 0;
1813: IF (PO_LOG.D_PROC) THEN
1814: PO_LOG.PROC_BEGIN(D_MODULE,'1',1);
1815: END IF;
1816:
1817: SELECT INDEX_NUM2, NUM1 INTO L_DRAFT_ID, L_HEADER_ID
1818: FROM PO_SESSION_GT

Line 2427: IF (PO_LOG.D_PROC) THEN

2423: END IF;
2424:
2425:
2426: D_POSITION := 140 ;
2427: IF (PO_LOG.D_PROC) THEN
2428: PO_LOG.PROC_END(D_MODULE);
2429: END IF;
2430:
2431:

Line 2428: PO_LOG.PROC_END(D_MODULE);

2424:
2425:
2426: D_POSITION := 140 ;
2427: IF (PO_LOG.D_PROC) THEN
2428: PO_LOG.PROC_END(D_MODULE);
2429: END IF;
2430:
2431:
2432: EXCEPTION

Line 2481: IF (PO_LOG.D_PROC) THEN

2477:
2478: BEGIN
2479:
2480: D_POSITION := 0;
2481: IF (PO_LOG.D_PROC) THEN
2482: PO_LOG.PROC_BEGIN(D_MODULE,'1',1);
2483: END IF;
2484:
2485: x_return_status := C_RESULT_TYPE_SUCCESS;

Line 2482: PO_LOG.PROC_BEGIN(D_MODULE,'1',1);

2478: BEGIN
2479:
2480: D_POSITION := 0;
2481: IF (PO_LOG.D_PROC) THEN
2482: PO_LOG.PROC_BEGIN(D_MODULE,'1',1);
2483: END IF;
2484:
2485: x_return_status := C_RESULT_TYPE_SUCCESS;
2486:

Line 2570: IF (PO_LOG.d_proc) THEN

2566:
2567: BEGIN
2568:
2569: d_position := 0;
2570: IF (PO_LOG.d_proc) THEN
2571: PO_LOG.proc_begin(d_module,'1',1);
2572: END IF;
2573:
2574: SELECT index_num2

Line 2571: PO_LOG.proc_begin(d_module,'1',1);

2567: BEGIN
2568:
2569: d_position := 0;
2570: IF (PO_LOG.d_proc) THEN
2571: PO_LOG.proc_begin(d_module,'1',1);
2572: END IF;
2573:
2574: SELECT index_num2
2575: INTO l_draft_id

Line 2723: IF (PO_LOG.D_PROC) THEN

2719:
2720: BEGIN
2721:
2722: D_POSITION := 0;
2723: IF (PO_LOG.D_PROC) THEN
2724: PO_LOG.PROC_BEGIN(D_MODULE,'1',1);
2725: END IF;
2726:
2727: D_POSITION := 10;

Line 2724: PO_LOG.PROC_BEGIN(D_MODULE,'1',1);

2720: BEGIN
2721:
2722: D_POSITION := 0;
2723: IF (PO_LOG.D_PROC) THEN
2724: PO_LOG.PROC_BEGIN(D_MODULE,'1',1);
2725: END IF;
2726:
2727: D_POSITION := 10;
2728: DEBUG(D_MODULE, D_POSITION, 'CALLING VALIDATE_LINKED_DISTRIBUTIONS');

Line 2811: IF (PO_LOG.D_PROC) THEN

2807:
2808: END IF;
2809:
2810: D_POSITION := 60;
2811: IF (PO_LOG.D_PROC) THEN
2812: PO_LOG.PROC_END(D_MODULE);
2813: END IF;
2814:
2815: EXCEPTION

Line 2812: PO_LOG.PROC_END(D_MODULE);

2808: END IF;
2809:
2810: D_POSITION := 60;
2811: IF (PO_LOG.D_PROC) THEN
2812: PO_LOG.PROC_END(D_MODULE);
2813: END IF;
2814:
2815: EXCEPTION
2816: WHEN OTHERS THEN