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 OE_MSG_PUB

Line 1832: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1828: EXCEPTION
1829:
1830: WHEN OTHERS THEN
1831:
1832: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1833: THEN
1834: oe_msg_pub.Add_Exc_Msg
1835: ( G_PKG_NAME
1836: , 'Update_Row'

Line 1834: oe_msg_pub.Add_Exc_Msg

1830: WHEN OTHERS THEN
1831:
1832: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1833: THEN
1834: oe_msg_pub.Add_Exc_Msg
1835: ( G_PKG_NAME
1836: , 'Update_Row'
1837: );
1838: END IF;

Line 2071: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

2067: EXCEPTION
2068:
2069: WHEN OTHERS THEN
2070:
2071: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2072: THEN
2073: oe_msg_pub.Add_Exc_Msg
2074: ( G_PKG_NAME
2075: , 'Insert_Row'

Line 2073: oe_msg_pub.Add_Exc_Msg

2069: WHEN OTHERS THEN
2070:
2071: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2072: THEN
2073: oe_msg_pub.Add_Exc_Msg
2074: ( G_PKG_NAME
2075: , 'Insert_Row'
2076: );
2077: END IF;

Line 2140: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

2136: EXCEPTION
2137:
2138: WHEN OTHERS THEN
2139:
2140: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2141: THEN
2142: oe_msg_pub.Add_Exc_Msg
2143: ( G_PKG_NAME
2144: , 'Delete_Row'

Line 2142: oe_msg_pub.Add_Exc_Msg

2138: WHEN OTHERS THEN
2139:
2140: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2141: THEN
2142: oe_msg_pub.Add_Exc_Msg
2143: ( G_PKG_NAME
2144: , 'Delete_Row'
2145: );
2146: END IF;

Line 2348: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

2344: (p_list_header_id IS NOT NULL
2345: AND
2346: p_list_header_id <> FND_API.G_MISS_NUM)
2347: THEN
2348: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2349: THEN
2350: oe_msg_pub.Add_Exc_Msg
2351: ( G_PKG_NAME
2352: , 'Query Rows'

Line 2350: oe_msg_pub.Add_Exc_Msg

2346: p_list_header_id <> FND_API.G_MISS_NUM)
2347: THEN
2348: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2349: THEN
2350: oe_msg_pub.Add_Exc_Msg
2351: ( G_PKG_NAME
2352: , 'Query Rows'
2353: , 'Keys are mutually exclusive: list_line_id = '|| p_list_line_id || ', list_header_id = '|| p_list_header_id
2354: );

Line 2596: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

2592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2593:
2594: WHEN OTHERS THEN
2595:
2596: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2597: THEN
2598: oe_msg_pub.Add_Exc_Msg
2599: ( G_PKG_NAME
2600: , 'Query_Rows'

Line 2598: oe_msg_pub.Add_Exc_Msg

2594: WHEN OTHERS THEN
2595:
2596: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2597: THEN
2598: oe_msg_pub.Add_Exc_Msg
2599: ( G_PKG_NAME
2600: , 'Query_Rows'
2601: );
2602: END IF;

Line 3059: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

3055:
3056: x_return_status := FND_API.G_RET_STS_ERROR;
3057: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
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;

Line 3063: oe_msg_pub.Add;

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:
3067: END IF;

Line 3076: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

3072:
3073: x_return_status := FND_API.G_RET_STS_ERROR;
3074: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
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;

Line 3080: oe_msg_pub.Add;

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
3084:

Line 3088: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

3084:
3085: x_return_status := FND_API.G_RET_STS_ERROR;
3086: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
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;

Line 3092: oe_msg_pub.Add;

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
3096:

Line 3100: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

3096:
3097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3098: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3099:
3100: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
3101: THEN
3102: oe_msg_pub.Add_Exc_Msg
3103: ( G_PKG_NAME
3104: , 'Lock_Row'

Line 3102: oe_msg_pub.Add_Exc_Msg

3098: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3099:
3100: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
3101: THEN
3102: oe_msg_pub.Add_Exc_Msg
3103: ( G_PKG_NAME
3104: , 'Lock_Row'
3105: );
3106: END IF;

Line 3354: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

3350: IF p_PRICE_LIST_LINE_rec.accrual_uom_code <> FND_API.G_MISS_CHAR THEN
3351:
3352: l_PRICE_LIST_LINE_rec.accrual_uom_code := p_PRICE_LIST_LINE_rec.accrual_uom_code;
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');

Line 3359: oe_msg_pub.Add;

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:
3363: ELSE

Line 3388: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

3384: IF p_PRICE_LIST_LINE_rec.automatic_flag <> FND_API.G_MISS_CHAR THEN
3385:
3386: l_PRICE_LIST_LINE_rec.automatic_flag := p_PRICE_LIST_LINE_rec.automatic_flag;
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');

Line 3393: oe_msg_pub.Add;

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:
3397: ELSE

Line 3418: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

3414: IF p_PRICE_LIST_LINE_rec.base_uom_code <> FND_API.G_MISS_CHAR THEN
3415:
3416: l_PRICE_LIST_LINE_rec.base_uom_code := p_PRICE_LIST_LINE_rec.base_uom_code;
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');

Line 3423: oe_msg_pub.Add;

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:
3427: ELSE

Line 3448: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

3444: IF p_PRICE_LIST_LINE_rec.generate_using_formula_id <> FND_API.G_MISS_NUM THEN
3445:
3446: l_PRICE_LIST_LINE_rec.generate_using_formula_id := p_PRICE_LIST_LINE_rec.generate_using_formula_id;
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');

Line 3453: oe_msg_pub.Add;

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:
3457: ELSE

Line 3478: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

3474: IF p_PRICE_LIST_LINE_rec.inventory_item_id <> FND_API.G_MISS_NUM THEN
3475:
3476: l_PRICE_LIST_LINE_rec.inventory_item_id := p_PRICE_LIST_LINE_rec.inventory_item_id;
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');

Line 3483: oe_msg_pub.Add;

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:
3487: ELSE

Line 3508: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

3504: IF p_PRICE_LIST_LINE_rec.list_header_id <> FND_API.G_MISS_NUM THEN
3505:
3506: l_PRICE_LIST_LINE_rec.list_header_id := p_PRICE_LIST_LINE_rec.list_header_id;
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');

Line 3513: oe_msg_pub.Add;

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:
3517: ELSE

Line 3538: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

3534: IF p_PRICE_LIST_LINE_rec.list_line_id <> FND_API.G_MISS_NUM THEN
3535:
3536: l_PRICE_LIST_LINE_rec.list_line_id := p_PRICE_LIST_LINE_rec.list_line_id;
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');

Line 3543: oe_msg_pub.Add;

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:
3547: ELSE

Line 3568: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

3564: IF p_PRICE_LIST_LINE_rec.list_line_type_code <> FND_API.G_MISS_CHAR THEN
3565:
3566: l_PRICE_LIST_LINE_rec.list_line_type_code := p_PRICE_LIST_LINE_rec.list_line_type_code;
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');

Line 3573: oe_msg_pub.Add;

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:
3577: ELSE

Line 3598: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

3594: IF p_PRICE_LIST_LINE_rec.modifier_level_code <> FND_API.G_MISS_CHAR THEN
3595:
3596: l_PRICE_LIST_LINE_rec.modifier_level_code := p_PRICE_LIST_LINE_rec.modifier_level_code;
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');

Line 3603: oe_msg_pub.Add;

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:
3607: ELSE

Line 3628: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

3624: IF p_PRICE_LIST_LINE_rec.organization_id <> FND_API.G_MISS_NUM THEN
3625:
3626: l_PRICE_LIST_LINE_rec.organization_id := p_PRICE_LIST_LINE_rec.organization_id;
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');

Line 3633: oe_msg_pub.Add;

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:
3637: ELSE

Line 3658: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

3654: IF p_PRICE_LIST_LINE_rec.override_flag <> FND_API.G_MISS_CHAR THEN
3655:
3656: l_PRICE_LIST_LINE_rec.override_flag := p_PRICE_LIST_LINE_rec.override_flag;
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');

Line 3663: oe_msg_pub.Add;

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:
3667: ELSE

Line 3688: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

3684: IF p_PRICE_LIST_LINE_rec.price_break_type_code <> FND_API.G_MISS_CHAR THEN
3685:
3686: l_PRICE_LIST_LINE_rec.price_break_type_code := p_PRICE_LIST_LINE_rec.price_break_type_code;
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');

Line 3693: oe_msg_pub.Add;

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:
3697: ELSE

Line 3718: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

3714: IF p_PRICE_LIST_LINE_rec.price_by_formula_id <> FND_API.G_MISS_NUM THEN
3715:
3716: l_PRICE_LIST_LINE_rec.price_by_formula_id := p_PRICE_LIST_LINE_rec.price_by_formula_id;
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');

Line 3723: oe_msg_pub.Add;

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:
3727: ELSE

Line 3748: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

3744: IF p_PRICE_LIST_LINE_rec.primary_uom_flag <> FND_API.G_MISS_CHAR THEN
3745:
3746: l_PRICE_LIST_LINE_rec.primary_uom_flag := p_PRICE_LIST_LINE_rec.primary_uom_flag;
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');

Line 3753: oe_msg_pub.Add;

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:
3757: ELSE

Line 3778: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

3774: IF p_PRICE_LIST_LINE_rec.print_on_invoice_flag <> FND_API.G_MISS_CHAR THEN
3775:
3776: l_PRICE_LIST_LINE_rec.print_on_invoice_flag := p_PRICE_LIST_LINE_rec.print_on_invoice_flag;
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');

Line 3783: oe_msg_pub.Add;

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:
3787: ELSE

Line 3808: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

3804: IF p_PRICE_LIST_LINE_rec.rebate_trxn_type_code <> FND_API.G_MISS_CHAR THEN
3805:
3806: l_PRICE_LIST_LINE_rec.rebate_trxn_type_code := p_PRICE_LIST_LINE_rec.rebate_trxn_type_code;
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');

Line 3813: oe_msg_pub.Add;

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:
3817: ELSE

Line 3838: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

3834: IF p_PRICE_LIST_LINE_rec.related_item_id <> FND_API.G_MISS_NUM THEN
3835:
3836: l_PRICE_LIST_LINE_rec.related_item_id := p_PRICE_LIST_LINE_rec.related_item_id;
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');

Line 3843: oe_msg_pub.Add;

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:
3847: ELSE

Line 3868: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

3864: IF p_PRICE_LIST_LINE_rec.relationship_type_id <> FND_API.G_MISS_NUM THEN
3865:
3866: l_PRICE_LIST_LINE_rec.relationship_type_id := p_PRICE_LIST_LINE_rec.relationship_type_id;
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');

Line 3873: oe_msg_pub.Add;

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:
3877: ELSE

Line 3898: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

3894: IF p_PRICE_LIST_LINE_rec.reprice_flag <> FND_API.G_MISS_CHAR THEN
3895:
3896: l_PRICE_LIST_LINE_rec.reprice_flag := p_PRICE_LIST_LINE_rec.reprice_flag;
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');

Line 3903: oe_msg_pub.Add;

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:
3907: ELSE

Line 3928: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

3924: IF p_PRICE_LIST_LINE_rec.revision_reason_code <> FND_API.G_MISS_CHAR THEN
3925:
3926: l_PRICE_LIST_LINE_rec.revision_reason_code := p_PRICE_LIST_LINE_rec.revision_reason_code;
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');

Line 3933: oe_msg_pub.Add;

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:
3937: ELSE