DBA Data[Home] [Help]

APPS.GCS_WF_NTF_PKG dependencies on GCS_UTILITY_PKG

Line 58: gcs_utility_pkg.g_module_enter

54:
55: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
56: fnd_log.STRING (fnd_log.level_procedure,
57: g_pkg_name || '.' || l_api_name,
58: gcs_utility_pkg.g_module_enter
59: || ' p_cons_detail_id = '
60: || p_cons_detail_id
61: || ' '
62: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')

Line 66: l_entity_contact_attr := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ENTITY_CONTACT').attribute_id;

62: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
63: );
64: END IF;
65:
66: l_entity_contact_attr := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ENTITY_CONTACT').attribute_id;
67: l_entity_contact_ver := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ENTITY_CONTACT').version_id;
68:
69: -- bug fix 5109610: change joins of fnd_lookup_values to gcs_data_types_b/tl for balance_type_code
70: SELECT fet_cons.entity_name,

Line 67: l_entity_contact_ver := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ENTITY_CONTACT').version_id;

63: );
64: END IF;
65:
66: l_entity_contact_attr := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ENTITY_CONTACT').attribute_id;
67: l_entity_contact_ver := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ENTITY_CONTACT').version_id;
68:
69: -- bug fix 5109610: change joins of fnd_lookup_values to gcs_data_types_b/tl for balance_type_code
70: SELECT fet_cons.entity_name,
71: fet_cons.entity_id,

Line 227: gcs_utility_pkg.g_module_success

223:
224: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
225: fnd_log.STRING (fnd_log.level_procedure,
226: g_pkg_name || '.' || l_api_name,
227: gcs_utility_pkg.g_module_success
228: || ' '
229: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
230: );
231: END IF;

Line 261: gcs_utility_pkg.g_module_enter

257:
258: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
259: fnd_log.STRING (fnd_log.level_procedure,
260: g_pkg_name || '.' || l_api_name,
261: gcs_utility_pkg.g_module_enter
262: || ' p_run_name = '
263: || p_run_name
264: || ', p_cons_entity_id = '
265: || p_cons_entity_id

Line 275: l_entity_contact_attr := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ENTITY_CONTACT').attribute_id;

271: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
272: );
273: END IF;
274:
275: l_entity_contact_attr := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ENTITY_CONTACT').attribute_id;
276: l_entity_contact_ver := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ENTITY_CONTACT').version_id;
277: -- bug fix 5109610: change joins of fnd_lookup_values to gcs_data_types_b/tl for balance_type_code
278: SELECT fet_cons.entity_name,
279: gdtct.data_type_name,

Line 276: l_entity_contact_ver := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ENTITY_CONTACT').version_id;

272: );
273: END IF;
274:
275: l_entity_contact_attr := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ENTITY_CONTACT').attribute_id;
276: l_entity_contact_ver := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ENTITY_CONTACT').version_id;
277: -- bug fix 5109610: change joins of fnd_lookup_values to gcs_data_types_b/tl for balance_type_code
278: SELECT fet_cons.entity_name,
279: gdtct.data_type_name,
280: fcpt.cal_period_name,

Line 357: gcs_utility_pkg.g_module_success

353:
354: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
355: fnd_log.STRING (fnd_log.level_procedure,
356: g_pkg_name || '.' || l_api_name,
357: gcs_utility_pkg.g_module_success
358: || ' '
359: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
360: );
361: END IF;

Line 385: gcs_utility_pkg.g_module_enter

381:
382: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
383: fnd_log.STRING (fnd_log.level_procedure,
384: g_pkg_name || '.' || l_api_name,
385: gcs_utility_pkg.g_module_enter
386: || ' p_run_name = '
387: || p_run_name
388: || ', p_cons_entity_id = '
389: || p_cons_entity_id

Line 395: l_entity_contact_attr := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ENTITY_CONTACT').attribute_id;

391: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
392: );
393: END IF;
394:
395: l_entity_contact_attr := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ENTITY_CONTACT').attribute_id;
396: l_entity_contact_ver := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ENTITY_CONTACT').version_id;
397: -- bug fix 5109610: change joins of fnd_lookup_values to gcs_data_types_b/tl for balance_type_code
398: SELECT fet_cons.entity_name,
399: gdtct.data_type_name,

Line 396: l_entity_contact_ver := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ENTITY_CONTACT').version_id;

392: );
393: END IF;
394:
395: l_entity_contact_attr := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ENTITY_CONTACT').attribute_id;
396: l_entity_contact_ver := gcs_utility_pkg.g_dimension_attr_info('ENTITY_ID-ENTITY_CONTACT').version_id;
397: -- bug fix 5109610: change joins of fnd_lookup_values to gcs_data_types_b/tl for balance_type_code
398: SELECT fet_cons.entity_name,
399: gdtct.data_type_name,
400: fcpt.cal_period_name,

Line 467: gcs_utility_pkg.g_module_success

463:
464: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
465: fnd_log.STRING (fnd_log.level_procedure,
466: g_pkg_name || '.' || l_api_name,
467: gcs_utility_pkg.g_module_success
468: || ' '
469: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
470: );
471: END IF;

Line 490: gcs_utility_pkg.g_module_enter

486:
487: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
488: fnd_log.STRING (fnd_log.level_procedure,
489: g_pkg_name || '.' || l_api_name,
490: gcs_utility_pkg.g_module_enter
491: || ' '
492: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
493: );
494: END IF;

Line 507: gcs_utility_pkg.g_module_success

503:
504: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
505: fnd_log.STRING (fnd_log.level_procedure,
506: g_pkg_name || '.' || l_api_name,
507: gcs_utility_pkg.g_module_success
508: || ' '
509: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
510: );
511: END IF;

Line 530: gcs_utility_pkg.g_module_enter

526:
527: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
528: fnd_log.STRING (fnd_log.level_procedure,
529: g_pkg_name || '.' || l_api_name,
530: gcs_utility_pkg.g_module_enter
531: || ' '
532: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
533: );
534: END IF;

Line 547: gcs_utility_pkg.g_module_success

543:
544: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
545: fnd_log.STRING (fnd_log.level_procedure,
546: g_pkg_name || '.' || l_api_name,
547: gcs_utility_pkg.g_module_success
548: || ' '
549: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
550: );
551: END IF;

Line 579: gcs_utility_pkg.g_module_enter

575:
576: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
577: fnd_log.STRING (fnd_log.level_procedure,
578: g_pkg_name || '.' || l_api_name,
579: gcs_utility_pkg.g_module_enter
580: || ' '
581: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
582: );
583: END IF;

Line 605: gcs_utility_pkg.g_module_success

601:
602: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
603: fnd_log.STRING (fnd_log.level_procedure,
604: g_pkg_name || '.' || l_api_name,
605: gcs_utility_pkg.g_module_success
606: || ' '
607: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
608: );
609: END IF;