DBA Data[Home] [Help]

APPS.QA_PARENT_CHILD_PKG dependencies on FND_LOG

Line 3666: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

3662: agg_val VARCHAR2(4000);
3663:
3664: BEGIN
3665:
3666: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
3667: FND_LOG.string
3668: (
3669: FND_LOG.level_procedure,
3670: g_pkg_name || '.' || l_api_name,

Line 3667: FND_LOG.string

3663:
3664: BEGIN
3665:
3666: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
3667: FND_LOG.string
3668: (
3669: FND_LOG.level_procedure,
3670: g_pkg_name || '.' || l_api_name,
3671: 'ENTERING PROCEDURE: P_PLAN_ID: ' || p_plan_id || ' P_COLLECTION_ID: ' || p_collection_id || ' P_OCCURRENCE: ' || p_occurrence || ' P_ENABLED: ' || p_enabled

Line 3669: FND_LOG.level_procedure,

3665:
3666: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
3667: FND_LOG.string
3668: (
3669: FND_LOG.level_procedure,
3670: g_pkg_name || '.' || l_api_name,
3671: 'ENTERING PROCEDURE: P_PLAN_ID: ' || p_plan_id || ' P_COLLECTION_ID: ' || p_collection_id || ' P_OCCURRENCE: ' || p_occurrence || ' P_ENABLED: ' || p_enabled
3672: );
3673: END IF;

Line 3680: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

3676: WHERE occurrence = p_occurrence
3677: AND plan_id = p_plan_id
3678: AND collection_id = p_collection_id;
3679:
3680: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
3681: FND_LOG.string
3682: (
3683: FND_LOG.level_statement,
3684: g_pkg_name || '.' || l_api_name,

Line 3681: FND_LOG.string

3677: AND plan_id = p_plan_id
3678: AND collection_id = p_collection_id;
3679:
3680: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
3681: FND_LOG.string
3682: (
3683: FND_LOG.level_statement,
3684: g_pkg_name || '.' || l_api_name,
3685: 'DELETED ROW IN QA RESULTS. GETTING PARENT'

Line 3683: FND_LOG.level_statement,

3679:
3680: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
3681: FND_LOG.string
3682: (
3683: FND_LOG.level_statement,
3684: g_pkg_name || '.' || l_api_name,
3685: 'DELETED ROW IN QA RESULTS. GETTING PARENT'
3686: );
3687: END IF;

Line 3699: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

3695: FETCH C1 INTO l_parent_plan_id,l_parent_collection_id,l_parent_occurrence;
3696: CLOSE C1;
3697:
3698: IF ( l_parent_plan_id IS NOT NULL ) THEN
3699: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
3700: FND_LOG.string
3701: (
3702: FND_LOG.level_statement,
3703: g_pkg_name || '.' || l_api_name,

Line 3700: FND_LOG.string

3696: CLOSE C1;
3697:
3698: IF ( l_parent_plan_id IS NOT NULL ) THEN
3699: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
3700: FND_LOG.string
3701: (
3702: FND_LOG.level_statement,
3703: g_pkg_name || '.' || l_api_name,
3704: 'BEFORE DELETING RELATIONSHIP ROW FOR CHILD'

Line 3702: FND_LOG.level_statement,

3698: IF ( l_parent_plan_id IS NOT NULL ) THEN
3699: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
3700: FND_LOG.string
3701: (
3702: FND_LOG.level_statement,
3703: g_pkg_name || '.' || l_api_name,
3704: 'BEFORE DELETING RELATIONSHIP ROW FOR CHILD'
3705: );
3706: END IF;

Line 3714: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN

3710: p_child_plan_id => p_plan_id,
3711: p_child_occurrence => p_occurrence
3712: );
3713:
3714: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
3715: FND_LOG.string
3716: (
3717: FND_LOG.level_statement,
3718: g_pkg_name || '.' || l_api_name,

Line 3715: FND_LOG.string

3711: p_child_occurrence => p_occurrence
3712: );
3713:
3714: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
3715: FND_LOG.string
3716: (
3717: FND_LOG.level_statement,
3718: g_pkg_name || '.' || l_api_name,
3719: 'BEFORE UPDATING PARENT FOR AGGREGATION PLAN_ID: ' || l_parent_plan_id || ' COLLECTION_ID: ' || l_parent_collection_id || ' OCCURRENCE: ' || l_parent_occurrence || ' FOR AGGREGATION '

Line 3717: FND_LOG.level_statement,

3713:
3714: IF ( FND_LOG.level_statement >= FND_LOG.g_current_runtime_level ) THEN
3715: FND_LOG.string
3716: (
3717: FND_LOG.level_statement,
3718: g_pkg_name || '.' || l_api_name,
3719: 'BEFORE UPDATING PARENT FOR AGGREGATION PLAN_ID: ' || l_parent_plan_id || ' COLLECTION_ID: ' || l_parent_collection_id || ' OCCURRENCE: ' || l_parent_occurrence || ' FOR AGGREGATION '
3720: );
3721: END IF;

Line 3742: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

3738: x_agg_val => agg_val
3739: );
3740: END IF;
3741:
3742: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
3743: FND_LOG.string
3744: (
3745: FND_LOG.level_procedure,
3746: g_pkg_name || '.' || l_api_name,

Line 3743: FND_LOG.string

3739: );
3740: END IF;
3741:
3742: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
3743: FND_LOG.string
3744: (
3745: FND_LOG.level_procedure,
3746: g_pkg_name || '.' || l_api_name,
3747: 'EXITING PROCEDURE: SUCCESS'

Line 3745: FND_LOG.level_procedure,

3741:
3742: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
3743: FND_LOG.string
3744: (
3745: FND_LOG.level_procedure,
3746: g_pkg_name || '.' || l_api_name,
3747: 'EXITING PROCEDURE: SUCCESS'
3748: );
3749: END IF;

Line 3833: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

3829: p_error_text => SUBSTR(SQLERRM,1,240)
3830: );
3831: END IF;
3832:
3833: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
3834: FND_LOG.string
3835: (
3836: FND_LOG.level_procedure,
3837: g_pkg_name || '.' || l_api_name,

Line 3834: FND_LOG.string

3830: );
3831: END IF;
3832:
3833: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
3834: FND_LOG.string
3835: (
3836: FND_LOG.level_procedure,
3837: g_pkg_name || '.' || l_api_name,
3838: 'EXITING PROCEDURE: ERROR'

Line 3836: FND_LOG.level_procedure,

3832:
3833: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
3834: FND_LOG.string
3835: (
3836: FND_LOG.level_procedure,
3837: g_pkg_name || '.' || l_api_name,
3838: 'EXITING PROCEDURE: ERROR'
3839: );
3840: END IF;

Line 3946: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

3942: p_error_text => SUBSTR(SQLERRM,1,240)
3943: );
3944: END IF;
3945:
3946: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
3947: FND_LOG.string
3948: (
3949: FND_LOG.level_procedure,
3950: g_pkg_name || '.' || l_api_name,

Line 3947: FND_LOG.string

3943: );
3944: END IF;
3945:
3946: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
3947: FND_LOG.string
3948: (
3949: FND_LOG.level_procedure,
3950: g_pkg_name || '.' || l_api_name,
3951: 'EXITING PROCEDURE: ERROR'

Line 3949: FND_LOG.level_procedure,

3945:
3946: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
3947: FND_LOG.string
3948: (
3949: FND_LOG.level_procedure,
3950: g_pkg_name || '.' || l_api_name,
3951: 'EXITING PROCEDURE: ERROR'
3952: );
3953: END IF;

Line 4097: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN

4093: p_error_text => SUBSTR(SQLERRM,1,240)
4094: );
4095: END IF;
4096:
4097: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
4098: FND_LOG.string
4099: (
4100: FND_LOG.level_procedure,
4101: g_pkg_name || '.' || l_api_name,

Line 4098: FND_LOG.string

4094: );
4095: END IF;
4096:
4097: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
4098: FND_LOG.string
4099: (
4100: FND_LOG.level_procedure,
4101: g_pkg_name || '.' || l_api_name,
4102: 'EXITING PROCEDURE: ERROR'

Line 4100: FND_LOG.level_procedure,

4096:
4097: IF ( FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level ) THEN
4098: FND_LOG.string
4099: (
4100: FND_LOG.level_procedure,
4101: g_pkg_name || '.' || l_api_name,
4102: 'EXITING PROCEDURE: ERROR'
4103: );
4104: END IF;