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.OE_LINE_PAYMENT_UTIL dependencies on OE_MSG_PUB

Line 2006: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2002: EXCEPTION
2003:
2004: WHEN OTHERS THEN
2005:
2006: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2007: THEN
2008: oe_msg_pub.Add_Exc_Msg
2009: ( G_PKG_NAME
2010: , 'Update_Row'

Line 2008: oe_msg_pub.Add_Exc_Msg

2004: WHEN OTHERS THEN
2005:
2006: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2007: THEN
2008: oe_msg_pub.Add_Exc_Msg
2009: ( G_PKG_NAME
2010: , 'Update_Row'
2011: );
2012: END IF;

Line 2210: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2206: EXCEPTION
2207:
2208: WHEN OTHERS THEN
2209:
2210: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2211: THEN
2212: oe_msg_pub.Add_Exc_Msg
2213: ( G_PKG_NAME
2214: , 'Insert_Row'

Line 2212: oe_msg_pub.Add_Exc_Msg

2208: WHEN OTHERS THEN
2209:
2210: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2211: THEN
2212: oe_msg_pub.Add_Exc_Msg
2213: ( G_PKG_NAME
2214: , 'Insert_Row'
2215: );
2216: END IF;

Line 2617: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2613: EXCEPTION
2614:
2615: WHEN OTHERS THEN
2616:
2617: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2618: THEN
2619: oe_msg_pub.Add_Exc_Msg
2620: ( G_PKG_NAME
2621: , 'Delete_Row'

Line 2619: oe_msg_pub.Add_Exc_Msg

2615: WHEN OTHERS THEN
2616:
2617: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2618: THEN
2619: oe_msg_pub.Add_Exc_Msg
2620: ( G_PKG_NAME
2621: , 'Delete_Row'
2622: );
2623: END IF;

Line 2818: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2815:
2816: WHEN OTHERS THEN
2817:
2818: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2819: THEN
2820: oe_msg_pub.Add_Exc_Msg
2821: ( G_PKG_NAME
2822: , 'Query_Row'

Line 2820: oe_msg_pub.Add_Exc_Msg

2816: WHEN OTHERS THEN
2817:
2818: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2819: THEN
2820: oe_msg_pub.Add_Exc_Msg
2821: ( G_PKG_NAME
2822: , 'Query_Row'
2823: );
2824: END IF;

Line 3008: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3005:
3006: WHEN OTHERS THEN
3007:
3008: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3009: THEN
3010: oe_msg_pub.Add_Exc_Msg
3011: ( G_PKG_NAME
3012: , 'Query_Rows'

Line 3010: oe_msg_pub.Add_Exc_Msg

3006: WHEN OTHERS THEN
3007:
3008: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3009: THEN
3010: oe_msg_pub.Add_Exc_Msg
3011: ( G_PKG_NAME
3012: , 'Query_Rows'
3013: );
3014: END IF;

Line 3117: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3113:
3114: x_return_status := FND_API.G_RET_STS_ERROR;
3115: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3116:
3117: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3118: THEN
3119:
3120: -- Release the lock
3121: ROLLBACK TO Lock_Row;

Line 3124: oe_msg_pub.Add;

3120: -- Release the lock
3121: ROLLBACK TO Lock_Row;
3122:
3123: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_CHANGED');
3124: oe_msg_pub.Add;
3125:
3126: END IF;
3127:
3128: END IF;

Line 3137: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3133:
3134: x_return_status := FND_API.G_RET_STS_ERROR;
3135: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3136:
3137: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3138: THEN
3139:
3140: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_DELETED');
3141: oe_msg_pub.Add;

Line 3141: oe_msg_pub.Add;

3137: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3138: THEN
3139:
3140: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_DELETED');
3141: oe_msg_pub.Add;
3142:
3143: END IF;
3144: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3145:

Line 3149: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

3145:
3146: x_return_status := FND_API.G_RET_STS_ERROR;
3147: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3148:
3149: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3150: THEN
3151:
3152: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
3153: oe_msg_pub.Add;

Line 3153: oe_msg_pub.Add;

3149: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3150: THEN
3151:
3152: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
3153: oe_msg_pub.Add;
3154:
3155: END IF;
3156: WHEN OTHERS THEN
3157:

Line 3161: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3157:
3158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3159: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3160:
3161: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3162: THEN
3163: oe_msg_pub.Add_Exc_Msg
3164: ( G_PKG_NAME
3165: , 'Lock_Row'

Line 3163: oe_msg_pub.Add_Exc_Msg

3159: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3160:
3161: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3162: THEN
3163: oe_msg_pub.Add_Exc_Msg
3164: ( G_PKG_NAME
3165: , 'Lock_Row'
3166: );
3167: END IF;

Line 3204: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3200: p_payment_number <> FND_API.G_MISS_NUM) AND
3201: (p_line_id IS NOT NULL AND
3202: p_line_id <> FND_API.G_MISS_NUM)
3203: THEN
3204: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3205: THEN
3206: OE_MSG_PUB.Add_Exc_Msg
3207: ( G_PKG_NAME
3208: , 'Lock Rows'

Line 3206: OE_MSG_PUB.Add_Exc_Msg

3202: p_line_id <> FND_API.G_MISS_NUM)
3203: THEN
3204: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3205: THEN
3206: OE_MSG_PUB.Add_Exc_Msg
3207: ( G_PKG_NAME
3208: , 'Lock Rows'
3209: , 'Keys are mutually exclusive: payment_number = '||
3210: p_payment_number || ', line_id = '|| p_line_id );

Line 3278: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3274: WHEN NO_DATA_FOUND THEN
3275:
3276: x_return_status := FND_API.G_RET_STS_ERROR;
3277:
3278: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3279: THEN
3280: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
3281: OE_MSG_PUB.Add;
3282: END IF;

Line 3281: OE_MSG_PUB.Add;

3277:
3278: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3279: THEN
3280: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
3281: OE_MSG_PUB.Add;
3282: END IF;
3283:
3284: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3285:

Line 3287: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3283:
3284: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3285:
3286: x_return_status := FND_API.G_RET_STS_ERROR;
3287: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3288: THEN
3289: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
3290: OE_MSG_PUB.Add;
3291: END IF;

Line 3290: OE_MSG_PUB.Add;

3286: x_return_status := FND_API.G_RET_STS_ERROR;
3287: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3288: THEN
3289: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
3290: OE_MSG_PUB.Add;
3291: END IF;
3292:
3293: WHEN OTHERS THEN
3294:

Line 3297: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3293: WHEN OTHERS THEN
3294:
3295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3296:
3297: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3298: THEN
3299: OE_MSG_PUB.Add_Exc_Msg
3300: ( G_PKG_NAME
3301: , 'Lock_Rows'

Line 3299: OE_MSG_PUB.Add_Exc_Msg

3295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3296:
3297: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3298: THEN
3299: OE_MSG_PUB.Add_Exc_Msg
3300: ( G_PKG_NAME
3301: , 'Lock_Rows'
3302: );
3303: END IF;

Line 3382: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

3378: THEN
3379:
3380: IF p_x_Line_Payment_rec.payment_collection_event <> FND_API.G_MISS_CHAR THEN
3381:
3382: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3383: THEN
3384:
3385: FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3386: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_collection_event_name');

Line 3387: oe_msg_pub.Add;

3383: THEN
3384:
3385: FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3386: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_collection_event_name');
3387: oe_msg_pub.Add;
3388:
3389: END IF;
3390:
3391: ELSE

Line 3411: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

3407:
3408: IF p_x_Line_Payment_rec.payment_type_code <> FND_API.G_MISS_CHAR THEN
3409:
3410:
3411: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3412: THEN
3413:
3414: FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3415: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_type');

Line 3416: oe_msg_pub.Add;

3412: THEN
3413:
3414: FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3415: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_type');
3416: oe_msg_pub.Add;
3417:
3418: END IF;
3419:
3420: ELSE

Line 3441: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

3437:
3438: IF p_x_Line_Payment_rec.receipt_method_id <> FND_API.G_MISS_NUM THEN
3439:
3440:
3441: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3442: THEN
3443:
3444: FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3445: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Receipt_Method');

Line 3446: oe_msg_pub.Add;

3442: THEN
3443:
3444: FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3445: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Receipt_Method');
3446: oe_msg_pub.Add;
3447:
3448: END IF;
3449:
3450: ELSE

Line 3590: OE_MSG_PUB.ADD;

3586: IF l_new_commitment_bal IS NOT NULL THEN
3587: FND_MESSAGE.Set_Name('ONT','OE_COM_BALANCE');
3588: FND_MESSAGE.Set_Token('COMMITMENT',l_commitment);
3589: FND_Message.Set_Token('BALANCE',to_char(l_new_commitment_bal, g_fmt_mask));
3590: OE_MSG_PUB.ADD;
3591: END IF;
3592: -- End of Bug #3742103
3593: END IF;
3594: --bug 3560198

Line 3752: OE_Msg_Pub.Add;

3748:
3749: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND
3750: p_x_line_Payment_rec.instrument_security_code IS NULL THEN
3751: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
3752: OE_Msg_Pub.Add;
3753: RAISE FND_API.G_EXC_ERROR;
3754: END IF;
3755: END IF;
3756:

Line 3812: OE_MSG_PUB.Count_And_Get

3808: oe_debug_pub.add('New trxn extension id after calling Create_Payment_TRXN:'||l_trxn_extension_id);
3809: END IF;
3810: EXCEPTION
3811: WHEN FND_API.G_EXC_ERROR THEN
3812: OE_MSG_PUB.Count_And_Get
3813: ( p_count => l_msg_count,
3814: p_data => l_msg_data
3815: );
3816: l_return_status := FND_API.G_RET_STS_ERROR;

Line 3820: OE_MSG_PUB.Count_And_Get

3816: l_return_status := FND_API.G_RET_STS_ERROR;
3817: RAISE FND_API.G_EXC_ERROR;
3818:
3819: WHEN OTHERS THEN
3820: OE_MSG_PUB.Count_And_Get
3821: ( p_count => l_msg_count,
3822: p_data => l_msg_data
3823: );
3824: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');

Line 3825: OE_MSG_PUB.ADD;

3821: ( p_count => l_msg_count,
3822: p_data => l_msg_data
3823: );
3824: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
3825: OE_MSG_PUB.ADD;
3826: IF l_debug_level > 0 THEN
3827: oe_debug_pub.add( 'OEXUHPMB: ERROR IN CREATE PAYMENT trxn...'||sqlerrm) ;
3828: oe_debug_pub.add('Error messsge ksurendr'||l_return_status);
3829: END IF;

Line 3846: OE_Msg_Pub.Add;

3842: END IF;
3843: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED'
3844: AND p_x_line_Payment_rec.instrument_security_code IS NULL THEN
3845: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
3846: OE_Msg_Pub.Add;
3847: RAISE FND_API.G_EXC_ERROR;
3848: END IF;
3849: END IF;*/
3850: IF l_debug_level > 0 THEN

Line 3920: OE_MSG_PUB.Count_And_Get

3916: oe_debug_pub.add('After call to Update_Payment_TRXN'||l_return_status);
3917: oe_debug_pub.add('Error'||sqlerrm);
3918: END IF;
3919: l_return_status := FND_API.G_RET_STS_ERROR;
3920: OE_MSG_PUB.Count_And_Get
3921: ( p_count => l_msg_count,
3922: p_data => l_msg_data
3923: );
3924: RAISE FND_API.G_EXC_ERROR;

Line 3953: OE_Msg_Pub.Add;

3949:
3950: IF OE_Payment_Trxn_Util.g_CC_Security_Code_Use = 'REQUIRED' AND
3951: p_x_line_Payment_rec.instrument_security_code IS NULL THEN
3952: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
3953: OE_Msg_Pub.Add;
3954: RAISE FND_API.G_EXC_ERROR;
3955: END IF;
3956: END IF;
3957:

Line 4016: OE_MSG_PUB.Count_And_Get

4012: oe_debug_pub.add('New trxn extension id after calling Create_Payment_TRXN:'||l_trxn_extension_id);
4013: END IF;
4014: Exception
4015: WHEN FND_API.G_EXC_ERROR THEN
4016: OE_MSG_PUB.Count_And_Get
4017: ( p_count => l_msg_count,
4018: p_data => l_msg_data
4019: );
4020: l_return_status := FND_API.G_RET_STS_ERROR;

Line 4024: OE_MSG_PUB.Count_And_Get

4020: l_return_status := FND_API.G_RET_STS_ERROR;
4021: RAISE FND_API.G_EXC_ERROR;
4022:
4023: WHEN OTHERS THEN
4024: OE_MSG_PUB.Count_And_Get
4025: ( p_count => l_msg_count,
4026: p_data => l_msg_data
4027: );
4028: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');

Line 4029: OE_MSG_PUB.ADD;

4025: ( p_count => l_msg_count,
4026: p_data => l_msg_data
4027: );
4028: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_ACCT_NOT_SET');
4029: OE_MSG_PUB.ADD;
4030: IF l_debug_level > 0 THEN
4031: oe_debug_pub.add( 'OEXUHPMB: ERROR IN CREATE PAYMENT trxn...'||sqlerrm) ;
4032: oe_debug_pub.add('Error messsge ksurendr'||l_return_status);
4033: END IF;

Line 4195: OE_MSG_PUB.Count_And_Get

4191: Exception
4192:
4193: WHEN FND_API.G_EXC_ERROR THEN
4194: x_return_status := FND_API.G_RET_STS_ERROR;
4195: OE_MSG_PUB.Count_And_Get
4196: ( p_count => x_msg_count,
4197: p_data => x_msg_data
4198: );
4199:

Line 4202: OE_MSG_PUB.Count_And_Get

4198: );
4199:
4200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4202: OE_MSG_PUB.Count_And_Get
4203: ( p_count => x_msg_count,
4204: p_data => x_msg_data
4205: );
4206:

Line 4209: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

4205: );
4206:
4207: WHEN OTHERS THEN
4208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4209: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4210: THEN
4211: OE_MSG_PUB.Add_Exc_Msg
4212: ( G_PKG_NAME
4213: , 'Delete_Payment_at_Line'

Line 4211: OE_MSG_PUB.Add_Exc_Msg

4207: WHEN OTHERS THEN
4208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4209: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4210: THEN
4211: OE_MSG_PUB.Add_Exc_Msg
4212: ( G_PKG_NAME
4213: , 'Delete_Payment_at_Line'
4214: );
4215: END IF;