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_DRAFT_EVENTS_PKG dependencies on PO_DEBUG

Line 13: g_debug_stmt BOOLEAN := PO_DEBUG.is_debug_stmt_on;

9: VARCHAR2(50)
10: := 'po.plsql.' || g_pkg_name || '.';
11:
12:
13: g_debug_stmt BOOLEAN := PO_DEBUG.is_debug_stmt_on;
14: g_debug_unexp BOOLEAN := PO_DEBUG.is_debug_unexp_on;
15:
16:
17: -------------------------------------------------------------------------------

Line 14: g_debug_unexp BOOLEAN := PO_DEBUG.is_debug_unexp_on;

10: := 'po.plsql.' || g_pkg_name || '.';
11:
12:
13: g_debug_stmt BOOLEAN := PO_DEBUG.is_debug_stmt_on;
14: g_debug_unexp BOOLEAN := PO_DEBUG.is_debug_unexp_on;
15:
16:
17: -------------------------------------------------------------------------------
18: --Start of Comments

Line 106: PO_DEBUG.debug_begin(l_log_head);

102: l_progress := '000';
103:
104: IF g_debug_stmt THEN
105:
106: PO_DEBUG.debug_begin(l_log_head);
107: PO_DEBUG.debug_var(l_log_head,l_progress,'p_ledger_id',p_ledger_id);
108: PO_DEBUG.debug_var(l_log_head,l_progress,'p_start_date',p_start_date);
109: PO_DEBUG.debug_var(l_log_head,l_progress,'p_end_date',p_end_date);
110: PO_DEBUG.debug_var(l_log_head,l_progress,'p_calling_sequence',p_calling_sequence);

Line 107: PO_DEBUG.debug_var(l_log_head,l_progress,'p_ledger_id',p_ledger_id);

103:
104: IF g_debug_stmt THEN
105:
106: PO_DEBUG.debug_begin(l_log_head);
107: PO_DEBUG.debug_var(l_log_head,l_progress,'p_ledger_id',p_ledger_id);
108: PO_DEBUG.debug_var(l_log_head,l_progress,'p_start_date',p_start_date);
109: PO_DEBUG.debug_var(l_log_head,l_progress,'p_end_date',p_end_date);
110: PO_DEBUG.debug_var(l_log_head,l_progress,'p_calling_sequence',p_calling_sequence);
111:

Line 108: PO_DEBUG.debug_var(l_log_head,l_progress,'p_start_date',p_start_date);

104: IF g_debug_stmt THEN
105:
106: PO_DEBUG.debug_begin(l_log_head);
107: PO_DEBUG.debug_var(l_log_head,l_progress,'p_ledger_id',p_ledger_id);
108: PO_DEBUG.debug_var(l_log_head,l_progress,'p_start_date',p_start_date);
109: PO_DEBUG.debug_var(l_log_head,l_progress,'p_end_date',p_end_date);
110: PO_DEBUG.debug_var(l_log_head,l_progress,'p_calling_sequence',p_calling_sequence);
111:
112: END IF;

Line 109: PO_DEBUG.debug_var(l_log_head,l_progress,'p_end_date',p_end_date);

105:
106: PO_DEBUG.debug_begin(l_log_head);
107: PO_DEBUG.debug_var(l_log_head,l_progress,'p_ledger_id',p_ledger_id);
108: PO_DEBUG.debug_var(l_log_head,l_progress,'p_start_date',p_start_date);
109: PO_DEBUG.debug_var(l_log_head,l_progress,'p_end_date',p_end_date);
110: PO_DEBUG.debug_var(l_log_head,l_progress,'p_calling_sequence',p_calling_sequence);
111:
112: END IF;
113:

Line 110: PO_DEBUG.debug_var(l_log_head,l_progress,'p_calling_sequence',p_calling_sequence);

