[Home] [Help]
907: CLOSE line_paytype_hold;
908: END IF;
909:
910: x_return_status := FND_API.G_RET_STS_ERROR;
911: FND_MSG_PUB.Count_And_Get
912: ( p_count => x_msg_count
913: , p_data => x_msg_data
914: );
915: WHEN OTHERS THEN
916: IF (line_paytype_hold%isopen) THEN
917: CLOSE line_paytype_hold;
918: END IF;
919: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
920: FND_MSG_PUB.Count_And_Get
921: ( p_count => x_msg_count
922: , p_data => x_msg_data
923: );
924:
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'
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'
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'
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'
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'
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;
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;
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;
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'
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');
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');
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');