APPS.QP_PS_ATTR_GRP_PVT dependencies on QP_PS_ATTR_GRP_PVT

Line 1: PACKAGE BODY QP_PS_ATTR_GRP_PVT AS

1: PACKAGE BODY QP_PS_ATTR_GRP_PVT AS
2: /* $Header: QPXPATGB.pls 120.6 2011/07/12 10:11:26 dnema noship $ */
3:
4: G_LINES_PER_INSERT CONSTANT NUMBER := 5000;
5:

Line 169: l_routine VARCHAR2(240):='Routine : QP_PS_ATTR_GRP_PVT.update_pattern_phases';

165:
166: l_old_start_date DATE := NULL;
167: l_old_end_date DATE := NULL;
168: l_old_active_flag VARCHAR2(1) := NULL;
169: l_routine VARCHAR2(240):='Routine : QP_PS_ATTR_GRP_PVT.update_pattern_phases';
170:
171: BEGIN
172:
173: IF p_min_list_line_id IS NOT NULL -- IF 1

Line 401: oe_debug_pub.add('QP_PS_ATTR_GRP_PVT.update_pattern_phases ' || SQLERRM);

397: CLOSE pat_phases_dates_flags_prl_all;
398: END if;
399:
400: if g_call_from_setup = 'Y' THEN
401: oe_debug_pub.add('QP_PS_ATTR_GRP_PVT.update_pattern_phases ' || SQLERRM);
402: else
403: write_log( 'QP_PS_ATTR_GRP_PVT.update_pattern_phases ' || SQLERRM );
404: end if;
405:

Line 403: write_log( 'QP_PS_ATTR_GRP_PVT.update_pattern_phases ' || SQLERRM );

399:
400: if g_call_from_setup = 'Y' THEN
401: oe_debug_pub.add('QP_PS_ATTR_GRP_PVT.update_pattern_phases ' || SQLERRM);
402: else
403: write_log( 'QP_PS_ATTR_GRP_PVT.update_pattern_phases ' || SQLERRM );
404: end if;
405:
406: END update_pattern_phases;
407:

Line 5353: FND_FILE.PUT_LINE( FND_FILE.LOG, 'QP_PS_ATTR_GRP_PVT.Set_Debug: Invalid value of p_debug. Value should be either Y or N' );

5349: IS
5350: BEGIN
5351: IF UPPER(p_debug) NOT IN (G_PAT_DEBUG_ON, G_PAT_DEBUG_OFF)
5352: THEN
5353: FND_FILE.PUT_LINE( FND_FILE.LOG, 'QP_PS_ATTR_GRP_PVT.Set_Debug: Invalid value of p_debug. Value should be either Y or N' );
5354: ELSE
5355: G_QP_DEBUG := UPPER(p_debug);
5356: END IF;
5357: END Set_Debug;

Line 5359: end QP_PS_ATTR_GRP_PVT; -- end package

5355: G_QP_DEBUG := UPPER(p_debug);
5356: END IF;
5357: END Set_Debug;
5358:
5359: end QP_PS_ATTR_GRP_PVT; -- end package