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

Line 1: PACKAGE BODY PO_LOG AS

1: PACKAGE BODY PO_LOG AS
2: -- $Header: PO_LOG.plb 120.2.12020000.3 2013/02/11 00:35:42 vegajula ship $
3:
4: --
5: -- For more details on the PO logging strategy,

Line 2: -- $Header: PO_LOG.plb 120.2.12020000.3 2013/02/11 00:35:42 vegajula ship $

1: PACKAGE BODY PO_LOG AS
2: -- $Header: PO_LOG.plb 120.2.12020000.3 2013/02/11 00:35:42 vegajula ship $
3:
4: --
5: -- For more details on the PO logging strategy,
6: -- see the document at

Line 5: -- For more details on the PO logging strategy,

1: PACKAGE BODY PO_LOG AS
2: -- $Header: PO_LOG.plb 120.2.12020000.3 2013/02/11 00:35:42 vegajula ship $
3:
4: --
5: -- For more details on the PO logging strategy,
6: -- see the document at
7: -- /podev/po/internal/standards/logging/logging.xml
8: --
9:

Line 18: D_PACKAGE_BASE CONSTANT VARCHAR2(50) := PO_LOG.get_package_base('MY_PACKAGE');

14: ---------------------------
15:
16: CREATE OR REPLACE PACKAGE BODY MY_PACKAGE AS
17:
18: D_PACKAGE_BASE CONSTANT VARCHAR2(50) := PO_LOG.get_package_base('MY_PACKAGE');
19:
20: D_my_proc CONSTANT VARCHAR2(100) :=
21: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'my_proc');
22:

Line 21: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'my_proc');

