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

Line 40: -- arp_standard.enable_debug;

36: l_ignore integer;
37: l_amount number;
38: l_cur_count number; /* 1806931 */
39: begin
40: -- arp_standard.enable_debug;
41: IF PG_DEBUG in ('Y', 'C') THEN
42: arp_standard.debug('Build_And_Bind: ' || 'where clause:' || p_where_clause );
43: END IF;
44: /* 1806931 Code Added Begins. */

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

38: l_cur_count number; /* 1806931 */
39: begin
40: -- arp_standard.enable_debug;
41: IF PG_DEBUG in ('Y', 'C') THEN
42: arp_standard.debug('Build_And_Bind: ' || 'where clause:' || p_where_clause );
43: END IF;
44: /* 1806931 Code Added Begins. */
45: /* Bugfix for 2112098 Check if the where clause passed has a payment_schedule_id=.
46: If yes, then split the where-clause to make use of bind variable.

Line 61: arp_standard.debug('Build_And_Bind: ' || 'no rows');

57: if dbms_sql.fetch_rows(l_select_cursor) > 0 then
58: dbms_sql.column_value(l_select_cursor, 1, l_cur_count);
59: else
60: IF PG_DEBUG in ('Y', 'C') THEN
61: arp_standard.debug('Build_And_Bind: ' || 'no rows');
62: END IF;
63: end if;
64: if (l_cur_count = 1) then
65: dbms_sql.close_cursor(l_select_cursor);

Line 78: arp_standard.debug('Build_And_Bind: ' || 'no rows');

74: if dbms_sql.fetch_rows(l_select_cursor) > 0 then
75: dbms_sql.column_value(l_select_cursor, 1, l_amount);
76: else
77: IF PG_DEBUG in ('Y', 'C') THEN
78: arp_standard.debug('Build_And_Bind: ' || 'no rows');
79: END IF;
80: end if;
81:
82: p_total := l_amount;

Line 84: arp_standard.debug('Build_And_Bind: ' || 'p_total =' || to_char(p_total) );

80: end if;
81:
82: p_total := l_amount;
83: IF PG_DEBUG in ('Y', 'C') THEN
84: arp_standard.debug('Build_And_Bind: ' || 'p_total =' || to_char(p_total) );
85: arp_standard.debug('Build_And_Bind: ' || 'l_amount =' || to_char(l_amount) );
86: END IF;
87: dbms_sql.close_cursor(l_select_cursor);
88:

Line 85: arp_standard.debug('Build_And_Bind: ' || 'l_amount =' || to_char(l_amount) );

81:
82: p_total := l_amount;
83: IF PG_DEBUG in ('Y', 'C') THEN
84: arp_standard.debug('Build_And_Bind: ' || 'p_total =' || to_char(p_total) );
85: arp_standard.debug('Build_And_Bind: ' || 'l_amount =' || to_char(l_amount) );
86: END IF;
87: dbms_sql.close_cursor(l_select_cursor);
88:
89: /*1806931 Code Added Begins */

Line 93: arp_standard.debug('Build_And_Bind: ' || 'p_total =' || to_char(p_total) );

89: /*1806931 Code Added Begins */
90: else
91: p_total := 0;
92: IF PG_DEBUG in ('Y', 'C') THEN
93: arp_standard.debug('Build_And_Bind: ' || 'p_total =' || to_char(p_total) );
94: END IF;
95: dbms_sql.close_cursor(l_select_cursor);
96: end if;
97: /* 1806931 Code Added Ends */

Line 126: arp_standard.debug('Build_And_Bind: ' || 'no rows');

122: if dbms_sql.fetch_rows(l_select_cursor) > 0 then
123: dbms_sql.column_value(l_select_cursor, 1, l_cur_count);
124: else
125: IF PG_DEBUG in ('Y', 'C') THEN
126: arp_standard.debug('Build_And_Bind: ' || 'no rows');
127: END IF;
128: end if;
129: if (l_cur_count = 1) then
130: dbms_sql.close_cursor(l_select_cursor);

Line 135: arp_standard.debug('Build_And_Bind: ' || l_select_stmt);

131:
132: l_select_stmt := 'select sum(total_amount) from ar_app_adj_v
133: where PAYMENT_SCHEDULE_ID= :ps_id ';
134: IF PG_DEBUG in ('Y', 'C') THEN
135: arp_standard.debug('Build_And_Bind: ' || l_select_stmt);
136: END IF;
137:
138: l_select_cursor := dbms_sql.open_cursor;
139:

Line 150: arp_standard.debug('Build_And_Bind: ' || 'no rows');

146: if dbms_sql.fetch_rows(l_select_cursor) > 0 then
147: dbms_sql.column_value(l_select_cursor, 1, l_amount);
148: else
149: IF PG_DEBUG in ('Y', 'C') THEN
150: arp_standard.debug('Build_And_Bind: ' || 'no rows');
151: END IF;
152: end if;
153:
154: p_total := l_amount;

Line 156: arp_standard.debug('Build_And_Bind: ' || 'p_total =' || to_char(p_total) );