106: PO_DEBUG.debug_begin(l_log_head);
107: PO_DEBUG.debug_var(l_log_head,l_progress,'p_ledger_id',p_ledger_id);
108: PO_DEBUG.debug_var(l_log_head,l_progress,'p_start_date',p_start_date);
109: PO_DEBUG.debug_var(l_log_head,l_progress,'p_end_date',p_end_date);
110: PO_DEBUG.debug_var(l_log_head,l_progress,'p_calling_sequence',p_calling_sequence);
111:
112: END IF;
113:
114: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN

Line 127: PO_DEBUG.debug_stmt(l_log_head,l_progress,'# Rows deleted from xla_events_int_gt'|| SQL%ROWCOUNT );

123:
124: DELETE FROM XLA_EVENTS_INT_GT;
125:
126: IF g_debug_stmt THEN
127: PO_DEBUG.debug_stmt(l_log_head,l_progress,'# Rows deleted from xla_events_int_gt'|| SQL%ROWCOUNT );
128: END IF;
129:
130: l_progress := '002';
131:

Line 156: PO_DEBUG.debug_stmt(l_log_head,l_progress,'#Rows inserted into xla_events_int_gt table:' || l_event_count);

152: INSERT INTO XLA_EVENTS_INT_GT
153: VALUES l_events_tab(i) ;
154:
155: IF g_debug_stmt THEN
156: PO_DEBUG.debug_stmt(l_log_head,l_progress,'#Rows inserted into xla_events_int_gt table:' || l_event_count);
157: END IF;
158:
159: END IF;
160:

Line 164: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Calling XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENT ');

160:
161: l_progress := '004';
162:
163: IF g_debug_stmt THEN
164: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Calling XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENT ');
165: END IF;
166:
167: XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENTS(p_application_id => 201);
168:

Line 170: PO_DEBUG.debug_stmt(l_log_head,l_progress,'After Deletion of Unprocessed Events');

166:
167: XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENTS(p_application_id => 201);
168:
169: IF g_debug_stmt THEN
170: PO_DEBUG.debug_stmt(l_log_head,l_progress,'After Deletion of Unprocessed Events');
171: END IF;
172:
173: fnd_file.put_line(fnd_file.log ,'The following BC unprocessed/Error events have been deleted');
174: fnd_file.put_line(fnd_file.log ,'Event_id Event_status_code Process_status_code');

Line 189: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Deleting the events from po_bc_distributions');

185:
186: l_progress := '005';
187:
188: IF g_debug_stmt THEN
189: PO_DEBUG.debug_stmt(l_log_head,l_progress,'Deleting the events from po_bc_distributions');
190: END IF;
191: -- Bug 14832613: Removed the FORALL statement and included this in the FOR LOOP above
192: -- as FORALL Does not support usage of variable of record type for db versions less than 11g.
193:

Line 202: PO_DEBUG.debug_end(l_log_head);

198:
199: x_return_status := Fnd_Api.G_Ret_Sts_Success;
200:
201: IF g_debug_stmt THEN
202: PO_DEBUG.debug_end(l_log_head);
203: END IF;
204:
205: EXCEPTION
206: WHEN OTHERS THEN

Line 209: PO_DEBUG.debug_exc(l_log_head,l_progress);

205: EXCEPTION
206: WHEN OTHERS THEN
207:
208: IF g_debug_unexp THEN
209: PO_DEBUG.debug_exc(l_log_head,l_progress);
210: END IF;
211:
212: x_return_status := Fnd_Api.G_Ret_Sts_Error;
213:

Line 215: FND_MESSAGE.SET_NAME('SQLAP','PO_DEBUG');

211:
212: x_return_status := Fnd_Api.G_Ret_Sts_Error;
213:
214: IF (SQLCODE <> -20001) THEN
215: FND_MESSAGE.SET_NAME('SQLAP','PO_DEBUG');
216: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
217: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_curr_calling_sequence);
218: END IF;
219: