eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_OE_FORM_HEADER_PAYMENT dependencies on FND_API

Line 162: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

158:
159: -- Call OE_Order_PVT.Process_order
160:
161: OE_Order_PVT.Header_Payments
162: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
163: , p_init_msg_list => FND_API.G_TRUE
164: , p_control_rec => l_control_rec
165: , p_x_Header_Payment_tbl => l_x_Header_Payment_tbl
166: , p_x_old_Header_Payment_tbl => l_x_old_Header_Payment_tbl

Line 163: , p_init_msg_list => FND_API.G_TRUE

159: -- Call OE_Order_PVT.Process_order
160:
161: OE_Order_PVT.Header_Payments
162: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
163: , p_init_msg_list => FND_API.G_TRUE
164: , p_control_rec => l_control_rec
165: , p_x_Header_Payment_tbl => l_x_Header_Payment_tbl
166: , p_x_old_Header_Payment_tbl => l_x_old_Header_Payment_tbl
167: , x_return_Status => l_return_status

Line 170: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

166: , p_x_old_Header_Payment_tbl => l_x_old_Header_Payment_tbl
167: , x_return_Status => l_return_status
168: );
169:
170: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
172: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
173: RAISE FND_API.G_EXC_ERROR;
174: END IF;

Line 171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

167: , x_return_Status => l_return_status
168: );
169:
170: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
172: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
173: RAISE FND_API.G_EXC_ERROR;
174: END IF;
175:

Line 172: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

168: );
169:
170: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
172: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
173: RAISE FND_API.G_EXC_ERROR;
174: END IF;
175:
176: -- Load OUT parameters.

Line 173: RAISE FND_API.G_EXC_ERROR;

169:
170: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
172: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
173: RAISE FND_API.G_EXC_ERROR;
174: END IF;
175:
176: -- Load OUT parameters.
177:

Line 231: l_x_Header_Payment_tbl(1).db_flag := FND_API.G_FALSE;

227:
228: -- Write to cache.
229: -- Set db_flag to False before writing to cache
230:
231: l_x_Header_Payment_tbl(1).db_flag := FND_API.G_FALSE;
232:
233: Write_Header_Payment
234: ( p_Header_Payment_rec => l_x_Header_PAYMENT_tbl(1)
235: );

Line 242: x_return_status := FND_API.G_RET_STS_SUCCESS;

238: OE_GLOBALS.G_UI_FLAG := FALSE;
239:
240: -- Set return status.
241:
242: x_return_status := FND_API.G_RET_STS_SUCCESS;
243:
244: -- Get message count and data
245:
246: oe_msg_pub.Count_And_Get

Line 257: WHEN FND_API.G_EXC_ERROR THEN

253: END IF;
254:
255: EXCEPTION
256:
257: WHEN FND_API.G_EXC_ERROR THEN
258:
259: OE_GLOBALS.G_UI_FLAG := FALSE;
260:
261: x_return_status := FND_API.G_RET_STS_ERROR;

Line 261: x_return_status := FND_API.G_RET_STS_ERROR;

257: WHEN FND_API.G_EXC_ERROR THEN
258:
259: OE_GLOBALS.G_UI_FLAG := FALSE;
260:
261: x_return_status := FND_API.G_RET_STS_ERROR;
262:
263: -- Get message count and data
264:
265: oe_msg_pub.Count_And_Get

Line 270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

266: ( p_count => x_msg_count
267: , p_data => x_msg_data
268: );
269:
270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
271:
272: OE_GLOBALS.G_UI_FLAG := FALSE;
273:
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

270: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
271:
272: OE_GLOBALS.G_UI_FLAG := FALSE;
273:
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
275:
276: -- Get message count and data
277:
278: oe_msg_pub.Count_And_Get

Line 287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

283: WHEN OTHERS THEN
284:
285: OE_GLOBALS.G_UI_FLAG := FALSE;
286:
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
288:
289: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
290: THEN
291: oe_msg_pub.Add_Exc_Msg

Line 488: IF FND_API.To_Boolean(l_x_Header_Payment_tbl(1).db_flag) THEN

484: END LOOP;
485:
486: -- Set Operation.
487:
488: IF FND_API.To_Boolean(l_x_Header_Payment_tbl(1).db_flag) THEN
489: l_x_Header_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
490: ELSE
491: l_x_Header_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
492: END IF;

Line 504: p_validation_level => FND_API.G_VALID_LEVEL_NONE

500: oe_debug_pub.add('New Card holder'||l_x_header_Payment_tbl(1).credit_card_holder_name);
501:
502: OE_Order_PVT.Header_Payments
503: (
504: p_validation_level => FND_API.G_VALID_LEVEL_NONE
505: , p_init_msg_list => FND_API.G_TRUE
506: , p_control_rec => l_control_rec
507: , p_x_Header_Payment_tbl => l_x_Header_PAYMENT_tbl
508: , p_x_old_Header_Payment_tbl => l_x_old_Header_PAYMENT_tbl

Line 505: , p_init_msg_list => FND_API.G_TRUE

501:
502: OE_Order_PVT.Header_Payments
503: (
504: p_validation_level => FND_API.G_VALID_LEVEL_NONE
505: , p_init_msg_list => FND_API.G_TRUE
506: , p_control_rec => l_control_rec
507: , p_x_Header_Payment_tbl => l_x_Header_PAYMENT_tbl
508: , p_x_old_Header_Payment_tbl => l_x_old_Header_PAYMENT_tbl
509: , x_return_status => l_return_status

Line 516: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

512: oe_debug_pub.add('New Holder name'||l_x_Header_Payment_Tbl(1).credit_card_holder_name);
513: oe_debug_pub.add('Old Holder name'||l_Header_Payment_rec.credit_card_holder_name);
514:
515:
516: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
517: oe_debug_pub.add('ren: unexp error header_payments : ' || p_attr_id);
518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
519: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
520: oe_debug_pub.add('ren: exp error header_payments : ' || p_attr_id);

Line 518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

514:
515:
516: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
517: oe_debug_pub.add('ren: unexp error header_payments : ' || p_attr_id);
518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
519: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
520: oe_debug_pub.add('ren: exp error header_payments : ' || p_attr_id);
521: RAISE FND_API.G_EXC_ERROR;
522: END IF;

Line 519: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

515:
516: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
517: oe_debug_pub.add('ren: unexp error header_payments : ' || p_attr_id);
518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
519: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
520: oe_debug_pub.add('ren: exp error header_payments : ' || p_attr_id);
521: RAISE FND_API.G_EXC_ERROR;
522: END IF;
523:

Line 521: RAISE FND_API.G_EXC_ERROR;

517: oe_debug_pub.add('ren: unexp error header_payments : ' || p_attr_id);
518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
519: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
520: oe_debug_pub.add('ren: exp error header_payments : ' || p_attr_id);
521: RAISE FND_API.G_EXC_ERROR;
522: END IF;
523:
524:
525: -- Init OUT parameters to missing.

Line 527: x_attribute1 := FND_API.G_MISS_CHAR;

523:
524:
525: -- Init OUT parameters to missing.
526:
527: x_attribute1 := FND_API.G_MISS_CHAR;
528: x_attribute2 := FND_API.G_MISS_CHAR;
529: x_attribute3 := FND_API.G_MISS_CHAR;
530: x_attribute4 := FND_API.G_MISS_CHAR;
531: x_attribute5 := FND_API.G_MISS_CHAR;

Line 528: x_attribute2 := FND_API.G_MISS_CHAR;

524:
525: -- Init OUT parameters to missing.
526:
527: x_attribute1 := FND_API.G_MISS_CHAR;
528: x_attribute2 := FND_API.G_MISS_CHAR;
529: x_attribute3 := FND_API.G_MISS_CHAR;
530: x_attribute4 := FND_API.G_MISS_CHAR;
531: x_attribute5 := FND_API.G_MISS_CHAR;
532: x_attribute6 := FND_API.G_MISS_CHAR;

Line 529: x_attribute3 := FND_API.G_MISS_CHAR;

525: -- Init OUT parameters to missing.
526:
527: x_attribute1 := FND_API.G_MISS_CHAR;
528: x_attribute2 := FND_API.G_MISS_CHAR;
529: x_attribute3 := FND_API.G_MISS_CHAR;
530: x_attribute4 := FND_API.G_MISS_CHAR;
531: x_attribute5 := FND_API.G_MISS_CHAR;
532: x_attribute6 := FND_API.G_MISS_CHAR;
533: x_attribute7 := FND_API.G_MISS_CHAR;

Line 530: x_attribute4 := FND_API.G_MISS_CHAR;

526:
527: x_attribute1 := FND_API.G_MISS_CHAR;
528: x_attribute2 := FND_API.G_MISS_CHAR;
529: x_attribute3 := FND_API.G_MISS_CHAR;
530: x_attribute4 := FND_API.G_MISS_CHAR;
531: x_attribute5 := FND_API.G_MISS_CHAR;
532: x_attribute6 := FND_API.G_MISS_CHAR;
533: x_attribute7 := FND_API.G_MISS_CHAR;
534: x_attribute8 := FND_API.G_MISS_CHAR;

Line 531: x_attribute5 := FND_API.G_MISS_CHAR;

527: x_attribute1 := FND_API.G_MISS_CHAR;
528: x_attribute2 := FND_API.G_MISS_CHAR;
529: x_attribute3 := FND_API.G_MISS_CHAR;
530: x_attribute4 := FND_API.G_MISS_CHAR;
531: x_attribute5 := FND_API.G_MISS_CHAR;
532: x_attribute6 := FND_API.G_MISS_CHAR;
533: x_attribute7 := FND_API.G_MISS_CHAR;
534: x_attribute8 := FND_API.G_MISS_CHAR;
535: x_attribute9 := FND_API.G_MISS_CHAR;

Line 532: x_attribute6 := FND_API.G_MISS_CHAR;

528: x_attribute2 := FND_API.G_MISS_CHAR;
529: x_attribute3 := FND_API.G_MISS_CHAR;
530: x_attribute4 := FND_API.G_MISS_CHAR;
531: x_attribute5 := FND_API.G_MISS_CHAR;
532: x_attribute6 := FND_API.G_MISS_CHAR;
533: x_attribute7 := FND_API.G_MISS_CHAR;
534: x_attribute8 := FND_API.G_MISS_CHAR;
535: x_attribute9 := FND_API.G_MISS_CHAR;
536: x_attribute10 := FND_API.G_MISS_CHAR;

Line 533: x_attribute7 := FND_API.G_MISS_CHAR;

529: x_attribute3 := FND_API.G_MISS_CHAR;
530: x_attribute4 := FND_API.G_MISS_CHAR;
531: x_attribute5 := FND_API.G_MISS_CHAR;
532: x_attribute6 := FND_API.G_MISS_CHAR;
533: x_attribute7 := FND_API.G_MISS_CHAR;
534: x_attribute8 := FND_API.G_MISS_CHAR;
535: x_attribute9 := FND_API.G_MISS_CHAR;
536: x_attribute10 := FND_API.G_MISS_CHAR;
537: x_attribute11 := FND_API.G_MISS_CHAR;

Line 534: x_attribute8 := FND_API.G_MISS_CHAR;

530: x_attribute4 := FND_API.G_MISS_CHAR;
531: x_attribute5 := FND_API.G_MISS_CHAR;
532: x_attribute6 := FND_API.G_MISS_CHAR;
533: x_attribute7 := FND_API.G_MISS_CHAR;
534: x_attribute8 := FND_API.G_MISS_CHAR;
535: x_attribute9 := FND_API.G_MISS_CHAR;
536: x_attribute10 := FND_API.G_MISS_CHAR;
537: x_attribute11 := FND_API.G_MISS_CHAR;
538: x_attribute12 := FND_API.G_MISS_CHAR;

Line 535: x_attribute9 := FND_API.G_MISS_CHAR;

531: x_attribute5 := FND_API.G_MISS_CHAR;
532: x_attribute6 := FND_API.G_MISS_CHAR;
533: x_attribute7 := FND_API.G_MISS_CHAR;
534: x_attribute8 := FND_API.G_MISS_CHAR;
535: x_attribute9 := FND_API.G_MISS_CHAR;
536: x_attribute10 := FND_API.G_MISS_CHAR;
537: x_attribute11 := FND_API.G_MISS_CHAR;
538: x_attribute12 := FND_API.G_MISS_CHAR;
539: x_attribute13 := FND_API.G_MISS_CHAR;

Line 536: x_attribute10 := FND_API.G_MISS_CHAR;

532: x_attribute6 := FND_API.G_MISS_CHAR;
533: x_attribute7 := FND_API.G_MISS_CHAR;
534: x_attribute8 := FND_API.G_MISS_CHAR;
535: x_attribute9 := FND_API.G_MISS_CHAR;
536: x_attribute10 := FND_API.G_MISS_CHAR;
537: x_attribute11 := FND_API.G_MISS_CHAR;
538: x_attribute12 := FND_API.G_MISS_CHAR;
539: x_attribute13 := FND_API.G_MISS_CHAR;
540: x_attribute14 := FND_API.G_MISS_CHAR;

Line 537: x_attribute11 := FND_API.G_MISS_CHAR;

533: x_attribute7 := FND_API.G_MISS_CHAR;
534: x_attribute8 := FND_API.G_MISS_CHAR;
535: x_attribute9 := FND_API.G_MISS_CHAR;
536: x_attribute10 := FND_API.G_MISS_CHAR;
537: x_attribute11 := FND_API.G_MISS_CHAR;
538: x_attribute12 := FND_API.G_MISS_CHAR;
539: x_attribute13 := FND_API.G_MISS_CHAR;
540: x_attribute14 := FND_API.G_MISS_CHAR;
541: x_attribute15 := FND_API.G_MISS_CHAR;

Line 538: x_attribute12 := FND_API.G_MISS_CHAR;

534: x_attribute8 := FND_API.G_MISS_CHAR;
535: x_attribute9 := FND_API.G_MISS_CHAR;
536: x_attribute10 := FND_API.G_MISS_CHAR;
537: x_attribute11 := FND_API.G_MISS_CHAR;
538: x_attribute12 := FND_API.G_MISS_CHAR;
539: x_attribute13 := FND_API.G_MISS_CHAR;
540: x_attribute14 := FND_API.G_MISS_CHAR;
541: x_attribute15 := FND_API.G_MISS_CHAR;
542: x_context := FND_API.G_MISS_CHAR;

Line 539: x_attribute13 := FND_API.G_MISS_CHAR;

535: x_attribute9 := FND_API.G_MISS_CHAR;
536: x_attribute10 := FND_API.G_MISS_CHAR;
537: x_attribute11 := FND_API.G_MISS_CHAR;
538: x_attribute12 := FND_API.G_MISS_CHAR;
539: x_attribute13 := FND_API.G_MISS_CHAR;
540: x_attribute14 := FND_API.G_MISS_CHAR;
541: x_attribute15 := FND_API.G_MISS_CHAR;
542: x_context := FND_API.G_MISS_CHAR;
543: x_check_number := FND_API.G_MISS_CHAR;

Line 540: x_attribute14 := FND_API.G_MISS_CHAR;

536: x_attribute10 := FND_API.G_MISS_CHAR;
537: x_attribute11 := FND_API.G_MISS_CHAR;
538: x_attribute12 := FND_API.G_MISS_CHAR;
539: x_attribute13 := FND_API.G_MISS_CHAR;
540: x_attribute14 := FND_API.G_MISS_CHAR;
541: x_attribute15 := FND_API.G_MISS_CHAR;
542: x_context := FND_API.G_MISS_CHAR;
543: x_check_number := FND_API.G_MISS_CHAR;
544: x_credit_card_approval_code := FND_API.G_MISS_CHAR;

Line 541: x_attribute15 := FND_API.G_MISS_CHAR;

537: x_attribute11 := FND_API.G_MISS_CHAR;
538: x_attribute12 := FND_API.G_MISS_CHAR;
539: x_attribute13 := FND_API.G_MISS_CHAR;
540: x_attribute14 := FND_API.G_MISS_CHAR;
541: x_attribute15 := FND_API.G_MISS_CHAR;
542: x_context := FND_API.G_MISS_CHAR;
543: x_check_number := FND_API.G_MISS_CHAR;
544: x_credit_card_approval_code := FND_API.G_MISS_CHAR;
545: x_credit_card_approval_date := FND_API.G_MISS_DATE;

Line 542: x_context := FND_API.G_MISS_CHAR;

538: x_attribute12 := FND_API.G_MISS_CHAR;
539: x_attribute13 := FND_API.G_MISS_CHAR;
540: x_attribute14 := FND_API.G_MISS_CHAR;
541: x_attribute15 := FND_API.G_MISS_CHAR;
542: x_context := FND_API.G_MISS_CHAR;
543: x_check_number := FND_API.G_MISS_CHAR;
544: x_credit_card_approval_code := FND_API.G_MISS_CHAR;
545: x_credit_card_approval_date := FND_API.G_MISS_DATE;
546: x_credit_card_code := FND_API.G_MISS_CHAR;

Line 543: x_check_number := FND_API.G_MISS_CHAR;

539: x_attribute13 := FND_API.G_MISS_CHAR;
540: x_attribute14 := FND_API.G_MISS_CHAR;
541: x_attribute15 := FND_API.G_MISS_CHAR;
542: x_context := FND_API.G_MISS_CHAR;
543: x_check_number := FND_API.G_MISS_CHAR;
544: x_credit_card_approval_code := FND_API.G_MISS_CHAR;
545: x_credit_card_approval_date := FND_API.G_MISS_DATE;
546: x_credit_card_code := FND_API.G_MISS_CHAR;
547: x_credit_card_expiration_date := FND_API.G_MISS_DATE;

Line 544: x_credit_card_approval_code := FND_API.G_MISS_CHAR;

540: x_attribute14 := FND_API.G_MISS_CHAR;
541: x_attribute15 := FND_API.G_MISS_CHAR;
542: x_context := FND_API.G_MISS_CHAR;
543: x_check_number := FND_API.G_MISS_CHAR;
544: x_credit_card_approval_code := FND_API.G_MISS_CHAR;
545: x_credit_card_approval_date := FND_API.G_MISS_DATE;
546: x_credit_card_code := FND_API.G_MISS_CHAR;
547: x_credit_card_expiration_date := FND_API.G_MISS_DATE;
548: x_credit_card_holder_name := FND_API.G_MISS_CHAR;

Line 545: x_credit_card_approval_date := FND_API.G_MISS_DATE;

541: x_attribute15 := FND_API.G_MISS_CHAR;
542: x_context := FND_API.G_MISS_CHAR;
543: x_check_number := FND_API.G_MISS_CHAR;
544: x_credit_card_approval_code := FND_API.G_MISS_CHAR;
545: x_credit_card_approval_date := FND_API.G_MISS_DATE;
546: x_credit_card_code := FND_API.G_MISS_CHAR;
547: x_credit_card_expiration_date := FND_API.G_MISS_DATE;
548: x_credit_card_holder_name := FND_API.G_MISS_CHAR;
549: x_credit_card_number := FND_API.G_MISS_CHAR;

Line 546: x_credit_card_code := FND_API.G_MISS_CHAR;

542: x_context := FND_API.G_MISS_CHAR;
543: x_check_number := FND_API.G_MISS_CHAR;
544: x_credit_card_approval_code := FND_API.G_MISS_CHAR;
545: x_credit_card_approval_date := FND_API.G_MISS_DATE;
546: x_credit_card_code := FND_API.G_MISS_CHAR;
547: x_credit_card_expiration_date := FND_API.G_MISS_DATE;
548: x_credit_card_holder_name := FND_API.G_MISS_CHAR;
549: x_credit_card_number := FND_API.G_MISS_CHAR;
550: x_payment_level_code := FND_API.G_MISS_CHAR;

Line 547: x_credit_card_expiration_date := FND_API.G_MISS_DATE;

543: x_check_number := FND_API.G_MISS_CHAR;
544: x_credit_card_approval_code := FND_API.G_MISS_CHAR;
545: x_credit_card_approval_date := FND_API.G_MISS_DATE;
546: x_credit_card_code := FND_API.G_MISS_CHAR;
547: x_credit_card_expiration_date := FND_API.G_MISS_DATE;
548: x_credit_card_holder_name := FND_API.G_MISS_CHAR;
549: x_credit_card_number := FND_API.G_MISS_CHAR;
550: x_payment_level_code := FND_API.G_MISS_CHAR;
551: x_commitment_applied_amount := FND_API.G_MISS_NUM;

Line 548: x_credit_card_holder_name := FND_API.G_MISS_CHAR;

544: x_credit_card_approval_code := FND_API.G_MISS_CHAR;
545: x_credit_card_approval_date := FND_API.G_MISS_DATE;
546: x_credit_card_code := FND_API.G_MISS_CHAR;
547: x_credit_card_expiration_date := FND_API.G_MISS_DATE;
548: x_credit_card_holder_name := FND_API.G_MISS_CHAR;
549: x_credit_card_number := FND_API.G_MISS_CHAR;
550: x_payment_level_code := FND_API.G_MISS_CHAR;
551: x_commitment_applied_amount := FND_API.G_MISS_NUM;
552: x_commitment_interfaced_amount := FND_API.G_MISS_NUM;

Line 549: x_credit_card_number := FND_API.G_MISS_CHAR;

545: x_credit_card_approval_date := FND_API.G_MISS_DATE;
546: x_credit_card_code := FND_API.G_MISS_CHAR;
547: x_credit_card_expiration_date := FND_API.G_MISS_DATE;
548: x_credit_card_holder_name := FND_API.G_MISS_CHAR;
549: x_credit_card_number := FND_API.G_MISS_CHAR;
550: x_payment_level_code := FND_API.G_MISS_CHAR;
551: x_commitment_applied_amount := FND_API.G_MISS_NUM;
552: x_commitment_interfaced_amount := FND_API.G_MISS_NUM;
553: x_payment_number := FND_API.G_MISS_NUM;

Line 550: x_payment_level_code := FND_API.G_MISS_CHAR;

546: x_credit_card_code := FND_API.G_MISS_CHAR;
547: x_credit_card_expiration_date := FND_API.G_MISS_DATE;
548: x_credit_card_holder_name := FND_API.G_MISS_CHAR;
549: x_credit_card_number := FND_API.G_MISS_CHAR;
550: x_payment_level_code := FND_API.G_MISS_CHAR;
551: x_commitment_applied_amount := FND_API.G_MISS_NUM;
552: x_commitment_interfaced_amount := FND_API.G_MISS_NUM;
553: x_payment_number := FND_API.G_MISS_NUM;
554: x_header_id := FND_API.G_MISS_NUM;

Line 551: x_commitment_applied_amount := FND_API.G_MISS_NUM;

547: x_credit_card_expiration_date := FND_API.G_MISS_DATE;
548: x_credit_card_holder_name := FND_API.G_MISS_CHAR;
549: x_credit_card_number := FND_API.G_MISS_CHAR;
550: x_payment_level_code := FND_API.G_MISS_CHAR;
551: x_commitment_applied_amount := FND_API.G_MISS_NUM;
552: x_commitment_interfaced_amount := FND_API.G_MISS_NUM;
553: x_payment_number := FND_API.G_MISS_NUM;
554: x_header_id := FND_API.G_MISS_NUM;
555: x_line_id := FND_API.G_MISS_NUM;

Line 552: x_commitment_interfaced_amount := FND_API.G_MISS_NUM;

548: x_credit_card_holder_name := FND_API.G_MISS_CHAR;
549: x_credit_card_number := FND_API.G_MISS_CHAR;
550: x_payment_level_code := FND_API.G_MISS_CHAR;
551: x_commitment_applied_amount := FND_API.G_MISS_NUM;
552: x_commitment_interfaced_amount := FND_API.G_MISS_NUM;
553: x_payment_number := FND_API.G_MISS_NUM;
554: x_header_id := FND_API.G_MISS_NUM;
555: x_line_id := FND_API.G_MISS_NUM;
556: x_payment_amount := FND_API.G_MISS_NUM;

Line 553: x_payment_number := FND_API.G_MISS_NUM;

549: x_credit_card_number := FND_API.G_MISS_CHAR;
550: x_payment_level_code := FND_API.G_MISS_CHAR;
551: x_commitment_applied_amount := FND_API.G_MISS_NUM;
552: x_commitment_interfaced_amount := FND_API.G_MISS_NUM;
553: x_payment_number := FND_API.G_MISS_NUM;
554: x_header_id := FND_API.G_MISS_NUM;
555: x_line_id := FND_API.G_MISS_NUM;
556: x_payment_amount := FND_API.G_MISS_NUM;
557: x_payment_collection_event := FND_API.G_MISS_CHAR;

Line 554: x_header_id := FND_API.G_MISS_NUM;

550: x_payment_level_code := FND_API.G_MISS_CHAR;
551: x_commitment_applied_amount := FND_API.G_MISS_NUM;
552: x_commitment_interfaced_amount := FND_API.G_MISS_NUM;
553: x_payment_number := FND_API.G_MISS_NUM;
554: x_header_id := FND_API.G_MISS_NUM;
555: x_line_id := FND_API.G_MISS_NUM;
556: x_payment_amount := FND_API.G_MISS_NUM;
557: x_payment_collection_event := FND_API.G_MISS_CHAR;
558: x_payment_trx_id := FND_API.G_MISS_NUM;

Line 555: x_line_id := FND_API.G_MISS_NUM;

551: x_commitment_applied_amount := FND_API.G_MISS_NUM;
552: x_commitment_interfaced_amount := FND_API.G_MISS_NUM;
553: x_payment_number := FND_API.G_MISS_NUM;
554: x_header_id := FND_API.G_MISS_NUM;
555: x_line_id := FND_API.G_MISS_NUM;
556: x_payment_amount := FND_API.G_MISS_NUM;
557: x_payment_collection_event := FND_API.G_MISS_CHAR;
558: x_payment_trx_id := FND_API.G_MISS_NUM;
559: x_payment_type_code := FND_API.G_MISS_CHAR;

Line 556: x_payment_amount := FND_API.G_MISS_NUM;

552: x_commitment_interfaced_amount := FND_API.G_MISS_NUM;
553: x_payment_number := FND_API.G_MISS_NUM;
554: x_header_id := FND_API.G_MISS_NUM;
555: x_line_id := FND_API.G_MISS_NUM;
556: x_payment_amount := FND_API.G_MISS_NUM;
557: x_payment_collection_event := FND_API.G_MISS_CHAR;
558: x_payment_trx_id := FND_API.G_MISS_NUM;
559: x_payment_type_code := FND_API.G_MISS_CHAR;
560: x_payment_set_id := FND_API.G_MISS_NUM;

Line 557: x_payment_collection_event := FND_API.G_MISS_CHAR;

553: x_payment_number := FND_API.G_MISS_NUM;
554: x_header_id := FND_API.G_MISS_NUM;
555: x_line_id := FND_API.G_MISS_NUM;
556: x_payment_amount := FND_API.G_MISS_NUM;
557: x_payment_collection_event := FND_API.G_MISS_CHAR;
558: x_payment_trx_id := FND_API.G_MISS_NUM;
559: x_payment_type_code := FND_API.G_MISS_CHAR;
560: x_payment_set_id := FND_API.G_MISS_NUM;
561: x_prepaid_amount := FND_API.G_MISS_NUM;

Line 558: x_payment_trx_id := FND_API.G_MISS_NUM;

554: x_header_id := FND_API.G_MISS_NUM;
555: x_line_id := FND_API.G_MISS_NUM;
556: x_payment_amount := FND_API.G_MISS_NUM;
557: x_payment_collection_event := FND_API.G_MISS_CHAR;
558: x_payment_trx_id := FND_API.G_MISS_NUM;
559: x_payment_type_code := FND_API.G_MISS_CHAR;
560: x_payment_set_id := FND_API.G_MISS_NUM;
561: x_prepaid_amount := FND_API.G_MISS_NUM;
562: x_receipt_method_id := FND_API.G_MISS_NUM;

Line 559: x_payment_type_code := FND_API.G_MISS_CHAR;

555: x_line_id := FND_API.G_MISS_NUM;
556: x_payment_amount := FND_API.G_MISS_NUM;
557: x_payment_collection_event := FND_API.G_MISS_CHAR;
558: x_payment_trx_id := FND_API.G_MISS_NUM;
559: x_payment_type_code := FND_API.G_MISS_CHAR;
560: x_payment_set_id := FND_API.G_MISS_NUM;
561: x_prepaid_amount := FND_API.G_MISS_NUM;
562: x_receipt_method_id := FND_API.G_MISS_NUM;
563: x_tangible_id := FND_API.G_MISS_CHAR;

Line 560: x_payment_set_id := FND_API.G_MISS_NUM;

556: x_payment_amount := FND_API.G_MISS_NUM;
557: x_payment_collection_event := FND_API.G_MISS_CHAR;
558: x_payment_trx_id := FND_API.G_MISS_NUM;
559: x_payment_type_code := FND_API.G_MISS_CHAR;
560: x_payment_set_id := FND_API.G_MISS_NUM;
561: x_prepaid_amount := FND_API.G_MISS_NUM;
562: x_receipt_method_id := FND_API.G_MISS_NUM;
563: x_tangible_id := FND_API.G_MISS_CHAR;
564: x_defer_processing_flag := FND_API.G_MISS_CHAR;

Line 561: x_prepaid_amount := FND_API.G_MISS_NUM;

557: x_payment_collection_event := FND_API.G_MISS_CHAR;
558: x_payment_trx_id := FND_API.G_MISS_NUM;
559: x_payment_type_code := FND_API.G_MISS_CHAR;
560: x_payment_set_id := FND_API.G_MISS_NUM;
561: x_prepaid_amount := FND_API.G_MISS_NUM;
562: x_receipt_method_id := FND_API.G_MISS_NUM;
563: x_tangible_id := FND_API.G_MISS_CHAR;
564: x_defer_processing_flag := FND_API.G_MISS_CHAR;
565: x_instrument_security_code := FND_API.G_MISS_CHAR; --R12 CC encryption

Line 562: x_receipt_method_id := FND_API.G_MISS_NUM;

558: x_payment_trx_id := FND_API.G_MISS_NUM;
559: x_payment_type_code := FND_API.G_MISS_CHAR;
560: x_payment_set_id := FND_API.G_MISS_NUM;
561: x_prepaid_amount := FND_API.G_MISS_NUM;
562: x_receipt_method_id := FND_API.G_MISS_NUM;
563: x_tangible_id := FND_API.G_MISS_CHAR;
564: x_defer_processing_flag := FND_API.G_MISS_CHAR;
565: x_instrument_security_code := FND_API.G_MISS_CHAR; --R12 CC encryption
566:

Line 563: x_tangible_id := FND_API.G_MISS_CHAR;

559: x_payment_type_code := FND_API.G_MISS_CHAR;
560: x_payment_set_id := FND_API.G_MISS_NUM;
561: x_prepaid_amount := FND_API.G_MISS_NUM;
562: x_receipt_method_id := FND_API.G_MISS_NUM;
563: x_tangible_id := FND_API.G_MISS_CHAR;
564: x_defer_processing_flag := FND_API.G_MISS_CHAR;
565: x_instrument_security_code := FND_API.G_MISS_CHAR; --R12 CC encryption
566:
567: -- Load display out parameters if any

Line 564: x_defer_processing_flag := FND_API.G_MISS_CHAR;

560: x_payment_set_id := FND_API.G_MISS_NUM;
561: x_prepaid_amount := FND_API.G_MISS_NUM;
562: x_receipt_method_id := FND_API.G_MISS_NUM;
563: x_tangible_id := FND_API.G_MISS_CHAR;
564: x_defer_processing_flag := FND_API.G_MISS_CHAR;
565: x_instrument_security_code := FND_API.G_MISS_CHAR; --R12 CC encryption
566:
567: -- Load display out parameters if any
568:

Line 565: x_instrument_security_code := FND_API.G_MISS_CHAR; --R12 CC encryption

561: x_prepaid_amount := FND_API.G_MISS_NUM;
562: x_receipt_method_id := FND_API.G_MISS_NUM;
563: x_tangible_id := FND_API.G_MISS_CHAR;
564: x_defer_processing_flag := FND_API.G_MISS_CHAR;
565: x_instrument_security_code := FND_API.G_MISS_CHAR; --R12 CC encryption
566:
567: -- Load display out parameters if any
568:
569: l_Header_Payment_val_rec := OE_Header_PAYMENT_Util.Get_Values

Line 849: x_return_status := FND_API.G_RET_STS_SUCCESS;

845: OE_GLOBALS.G_UI_FLAG := FALSE;
846:
847: -- Set return status.
848:
849: x_return_status := FND_API.G_RET_STS_SUCCESS;
850:
851: -- Get message count and data
852:
853: oe_msg_pub.Count_And_Get

Line 864: WHEN FND_API.G_EXC_ERROR THEN

860: END IF;
861:
862: EXCEPTION
863:
864: WHEN FND_API.G_EXC_ERROR THEN
865:
866: OE_GLOBALS.G_UI_FLAG := FALSE;
867:
868: x_return_status := FND_API.G_RET_STS_ERROR;

Line 868: x_return_status := FND_API.G_RET_STS_ERROR;

864: WHEN FND_API.G_EXC_ERROR THEN
865:
866: OE_GLOBALS.G_UI_FLAG := FALSE;
867:
868: x_return_status := FND_API.G_RET_STS_ERROR;
869:
870: -- Get message count and data
871:
872: oe_msg_pub.Count_And_Get

Line 877: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

873: ( p_count => x_msg_count
874: , p_data => x_msg_data
875: );
876:
877: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
878:
879: OE_GLOBALS.G_UI_FLAG := FALSE;
880:
881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

877: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
878:
879: OE_GLOBALS.G_UI_FLAG := FALSE;
880:
881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
882:
883: -- Get message count and data
884:
885: oe_msg_pub.Count_And_Get

Line 894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

890: WHEN OTHERS THEN
891:
892: OE_GLOBALS.G_UI_FLAG := FALSE;
893:
894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
895:
896: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
897: THEN
898: oe_msg_pub.Add_Exc_Msg

Line 1053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1049: , 'Unrecognized attribute'
1050: );
1051: END IF;
1052:
1053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1054:
1055: END IF;
1056: EXCEPTION
1057: WHEN OTHERS THEN

Line 1065: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1061: ( G_PKG_NAME
1062: , 'Copy_Attribute_To_Rec'
1063: );
1064: END IF;
1065: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1066: END Copy_Attribute_To_Rec;
1067: -- R12 CC Encryption
1068:
1069: -- Procedure Validate_And_Write

Line 1141: IF FND_API.To_Boolean(l_x_Header_Payment_tbl(1).db_flag) THEN

1137: );
1138:
1139: -- Set Operation.
1140:
1141: IF FND_API.To_Boolean(l_x_Header_Payment_tbl(1).db_flag) THEN
1142: l_x_Header_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
1143: ELSE
1144: l_x_Header_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_CREATE;
1145: END IF;

Line 1153: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

1149: -- Call OE_Order_PVT.Process_order
1150:
1151:
1152: OE_Order_PVT.Header_Payments
1153: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
1154: , p_init_msg_list => FND_API.G_TRUE
1155: , p_control_rec => l_control_rec
1156: , p_x_Header_Payment_tbl => l_x_Header_PAYMENT_tbl
1157: , p_x_old_Header_Payment_tbl => l_x_old_Header_PAYMENT_tbl

Line 1154: , p_init_msg_list => FND_API.G_TRUE

1150:
1151:
1152: OE_Order_PVT.Header_Payments
1153: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
1154: , p_init_msg_list => FND_API.G_TRUE
1155: , p_control_rec => l_control_rec
1156: , p_x_Header_Payment_tbl => l_x_Header_PAYMENT_tbl
1157: , p_x_old_Header_Payment_tbl => l_x_old_Header_PAYMENT_tbl
1158: , x_return_status => l_return_status

Line 1161: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1157: , p_x_old_Header_Payment_tbl => l_x_old_Header_PAYMENT_tbl
1158: , x_return_status => l_return_status
1159: );
1160:
1161: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1163: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1164: RAISE FND_API.G_EXC_ERROR;
1165: END IF;

Line 1162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1158: , x_return_status => l_return_status
1159: );
1160:
1161: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1163: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1164: RAISE FND_API.G_EXC_ERROR;
1165: END IF;
1166:

