[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:
2109: EXCEPTION
2110:
2111: WHEN OTHERS THEN
2112:
2113: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2114: THEN
2115: oe_msg_pub.Add_Exc_Msg
2116: ( G_PKG_NAME
2117: , 'Update_Row'
2292: EXCEPTION
2293:
2294: WHEN OTHERS THEN
2295: oe_debug_pub.add('Sql error'||sqlerrm);
2296: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2297: THEN
2298: oe_msg_pub.Add_Exc_Msg
2299: ( G_PKG_NAME
2300: , 'Insert_Row'
2683: EXCEPTION
2684:
2685: WHEN OTHERS THEN
2686:
2687: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2688: THEN
2689: oe_msg_pub.Add_Exc_Msg
2690: ( G_PKG_NAME
2691: , 'Delete_Row'
2880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2881:
2882: WHEN OTHERS THEN
2883:
2884: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2885: THEN
2886: oe_msg_pub.Add_Exc_Msg
2887: ( G_PKG_NAME
2888: , 'Query_Row'
3072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3073:
3074: WHEN OTHERS THEN
3075:
3076: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3077: THEN
3078: oe_msg_pub.Add_Exc_Msg
3079: ( G_PKG_NAME
3080: , 'Query_Rows'
3176:
3177: x_return_status := FND_API.G_RET_STS_ERROR;
3178: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3179:
3180: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3181: THEN
3182:
3183: -- Release the lock
3184: ROLLBACK TO Lock_Row;
3196:
3197: x_return_status := FND_API.G_RET_STS_ERROR;
3198: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3199:
3200: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3201: THEN
3202:
3203: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_DELETED');
3204: oe_msg_pub.Add;
3208:
3209: x_return_status := FND_API.G_RET_STS_ERROR;
3210: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_ERROR;
3211:
3212: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3213: THEN
3214:
3215: FND_MESSAGE.SET_NAME('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
3216: oe_msg_pub.Add;
3220:
3221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3222: p_x_Header_Payment_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3223:
3224: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3225: THEN
3226: oe_msg_pub.Add_Exc_Msg
3227: ( G_PKG_NAME
3228: , 'Lock_Row'
3439: THEN
3440:
3441: IF p_x_Header_Payment_rec.payment_collection_event <> FND_API.G_MISS_CHAR THEN
3442:
3443: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3444: THEN
3445:
3446: FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3447: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_collection_event_name');
3468:
3469: IF p_x_Header_Payment_rec.payment_type_code <> FND_API.G_MISS_CHAR THEN
3470:
3471:
3472: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3473: THEN
3474:
3475: FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3476: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_type');
3498:
3499: IF p_x_Header_Payment_rec.receipt_method_id <> FND_API.G_MISS_NUM THEN
3500:
3501:
3502: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3503: THEN
3504:
3505: FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3506: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Receipt_Method');
3528: IF p_x_Header_Payment_rec.payment_percentage <> FND_API.G_MISS_NUM OR
3529: p_x_Header_Payment_rec.payment_amount <> FND_API.G_MISS_NUM
3530: THEN
3531:
3532: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
3533: THEN
3534:
3535: FND_MESSAGE.SET_NAME('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3536: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_percentage');