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 1827: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1823: EXCEPTION
1824:
1825: WHEN OTHERS THEN
1826:
1827: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1828: THEN
1829: oe_msg_pub.Add_Exc_Msg
1830: ( G_PKG_NAME
1831: , 'Update_Row'

Line 1829: oe_msg_pub.Add_Exc_Msg

1825: WHEN OTHERS THEN
1826:
1827: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1828: THEN
1829: oe_msg_pub.Add_Exc_Msg
1830: ( G_PKG_NAME
1831: , 'Update_Row'
1832: );
1833: END IF;

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

2062: EXCEPTION
2063:
2064: WHEN OTHERS THEN
2065:
2066: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2067: THEN
2068: oe_msg_pub.Add_Exc_Msg
2069: ( G_PKG_NAME
2070: , 'Insert_Row'

Line 2068: oe_msg_pub.Add_Exc_Msg

2064: WHEN OTHERS THEN
2065:
2066: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2067: THEN
2068: oe_msg_pub.Add_Exc_Msg
2069: ( G_PKG_NAME
2070: , 'Insert_Row'
2071: );
2072: END IF;

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

2131: EXCEPTION
2132:
2133: WHEN OTHERS THEN
2134:
2135: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2136: THEN
2137: oe_msg_pub.Add_Exc_Msg
2138: ( G_PKG_NAME
2139: , 'Delete_Row'

Line 2137: oe_msg_pub.Add_Exc_Msg

2133: WHEN OTHERS THEN
2134:
2135: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2136: THEN
2137: oe_msg_pub.Add_Exc_Msg
2138: ( G_PKG_NAME
2139: , 'Delete_Row'
2140: );
2141: END IF;

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

2339: (p_list_header_id IS NOT NULL
2340: AND
2341: p_list_header_id <> FND_API.G_MISS_NUM)
2342: THEN
2343: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2344: THEN
2345: oe_msg_pub.Add_Exc_Msg
2346: ( G_PKG_NAME
2347: , 'Query Rows'

Line 2345: oe_msg_pub.Add_Exc_Msg

2341: p_list_header_id <> FND_API.G_MISS_NUM)
2342: THEN
2343: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2344: THEN
2345: oe_msg_pub.Add_Exc_Msg
2346: ( G_PKG_NAME
2347: , 'Query Rows'
2348: , 'Keys are mutually exclusive: list_line_id = '|| p_list_line_id || ', list_header_id = '|| p_list_header_id
2349: );

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

2587: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2588:
2589: WHEN OTHERS THEN
2590:
2591: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2592: THEN
2593: oe_msg_pub.Add_Exc_Msg
2594: ( G_PKG_NAME
2595: , 'Query_Rows'

Line 2593: oe_msg_pub.Add_Exc_Msg

2589: WHEN OTHERS THEN
2590:
2591: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2592: THEN
2593: oe_msg_pub.Add_Exc_Msg
2594: ( G_PKG_NAME
2595: , 'Query_Rows'
2596: );
2597: END IF;

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

2909:
2910: x_return_status := FND_API.G_RET_STS_ERROR;
2911: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
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;

Line 2917: oe_msg_pub.Add;

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

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

2926:
2927: x_return_status := FND_API.G_RET_STS_ERROR;
2928: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
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;

Line 2934: oe_msg_pub.Add;

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

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

2938:
2939: x_return_status := FND_API.G_RET_STS_ERROR;
2940: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
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;

Line 2946: oe_msg_pub.Add;

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

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

2950:
2951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2952: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2953:
2954: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2955: THEN
2956: oe_msg_pub.Add_Exc_Msg
2957: ( G_PKG_NAME
2958: , 'Lock_Row'

Line 2956: oe_msg_pub.Add_Exc_Msg

2952: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2953:
2954: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2955: THEN
2956: oe_msg_pub.Add_Exc_Msg
2957: ( G_PKG_NAME
2958: , 'Lock_Row'
2959: );
2960: END IF;

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

3204: IF p_PRICE_LIST_LINE_rec.accrual_uom_code <> FND_API.G_MISS_CHAR THEN
3205:
3206: l_PRICE_LIST_LINE_rec.accrual_uom_code := p_PRICE_LIST_LINE_rec.accrual_uom_code;
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');

Line 3213: oe_msg_pub.Add;

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

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

3238: IF p_PRICE_LIST_LINE_rec.automatic_flag <> FND_API.G_MISS_CHAR THEN
3239:
3240: l_PRICE_LIST_LINE_rec.automatic_flag := p_PRICE_LIST_LINE_rec.automatic_flag;
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');

Line 3247: oe_msg_pub.Add;

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

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

3268: IF p_PRICE_LIST_LINE_rec.base_uom_code <> FND_API.G_MISS_CHAR THEN
3269:
3270: l_PRICE_LIST_LINE_rec.base_uom_code := p_PRICE_LIST_LINE_rec.base_uom_code;
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');

Line 3277: oe_msg_pub.Add;

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

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

3298: IF p_PRICE_LIST_LINE_rec.generate_using_formula_id <> FND_API.G_MISS_NUM THEN
3299:
3300: l_PRICE_LIST_LINE_rec.generate_using_formula_id := p_PRICE_LIST_LINE_rec.generate_using_formula_id;
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');

Line 3307: oe_msg_pub.Add;

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

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

3328: IF p_PRICE_LIST_LINE_rec.inventory_item_id <> FND_API.G_MISS_NUM THEN
3329:
3330: l_PRICE_LIST_LINE_rec.inventory_item_id := p_PRICE_LIST_LINE_rec.inventory_item_id;
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');

Line 3337: oe_msg_pub.Add;

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

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

3358: IF p_PRICE_LIST_LINE_rec.list_header_id <> FND_API.G_MISS_NUM THEN
3359:
3360: l_PRICE_LIST_LINE_rec.list_header_id := p_PRICE_LIST_LINE_rec.list_header_id;
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');

Line 3367: oe_msg_pub.Add;

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

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

3388: IF p_PRICE_LIST_LINE_rec.list_line_id <> FND_API.G_MISS_NUM THEN
3389:
3390: l_PRICE_LIST_LINE_rec.list_line_id := p_PRICE_LIST_LINE_rec.list_line_id;
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');

Line 3397: oe_msg_pub.Add;

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

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

3418: IF p_PRICE_LIST_LINE_rec.list_line_type_code <> FND_API.G_MISS_CHAR THEN
3419:
3420: l_PRICE_LIST_LINE_rec.list_line_type_code := p_PRICE_LIST_LINE_rec.list_line_type_code;
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');

Line 3427: oe_msg_pub.Add;

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

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

3448: IF p_PRICE_LIST_LINE_rec.modifier_level_code <> FND_API.G_MISS_CHAR THEN
3449:
3450: l_PRICE_LIST_LINE_rec.modifier_level_code := p_PRICE_LIST_LINE_rec.modifier_level_code;
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');

Line 3457: oe_msg_pub.Add;

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

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

3478: IF p_PRICE_LIST_LINE_rec.organization_id <> FND_API.G_MISS_NUM THEN
3479:
3480: l_PRICE_LIST_LINE_rec.organization_id := p_PRICE_LIST_LINE_rec.organization_id;
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');

Line 3487: oe_msg_pub.Add;

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

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

3508: IF p_PRICE_LIST_LINE_rec.override_flag <> FND_API.G_MISS_CHAR THEN
3509:
3510: l_PRICE_LIST_LINE_rec.override_flag := p_PRICE_LIST_LINE_rec.override_flag;
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');

Line 3517: oe_msg_pub.Add;

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

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

3538: IF p_PRICE_LIST_LINE_rec.price_break_type_code <> FND_API.G_MISS_CHAR THEN
3539:
3540: l_PRICE_LIST_LINE_rec.price_break_type_code := p_PRICE_LIST_LINE_rec.price_break_type_code;
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');

Line 3547: oe_msg_pub.Add;

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

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

3568: IF p_PRICE_LIST_LINE_rec.price_by_formula_id <> FND_API.G_MISS_NUM THEN
3569:
3570: l_PRICE_LIST_LINE_rec.price_by_formula_id := p_PRICE_LIST_LINE_rec.price_by_formula_id;
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');

Line 3577: oe_msg_pub.Add;

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

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

3598: IF p_PRICE_LIST_LINE_rec.primary_uom_flag <> FND_API.G_MISS_CHAR THEN
3599:
3600: l_PRICE_LIST_LINE_rec.primary_uom_flag := p_PRICE_LIST_LINE_rec.primary_uom_flag;
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');

Line 3607: oe_msg_pub.Add;

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

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

3628: IF p_PRICE_LIST_LINE_rec.print_on_invoice_flag <> FND_API.G_MISS_CHAR THEN
3629:
3630: l_PRICE_LIST_LINE_rec.print_on_invoice_flag := p_PRICE_LIST_LINE_rec.print_on_invoice_flag;
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');

Line 3637: oe_msg_pub.Add;

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

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

3658: IF p_PRICE_LIST_LINE_rec.rebate_trxn_type_code <> FND_API.G_MISS_CHAR THEN
3659:
3660: l_PRICE_LIST_LINE_rec.rebate_trxn_type_code := p_PRICE_LIST_LINE_rec.rebate_trxn_type_code;
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');

Line 3667: oe_msg_pub.Add;

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

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

3688: IF p_PRICE_LIST_LINE_rec.related_item_id <> FND_API.G_MISS_NUM THEN
3689:
3690: l_PRICE_LIST_LINE_rec.related_item_id := p_PRICE_LIST_LINE_rec.related_item_id;
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');

Line 3697: oe_msg_pub.Add;

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

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

3718: IF p_PRICE_LIST_LINE_rec.relationship_type_id <> FND_API.G_MISS_NUM THEN
3719:
3720: l_PRICE_LIST_LINE_rec.relationship_type_id := p_PRICE_LIST_LINE_rec.relationship_type_id;
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');

Line 3727: oe_msg_pub.Add;

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

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

3748: IF p_PRICE_LIST_LINE_rec.reprice_flag <> FND_API.G_MISS_CHAR THEN
3749:
3750: l_PRICE_LIST_LINE_rec.reprice_flag := p_PRICE_LIST_LINE_rec.reprice_flag;
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');

Line 3757: oe_msg_pub.Add;

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

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

3778: IF p_PRICE_LIST_LINE_rec.revision_reason_code <> FND_API.G_MISS_CHAR THEN
3779:
3780: l_PRICE_LIST_LINE_rec.revision_reason_code := p_PRICE_LIST_LINE_rec.revision_reason_code;
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');

Line 3787: oe_msg_pub.Add;

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