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 2916: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');

2912:
2913: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2914: THEN
2915:
2916: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
2917: oe_msg_pub.Add;
2918:
2919: END IF;
2920:

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

2929:
2930: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2931: THEN
2932:
2933: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
2934: oe_msg_pub.Add;
2935:
2936: END IF;
2937: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

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

2941:
2942: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2943: THEN
2944:
2945: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
2946: oe_msg_pub.Add;
2947:
2948: END IF;
2949: WHEN OTHERS THEN

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

3207:
3208: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3209: THEN
3210:
3211: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3212: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accrual_uom');
3213: oe_msg_pub.Add;
3214:
3215: END IF;

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

3208: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3209: THEN
3210:
3211: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3212: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accrual_uom');
3213: oe_msg_pub.Add;
3214:
3215: END IF;
3216:

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

3241:
3242: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3243: THEN
3244:
3245: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3246: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','automatic');
3247: oe_msg_pub.Add;
3248:
3249: END IF;

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

3242: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3243: THEN
3244:
3245: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3246: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','automatic');
3247: oe_msg_pub.Add;
3248:
3249: END IF;
3250:

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

3271:
3272: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3273: THEN
3274:
3275: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3276: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','base_uom');
3277: oe_msg_pub.Add;
3278:
3279: END IF;

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

3272: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3273: THEN
3274:
3275: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3276: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','base_uom');
3277: oe_msg_pub.Add;
3278:
3279: END IF;
3280:

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

3301:
3302: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3303: THEN
3304:
3305: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3306: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','generate_using_formula');
3307: oe_msg_pub.Add;
3308:
3309: END IF;

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

3302: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3303: THEN
3304:
3305: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3306: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','generate_using_formula');
3307: oe_msg_pub.Add;
3308:
3309: END IF;
3310:

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

3331:
3332: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3333: THEN
3334:
3335: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3336: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item');
3337: oe_msg_pub.Add;
3338:
3339: END IF;

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

3332: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3333: THEN
3334:
3335: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3336: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item');
3337: oe_msg_pub.Add;
3338:
3339: END IF;
3340:

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

3361:
3362: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3363: THEN
3364:
3365: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3366: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');
3367: oe_msg_pub.Add;
3368:
3369: END IF;

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

3362: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3363: THEN
3364:
3365: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3366: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');
3367: oe_msg_pub.Add;
3368:
3369: END IF;
3370:

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

3391:
3392: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3393: THEN
3394:
3395: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3396: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line');
3397: oe_msg_pub.Add;
3398:
3399: END IF;

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

3392: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3393: THEN
3394:
3395: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3396: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line');
3397: oe_msg_pub.Add;
3398:
3399: END IF;
3400:

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

3421:
3422: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3423: THEN
3424:
3425: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3426: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line_type');
3427: oe_msg_pub.Add;
3428:
3429: END IF;

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

3422: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3423: THEN
3424:
3425: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3426: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line_type');
3427: oe_msg_pub.Add;
3428:
3429: END IF;
3430:

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

3451:
3452: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3453: THEN
3454:
3455: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3456: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','modifier_level');
3457: oe_msg_pub.Add;
3458:
3459: END IF;

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

3452: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3453: THEN
3454:
3455: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3456: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','modifier_level');
3457: oe_msg_pub.Add;
3458:
3459: END IF;
3460:

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

3481:
3482: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3483: THEN
3484:
3485: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3486: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','organization');
3487: oe_msg_pub.Add;
3488:
3489: END IF;

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

3482: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3483: THEN
3484:
3485: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3486: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','organization');
3487: oe_msg_pub.Add;
3488:
3489: END IF;
3490:

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

3511:
3512: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3513: THEN
3514:
3515: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3516: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override');
3517: oe_msg_pub.Add;
3518:
3519: END IF;

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

3512: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3513: THEN
3514:
3515: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3516: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override');
3517: oe_msg_pub.Add;
3518:
3519: END IF;
3520:

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

3541:
3542: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3543: THEN
3544:
3545: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3546: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_break_type');
3547: oe_msg_pub.Add;
3548:
3549: END IF;

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

3542: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3543: THEN
3544:
3545: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3546: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_break_type');
3547: oe_msg_pub.Add;
3548:
3549: END IF;
3550:

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

3571:
3572: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3573: THEN
3574:
3575: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3576: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_by_formula');
3577: oe_msg_pub.Add;
3578:
3579: END IF;

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

3572: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3573: THEN
3574:
3575: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3576: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_by_formula');
3577: oe_msg_pub.Add;
3578:
3579: END IF;
3580:

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

3601:
3602: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3603: THEN
3604:
3605: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3606: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','primary_uom');
3607: oe_msg_pub.Add;
3608:
3609: END IF;

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

3602: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3603: THEN
3604:
3605: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3606: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','primary_uom');
3607: oe_msg_pub.Add;
3608:
3609: END IF;
3610:

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

3631:
3632: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3633: THEN
3634:
3635: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3636: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','print_on_invoice');
3637: oe_msg_pub.Add;
3638:
3639: END IF;

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

3632: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3633: THEN
3634:
3635: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3636: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','print_on_invoice');
3637: oe_msg_pub.Add;
3638:
3639: END IF;
3640:

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

3661:
3662: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3663: THEN
3664:
3665: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3666: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rebate_transaction_type');
3667: oe_msg_pub.Add;
3668:
3669: END IF;

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

3662: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3663: THEN
3664:
3665: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3666: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rebate_transaction_type');
3667: oe_msg_pub.Add;
3668:
3669: END IF;
3670:

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

3691:
3692: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3693: THEN
3694:
3695: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3696: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','related_item');
3697: oe_msg_pub.Add;
3698:
3699: END IF;

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

3692: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3693: THEN
3694:
3695: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3696: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','related_item');
3697: oe_msg_pub.Add;
3698:
3699: END IF;
3700:

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

3721:
3722: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3723: THEN
3724:
3725: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3726: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','relationship_type');
3727: oe_msg_pub.Add;
3728:
3729: END IF;

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

3722: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3723: THEN
3724:
3725: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3726: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','relationship_type');
3727: oe_msg_pub.Add;
3728:
3729: END IF;
3730:

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

3751:
3752: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3753: THEN
3754:
3755: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3756: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reprice');
3757: oe_msg_pub.Add;
3758:
3759: END IF;

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

3752: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3753: THEN
3754:
3755: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3756: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reprice');
3757: oe_msg_pub.Add;
3758:
3759: END IF;
3760:

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

3781:
3782: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3783: THEN
3784:
3785: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3786: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','revision_reason');
3787: oe_msg_pub.Add;
3788:
3789: END IF;

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

3782: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
3783: THEN
3784:
3785: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3786: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','revision_reason');
3787: oe_msg_pub.Add;
3788:
3789: END IF;
3790:

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

3970: x_attribute_code VARCHAR2(240) := NULL;
3971:
3972: BEGIN
3973:
3974: --fnd_message.debug('passsed values are ' ||p_FlexField_Name);
3975: --fnd_message.debug('passsed values are ' ||p_Context_Name);
3976: --fnd_message.debug('passsed values are ' ||p_attribute);
3977:
3978:

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

3971:
3972: BEGIN
3973:
3974: --fnd_message.debug('passsed values are ' ||p_FlexField_Name);
3975: --fnd_message.debug('passsed values are ' ||p_Context_Name);
3976: --fnd_message.debug('passsed values are ' ||p_attribute);
3977:
3978:
3979: FND_DFLEX.get_flexfield('QP',p_FlexField_Name,Flexfield,Flexinfo);

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

3972: BEGIN
3973:
3974: --fnd_message.debug('passsed values are ' ||p_FlexField_Name);
3975: --fnd_message.debug('passsed values are ' ||p_Context_Name);
3976: --fnd_message.debug('passsed values are ' ||p_attribute);
3977:
3978:
3979: FND_DFLEX.get_flexfield('QP',p_FlexField_Name,Flexfield,Flexinfo);
3980: FND_DFLEX.get_segments(FND_DFLEX.make_context(Flexfield,p_Context_Name),

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

3983: For i in 1..segments.nsegments LOOP
3984:
3985: IF segments.is_enabled(i) THEN
3986:
3987: --fnd_message.debug('col name is ' ||segments.application_column_name(i));
3988: --fnd_message.debug(' seg name is ' ||segments.segment_name(i));
3989: IF segments.application_column_name(i) = p_attribute Then
3990: x_attribute_code := segments.row_prompt(i);
3991: RETURN x_attribute_code;

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

3984:
3985: IF segments.is_enabled(i) THEN
3986:
3987: --fnd_message.debug('col name is ' ||segments.application_column_name(i));
3988: --fnd_message.debug(' seg name is ' ||segments.segment_name(i));
3989: IF segments.application_column_name(i) = p_attribute Then
3990: x_attribute_code := segments.row_prompt(i);
3991: RETURN x_attribute_code;
3992: End if;

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

4105: BEGIN
4106:
4107: QP_UTIL.get_valueset_id(p_FlexField_Name,p_Context_Name,p_Segment_Name,x_Vsid,x_Format_Type,
4108: x_Validation_Type);
4109: --fnd_message.debug(x_Vsid);
4110: --fnd_message.debug(x_Validation_Type);
4111: --fnd_message.show;
4112:
4113: IF x_Validation_Type In('F' ,'I') AND x_Vsid IS NOT NULL THEN

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

4106:
4107: QP_UTIL.get_valueset_id(p_FlexField_Name,p_Context_Name,p_Segment_Name,x_Vsid,x_Format_Type,
4108: x_Validation_Type);
4109: --fnd_message.debug(x_Vsid);
4110: --fnd_message.debug(x_Validation_Type);
4111: --fnd_message.show;
4112:
4113: IF x_Validation_Type In('F' ,'I') AND x_Vsid IS NOT NULL THEN
4114: IF x_Validation_Type = 'I' THEN --Added for 2332139

Line 4111: --fnd_message.show;

4107: QP_UTIL.get_valueset_id(p_FlexField_Name,p_Context_Name,p_Segment_Name,x_Vsid,x_Format_Type,
4108: x_Validation_Type);
4109: --fnd_message.debug(x_Vsid);
4110: --fnd_message.debug(x_Validation_Type);
4111: --fnd_message.show;
4112:
4113: IF x_Validation_Type In('F' ,'I') AND x_Vsid IS NOT NULL THEN
4114: IF x_Validation_Type = 'I' THEN --Added for 2332139
4115: FND_VSET.get_valueset(x_Vsid,Vset,Fmt);

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

4119: IF Fmt.Has_Id Then --id is defined.Hence compare for id
4120:
4121: While(Found) Loop
4122:
4123: --fnd_message.debug(Value.value);
4124: --fnd_message.debug(Value.meaning);
4125: --fnd_message.debug(Value.id);
4126:
4127: If p_attr_value = Value.id Then

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

4120:
4121: While(Found) Loop
4122:
4123: --fnd_message.debug(Value.value);
4124: --fnd_message.debug(Value.meaning);
4125: --fnd_message.debug(Value.id);
4126:
4127: If p_attr_value = Value.id Then
4128:

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

4121: While(Found) Loop
4122:
4123: --fnd_message.debug(Value.value);
4124: --fnd_message.debug(Value.meaning);
4125: --fnd_message.debug(Value.id);
4126:
4127: If p_attr_value = Value.id Then
4128:
4129: x_attr_value_code := Value.Value;

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

4136: Else
4137:
4138: While(Found) Loop
4139:
4140: --fnd_message.debug(Value.value);
4141: --fnd_message.debug(Value.meaning);
4142: --fnd_message.debug(Value.id);
4143:
4144: If p_attr_value = Value.value Then

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

4137:
4138: While(Found) Loop
4139:
4140: --fnd_message.debug(Value.value);
4141: --fnd_message.debug(Value.meaning);
4142: --fnd_message.debug(Value.id);
4143:
4144: If p_attr_value = Value.value Then
4145:

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

4138: While(Found) Loop
4139:
4140: --fnd_message.debug(Value.value);
4141: --fnd_message.debug(Value.meaning);
4142: --fnd_message.debug(Value.id);
4143:
4144: If p_attr_value = Value.value Then
4145:
4146: x_attr_value_code := p_attr_value;