152: end if;
153:
154: p_total := l_amount;
155: IF PG_DEBUG in ('Y', 'C') THEN
156: arp_standard.debug('Build_And_Bind: ' || 'p_total =' || to_char(p_total) );
157: arp_standard.debug('Build_And_Bind: ' || 'l_amount =' || to_char(l_amount) );
158: END IF;
159: dbms_sql.close_cursor(l_select_cursor);
160: else

Line 157: arp_standard.debug('Build_And_Bind: ' || 'l_amount =' || to_char(l_amount) );

153:
154: p_total := l_amount;
155: IF PG_DEBUG in ('Y', 'C') THEN
156: arp_standard.debug('Build_And_Bind: ' || 'p_total =' || to_char(p_total) );
157: arp_standard.debug('Build_And_Bind: ' || 'l_amount =' || to_char(l_amount) );
158: END IF;
159: dbms_sql.close_cursor(l_select_cursor);
160: else
161: p_total := 0;

Line 163: arp_standard.debug('Build_And_Bind: ' || 'p_total =' || to_char(p_total) );

159: dbms_sql.close_cursor(l_select_cursor);
160: else
161: p_total := 0;
162: IF PG_DEBUG in ('Y', 'C') THEN
163: arp_standard.debug('Build_And_Bind: ' || 'p_total =' || to_char(p_total) );
164: END IF;
165: dbms_sql.close_cursor(l_select_cursor);
166: end if;
167: END;

Line 171: -- arp_standard.enable_debug;

167: END;
168: END IF;
169: /* End of bugfix 2112438 */
170:
171: -- arp_standard.enable_debug;
172: EXCEPTION
173: WHEN OTHERS THEN
174: IF PG_DEBUG in ('Y', 'C') THEN
175: arp_standard.debug('Build_And_Bind: ' || 'Exception:'|| to_char(p_total));

Line 175: arp_standard.debug('Build_And_Bind: ' || 'Exception:'|| to_char(p_total));

171: -- arp_standard.enable_debug;
172: EXCEPTION
173: WHEN OTHERS THEN
174: IF PG_DEBUG in ('Y', 'C') THEN
175: arp_standard.debug('Build_And_Bind: ' || 'Exception:'|| to_char(p_total));
176: END IF;
177: end;
178:
179: -- Bug No. : 950002 : Removed folder_total and folder_func_total as these are included in fold_total.

Line 219: -- arp_standard.enable_debug;

215: p_total := 0;
216:
217: p_func_total := 0;
218:
219: -- arp_standard.enable_debug;
220:
221: /*-----------------------------------------------------------------------+
222: |Removed the 'WHERE' from the Parse Statement , It now comes in |
223: |p_where_clause before the actual where clause , This is done to take |

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

224: |care of the Null Where Clause Case. |
225: +-----------------------------------------------------------------------*/
226:
227: IF PG_DEBUG in ('Y', 'C') THEN
228: arp_standard.debug('Build_And_Bind: ' || 'where clause:' || p_where_clause );
229: arp_standard.debug('Build_And_Bind: ' || 'Opening Cursor');
230: END IF;
231:
232: l_select_cursor := dbms_sql.open_cursor;

Line 229: arp_standard.debug('Build_And_Bind: ' || 'Opening Cursor');

225: +-----------------------------------------------------------------------*/
226:
227: IF PG_DEBUG in ('Y', 'C') THEN
228: arp_standard.debug('Build_And_Bind: ' || 'where clause:' || p_where_clause );
229: arp_standard.debug('Build_And_Bind: ' || 'Opening Cursor');
230: END IF;
231:
232: l_select_cursor := dbms_sql.open_cursor;
233:

