DBA Data[Home] [Help]

APPS.OE_OE_FORM_LINE_PAYMENT dependencies on FND_API

Line 179: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

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

Line 180: , p_init_msg_list => FND_API.G_TRUE

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

Line 187: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;

Line 188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 189: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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.

Line 190: RAISE FND_API.G_EXC_ERROR;

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:

Line 248: l_x_Line_Payment_tbl(1).db_flag := FND_API.G_FALSE;

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: );

Line 259: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 274: WHEN FND_API.G_EXC_ERROR THEN

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;

Line 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

Line 287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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 ;

Line 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

Line 304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 508: IF FND_API.To_Boolean(l_x_Line_Payment_tbl(1).db_flag) THEN

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;

Line 524: p_validation_level => FND_API.G_VALID_LEVEL_NONE

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

Line 525: , p_init_msg_list => FND_API.G_TRUE

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

Line 532: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;

Line 533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 534: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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);

Line 535: RAISE FND_API.G_EXC_ERROR;

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);

Line 544: x_attribute1 := FND_API.G_MISS_CHAR;

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;

Line 545: x_attribute2 := 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;

Line 546: x_attribute3 := 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;

Line 547: x_attribute4 := 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;

Line 548: x_attribute5 := 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;

Line 549: x_attribute6 := 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;

Line 550: x_attribute7 := 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;

Line 551: x_attribute8 := 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;

Line 552: x_attribute9 := 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;

Line 553: x_attribute10 := 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;

Line 554: x_attribute11 := 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;

Line 555: x_attribute12 := 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;

Line 556: x_attribute13 := 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;

Line 557: x_attribute14 := 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;

Line 558: x_attribute15 := 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;

Line 559: x_context := 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;
563: x_credit_card_code := FND_API.G_MISS_CHAR;

Line 560: x_check_number := 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;

Line 561: x_credit_card_approval_code := 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;
565: x_credit_card_holder_name := FND_API.G_MISS_CHAR;

Line 562: x_credit_card_approval_date := FND_API.G_MISS_DATE;

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;

Line 563: x_credit_card_code := 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;

Line 564: x_credit_card_expiration_date := FND_API.G_MISS_DATE;

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;

Line 565: x_credit_card_holder_name := 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;
569: x_commitment_interfaced_amount := FND_API.G_MISS_NUM;

Line 566: x_credit_card_number := 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;
570: x_payment_number := FND_API.G_MISS_NUM;

Line 567: x_payment_level_code := FND_API.G_MISS_CHAR;

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;

Line 568: x_commitment_applied_amount := 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;

Line 569: x_commitment_interfaced_amount := 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;

Line 570: x_payment_number := 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;

Line 571: x_header_id := FND_API.G_MISS_NUM;

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;

Line 572: x_line_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;

Line 573: x_payment_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;
577: x_payment_set_id := FND_API.G_MISS_NUM;

Line 574: x_payment_collection_event := FND_API.G_MISS_CHAR;

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;

Line 575: x_payment_trx_id := 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;

Line 576: x_payment_type_code := FND_API.G_MISS_CHAR;

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;

Line 577: x_payment_set_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;
581: x_defer_processing_flag := FND_API.G_MISS_CHAR;

Line 578: x_prepaid_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;
582: x_instrument_security_code := FND_API.G_MISS_CHAR; --R12 Cc encryption

Line 579: x_receipt_method_id := FND_API.G_MISS_NUM;

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:

Line 580: x_tangible_id := FND_API.G_MISS_CHAR;

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

Line 581: x_defer_processing_flag := 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
585:

Line 582: x_instrument_security_code := FND_API.G_MISS_CHAR; --R12 Cc encryption

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

Line 862: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 877: WHEN FND_API.G_EXC_ERROR THEN

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;

Line 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

Line 890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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 ;

Line 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

Line 907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1065: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 1157: IF FND_API.To_Boolean(l_x_Line_Payment_tbl(1).db_flag) THEN

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;

Line 1169: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

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

Line 1170: , p_init_msg_list => FND_API.G_TRUE

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

Line 1177: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;

Line 1178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 1179: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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.

Line 1180: RAISE FND_API.G_EXC_ERROR;

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:

Line 1206: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1221: WHEN FND_API.G_EXC_ERROR THEN

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;

Line 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

Line 1234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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 ;

Line 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

Line 1251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1337: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

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

Line 1338: , p_init_msg_list => FND_API.G_TRUE

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

Line 1345: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;

Line 1346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 1347: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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:

Line 1348: RAISE FND_API.G_EXC_ERROR;

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

Line 1361: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1376: WHEN FND_API.G_EXC_ERROR THEN

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;

Line 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

Line 1389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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 ;

Line 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

Line 1406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1495: , p_init_msg_list => FND_API.G_TRUE

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

Line 1521: , p_init_msg_list => FND_API.G_TRUE

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:

Line 1526: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;

Line 1527: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 1528: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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:

Line 1529: RAISE FND_API.G_EXC_ERROR;

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

Line 1538: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1553: WHEN FND_API.G_EXC_ERROR THEN

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;

Line 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

Line 1566: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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 ;

Line 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

Line 1583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1640: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

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;

Line 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

Line 1680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1752: g_Line_Payment_rec.db_flag := FND_API.G_TRUE;

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;