DBA Data[Home] [Help]

APPS.OE_OE_FORM_AGREEMENT dependencies on FND_API

Line 167: , p_init_msg_list => FND_API.G_TRUE

163: -- Call OE_Pricing_Cont_PVT.Process_Pricing_Cont
164:
165: OE_Pricing_Cont_PVT.Process_Pricing_Cont
166: ( p_api_version_number => 1.0
167: , p_init_msg_list => FND_API.G_TRUE
168: , x_return_status => l_return_status
169: , x_msg_count => x_msg_count
170: , x_msg_data => x_msg_data
171: , p_control_rec => l_control_rec

Line 183: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

179: , x_Discount_Line_tbl => l_x_Discount_Line_tbl
180: , x_Price_Break_tbl => l_x_Price_Break_tbl
181: );
182:
183: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
185: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
186: RAISE FND_API.G_EXC_ERROR;
187: END IF;

Line 184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

180: , x_Price_Break_tbl => l_x_Price_Break_tbl
181: );
182:
183: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
185: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
186: RAISE FND_API.G_EXC_ERROR;
187: END IF;
188:

Line 185: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

181: );
182:
183: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
185: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
186: RAISE FND_API.G_EXC_ERROR;
187: END IF;
188:
189:

Line 186: RAISE FND_API.G_EXC_ERROR;

182:
183: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
185: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
186: RAISE FND_API.G_EXC_ERROR;
187: END IF;
188:
189:
190: -- Load OUT parameters.

Line 267: l_x_Agreement_rec.db_flag := FND_API.G_FALSE;

263:
264: -- Write to cache.
265: -- Set db_flag to False before writing to cache
266:
267: l_x_Agreement_rec.db_flag := FND_API.G_FALSE;
268:
269: Write_Agreement
270: ( p_Agreement_rec => l_x_Agreement_rec
271: );

Line 275: x_return_status := FND_API.G_RET_STS_SUCCESS;

271: );
272:
273: -- Set return status.
274:
275: x_return_status := FND_API.G_RET_STS_SUCCESS;
276:
277: -- Get message count and data
278:
279: OE_MSG_PUB.Count_And_Get

Line 288: WHEN FND_API.G_EXC_ERROR THEN

284: oe_debug_pub.add('Exiting OE_OE_Form_Agreement.Default_Attributes');
285:
286: EXCEPTION
287:
288: WHEN FND_API.G_EXC_ERROR THEN
289:
290: x_return_status := FND_API.G_RET_STS_ERROR;
291:
292: -- Get message count and data

Line 290: x_return_status := FND_API.G_RET_STS_ERROR;

286: EXCEPTION
287:
288: WHEN FND_API.G_EXC_ERROR THEN
289:
290: x_return_status := FND_API.G_RET_STS_ERROR;
291:
292: -- Get message count and data
293:
294: OE_MSG_PUB.Count_And_Get

Line 299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

295: ( p_count => x_msg_count
296: , p_data => x_msg_data
297: );
298:
299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
300:
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
302:
303: -- Get message count and data

Line 301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

297: );
298:
299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
300:
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
302:
303: -- Get message count and data
304:
305: OE_MSG_PUB.Count_And_Get

Line 312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

308: );
309:
310: WHEN OTHERS THEN
311:
312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
313:
314: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
315: THEN
316: OE_MSG_PUB.Add_Exc_Msg

Line 572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

568: , 'Unrecognized attribute'
569: );
570: END IF;
571:
572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
573:
574: END IF;
575:
576: -- Set Operation.

Line 578: IF FND_API.To_Boolean(l_Agreement_rec.db_flag) THEN

574: END IF;
575:
576: -- Set Operation.
577:
578: IF FND_API.To_Boolean(l_Agreement_rec.db_flag) THEN
579: l_Agreement_rec.operation := oe_globals.G_OPR_UPDATE;
580: ELSE
581: l_Agreement_rec.operation := oe_globals.G_OPR_CREATE;
582: END IF;

Line 588: , p_init_msg_list => FND_API.G_TRUE

584: -- Call OE_Pricing_Cont_PVT.Process_Pricing_Cont
585:
586: OE_Pricing_Cont_PVT.Process_Pricing_Cont
587: ( p_api_version_number => 1.0
588: , p_init_msg_list => FND_API.G_TRUE
589: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
590: , x_return_status => l_return_status
591: , x_msg_count => x_msg_count
592: , x_msg_data => x_msg_data

Line 589: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

585:
586: OE_Pricing_Cont_PVT.Process_Pricing_Cont
587: ( p_api_version_number => 1.0
588: , p_init_msg_list => FND_API.G_TRUE
589: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
590: , x_return_status => l_return_status
591: , x_msg_count => x_msg_count
592: , x_msg_data => x_msg_data
593: , p_control_rec => l_control_rec

Line 606: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

602: , x_Discount_Line_tbl => l_x_Discount_Line_tbl
603: , x_Price_Break_tbl => l_x_Price_Break_tbl
604: );
605:
606: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
608: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
609: RAISE FND_API.G_EXC_ERROR;
610: END IF;

Line 607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

603: , x_Price_Break_tbl => l_x_Price_Break_tbl
604: );
605:
606: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
608: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
609: RAISE FND_API.G_EXC_ERROR;
610: END IF;
611:

Line 608: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

604: );
605:
606: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
608: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
609: RAISE FND_API.G_EXC_ERROR;
610: END IF;
611:
612:

Line 609: RAISE FND_API.G_EXC_ERROR;

605:
606: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
608: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
609: RAISE FND_API.G_EXC_ERROR;
610: END IF;
611:
612:
613: -- Init OUT parameters to missing.

Line 615: x_accounting_rule_id := FND_API.G_MISS_NUM;

611:
612:
613: -- Init OUT parameters to missing.
614:
615: x_accounting_rule_id := FND_API.G_MISS_NUM;
616: x_agreement_contact_id := FND_API.G_MISS_NUM;
617: x_agreement_id := FND_API.G_MISS_NUM;
618: x_agreement_num := FND_API.G_MISS_CHAR;
619: x_agreement_type_code := FND_API.G_MISS_CHAR;

Line 616: x_agreement_contact_id := FND_API.G_MISS_NUM;

612:
613: -- Init OUT parameters to missing.
614:
615: x_accounting_rule_id := FND_API.G_MISS_NUM;
616: x_agreement_contact_id := FND_API.G_MISS_NUM;
617: x_agreement_id := FND_API.G_MISS_NUM;
618: x_agreement_num := FND_API.G_MISS_CHAR;
619: x_agreement_type_code := FND_API.G_MISS_CHAR;
620: x_attribute1 := FND_API.G_MISS_CHAR;

Line 617: x_agreement_id := FND_API.G_MISS_NUM;

613: -- Init OUT parameters to missing.
614:
615: x_accounting_rule_id := FND_API.G_MISS_NUM;
616: x_agreement_contact_id := FND_API.G_MISS_NUM;
617: x_agreement_id := FND_API.G_MISS_NUM;
618: x_agreement_num := FND_API.G_MISS_CHAR;
619: x_agreement_type_code := FND_API.G_MISS_CHAR;
620: x_attribute1 := FND_API.G_MISS_CHAR;
621: x_attribute10 := FND_API.G_MISS_CHAR;

Line 618: x_agreement_num := FND_API.G_MISS_CHAR;

614:
615: x_accounting_rule_id := FND_API.G_MISS_NUM;
616: x_agreement_contact_id := FND_API.G_MISS_NUM;
617: x_agreement_id := FND_API.G_MISS_NUM;
618: x_agreement_num := FND_API.G_MISS_CHAR;
619: x_agreement_type_code := FND_API.G_MISS_CHAR;
620: x_attribute1 := FND_API.G_MISS_CHAR;
621: x_attribute10 := FND_API.G_MISS_CHAR;
622: x_attribute11 := FND_API.G_MISS_CHAR;

Line 619: x_agreement_type_code := FND_API.G_MISS_CHAR;

615: x_accounting_rule_id := FND_API.G_MISS_NUM;
616: x_agreement_contact_id := FND_API.G_MISS_NUM;
617: x_agreement_id := FND_API.G_MISS_NUM;
618: x_agreement_num := FND_API.G_MISS_CHAR;
619: x_agreement_type_code := FND_API.G_MISS_CHAR;
620: x_attribute1 := FND_API.G_MISS_CHAR;
621: x_attribute10 := FND_API.G_MISS_CHAR;
622: x_attribute11 := FND_API.G_MISS_CHAR;
623: x_attribute12 := FND_API.G_MISS_CHAR;

Line 620: x_attribute1 := FND_API.G_MISS_CHAR;

616: x_agreement_contact_id := FND_API.G_MISS_NUM;
617: x_agreement_id := FND_API.G_MISS_NUM;
618: x_agreement_num := FND_API.G_MISS_CHAR;
619: x_agreement_type_code := FND_API.G_MISS_CHAR;
620: x_attribute1 := FND_API.G_MISS_CHAR;
621: x_attribute10 := FND_API.G_MISS_CHAR;
622: x_attribute11 := FND_API.G_MISS_CHAR;
623: x_attribute12 := FND_API.G_MISS_CHAR;
624: x_attribute13 := FND_API.G_MISS_CHAR;

Line 621: x_attribute10 := FND_API.G_MISS_CHAR;

617: x_agreement_id := FND_API.G_MISS_NUM;
618: x_agreement_num := FND_API.G_MISS_CHAR;
619: x_agreement_type_code := FND_API.G_MISS_CHAR;
620: x_attribute1 := FND_API.G_MISS_CHAR;
621: x_attribute10 := FND_API.G_MISS_CHAR;
622: x_attribute11 := FND_API.G_MISS_CHAR;
623: x_attribute12 := FND_API.G_MISS_CHAR;
624: x_attribute13 := FND_API.G_MISS_CHAR;
625: x_attribute14 := FND_API.G_MISS_CHAR;

Line 622: x_attribute11 := FND_API.G_MISS_CHAR;

618: x_agreement_num := FND_API.G_MISS_CHAR;
619: x_agreement_type_code := FND_API.G_MISS_CHAR;
620: x_attribute1 := FND_API.G_MISS_CHAR;
621: x_attribute10 := FND_API.G_MISS_CHAR;
622: x_attribute11 := FND_API.G_MISS_CHAR;
623: x_attribute12 := FND_API.G_MISS_CHAR;
624: x_attribute13 := FND_API.G_MISS_CHAR;
625: x_attribute14 := FND_API.G_MISS_CHAR;
626: x_attribute15 := FND_API.G_MISS_CHAR;

Line 623: x_attribute12 := FND_API.G_MISS_CHAR;

619: x_agreement_type_code := FND_API.G_MISS_CHAR;
620: x_attribute1 := FND_API.G_MISS_CHAR;
621: x_attribute10 := FND_API.G_MISS_CHAR;
622: x_attribute11 := FND_API.G_MISS_CHAR;
623: x_attribute12 := FND_API.G_MISS_CHAR;
624: x_attribute13 := FND_API.G_MISS_CHAR;
625: x_attribute14 := FND_API.G_MISS_CHAR;
626: x_attribute15 := FND_API.G_MISS_CHAR;
627: x_attribute2 := FND_API.G_MISS_CHAR;

Line 624: x_attribute13 := FND_API.G_MISS_CHAR;

620: x_attribute1 := FND_API.G_MISS_CHAR;
621: x_attribute10 := FND_API.G_MISS_CHAR;
622: x_attribute11 := FND_API.G_MISS_CHAR;
623: x_attribute12 := FND_API.G_MISS_CHAR;
624: x_attribute13 := FND_API.G_MISS_CHAR;
625: x_attribute14 := FND_API.G_MISS_CHAR;
626: x_attribute15 := FND_API.G_MISS_CHAR;
627: x_attribute2 := FND_API.G_MISS_CHAR;
628: x_attribute3 := FND_API.G_MISS_CHAR;

Line 625: x_attribute14 := FND_API.G_MISS_CHAR;

621: x_attribute10 := FND_API.G_MISS_CHAR;
622: x_attribute11 := FND_API.G_MISS_CHAR;
623: x_attribute12 := FND_API.G_MISS_CHAR;
624: x_attribute13 := FND_API.G_MISS_CHAR;
625: x_attribute14 := FND_API.G_MISS_CHAR;
626: x_attribute15 := FND_API.G_MISS_CHAR;
627: x_attribute2 := FND_API.G_MISS_CHAR;
628: x_attribute3 := FND_API.G_MISS_CHAR;
629: x_attribute4 := FND_API.G_MISS_CHAR;

Line 626: x_attribute15 := FND_API.G_MISS_CHAR;

622: x_attribute11 := FND_API.G_MISS_CHAR;
623: x_attribute12 := FND_API.G_MISS_CHAR;
624: x_attribute13 := FND_API.G_MISS_CHAR;
625: x_attribute14 := FND_API.G_MISS_CHAR;
626: x_attribute15 := FND_API.G_MISS_CHAR;
627: x_attribute2 := FND_API.G_MISS_CHAR;
628: x_attribute3 := FND_API.G_MISS_CHAR;
629: x_attribute4 := FND_API.G_MISS_CHAR;
630: x_attribute5 := FND_API.G_MISS_CHAR;

Line 627: x_attribute2 := FND_API.G_MISS_CHAR;

623: x_attribute12 := FND_API.G_MISS_CHAR;
624: x_attribute13 := FND_API.G_MISS_CHAR;
625: x_attribute14 := FND_API.G_MISS_CHAR;
626: x_attribute15 := FND_API.G_MISS_CHAR;
627: x_attribute2 := FND_API.G_MISS_CHAR;
628: x_attribute3 := FND_API.G_MISS_CHAR;
629: x_attribute4 := FND_API.G_MISS_CHAR;
630: x_attribute5 := FND_API.G_MISS_CHAR;
631: x_attribute6 := FND_API.G_MISS_CHAR;

Line 628: x_attribute3 := FND_API.G_MISS_CHAR;

624: x_attribute13 := FND_API.G_MISS_CHAR;
625: x_attribute14 := FND_API.G_MISS_CHAR;
626: x_attribute15 := FND_API.G_MISS_CHAR;
627: x_attribute2 := FND_API.G_MISS_CHAR;
628: x_attribute3 := FND_API.G_MISS_CHAR;
629: x_attribute4 := FND_API.G_MISS_CHAR;
630: x_attribute5 := FND_API.G_MISS_CHAR;
631: x_attribute6 := FND_API.G_MISS_CHAR;
632: x_attribute7 := FND_API.G_MISS_CHAR;

Line 629: x_attribute4 := FND_API.G_MISS_CHAR;

625: x_attribute14 := FND_API.G_MISS_CHAR;
626: x_attribute15 := FND_API.G_MISS_CHAR;
627: x_attribute2 := FND_API.G_MISS_CHAR;
628: x_attribute3 := FND_API.G_MISS_CHAR;
629: x_attribute4 := FND_API.G_MISS_CHAR;
630: x_attribute5 := FND_API.G_MISS_CHAR;
631: x_attribute6 := FND_API.G_MISS_CHAR;
632: x_attribute7 := FND_API.G_MISS_CHAR;
633: x_attribute8 := FND_API.G_MISS_CHAR;

Line 630: x_attribute5 := FND_API.G_MISS_CHAR;

626: x_attribute15 := FND_API.G_MISS_CHAR;
627: x_attribute2 := FND_API.G_MISS_CHAR;
628: x_attribute3 := FND_API.G_MISS_CHAR;
629: x_attribute4 := FND_API.G_MISS_CHAR;
630: x_attribute5 := FND_API.G_MISS_CHAR;
631: x_attribute6 := FND_API.G_MISS_CHAR;
632: x_attribute7 := FND_API.G_MISS_CHAR;
633: x_attribute8 := FND_API.G_MISS_CHAR;
634: x_attribute9 := FND_API.G_MISS_CHAR;

Line 631: x_attribute6 := FND_API.G_MISS_CHAR;

627: x_attribute2 := FND_API.G_MISS_CHAR;
628: x_attribute3 := FND_API.G_MISS_CHAR;
629: x_attribute4 := FND_API.G_MISS_CHAR;
630: x_attribute5 := FND_API.G_MISS_CHAR;
631: x_attribute6 := FND_API.G_MISS_CHAR;
632: x_attribute7 := FND_API.G_MISS_CHAR;
633: x_attribute8 := FND_API.G_MISS_CHAR;
634: x_attribute9 := FND_API.G_MISS_CHAR;
635: x_context := FND_API.G_MISS_CHAR;

Line 632: x_attribute7 := FND_API.G_MISS_CHAR;

628: x_attribute3 := FND_API.G_MISS_CHAR;
629: x_attribute4 := FND_API.G_MISS_CHAR;
630: x_attribute5 := FND_API.G_MISS_CHAR;
631: x_attribute6 := FND_API.G_MISS_CHAR;
632: x_attribute7 := FND_API.G_MISS_CHAR;
633: x_attribute8 := FND_API.G_MISS_CHAR;
634: x_attribute9 := FND_API.G_MISS_CHAR;
635: x_context := FND_API.G_MISS_CHAR;
636: x_sold_to_org_id := FND_API.G_MISS_NUM;

Line 633: x_attribute8 := FND_API.G_MISS_CHAR;

629: x_attribute4 := FND_API.G_MISS_CHAR;
630: x_attribute5 := FND_API.G_MISS_CHAR;
631: x_attribute6 := FND_API.G_MISS_CHAR;
632: x_attribute7 := FND_API.G_MISS_CHAR;
633: x_attribute8 := FND_API.G_MISS_CHAR;
634: x_attribute9 := FND_API.G_MISS_CHAR;
635: x_context := FND_API.G_MISS_CHAR;
636: x_sold_to_org_id := FND_API.G_MISS_NUM;
637: x_end_date_active := FND_API.G_MISS_DATE;

Line 634: x_attribute9 := FND_API.G_MISS_CHAR;

630: x_attribute5 := FND_API.G_MISS_CHAR;
631: x_attribute6 := FND_API.G_MISS_CHAR;
632: x_attribute7 := FND_API.G_MISS_CHAR;
633: x_attribute8 := FND_API.G_MISS_CHAR;
634: x_attribute9 := FND_API.G_MISS_CHAR;
635: x_context := FND_API.G_MISS_CHAR;
636: x_sold_to_org_id := FND_API.G_MISS_NUM;
637: x_end_date_active := FND_API.G_MISS_DATE;
638: x_freight_terms_code := FND_API.G_MISS_CHAR;

Line 635: x_context := FND_API.G_MISS_CHAR;

631: x_attribute6 := FND_API.G_MISS_CHAR;
632: x_attribute7 := FND_API.G_MISS_CHAR;
633: x_attribute8 := FND_API.G_MISS_CHAR;
634: x_attribute9 := FND_API.G_MISS_CHAR;
635: x_context := FND_API.G_MISS_CHAR;
636: x_sold_to_org_id := FND_API.G_MISS_NUM;
637: x_end_date_active := FND_API.G_MISS_DATE;
638: x_freight_terms_code := FND_API.G_MISS_CHAR;
639: x_invoice_contact_id := FND_API.G_MISS_NUM;

Line 636: x_sold_to_org_id := FND_API.G_MISS_NUM;

632: x_attribute7 := FND_API.G_MISS_CHAR;
633: x_attribute8 := FND_API.G_MISS_CHAR;
634: x_attribute9 := FND_API.G_MISS_CHAR;
635: x_context := FND_API.G_MISS_CHAR;
636: x_sold_to_org_id := FND_API.G_MISS_NUM;
637: x_end_date_active := FND_API.G_MISS_DATE;
638: x_freight_terms_code := FND_API.G_MISS_CHAR;
639: x_invoice_contact_id := FND_API.G_MISS_NUM;
640: x_invoice_to_org_id := FND_API.G_MISS_NUM;

Line 637: x_end_date_active := FND_API.G_MISS_DATE;

633: x_attribute8 := FND_API.G_MISS_CHAR;
634: x_attribute9 := FND_API.G_MISS_CHAR;
635: x_context := FND_API.G_MISS_CHAR;
636: x_sold_to_org_id := FND_API.G_MISS_NUM;
637: x_end_date_active := FND_API.G_MISS_DATE;
638: x_freight_terms_code := FND_API.G_MISS_CHAR;
639: x_invoice_contact_id := FND_API.G_MISS_NUM;
640: x_invoice_to_org_id := FND_API.G_MISS_NUM;
641: x_invoicing_rule_id := FND_API.G_MISS_NUM;

Line 638: x_freight_terms_code := FND_API.G_MISS_CHAR;

634: x_attribute9 := FND_API.G_MISS_CHAR;
635: x_context := FND_API.G_MISS_CHAR;
636: x_sold_to_org_id := FND_API.G_MISS_NUM;
637: x_end_date_active := FND_API.G_MISS_DATE;
638: x_freight_terms_code := FND_API.G_MISS_CHAR;
639: x_invoice_contact_id := FND_API.G_MISS_NUM;
640: x_invoice_to_org_id := FND_API.G_MISS_NUM;
641: x_invoicing_rule_id := FND_API.G_MISS_NUM;
642: x_name := FND_API.G_MISS_CHAR;

Line 639: x_invoice_contact_id := FND_API.G_MISS_NUM;

635: x_context := FND_API.G_MISS_CHAR;
636: x_sold_to_org_id := FND_API.G_MISS_NUM;
637: x_end_date_active := FND_API.G_MISS_DATE;
638: x_freight_terms_code := FND_API.G_MISS_CHAR;
639: x_invoice_contact_id := FND_API.G_MISS_NUM;
640: x_invoice_to_org_id := FND_API.G_MISS_NUM;
641: x_invoicing_rule_id := FND_API.G_MISS_NUM;
642: x_name := FND_API.G_MISS_CHAR;
643: x_override_arule_flag := FND_API.G_MISS_CHAR;

Line 640: x_invoice_to_org_id := FND_API.G_MISS_NUM;

636: x_sold_to_org_id := FND_API.G_MISS_NUM;
637: x_end_date_active := FND_API.G_MISS_DATE;
638: x_freight_terms_code := FND_API.G_MISS_CHAR;
639: x_invoice_contact_id := FND_API.G_MISS_NUM;
640: x_invoice_to_org_id := FND_API.G_MISS_NUM;
641: x_invoicing_rule_id := FND_API.G_MISS_NUM;
642: x_name := FND_API.G_MISS_CHAR;
643: x_override_arule_flag := FND_API.G_MISS_CHAR;
644: x_override_irule_flag := FND_API.G_MISS_CHAR;

Line 641: x_invoicing_rule_id := FND_API.G_MISS_NUM;

637: x_end_date_active := FND_API.G_MISS_DATE;
638: x_freight_terms_code := FND_API.G_MISS_CHAR;
639: x_invoice_contact_id := FND_API.G_MISS_NUM;
640: x_invoice_to_org_id := FND_API.G_MISS_NUM;
641: x_invoicing_rule_id := FND_API.G_MISS_NUM;
642: x_name := FND_API.G_MISS_CHAR;
643: x_override_arule_flag := FND_API.G_MISS_CHAR;
644: x_override_irule_flag := FND_API.G_MISS_CHAR;
645: x_price_list_id := FND_API.G_MISS_NUM;

Line 642: x_name := FND_API.G_MISS_CHAR;

638: x_freight_terms_code := FND_API.G_MISS_CHAR;
639: x_invoice_contact_id := FND_API.G_MISS_NUM;
640: x_invoice_to_org_id := FND_API.G_MISS_NUM;
641: x_invoicing_rule_id := FND_API.G_MISS_NUM;
642: x_name := FND_API.G_MISS_CHAR;
643: x_override_arule_flag := FND_API.G_MISS_CHAR;
644: x_override_irule_flag := FND_API.G_MISS_CHAR;
645: x_price_list_id := FND_API.G_MISS_NUM;
646: x_purchase_order_num := FND_API.G_MISS_CHAR;

Line 643: x_override_arule_flag := FND_API.G_MISS_CHAR;

639: x_invoice_contact_id := FND_API.G_MISS_NUM;
640: x_invoice_to_org_id := FND_API.G_MISS_NUM;
641: x_invoicing_rule_id := FND_API.G_MISS_NUM;
642: x_name := FND_API.G_MISS_CHAR;
643: x_override_arule_flag := FND_API.G_MISS_CHAR;
644: x_override_irule_flag := FND_API.G_MISS_CHAR;
645: x_price_list_id := FND_API.G_MISS_NUM;
646: x_purchase_order_num := FND_API.G_MISS_CHAR;
647: x_revision := FND_API.G_MISS_CHAR;

Line 644: x_override_irule_flag := FND_API.G_MISS_CHAR;

640: x_invoice_to_org_id := FND_API.G_MISS_NUM;
641: x_invoicing_rule_id := FND_API.G_MISS_NUM;
642: x_name := FND_API.G_MISS_CHAR;
643: x_override_arule_flag := FND_API.G_MISS_CHAR;
644: x_override_irule_flag := FND_API.G_MISS_CHAR;
645: x_price_list_id := FND_API.G_MISS_NUM;
646: x_purchase_order_num := FND_API.G_MISS_CHAR;
647: x_revision := FND_API.G_MISS_CHAR;
648: x_revision_date := FND_API.G_MISS_DATE;

Line 645: x_price_list_id := FND_API.G_MISS_NUM;

641: x_invoicing_rule_id := FND_API.G_MISS_NUM;
642: x_name := FND_API.G_MISS_CHAR;
643: x_override_arule_flag := FND_API.G_MISS_CHAR;
644: x_override_irule_flag := FND_API.G_MISS_CHAR;
645: x_price_list_id := FND_API.G_MISS_NUM;
646: x_purchase_order_num := FND_API.G_MISS_CHAR;
647: x_revision := FND_API.G_MISS_CHAR;
648: x_revision_date := FND_API.G_MISS_DATE;
649: x_revision_reason_code := FND_API.G_MISS_CHAR;

Line 646: x_purchase_order_num := FND_API.G_MISS_CHAR;

642: x_name := FND_API.G_MISS_CHAR;
643: x_override_arule_flag := FND_API.G_MISS_CHAR;
644: x_override_irule_flag := FND_API.G_MISS_CHAR;
645: x_price_list_id := FND_API.G_MISS_NUM;
646: x_purchase_order_num := FND_API.G_MISS_CHAR;
647: x_revision := FND_API.G_MISS_CHAR;
648: x_revision_date := FND_API.G_MISS_DATE;
649: x_revision_reason_code := FND_API.G_MISS_CHAR;
650: x_salesrep_id := FND_API.G_MISS_NUM;

Line 647: x_revision := FND_API.G_MISS_CHAR;

643: x_override_arule_flag := FND_API.G_MISS_CHAR;
644: x_override_irule_flag := FND_API.G_MISS_CHAR;
645: x_price_list_id := FND_API.G_MISS_NUM;
646: x_purchase_order_num := FND_API.G_MISS_CHAR;
647: x_revision := FND_API.G_MISS_CHAR;
648: x_revision_date := FND_API.G_MISS_DATE;
649: x_revision_reason_code := FND_API.G_MISS_CHAR;
650: x_salesrep_id := FND_API.G_MISS_NUM;
651: x_ship_method_code := FND_API.G_MISS_CHAR;

Line 648: x_revision_date := FND_API.G_MISS_DATE;

644: x_override_irule_flag := FND_API.G_MISS_CHAR;
645: x_price_list_id := FND_API.G_MISS_NUM;
646: x_purchase_order_num := FND_API.G_MISS_CHAR;
647: x_revision := FND_API.G_MISS_CHAR;
648: x_revision_date := FND_API.G_MISS_DATE;
649: x_revision_reason_code := FND_API.G_MISS_CHAR;
650: x_salesrep_id := FND_API.G_MISS_NUM;
651: x_ship_method_code := FND_API.G_MISS_CHAR;
652: x_signature_date := FND_API.G_MISS_DATE;

Line 649: x_revision_reason_code := FND_API.G_MISS_CHAR;

645: x_price_list_id := FND_API.G_MISS_NUM;
646: x_purchase_order_num := FND_API.G_MISS_CHAR;
647: x_revision := FND_API.G_MISS_CHAR;
648: x_revision_date := FND_API.G_MISS_DATE;
649: x_revision_reason_code := FND_API.G_MISS_CHAR;
650: x_salesrep_id := FND_API.G_MISS_NUM;
651: x_ship_method_code := FND_API.G_MISS_CHAR;
652: x_signature_date := FND_API.G_MISS_DATE;
653: x_start_date_active := FND_API.G_MISS_DATE;

Line 650: x_salesrep_id := FND_API.G_MISS_NUM;

646: x_purchase_order_num := FND_API.G_MISS_CHAR;
647: x_revision := FND_API.G_MISS_CHAR;
648: x_revision_date := FND_API.G_MISS_DATE;
649: x_revision_reason_code := FND_API.G_MISS_CHAR;
650: x_salesrep_id := FND_API.G_MISS_NUM;
651: x_ship_method_code := FND_API.G_MISS_CHAR;
652: x_signature_date := FND_API.G_MISS_DATE;
653: x_start_date_active := FND_API.G_MISS_DATE;
654: x_term_id := FND_API.G_MISS_NUM;

Line 651: x_ship_method_code := FND_API.G_MISS_CHAR;

647: x_revision := FND_API.G_MISS_CHAR;
648: x_revision_date := FND_API.G_MISS_DATE;
649: x_revision_reason_code := FND_API.G_MISS_CHAR;
650: x_salesrep_id := FND_API.G_MISS_NUM;
651: x_ship_method_code := FND_API.G_MISS_CHAR;
652: x_signature_date := FND_API.G_MISS_DATE;
653: x_start_date_active := FND_API.G_MISS_DATE;
654: x_term_id := FND_API.G_MISS_NUM;
655: x_accounting_rule := FND_API.G_MISS_CHAR;

Line 652: x_signature_date := FND_API.G_MISS_DATE;

648: x_revision_date := FND_API.G_MISS_DATE;
649: x_revision_reason_code := FND_API.G_MISS_CHAR;
650: x_salesrep_id := FND_API.G_MISS_NUM;
651: x_ship_method_code := FND_API.G_MISS_CHAR;
652: x_signature_date := FND_API.G_MISS_DATE;
653: x_start_date_active := FND_API.G_MISS_DATE;
654: x_term_id := FND_API.G_MISS_NUM;
655: x_accounting_rule := FND_API.G_MISS_CHAR;
656: x_agreement_contact := FND_API.G_MISS_CHAR;

Line 653: x_start_date_active := FND_API.G_MISS_DATE;

649: x_revision_reason_code := FND_API.G_MISS_CHAR;
650: x_salesrep_id := FND_API.G_MISS_NUM;
651: x_ship_method_code := FND_API.G_MISS_CHAR;
652: x_signature_date := FND_API.G_MISS_DATE;
653: x_start_date_active := FND_API.G_MISS_DATE;
654: x_term_id := FND_API.G_MISS_NUM;
655: x_accounting_rule := FND_API.G_MISS_CHAR;
656: x_agreement_contact := FND_API.G_MISS_CHAR;
657: x_agreement := FND_API.G_MISS_CHAR;

Line 654: x_term_id := FND_API.G_MISS_NUM;

650: x_salesrep_id := FND_API.G_MISS_NUM;
651: x_ship_method_code := FND_API.G_MISS_CHAR;
652: x_signature_date := FND_API.G_MISS_DATE;
653: x_start_date_active := FND_API.G_MISS_DATE;
654: x_term_id := FND_API.G_MISS_NUM;
655: x_accounting_rule := FND_API.G_MISS_CHAR;
656: x_agreement_contact := FND_API.G_MISS_CHAR;
657: x_agreement := FND_API.G_MISS_CHAR;
658: x_agreement_type := FND_API.G_MISS_CHAR;

Line 655: x_accounting_rule := FND_API.G_MISS_CHAR;

651: x_ship_method_code := FND_API.G_MISS_CHAR;
652: x_signature_date := FND_API.G_MISS_DATE;
653: x_start_date_active := FND_API.G_MISS_DATE;
654: x_term_id := FND_API.G_MISS_NUM;
655: x_accounting_rule := FND_API.G_MISS_CHAR;
656: x_agreement_contact := FND_API.G_MISS_CHAR;
657: x_agreement := FND_API.G_MISS_CHAR;
658: x_agreement_type := FND_API.G_MISS_CHAR;
659: x_customer := FND_API.G_MISS_CHAR;

Line 656: x_agreement_contact := FND_API.G_MISS_CHAR;

652: x_signature_date := FND_API.G_MISS_DATE;
653: x_start_date_active := FND_API.G_MISS_DATE;
654: x_term_id := FND_API.G_MISS_NUM;
655: x_accounting_rule := FND_API.G_MISS_CHAR;
656: x_agreement_contact := FND_API.G_MISS_CHAR;
657: x_agreement := FND_API.G_MISS_CHAR;
658: x_agreement_type := FND_API.G_MISS_CHAR;
659: x_customer := FND_API.G_MISS_CHAR;
660: x_freight_terms := FND_API.G_MISS_CHAR;

Line 657: x_agreement := FND_API.G_MISS_CHAR;

653: x_start_date_active := FND_API.G_MISS_DATE;
654: x_term_id := FND_API.G_MISS_NUM;
655: x_accounting_rule := FND_API.G_MISS_CHAR;
656: x_agreement_contact := FND_API.G_MISS_CHAR;
657: x_agreement := FND_API.G_MISS_CHAR;
658: x_agreement_type := FND_API.G_MISS_CHAR;
659: x_customer := FND_API.G_MISS_CHAR;
660: x_freight_terms := FND_API.G_MISS_CHAR;
661: x_invoice_contact := FND_API.G_MISS_CHAR;

Line 658: x_agreement_type := FND_API.G_MISS_CHAR;

654: x_term_id := FND_API.G_MISS_NUM;
655: x_accounting_rule := FND_API.G_MISS_CHAR;
656: x_agreement_contact := FND_API.G_MISS_CHAR;
657: x_agreement := FND_API.G_MISS_CHAR;
658: x_agreement_type := FND_API.G_MISS_CHAR;
659: x_customer := FND_API.G_MISS_CHAR;
660: x_freight_terms := FND_API.G_MISS_CHAR;
661: x_invoice_contact := FND_API.G_MISS_CHAR;
662: x_invoice_to_site_use := FND_API.G_MISS_CHAR;

Line 659: x_customer := FND_API.G_MISS_CHAR;

655: x_accounting_rule := FND_API.G_MISS_CHAR;
656: x_agreement_contact := FND_API.G_MISS_CHAR;
657: x_agreement := FND_API.G_MISS_CHAR;
658: x_agreement_type := FND_API.G_MISS_CHAR;
659: x_customer := FND_API.G_MISS_CHAR;
660: x_freight_terms := FND_API.G_MISS_CHAR;
661: x_invoice_contact := FND_API.G_MISS_CHAR;
662: x_invoice_to_site_use := FND_API.G_MISS_CHAR;
663: /* x_invoice_org := FND_API.G_MISS_CHAR; */

Line 660: x_freight_terms := FND_API.G_MISS_CHAR;

656: x_agreement_contact := FND_API.G_MISS_CHAR;
657: x_agreement := FND_API.G_MISS_CHAR;
658: x_agreement_type := FND_API.G_MISS_CHAR;
659: x_customer := FND_API.G_MISS_CHAR;
660: x_freight_terms := FND_API.G_MISS_CHAR;
661: x_invoice_contact := FND_API.G_MISS_CHAR;
662: x_invoice_to_site_use := FND_API.G_MISS_CHAR;
663: /* x_invoice_org := FND_API.G_MISS_CHAR; */
664: x_invoicing_rule := FND_API.G_MISS_CHAR;

Line 661: x_invoice_contact := FND_API.G_MISS_CHAR;

657: x_agreement := FND_API.G_MISS_CHAR;
658: x_agreement_type := FND_API.G_MISS_CHAR;
659: x_customer := FND_API.G_MISS_CHAR;
660: x_freight_terms := FND_API.G_MISS_CHAR;
661: x_invoice_contact := FND_API.G_MISS_CHAR;
662: x_invoice_to_site_use := FND_API.G_MISS_CHAR;
663: /* x_invoice_org := FND_API.G_MISS_CHAR; */
664: x_invoicing_rule := FND_API.G_MISS_CHAR;
665: x_override_arule := FND_API.G_MISS_CHAR;

Line 662: x_invoice_to_site_use := FND_API.G_MISS_CHAR;

658: x_agreement_type := FND_API.G_MISS_CHAR;
659: x_customer := FND_API.G_MISS_CHAR;
660: x_freight_terms := FND_API.G_MISS_CHAR;
661: x_invoice_contact := FND_API.G_MISS_CHAR;
662: x_invoice_to_site_use := FND_API.G_MISS_CHAR;
663: /* x_invoice_org := FND_API.G_MISS_CHAR; */
664: x_invoicing_rule := FND_API.G_MISS_CHAR;
665: x_override_arule := FND_API.G_MISS_CHAR;
666: x_override_irule := FND_API.G_MISS_CHAR;

Line 663: /* x_invoice_org := FND_API.G_MISS_CHAR; */

659: x_customer := FND_API.G_MISS_CHAR;
660: x_freight_terms := FND_API.G_MISS_CHAR;
661: x_invoice_contact := FND_API.G_MISS_CHAR;
662: x_invoice_to_site_use := FND_API.G_MISS_CHAR;
663: /* x_invoice_org := FND_API.G_MISS_CHAR; */
664: x_invoicing_rule := FND_API.G_MISS_CHAR;
665: x_override_arule := FND_API.G_MISS_CHAR;
666: x_override_irule := FND_API.G_MISS_CHAR;
667: x_price_list := FND_API.G_MISS_CHAR;

Line 664: x_invoicing_rule := FND_API.G_MISS_CHAR;

660: x_freight_terms := FND_API.G_MISS_CHAR;
661: x_invoice_contact := FND_API.G_MISS_CHAR;
662: x_invoice_to_site_use := FND_API.G_MISS_CHAR;
663: /* x_invoice_org := FND_API.G_MISS_CHAR; */
664: x_invoicing_rule := FND_API.G_MISS_CHAR;
665: x_override_arule := FND_API.G_MISS_CHAR;
666: x_override_irule := FND_API.G_MISS_CHAR;
667: x_price_list := FND_API.G_MISS_CHAR;
668: x_revision_reason := FND_API.G_MISS_CHAR;

Line 665: x_override_arule := FND_API.G_MISS_CHAR;

661: x_invoice_contact := FND_API.G_MISS_CHAR;
662: x_invoice_to_site_use := FND_API.G_MISS_CHAR;
663: /* x_invoice_org := FND_API.G_MISS_CHAR; */
664: x_invoicing_rule := FND_API.G_MISS_CHAR;
665: x_override_arule := FND_API.G_MISS_CHAR;
666: x_override_irule := FND_API.G_MISS_CHAR;
667: x_price_list := FND_API.G_MISS_CHAR;
668: x_revision_reason := FND_API.G_MISS_CHAR;
669: x_salesrep := FND_API.G_MISS_CHAR;

Line 666: x_override_irule := FND_API.G_MISS_CHAR;

662: x_invoice_to_site_use := FND_API.G_MISS_CHAR;
663: /* x_invoice_org := FND_API.G_MISS_CHAR; */
664: x_invoicing_rule := FND_API.G_MISS_CHAR;
665: x_override_arule := FND_API.G_MISS_CHAR;
666: x_override_irule := FND_API.G_MISS_CHAR;
667: x_price_list := FND_API.G_MISS_CHAR;
668: x_revision_reason := FND_API.G_MISS_CHAR;
669: x_salesrep := FND_API.G_MISS_CHAR;
670: x_ship_method := FND_API.G_MISS_CHAR;

Line 667: x_price_list := FND_API.G_MISS_CHAR;

663: /* x_invoice_org := FND_API.G_MISS_CHAR; */
664: x_invoicing_rule := FND_API.G_MISS_CHAR;
665: x_override_arule := FND_API.G_MISS_CHAR;
666: x_override_irule := FND_API.G_MISS_CHAR;
667: x_price_list := FND_API.G_MISS_CHAR;
668: x_revision_reason := FND_API.G_MISS_CHAR;
669: x_salesrep := FND_API.G_MISS_CHAR;
670: x_ship_method := FND_API.G_MISS_CHAR;
671: x_term := FND_API.G_MISS_CHAR;

Line 668: x_revision_reason := FND_API.G_MISS_CHAR;

664: x_invoicing_rule := FND_API.G_MISS_CHAR;
665: x_override_arule := FND_API.G_MISS_CHAR;
666: x_override_irule := FND_API.G_MISS_CHAR;
667: x_price_list := FND_API.G_MISS_CHAR;
668: x_revision_reason := FND_API.G_MISS_CHAR;
669: x_salesrep := FND_API.G_MISS_CHAR;
670: x_ship_method := FND_API.G_MISS_CHAR;
671: x_term := FND_API.G_MISS_CHAR;
672: x_agreement_source_code := FND_API.G_MISS_CHAR;

Line 669: x_salesrep := FND_API.G_MISS_CHAR;

665: x_override_arule := FND_API.G_MISS_CHAR;
666: x_override_irule := FND_API.G_MISS_CHAR;
667: x_price_list := FND_API.G_MISS_CHAR;
668: x_revision_reason := FND_API.G_MISS_CHAR;
669: x_salesrep := FND_API.G_MISS_CHAR;
670: x_ship_method := FND_API.G_MISS_CHAR;
671: x_term := FND_API.G_MISS_CHAR;
672: x_agreement_source_code := FND_API.G_MISS_CHAR;
673: --added by rchellam for OKC

Line 670: x_ship_method := FND_API.G_MISS_CHAR;

666: x_override_irule := FND_API.G_MISS_CHAR;
667: x_price_list := FND_API.G_MISS_CHAR;
668: x_revision_reason := FND_API.G_MISS_CHAR;
669: x_salesrep := FND_API.G_MISS_CHAR;
670: x_ship_method := FND_API.G_MISS_CHAR;
671: x_term := FND_API.G_MISS_CHAR;
672: x_agreement_source_code := FND_API.G_MISS_CHAR;
673: --added by rchellam for OKC
674: x_orig_system_agr_id := FND_API.G_MISS_NUM;

Line 671: x_term := FND_API.G_MISS_CHAR;

667: x_price_list := FND_API.G_MISS_CHAR;
668: x_revision_reason := FND_API.G_MISS_CHAR;
669: x_salesrep := FND_API.G_MISS_CHAR;
670: x_ship_method := FND_API.G_MISS_CHAR;
671: x_term := FND_API.G_MISS_CHAR;
672: x_agreement_source_code := FND_API.G_MISS_CHAR;
673: --added by rchellam for OKC
674: x_orig_system_agr_id := FND_API.G_MISS_NUM;
675: --added by rchellam for OKC

Line 672: x_agreement_source_code := FND_API.G_MISS_CHAR;

668: x_revision_reason := FND_API.G_MISS_CHAR;
669: x_salesrep := FND_API.G_MISS_CHAR;
670: x_ship_method := FND_API.G_MISS_CHAR;
671: x_term := FND_API.G_MISS_CHAR;
672: x_agreement_source_code := FND_API.G_MISS_CHAR;
673: --added by rchellam for OKC
674: x_orig_system_agr_id := FND_API.G_MISS_NUM;
675: --added by rchellam for OKC
676: x_agreement_source := FND_API.G_MISS_CHAR;

