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 ARP_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 298: arp_standard.debug('Build_And_Bind: ' || 'Defining Columns +');

294: /*-----------------------------------------------------------------------+
295: |Define columns for the select statement. |
296: +-----------------------------------------------------------------------*/
297: IF PG_DEBUG in ('Y', 'C') THEN
298: arp_standard.debug('Build_And_Bind: ' || 'Defining Columns +');
299: END IF;
300:
301: dbms_sql.define_column(l_select_cursor, 1 , l_count);
302: dbms_sql.define_column(l_select_cursor, 2 , l_amount);

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

302: dbms_sql.define_column(l_select_cursor, 2 , l_amount);
303: dbms_sql.define_column(l_select_cursor, 3 , l_func_amount);
304:
305: IF PG_DEBUG in ('Y', 'C') THEN
306: arp_standard.debug('Build_And_Bind: ' || 'Defining Columns -');
307: END IF;
308:
309: /*-----------------------------------------------------------------------+
310: |Bind the variables built by Build_And_Bind routine with actual values |

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

311: +-----------------------------------------------------------------------*/
312: IF ((l_literal_tbl.EXISTS(l_tbl_ctr)) AND (p_where_clause IS NOT NULL)) THEN
313:
314: IF PG_DEBUG in ('Y', 'C') THEN
315: arp_standard.debug('Build_And_Bind: ' || 'Binding Variables +');
316: END IF;
317:
318: FOR l_ctr in 1..l_tbl_ctr LOOP
319:

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

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

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

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

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

327:
328: l_actual_bind_var := rtrim(ltrim(l_literal_tbl(l_ctr).bind_var_name));
329:
330: IF PG_DEBUG in ('Y', 'C') THEN
331: arp_standard.debug('Build_And_Bind: ' || 'l_actual_bind_var = '||l_actual_bind_var);
332: END IF;
333:
334: dbms_sql.bind_variable(l_select_cursor, l_actual_bind_var, l_literal_tbl(l_ctr).stripped_value);
335:

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

335:
336: END LOOP;
337:
338: IF PG_DEBUG in ('Y', 'C') THEN
339: arp_standard.debug('Build_And_Bind: ' || 'Binding Variables -');
340: END IF;
341:
342: END IF;
343:

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

345: |Execute the SQL statement to calculate functional amount and accounted |
346: |amount totals. |
347: +-----------------------------------------------------------------------*/
348: IF PG_DEBUG in ('Y', 'C') THEN
349: arp_standard.debug('Build_And_Bind: ' || 'Executing Statement +');
350: END IF;
351:
352: l_ignore := dbms_sql.execute(l_select_cursor);
353:

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

351:
352: l_ignore := dbms_sql.execute(l_select_cursor);
353:
354: IF PG_DEBUG in ('Y', 'C') THEN
355: arp_standard.debug('Build_And_Bind: ' || 'Executing Statement -');
356: END IF;
357:
358: IF dbms_sql.fetch_rows(l_select_cursor) > 0 then
359:

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

360: /*-----------------------------------------------------------------------+
361: |Fetch the column values, into actual variables |
362: +-----------------------------------------------------------------------*/
363: IF PG_DEBUG in ('Y', 'C') THEN
364: arp_standard.debug('Build_And_Bind: ' || 'Fetching column values +');
365: END IF;
366:
367: dbms_sql.column_value(l_select_cursor, 1, l_count);
368: dbms_sql.column_value(l_select_cursor, 2, l_amount);

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

368: dbms_sql.column_value(l_select_cursor, 2, l_amount);
369: dbms_sql.column_value(l_select_cursor, 3, l_func_amount);
370:
371: IF PG_DEBUG in ('Y', 'C') THEN
372: arp_standard.debug('Build_And_Bind: ' || 'l_count '||l_count);
373: arp_standard.debug('Build_And_Bind: ' || 'l_amount'||l_amount);
374: arp_standard.debug('Build_And_Bind: ' || 'l_func_amount'||l_func_amount);
375: END IF;
376:

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

