[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:
1924: EXCEPTION
1925:
1926: WHEN OTHERS THEN
1927:
1928: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1929: THEN
1930: oe_msg_pub.Add_Exc_Msg
1931: ( G_PKG_NAME
1932: , 'Update_Row'
2128: EXCEPTION
2129:
2130: WHEN OTHERS THEN
2131:
2132: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2133: THEN
2134: oe_msg_pub.Add_Exc_Msg
2135: ( G_PKG_NAME
2136: , 'Insert_Row'
2535: EXCEPTION
2536:
2537: WHEN OTHERS THEN
2538:
2539: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2540: THEN
2541: oe_msg_pub.Add_Exc_Msg
2542: ( G_PKG_NAME
2543: , 'Delete_Row'
2736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2737:
2738: WHEN OTHERS THEN
2739:
2740: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2741: THEN
2742: oe_msg_pub.Add_Exc_Msg
2743: ( G_PKG_NAME
2744: , 'Query_Row'
2926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2927:
2928: WHEN OTHERS THEN
2929:
2930: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2931: THEN
2932: oe_msg_pub.Add_Exc_Msg
2933: ( G_PKG_NAME
2934: , 'Query_Rows'
3035:
3036: x_return_status := FND_API.G_RET_STS_ERROR;
3037: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3038:
3039: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3040: THEN
3041:
3042: -- Release the lock
3043: ROLLBACK TO Lock_Row;
3055:
3056: x_return_status := FND_API.G_RET_STS_ERROR;
3057: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3058:
3059: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3060: THEN
3061:
3062: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_DELETED');
3063: oe_msg_pub.Add;
3067:
3068: x_return_status := FND_API.G_RET_STS_ERROR;
3069: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3070:
3071: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3072: THEN
3073:
3074: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
3075: oe_msg_pub.Add;
3079:
3080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3081: p_x_Line_Payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3082:
3083: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3084: THEN
3085: oe_msg_pub.Add_Exc_Msg
3086: ( G_PKG_NAME
3087: , 'Lock_Row'
3300: THEN
3301:
3302: IF p_x_Line_Payment_rec.payment_collection_event <> FND_API.G_MISS_CHAR THEN
3303:
3304: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3305: THEN
3306:
3307: FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3308: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_collection_event_name');
3329:
3330: IF p_x_Line_Payment_rec.payment_type_code <> FND_API.G_MISS_CHAR THEN
3331:
3332:
3333: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3334: THEN
3335:
3336: FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3337: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_type');
3359:
3360: IF p_x_Line_Payment_rec.receipt_method_id <> FND_API.G_MISS_NUM THEN
3361:
3362:
3363: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3364: THEN
3365:
3366: FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3367: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Receipt_Method');