Line 244: arp_standard.debug('l_quote1 = ' || to_char(l_quote1) ||

240: -- Bug 3804333 : need to pre-process p_where_clause to check if trx_number has '
241: l_quote1 := instr(p_where_clause,'''',1,2);
242: l_quote2 := instr(p_where_clause,'''',l_quote1+1,1);
243: IF PG_DEBUG in ('Y', 'C') THEN
244: arp_standard.debug('l_quote1 = ' || to_char(l_quote1) ||
245: ' l_quote2 = ' || to_char(l_quote2));
246: END IF;
247: if l_quote2 - l_quote1 = 1 then
248: -- trx_number has embedded ', temporarily change ' to ^

Line 252: arp_standard.debug('l_where_clause = ' || l_where_clause);

248: -- trx_number has embedded ', temporarily change ' to ^
249: l_where_clause := substrb(p_where_clause,1,l_quote1-1) ||
250: '^' || substrb(p_where_clause, l_quote2+1);
251: emb_quote := TRUE;
252: arp_standard.debug('l_where_clause = ' || l_where_clause);
253: else
254: l_where_clause := p_where_clause;
255: end if;
256:

Line 264: arp_standard.debug('Build_And_Bind: ' || 'Parsing statement ');

260: /*-----------------------------------------------------------------------+
261: |Parse the built statement along with the where clause. |
262: +-----------------------------------------------------------------------*/
263: IF PG_DEBUG in ('Y', 'C') THEN
264: arp_standard.debug('Build_And_Bind: ' || 'Parsing statement ');
265: arp_standard.debug('Build_And_Bind: ' || l_out_where_clause);
266: END IF;
267: --Bug 1563252 : modified the query string to add the from clause dynamically.
268:

Line 265: arp_standard.debug('Build_And_Bind: ' || l_out_where_clause);

261: |Parse the built statement along with the where clause. |
262: +-----------------------------------------------------------------------*/
263: IF PG_DEBUG in ('Y', 'C') THEN
264: arp_standard.debug('Build_And_Bind: ' || 'Parsing statement ');
265: arp_standard.debug('Build_And_Bind: ' || l_out_where_clause);
266: END IF;
267: --Bug 1563252 : modified the query string to add the from clause dynamically.
268:
269: /* 3988361 :If the customer_id is used for selection the use n6 index */

Line 291: arp_standard.debug('Build_And_Bind: ' || 'Defining Columns +');

287: /*-----------------------------------------------------------------------+
288: |Define columns for the select statement. |
289: +-----------------------------------------------------------------------*/
290: IF PG_DEBUG in ('Y', 'C') THEN
291: arp_standard.debug('Build_And_Bind: ' || 'Defining Columns +');
292: END IF;
293:
294: dbms_sql.define_column(l_select_cursor, 1 , l_count);
295: dbms_sql.define_column(l_select_cursor, 2 , l_amount);

Line 299: arp_standard.debug('Build_And_Bind: ' || 'Defining Columns -');

295: dbms_sql.define_column(l_select_cursor, 2 , l_amount);
296: dbms_sql.define_column(l_select_cursor, 3 , l_func_amount);
297:
298: IF PG_DEBUG in ('Y', 'C') THEN
299: arp_standard.debug('Build_And_Bind: ' || 'Defining Columns -');
300: END IF;
301:
302: /*-----------------------------------------------------------------------+
303: |Bind the variables built by Build_And_Bind routine with actual values |

Line 308: arp_standard.debug('Build_And_Bind: ' || 'Binding Variables +');

304: +-----------------------------------------------------------------------*/
305: IF ((l_literal_tbl.EXISTS(l_tbl_ctr)) AND (p_where_clause IS NOT NULL)) THEN
306:
307: IF PG_DEBUG in ('Y', 'C') THEN
308: arp_standard.debug('Build_And_Bind: ' || 'Binding Variables +');
309: END IF;
310:
311: FOR l_ctr in 1..l_tbl_ctr LOOP
312:

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

313: l_actual_bind_var := '';
314:
315: --Bind variables
316: IF PG_DEBUG in ('Y', 'C') THEN
317: arp_standard.debug('Build_And_Bind: ' || 'l_literal_tbl('||l_ctr||').bind_var_name = ' || l_literal_tbl(l_ctr).bind_var_name);
318: arp_standard.debug('Build_And_Bind: ' || 'l_literal_tbl('||l_ctr||').stripped_value = ' || l_literal_tbl(l_ctr).stripped_value);
319: END IF;
320:
321: l_actual_bind_var := rtrim(ltrim(l_literal_tbl(l_ctr).bind_var_name));

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

314:
315: --Bind variables
316: IF PG_DEBUG in ('Y', 'C') THEN
317: arp_standard.debug('Build_And_Bind: ' || 'l_literal_tbl('||l_ctr||').bind_var_name = ' || l_literal_tbl(l_ctr).bind_var_name);
318: arp_standard.debug('Build_And_Bind: ' || 'l_literal_tbl('||l_ctr||').stripped_value = ' || l_literal_tbl(l_ctr).stripped_value);
319: END IF;
320:
321: l_actual_bind_var := rtrim(ltrim(l_literal_tbl(l_ctr).bind_var_name));
322:

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

320:
321: l_actual_bind_var := rtrim(ltrim(l_literal_tbl(l_ctr).bind_var_name));
322:
323: IF PG_DEBUG in ('Y', 'C') THEN
324: arp_standard.debug('Build_And_Bind: ' || 'l_actual_bind_var = '||l_actual_bind_var);
325: END IF;
326:
327: dbms_sql.bind_variable(l_select_cursor, l_actual_bind_var, l_literal_tbl(l_ctr).stripped_value);
328:

Line 332: arp_standard.debug('Build_And_Bind: ' || 'Binding Variables -');

328:
329: END LOOP;
330:
331: IF PG_DEBUG in ('Y', 'C') THEN
332: arp_standard.debug('Build_And_Bind: ' || 'Binding Variables -');
333: END IF;
334:
335: END IF;
336:

Line 342: arp_standard.debug('Build_And_Bind: ' || 'Executing Statement +');

338: |Execute the SQL statement to calculate functional amount and accounted |
339: |amount totals. |
340: +-----------------------------------------------------------------------*/
341: IF PG_DEBUG in ('Y', 'C') THEN
342: arp_standard.debug('Build_And_Bind: ' || 'Executing Statement +');
343: END IF;
344:
345: l_ignore := dbms_sql.execute(l_select_cursor);
346:

Line 348: arp_standard.debug('Build_And_Bind: ' || 'Executing Statement -');

344:
345: l_ignore := dbms_sql.execute(l_select_cursor);
346:
347: IF PG_DEBUG in ('Y', 'C') THEN
348: arp_standard.debug('Build_And_Bind: ' || 'Executing Statement -');
349: END IF;
350:
351: IF dbms_sql.fetch_rows(l_select_cursor) > 0 then
352:

Line 357: arp_standard.debug('Build_And_Bind: ' || 'Fetching column values +');

353: /*-----------------------------------------------------------------------+
354: |Fetch the column values, into actual variables |
355: +-----------------------------------------------------------------------*/
356: IF PG_DEBUG in ('Y', 'C') THEN
357: arp_standard.debug('Build_And_Bind: ' || 'Fetching column values +');
358: END IF;
359:
360: dbms_sql.column_value(l_select_cursor, 1, l_count);
361: dbms_sql.column_value(l_select_cursor, 2, l_amount);

Line 365: arp_standard.debug('Build_And_Bind: ' || 'l_count '||l_count);

361: dbms_sql.column_value(l_select_cursor, 2, l_amount);
362: dbms_sql.column_value(l_select_cursor, 3, l_func_amount);
363:
364: IF PG_DEBUG in ('Y', 'C') THEN
365: arp_standard.debug('Build_And_Bind: ' || 'l_count '||l_count);
366: arp_standard.debug('Build_And_Bind: ' || 'l_amount'||l_amount);
367: arp_standard.debug('Build_And_Bind: ' || 'l_func_amount'||l_func_amount);
368: END IF;
369:

Line 366: arp_standard.debug('Build_And_Bind: ' || 'l_amount'||l_amount);

362: dbms_sql.column_value(l_select_cursor, 3, l_func_amount);
363:
364: IF PG_DEBUG in ('Y', 'C') THEN
365: arp_standard.debug('Build_And_Bind: ' || 'l_count '||l_count);
366: arp_standard.debug('Build_And_Bind: ' || 'l_amount'||l_amount);
367: arp_standard.debug('Build_And_Bind: ' || 'l_func_amount'||l_func_amount);
368: END IF;
369:
370: IF l_count = 1 THEN

Line 367: arp_standard.debug('Build_And_Bind: ' || 'l_func_amount'||l_func_amount);

363:
364: IF PG_DEBUG in ('Y', 'C') THEN
365: arp_standard.debug('Build_And_Bind: ' || 'l_count '||l_count);
366: arp_standard.debug('Build_And_Bind: ' || 'l_amount'||l_amount);
367: arp_standard.debug('Build_And_Bind: ' || 'l_func_amount'||l_func_amount);
368: END IF;
369:
370: IF l_count = 1 THEN
371: p_total := l_amount;

Line 380: arp_standard.debug('Build_And_Bind: ' || 'p_total '||p_total);

376: p_cur_count := l_count;
377: p_func_total := l_func_amount;
378:
379: IF PG_DEBUG in ('Y', 'C') THEN
380: arp_standard.debug('Build_And_Bind: ' || 'p_total '||p_total);
381: arp_standard.debug('Build_And_Bind: ' || 'p_func_total'||p_func_total);
382: arp_standard.debug('Build_And_Bind: ' || 'Fetching column values -');
383: END IF;
384:

Line 381: arp_standard.debug('Build_And_Bind: ' || 'p_func_total'||p_func_total);

377: p_func_total := l_func_amount;
378:
379: IF PG_DEBUG in ('Y', 'C') THEN
380: arp_standard.debug('Build_And_Bind: ' || 'p_total '||p_total);
381: arp_standard.debug('Build_And_Bind: ' || 'p_func_total'||p_func_total);
382: arp_standard.debug('Build_And_Bind: ' || 'Fetching column values -');
383: END IF;
384:
385: ELSE

Line 382: arp_standard.debug('Build_And_Bind: ' || 'Fetching column values -');

378:
379: IF PG_DEBUG in ('Y', 'C') THEN
380: arp_standard.debug('Build_And_Bind: ' || 'p_total '||p_total);
381: arp_standard.debug('Build_And_Bind: ' || 'p_func_total'||p_func_total);
382: arp_standard.debug('Build_And_Bind: ' || 'Fetching column values -');
383: END IF;
384:
385: ELSE
386: IF PG_DEBUG in ('Y', 'C') THEN

Line 387: arp_standard.debug('Build_And_Bind: ' || 'no rows');

383: END IF;
384:
385: ELSE
386: IF PG_DEBUG in ('Y', 'C') THEN
387: arp_standard.debug('Build_And_Bind: ' || 'no rows');
388: END IF;
389: END IF;
390:
391: /*-----------------------------------------------------------------------+

Line 395: arp_standard.debug('Build_And_Bind: ' || 'Closing Cursor');

391: /*-----------------------------------------------------------------------+
392: |Finally close the cursor |
393: +-----------------------------------------------------------------------*/
394: IF PG_DEBUG in ('Y', 'C') THEN
395: arp_standard.debug('Build_And_Bind: ' || 'Closing Cursor');
396: END IF;
397: dbms_sql.close_cursor(l_select_cursor);
398:
399: -- arp_standard.enable_debug;

Line 399: -- arp_standard.enable_debug;

395: arp_standard.debug('Build_And_Bind: ' || 'Closing Cursor');
396: END IF;
397: dbms_sql.close_cursor(l_select_cursor);
398:
399: -- arp_standard.enable_debug;
400: EXCEPTION
401: WHEN OTHERS THEN
402: IF PG_DEBUG in ('Y', 'C') THEN
403: arp_standard.debug('Build_And_Bind: ' || 'Exception:' );

Line 403: arp_standard.debug('Build_And_Bind: ' || 'Exception:' );

399: -- arp_standard.enable_debug;
400: EXCEPTION
401: WHEN OTHERS THEN
402: IF PG_DEBUG in ('Y', 'C') THEN
403: arp_standard.debug('Build_And_Bind: ' || 'Exception:' );
404: END IF;
405: END;
406:
407: -- Bug 2089289

Line 425: -- arp_standard.enable_debug;

421:
422: l_out_where_clause := '';
423: l_currency_code := '';
424:
425: -- arp_standard.enable_debug;
426:
427: /*-----------------------------------------------------------------------+
428: |Removed the 'WHERE' from the Parse Statement , It now comes in |
429: |p_where_clause before the actual where clause , This is done to take |

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

429: |p_where_clause before the actual where clause , This is done to take |
430: |care of the Null Where Clause Case. |
431: +-----------------------------------------------------------------------*/
432: IF PG_DEBUG in ('Y', 'C') THEN
433: arp_standard.debug('Build_And_Bind: ' || 'where clause:' || p_where_clause );
434: arp_standard.debug('Build_And_Bind: ' || 'Opening Cursor');
435: END IF;
436:
437: l_select_cursor := dbms_sql.open_cursor;

Line 434: arp_standard.debug('Build_And_Bind: ' || 'Opening Cursor');

430: |care of the Null Where Clause Case. |
431: +-----------------------------------------------------------------------*/
432: IF PG_DEBUG in ('Y', 'C') THEN
433: arp_standard.debug('Build_And_Bind: ' || 'where clause:' || p_where_clause );
434: arp_standard.debug('Build_And_Bind: ' || 'Opening Cursor');
435: END IF;
436:
437: l_select_cursor := dbms_sql.open_cursor;
438:

Line 451: arp_standard.debug('Build_And_Bind: ' || 'Parsing statement ');

447: /*-----------------------------------------------------------------------+
448: |Parse the built statement along with the where clause. |
449: +-----------------------------------------------------------------------*/
450: IF PG_DEBUG in ('Y', 'C') THEN
451: arp_standard.debug('Build_And_Bind: ' || 'Parsing statement ');
452: arp_standard.debug('Build_And_Bind: ' || l_out_where_clause);
453: END IF;
454: dbms_sql.parse(l_select_cursor,
455: 'select invoice_currency_code from '||p_from_clause||' '||l_out_where_clause,

Line 452: arp_standard.debug('Build_And_Bind: ' || l_out_where_clause);

448: |Parse the built statement along with the where clause. |
449: +-----------------------------------------------------------------------*/
450: IF PG_DEBUG in ('Y', 'C') THEN
451: arp_standard.debug('Build_And_Bind: ' || 'Parsing statement ');
452: arp_standard.debug('Build_And_Bind: ' || l_out_where_clause);
453: END IF;
454: dbms_sql.parse(l_select_cursor,
455: 'select invoice_currency_code from '||p_from_clause||' '||l_out_where_clause,
456: dbms_sql.v7);

Line 463: arp_standard.debug('Build_And_Bind: ' || 'Defining Columns +');

459: |Define columns for the select statement. |
460: +-----------------------------------------------------------------------*/
461:
462: IF PG_DEBUG in ('Y', 'C') THEN
463: arp_standard.debug('Build_And_Bind: ' || 'Defining Columns +');
464: END IF;
465: dbms_sql.define_column(l_select_cursor, 1 ,l_currency_code,15);
466: IF PG_DEBUG in ('Y', 'C') THEN
467: arp_standard.debug('Build_And_Bind: ' || 'Defining Columns -');

Line 467: arp_standard.debug('Build_And_Bind: ' || 'Defining Columns -');

463: arp_standard.debug('Build_And_Bind: ' || 'Defining Columns +');
464: END IF;
465: dbms_sql.define_column(l_select_cursor, 1 ,l_currency_code,15);
466: IF PG_DEBUG in ('Y', 'C') THEN
467: arp_standard.debug('Build_And_Bind: ' || 'Defining Columns -');
468: END IF;
469:
470: /*-----------------------------------------------------------------------+
471: |Bind the variables built by Build_And_Bind routine with actual values |

Line 475: arp_standard.debug('Build_And_Bind: ' || 'Binding Variables +');

471: |Bind the variables built by Build_And_Bind routine with actual values |
472: +-----------------------------------------------------------------------*/
473: IF ((l_literal_tbl.EXISTS(l_tbl_ctr)) AND (p_where_clause IS NOT NULL)) THEN
474: IF PG_DEBUG in ('Y', 'C') THEN
475: arp_standard.debug('Build_And_Bind: ' || 'Binding Variables +');
476: END IF;
477:
478: FOR l_ctr in 1..l_tbl_ctr LOOP
479:

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

480: l_actual_bind_var := '';
481:
482: --Bind variables
483: IF PG_DEBUG in ('Y', 'C') THEN
484: arp_standard.debug('Build_And_Bind: ' || 'l_literal_tbl('||l_ctr||').bind_var_name = ' || l_literal_tbl(l_ctr).bind_var_name);
485: arp_standard.debug('Build_And_Bind: ' || 'l_literal_tbl('||l_ctr||').stripped_value = ' || l_literal_tbl(l_ctr).stripped_value);
486: END IF;
487:
488: l_actual_bind_var := rtrim(ltrim(l_literal_tbl(l_ctr).bind_var_name));

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

481:
482: --Bind variables
483: IF PG_DEBUG in ('Y', 'C') THEN
484: arp_standard.debug('Build_And_Bind: ' || 'l_literal_tbl('||l_ctr||').bind_var_name = ' || l_literal_tbl(l_ctr).bind_var_name);
485: arp_standard.debug('Build_And_Bind: ' || 'l_literal_tbl('||l_ctr||').stripped_value = ' || l_literal_tbl(l_ctr).stripped_value);
486: END IF;
487:
488: l_actual_bind_var := rtrim(ltrim(l_literal_tbl(l_ctr).bind_var_name));
489:

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

487:
488: l_actual_bind_var := rtrim(ltrim(l_literal_tbl(l_ctr).bind_var_name));
489:
490: IF PG_DEBUG in ('Y', 'C') THEN
491: arp_standard.debug('Build_And_Bind: ' || 'l_actual_bind_var = '||l_actual_bind_var);
492: END IF;
493:
494: dbms_sql.bind_variable(l_select_cursor, l_actual_bind_var, l_literal_tbl(l_ctr).stripped_value);
495:

Line 499: arp_standard.debug('Build_And_Bind: ' || 'Binding Variables -');

495:
496: END LOOP;
497:
498: IF PG_DEBUG in ('Y', 'C') THEN
499: arp_standard.debug('Build_And_Bind: ' || 'Binding Variables -');
500: END IF;
501:
502: END IF;
503:

Line 509: arp_standard.debug('Build_And_Bind: ' || 'Executing Statement +');

505: |Execute the SQL statement to calculate functional amount and accounted |
506: |amount totals. |
507: +-----------------------------------------------------------------------*/
508: IF PG_DEBUG in ('Y', 'C') THEN
509: arp_standard.debug('Build_And_Bind: ' || 'Executing Statement +');
510: END IF;
511:
512: l_ignore := dbms_sql.execute(l_select_cursor);
513:

Line 515: arp_standard.debug('Build_And_Bind: ' || 'Executing Statement -');

511:
512: l_ignore := dbms_sql.execute(l_select_cursor);
513:
514: IF PG_DEBUG in ('Y', 'C') THEN
515: arp_standard.debug('Build_And_Bind: ' || 'Executing Statement -');
516: END IF;
517:
518: IF dbms_sql.fetch_rows(l_select_cursor) > 0 then
519:

Line 524: arp_standard.debug('Build_And_Bind: ' || 'Fetching column values +');

520: /*-----------------------------------------------------------------------+
521: |Fetch the column values, into actual variables |
522: +-----------------------------------------------------------------------*/
523: IF PG_DEBUG in ('Y', 'C') THEN
524: arp_standard.debug('Build_And_Bind: ' || 'Fetching column values +');
525: END IF;
526:
527: dbms_sql.column_value(l_select_cursor, 1, l_currency_code);
528:

Line 530: arp_standard.debug('Build_And_Bind: ' || 'l_currency_code '||l_currency_code);

526:
527: dbms_sql.column_value(l_select_cursor, 1, l_currency_code);
528:
529: IF PG_DEBUG in ('Y', 'C') THEN
530: arp_standard.debug('Build_And_Bind: ' || 'l_currency_code '||l_currency_code);
531: END IF;
532:
533: p_currency_code := l_currency_code;
534:

Line 536: arp_standard.debug('Build_And_Bind: ' || 'p_currency_code'||p_currency_code);

532:
533: p_currency_code := l_currency_code;
534:
535: IF PG_DEBUG in ('Y', 'C') THEN
536: arp_standard.debug('Build_And_Bind: ' || 'p_currency_code'||p_currency_code);
537: arp_standard.debug('Build_And_Bind: ' || 'Fetching column values -');
538: END IF;
539:
540: ELSE

Line 537: arp_standard.debug('Build_And_Bind: ' || 'Fetching column values -');

533: p_currency_code := l_currency_code;
534:
535: IF PG_DEBUG in ('Y', 'C') THEN
536: arp_standard.debug('Build_And_Bind: ' || 'p_currency_code'||p_currency_code);
537: arp_standard.debug('Build_And_Bind: ' || 'Fetching column values -');
538: END IF;
539:
540: ELSE
541: IF PG_DEBUG in ('Y', 'C') THEN

Line 542: arp_standard.debug('Build_And_Bind: ' || 'no rows');

538: END IF;
539:
540: ELSE
541: IF PG_DEBUG in ('Y', 'C') THEN
542: arp_standard.debug('Build_And_Bind: ' || 'no rows');
543: END IF;
544: END IF;
545:
546: /*-----------------------------------------------------------------------+

Line 550: arp_standard.debug('Build_And_Bind: ' || 'Closing Cursor');

546: /*-----------------------------------------------------------------------+
547: |Finally close the cursor |
548: +-----------------------------------------------------------------------*/
549: IF PG_DEBUG in ('Y', 'C') THEN
550: arp_standard.debug('Build_And_Bind: ' || 'Closing Cursor');
551: END IF;
552: dbms_sql.close_cursor(l_select_cursor);
553:
554: -- arp_standard.enable_debug;

Line 554: -- arp_standard.enable_debug;

550: arp_standard.debug('Build_And_Bind: ' || 'Closing Cursor');
551: END IF;
552: dbms_sql.close_cursor(l_select_cursor);
553:
554: -- arp_standard.enable_debug;
555: EXCEPTION
556: WHEN OTHERS THEN
557: IF PG_DEBUG in ('Y', 'C') THEN
558: arp_standard.debug('Build_And_Bind: ' || 'Exception:' );

Line 558: arp_standard.debug('Build_And_Bind: ' || 'Exception:' );

554: -- arp_standard.enable_debug;
555: EXCEPTION
556: WHEN OTHERS THEN
557: IF PG_DEBUG in ('Y', 'C') THEN
558: arp_standard.debug('Build_And_Bind: ' || 'Exception:' );
559: END IF;
560: END;
561:
562: -- End bug 2089289

Line 573: -- arp_standard.enable_debug;

569: p_last_dispute_date
570: from ar_dispute_history
571: where payment_schedule_id = p_ps_id and
572: end_date is null;
573: -- arp_standard.enable_debug;
574: EXCEPTION
575: WHEN OTHERS THEN
576: IF PG_DEBUG in ('Y', 'C') THEN
577: arp_standard.debug('Build_And_Bind: ' || 'Exception:'|| to_char(p_last_dispute_date));

Line 577: arp_standard.debug('Build_And_Bind: ' || 'Exception:'|| to_char(p_last_dispute_date));

573: -- arp_standard.enable_debug;
574: EXCEPTION
575: WHEN OTHERS THEN
576: IF PG_DEBUG in ('Y', 'C') THEN
577: arp_standard.debug('Build_And_Bind: ' || 'Exception:'|| to_char(p_last_dispute_date));
578: END IF;
579: end;
580:
581:

Line 595: -- arp_standard.enable_debug;

591: (amount_in_dispute is NOT NULL and
592: p_amount_in_dispute IS NULL ) OR
593: ( p_amount_in_dispute IS NOT NULL and
594: amount_in_dispute IS NULL ) );
595: -- arp_standard.enable_debug;
596: EXCEPTION
597: WHEN OTHERS THEN
598: IF PG_DEBUG in ('Y', 'C') THEN
599: arp_standard.debug('Build_And_Bind: ' || 'Exception:'|| to_char(p_dispute_amount_changed));

Line 599: arp_standard.debug('Build_And_Bind: ' || 'Exception:'|| to_char(p_dispute_amount_changed));

595: -- arp_standard.enable_debug;
596: EXCEPTION
597: WHEN OTHERS THEN
598: IF PG_DEBUG in ('Y', 'C') THEN
599: arp_standard.debug('Build_And_Bind: ' || 'Exception:'|| to_char(p_dispute_amount_changed));
600: END IF;
601: end;
602:
603:

Line 614: -- arp_standard.enable_debug;

610: 'Y' )
611: into p_ever_in_dispute_flag
612: from ar_dispute_history
613: WHERE payment_schedule_id = p_ps_id;
614: -- arp_standard.enable_debug;
615: EXCEPTION
616: WHEN OTHERS THEN
617: IF PG_DEBUG in ('Y', 'C') THEN
618: arp_standard.debug('Build_And_Bind: ' || 'Exception in ever_in_dispute_flag' );

Line 618: arp_standard.debug('Build_And_Bind: ' || 'Exception in ever_in_dispute_flag' );

614: -- arp_standard.enable_debug;
615: EXCEPTION
616: WHEN OTHERS THEN
617: IF PG_DEBUG in ('Y', 'C') THEN
618: arp_standard.debug('Build_And_Bind: ' || 'Exception in ever_in_dispute_flag' );
619: END IF;
620: end;
621:
622: procedure get_days_late( p_due_date IN ar_payment_schedules.due_date%TYPE,

Line 628: -- arp_standard.enable_debug;

624: begin
625: select trunc(sysdate) - p_due_date
626: into p_days_late
627: from dual;
628: -- arp_standard.enable_debug;
629: EXCEPTION
630: WHEN OTHERS THEN
631: IF PG_DEBUG in ('Y', 'C') THEN
632: arp_standard.debug('Build_And_Bind: ' || 'Exception in ever_in_dispute_flag' );

Line 632: arp_standard.debug('Build_And_Bind: ' || 'Exception in ever_in_dispute_flag' );

628: -- arp_standard.enable_debug;
629: EXCEPTION
630: WHEN OTHERS THEN
631: IF PG_DEBUG in ('Y', 'C') THEN
632: arp_standard.debug('Build_And_Bind: ' || 'Exception in ever_in_dispute_flag' );
633: END IF;
634: end;
635:
636: /* ===============================================================================

Line 706: arp_standard.debug('Build_And_Bind: ' || 'l_in_where_clause ' || l_in_where_clause);

702:
703: BEGIN
704:
705: IF PG_DEBUG in ('Y', 'C') THEN
706: arp_standard.debug('Build_And_Bind: ' || 'l_in_where_clause ' || l_in_where_clause);
707: END IF;
708:
709: l_in_where_clause := p_in_where_clause;
710:

Line 808: arp_standard.debug('Build_And_Bind: ' || 'l_prev_cell = ' || l_prev_cell);

804: +---------------------------------------------------------------------------*/
805: IF (num_literal_on) AND l_prev_cell IN (',','.','+','-')THEN
806:
807: IF PG_DEBUG in ('Y', 'C') THEN
808: arp_standard.debug('Build_And_Bind: ' || 'l_prev_cell = ' || l_prev_cell);
809: END IF; --set values for numeric token
810: l_literal_tbl(l_tbl_ctr).stripped_value := l_literal_tbl(l_tbl_ctr).stripped_value || l_prev_cell;
811: ELSE
812: l_actual_where_clause := l_actual_where_clause || l_prev_cell; --Build the previous cell

Line 851: arp_standard.debug('Build_And_Bind: ' || 'l_temp_cell = ' || l_temp_cell);

847: l_build_where := TRUE ; --set the flag so that the actual where clause can be built
848:
849: ELSE
850: IF PG_DEBUG in ('Y', 'C') THEN
851: arp_standard.debug('Build_And_Bind: ' || 'l_temp_cell = ' || l_temp_cell);
852: END IF; --set values
853: -- 3804333, determine if there was a ' replaced with ^, now set it back to '
854: if emb_quote and l_temp_cell = '^' then
855: emb_quote := FALSE;

Line 884: arp_standard.debug('Build_And_Bind: ' || 'l_actual_where_clause ' || l_actual_where_clause);

880:
881: END IF; --end if by clause pos greater than 0
882:
883: IF PG_DEBUG in ('Y', 'C') THEN
884: arp_standard.debug('Build_And_Bind: ' || 'l_actual_where_clause ' || l_actual_where_clause);
885: END IF;
886:
887: /*---------------------------------------------------------------------------+
888: |In debug mode dump the contents of the table, which helps bind variables |

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

889: +---------------------------------------------------------------------------*/
890: FOR l_ctr in 1..l_tbl_ctr LOOP
891:
892: IF PG_DEBUG in ('Y', 'C') THEN
893: arp_standard.debug('Build_And_Bind: ' || 'l_literal_tbl('||l_ctr||').literal_counter = '|| l_literal_tbl(l_ctr).literal_counter);
894: arp_standard.debug('Build_And_Bind: ' || 'l_literal_tbl('||l_ctr||').bind_var_name = '|| l_literal_tbl(l_ctr).bind_var_name);
895: arp_standard.debug('Build_And_Bind: ' || 'l_literal_tbl('||l_ctr||').stripped_value = '|| l_literal_tbl(l_ctr).stripped_value);
896: END IF;
897:

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

890: FOR l_ctr in 1..l_tbl_ctr LOOP
891:
892: IF PG_DEBUG in ('Y', 'C') THEN
893: arp_standard.debug('Build_And_Bind: ' || 'l_literal_tbl('||l_ctr||').literal_counter = '|| l_literal_tbl(l_ctr).literal_counter);
894: arp_standard.debug('Build_And_Bind: ' || 'l_literal_tbl('||l_ctr||').bind_var_name = '|| l_literal_tbl(l_ctr).bind_var_name);
895: arp_standard.debug('Build_And_Bind: ' || 'l_literal_tbl('||l_ctr||').stripped_value = '|| l_literal_tbl(l_ctr).stripped_value);
896: END IF;
897:
898: END LOOP; --end loop dump debug statements

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

891:
892: IF PG_DEBUG in ('Y', 'C') THEN
893: arp_standard.debug('Build_And_Bind: ' || 'l_literal_tbl('||l_ctr||').literal_counter = '|| l_literal_tbl(l_ctr).literal_counter);
894: arp_standard.debug('Build_And_Bind: ' || 'l_literal_tbl('||l_ctr||').bind_var_name = '|| l_literal_tbl(l_ctr).bind_var_name);
895: arp_standard.debug('Build_And_Bind: ' || 'l_literal_tbl('||l_ctr||').stripped_value = '|| l_literal_tbl(l_ctr).stripped_value);
896: END IF;
897:
898: END LOOP; --end loop dump debug statements
899:

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

905:
906: EXCEPTION
907: WHEN OTHERS THEN
908: IF PG_DEBUG in ('Y', 'C') THEN
909: arp_standard.debug( 'ARP_ARXCOQIT.Build_And_Bind Exception: OTHERS EXCEPTION');
910: END IF;
911: RAISE;
912:
913: END Build_And_Bind;