369: dbms_sql.column_value(l_select_cursor, 3, l_func_amount);
370:
371: IF PG_DEBUG in ('Y', 'C') THEN
372: arp_standard.debug('Build_And_Bind: ' || 'l_count '||l_count);
373: arp_standard.debug('Build_And_Bind: ' || 'l_amount'||l_amount);
374: arp_standard.debug('Build_And_Bind: ' || 'l_func_amount'||l_func_amount);
375: END IF;
376:
377: IF l_count = 1 THEN

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

370:
371: IF PG_DEBUG in ('Y', 'C') THEN
372: arp_standard.debug('Build_And_Bind: ' || 'l_count '||l_count);
373: arp_standard.debug('Build_And_Bind: ' || 'l_amount'||l_amount);
374: arp_standard.debug('Build_And_Bind: ' || 'l_func_amount'||l_func_amount);
375: END IF;
376:
377: IF l_count = 1 THEN
378: p_total := l_amount;

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

383: p_cur_count := l_count;
384: p_func_total := l_func_amount;
385:
386: IF PG_DEBUG in ('Y', 'C') THEN
387: arp_standard.debug('Build_And_Bind: ' || 'p_total '||p_total);
388: arp_standard.debug('Build_And_Bind: ' || 'p_func_total'||p_func_total);
389: arp_standard.debug('Build_And_Bind: ' || 'Fetching column values -');
390: END IF;
391:

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

384: p_func_total := l_func_amount;
385:
386: IF PG_DEBUG in ('Y', 'C') THEN
387: arp_standard.debug('Build_And_Bind: ' || 'p_total '||p_total);
388: arp_standard.debug('Build_And_Bind: ' || 'p_func_total'||p_func_total);
389: arp_standard.debug('Build_And_Bind: ' || 'Fetching column values -');
390: END IF;
391:
392: ELSE

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

385:
386: IF PG_DEBUG in ('Y', 'C') THEN
387: arp_standard.debug('Build_And_Bind: ' || 'p_total '||p_total);
388: arp_standard.debug('Build_And_Bind: ' || 'p_func_total'||p_func_total);
389: arp_standard.debug('Build_And_Bind: ' || 'Fetching column values -');
390: END IF;
391:
392: ELSE
393: IF PG_DEBUG in ('Y', 'C') THEN

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

390: END IF;
391:
392: ELSE
393: IF PG_DEBUG in ('Y', 'C') THEN
394: arp_standard.debug('Build_And_Bind: ' || 'no rows');
395: END IF;
396: END IF;
397:
398: /*-----------------------------------------------------------------------+

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

398: /*-----------------------------------------------------------------------+
399: |Finally close the cursor |
400: +-----------------------------------------------------------------------*/
401: IF PG_DEBUG in ('Y', 'C') THEN
402: arp_standard.debug('Build_And_Bind: ' || 'Closing Cursor');
403: END IF;
404: dbms_sql.close_cursor(l_select_cursor);
405:
406: -- arp_standard.enable_debug;

Line 406: -- arp_standard.enable_debug;

402: arp_standard.debug('Build_And_Bind: ' || 'Closing Cursor');
403: END IF;
404: dbms_sql.close_cursor(l_select_cursor);
405:
406: -- arp_standard.enable_debug;
407: EXCEPTION
408: WHEN OTHERS THEN
409: IF PG_DEBUG in ('Y', 'C') THEN
410: arp_standard.debug('Build_And_Bind: ' || 'Exception:' );

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

406: -- arp_standard.enable_debug;
407: EXCEPTION
408: WHEN OTHERS THEN
409: IF PG_DEBUG in ('Y', 'C') THEN
410: arp_standard.debug('Build_And_Bind: ' || 'Exception:' );
411: END IF;
412: END;
413:
414: -- Bug 2089289

Line 432: -- arp_standard.enable_debug;

