DBA Data[Home] [Help]

APPS.AR_GDF_VALIDATION dependencies on JL_ZZ_POSTBATCH

Line 176: | JL_ZZ_POSTBATCH is installed only when JL is installed. |

172: | This is a stub module for global descriptive flex field validation |
173: | during postbatch run. |
174: | |
175: | The global descriptive flex field validation package |
176: | JL_ZZ_POSTBATCH is installed only when JL is installed. |
177: | |
178: | ARGUMENTS |
179: | batch_id IN NUMBER |
180: | cash_receipt_id IN NUMBER |

Line 228: /* Check if JL_ZZ_POSTBATCH package is installed */

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 */
229: /* If JL_ZZ_POSTBATCH is not installed, handle it in the exception */
230: /***
231: SELECT distinct 1
232: INTO is_there

Line 229: /* If JL_ZZ_POSTBATCH is not installed, handle it in the exception */

225: 'cash_receipt_id= ' || cash_receipt_id);
226: END IF;
227:
228: /* Check if JL_ZZ_POSTBATCH package is installed */
229: /* If JL_ZZ_POSTBATCH is not installed, handle it in the exception */
230: /***
231: SELECT distinct 1
232: INTO is_there
233: FROM all_source

Line 234: WHERE name = 'JL_ZZ_POSTBATCH'

230: /***
231: SELECT distinct 1
232: INTO is_there
233: FROM all_source
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.');

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 242: /* JL_ZZ_POSTBATCH package is installed, so OK to call it */

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 */
243:
244: IF g_jgzz_product_code = 'JL' THEN
245:
246: BEGIN

Line 247: JL_ZZ_POSTBATCH.populate_gdfs(p_cash_receipt_id=>cash_receipt_id,

243:
244: IF g_jgzz_product_code = 'JL' THEN
245:
246: BEGIN
247: JL_ZZ_POSTBATCH.populate_gdfs(p_cash_receipt_id=>cash_receipt_id,
248: p_batch_id=>batch_id);
249:
250: EXCEPTION
251: when OTHERS then

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 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);