Line 1163: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1159: );
1160:
1161: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1163: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1164: RAISE FND_API.G_EXC_ERROR;
1165: END IF;
1166:
1167: -- Load OUT parameters.

Line 1164: RAISE FND_API.G_EXC_ERROR;

1160:
1161: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1163: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1164: RAISE FND_API.G_EXC_ERROR;
1165: END IF;
1166:
1167: -- Load OUT parameters.
1168:

Line 1190: x_return_status := FND_API.G_RET_STS_SUCCESS;

1186: OE_GLOBALS.G_UI_FLAG := FALSE;
1187:
1188: -- Set return status.
1189:
1190: x_return_status := FND_API.G_RET_STS_SUCCESS;
1191:
1192: -- Get message count and data
1193:
1194: oe_msg_pub.Count_And_Get

Line 1205: WHEN FND_API.G_EXC_ERROR THEN

1201: END IF;
1202:
1203: EXCEPTION
1204:
1205: WHEN FND_API.G_EXC_ERROR THEN
1206:
1207: OE_GLOBALS.G_UI_FLAG := FALSE;
1208:
1209: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1209: x_return_status := FND_API.G_RET_STS_ERROR;

1205: WHEN FND_API.G_EXC_ERROR THEN
1206:
1207: OE_GLOBALS.G_UI_FLAG := FALSE;
1208:
1209: x_return_status := FND_API.G_RET_STS_ERROR;
1210:
1211: -- Get message count and data
1212:
1213: oe_msg_pub.Count_And_Get