428:
429: l_out_where_clause := '';
430: l_currency_code := '';
431:
432: -- arp_standard.enable_debug;
433:
434: /*-----------------------------------------------------------------------+
435: |Removed the 'WHERE' from the Parse Statement , It now comes in |
436: |p_where_clause before the actual where clause , This is done to take |

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

436: |p_where_clause before the actual where clause , This is done to take |
437: |care of the Null Where Clause Case. |
438: +-----------------------------------------------------------------------*/
439: IF PG_DEBUG in ('Y', 'C') THEN
440: arp_standard.debug('Build_And_Bind: ' || 'where clause:' || p_where_clause );
441: arp_standard.debug('Build_And_Bind: ' || 'Opening Cursor');
442: END IF;
443:
444: l_select_cursor := dbms_sql.open_cursor;

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

437: |care of the Null Where Clause Case. |
438: +-----------------------------------------------------------------------*/
439: IF PG_DEBUG in ('Y', 'C') THEN
440: arp_standard.debug('Build_And_Bind: ' || 'where clause:' || p_where_clause );
441: arp_standard.debug('Build_And_Bind: ' || 'Opening Cursor');
442: END IF;
443:
444: l_select_cursor := dbms_sql.open_cursor;
445:

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

454: /*-----------------------------------------------------------------------+
455: |Parse the built statement along with the where clause. |
456: +-----------------------------------------------------------------------*/
457: IF PG_DEBUG in ('Y', 'C') THEN
458: arp_standard.debug('Build_And_Bind: ' || 'Parsing statement ');
459: arp_standard.debug('Build_And_Bind: ' || l_out_where_clause);
460: END IF;
461: dbms_sql.parse(l_select_cursor,
462: 'select invoice_currency_code from '||p_from_clause||' '||l_out_where_clause,

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

455: |Parse the built statement along with the where clause. |
456: +-----------------------------------------------------------------------*/
457: IF PG_DEBUG in ('Y', 'C') THEN
458: arp_standard.debug('Build_And_Bind: ' || 'Parsing statement ');
459: arp_standard.debug('Build_And_Bind: ' || l_out_where_clause);
460: END IF;
461: dbms_sql.parse(l_select_cursor,
462: 'select invoice_currency_code from '||p_from_clause||' '||l_out_where_clause,
463: dbms_sql.v7);

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

466: |Define columns for the select statement. |
467: +-----------------------------------------------------------------------*/
468:
469: IF PG_DEBUG in ('Y', 'C') THEN
470: arp_standard.debug('Build_And_Bind: ' || 'Defining Columns +');
471: END IF;
472: dbms_sql.define_column(l_select_cursor, 1 ,l_currency_code,15);
473: IF PG_DEBUG in ('Y', 'C') THEN
474: arp_standard.debug('Build_And_Bind: ' || 'Defining Columns -');

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

470: arp_standard.debug('Build_And_Bind: ' || 'Defining Columns +');
471: END IF;
472: dbms_sql.define_column(l_select_cursor, 1 ,l_currency_code,15);
473: IF PG_DEBUG in ('Y', 'C') THEN
474: arp_standard.debug('Build_And_Bind: ' || 'Defining Columns -');
475: END IF;
476:
477: /*-----------------------------------------------------------------------+
478: |Bind the variables built by Build_And_Bind routine with actual values |

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

478: |Bind the variables built by Build_And_Bind routine with actual values |
479: +-----------------------------------------------------------------------*/
480: IF ((l_literal_tbl.EXISTS(l_tbl_ctr)) AND (p_where_clause IS NOT NULL)) THEN
481: IF PG_DEBUG in ('Y', 'C') THEN
482: arp_standard.debug('Build_And_Bind: ' || 'Binding Variables +');
483: END IF;
484:
485: FOR l_ctr in 1..l_tbl_ctr LOOP
486:

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

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

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

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

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

494:
495: l_actual_bind_var := rtrim(ltrim(l_literal_tbl(l_ctr).bind_var_name));
496:
497: IF PG_DEBUG in ('Y', 'C') THEN
498: arp_standard.debug('Build_And_Bind: ' || 'l_actual_bind_var = '||l_actual_bind_var);
499: END IF;
500:
501: dbms_sql.bind_variable(l_select_cursor, l_actual_bind_var, l_literal_tbl(l_ctr).stripped_value);
502:

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

502:
503: END LOOP;
504:
505: IF PG_DEBUG in ('Y', 'C') THEN
506: arp_standard.debug('Build_And_Bind: ' || 'Binding Variables -');
507: END IF;
508:
509: END IF;
510:

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

512: |Execute the SQL statement to calculate functional amount and accounted |
513: |amount totals. |
514: +-----------------------------------------------------------------------*/
515: IF PG_DEBUG in ('Y', 'C') THEN
516: arp_standard.debug('Build_And_Bind: ' || 'Executing Statement +');
517: END IF;
518:
519: l_ignore := dbms_sql.execute(l_select_cursor);
520:

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

518:
519: l_ignore := dbms_sql.execute(l_select_cursor);
520:
521: IF PG_DEBUG in ('Y', 'C') THEN
522: arp_standard.debug('Build_And_Bind: ' || 'Executing Statement -');
523: END IF;
524:
525: IF dbms_sql.fetch_rows(l_select_cursor) > 0 then
526:

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

527: /*-----------------------------------------------------------------------+
528: |Fetch the column values, into actual variables |
529: +-----------------------------------------------------------------------*/
530: IF PG_DEBUG in ('Y', 'C') THEN
531: arp_standard.debug('Build_And_Bind: ' || 'Fetching column values +');
532: END IF;
533:
534: dbms_sql.column_value(l_select_cursor, 1, l_currency_code);
535:

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

533:
534: dbms_sql.column_value(l_select_cursor, 1, l_currency_code);
535:
536: IF PG_DEBUG in ('Y', 'C') THEN
537: arp_standard.debug('Build_And_Bind: ' || 'l_currency_code '||l_currency_code);
538: END IF;
539:
540: p_currency_code := l_currency_code;
541:

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

539:
540: p_currency_code := l_currency_code;
541:
542: IF PG_DEBUG in ('Y', 'C') THEN
543: arp_standard.debug('Build_And_Bind: ' || 'p_currency_code'||p_currency_code);
544: arp_standard.debug('Build_And_Bind: ' || 'Fetching column values -');
545: END IF;
546:
547: ELSE

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

540: p_currency_code := l_currency_code;
541:
542: IF PG_DEBUG in ('Y', 'C') THEN
543: arp_standard.debug('Build_And_Bind: ' || 'p_currency_code'||p_currency_code);
544: arp_standard.debug('Build_And_Bind: ' || 'Fetching column values -');
545: END IF;
546:
547: ELSE
548: IF PG_DEBUG in ('Y', 'C') THEN

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

545: END IF;
546:
547: ELSE
548: IF PG_DEBUG in ('Y', 'C') THEN
549: arp_standard.debug('Build_And_Bind: ' || 'no rows');
550: END IF;
551: END IF;
552:
553: /*-----------------------------------------------------------------------+

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

553: /*-----------------------------------------------------------------------+
554: |Finally close the cursor |
555: +-----------------------------------------------------------------------*/
556: IF PG_DEBUG in ('Y', 'C') THEN
557: arp_standard.debug('Build_And_Bind: ' || 'Closing Cursor');
558: END IF;
559: dbms_sql.close_cursor(l_select_cursor);
560:
561: -- arp_standard.enable_debug;

Line 561: -- arp_standard.enable_debug;

557: arp_standard.debug('Build_And_Bind: ' || 'Closing Cursor');
558: END IF;
559: dbms_sql.close_cursor(l_select_cursor);
560:
561: -- arp_standard.enable_debug;
562: EXCEPTION
563: WHEN OTHERS THEN
564: IF PG_DEBUG in ('Y', 'C') THEN
565: arp_standard.debug('Build_And_Bind: ' || 'Exception:' );

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

561: -- arp_standard.enable_debug;
562: EXCEPTION
563: WHEN OTHERS THEN
564: IF PG_DEBUG in ('Y', 'C') THEN
565: arp_standard.debug('Build_And_Bind: ' || 'Exception:' );
566: END IF;
567: END;
568:
569: -- End bug 2089289

Line 580: -- arp_standard.enable_debug;

576: p_last_dispute_date
577: from ar_dispute_history
578: where payment_schedule_id = p_ps_id and
579: end_date is null;
580: -- arp_standard.enable_debug;
581: EXCEPTION
582: WHEN OTHERS THEN
583: IF PG_DEBUG in ('Y', 'C') THEN
584: arp_standard.debug('Build_And_Bind: ' || 'Exception:'|| to_char(p_last_dispute_date));

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

580: -- arp_standard.enable_debug;
581: EXCEPTION
582: WHEN OTHERS THEN
583: IF PG_DEBUG in ('Y', 'C') THEN
584: arp_standard.debug('Build_And_Bind: ' || 'Exception:'|| to_char(p_last_dispute_date));
585: END IF;
586: end;
587:
588:

Line 602: -- arp_standard.enable_debug;

598: (amount_in_dispute is NOT NULL and
599: p_amount_in_dispute IS NULL ) OR
600: ( p_amount_in_dispute IS NOT NULL and
601: amount_in_dispute IS NULL ) );
602: -- arp_standard.enable_debug;
603: EXCEPTION
604: WHEN OTHERS THEN
605: IF PG_DEBUG in ('Y', 'C') THEN
606: arp_standard.debug('Build_And_Bind: ' || 'Exception:'|| to_char(p_dispute_amount_changed));

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