Line 674: x_orig_system_agr_id := FND_API.G_MISS_NUM;

670: x_ship_method := FND_API.G_MISS_CHAR;
671: x_term := FND_API.G_MISS_CHAR;
672: x_agreement_source_code := FND_API.G_MISS_CHAR;
673: --added by rchellam for OKC
674: x_orig_system_agr_id := FND_API.G_MISS_NUM;
675: --added by rchellam for OKC
676: x_agreement_source := FND_API.G_MISS_CHAR;
677: --added by rchellam for OKC
678: x_invoice_to_customer_id := FND_API.G_MISS_NUM;

Line 676: x_agreement_source := FND_API.G_MISS_CHAR;

672: x_agreement_source_code := FND_API.G_MISS_CHAR;
673: --added by rchellam for OKC
674: x_orig_system_agr_id := FND_API.G_MISS_NUM;
675: --added by rchellam for OKC
676: x_agreement_source := FND_API.G_MISS_CHAR;
677: --added by rchellam for OKC
678: x_invoice_to_customer_id := FND_API.G_MISS_NUM;
679: -- Added for bug#4029589
680:

Line 678: x_invoice_to_customer_id := FND_API.G_MISS_NUM;

674: x_orig_system_agr_id := FND_API.G_MISS_NUM;
675: --added by rchellam for OKC
676: x_agreement_source := FND_API.G_MISS_CHAR;
677: --added by rchellam for OKC
678: x_invoice_to_customer_id := FND_API.G_MISS_NUM;
679: -- Added for bug#4029589
680:
681: -- Load display out parameters if any
682:

Line 1002: x_return_status := FND_API.G_RET_STS_SUCCESS;

998: /* End of code for Bug-2106110 */
999:
1000: -- Set return status.
1001:
1002: x_return_status := FND_API.G_RET_STS_SUCCESS;
1003:
1004: -- Get message count and data
1005:
1006: OE_MSG_PUB.Count_And_Get

Line 1015: WHEN FND_API.G_EXC_ERROR THEN

1011: oe_debug_pub.add('Exiting OE_OE_Form_Agreement.Change_Attribute');
1012:
1013: EXCEPTION
1014:
1015: WHEN FND_API.G_EXC_ERROR THEN
1016:
1017: x_return_status := FND_API.G_RET_STS_ERROR;
1018:
1019: -- Get message count and data

Line 1017: x_return_status := FND_API.G_RET_STS_ERROR;

1013: EXCEPTION
1014:
1015: WHEN FND_API.G_EXC_ERROR THEN
1016:
1017: x_return_status := FND_API.G_RET_STS_ERROR;
1018:
1019: -- Get message count and data
1020:
1021: OE_MSG_PUB.Count_And_Get

Line 1026: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1022: ( p_count => x_msg_count
1023: , p_data => x_msg_data
1024: );
1025:
1026: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1027:
1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1029:
1030: -- Get message count and data

Line 1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1024: );
1025:
1026: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1027:
1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1029:
1030: -- Get message count and data
1031:
1032: OE_MSG_PUB.Count_And_Get

Line 1039: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1035: );
1036:
1037: WHEN OTHERS THEN
1038:
1039: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1040:
1041: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1042: THEN
1043: OE_MSG_PUB.Add_Exc_Msg

Line 1122: IF FND_API.To_Boolean(l_Agreement_rec.db_flag) THEN

1118: );
1119:
1120: -- Set Operation.
1121:
1122: IF FND_API.To_Boolean(l_Agreement_rec.db_flag) THEN
1123: l_Agreement_rec.operation := oe_globals.G_OPR_UPDATE;
1124: ELSE
1125: l_Agreement_rec.operation := oe_globals.G_OPR_CREATE;
1126: END IF;

Line 1137: l_Agreement_rec.db_flag := FND_API.G_FALSE;

1133:
1134: select oe_agreements_s.nextval into l_agreement_rec.agreement_id from dual;
1135:
1136: l_Agreement_rec.operation := oe_globals.G_OPR_CREATE;
1137: l_Agreement_rec.db_flag := FND_API.G_FALSE;
1138: --OE_OE_Form_Contract.Create_Revision(l_agreement_rec.agreement_id);
1139: END IF;
1140: --Revision Control E
1141:

Line 1151: , p_init_msg_list => FND_API.G_TRUE

1147:
1148:
1149: OE_Pricing_Cont_PVT.Process_Pricing_Cont
1150: ( p_api_version_number => 1.0
1151: , p_init_msg_list => FND_API.G_TRUE
1152: , x_return_status => l_return_status
1153: , x_msg_count => x_msg_count
1154: , x_msg_data => x_msg_data
1155: , p_control_rec => l_control_rec

Line 1172: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1168:
1169: /* commit; */
1170:
1171:
1172: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1174: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1175: RAISE FND_API.G_EXC_ERROR;
1176:

Line 1173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1169: /* commit; */
1170:
1171:
1172: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1174: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1175: RAISE FND_API.G_EXC_ERROR;
1176:
1177: END IF;

Line 1174: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1170:
1171:
1172: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1174: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1175: RAISE FND_API.G_EXC_ERROR;
1176:
1177: END IF;
1178:

Line 1175: RAISE FND_API.G_EXC_ERROR;

1171:
1172: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1174: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1175: RAISE FND_API.G_EXC_ERROR;
1176:
1177: END IF;
1178:
1179:

Line 1200: x_return_status := FND_API.G_RET_STS_SUCCESS;

1196:
1197:
1198: -- Set return status.
1199:
1200: x_return_status := FND_API.G_RET_STS_SUCCESS;
1201:
1202: -- Get message count and data
1203:
1204: OE_MSG_PUB.Count_And_Get

Line 1213: WHEN FND_API.G_EXC_ERROR THEN

1209: oe_debug_pub.add('Exiting OE_OE_Form_Agreement.Validate_And_Write');
1210:
1211: EXCEPTION
1212:
1213: WHEN FND_API.G_EXC_ERROR THEN
1214:
1215: x_return_status := FND_API.G_RET_STS_ERROR;
1216:
1217: -- Get message count and data

Line 1215: x_return_status := FND_API.G_RET_STS_ERROR;

1211: EXCEPTION
1212:
1213: WHEN FND_API.G_EXC_ERROR THEN
1214:
1215: x_return_status := FND_API.G_RET_STS_ERROR;
1216:
1217: -- Get message count and data
1218:
1219:

Line 1230: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1226: ( G_PKG_NAME
1227: , x_msg_count || '1 ' || x_msg_data
1228: );
1229:
1230: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1231:
1232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1233:
1234: -- Get message count and data

Line 1232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1228: );
1229:
1230: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1231:
1232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1233:
1234: -- Get message count and data
1235:
1236: OE_MSG_PUB.Count_And_Get

Line 1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1243: );
1244:
1245: WHEN OTHERS THEN
1246:
1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1248:
1249: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1250: THEN
1251: OE_MSG_PUB.Add_Exc_Msg

Line 1328: , p_init_msg_list => FND_API.G_TRUE

1324: -- Call OE_Pricing_Cont_PVT.Process_Pricing_Cont
1325:
1326: OE_Pricing_Cont_PVT.Process_Pricing_Cont
1327: ( p_api_version_number => 1.0
1328: , p_init_msg_list => FND_API.G_TRUE
1329: , x_return_status => l_return_status
1330: , x_msg_count => x_msg_count
1331: , x_msg_data => x_msg_data
1332: , p_control_rec => l_control_rec

Line 1344: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1340: , x_Discount_Line_tbl => l_x_Discount_Line_tbl
1341: , x_Price_Break_tbl => l_x_Price_Break_tbl
1342: );
1343:
1344: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1346: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1347: RAISE FND_API.G_EXC_ERROR;
1348: END IF;