Line 1218: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1214: ( p_count => x_msg_count
1215: , p_data => x_msg_data
1216: );
1217:
1218: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1219:
1220: OE_GLOBALS.G_UI_FLAG := FALSE;
1221:
1222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1218: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1219:
1220: OE_GLOBALS.G_UI_FLAG := FALSE;
1221:
1222: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1223:
1224: -- Get message count and data
1225:
1226: oe_msg_pub.Count_And_Get

Line 1235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1231: WHEN OTHERS THEN
1232:
1233: OE_GLOBALS.G_UI_FLAG := FALSE;
1234:
1235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1236:
1237: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1238: THEN
1239: oe_msg_pub.Add_Exc_Msg

Line 1319: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE

1315: -- Call OE_Order_PVT.Process_order
1316:
1317:
1318: OE_Order_PVT.Header_Payments
1319: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
1320: , p_init_msg_list => FND_API.G_TRUE
1321: , p_control_rec => l_control_rec
1322: , p_x_Header_Payment_tbl => l_x_Header_Payment_tbl
1323: , p_x_old_Header_Payment_tbl => l_x_old_Header_Payment_tbl

Line 1320: , p_init_msg_list => FND_API.G_TRUE

1316:
1317:
1318: OE_Order_PVT.Header_Payments
1319: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
1320: , p_init_msg_list => FND_API.G_TRUE
1321: , p_control_rec => l_control_rec
1322: , p_x_Header_Payment_tbl => l_x_Header_Payment_tbl
1323: , p_x_old_Header_Payment_tbl => l_x_old_Header_Payment_tbl
1324: , x_return_status => l_return_status

Line 1327: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1323: , p_x_old_Header_Payment_tbl => l_x_old_Header_Payment_tbl
1324: , x_return_status => l_return_status
1325: );
1326:
1327: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1329: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1330: RAISE FND_API.G_EXC_ERROR;
1331: END IF;

Line 1328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1324: , x_return_status => l_return_status
1325: );
1326:
1327: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1329: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1330: RAISE FND_API.G_EXC_ERROR;
1331: END IF;
1332:

Line 1329: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1325: );
1326:
1327: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1329: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1330: RAISE FND_API.G_EXC_ERROR;
1331: END IF;
1332:
1333:

Line 1330: RAISE FND_API.G_EXC_ERROR;

1326:
1327: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1328: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1329: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1330: RAISE FND_API.G_EXC_ERROR;
1331: END IF;
1332:
1333:
1334: -- Clear Header_Payment record cache

Line 1343: x_return_status := FND_API.G_RET_STS_SUCCESS;

1339: OE_GLOBALS.G_UI_FLAG := FALSE;
1340:
1341: -- Set return status.
1342:
1343: x_return_status := FND_API.G_RET_STS_SUCCESS;
1344:
1345: -- Get message count and data
1346:
1347: oe_msg_pub.Count_And_Get

Line 1358: WHEN FND_API.G_EXC_ERROR THEN