602: -- arp_standard.enable_debug;
603: EXCEPTION
604: WHEN OTHERS THEN
605: IF PG_DEBUG in ('Y', 'C') THEN
606: arp_standard.debug('Build_And_Bind: ' || 'Exception:'|| to_char(p_dispute_amount_changed));
607: END IF;
608: end;
609:
610:

Line 621: -- arp_standard.enable_debug;

617: 'Y' )
618: into p_ever_in_dispute_flag
619: from ar_dispute_history
620: WHERE payment_schedule_id = p_ps_id;
621: -- arp_standard.enable_debug;
622: EXCEPTION
623: WHEN OTHERS THEN
624: IF PG_DEBUG in ('Y', 'C') THEN
625: arp_standard.debug('Build_And_Bind: ' || 'Exception in ever_in_dispute_flag' );

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

621: -- arp_standard.enable_debug;
622: EXCEPTION
623: WHEN OTHERS THEN
624: IF PG_DEBUG in ('Y', 'C') THEN
625: arp_standard.debug('Build_And_Bind: ' || 'Exception in ever_in_dispute_flag' );
626: END IF;
627: end;
628:
629: procedure get_days_late( p_due_date IN ar_payment_schedules.due_date%TYPE,

Line 635: -- arp_standard.enable_debug;

631: begin
632: select trunc(sysdate) - p_due_date
633: into p_days_late
634: from dual;
635: -- arp_standard.enable_debug;
636: EXCEPTION
637: WHEN OTHERS THEN
638: IF PG_DEBUG in ('Y', 'C') THEN
639: arp_standard.debug('Build_And_Bind: ' || 'Exception in ever_in_dispute_flag' );

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

635: -- arp_standard.enable_debug;
636: EXCEPTION
637: WHEN OTHERS THEN
638: IF PG_DEBUG in ('Y', 'C') THEN
639: arp_standard.debug('Build_And_Bind: ' || 'Exception in ever_in_dispute_flag' );
640: END IF;
641: end;
642:
643: /* ===============================================================================

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

709:
710: BEGIN
711:
712: IF PG_DEBUG in ('Y', 'C') THEN
713: arp_standard.debug('Build_And_Bind: ' || 'l_in_where_clause ' || l_in_where_clause);
714: END IF;
715:
716: l_in_where_clause := p_in_where_clause;
717:

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

811: +---------------------------------------------------------------------------*/
812: IF (num_literal_on) AND l_prev_cell IN (',','.','+','-')THEN
813:
814: IF PG_DEBUG in ('Y', 'C') THEN
815: arp_standard.debug('Build_And_Bind: ' || 'l_prev_cell = ' || l_prev_cell);
816: END IF; --set values for numeric token
817: l_literal_tbl(l_tbl_ctr).stripped_value := l_literal_tbl(l_tbl_ctr).stripped_value || l_prev_cell;
818: ELSE
819: l_actual_where_clause := l_actual_where_clause || l_prev_cell; --Build the previous cell

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

854: l_build_where := TRUE ; --set the flag so that the actual where clause can be built
855:
856: ELSE
857: IF PG_DEBUG in ('Y', 'C') THEN
858: arp_standard.debug('Build_And_Bind: ' || 'l_temp_cell = ' || l_temp_cell);
859: END IF; --set values
860: -- 3804333, determine if there was a ' replaced with ^, now set it back to '
861: if emb_quote and l_temp_cell = '^' then
862: emb_quote := FALSE;

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

887:
888: END IF; --end if by clause pos greater than 0
889:
890: IF PG_DEBUG in ('Y', 'C') THEN
891: arp_standard.debug('Build_And_Bind: ' || 'l_actual_where_clause ' || l_actual_where_clause);
892: END IF;
893:
894: /*---------------------------------------------------------------------------+
895: |In debug mode dump the contents of the table, which helps bind variables |

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

896: +---------------------------------------------------------------------------*/
897: FOR l_ctr in 1..l_tbl_ctr LOOP
898:
899: IF PG_DEBUG in ('Y', 'C') THEN
900: arp_standard.debug('Build_And_Bind: ' || 'l_literal_tbl('||l_ctr||').literal_counter = '|| l_literal_tbl(l_ctr).literal_counter);
901: arp_standard.debug('Build_And_Bind: ' || 'l_literal_tbl('||l_ctr||').bind_var_name = '|| l_literal_tbl(l_ctr).bind_var_name);
902: arp_standard.debug('Build_And_Bind: ' || 'l_literal_tbl('||l_ctr||').stripped_value = '|| l_literal_tbl(l_ctr).stripped_value);
903: END IF;
904:

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

897: FOR l_ctr in 1..l_tbl_ctr LOOP
898:
899: IF PG_DEBUG in ('Y', 'C') THEN
900: arp_standard.debug('Build_And_Bind: ' || 'l_literal_tbl('||l_ctr||').literal_counter = '|| l_literal_tbl(l_ctr).literal_counter);
901: arp_standard.debug('Build_And_Bind: ' || 'l_literal_tbl('||l_ctr||').bind_var_name = '|| l_literal_tbl(l_ctr).bind_var_name);
902: arp_standard.debug('Build_And_Bind: ' || 'l_literal_tbl('||l_ctr||').stripped_value = '|| l_literal_tbl(l_ctr).stripped_value);
903: END IF;
904:
905: END LOOP; --end loop dump debug statements

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

898:
899: IF PG_DEBUG in ('Y', 'C') THEN
900: arp_standard.debug('Build_And_Bind: ' || 'l_literal_tbl('||l_ctr||').literal_counter = '|| l_literal_tbl(l_ctr).literal_counter);
901: arp_standard.debug('Build_And_Bind: ' || 'l_literal_tbl('||l_ctr||').bind_var_name = '|| l_literal_tbl(l_ctr).bind_var_name);
902: arp_standard.debug('Build_And_Bind: ' || 'l_literal_tbl('||l_ctr||').stripped_value = '|| l_literal_tbl(l_ctr).stripped_value);
903: END IF;
904:
905: END LOOP; --end loop dump debug statements
906:

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

912:
913: EXCEPTION
914: WHEN OTHERS THEN
915: IF PG_DEBUG in ('Y', 'C') THEN
916: arp_standard.debug( 'ARP_ARXCOQIT.Build_And_Bind Exception: OTHERS EXCEPTION');
917: END IF;
918: RAISE;
919:
920: END Build_And_Bind;