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

Line 63: arp_standard.enable_debug;

59: sqlstmt VARCHAR2(254);
60:
61: BEGIN
62:
63: arp_standard.enable_debug;
64:
65: IF PG_DEBUG in ('Y', 'C') THEN
66: arp_standard.debug('is_gdf_valid: ' || cr || 'Global Descr Flex Field Validation begin: ' ||
67: to_char(sysdate, 'DD-MON-YY HH:MI:SS'));

Line 66: arp_standard.debug('is_gdf_valid: ' || cr || 'Global Descr Flex Field Validation begin: ' ||

62:
63: arp_standard.enable_debug;
64:
65: IF PG_DEBUG in ('Y', 'C') THEN
66: arp_standard.debug('is_gdf_valid: ' || cr || 'Global Descr Flex Field Validation begin: ' ||
67: to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
68: END IF;
69:
70: /* Check if JG_ZZ_AUTO_INVOICE package is installed */

Line 89: arp_standard.debug('is_gdf_valid: ' || cr || 'Package: JG_ZZ_AUTO_INVOICE is installed.');

85:
86: IF g_jgzz_product_code IS NOT NULL THEN
87:
88: IF PG_DEBUG in ('Y', 'C') THEN
89: arp_standard.debug('is_gdf_valid: ' || cr || 'Package: JG_ZZ_AUTO_INVOICE is installed.');
90: END IF;
91:
92: /* JG_ZZ_AUTO_INVOICE package is installed, so OK to call it */
93:

Line 106: arp_standard.debug('is_gdf_valid: ' || cr||'Executing Statement:'||cr||cr||sqlstmt);

102: dbms_sql.bind_variable(lcursor, ':request_id', request_id);
103: dbms_sql.bind_variable(lcursor, ':return_value', return_value);
104:
105: IF PG_DEBUG in ('Y', 'C') THEN
106: arp_standard.debug('is_gdf_valid: ' || cr||'Executing Statement:'||cr||cr||sqlstmt);
107: END IF;
108:
109: lignore := dbms_sql.execute(lcursor);
110: dbms_sql.variable_value (lcursor, ':return_value', return_value);

Line 112: arp_standard.debug('is_gdf_valid: ' || 'Return value from JG_ZZ_AUTO_INVOICE.validate_gdff(): ' || return_value);

108:
109: lignore := dbms_sql.execute(lcursor);
110: dbms_sql.variable_value (lcursor, ':return_value', return_value);
111: IF PG_DEBUG in ('Y', 'C') THEN
112: arp_standard.debug('is_gdf_valid: ' || 'Return value from JG_ZZ_AUTO_INVOICE.validate_gdff(): ' || return_value);
113: END IF;
114: dbms_sql.close_cursor(lcursor);
115:
116: EXCEPTION

Line 119: arp_standard.debug('is_gdf_valid: ' || cr|| 'Exception calling JG_ZZ_AUTO_INVOICE.validate_gdff()');

115:
116: EXCEPTION
117: WHEN OTHERS THEN
118: IF PG_DEBUG in ('Y', 'C') THEN
119: arp_standard.debug('is_gdf_valid: ' || cr|| 'Exception calling JG_ZZ_AUTO_INVOICE.validate_gdff()');
120: arp_standard.debug('is_gdf_valid: ' || SQLERRM);
121: END IF;
122:
123: IF dbms_sql.is_open(lcursor)

Line 120: arp_standard.debug('is_gdf_valid: ' || SQLERRM);

116: EXCEPTION
117: WHEN OTHERS THEN
118: IF PG_DEBUG in ('Y', 'C') THEN
119: arp_standard.debug('is_gdf_valid: ' || cr|| 'Exception calling JG_ZZ_AUTO_INVOICE.validate_gdff()');
120: arp_standard.debug('is_gdf_valid: ' || SQLERRM);
121: END IF;
122:
123: IF dbms_sql.is_open(lcursor)
124: THEN

Line 129: arp_standard.debug('is_gdf_valid: ' || cr || 'Global Descr Flex Field Validation end: ' || to_char(sysdate, 'DD-MON-YY HH:MI:SS'));

125: dbms_sql.close_cursor(lcursor);
126: END IF;
127:
128: IF PG_DEBUG in ('Y', 'C') THEN
129: arp_standard.debug('is_gdf_valid: ' || cr || 'Global Descr Flex Field Validation end: ' || to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
130: END IF;
131:
132: return(FALSE);
133: END;

Line 145: arp_standard.debug('is_gdf_valid: ' || cr || 'Global Descr Flex Field Validation end: ' ||

141: END IF ;
142:
143:
144: IF PG_DEBUG in ('Y', 'C') THEN
145: arp_standard.debug('is_gdf_valid: ' || cr || 'Global Descr Flex Field Validation end: ' ||
146: to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
147: END IF;
148:
149: /* Always return TRUE if JG is not installed */

Line 157: arp_standard.debug(cr|| 'Exception in AR_GDF_VALIDATION.is_gdf_valid()');

153: EXCEPTION
154:
155: WHEN OTHERS THEN
156: IF PG_DEBUG in ('Y', 'C') THEN
157: arp_standard.debug(cr|| 'Exception in AR_GDF_VALIDATION.is_gdf_valid()');
158: arp_standard.debug('is_gdf_valid: ' || SQLERRM);
159: arp_standard.debug('is_gdf_valid: ' || cr || 'Global Descr Flex Field Validation end: ' || to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
160: END IF;
161: return(FALSE);

Line 158: arp_standard.debug('is_gdf_valid: ' || SQLERRM);

154:
155: WHEN OTHERS THEN
156: IF PG_DEBUG in ('Y', 'C') THEN
157: arp_standard.debug(cr|| 'Exception in AR_GDF_VALIDATION.is_gdf_valid()');
158: arp_standard.debug('is_gdf_valid: ' || SQLERRM);
159: arp_standard.debug('is_gdf_valid: ' || cr || 'Global Descr Flex Field Validation end: ' || to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
160: END IF;
161: return(FALSE);
162:

Line 159: arp_standard.debug('is_gdf_valid: ' || cr || 'Global Descr Flex Field Validation end: ' || to_char(sysdate, 'DD-MON-YY HH:MI:SS'));

155: WHEN OTHERS THEN
156: IF PG_DEBUG in ('Y', 'C') THEN
157: arp_standard.debug(cr|| 'Exception in AR_GDF_VALIDATION.is_gdf_valid()');
158: arp_standard.debug('is_gdf_valid: ' || SQLERRM);
159: arp_standard.debug('is_gdf_valid: ' || cr || 'Global Descr Flex Field Validation end: ' || to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
160: END IF;
161: return(FALSE);
162:
163: END is_gdf_valid;

Line 219: --arp_standard.enable_debug;

215:
216:
217: BEGIN
218:
219: --arp_standard.enable_debug;
220:
221: IF PG_DEBUG in ('Y', 'C') THEN
222: arp_standard.debug('is_gdf_postbatch_valid: ' || cr || 'Global Descr Flex Field Validation begin: ' ||
223: to_char(sysdate, 'DD-MON-YY HH:MI:SS'));

Line 222: arp_standard.debug('is_gdf_postbatch_valid: ' || cr || 'Global Descr Flex Field Validation begin: ' ||

218:
219: --arp_standard.enable_debug;
220:
221: IF PG_DEBUG in ('Y', 'C') THEN
222: arp_standard.debug('is_gdf_postbatch_valid: ' || cr || 'Global Descr Flex Field Validation begin: ' ||
223: to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
224: arp_standard.debug('is_gdf_postbatch_valid: ' || cr || 'batch_id= ' || batch_id ||
225: 'cash_receipt_id= ' || cash_receipt_id);
226: END IF;

Line 224: arp_standard.debug('is_gdf_postbatch_valid: ' || cr || 'batch_id= ' || batch_id ||

220:
221: IF PG_DEBUG in ('Y', 'C') THEN
222: arp_standard.debug('is_gdf_postbatch_valid: ' || cr || 'Global Descr Flex Field Validation begin: ' ||
223: to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
224: arp_standard.debug('is_gdf_postbatch_valid: ' || cr || 'batch_id= ' || batch_id ||
225: 'cash_receipt_id= ' || cash_receipt_id);
226: END IF;
227:
228: /* Check if JL_ZZ_POSTBATCH package is installed */

Line 238: arp_standard.debug('is_gdf_postbatch_valid: ' || cr || 'Package: JL_ZZ_POSTBATCH is installed.');

234: WHERE name = 'JL_ZZ_POSTBATCH'
235: AND type = 'PACKAGE BODY';
236:
237: IF PG_DEBUG in ('Y', 'C') THEN
238: arp_standard.debug('is_gdf_postbatch_valid: ' || cr || 'Package: JL_ZZ_POSTBATCH is installed.');
239: END IF;
240: ***/
241:
242: /* JL_ZZ_POSTBATCH package is installed, so OK to call it */

Line 253: arp_standard.debug('is_gdf_postbatch_valid: ' || cr|| 'Exception calling JL_ZZ_POSTBATCH.populate_gdfs()');

249:
250: EXCEPTION
251: when OTHERS then
252: IF PG_DEBUG in ('Y', 'C') THEN
253: arp_standard.debug('is_gdf_postbatch_valid: ' || cr|| 'Exception calling JL_ZZ_POSTBATCH.populate_gdfs()');
254: arp_standard.debug('is_gdf_postbatch_valid: ' || SQLERRM(SQLCODE));
255: arp_standard.debug('is_gdf_postbatch_valid: ' || cr || 'Global Descr Flex Field Validation end: '
256: || to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
257: END IF;

Line 254: arp_standard.debug('is_gdf_postbatch_valid: ' || SQLERRM(SQLCODE));

250: EXCEPTION
251: when OTHERS then
252: IF PG_DEBUG in ('Y', 'C') THEN
253: arp_standard.debug('is_gdf_postbatch_valid: ' || cr|| 'Exception calling JL_ZZ_POSTBATCH.populate_gdfs()');
254: arp_standard.debug('is_gdf_postbatch_valid: ' || SQLERRM(SQLCODE));
255: arp_standard.debug('is_gdf_postbatch_valid: ' || cr || 'Global Descr Flex Field Validation end: '
256: || to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
257: END IF;
258:

Line 255: arp_standard.debug('is_gdf_postbatch_valid: ' || cr || 'Global Descr Flex Field Validation end: '

251: when OTHERS then
252: IF PG_DEBUG in ('Y', 'C') THEN
253: arp_standard.debug('is_gdf_postbatch_valid: ' || cr|| 'Exception calling JL_ZZ_POSTBATCH.populate_gdfs()');
254: arp_standard.debug('is_gdf_postbatch_valid: ' || SQLERRM(SQLCODE));
255: arp_standard.debug('is_gdf_postbatch_valid: ' || cr || 'Global Descr Flex Field Validation end: '
256: || to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
257: END IF;
258:
259: return(FALSE);

Line 265: arp_standard.debug('is_gdf_postbatch_valid: ' || cr || 'Global Descr Flex Field Validation end: ' ||

261: END IF;
262:
263:
264: IF PG_DEBUG in ('Y', 'C') THEN
265: arp_standard.debug('is_gdf_postbatch_valid: ' || cr || 'Global Descr Flex Field Validation end: ' ||
266: to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
267: END IF;
268:
269:

Line 277: arp_standard.debug('is_gdf_postbatch_valid: ' || 'Not running Global Validation, JL_ZZ_POSTBATCH NOT installed.');

273:
274: WHEN NO_DATA_FOUND THEN
275: /* Always return TRUE if JL is not installed */
276: IF PG_DEBUG in ('Y', 'C') THEN
277: arp_standard.debug('is_gdf_postbatch_valid: ' || 'Not running Global Validation, JL_ZZ_POSTBATCH NOT installed.');
278: arp_standard.debug('is_gdf_postbatch_valid: ' || cr || 'Global Descr Flex Field Validation end: '
279: || to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
280: END IF;
281: return(TRUE);

Line 278: arp_standard.debug('is_gdf_postbatch_valid: ' || cr || 'Global Descr Flex Field Validation end: '

274: WHEN NO_DATA_FOUND THEN
275: /* Always return TRUE if JL is not installed */
276: IF PG_DEBUG in ('Y', 'C') THEN
277: arp_standard.debug('is_gdf_postbatch_valid: ' || 'Not running Global Validation, JL_ZZ_POSTBATCH NOT installed.');
278: arp_standard.debug('is_gdf_postbatch_valid: ' || cr || 'Global Descr Flex Field Validation end: '
279: || to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
280: END IF;
281: return(TRUE);
282:

Line 285: arp_standard.debug(cr|| 'Exception in AR_GDF_VALIDATION.is_gdf_postbatch_valid()');

281: return(TRUE);
282:
283: WHEN OTHERS THEN
284: IF PG_DEBUG in ('Y', 'C') THEN
285: arp_standard.debug(cr|| 'Exception in AR_GDF_VALIDATION.is_gdf_postbatch_valid()');
286: arp_standard.debug('is_gdf_postbatch_valid: ' || SQLERRM);
287: arp_standard.debug('is_gdf_postbatch_valid: ' || cr || 'Global Descr Flex Field Validation end: '
288: || to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
289: END IF;

Line 286: arp_standard.debug('is_gdf_postbatch_valid: ' || SQLERRM);

282:
283: WHEN OTHERS THEN
284: IF PG_DEBUG in ('Y', 'C') THEN
285: arp_standard.debug(cr|| 'Exception in AR_GDF_VALIDATION.is_gdf_postbatch_valid()');
286: arp_standard.debug('is_gdf_postbatch_valid: ' || SQLERRM);
287: arp_standard.debug('is_gdf_postbatch_valid: ' || cr || 'Global Descr Flex Field Validation end: '
288: || to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
289: END IF;
290: return(FALSE);

Line 287: arp_standard.debug('is_gdf_postbatch_valid: ' || cr || 'Global Descr Flex Field Validation end: '

283: WHEN OTHERS THEN
284: IF PG_DEBUG in ('Y', 'C') THEN
285: arp_standard.debug(cr|| 'Exception in AR_GDF_VALIDATION.is_gdf_postbatch_valid()');
286: arp_standard.debug('is_gdf_postbatch_valid: ' || SQLERRM);
287: arp_standard.debug('is_gdf_postbatch_valid: ' || cr || 'Global Descr Flex Field Validation end: '
288: || to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
289: END IF;
290: return(FALSE);
291:

Line 364: --arp_standard.enable_debug;

360: l_user_schema VARCHAR2(30) := USER;
361:
362: BEGIN
363:
364: --arp_standard.enable_debug;
365:
366: IF PG_DEBUG in ('Y', 'C') THEN
367: arp_standard.debug('is_gdf_taxid_valid: ' || cr || 'Global Descr Flex Field Validation begin: ' ||
368: to_char(sysdate, 'DD-MON-YY HH:MI:SS'));

Line 367: arp_standard.debug('is_gdf_taxid_valid: ' || cr || 'Global Descr Flex Field Validation begin: ' ||

363:
364: --arp_standard.enable_debug;
365:
366: IF PG_DEBUG in ('Y', 'C') THEN
367: arp_standard.debug('is_gdf_taxid_valid: ' || cr || 'Global Descr Flex Field Validation begin: ' ||
368: to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
369: END IF;
370:
371: /* Check if JG_GLOBE_FLEX_VAL package is installed */

Line 382: arp_standard.debug('is_gdf_taxid_valid: ' || cr || 'Package: JG_GLOBE_FLEX_VAL is installed.');

378: AND type = 'PACKAGE BODY'
379: AND owner = l_user_schema; /*Bug 3544086*/
380:
381: IF PG_DEBUG in ('Y', 'C') THEN
382: arp_standard.debug('is_gdf_taxid_valid: ' || cr || 'Package: JG_GLOBE_FLEX_VAL is installed.');
383: END IF;
384:
385: /* JG_GLOBE_FLEX_VAL package is installed, so OK to call it */
386:

Line 404: arp_standard.debug('is_gdf_taxid_valid: ' || cr||'Executing Statement:'||cr||cr||sqlstmt);

400:
401: dbms_sql.parse(lcursor, sqlstmt, dbms_sql.native);
402:
403: IF PG_DEBUG in ('Y', 'C') THEN
404: arp_standard.debug('is_gdf_taxid_valid: ' || cr||'Executing Statement:'||cr||cr||sqlstmt);
405: END IF;
406:
407: lignore := dbms_sql.execute(lcursor);
408:

Line 414: arp_standard.debug('is_gdf_taxid_valid: ' || cr|| 'Exception calling JG_GLOBE_FLEX_VAL.ar_cust_interface()');

410:
411: EXCEPTION
412: when OTHERS then
413: IF PG_DEBUG in ('Y', 'C') THEN
414: arp_standard.debug('is_gdf_taxid_valid: ' || cr|| 'Exception calling JG_GLOBE_FLEX_VAL.ar_cust_interface()');
415: arp_standard.debug('is_gdf_taxid_valid: ' || SQLERRM);
416: END IF;
417:
418: IF dbms_sql.is_open(lcursor)

Line 415: arp_standard.debug('is_gdf_taxid_valid: ' || SQLERRM);

411: EXCEPTION
412: when OTHERS then
413: IF PG_DEBUG in ('Y', 'C') THEN
414: arp_standard.debug('is_gdf_taxid_valid: ' || cr|| 'Exception calling JG_GLOBE_FLEX_VAL.ar_cust_interface()');
415: arp_standard.debug('is_gdf_taxid_valid: ' || SQLERRM);
416: END IF;
417:
418: IF dbms_sql.is_open(lcursor)
419: THEN

Line 423: arp_standard.debug('is_gdf_taxid_valid: ' || cr || 'Global Descr Flex Field Validation end: '

419: THEN
420: dbms_sql.close_cursor(lcursor);
421: END IF;
422: IF PG_DEBUG in ('Y', 'C') THEN
423: arp_standard.debug('is_gdf_taxid_valid: ' || cr || 'Global Descr Flex Field Validation end: '
424: || to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
425: END IF;
426:
427: return(FALSE);

Line 432: arp_standard.debug('is_gdf_taxid_valid: ' || cr || 'Global Descr Flex Field Validation end: ' ||

428: END;
429:
430:
431: IF PG_DEBUG in ('Y', 'C') THEN
432: arp_standard.debug('is_gdf_taxid_valid: ' || cr || 'Global Descr Flex Field Validation end: ' ||
433: to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
434: END IF;
435:
436: return(TRUE);

Line 443: arp_standard.debug('is_gdf_taxid_valid: ' || 'Not running Global Validation, JG_GLOBE_FLEX_VAL NOT installed.');

439:
440: WHEN NO_DATA_FOUND THEN
441: /* Always return TRUE if JG is not installed */
442: IF PG_DEBUG in ('Y', 'C') THEN
443: arp_standard.debug('is_gdf_taxid_valid: ' || 'Not running Global Validation, JG_GLOBE_FLEX_VAL NOT installed.');
444: arp_standard.debug('is_gdf_taxid_valid: ' || cr || 'Global Descr Flex Field Validation end: '
445: || to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
446: END IF;
447: return(TRUE);

Line 444: arp_standard.debug('is_gdf_taxid_valid: ' || cr || 'Global Descr Flex Field Validation end: '

440: WHEN NO_DATA_FOUND THEN
441: /* Always return TRUE if JG is not installed */
442: IF PG_DEBUG in ('Y', 'C') THEN
443: arp_standard.debug('is_gdf_taxid_valid: ' || 'Not running Global Validation, JG_GLOBE_FLEX_VAL NOT installed.');
444: arp_standard.debug('is_gdf_taxid_valid: ' || cr || 'Global Descr Flex Field Validation end: '
445: || to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
446: END IF;
447: return(TRUE);
448:

Line 451: arp_standard.debug(cr|| 'Exception in AR_GDF_VALIDATION.is_gdf_taxid_valid()');

447: return(TRUE);
448:
449: WHEN OTHERS THEN
450: IF PG_DEBUG in ('Y', 'C') THEN
451: arp_standard.debug(cr|| 'Exception in AR_GDF_VALIDATION.is_gdf_taxid_valid()');
452: arp_standard.debug('is_gdf_taxid_valid: ' || SQLERRM);
453: arp_standard.debug('is_gdf_taxid_valid: ' || cr || 'Global Descr Flex Field Validation end: '
454: || to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
455: END IF;

Line 452: arp_standard.debug('is_gdf_taxid_valid: ' || SQLERRM);

448:
449: WHEN OTHERS THEN
450: IF PG_DEBUG in ('Y', 'C') THEN
451: arp_standard.debug(cr|| 'Exception in AR_GDF_VALIDATION.is_gdf_taxid_valid()');
452: arp_standard.debug('is_gdf_taxid_valid: ' || SQLERRM);
453: arp_standard.debug('is_gdf_taxid_valid: ' || cr || 'Global Descr Flex Field Validation end: '
454: || to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
455: END IF;
456: return(FALSE);

Line 453: arp_standard.debug('is_gdf_taxid_valid: ' || cr || 'Global Descr Flex Field Validation end: '

449: WHEN OTHERS THEN
450: IF PG_DEBUG in ('Y', 'C') THEN
451: arp_standard.debug(cr|| 'Exception in AR_GDF_VALIDATION.is_gdf_taxid_valid()');
452: arp_standard.debug('is_gdf_taxid_valid: ' || SQLERRM);
453: arp_standard.debug('is_gdf_taxid_valid: ' || cr || 'Global Descr Flex Field Validation end: '
454: || to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
455: END IF;
456: return(FALSE);
457:

Line 524: --arp_standard.enable_debug;

520: l_user_schema VARCHAR2(30) := USER;
521:
522: BEGIN
523:
524: --arp_standard.enable_debug;
525:
526: IF PG_DEBUG in ('Y', 'C') THEN
527: arp_standard.debug('is_cust_imp_valid: ' || cr || 'Global Descr Flex Field Validation begin: ' ||
528: to_char(sysdate, 'DD-MON-YY HH:MI:SS'));

Line 527: arp_standard.debug('is_cust_imp_valid: ' || cr || 'Global Descr Flex Field Validation begin: ' ||

523:
524: --arp_standard.enable_debug;
525:
526: IF PG_DEBUG in ('Y', 'C') THEN
527: arp_standard.debug('is_cust_imp_valid: ' || cr || 'Global Descr Flex Field Validation begin: ' ||
528: to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
529: END IF;
530:
531: /* Check if JG_GLOBE_FLEX_VAL package is installed */

Line 542: arp_standard.debug('is_cust_imp_valid: ' || cr || 'Package: JG_GLOBE_FLEX_VAL is installed.');

538: AND type = 'PACKAGE BODY'
539: AND owner = l_user_schema;
540:
541: IF PG_DEBUG in ('Y', 'C') THEN
542: arp_standard.debug('is_cust_imp_valid: ' || cr || 'Package: JG_GLOBE_FLEX_VAL is installed.');
543: END IF;
544:
545: /* JG_GLOBE_FLEX_VAL package is installed, so OK to call it */
546:

Line 617: arp_standard.debug('is_cust_imp_valid: ' || cr||'Executing Statement:'||cr||cr||sqlstmt);

613: end if;
614: dbms_sql.parse(lcursor, sqlstmt, dbms_sql.native);
615:
616: IF PG_DEBUG in ('Y', 'C') THEN
617: arp_standard.debug('is_cust_imp_valid: ' || cr||'Executing Statement:'||cr||cr||sqlstmt);
618: END IF;
619:
620: lignore := dbms_sql.execute(lcursor);
621:

Line 627: arp_standard.debug('is_cust_imp_valid: ' || cr|| 'Exception calling JG_GLOBE_FLEX_VAL.ar_cust_interface()');

623:
624: EXCEPTION
625: when OTHERS then
626: IF PG_DEBUG in ('Y', 'C') THEN
627: arp_standard.debug('is_cust_imp_valid: ' || cr|| 'Exception calling JG_GLOBE_FLEX_VAL.ar_cust_interface()');
628: arp_standard.debug('is_cust_imp_valid: ' || SQLERRM);
629: END IF;
630:
631: IF dbms_sql.is_open(lcursor)

Line 628: arp_standard.debug('is_cust_imp_valid: ' || SQLERRM);

624: EXCEPTION
625: when OTHERS then
626: IF PG_DEBUG in ('Y', 'C') THEN
627: arp_standard.debug('is_cust_imp_valid: ' || cr|| 'Exception calling JG_GLOBE_FLEX_VAL.ar_cust_interface()');
628: arp_standard.debug('is_cust_imp_valid: ' || SQLERRM);
629: END IF;
630:
631: IF dbms_sql.is_open(lcursor)
632: THEN

Line 636: arp_standard.debug('is_cust_imp_valid: ' || cr || 'Global Descr Flex Field Validation end: '

632: THEN
633: dbms_sql.close_cursor(lcursor);
634: END IF;
635: IF PG_DEBUG in ('Y', 'C') THEN
636: arp_standard.debug('is_cust_imp_valid: ' || cr || 'Global Descr Flex Field Validation end: '
637: || to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
638: END IF;
639:
640: return(FALSE);

Line 645: arp_standard.debug('is_cust_imp_valid: ' || cr || 'Global Descr Flex Field Validation end: ' ||

641: END;
642:
643:
644: IF PG_DEBUG in ('Y', 'C') THEN
645: arp_standard.debug('is_cust_imp_valid: ' || cr || 'Global Descr Flex Field Validation end: ' ||
646: to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
647: END IF;
648:
649: return(TRUE);

Line 656: arp_standard.debug('is_cust_imp_valid: ' || 'Not running Global Validation, JG_GLOBE_FLEX_VAL NOT installed.');

652:
653: WHEN NO_DATA_FOUND THEN
654: /* Always return TRUE if JG is not installed */
655: IF PG_DEBUG in ('Y', 'C') THEN
656: arp_standard.debug('is_cust_imp_valid: ' || 'Not running Global Validation, JG_GLOBE_FLEX_VAL NOT installed.');
657: arp_standard.debug('is_cust_imp_valid: ' || cr || 'Global Descr Flex Field Validation end: '
658: || to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
659: END IF;
660: return(TRUE);

Line 657: arp_standard.debug('is_cust_imp_valid: ' || cr || 'Global Descr Flex Field Validation end: '

653: WHEN NO_DATA_FOUND THEN
654: /* Always return TRUE if JG is not installed */
655: IF PG_DEBUG in ('Y', 'C') THEN
656: arp_standard.debug('is_cust_imp_valid: ' || 'Not running Global Validation, JG_GLOBE_FLEX_VAL NOT installed.');
657: arp_standard.debug('is_cust_imp_valid: ' || cr || 'Global Descr Flex Field Validation end: '
658: || to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
659: END IF;
660: return(TRUE);
661:

Line 664: arp_standard.debug(cr|| 'Exception in AR_GDF_VALIDATION.is_cust_imp_valid()');

660: return(TRUE);
661:
662: WHEN OTHERS THEN
663: IF PG_DEBUG in ('Y', 'C') THEN
664: arp_standard.debug(cr|| 'Exception in AR_GDF_VALIDATION.is_cust_imp_valid()');
665: arp_standard.debug('is_cust_imp_valid: ' || SQLERRM);
666: arp_standard.debug('is_cust_imp_valid: ' || cr || 'Global Descr Flex Field Validation end: '
667: || to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
668: END IF;

Line 665: arp_standard.debug('is_cust_imp_valid: ' || SQLERRM);

661:
662: WHEN OTHERS THEN
663: IF PG_DEBUG in ('Y', 'C') THEN
664: arp_standard.debug(cr|| 'Exception in AR_GDF_VALIDATION.is_cust_imp_valid()');
665: arp_standard.debug('is_cust_imp_valid: ' || SQLERRM);
666: arp_standard.debug('is_cust_imp_valid: ' || cr || 'Global Descr Flex Field Validation end: '
667: || to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
668: END IF;
669: return(FALSE);

Line 666: arp_standard.debug('is_cust_imp_valid: ' || cr || 'Global Descr Flex Field Validation end: '

662: WHEN OTHERS THEN
663: IF PG_DEBUG in ('Y', 'C') THEN
664: arp_standard.debug(cr|| 'Exception in AR_GDF_VALIDATION.is_cust_imp_valid()');
665: arp_standard.debug('is_cust_imp_valid: ' || SQLERRM);
666: arp_standard.debug('is_cust_imp_valid: ' || cr || 'Global Descr Flex Field Validation end: '
667: || to_char(sysdate, 'DD-MON-YY HH:MI:SS'));
668: END IF;
669: return(FALSE);
670:

Line 716: arp_standard.debug('ar_gdf_validation.copy_gdf_attributes()+');

712: l_return_value NUMBER;
713: BEGIN
714:
715: IF PG_DEBUG in ('Y', 'C') THEN
716: arp_standard.debug('ar_gdf_validation.copy_gdf_attributes()+');
717: END IF;
718:
719: /* Check if JL_BR_SPED_PKG package is installed. */
720:

Line 726: arp_standard.debug('copy_gdf_attributes: Package: JL_BR_SPED_PKG is installed.');

722: g_jgzz_product_code := FND_PROFILE.value('JGZZ_PRODUCT_CODE');
723: IF g_jgzz_product_code IS NOT NULL THEN
724:
725: IF PG_DEBUG in ('Y', 'C') THEN
726: arp_standard.debug('copy_gdf_attributes: Package: JL_BR_SPED_PKG is installed.');
727: END IF;
728:
729: /* JL_BR_SPED_PKG package is installed, so OK to call the package. */
730:

Line 744: arp_standard.debug('copy_gdf_attributes: Executing Statement: '||sqlstmt);

740: dbms_sql.bind_variable(lcursor, ':p_called_from', p_called_from);
741: dbms_sql.bind_variable(lcursor, ':l_return_value', l_return_value);
742:
743: IF PG_DEBUG in ('Y', 'C') THEN
744: arp_standard.debug('copy_gdf_attributes: Executing Statement: '||sqlstmt);
745: END IF;
746:
747: lignore := dbms_sql.execute(lcursor);
748: dbms_sql.close_cursor(lcursor);

Line 753: arp_standard.debug('copy_gdf_attributes: Exception calling BEGIN JL_BR_SPED_PKG.copy_gdf_attributes.');

749:
750: EXCEPTION
751: WHEN OTHERS THEN
752: IF PG_DEBUG in ('Y', 'C') THEN
753: arp_standard.debug('copy_gdf_attributes: Exception calling BEGIN JL_BR_SPED_PKG.copy_gdf_attributes.');
754: arp_standard.debug('copy_gdf_attributes: ' || SQLERRM);
755: l_error := SQLERRM;
756: arp_standard.debug('ar_gdf_validation.copy_gdf_attributes()-');
757: END IF;

Line 754: arp_standard.debug('copy_gdf_attributes: ' || SQLERRM);

750: EXCEPTION
751: WHEN OTHERS THEN
752: IF PG_DEBUG in ('Y', 'C') THEN
753: arp_standard.debug('copy_gdf_attributes: Exception calling BEGIN JL_BR_SPED_PKG.copy_gdf_attributes.');
754: arp_standard.debug('copy_gdf_attributes: ' || SQLERRM);
755: l_error := SQLERRM;
756: arp_standard.debug('ar_gdf_validation.copy_gdf_attributes()-');
757: END IF;
758: IF dbms_sql.is_open(lcursor)

Line 756: arp_standard.debug('ar_gdf_validation.copy_gdf_attributes()-');

752: IF PG_DEBUG in ('Y', 'C') THEN
753: arp_standard.debug('copy_gdf_attributes: Exception calling BEGIN JL_BR_SPED_PKG.copy_gdf_attributes.');
754: arp_standard.debug('copy_gdf_attributes: ' || SQLERRM);
755: l_error := SQLERRM;
756: arp_standard.debug('ar_gdf_validation.copy_gdf_attributes()-');
757: END IF;
758: IF dbms_sql.is_open(lcursor)
759: THEN
760: dbms_sql.close_cursor(lcursor);

Line 767: arp_standard.debug('ar_gdf_validation.copy_gdf_attributes()-');

763:
764: END IF ;
765:
766: IF PG_DEBUG in ('Y', 'C') THEN
767: arp_standard.debug('ar_gdf_validation.copy_gdf_attributes()-');
768: END IF;
769:
770: EXCEPTION
771: WHEN OTHERS THEN

Line 773: arp_standard.debug('copy_gdf_attributes: Exception calling BEGIN JL_BR_SPED_PKG.copy_gdf_attributes.');

769:
770: EXCEPTION
771: WHEN OTHERS THEN
772: IF PG_DEBUG in ('Y', 'C') THEN
773: arp_standard.debug('copy_gdf_attributes: Exception calling BEGIN JL_BR_SPED_PKG.copy_gdf_attributes.');
774: arp_standard.debug('copy_gdf_attributes: ' || SQLERRM);
775: arp_standard.debug('ar_gdf_validation.copy_gdf_attributes()-');
776: END IF;
777: END copy_gdf_attributes;

Line 774: arp_standard.debug('copy_gdf_attributes: ' || SQLERRM);

770: EXCEPTION
771: WHEN OTHERS THEN
772: IF PG_DEBUG in ('Y', 'C') THEN
773: arp_standard.debug('copy_gdf_attributes: Exception calling BEGIN JL_BR_SPED_PKG.copy_gdf_attributes.');
774: arp_standard.debug('copy_gdf_attributes: ' || SQLERRM);
775: arp_standard.debug('ar_gdf_validation.copy_gdf_attributes()-');
776: END IF;
777: END copy_gdf_attributes;
778:

Line 775: arp_standard.debug('ar_gdf_validation.copy_gdf_attributes()-');

771: WHEN OTHERS THEN
772: IF PG_DEBUG in ('Y', 'C') THEN
773: arp_standard.debug('copy_gdf_attributes: Exception calling BEGIN JL_BR_SPED_PKG.copy_gdf_attributes.');
774: arp_standard.debug('copy_gdf_attributes: ' || SQLERRM);
775: arp_standard.debug('ar_gdf_validation.copy_gdf_attributes()-');
776: END IF;
777: END copy_gdf_attributes;
778:
779: