eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_PRICE_LIST_LINE_UTIL dependencies on FND_MESSAGE

Line 923: --fnd_message.debug('gm before new code');

919: --IF not p_PRICE_LIST_LINE_rec.list_line_type_code = 'PHB'
920: --then null;
921: --else
922:
923: --fnd_message.debug('gm before new code');
924: oe_debug_pub.add('gm before new code');
925:
926: IF NOT (QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.price_break_type_code,p_old_PRICE_LIST_LINE_rec.price_break_type_code)
927: and QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.arithmetic_operator,p_old_PRICE_LIST_LINE_rec.arithmetic_operator))

Line 942: --fnd_message.debug('gm after new code');

938: -- END IF;
939: oe_debug_pub.add('gm after new code');
940:
941:
942: --fnd_message.debug('gm after new code');
943:
944:
945: IF NOT QP_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.price_by_formula_id,p_old_PRICE_LIST_LINE_rec.price_by_formula_id)
946: THEN

Line 3062: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');

3058:
3059: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
3060: THEN
3061:
3062: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
3063: oe_msg_pub.Add;
3064:
3065: END IF;
3066:

Line 3079: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');

3075:
3076: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
3077: THEN
3078:
3079: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
3080: oe_msg_pub.Add;
3081:
3082: END IF;
3083: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

Line 3091: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');

3087:
3088: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
3089: THEN
3090:
3091: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
3092: oe_msg_pub.Add;
3093:
3094: END IF;
3095: WHEN OTHERS THEN

Line 3357: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');

3353:
3354: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3355: THEN
3356:
3357: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3358: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accrual_uom');
3359: oe_msg_pub.Add;
3360:
3361: END IF;

Line 3358: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accrual_uom');

3354: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3355: THEN
3356:
3357: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3358: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accrual_uom');
3359: oe_msg_pub.Add;
3360:
3361: END IF;
3362:

Line 3391: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');

3387:
3388: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3389: THEN
3390:
3391: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3392: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','automatic');
3393: oe_msg_pub.Add;
3394:
3395: END IF;

Line 3392: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','automatic');

3388: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3389: THEN
3390:
3391: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3392: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','automatic');
3393: oe_msg_pub.Add;
3394:
3395: END IF;
3396:

Line 3421: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');

3417:
3418: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3419: THEN
3420:
3421: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3422: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','base_uom');
3423: oe_msg_pub.Add;
3424:
3425: END IF;

Line 3422: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','base_uom');

3418: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3419: THEN
3420:
3421: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3422: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','base_uom');
3423: oe_msg_pub.Add;
3424:
3425: END IF;
3426:

Line 3451: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');

3447:
3448: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3449: THEN
3450:
3451: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3452: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','generate_using_formula');
3453: oe_msg_pub.Add;
3454:
3455: END IF;

Line 3452: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','generate_using_formula');

3448: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3449: THEN
3450:
3451: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3452: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','generate_using_formula');
3453: oe_msg_pub.Add;
3454:
3455: END IF;
3456:

Line 3481: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');

3477:
3478: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3479: THEN
3480:
3481: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3482: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item');
3483: oe_msg_pub.Add;
3484:
3485: END IF;

Line 3482: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item');

3478: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3479: THEN
3480:
3481: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3482: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item');
3483: oe_msg_pub.Add;
3484:
3485: END IF;
3486:

Line 3511: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');

3507:
3508: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3509: THEN
3510:
3511: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3512: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');
3513: oe_msg_pub.Add;
3514:
3515: END IF;

Line 3512: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');

3508: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3509: THEN
3510:
3511: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3512: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');
3513: oe_msg_pub.Add;
3514:
3515: END IF;
3516:

Line 3541: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');

3537:
3538: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3539: THEN
3540:
3541: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3542: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line');
3543: oe_msg_pub.Add;
3544:
3545: END IF;

Line 3542: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line');

3538: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3539: THEN
3540:
3541: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3542: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line');
3543: oe_msg_pub.Add;
3544:
3545: END IF;
3546:

Line 3571: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');

3567:
3568: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3569: THEN
3570:
3571: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3572: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line_type');
3573: oe_msg_pub.Add;
3574:
3575: END IF;

Line 3572: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line_type');

3568: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3569: THEN
3570:
3571: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3572: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line_type');
3573: oe_msg_pub.Add;
3574:
3575: END IF;
3576:

Line 3601: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');

3597:
3598: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3599: THEN
3600:
3601: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3602: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','modifier_level');
3603: oe_msg_pub.Add;
3604:
3605: END IF;

Line 3602: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','modifier_level');

3598: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3599: THEN
3600:
3601: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3602: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','modifier_level');
3603: oe_msg_pub.Add;
3604:
3605: END IF;
3606:

Line 3631: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');

3627:
3628: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3629: THEN
3630:
3631: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3632: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','organization');
3633: oe_msg_pub.Add;
3634:
3635: END IF;

Line 3632: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','organization');

3628: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3629: THEN
3630:
3631: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3632: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','organization');
3633: oe_msg_pub.Add;
3634:
3635: END IF;
3636:

Line 3661: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');

3657:
3658: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3659: THEN
3660:
3661: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3662: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override');
3663: oe_msg_pub.Add;
3664:
3665: END IF;

Line 3662: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override');

3658: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3659: THEN
3660:
3661: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3662: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override');
3663: oe_msg_pub.Add;
3664:
3665: END IF;
3666:

Line 3691: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');

3687:
3688: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3689: THEN
3690:
3691: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3692: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_break_type');
3693: oe_msg_pub.Add;
3694:
3695: END IF;

Line 3692: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_break_type');

3688: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3689: THEN
3690:
3691: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3692: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_break_type');
3693: oe_msg_pub.Add;
3694:
3695: END IF;
3696:

Line 3721: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');

3717:
3718: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3719: THEN
3720:
3721: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3722: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_by_formula');
3723: oe_msg_pub.Add;
3724:
3725: END IF;

Line 3722: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_by_formula');

3718: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3719: THEN
3720:
3721: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3722: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_by_formula');
3723: oe_msg_pub.Add;
3724:
3725: END IF;
3726:

Line 3751: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');

3747:
3748: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3749: THEN
3750:
3751: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3752: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','primary_uom');
3753: oe_msg_pub.Add;
3754:
3755: END IF;

Line 3752: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','primary_uom');

3748: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3749: THEN
3750:
3751: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3752: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','primary_uom');
3753: oe_msg_pub.Add;
3754:
3755: END IF;
3756:

Line 3781: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');

3777:
3778: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3779: THEN
3780:
3781: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3782: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','print_on_invoice');
3783: oe_msg_pub.Add;
3784:
3785: END IF;

Line 3782: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','print_on_invoice');

3778: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3779: THEN
3780:
3781: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3782: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','print_on_invoice');
3783: oe_msg_pub.Add;
3784:
3785: END IF;
3786:

Line 3811: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');

3807:
3808: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3809: THEN
3810:
3811: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3812: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rebate_transaction_type');
3813: oe_msg_pub.Add;
3814:
3815: END IF;

Line 3812: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rebate_transaction_type');

3808: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3809: THEN
3810:
3811: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3812: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rebate_transaction_type');
3813: oe_msg_pub.Add;
3814:
3815: END IF;
3816:

Line 3841: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');

3837:
3838: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3839: THEN
3840:
3841: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3842: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','related_item');
3843: oe_msg_pub.Add;
3844:
3845: END IF;

Line 3842: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','related_item');

3838: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3839: THEN
3840:
3841: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3842: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','related_item');
3843: oe_msg_pub.Add;
3844:
3845: END IF;
3846:

Line 3871: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');

3867:
3868: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3869: THEN
3870:
3871: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3872: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','relationship_type');
3873: oe_msg_pub.Add;
3874:
3875: END IF;

Line 3872: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','relationship_type');

3868: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3869: THEN
3870:
3871: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3872: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','relationship_type');
3873: oe_msg_pub.Add;
3874:
3875: END IF;
3876:

Line 3901: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');

3897:
3898: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3899: THEN
3900:
3901: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3902: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reprice');
3903: oe_msg_pub.Add;
3904:
3905: END IF;

Line 3902: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reprice');

3898: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3899: THEN
3900:
3901: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3902: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reprice');
3903: oe_msg_pub.Add;
3904:
3905: END IF;
3906:

Line 3931: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');

3927:
3928: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3929: THEN
3930:
3931: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3932: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','revision_reason');
3933: oe_msg_pub.Add;
3934:
3935: END IF;

Line 3932: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','revision_reason');

3928: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3929: THEN
3930:
3931: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3932: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','revision_reason');
3933: oe_msg_pub.Add;
3934:
3935: END IF;
3936:

Line 4120: --fnd_message.debug('passsed values are ' ||p_FlexField_Name);

4116: x_attribute_code VARCHAR2(240) := NULL;
4117:
4118: BEGIN
4119:
4120: --fnd_message.debug('passsed values are ' ||p_FlexField_Name);
4121: --fnd_message.debug('passsed values are ' ||p_Context_Name);
4122: --fnd_message.debug('passsed values are ' ||p_attribute);
4123:
4124:

Line 4121: --fnd_message.debug('passsed values are ' ||p_Context_Name);

4117:
4118: BEGIN
4119:
4120: --fnd_message.debug('passsed values are ' ||p_FlexField_Name);
4121: --fnd_message.debug('passsed values are ' ||p_Context_Name);
4122: --fnd_message.debug('passsed values are ' ||p_attribute);
4123:
4124:
4125: FND_DFLEX.get_flexfield('QP',p_FlexField_Name,Flexfield,Flexinfo);

Line 4122: --fnd_message.debug('passsed values are ' ||p_attribute);

