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.IGIRMINP dependencies on STANDARD

Line 129: -- arp_standard.enable_debug;

125: p_total := 0;
126:
127: p_func_total := 0;
128:
129: -- arp_standard.enable_debug;
130:
131: /*-----------------------------------------------------------------------+
132: |Removed the 'WHERE' from the Parse Statement , It now comes in |
133: |p_where_clause before the actual where clause , This is done to take |

Line 137: arp_standard.debug('where clause:' || p_where_clause );

133: |p_where_clause before the actual where clause , This is done to take |
134: |care of the Null Where Clause Case. |
135: +-----------------------------------------------------------------------*/
136:
137: arp_standard.debug('where clause:' || p_where_clause );
138:
139: arp_standard.debug('Opening Cursor');
140:
141: l_select_cursor := dbms_sql.open_cursor;

Line 139: arp_standard.debug('Opening Cursor');

135: +-----------------------------------------------------------------------*/
136:
137: arp_standard.debug('where clause:' || p_where_clause );
138:
139: arp_standard.debug('Opening Cursor');
140:
141: l_select_cursor := dbms_sql.open_cursor;
142:
143: /*-----------------------------------------------------------------------+

Line 154: arp_standard.debug('Parsing statement ');

150:
151: /*-----------------------------------------------------------------------+
152: |Parse the built statement along with the where clause. |
153: +-----------------------------------------------------------------------*/
154: arp_standard.debug('Parsing statement ');
155: arp_standard.debug(l_out_where_clause);
156: --Bug 1563252 : modified the query string to add the from clause dynamically.
157: dbms_sql.parse(l_select_cursor,
158: 'select count( distinct invoice_currency_code ), sum(amount_due_remaining), sum(acctd_amount_due_remaining) from '||p_from_clause||' '||l_out_where_clause,

Line 155: arp_standard.debug(l_out_where_clause);

151: /*-----------------------------------------------------------------------+
152: |Parse the built statement along with the where clause. |
153: +-----------------------------------------------------------------------*/
154: arp_standard.debug('Parsing statement ');
155: arp_standard.debug(l_out_where_clause);
156: --Bug 1563252 : modified the query string to add the from clause dynamically.
157: dbms_sql.parse(l_select_cursor,
158: 'select count( distinct invoice_currency_code ), sum(amount_due_remaining), sum(acctd_amount_due_remaining) from '||p_from_clause||' '||l_out_where_clause,
159: dbms_sql.v7);

Line 164: arp_standard.debug('Defining Columns +');

160:
161: /*-----------------------------------------------------------------------+
162: |Define columns for the select statement. |
163: +-----------------------------------------------------------------------*/
164: arp_standard.debug('Defining Columns +');
165:
166: dbms_sql.define_column(l_select_cursor, 1 , l_count);
167: dbms_sql.define_column(l_select_cursor, 2 , l_amount);
168: dbms_sql.define_column(l_select_cursor, 3 , l_func_amount);

Line 170: arp_standard.debug('Defining Columns -');

166: dbms_sql.define_column(l_select_cursor, 1 , l_count);
167: dbms_sql.define_column(l_select_cursor, 2 , l_amount);
168: dbms_sql.define_column(l_select_cursor, 3 , l_func_amount);
169:
170: arp_standard.debug('Defining Columns -');
171:
172: /*-----------------------------------------------------------------------+
173: |Bind the variables built by Build_And_Bind routine with actual values |
174: +-----------------------------------------------------------------------*/

Line 177: arp_standard.debug('Binding Variables +');

173: |Bind the variables built by Build_And_Bind routine with actual values |
174: +-----------------------------------------------------------------------*/
175: IF ((l_literal_tbl.EXISTS(l_tbl_ctr)) AND (p_where_clause IS NOT NULL)) THEN
176:
177: arp_standard.debug('Binding Variables +');
178:
179: FOR l_ctr in 1..l_tbl_ctr LOOP
180:
181: l_actual_bind_var := '';

Line 184: arp_standard.debug('l_literal_tbl('||l_ctr||').bind_var_name = ' || l_literal_tbl(l_ctr).bind_var_name);

180:
181: l_actual_bind_var := '';
182:
183: --Bind variables
184: arp_standard.debug('l_literal_tbl('||l_ctr||').bind_var_name = ' || l_literal_tbl(l_ctr).bind_var_name);
185: arp_standard.debug('l_literal_tbl('||l_ctr||').stripped_value = ' || l_literal_tbl(l_ctr).stripped_value);
186:
187: l_actual_bind_var := rtrim(ltrim(l_literal_tbl(l_ctr).bind_var_name));
188:

Line 185: arp_standard.debug('l_literal_tbl('||l_ctr||').stripped_value = ' || l_literal_tbl(l_ctr).stripped_value);

181: l_actual_bind_var := '';
182:
183: --Bind variables
184: arp_standard.debug('l_literal_tbl('||l_ctr||').bind_var_name = ' || l_literal_tbl(l_ctr).bind_var_name);
185: arp_standard.debug('l_literal_tbl('||l_ctr||').stripped_value = ' || l_literal_tbl(l_ctr).stripped_value);
186:
187: l_actual_bind_var := rtrim(ltrim(l_literal_tbl(l_ctr).bind_var_name));
188:
189: arp_standard.debug('l_actual_bind_var = '||l_actual_bind_var);

Line 189: arp_standard.debug('l_actual_bind_var = '||l_actual_bind_var);

185: arp_standard.debug('l_literal_tbl('||l_ctr||').stripped_value = ' || l_literal_tbl(l_ctr).stripped_value);
186:
187: l_actual_bind_var := rtrim(ltrim(l_literal_tbl(l_ctr).bind_var_name));
188:
189: arp_standard.debug('l_actual_bind_var = '||l_actual_bind_var);
190:
191: dbms_sql.bind_variable(l_select_cursor, l_actual_bind_var, l_literal_tbl(l_ctr).stripped_value);
192:
193: END LOOP;

Line 195: arp_standard.debug('Binding Variables -');

191: dbms_sql.bind_variable(l_select_cursor, l_actual_bind_var, l_literal_tbl(l_ctr).stripped_value);
192:
193: END LOOP;
194:
195: arp_standard.debug('Binding Variables -');
196:
197: END IF;
198:
199: /*-----------------------------------------------------------------------+

Line 203: arp_standard.debug('Executing Statement +');

199: /*-----------------------------------------------------------------------+
200: |Execute the SQL statement to calculate functional amount and accounted |
201: |amount totals. |
202: +-----------------------------------------------------------------------*/
203: arp_standard.debug('Executing Statement +');
204:
205: l_ignore := dbms_sql.execute(l_select_cursor);
206:
207: arp_standard.debug('Executing Statement -');

Line 207: arp_standard.debug('Executing Statement -');

203: arp_standard.debug('Executing Statement +');
204:
205: l_ignore := dbms_sql.execute(l_select_cursor);
206:
207: arp_standard.debug('Executing Statement -');
208:
209: IF dbms_sql.fetch_rows(l_select_cursor) > 0 then
210:
211: /*-----------------------------------------------------------------------+

Line 214: arp_standard.debug('Fetching column values +');

210:
211: /*-----------------------------------------------------------------------+
212: |Fetch the column values, into actual variables |
213: +-----------------------------------------------------------------------*/
214: arp_standard.debug('Fetching column values +');
215:
216: dbms_sql.column_value(l_select_cursor, 1, l_count);
217: dbms_sql.column_value(l_select_cursor, 2, l_amount);
218: dbms_sql.column_value(l_select_cursor, 3, l_func_amount);

Line 220: arp_standard.debug('l_count '||l_count);

216: dbms_sql.column_value(l_select_cursor, 1, l_count);
217: dbms_sql.column_value(l_select_cursor, 2, l_amount);
218: dbms_sql.column_value(l_select_cursor, 3, l_func_amount);
219:
220: arp_standard.debug('l_count '||l_count);
221: arp_standard.debug('l_amount'||l_amount);
222: arp_standard.debug('l_func_amount'||l_func_amount);
223:
224: IF l_count = 1 THEN

Line 221: arp_standard.debug('l_amount'||l_amount);

217: dbms_sql.column_value(l_select_cursor, 2, l_amount);
218: dbms_sql.column_value(l_select_cursor, 3, l_func_amount);
219:
220: arp_standard.debug('l_count '||l_count);
221: arp_standard.debug('l_amount'||l_amount);
222: arp_standard.debug('l_func_amount'||l_func_amount);
223:
224: IF l_count = 1 THEN
225: p_total := l_amount;

Line 222: arp_standard.debug('l_func_amount'||l_func_amount);

218: dbms_sql.column_value(l_select_cursor, 3, l_func_amount);
219:
220: arp_standard.debug('l_count '||l_count);
221: arp_standard.debug('l_amount'||l_amount);
222: arp_standard.debug('l_func_amount'||l_func_amount);
223:
224: IF l_count = 1 THEN
225: p_total := l_amount;
226: ELSE

Line 232: arp_standard.debug('p_total '||p_total);

228: END IF;
229:
230: p_func_total := l_func_amount;
231:
232: arp_standard.debug('p_total '||p_total);
233: arp_standard.debug('p_func_total'||p_func_total);
234: arp_standard.debug('Fetching column values -');
235:
236: ELSE

Line 233: arp_standard.debug('p_func_total'||p_func_total);

229:
230: p_func_total := l_func_amount;
231:
232: arp_standard.debug('p_total '||p_total);
233: arp_standard.debug('p_func_total'||p_func_total);
234: arp_standard.debug('Fetching column values -');
235:
236: ELSE
237: arp_standard.debug('no rows');

Line 234: arp_standard.debug('Fetching column values -');

230: p_func_total := l_func_amount;
231:
232: arp_standard.debug('p_total '||p_total);
233: arp_standard.debug('p_func_total'||p_func_total);
234: arp_standard.debug('Fetching column values -');
235:
236: ELSE
237: arp_standard.debug('no rows');
238: END IF;

Line 237: arp_standard.debug('no rows');

233: arp_standard.debug('p_func_total'||p_func_total);
234: arp_standard.debug('Fetching column values -');
235:
236: ELSE
237: arp_standard.debug('no rows');
238: END IF;
239:
240: /*-----------------------------------------------------------------------+
241: |Finally close the cursor |

Line 243: arp_standard.debug('Closing Cursor');

239:
240: /*-----------------------------------------------------------------------+
241: |Finally close the cursor |
242: +-----------------------------------------------------------------------*/
243: arp_standard.debug('Closing Cursor');
244: dbms_sql.close_cursor(l_select_cursor);
245:
246: -- arp_standard.enable_debug;
247: EXCEPTION

Line 246: -- arp_standard.enable_debug;

242: +-----------------------------------------------------------------------*/
243: arp_standard.debug('Closing Cursor');
244: dbms_sql.close_cursor(l_select_cursor);
245:
246: -- arp_standard.enable_debug;
247: EXCEPTION
248: WHEN OTHERS THEN
249: arp_standard.debug( 'Exception:' );
250: END;

Line 249: arp_standard.debug( 'Exception:' );

245:
246: -- arp_standard.enable_debug;
247: EXCEPTION
248: WHEN OTHERS THEN
249: arp_standard.debug( 'Exception:' );
250: END;
251:
252:
253: /* ===============================================================================

Line 320: arp_standard.debug('l_in_where_clause ' || l_in_where_clause);

316: l_actual_length BINARY_INTEGER;
317:
318: BEGIN
319:
320: arp_standard.debug('l_in_where_clause ' || l_in_where_clause);
321:
322: l_in_where_clause := p_in_where_clause;
323:
324: /*---------------------------------------------------------------+

Line 420: arp_standard.debug('l_prev_cell = ' || l_prev_cell); --set values for numeric token

416: |of that situation. |
417: +---------------------------------------------------------------------------*/
418: IF (num_literal_on) AND l_prev_cell IN (',','.','+','-')THEN
419:
420: arp_standard.debug('l_prev_cell = ' || l_prev_cell); --set values for numeric token
421: l_literal_tbl(l_tbl_ctr).stripped_value := l_literal_tbl(l_tbl_ctr).stripped_value || l_prev_cell;
422: ELSE
423: l_actual_where_clause := l_actual_where_clause || l_prev_cell; --Build the previous cell
424: END IF;

Line 461: arp_standard.debug('l_temp_cell = ' || l_temp_cell); --set values

457: num_literal_on := FALSE; --end point
458: l_build_where := TRUE ; --set the flag so that the actual where clause can be built
459:
460: ELSE
461: arp_standard.debug('l_temp_cell = ' || l_temp_cell); --set values
462: l_literal_tbl(l_tbl_ctr).stripped_value := l_literal_tbl(l_tbl_ctr).stripped_value || l_temp_cell;
463:
464: END IF;
465:

Line 486: arp_standard.debug('l_actual_where_clause ' || l_actual_where_clause);

482: l_actual_where_clause := l_actual_where_clause || l_balance_clause;
483:
484: END IF; --end if by clause pos greater than 0
485:
486: arp_standard.debug('l_actual_where_clause ' || l_actual_where_clause);
487:
488: /*---------------------------------------------------------------------------+
489: |In debug mode dump the contents of the table, which helps bind variables |
490: +---------------------------------------------------------------------------*/

Line 493: arp_standard.debug('l_literal_tbl('||l_ctr||').literal_counter = '|| l_literal_tbl(l_ctr).literal_counter);

489: |In debug mode dump the contents of the table, which helps bind variables |
490: +---------------------------------------------------------------------------*/
491: FOR l_ctr in 1..l_tbl_ctr LOOP
492:
493: arp_standard.debug('l_literal_tbl('||l_ctr||').literal_counter = '|| l_literal_tbl(l_ctr).literal_counter);
494: arp_standard.debug('l_literal_tbl('||l_ctr||').bind_var_name = '|| l_literal_tbl(l_ctr).bind_var_name);
495: arp_standard.debug('l_literal_tbl('||l_ctr||').stripped_value = '|| l_literal_tbl(l_ctr).stripped_value);
496:
497: END LOOP; --end loop dump debug statements

Line 494: arp_standard.debug('l_literal_tbl('||l_ctr||').bind_var_name = '|| l_literal_tbl(l_ctr).bind_var_name);

490: +---------------------------------------------------------------------------*/
491: FOR l_ctr in 1..l_tbl_ctr LOOP
492:
493: arp_standard.debug('l_literal_tbl('||l_ctr||').literal_counter = '|| l_literal_tbl(l_ctr).literal_counter);
494: arp_standard.debug('l_literal_tbl('||l_ctr||').bind_var_name = '|| l_literal_tbl(l_ctr).bind_var_name);
495: arp_standard.debug('l_literal_tbl('||l_ctr||').stripped_value = '|| l_literal_tbl(l_ctr).stripped_value);
496:
497: END LOOP; --end loop dump debug statements
498:

Line 495: arp_standard.debug('l_literal_tbl('||l_ctr||').stripped_value = '|| l_literal_tbl(l_ctr).stripped_value);

491: FOR l_ctr in 1..l_tbl_ctr LOOP
492:
493: arp_standard.debug('l_literal_tbl('||l_ctr||').literal_counter = '|| l_literal_tbl(l_ctr).literal_counter);
494: arp_standard.debug('l_literal_tbl('||l_ctr||').bind_var_name = '|| l_literal_tbl(l_ctr).bind_var_name);
495: arp_standard.debug('l_literal_tbl('||l_ctr||').stripped_value = '|| l_literal_tbl(l_ctr).stripped_value);
496:
497: END LOOP; --end loop dump debug statements
498:
499: p_out_where_clause := l_actual_where_clause;

Line 507: arp_standard.debug( 'ARP_ARXCOQIT.Build_And_Bind Exception: OTHERS EXCEPTION');

503: p_tbl_ctr := l_tbl_ctr;
504:
505: EXCEPTION
506: WHEN OTHERS THEN
507: arp_standard.debug( 'ARP_ARXCOQIT.Build_And_Bind Exception: OTHERS EXCEPTION');
508: RAISE;
509:
510: END Build_And_Bind;
511: