[Home] [Help]
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')
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,
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,
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;
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
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,
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,
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;
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
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,
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,
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;
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;
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;
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;
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;
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;
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;