1354: END IF;
1355:
1356: EXCEPTION
1357:
1358: WHEN FND_API.G_EXC_ERROR THEN
1359:
1360: OE_GLOBALS.G_UI_FLAG := FALSE;
1361:
1362: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1362: x_return_status := FND_API.G_RET_STS_ERROR;

1358: WHEN FND_API.G_EXC_ERROR THEN
1359:
1360: OE_GLOBALS.G_UI_FLAG := FALSE;
1361:
1362: x_return_status := FND_API.G_RET_STS_ERROR;
1363:
1364: -- Get message count and data
1365:
1366: oe_msg_pub.Count_And_Get

Line 1371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1367: ( p_count => x_msg_count
1368: , p_data => x_msg_data
1369: );
1370:
1371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1372:
1373: OE_GLOBALS.G_UI_FLAG := FALSE;
1374:
1375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1372:
1373: OE_GLOBALS.G_UI_FLAG := FALSE;
1374:
1375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1376:
1377: -- Get message count and data
1378:
1379: oe_msg_pub.Count_And_Get

Line 1388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1384: WHEN OTHERS THEN
1385:
1386: OE_GLOBALS.G_UI_FLAG := FALSE;
1387:
1388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1389:
1390: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1391: THEN
1392: oe_msg_pub.Add_Exc_Msg