17:
18: D_PACKAGE_BASE CONSTANT VARCHAR2(50) := PO_LOG.get_package_base('MY_PACKAGE');
19:
20: D_my_proc CONSTANT VARCHAR2(100) :=
21: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'my_proc');
22:
23: PROCEDURE my_proc(
24: p_in IN PO_TBL_NUMBER
25: , p_inout IN OUT NOCOPY NUMBER

Line 33: IF PO_LOG.d_proc THEN

29: d_mod CONSTANT VARCHAR2(100) := D_my_proc;
30: d_position NUMBER := 0;
31: BEGIN
32:
33: IF PO_LOG.d_proc THEN
34: PO_LOG.proc_begin(d_mod,'p_in',p_in);
35: PO_LOG.proc_begin(d_mod,'p_inout',p_inout);
36: END IF;
37:

Line 34: PO_LOG.proc_begin(d_mod,'p_in',p_in);

30: d_position NUMBER := 0;
31: BEGIN
32:
33: IF PO_LOG.d_proc THEN
34: PO_LOG.proc_begin(d_mod,'p_in',p_in);
35: PO_LOG.proc_begin(d_mod,'p_inout',p_inout);
36: END IF;
37:
38: d_position := 1;

Line 35: PO_LOG.proc_begin(d_mod,'p_inout',p_inout);

31: BEGIN
32:
33: IF PO_LOG.d_proc THEN
34: PO_LOG.proc_begin(d_mod,'p_in',p_in);
35: PO_LOG.proc_begin(d_mod,'p_inout',p_inout);
36: END IF;
37:
38: d_position := 1;
39:

Line 43: IF PO_LOG.d_stmt THEN

39:
40: -- do some stuff...
41:
42: d_position := 123;
43: IF PO_LOG.d_stmt THEN
44: PO_LOG.stmt(d_mod,d_position,'did some stuff');
45: END IF;
46:
47: -- do some more stuff...

Line 44: PO_LOG.stmt(d_mod,d_position,'did some stuff');

40: -- do some stuff...
41:
42: d_position := 123;
43: IF PO_LOG.d_stmt THEN
44: PO_LOG.stmt(d_mod,d_position,'did some stuff');
45: END IF;
46:
47: -- do some more stuff...
48:

Line 49: IF PO_LOG.d_proc THEN

45: END IF;
46:
47: -- do some more stuff...
48:
49: IF PO_LOG.d_proc THEN
50: PO_LOG.proc_end(d_mod,'p_inout',p_inout);
51: PO_LOG.proc_end(d_mod,'p_out',p_out);
52: END IF;
53:

Line 50: PO_LOG.proc_end(d_mod,'p_inout',p_inout);

46:
47: -- do some more stuff...
48:
49: IF PO_LOG.d_proc THEN
50: PO_LOG.proc_end(d_mod,'p_inout',p_inout);
51: PO_LOG.proc_end(d_mod,'p_out',p_out);
52: END IF;
53:
54: EXCEPTION

Line 51: PO_LOG.proc_end(d_mod,'p_out',p_out);

47: -- do some more stuff...
48:
49: IF PO_LOG.d_proc THEN
50: PO_LOG.proc_end(d_mod,'p_inout',p_inout);
51: PO_LOG.proc_end(d_mod,'p_out',p_out);
52: END IF;
53:
54: EXCEPTION
55: WHEN OTHERS THEN

Line 56: IF PO_LOG.d_exc THEN

52: END IF;
53:
54: EXCEPTION
55: WHEN OTHERS THEN
56: IF PO_LOG.d_exc THEN
57: PO_LOG.exc(d_mod,d_position,NULL);
58: END IF;
59: RAISE;
60:

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

53:
54: EXCEPTION
55: WHEN OTHERS THEN
56: IF PO_LOG.d_exc THEN
57: PO_LOG.exc(d_mod,d_position,NULL);
58: END IF;
59: RAISE;
60:
61: END my_proc;

Line 84: 1-STATEMENT - PO_LOG.stmt()

80:
81: Use of the different levels of logging statements should follow the
82: following guidelines:
83:
84: 1-STATEMENT - PO_LOG.stmt()
85:
86: Use STATEMENT-level for general debugging messages within the body
87: of a method / procedure.
88:

Line 92: 2-PROCEDURE - PO_LOG.proc_xxx()

88:
89: Dynamic SQL must be recorded with STATEMENT-level logging, as well
90: as all bind variables that are used while executing the SQL.
91:
92: 2-PROCEDURE - PO_LOG.proc_xxx()
93:
94: At the very beginning of every method/procedure, and immediately
95: before every exit point of the procedure (return statements, thrown
96: exceptions, normal "fall of the end"), PROCEDURE-level logs should

Line 109: 3-EVENT - PO_LOG.event()

105: called, again for each IN OUT or OUT parameter, return value, or just
106: for the module if it has none of these. Be sure to call these routines
107: before each RETURN or normal RAISE statement in the procedure/function.
108:
109: 3-EVENT - PO_LOG.event()
110:
111: At the beginning and end of a "flow", EVENT-level messages should be
112: logged. EVENT-level messages should be used at the beginning/end of
113: APIs, user-initiated actions (Form submits), concurrent requests,

Line 120: 4-EXCEPTION - PO_LOG.exc()

116: also be used to mark milestones within a larger flow, e.g. "document
117: locked", "validations completed", "document updated". EVENT-level
118: messages should surround all COMMITs, SAVEPOINTS, and ROLLBACKs.
119:
120: 4-EXCEPTION - PO_LOG.exc()
121:
122: An EXCEPTION-level message should be logged any time an "exception"
123: occurs in the code. In PL/SQL, such a message should be logged at
124: the beginning of every (EXCEPTION) WHEN xxx THEN block unless the

Line 206: PO_LOG.enable_logging('po.plsql.SBULL%,po.plsql.%ENCUMBRANCE%,po.plsql.PO_DOCUMENT_FUNDS%');

202: BEGIN
203:
204: FND_GLOBAL.APPS_INITIALIZE(1318, 50063, 201); -- operations, vision services, purchasing
205:
206: PO_LOG.enable_logging('po.plsql.SBULL%,po.plsql.%ENCUMBRANCE%,po.plsql.PO_DOCUMENT_FUNDS%');
207:
208: d_mod := PO_LOG.get_subprogram_base(PO_LOG.get_package_base('SBULL'),'TEST');
209:
210: PO_LOG.proc_begin(d_mod);

Line 208: d_mod := PO_LOG.get_subprogram_base(PO_LOG.get_package_base('SBULL'),'TEST');

204: FND_GLOBAL.APPS_INITIALIZE(1318, 50063, 201); -- operations, vision services, purchasing
205:
206: PO_LOG.enable_logging('po.plsql.SBULL%,po.plsql.%ENCUMBRANCE%,po.plsql.PO_DOCUMENT_FUNDS%');
207:
208: d_mod := PO_LOG.get_subprogram_base(PO_LOG.get_package_base('SBULL'),'TEST');
209:
210: PO_LOG.proc_begin(d_mod);
211:
212: PO_DOCUMENT_FUNDS_PVT.do_unreserve(

Line 210: PO_LOG.proc_begin(d_mod);

206: PO_LOG.enable_logging('po.plsql.SBULL%,po.plsql.%ENCUMBRANCE%,po.plsql.PO_DOCUMENT_FUNDS%');
207:
208: d_mod := PO_LOG.get_subprogram_base(PO_LOG.get_package_base('SBULL'),'TEST');
209:
210: PO_LOG.proc_begin(d_mod);
211:
212: PO_DOCUMENT_FUNDS_PVT.do_unreserve(
213: x_return_status => l_return_status
214: , p_doc_type => PO_DOCUMENT_FUNDS_PVT.g_doc_type_PO

Line 228: PO_LOG.proc_end(d_mod);

224: , x_po_return_code => l_po_return_code
225: , x_online_report_id => l_online_report_id
226: );
227:
228: PO_LOG.proc_end(d_mod);
229:
230: END;
231:
232:

Line 302: D_PACKAGE_BASE CONSTANT VARCHAR2(50) := get_package_base('PO_LOG');

298: -- Modules for debugging.
299: ---------------------------------------------------------------------------
300:
301: -- The module base for this package.
302: D_PACKAGE_BASE CONSTANT VARCHAR2(50) := get_package_base('PO_LOG');
303:
304: -- The module base for the subprogram.
305: D_MOD_refresh_log_flags CONSTANT VARCHAR2(100) :=
306: get_subprogram_base(D_PACKAGE_BASE,'refresh_log_flags');

Line 431: --p_package_name The name of the package, for example, "PO_LOG".

427: -- Appends the package name to the PL/SQL base module and adds
428: -- module separators.
429: --Parameters:
430: --IN:
431: --p_package_name The name of the package, for example, "PO_LOG".
432: --Returns:
433: -- A string appropriate for passing into get_subprogram_base().
434: -- VARCHAR2(50).
435: --End of Comments

Line 1046: update_po_log_tbl po_tbl_number;

1042: , p_position IN NUMBER
1043: , p_record_identifier IN VARCHAR2
1044: )
1045: IS
1046: update_po_log_tbl po_tbl_number;
1047: BEGIN
1048:
1049: update_po_log_tbl:=po_tbl_number();
1050:

Line 1049: update_po_log_tbl:=po_tbl_number();

1045: IS
1046: update_po_log_tbl po_tbl_number;
1047: BEGIN
1048:
1049: update_po_log_tbl:=po_tbl_number();
1050:
1051: SELECT psgt.key
1052: BULK COLLECT INTO update_po_log_tbl
1053: FROM po_session_gt psgt

Line 1052: BULK COLLECT INTO update_po_log_tbl

1048:
1049: update_po_log_tbl:=po_tbl_number();
1050:
1051: SELECT psgt.key
1052: BULK COLLECT INTO update_po_log_tbl
1053: FROM po_session_gt psgt
1054: WHERE psgt.index_char1=p_record_identifier ;
1055:
1056:

Line 1057: FOR i in 1..update_po_log_tbl.COUNT LOOP

1053: FROM po_session_gt psgt
1054: WHERE psgt.index_char1=p_record_identifier ;
1055:
1056:
1057: FOR i in 1..update_po_log_tbl.COUNT LOOP
1058: stmt_session_gt( p_module_base => p_module_base,
1059: p_position => p_position ,
1060: p_key => update_po_log_tbl(i));
1061: END LOOP;

Line 1060: p_key => update_po_log_tbl(i));

1056:
1057: FOR i in 1..update_po_log_tbl.COUNT LOOP
1058: stmt_session_gt( p_module_base => p_module_base,
1059: p_position => p_position ,
1060: p_key => update_po_log_tbl(i));
1061: END LOOP;
1062:
1063: END stmt_all_session_gt;
1064:

Line 1807: END PO_LOG;

1803: BEGIN
1804:
1805: refresh_log_flags();
1806:
1807: END PO_LOG;