4118: BEGIN
4119:
4120: --fnd_message.debug('passsed values are ' ||p_FlexField_Name);
4121: --fnd_message.debug('passsed values are ' ||p_Context_Name);
4122: --fnd_message.debug('passsed values are ' ||p_attribute);
4123:
4124:
4125: FND_DFLEX.get_flexfield('QP',p_FlexField_Name,Flexfield,Flexinfo);
4126: FND_DFLEX.get_segments(FND_DFLEX.make_context(Flexfield,p_Context_Name),

Line 4133: --fnd_message.debug('col name is ' ||segments.application_column_name(i));

4129: For i in 1..segments.nsegments LOOP
4130:
4131: IF segments.is_enabled(i) THEN
4132:
4133: --fnd_message.debug('col name is ' ||segments.application_column_name(i));
4134: --fnd_message.debug(' seg name is ' ||segments.segment_name(i));
4135: IF segments.application_column_name(i) = p_attribute Then
4136: x_attribute_code := segments.row_prompt(i);
4137: RETURN x_attribute_code;

Line 4134: --fnd_message.debug(' seg name is ' ||segments.segment_name(i));

4130:
4131: IF segments.is_enabled(i) THEN
4132:
4133: --fnd_message.debug('col name is ' ||segments.application_column_name(i));
4134: --fnd_message.debug(' seg name is ' ||segments.segment_name(i));
4135: IF segments.application_column_name(i) = p_attribute Then
4136: x_attribute_code := segments.row_prompt(i);
4137: RETURN x_attribute_code;
4138: End if;

Line 4255: --fnd_message.debug(x_Vsid);

4251: BEGIN
4252:
4253: QP_UTIL.get_valueset_id(p_FlexField_Name,p_Context_Name,p_Segment_Name,x_Vsid,x_Format_Type,
4254: x_Validation_Type);
4255: --fnd_message.debug(x_Vsid);
4256: --fnd_message.debug(x_Validation_Type);
4257: --fnd_message.show;
4258:
4259: IF x_Validation_Type In('F' ,'I') AND x_Vsid IS NOT NULL THEN

Line 4256: --fnd_message.debug(x_Validation_Type);

4252:
4253: QP_UTIL.get_valueset_id(p_FlexField_Name,p_Context_Name,p_Segment_Name,x_Vsid,x_Format_Type,
4254: x_Validation_Type);
4255: --fnd_message.debug(x_Vsid);
4256: --fnd_message.debug(x_Validation_Type);
4257: --fnd_message.show;
4258:
4259: IF x_Validation_Type In('F' ,'I') AND x_Vsid IS NOT NULL THEN
4260: IF x_Validation_Type = 'I' THEN --Added for 2332139

Line 4257: --fnd_message.show;

4253: QP_UTIL.get_valueset_id(p_FlexField_Name,p_Context_Name,p_Segment_Name,x_Vsid,x_Format_Type,
4254: x_Validation_Type);
4255: --fnd_message.debug(x_Vsid);
4256: --fnd_message.debug(x_Validation_Type);
4257: --fnd_message.show;
4258:
4259: IF x_Validation_Type In('F' ,'I') AND x_Vsid IS NOT NULL THEN
4260: IF x_Validation_Type = 'I' THEN --Added for 2332139
4261: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);

Line 4269: --fnd_message.debug(Value.value);

4265: IF Fmt.Has_Id Then --id is defined.Hence compare for id
4266:
4267: While(Found) Loop
4268:
4269: --fnd_message.debug(Value.value);
4270: --fnd_message.debug(Value.meaning);
4271: --fnd_message.debug(Value.id);
4272:
4273: If p_attr_value = Value.id Then

Line 4270: --fnd_message.debug(Value.meaning);

4266:
4267: While(Found) Loop
4268:
4269: --fnd_message.debug(Value.value);
4270: --fnd_message.debug(Value.meaning);
4271: --fnd_message.debug(Value.id);
4272:
4273: If p_attr_value = Value.id Then
4274:

Line 4271: --fnd_message.debug(Value.id);

4267: While(Found) Loop
4268:
4269: --fnd_message.debug(Value.value);
4270: --fnd_message.debug(Value.meaning);
4271: --fnd_message.debug(Value.id);
4272:
4273: If p_attr_value = Value.id Then
4274:
4275: x_attr_value_code := Value.Value;

Line 4286: --fnd_message.debug(Value.value);

4282: Else
4283:
4284: While(Found) Loop
4285:
4286: --fnd_message.debug(Value.value);
4287: --fnd_message.debug(Value.meaning);
4288: --fnd_message.debug(Value.id);
4289:
4290: If p_attr_value = Value.value Then

Line 4287: --fnd_message.debug(Value.meaning);

4283:
4284: While(Found) Loop
4285:
4286: --fnd_message.debug(Value.value);
4287: --fnd_message.debug(Value.meaning);
4288: --fnd_message.debug(Value.id);
4289:
4290: If p_attr_value = Value.value Then
4291:

Line 4288: --fnd_message.debug(Value.id);

4284: While(Found) Loop
4285:
4286: --fnd_message.debug(Value.value);
4287: --fnd_message.debug(Value.meaning);
4288: --fnd_message.debug(Value.id);
4289:
4290: If p_attr_value = Value.value Then
4291:
4292: x_attr_value_code := p_attr_value;