175: -- Call OE_Order_PVT.Process_order
176:
177:
178: OE_Order_PVT.Line_Payments
179: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
180: , p_init_msg_list => FND_API.G_TRUE
181: , p_control_rec => l_control_rec
182: , p_x_Line_Payment_tbl => l_x_Line_Payment_tbl
183: , p_x_old_Line_Payment_tbl => l_x_old_Line_Payment_tbl
176:
177:
178: OE_Order_PVT.Line_Payments
179: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
180: , p_init_msg_list => FND_API.G_TRUE
181: , p_control_rec => l_control_rec
182: , p_x_Line_Payment_tbl => l_x_Line_Payment_tbl
183: , p_x_old_Line_Payment_tbl => l_x_old_Line_Payment_tbl
184: , x_return_Status => l_return_status
183: , p_x_old_Line_Payment_tbl => l_x_old_Line_Payment_tbl
184: , x_return_Status => l_return_status
185: );
186:
187: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
189: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
190: RAISE FND_API.G_EXC_ERROR;
191: END IF;
184: , x_return_Status => l_return_status
185: );
186:
187: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
189: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
190: RAISE FND_API.G_EXC_ERROR;
191: END IF;
192:
185: );
186:
187: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
189: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
190: RAISE FND_API.G_EXC_ERROR;
191: END IF;
192:
193: -- Load OUT parameters.
186:
187: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
189: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
190: RAISE FND_API.G_EXC_ERROR;
191: END IF;
192:
193: -- Load OUT parameters.
194:
244:
245: -- Write to cache.
246: -- Set db_flag to False before writing to cache
247:
248: l_x_Line_Payment_tbl(1).db_flag := FND_API.G_FALSE;
249:
250: Write_Line_Payment
251: ( p_Line_Payment_rec => l_x_Line_PAYMENT_tbl(1)
252: );
255: OE_GLOBALS.G_UI_FLAG := FALSE;
256:
257: -- Set return status.
258:
259: x_return_status := FND_API.G_RET_STS_SUCCESS;
260:
261: -- Get message count and data
262:
263: oe_msg_pub.Count_And_Get
270: END IF;
271:
272: EXCEPTION
273:
274: WHEN FND_API.G_EXC_ERROR THEN
275:
276: OE_GLOBALS.G_UI_FLAG := FALSE;
277:
278: x_return_status := FND_API.G_RET_STS_ERROR;
274: WHEN FND_API.G_EXC_ERROR THEN
275:
276: OE_GLOBALS.G_UI_FLAG := FALSE;
277:
278: x_return_status := FND_API.G_RET_STS_ERROR;
279:
280: -- Get message count and data
281:
282: oe_msg_pub.Count_And_Get
283: ( p_count => x_msg_count
284: , p_data => x_msg_data
285: );
286:
287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
288:
289: OE_GLOBALS.G_UI_FLAG := FALSE;
290:
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
288:
289: OE_GLOBALS.G_UI_FLAG := FALSE;
290:
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
292:
293: -- Get message count and data
294:
295: oe_msg_pub.Count_And_Get
300: WHEN OTHERS THEN
301:
302: OE_GLOBALS.G_UI_FLAG := FALSE;
303:
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
305:
306: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
307: THEN
308: oe_msg_pub.Add_Exc_Msg
504:
505:
506: -- Set Operation.
507:
508: IF FND_API.To_Boolean(l_x_Line_Payment_tbl(1).db_flag) THEN
509: l_x_Line_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
510: ELSE
511: l_x_Line_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
512: END IF;
520: --oe_debug_pub.add('Old card number'||l_x_old_Line_PAYMENT_tbl(1).credit_card_number);
521:
522: OE_Order_PVT.Line_Payments
523: (
524: p_validation_level => FND_API.G_VALID_LEVEL_NONE
525: , p_init_msg_list => FND_API.G_TRUE
526: , p_control_rec => l_control_rec
527: , p_x_Line_Payment_tbl => l_x_Line_PAYMENT_tbl
528: , p_x_old_Line_Payment_tbl => l_x_old_Line_PAYMENT_tbl
521:
522: OE_Order_PVT.Line_Payments
523: (
524: p_validation_level => FND_API.G_VALID_LEVEL_NONE
525: , p_init_msg_list => FND_API.G_TRUE
526: , p_control_rec => l_control_rec
527: , p_x_Line_Payment_tbl => l_x_Line_PAYMENT_tbl
528: , p_x_old_Line_Payment_tbl => l_x_old_Line_PAYMENT_tbl
529: , x_return_status => l_return_status
528: , p_x_old_Line_Payment_tbl => l_x_old_Line_PAYMENT_tbl
529: , x_return_status => l_return_status
530: );
531:
532: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
534: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
535: RAISE FND_API.G_EXC_ERROR;
536: END IF;
529: , x_return_status => l_return_status
530: );
531:
532: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
534: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
535: RAISE FND_API.G_EXC_ERROR;
536: END IF;
537:
530: );
531:
532: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
534: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
535: RAISE FND_API.G_EXC_ERROR;
536: END IF;
537:
538: oe_debug_pub.add('ren: before Line_Payments: ' || p_attr_id);
531:
532: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
534: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
535: RAISE FND_API.G_EXC_ERROR;
536: END IF;
537:
538: oe_debug_pub.add('ren: before Line_Payments: ' || p_attr_id);
539: --oe_debug_pub.add('New Card number'||l_x_Line_PAYMENT_tbl(1).credit_card_number);
540: --oe_debug_pub.add('New Card holder'||l_x_Line_PAYMENT_tbl(1).credit_card_holder_name);
541: --oe_debug_pub.add('Old card number'||l_Line_Payment_rec.credit_card_number);
542: -- Init OUT parameters to missing.
543:
544: x_attribute1 := FND_API.G_MISS_CHAR;
545: x_attribute2 := FND_API.G_MISS_CHAR;
546: x_attribute3 := FND_API.G_MISS_CHAR;
547: x_attribute4 := FND_API.G_MISS_CHAR;
548: x_attribute5 := FND_API.G_MISS_CHAR;
541: --oe_debug_pub.add('Old card number'||l_Line_Payment_rec.credit_card_number);
542: -- Init OUT parameters to missing.
543:
544: x_attribute1 := FND_API.G_MISS_CHAR;
545: x_attribute2 := FND_API.G_MISS_CHAR;
546: x_attribute3 := FND_API.G_MISS_CHAR;
547: x_attribute4 := FND_API.G_MISS_CHAR;
548: x_attribute5 := FND_API.G_MISS_CHAR;
549: x_attribute6 := FND_API.G_MISS_CHAR;
542: -- Init OUT parameters to missing.
543:
544: x_attribute1 := FND_API.G_MISS_CHAR;
545: x_attribute2 := FND_API.G_MISS_CHAR;
546: x_attribute3 := FND_API.G_MISS_CHAR;
547: x_attribute4 := FND_API.G_MISS_CHAR;
548: x_attribute5 := FND_API.G_MISS_CHAR;
549: x_attribute6 := FND_API.G_MISS_CHAR;
550: x_attribute7 := FND_API.G_MISS_CHAR;
543:
544: x_attribute1 := FND_API.G_MISS_CHAR;
545: x_attribute2 := FND_API.G_MISS_CHAR;
546: x_attribute3 := FND_API.G_MISS_CHAR;
547: x_attribute4 := FND_API.G_MISS_CHAR;
548: x_attribute5 := FND_API.G_MISS_CHAR;
549: x_attribute6 := FND_API.G_MISS_CHAR;
550: x_attribute7 := FND_API.G_MISS_CHAR;
551: x_attribute8 := FND_API.G_MISS_CHAR;
544: x_attribute1 := FND_API.G_MISS_CHAR;
545: x_attribute2 := FND_API.G_MISS_CHAR;
546: x_attribute3 := FND_API.G_MISS_CHAR;
547: x_attribute4 := FND_API.G_MISS_CHAR;
548: x_attribute5 := FND_API.G_MISS_CHAR;
549: x_attribute6 := FND_API.G_MISS_CHAR;
550: x_attribute7 := FND_API.G_MISS_CHAR;
551: x_attribute8 := FND_API.G_MISS_CHAR;
552: x_attribute9 := FND_API.G_MISS_CHAR;
545: x_attribute2 := FND_API.G_MISS_CHAR;
546: x_attribute3 := FND_API.G_MISS_CHAR;
547: x_attribute4 := FND_API.G_MISS_CHAR;
548: x_attribute5 := FND_API.G_MISS_CHAR;
549: x_attribute6 := FND_API.G_MISS_CHAR;
550: x_attribute7 := FND_API.G_MISS_CHAR;
551: x_attribute8 := FND_API.G_MISS_CHAR;
552: x_attribute9 := FND_API.G_MISS_CHAR;
553: x_attribute10 := FND_API.G_MISS_CHAR;
546: x_attribute3 := FND_API.G_MISS_CHAR;
547: x_attribute4 := FND_API.G_MISS_CHAR;
548: x_attribute5 := FND_API.G_MISS_CHAR;
549: x_attribute6 := FND_API.G_MISS_CHAR;
550: x_attribute7 := FND_API.G_MISS_CHAR;
551: x_attribute8 := FND_API.G_MISS_CHAR;
552: x_attribute9 := FND_API.G_MISS_CHAR;
553: x_attribute10 := FND_API.G_MISS_CHAR;
554: x_attribute11 := FND_API.G_MISS_CHAR;
547: x_attribute4 := FND_API.G_MISS_CHAR;
548: x_attribute5 := FND_API.G_MISS_CHAR;
549: x_attribute6 := FND_API.G_MISS_CHAR;
550: x_attribute7 := FND_API.G_MISS_CHAR;
551: x_attribute8 := FND_API.G_MISS_CHAR;
552: x_attribute9 := FND_API.G_MISS_CHAR;
553: x_attribute10 := FND_API.G_MISS_CHAR;
554: x_attribute11 := FND_API.G_MISS_CHAR;
555: x_attribute12 := FND_API.G_MISS_CHAR;
548: x_attribute5 := FND_API.G_MISS_CHAR;
549: x_attribute6 := FND_API.G_MISS_CHAR;
550: x_attribute7 := FND_API.G_MISS_CHAR;
551: x_attribute8 := FND_API.G_MISS_CHAR;
552: x_attribute9 := FND_API.G_MISS_CHAR;
553: x_attribute10 := FND_API.G_MISS_CHAR;
554: x_attribute11 := FND_API.G_MISS_CHAR;
555: x_attribute12 := FND_API.G_MISS_CHAR;
556: x_attribute13 := FND_API.G_MISS_CHAR;
549: x_attribute6 := FND_API.G_MISS_CHAR;
550: x_attribute7 := FND_API.G_MISS_CHAR;
551: x_attribute8 := FND_API.G_MISS_CHAR;
552: x_attribute9 := FND_API.G_MISS_CHAR;
553: x_attribute10 := FND_API.G_MISS_CHAR;
554: x_attribute11 := FND_API.G_MISS_CHAR;
555: x_attribute12 := FND_API.G_MISS_CHAR;
556: x_attribute13 := FND_API.G_MISS_CHAR;
557: x_attribute14 := FND_API.G_MISS_CHAR;
550: x_attribute7 := FND_API.G_MISS_CHAR;
551: x_attribute8 := FND_API.G_MISS_CHAR;
552: x_attribute9 := FND_API.G_MISS_CHAR;
553: x_attribute10 := FND_API.G_MISS_CHAR;
554: x_attribute11 := FND_API.G_MISS_CHAR;
555: x_attribute12 := FND_API.G_MISS_CHAR;
556: x_attribute13 := FND_API.G_MISS_CHAR;
557: x_attribute14 := FND_API.G_MISS_CHAR;
558: x_attribute15 := FND_API.G_MISS_CHAR;
551: x_attribute8 := FND_API.G_MISS_CHAR;
552: x_attribute9 := FND_API.G_MISS_CHAR;
553: x_attribute10 := FND_API.G_MISS_CHAR;
554: x_attribute11 := FND_API.G_MISS_CHAR;
555: x_attribute12 := FND_API.G_MISS_CHAR;
556: x_attribute13 := FND_API.G_MISS_CHAR;
557: x_attribute14 := FND_API.G_MISS_CHAR;
558: x_attribute15 := FND_API.G_MISS_CHAR;
559: x_context := FND_API.G_MISS_CHAR;
552: x_attribute9 := FND_API.G_MISS_CHAR;
553: x_attribute10 := FND_API.G_MISS_CHAR;
554: x_attribute11 := FND_API.G_MISS_CHAR;
555: x_attribute12 := FND_API.G_MISS_CHAR;
556: x_attribute13 := FND_API.G_MISS_CHAR;
557: x_attribute14 := FND_API.G_MISS_CHAR;
558: x_attribute15 := FND_API.G_MISS_CHAR;
559: x_context := FND_API.G_MISS_CHAR;
560: x_check_number := FND_API.G_MISS_CHAR;
553: x_attribute10 := FND_API.G_MISS_CHAR;
554: x_attribute11 := FND_API.G_MISS_CHAR;
555: x_attribute12 := FND_API.G_MISS_CHAR;
556: x_attribute13 := FND_API.G_MISS_CHAR;
557: x_attribute14 := FND_API.G_MISS_CHAR;
558: x_attribute15 := FND_API.G_MISS_CHAR;
559: x_context := FND_API.G_MISS_CHAR;
560: x_check_number := FND_API.G_MISS_CHAR;
561: x_credit_card_approval_code := FND_API.G_MISS_CHAR;
554: x_attribute11 := FND_API.G_MISS_CHAR;
555: x_attribute12 := FND_API.G_MISS_CHAR;
556: x_attribute13 := FND_API.G_MISS_CHAR;
557: x_attribute14 := FND_API.G_MISS_CHAR;
558: x_attribute15 := FND_API.G_MISS_CHAR;
559: x_context := FND_API.G_MISS_CHAR;
560: x_check_number := FND_API.G_MISS_CHAR;
561: x_credit_card_approval_code := FND_API.G_MISS_CHAR;
562: x_credit_card_approval_date := FND_API.G_MISS_DATE;
555: x_attribute12 := FND_API.G_MISS_CHAR;
556: x_attribute13 := FND_API.G_MISS_CHAR;
557: x_attribute14 := FND_API.G_MISS_CHAR;
558: x_attribute15 := FND_API.G_MISS_CHAR;
559: x_context := FND_API.G_MISS_CHAR;
560: x_check_number := FND_API.G_MISS_CHAR;
561: x_credit_card_approval_code := FND_API.G_MISS_CHAR;
562: x_credit_card_approval_date := FND_API.G_MISS_DATE;
563: x_credit_card_code := FND_API.G_MISS_CHAR;
556: x_attribute13 := FND_API.G_MISS_CHAR;
557: x_attribute14 := FND_API.G_MISS_CHAR;
558: x_attribute15 := FND_API.G_MISS_CHAR;
559: x_context := FND_API.G_MISS_CHAR;
560: x_check_number := FND_API.G_MISS_CHAR;
561: x_credit_card_approval_code := FND_API.G_MISS_CHAR;
562: x_credit_card_approval_date := FND_API.G_MISS_DATE;
563: x_credit_card_code := FND_API.G_MISS_CHAR;
564: x_credit_card_expiration_date := FND_API.G_MISS_DATE;
557: x_attribute14 := FND_API.G_MISS_CHAR;
558: x_attribute15 := FND_API.G_MISS_CHAR;
559: x_context := FND_API.G_MISS_CHAR;
560: x_check_number := FND_API.G_MISS_CHAR;
561: x_credit_card_approval_code := FND_API.G_MISS_CHAR;
562: x_credit_card_approval_date := FND_API.G_MISS_DATE;
563: x_credit_card_code := FND_API.G_MISS_CHAR;
564: x_credit_card_expiration_date := FND_API.G_MISS_DATE;
565: x_credit_card_holder_name := FND_API.G_MISS_CHAR;
558: x_attribute15 := FND_API.G_MISS_CHAR;
559: x_context := FND_API.G_MISS_CHAR;
560: x_check_number := FND_API.G_MISS_CHAR;
561: x_credit_card_approval_code := FND_API.G_MISS_CHAR;
562: x_credit_card_approval_date := FND_API.G_MISS_DATE;
563: x_credit_card_code := FND_API.G_MISS_CHAR;
564: x_credit_card_expiration_date := FND_API.G_MISS_DATE;
565: x_credit_card_holder_name := FND_API.G_MISS_CHAR;
566: x_credit_card_number := FND_API.G_MISS_CHAR;
559: x_context := FND_API.G_MISS_CHAR;
560: x_check_number := FND_API.G_MISS_CHAR;
561: x_credit_card_approval_code := FND_API.G_MISS_CHAR;
562: x_credit_card_approval_date := FND_API.G_MISS_DATE;
563: x_credit_card_code := FND_API.G_MISS_CHAR;
564: x_credit_card_expiration_date := FND_API.G_MISS_DATE;
565: x_credit_card_holder_name := FND_API.G_MISS_CHAR;
566: x_credit_card_number := FND_API.G_MISS_CHAR;
567: x_payment_level_code := FND_API.G_MISS_CHAR;
560: x_check_number := FND_API.G_MISS_CHAR;
561: x_credit_card_approval_code := FND_API.G_MISS_CHAR;
562: x_credit_card_approval_date := FND_API.G_MISS_DATE;
563: x_credit_card_code := FND_API.G_MISS_CHAR;
564: x_credit_card_expiration_date := FND_API.G_MISS_DATE;
565: x_credit_card_holder_name := FND_API.G_MISS_CHAR;
566: x_credit_card_number := FND_API.G_MISS_CHAR;
567: x_payment_level_code := FND_API.G_MISS_CHAR;
568: x_commitment_applied_amount := FND_API.G_MISS_NUM;
561: x_credit_card_approval_code := FND_API.G_MISS_CHAR;
562: x_credit_card_approval_date := FND_API.G_MISS_DATE;
563: x_credit_card_code := FND_API.G_MISS_CHAR;
564: x_credit_card_expiration_date := FND_API.G_MISS_DATE;
565: x_credit_card_holder_name := FND_API.G_MISS_CHAR;
566: x_credit_card_number := FND_API.G_MISS_CHAR;
567: x_payment_level_code := FND_API.G_MISS_CHAR;
568: x_commitment_applied_amount := FND_API.G_MISS_NUM;
569: x_commitment_interfaced_amount := FND_API.G_MISS_NUM;
562: x_credit_card_approval_date := FND_API.G_MISS_DATE;
563: x_credit_card_code := FND_API.G_MISS_CHAR;
564: x_credit_card_expiration_date := FND_API.G_MISS_DATE;
565: x_credit_card_holder_name := FND_API.G_MISS_CHAR;
566: x_credit_card_number := FND_API.G_MISS_CHAR;
567: x_payment_level_code := FND_API.G_MISS_CHAR;
568: x_commitment_applied_amount := FND_API.G_MISS_NUM;
569: x_commitment_interfaced_amount := FND_API.G_MISS_NUM;
570: x_payment_number := FND_API.G_MISS_NUM;
563: x_credit_card_code := FND_API.G_MISS_CHAR;
564: x_credit_card_expiration_date := FND_API.G_MISS_DATE;
565: x_credit_card_holder_name := FND_API.G_MISS_CHAR;
566: x_credit_card_number := FND_API.G_MISS_CHAR;
567: x_payment_level_code := FND_API.G_MISS_CHAR;
568: x_commitment_applied_amount := FND_API.G_MISS_NUM;
569: x_commitment_interfaced_amount := FND_API.G_MISS_NUM;
570: x_payment_number := FND_API.G_MISS_NUM;
571: x_header_id := FND_API.G_MISS_NUM;
564: x_credit_card_expiration_date := FND_API.G_MISS_DATE;
565: x_credit_card_holder_name := FND_API.G_MISS_CHAR;
566: x_credit_card_number := FND_API.G_MISS_CHAR;
567: x_payment_level_code := FND_API.G_MISS_CHAR;
568: x_commitment_applied_amount := FND_API.G_MISS_NUM;
569: x_commitment_interfaced_amount := FND_API.G_MISS_NUM;
570: x_payment_number := FND_API.G_MISS_NUM;
571: x_header_id := FND_API.G_MISS_NUM;
572: x_line_id := FND_API.G_MISS_NUM;
565: x_credit_card_holder_name := FND_API.G_MISS_CHAR;
566: x_credit_card_number := FND_API.G_MISS_CHAR;
567: x_payment_level_code := FND_API.G_MISS_CHAR;
568: x_commitment_applied_amount := FND_API.G_MISS_NUM;
569: x_commitment_interfaced_amount := FND_API.G_MISS_NUM;
570: x_payment_number := FND_API.G_MISS_NUM;
571: x_header_id := FND_API.G_MISS_NUM;
572: x_line_id := FND_API.G_MISS_NUM;
573: x_payment_amount := FND_API.G_MISS_NUM;
566: x_credit_card_number := FND_API.G_MISS_CHAR;
567: x_payment_level_code := FND_API.G_MISS_CHAR;
568: x_commitment_applied_amount := FND_API.G_MISS_NUM;
569: x_commitment_interfaced_amount := FND_API.G_MISS_NUM;
570: x_payment_number := FND_API.G_MISS_NUM;
571: x_header_id := FND_API.G_MISS_NUM;
572: x_line_id := FND_API.G_MISS_NUM;
573: x_payment_amount := FND_API.G_MISS_NUM;
574: x_payment_collection_event := FND_API.G_MISS_CHAR;
567: x_payment_level_code := FND_API.G_MISS_CHAR;
568: x_commitment_applied_amount := FND_API.G_MISS_NUM;
569: x_commitment_interfaced_amount := FND_API.G_MISS_NUM;
570: x_payment_number := FND_API.G_MISS_NUM;
571: x_header_id := FND_API.G_MISS_NUM;
572: x_line_id := FND_API.G_MISS_NUM;
573: x_payment_amount := FND_API.G_MISS_NUM;
574: x_payment_collection_event := FND_API.G_MISS_CHAR;
575: x_payment_trx_id := FND_API.G_MISS_NUM;
568: x_commitment_applied_amount := FND_API.G_MISS_NUM;
569: x_commitment_interfaced_amount := FND_API.G_MISS_NUM;
570: x_payment_number := FND_API.G_MISS_NUM;
571: x_header_id := FND_API.G_MISS_NUM;
572: x_line_id := FND_API.G_MISS_NUM;
573: x_payment_amount := FND_API.G_MISS_NUM;
574: x_payment_collection_event := FND_API.G_MISS_CHAR;
575: x_payment_trx_id := FND_API.G_MISS_NUM;
576: x_payment_type_code := FND_API.G_MISS_CHAR;
569: x_commitment_interfaced_amount := FND_API.G_MISS_NUM;
570: x_payment_number := FND_API.G_MISS_NUM;
571: x_header_id := FND_API.G_MISS_NUM;
572: x_line_id := FND_API.G_MISS_NUM;
573: x_payment_amount := FND_API.G_MISS_NUM;
574: x_payment_collection_event := FND_API.G_MISS_CHAR;
575: x_payment_trx_id := FND_API.G_MISS_NUM;
576: x_payment_type_code := FND_API.G_MISS_CHAR;
577: x_payment_set_id := FND_API.G_MISS_NUM;
570: x_payment_number := FND_API.G_MISS_NUM;
571: x_header_id := FND_API.G_MISS_NUM;
572: x_line_id := FND_API.G_MISS_NUM;
573: x_payment_amount := FND_API.G_MISS_NUM;
574: x_payment_collection_event := FND_API.G_MISS_CHAR;
575: x_payment_trx_id := FND_API.G_MISS_NUM;
576: x_payment_type_code := FND_API.G_MISS_CHAR;
577: x_payment_set_id := FND_API.G_MISS_NUM;
578: x_prepaid_amount := FND_API.G_MISS_NUM;
571: x_header_id := FND_API.G_MISS_NUM;
572: x_line_id := FND_API.G_MISS_NUM;
573: x_payment_amount := FND_API.G_MISS_NUM;
574: x_payment_collection_event := FND_API.G_MISS_CHAR;
575: x_payment_trx_id := FND_API.G_MISS_NUM;
576: x_payment_type_code := FND_API.G_MISS_CHAR;
577: x_payment_set_id := FND_API.G_MISS_NUM;
578: x_prepaid_amount := FND_API.G_MISS_NUM;
579: x_receipt_method_id := FND_API.G_MISS_NUM;
572: x_line_id := FND_API.G_MISS_NUM;
573: x_payment_amount := FND_API.G_MISS_NUM;
574: x_payment_collection_event := FND_API.G_MISS_CHAR;
575: x_payment_trx_id := FND_API.G_MISS_NUM;
576: x_payment_type_code := FND_API.G_MISS_CHAR;
577: x_payment_set_id := FND_API.G_MISS_NUM;
578: x_prepaid_amount := FND_API.G_MISS_NUM;
579: x_receipt_method_id := FND_API.G_MISS_NUM;
580: x_tangible_id := FND_API.G_MISS_CHAR;
573: x_payment_amount := FND_API.G_MISS_NUM;
574: x_payment_collection_event := FND_API.G_MISS_CHAR;
575: x_payment_trx_id := FND_API.G_MISS_NUM;
576: x_payment_type_code := FND_API.G_MISS_CHAR;
577: x_payment_set_id := FND_API.G_MISS_NUM;
578: x_prepaid_amount := FND_API.G_MISS_NUM;
579: x_receipt_method_id := FND_API.G_MISS_NUM;
580: x_tangible_id := FND_API.G_MISS_CHAR;
581: x_defer_processing_flag := FND_API.G_MISS_CHAR;
574: x_payment_collection_event := FND_API.G_MISS_CHAR;
575: x_payment_trx_id := FND_API.G_MISS_NUM;
576: x_payment_type_code := FND_API.G_MISS_CHAR;
577: x_payment_set_id := FND_API.G_MISS_NUM;
578: x_prepaid_amount := FND_API.G_MISS_NUM;
579: x_receipt_method_id := FND_API.G_MISS_NUM;
580: x_tangible_id := FND_API.G_MISS_CHAR;
581: x_defer_processing_flag := FND_API.G_MISS_CHAR;
582: x_instrument_security_code := FND_API.G_MISS_CHAR; --R12 Cc encryption
575: x_payment_trx_id := FND_API.G_MISS_NUM;
576: x_payment_type_code := FND_API.G_MISS_CHAR;
577: x_payment_set_id := FND_API.G_MISS_NUM;
578: x_prepaid_amount := FND_API.G_MISS_NUM;
579: x_receipt_method_id := FND_API.G_MISS_NUM;
580: x_tangible_id := FND_API.G_MISS_CHAR;
581: x_defer_processing_flag := FND_API.G_MISS_CHAR;
582: x_instrument_security_code := FND_API.G_MISS_CHAR; --R12 Cc encryption
583:
576: x_payment_type_code := FND_API.G_MISS_CHAR;
577: x_payment_set_id := FND_API.G_MISS_NUM;
578: x_prepaid_amount := FND_API.G_MISS_NUM;
579: x_receipt_method_id := FND_API.G_MISS_NUM;
580: x_tangible_id := FND_API.G_MISS_CHAR;
581: x_defer_processing_flag := FND_API.G_MISS_CHAR;
582: x_instrument_security_code := FND_API.G_MISS_CHAR; --R12 Cc encryption
583:
584: -- Load display out parameters if any
577: x_payment_set_id := FND_API.G_MISS_NUM;
578: x_prepaid_amount := FND_API.G_MISS_NUM;
579: x_receipt_method_id := FND_API.G_MISS_NUM;
580: x_tangible_id := FND_API.G_MISS_CHAR;
581: x_defer_processing_flag := FND_API.G_MISS_CHAR;
582: x_instrument_security_code := FND_API.G_MISS_CHAR; --R12 Cc encryption
583:
584: -- Load display out parameters if any
585:
578: x_prepaid_amount := FND_API.G_MISS_NUM;
579: x_receipt_method_id := FND_API.G_MISS_NUM;
580: x_tangible_id := FND_API.G_MISS_CHAR;
581: x_defer_processing_flag := FND_API.G_MISS_CHAR;
582: x_instrument_security_code := FND_API.G_MISS_CHAR; --R12 Cc encryption
583:
584: -- Load display out parameters if any
585:
586: l_Line_Payment_val_rec := OE_Line_PAYMENT_Util.Get_Values
858: OE_GLOBALS.G_UI_FLAG := FALSE;
859:
860: -- Set return status.
861:
862: x_return_status := FND_API.G_RET_STS_SUCCESS;
863:
864: -- Get message count and data
865:
866: oe_msg_pub.Count_And_Get
873: END IF;
874:
875: EXCEPTION
876:
877: WHEN FND_API.G_EXC_ERROR THEN
878:
879: OE_GLOBALS.G_UI_FLAG := FALSE;
880:
881: x_return_status := FND_API.G_RET_STS_ERROR;
877: WHEN FND_API.G_EXC_ERROR THEN
878:
879: OE_GLOBALS.G_UI_FLAG := FALSE;
880:
881: x_return_status := FND_API.G_RET_STS_ERROR;
882:
883: -- Get message count and data
884:
885: oe_msg_pub.Count_And_Get
886: ( p_count => x_msg_count
887: , p_data => x_msg_data
888: );
889:
890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
891:
892: OE_GLOBALS.G_UI_FLAG := FALSE;
893:
894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
891:
892: OE_GLOBALS.G_UI_FLAG := FALSE;
893:
894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
895:
896: -- Get message count and data
897:
898: oe_msg_pub.Count_And_Get
903: WHEN OTHERS THEN
904:
905: OE_GLOBALS.G_UI_FLAG := FALSE;
906:
907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
908:
909: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
910: THEN
911: oe_msg_pub.Add_Exc_Msg
1061: , 'Unrecognized attribute'
1062: );
1063: END IF;
1064:
1065: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1066:
1067: END IF;
1068: EXCEPTION
1069: WHEN OTHERS THEN
1073: ( G_PKG_NAME
1074: , 'Copy_Attribute_To_Rec'
1075: );
1076: END IF;
1077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1078: END Copy_Attribute_To_Rec;
1079: -- R12 CC Encryption
1080:
1081:
1153: );
1154:
1155: -- Set Operation.
1156:
1157: IF FND_API.To_Boolean(l_x_Line_Payment_tbl(1).db_flag) THEN
1158: l_x_Line_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
1159: ELSE
1160: l_x_Line_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
1161: END IF;
1165: -- Call OE_Order_PVT.Process_order
1166:
1167:
1168: OE_Order_PVT.Line_Payments
1169: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
1170: , p_init_msg_list => FND_API.G_TRUE
1171: , p_control_rec => l_control_rec
1172: , p_x_Line_Payment_tbl => l_x_Line_PAYMENT_tbl
1173: , p_x_old_Line_Payment_tbl => l_x_old_Line_PAYMENT_tbl
1166:
1167:
1168: OE_Order_PVT.Line_Payments
1169: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
1170: , p_init_msg_list => FND_API.G_TRUE
1171: , p_control_rec => l_control_rec
1172: , p_x_Line_Payment_tbl => l_x_Line_PAYMENT_tbl
1173: , p_x_old_Line_Payment_tbl => l_x_old_Line_PAYMENT_tbl
1174: , x_return_status => l_return_status
1173: , p_x_old_Line_Payment_tbl => l_x_old_Line_PAYMENT_tbl
1174: , x_return_status => l_return_status
1175: );
1176:
1177: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1179: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1180: RAISE FND_API.G_EXC_ERROR;
1181: END IF;
1174: , x_return_status => l_return_status
1175: );
1176:
1177: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1179: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1180: RAISE FND_API.G_EXC_ERROR;
1181: END IF;
1182:
1175: );
1176:
1177: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1179: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1180: RAISE FND_API.G_EXC_ERROR;
1181: END IF;
1182:
1183: -- Load OUT parameters.
1176:
1177: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1179: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1180: RAISE FND_API.G_EXC_ERROR;
1181: END IF;
1182:
1183: -- Load OUT parameters.
1184:
1202: OE_GLOBALS.G_UI_FLAG := FALSE;
1203:
1204: -- Set return status.
1205:
1206: x_return_status := FND_API.G_RET_STS_SUCCESS;
1207:
1208: -- Get message count and data
1209:
1210: oe_msg_pub.Count_And_Get
1217: END IF;
1218:
1219: EXCEPTION
1220:
1221: WHEN FND_API.G_EXC_ERROR THEN
1222:
1223: OE_GLOBALS.G_UI_FLAG := FALSE;
1224:
1225: x_return_status := FND_API.G_RET_STS_ERROR;
1221: WHEN FND_API.G_EXC_ERROR THEN
1222:
1223: OE_GLOBALS.G_UI_FLAG := FALSE;
1224:
1225: x_return_status := FND_API.G_RET_STS_ERROR;
1226:
1227: -- Get message count and data
1228:
1229: oe_msg_pub.Count_And_Get
1230: ( p_count => x_msg_count
1231: , p_data => x_msg_data
1232: );
1233:
1234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1235:
1236: OE_GLOBALS.G_UI_FLAG := FALSE;
1237:
1238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1235:
1236: OE_GLOBALS.G_UI_FLAG := FALSE;
1237:
1238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1239:
1240: -- Get message count and data
1241:
1242: oe_msg_pub.Count_And_Get
1247: WHEN OTHERS THEN
1248:
1249: OE_GLOBALS.G_UI_FLAG := FALSE;
1250:
1251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1252:
1253: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1254: THEN
1255: oe_msg_pub.Add_Exc_Msg
1333: -- Call OE_Order_PVT.Process_order
1334:
1335:
1336: OE_Order_PVT.Line_Payments
1337: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
1338: , p_init_msg_list => FND_API.G_TRUE
1339: , p_control_rec => l_control_rec
1340: , p_x_Line_Payment_tbl => l_x_Line_Payment_tbl
1341: , p_x_old_Line_Payment_tbl => l_x_old_Line_Payment_tbl
1334:
1335:
1336: OE_Order_PVT.Line_Payments
1337: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
1338: , p_init_msg_list => FND_API.G_TRUE
1339: , p_control_rec => l_control_rec
1340: , p_x_Line_Payment_tbl => l_x_Line_Payment_tbl
1341: , p_x_old_Line_Payment_tbl => l_x_old_Line_Payment_tbl
1342: , x_return_status => l_return_status
1341: , p_x_old_Line_Payment_tbl => l_x_old_Line_Payment_tbl
1342: , x_return_status => l_return_status
1343: );
1344:
1345: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1347: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1348: RAISE FND_API.G_EXC_ERROR;
1349: END IF;
1342: , x_return_status => l_return_status
1343: );
1344:
1345: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1347: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1348: RAISE FND_API.G_EXC_ERROR;
1349: END IF;
1350:
1343: );
1344:
1345: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1347: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1348: RAISE FND_API.G_EXC_ERROR;
1349: END IF;
1350:
1351:
1344:
1345: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1347: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1348: RAISE FND_API.G_EXC_ERROR;
1349: END IF;
1350:
1351:
1352: -- Clear Line_Payment record cache
1357: OE_GLOBALS.G_UI_FLAG := FALSE;
1358:
1359: -- Set return status.
1360:
1361: x_return_status := FND_API.G_RET_STS_SUCCESS;
1362:
1363: -- Get message count and data
1364:
1365: oe_msg_pub.Count_And_Get
1372: END IF;
1373:
1374: EXCEPTION
1375:
1376: WHEN FND_API.G_EXC_ERROR THEN
1377:
1378: OE_GLOBALS.G_UI_FLAG := FALSE;
1379:
1380: x_return_status := FND_API.G_RET_STS_ERROR;
1376: WHEN FND_API.G_EXC_ERROR THEN
1377:
1378: OE_GLOBALS.G_UI_FLAG := FALSE;
1379:
1380: x_return_status := FND_API.G_RET_STS_ERROR;
1381:
1382: -- Get message count and data
1383:
1384: oe_msg_pub.Count_And_Get
1385: ( p_count => x_msg_count
1386: , p_data => x_msg_data
1387: );
1388:
1389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1390:
1391: OE_GLOBALS.G_UI_FLAG := FALSE;
1392:
1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1390:
1391: OE_GLOBALS.G_UI_FLAG := FALSE;
1392:
1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1394:
1395: -- Get message count and data
1396:
1397: oe_msg_pub.Count_And_Get
1402: WHEN OTHERS THEN
1403:
1404: OE_GLOBALS.G_UI_FLAG := FALSE;
1405:
1406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1407:
1408: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1409: THEN
1410: oe_msg_pub.Add_Exc_Msg
1491: -- Call OE_Order_PVT.Process_order
1492:
1493: OE_Order_PVT.Process_order
1494: ( p_api_version_number => 1.0
1495: , p_init_msg_list => FND_API.G_TRUE
1496: , x_return_status => l_return_status
1497: , x_msg_count => x_msg_count
1498: , x_msg_data => x_msg_data
1499: , p_control_rec => l_control_rec
1517: );
1518:
1519: Oe_Order_Pvt.Process_Requests_And_Notify
1520: ( p_process_requests => TRUE
1521: , p_init_msg_list => FND_API.G_TRUE
1522: , p_notify => FALSE
1523: , x_return_status => l_return_status
1524: );
1525:
1522: , p_notify => FALSE
1523: , x_return_status => l_return_status
1524: );
1525:
1526: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1528: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1529: RAISE FND_API.G_EXC_ERROR;
1530: END IF;
1523: , x_return_status => l_return_status
1524: );
1525:
1526: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1528: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1529: RAISE FND_API.G_EXC_ERROR;
1530: END IF;
1531:
1524: );
1525:
1526: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1528: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1529: RAISE FND_API.G_EXC_ERROR;
1530: END IF;
1531:
1532:
1525:
1526: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1528: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1529: RAISE FND_API.G_EXC_ERROR;
1530: END IF;
1531:
1532:
1533: -- Re-set the UI flag to FALSE
1534: OE_GLOBALS.G_UI_FLAG := FALSE;
1535:
1536: -- Set return status.
1537:
1538: x_return_status := FND_API.G_RET_STS_SUCCESS;
1539:
1540: -- Get message count and data
1541:
1542: oe_msg_pub.Count_And_Get
1549: END IF;
1550:
1551: EXCEPTION
1552:
1553: WHEN FND_API.G_EXC_ERROR THEN
1554:
1555: OE_GLOBALS.G_UI_FLAG := FALSE;
1556:
1557: x_return_status := FND_API.G_RET_STS_ERROR;
1553: WHEN FND_API.G_EXC_ERROR THEN
1554:
1555: OE_GLOBALS.G_UI_FLAG := FALSE;
1556:
1557: x_return_status := FND_API.G_RET_STS_ERROR;
1558:
1559: -- Get message count and data
1560:
1561: oe_msg_pub.Count_And_Get
1562: ( p_count => x_msg_count
1563: , p_data => x_msg_data
1564: );
1565:
1566: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1567:
1568: OE_GLOBALS.G_UI_FLAG := FALSE;
1569:
1570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1566: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1567:
1568: OE_GLOBALS.G_UI_FLAG := FALSE;
1569:
1570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1571:
1572: -- Get message count and data
1573:
1574: oe_msg_pub.Count_And_Get
1579: WHEN OTHERS THEN
1580:
1581: OE_GLOBALS.G_UI_FLAG := FALSE;
1582:
1583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1584:
1585: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1586: THEN
1587: oe_msg_pub.Add_Exc_Msg
1636:
1637: OE_Line_Payment_Util.Lock_Row
1638: ( x_return_status => l_return_status
1639: , p_x_line_Payment_rec => l_x_line_payment_rec );
1640: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1641:
1642: -- Set DB flag and write record to cache.
1643:
1644: l_x_Line_Payment_rec.db_flag := FND_API.G_TRUE;
1640: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1641:
1642: -- Set DB flag and write record to cache.
1643:
1644: l_x_Line_Payment_rec.db_flag := FND_API.G_TRUE;
1645:
1646: Write_Line_Payment
1647: ( p_Line_Payment_rec => l_x_Line_Payment_rec
1648: , p_db_record => TRUE
1676: , 'Lock_Row'
1677: );
1678: END IF;
1679:
1680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1681:
1682: -- Get message count and data
1683:
1684: oe_msg_pub.Count_And_Get
1748: , p_header_id => p_header_id
1749: , x_line_Payment_rec => g_Line_Payment_rec
1750: );
1751:
1752: g_Line_Payment_rec.db_flag := FND_API.G_TRUE;
1753:
1754: -- Load DB record
1755:
1756: g_db_Line_Payment_rec := g_Line_PAYMENT_rec;