Line 1477: , p_init_msg_list => FND_API.G_TRUE

1473: -- Call OE_Order_PVT.Process_order
1474:
1475: OE_Order_PVT.Process_order
1476: ( p_api_version_number => 1.0
1477: , p_init_msg_list => FND_API.G_TRUE
1478: , x_return_status => l_return_status
1479: , x_msg_count => x_msg_count
1480: , x_msg_data => x_msg_data
1481: , p_control_rec => l_control_rec

Line 1503: , p_init_msg_list => FND_API.G_TRUE

1499: );
1500:
1501: Oe_Order_Pvt.Process_Requests_And_Notify
1502: ( p_process_requests => TRUE
1503: , p_init_msg_list => FND_API.G_TRUE
1504: , p_notify => FALSE
1505: , x_return_status => l_return_status
1506: );
1507:

Line 1508: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1504: , p_notify => FALSE
1505: , x_return_status => l_return_status
1506: );
1507:
1508: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1510: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1511: RAISE FND_API.G_EXC_ERROR;
1512: END IF;

Line 1509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1505: , x_return_status => l_return_status
1506: );
1507:
1508: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1510: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1511: RAISE FND_API.G_EXC_ERROR;
1512: END IF;
1513:

Line 1510: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1506: );
1507:
1508: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1510: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1511: RAISE FND_API.G_EXC_ERROR;
1512: END IF;
1513:
1514:

Line 1511: RAISE FND_API.G_EXC_ERROR;

1507:
1508: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1510: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1511: RAISE FND_API.G_EXC_ERROR;
1512: END IF;
1513:
1514:
1515: -- Re-set the UI flag to FALSE

Line 1520: x_return_status := FND_API.G_RET_STS_SUCCESS;

1516: OE_GLOBALS.G_UI_FLAG := FALSE;
1517:
1518: -- Set return status.
1519:
1520: x_return_status := FND_API.G_RET_STS_SUCCESS;
1521:
1522: -- Get message count and data
1523:
1524: oe_msg_pub.Count_And_Get

Line 1535: WHEN FND_API.G_EXC_ERROR THEN

1531: END IF;
1532:
1533: EXCEPTION
1534:
1535: WHEN FND_API.G_EXC_ERROR THEN
1536:
1537: OE_GLOBALS.G_UI_FLAG := FALSE;
1538:
1539: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1539: x_return_status := FND_API.G_RET_STS_ERROR;

1535: WHEN FND_API.G_EXC_ERROR THEN
1536:
1537: OE_GLOBALS.G_UI_FLAG := FALSE;
1538:
1539: x_return_status := FND_API.G_RET_STS_ERROR;
1540:
1541: -- Get message count and data
1542:
1543: oe_msg_pub.Count_And_Get

Line 1548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1544: ( p_count => x_msg_count
1545: , p_data => x_msg_data
1546: );
1547:
1548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1549:
1550: OE_GLOBALS.G_UI_FLAG := FALSE;
1551:
1552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1549:
1550: OE_GLOBALS.G_UI_FLAG := FALSE;
1551:
1552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1553:
1554: -- Get message count and data
1555:
1556: oe_msg_pub.Count_And_Get

Line 1565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1561: WHEN OTHERS THEN
1562:
1563: OE_GLOBALS.G_UI_FLAG := FALSE;
1564:
1565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1566:
1567: IF oe_msg_pub.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1568: THEN
1569: oe_msg_pub.Add_Exc_Msg

Line 1620: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1616:
1617: OE_Header_Payment_Util.Lock_Row
1618: ( x_return_status => l_return_status
1619: , p_x_header_Payment_rec => l_x_header_payment_rec );
1620: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1621:
1622: -- Set DB flag and write record to cache.
1623:
1624: l_x_Header_Payment_rec.db_flag := FND_API.G_TRUE;

Line 1624: l_x_Header_Payment_rec.db_flag := FND_API.G_TRUE;

1620: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1621:
1622: -- Set DB flag and write record to cache.
1623:
1624: l_x_Header_Payment_rec.db_flag := FND_API.G_TRUE;
1625:
1626: Write_Header_Payment
1627: ( p_Header_Payment_rec => l_x_Header_Payment_rec
1628: , p_db_record => TRUE

Line 1660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1656: , 'Lock_Row'
1657: );
1658: END IF;
1659:
1660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1661:
1662: -- Get message count and data
1663:
1664: oe_msg_pub.Count_And_Get

Line 1731: g_Header_Payment_rec.db_flag := FND_API.G_TRUE;

1727: , p_header_id => p_header_id
1728: , x_header_Payment_rec => g_Header_Payment_rec
1729: );
1730:
1731: g_Header_Payment_rec.db_flag := FND_API.G_TRUE;
1732:
1733: -- Load DB record
1734:
1735: g_db_Header_Payment_rec := g_Header_PAYMENT_rec;