Line 1345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1341: , x_Price_Break_tbl => l_x_Price_Break_tbl
1342: );
1343:
1344: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1346: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1347: RAISE FND_API.G_EXC_ERROR;
1348: END IF;
1349:

Line 1346: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1342: );
1343:
1344: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1346: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1347: RAISE FND_API.G_EXC_ERROR;
1348: END IF;
1349:
1350:

Line 1347: RAISE FND_API.G_EXC_ERROR;

1343:
1344: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1346: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1347: RAISE FND_API.G_EXC_ERROR;
1348: END IF;
1349:
1350:
1351: -- Clear Agreement record cache

Line 1357: x_return_status := FND_API.G_RET_STS_SUCCESS;

1353: Clear_Agreement;
1354:
1355: -- Set return status.
1356:
1357: x_return_status := FND_API.G_RET_STS_SUCCESS;
1358:
1359: -- Get message count and data
1360:
1361: OE_MSG_PUB.Count_And_Get

Line 1369: WHEN FND_API.G_EXC_ERROR THEN

1365:
1366:
1367: EXCEPTION
1368:
1369: WHEN FND_API.G_EXC_ERROR THEN
1370:
1371: x_return_status := FND_API.G_RET_STS_ERROR;
1372:
1373: -- Get message count and data

Line 1371: x_return_status := FND_API.G_RET_STS_ERROR;

1367: EXCEPTION
1368:
1369: WHEN FND_API.G_EXC_ERROR THEN
1370:
1371: x_return_status := FND_API.G_RET_STS_ERROR;
1372:
1373: -- Get message count and data
1374:
1375: OE_MSG_PUB.Count_And_Get

Line 1380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1376: ( p_count => x_msg_count
1377: , p_data => x_msg_data
1378: );
1379:
1380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1381:
1382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1383:
1384: -- Get message count and data

Line 1382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1378: );
1379:
1380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1381:
1382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1383:
1384: -- Get message count and data
1385:
1386: OE_MSG_PUB.Count_And_Get

Line 1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1389: );
1390:
1391: WHEN OTHERS THEN
1392:
1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1394:
1395: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1396: THEN
1397: OE_MSG_PUB.Add_Exc_Msg

Line 1457: , p_init_msg_list => FND_API.G_TRUE

1453: -- Call OE_Pricing_Cont_PVT.Process_Pricing_Cont
1454:
1455: OE_Pricing_Cont_PVT.Process_Pricing_Cont
1456: ( p_api_version_number => 1.0
1457: , p_init_msg_list => FND_API.G_TRUE
1458: , x_return_status => l_return_status
1459: , x_msg_count => x_msg_count
1460: , x_msg_data => x_msg_data
1461: , p_control_rec => l_control_rec

Line 1472: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1468: , x_Discount_Line_tbl => l_x_Discount_Line_tbl
1469: , x_Price_Break_tbl => l_x_Price_Break_tbl
1470: );
1471:
1472: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1474: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1475: RAISE FND_API.G_EXC_ERROR;
1476: END IF;

Line 1473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1469: , x_Price_Break_tbl => l_x_Price_Break_tbl
1470: );
1471:
1472: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1474: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1475: RAISE FND_API.G_EXC_ERROR;
1476: END IF;
1477:

Line 1474: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1470: );
1471:
1472: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1474: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1475: RAISE FND_API.G_EXC_ERROR;
1476: END IF;
1477:
1478:

Line 1475: RAISE FND_API.G_EXC_ERROR;

1471:
1472: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1474: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1475: RAISE FND_API.G_EXC_ERROR;
1476: END IF;
1477:
1478:
1479: -- Set return status.

Line 1481: x_return_status := FND_API.G_RET_STS_SUCCESS;

1477:
1478:
1479: -- Set return status.
1480:
1481: x_return_status := FND_API.G_RET_STS_SUCCESS;
1482:
1483: -- Get message count and data
1484:
1485: OE_MSG_PUB.Count_And_Get

Line 1493: WHEN FND_API.G_EXC_ERROR THEN

1489:
1490:
1491: EXCEPTION
1492:
1493: WHEN FND_API.G_EXC_ERROR THEN
1494:
1495: x_return_status := FND_API.G_RET_STS_ERROR;
1496:
1497: -- Get message count and data

Line 1495: x_return_status := FND_API.G_RET_STS_ERROR;

1491: EXCEPTION
1492:
1493: WHEN FND_API.G_EXC_ERROR THEN
1494:
1495: x_return_status := FND_API.G_RET_STS_ERROR;
1496:
1497: -- Get message count and data
1498:
1499: OE_MSG_PUB.Count_And_Get

Line 1504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1500: ( p_count => x_msg_count
1501: , p_data => x_msg_data
1502: );
1503:
1504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1505:
1506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1507:
1508: -- Get message count and data

Line 1506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1502: );
1503:
1504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1505:
1506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1507:
1508: -- Get message count and data
1509:
1510: OE_MSG_PUB.Count_And_Get

Line 1517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1513: );
1514:
1515: WHEN OTHERS THEN
1516:
1517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1518:
1519: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1520: THEN
1521: OE_MSG_PUB.Add_Exc_Msg

Line 1670: , p_init_msg_list => FND_API.G_TRUE

1666: -- Call OE_Pricing_Cont_PVT.Lock_Pricing_Cont
1667:
1668: OE_Pricing_Cont_PVT.Lock_Pricing_Cont
1669: ( p_api_version_number => 1.0
1670: , p_init_msg_list => FND_API.G_TRUE
1671: , x_return_status => l_return_status
1672: , x_msg_count => x_msg_count
1673: , x_msg_data => x_msg_data
1674: , p_Agreement_rec => l_Agreement_rec

Line 1685: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1681: , x_Discount_Line_tbl => l_x_Discount_Line_tbl
1682: , x_Price_Break_tbl => l_x_Price_Break_tbl
1683: );
1684:
1685: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1686:
1687: -- Set DB flag and write record to cache.
1688:
1689: l_x_Agreement_rec.db_flag := FND_API.G_TRUE;

Line 1689: l_x_Agreement_rec.db_flag := FND_API.G_TRUE;

1685: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1686:
1687: -- Set DB flag and write record to cache.
1688:
1689: l_x_Agreement_rec.db_flag := FND_API.G_TRUE;
1690:
1691: Write_Agreement
1692: ( p_Agreement_rec => l_x_Agreement_rec
1693: , p_db_record => TRUE

Line 1722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1718: , 'Lock_Row'
1719: );
1720: END IF;
1721:
1722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1723:
1724: -- Get message count and data
1725:
1726: OE_MSG_PUB.Count_And_Get

Line 1771: g_Agreement_rec.db_flag := FND_API.G_TRUE;

1767: g_Agreement_rec := OE_Agreement_Util.Query_Row
1768: ( p_agreement_id => p_agreement_id
1769: );
1770:
1771: g_Agreement_rec.db_flag := FND_API.G_TRUE;
1772:
1773: -- Load DB record
1774:
1775: g_db_Agreement_rec := g_Agreement_rec;