[Home] [Help]
892: CLOSE order_paytype_hold;
893: END IF;
894:
895: x_return_status := FND_API.G_RET_STS_ERROR;
896: FND_MSG_PUB.Count_And_Get
897: ( p_count => x_msg_count
898: , p_data => x_msg_data
899: );
900: WHEN OTHERS THEN
901: IF (order_paytype_hold%isopen) THEN
902: CLOSE order_paytype_hold;
903: END IF;
904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
905: FND_MSG_PUB.Count_And_Get
906: ( p_count => x_msg_count
907: , p_data => x_msg_data
908: );
909:
2027: EXCEPTION
2028:
2029: WHEN OTHERS THEN
2030:
2031: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2032: THEN
2033: oe_msg_pub.Add_Exc_Msg
2034: ( G_PKG_NAME
2035: , 'Update_Row'
2206: EXCEPTION
2207:
2208: WHEN OTHERS THEN
2209: oe_debug_pub.add('Sql error'||sqlerrm);
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'
2597: EXCEPTION
2598:
2599: WHEN OTHERS THEN
2600:
2601: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2602: THEN
2603: oe_msg_pub.Add_Exc_Msg
2604: ( G_PKG_NAME
2605: , 'Delete_Row'
2792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2793:
2794: WHEN OTHERS THEN
2795:
2796: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2797: THEN
2798: oe_msg_pub.Add_Exc_Msg
2799: ( G_PKG_NAME
2800: , 'Query_Row'
2982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2983:
2984: WHEN OTHERS THEN
2985:
2986: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2987: THEN
2988: oe_msg_pub.Add_Exc_Msg
2989: ( G_PKG_NAME
2990: , 'Query_Rows'
3086:
3087: x_return_status := FND_API.G_RET_STS_ERROR;
3088: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3089:
3090: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3091: THEN
3092:
3093: -- Release the lock
3094: ROLLBACK TO Lock_Row;
3106:
3107: x_return_status := FND_API.G_RET_STS_ERROR;
3108: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3109:
3110: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3111: THEN
3112:
3113: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_DELETED');
3114: oe_msg_pub.Add;
3118:
3119: x_return_status := FND_API.G_RET_STS_ERROR;
3120: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3121:
3122: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3123: THEN
3124:
3125: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
3126: oe_msg_pub.Add;
3130:
3131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3132: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3133:
3134: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3135: THEN
3136: oe_msg_pub.Add_Exc_Msg
3137: ( G_PKG_NAME
3138: , 'Lock_Row'
3349: THEN
3350:
3351: IF p_x_Header_Payment_rec.payment_collection_event <> FND_API.G_MISS_CHAR THEN
3352:
3353: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3354: THEN
3355:
3356: FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3357: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_collection_event_name');
3378:
3379: IF p_x_Header_Payment_rec.payment_type_code <> FND_API.G_MISS_CHAR THEN
3380:
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_type');
3408:
3409: IF p_x_Header_Payment_rec.receipt_method_id <> FND_API.G_MISS_NUM THEN
3410:
3411:
3412: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3413: THEN
3414:
3415: FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3416: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Receipt_Method');