APPS.OKL_CREDIT_DATAPOINTS_PVT dependencies on FND_API

Line 15: x_resultout := FND_API.G_RET_STS_SUCCESS;

11: l_credit_line_number VARCHAR2(120);
12:
13: BEGIN
14: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
15: x_resultout := FND_API.G_RET_STS_SUCCESS;
16: BEGIN
17: SELECT KHR.CONTRACT_NUMBER
18: INTO l_credit_line_number
19: FROM OKC_K_HEADERS_B KHR, OKL_LEASE_APPLICATIONS_B LAP

Line 28: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

24: EXCEPTION
25: WHEN NO_DATA_FOUND THEN
26: l_credit_line_number := NULL;
27: WHEN OTHERS THEN
28: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
29: x_errormsg := sqlerrm;
30: END;
31:
32: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

Line 49: x_resultout := FND_API.G_RET_STS_SUCCESS;

45: l_credit_line_expiration_date DATE;
46:
47: BEGIN
48: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
49: x_resultout := FND_API.G_RET_STS_SUCCESS;
50: BEGIN
51: SELECT KHR.END_DATE
52: INTO l_credit_line_expiration_date
53: FROM OKC_K_HEADERS_B KHR,

Line 63: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

59: EXCEPTION
60: WHEN NO_DATA_FOUND THEN
61: l_credit_line_expiration_date := NULL;
62: WHEN OTHERS THEN
63: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
64: x_errormsg := sqlerrm;
65: END;
66:
67: l_credit_line_expiration_date := to_date(l_credit_line_expiration_date, 'DD-MM-RRRR');

Line 86: x_resultout := FND_API.G_RET_STS_SUCCESS;

82: l_currency VARCHAR2(15);
83:
84: BEGIN
85: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
86: x_resultout := FND_API.G_RET_STS_SUCCESS;
87: BEGIN
88: SELECT CURRENCY_CODE
89: INTO l_currency
90: FROM OKL_LEASE_APPLICATIONS_B

Line 97: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

93: EXCEPTION
94: WHEN NO_DATA_FOUND THEN
95: l_currency := NULL;
96: WHEN OTHERS THEN
97: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
98: x_errormsg := sqlerrm;
99: END;
100:
101: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

Line 118: x_resultout := FND_API.G_RET_STS_SUCCESS;

114: l_sales_rep VARCHAR2(30);
115:
116: BEGIN
117: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
118: x_resultout := FND_API.G_RET_STS_SUCCESS;
119: BEGIN
120: SELECT REP.SALESREP_NUMBER
121: INTO l_sales_rep
122: FROM JTF_RS_SALESREPS REP,

Line 132: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

128: EXCEPTION
129: WHEN NO_DATA_FOUND THEN
130: l_sales_rep := NULL;
131: WHEN OTHERS THEN
132: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
133: x_errormsg := sqlerrm;
134: END;
135:
136: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

Line 153: x_resultout := FND_API.G_RET_STS_SUCCESS;

149: l_program_vendor VARCHAR2(30);
150:
151: BEGIN
152: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
153: x_resultout := FND_API.G_RET_STS_SUCCESS;
154: BEGIN
155: SELECT PO.SEGMENT1
156: INTO l_program_vendor
157: FROM OKL_LEASE_APPLICATIONS_B LAP, OKC_K_HEADERS_B CHR,

Line 169: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

165: EXCEPTION
166: WHEN NO_DATA_FOUND THEN
167: l_program_vendor := NULL;
168: WHEN OTHERS THEN
169: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
170: x_errormsg := sqlerrm;
171: END;
172:
173: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

Line 190: x_resultout := FND_API.G_RET_STS_SUCCESS;

186: l_program_agreement_number VARCHAR2(120);
187:
188: BEGIN
189: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
190: x_resultout := FND_API.G_RET_STS_SUCCESS;
191: BEGIN
192: SELECT KHR.CONTRACT_NUMBER
193: INTO l_program_agreement_number
194: FROM OKC_K_HEADERS_B KHR, OKL_LEASE_APPLICATIONS_B LAP

Line 203: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

199: EXCEPTION
200: WHEN NO_DATA_FOUND THEN
201: l_program_agreement_number := NULL;
202: WHEN OTHERS THEN
203: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
204: x_errormsg := sqlerrm;
205: END;
206:
207: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

Line 224: x_resultout := FND_API.G_RET_STS_SUCCESS;

220: l_expected_start_date DATE;
221:
222: BEGIN
223: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
224: x_resultout := FND_API.G_RET_STS_SUCCESS;
225: BEGIN
226: SELECT QUOTE.EXPECTED_START_DATE
227: INTO l_expected_start_date
228: FROM OKL_LEASE_QUOTES_B QUOTE,

Line 239: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

235: EXCEPTION
236: WHEN NO_DATA_FOUND THEN
237: l_expected_start_date := NULL;
238: WHEN OTHERS THEN
239: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
240: x_errormsg := sqlerrm;
241: END;
242:
243: l_expected_start_date := to_date(l_expected_start_date, 'DD-MM-RRRR');

Line 262: x_resultout := FND_API.G_RET_STS_SUCCESS;

258: l_expected_delivery_date DATE;
259:
260: BEGIN
261: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
262: x_resultout := FND_API.G_RET_STS_SUCCESS;
263: BEGIN
264: SELECT QUOTE.EXPECTED_DELIVERY_DATE
265: INTO l_expected_delivery_date
266: FROM OKL_LEASE_QUOTES_B QUOTE, OKL_LEASE_APPLICATIONS_B LAP

Line 276: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

272: EXCEPTION
273: WHEN NO_DATA_FOUND THEN
274: l_expected_delivery_date := NULL;
275: WHEN OTHERS THEN
276: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
277: x_errormsg := sqlerrm;
278: END;
279:
280: l_expected_delivery_date := to_date(l_expected_delivery_date, 'DD-MM-RRRR');

Line 299: x_resultout := FND_API.G_RET_STS_SUCCESS;

295: l_expected_funding_date DATE;
296:
297: BEGIN
298: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
299: x_resultout := FND_API.G_RET_STS_SUCCESS;
300: BEGIN
301: SELECT QUOTE.EXPECTED_FUNDING_DATE
302: INTO l_expected_funding_date
303: FROM OKL_LEASE_QUOTES_B QUOTE, OKL_LEASE_APPLICATIONS_B LAP

Line 313: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

309: EXCEPTION
310: WHEN NO_DATA_FOUND THEN
311: l_expected_funding_date := NULL;
312: WHEN OTHERS THEN
313: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
314: x_errormsg := sqlerrm;
315: END;
316:
317: l_expected_funding_date := to_date(l_expected_funding_date, 'DD-MM-RRRR');

Line 336: x_resultout := FND_API.G_RET_STS_SUCCESS;

332: l_lease_application_template VARCHAR2(150);
333:
334: BEGIN
335: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
336: x_resultout := FND_API.G_RET_STS_SUCCESS;
337: BEGIN
338: SELECT TEMPLATES.NAME
339: INTO l_lease_application_template
340: FROM OKL_LEASEAPP_TEMPLATES TEMPLATES, OKL_LEASE_APPLICATIONS_B LAP

Line 348: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

344: EXCEPTION
345: WHEN NO_DATA_FOUND THEN
346: l_lease_application_template := NULL;
347: WHEN OTHERS THEN
348: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
349: x_errormsg := sqlerrm;
350: END;
351:
352: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

Line 369: x_resultout := FND_API.G_RET_STS_SUCCESS;

365: l_org_unit VARCHAR2(240);
366:
367: BEGIN
368: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
369: x_resultout := FND_API.G_RET_STS_SUCCESS;
370: BEGIN
371: SELECT ORG.NAME
372: INTO l_org_unit
373: FROM HR_ALL_ORGANIZATION_UNITS ORG, OKL_LEASE_APPLICATIONS_B LAP

Line 381: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

377: EXCEPTION
378: WHEN NO_DATA_FOUND THEN
379: l_org_unit := NULL;
380: WHEN OTHERS THEN
381: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
382: x_errormsg := sqlerrm;
383: END;
384:
385: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

Line 402: x_resultout := FND_API.G_RET_STS_SUCCESS;

398: l_prospect_address VARCHAR2(30);
399:
400: BEGIN
401: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
402: x_resultout := FND_API.G_RET_STS_SUCCESS;
403: BEGIN
404: SELECT PARTY_SITES.PARTY_SITE_NUMBER
405: INTO l_prospect_address
406: FROM HZ_PARTY_SITES PARTY_SITES, OKL_LEASE_APPLICATIONS_B LAP

Line 414: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

410: EXCEPTION
411: WHEN NO_DATA_FOUND THEN
412: l_prospect_address := NULL;
413: WHEN OTHERS THEN
414: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
415: x_errormsg := sqlerrm;
416: END;
417:
418: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

Line 435: x_resultout := FND_API.G_RET_STS_SUCCESS;

431: l_term_of_deal NUMBER;
432:
433: BEGIN
434: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
435: x_resultout := FND_API.G_RET_STS_SUCCESS;
436: BEGIN
437: SELECT QUOTE.TERM
438: INTO l_term_of_deal
439: FROM OKL_LEASE_QUOTES_B QUOTE, OKL_LEASE_APPLICATIONS_B LAP

Line 449: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

445: EXCEPTION
446: WHEN NO_DATA_FOUND THEN
447: l_term_of_deal := NULL;
448: WHEN OTHERS THEN
449: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
450: x_errormsg := sqlerrm;
451: END;
452:
453: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

Line 470: x_resultout := FND_API.G_RET_STS_SUCCESS;

466: l_financial_product VARCHAR2(150);
467:
468: BEGIN
469: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
470: x_resultout := FND_API.G_RET_STS_SUCCESS;
471: BEGIN
472: SELECT PRODUCT.NAME
473: INTO l_financial_product
474: FROM OKL_PRODUCTS PRODUCT, OKL_LEASE_APPLICATIONS_B LAP, OKL_LEASE_QUOTES_B QUOTE

Line 486: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

482: EXCEPTION
483: WHEN NO_DATA_FOUND THEN
484: l_financial_product := NULL;
485: WHEN OTHERS THEN
486: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
487: x_errormsg := sqlerrm;
488: END;
489:
490: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

Line 527: x_resultout := FND_API.G_RET_STS_SUCCESS;

523:
524: ln_seq_number NUMBER :=1;
525: BEGIN
526: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
527: x_resultout := FND_API.G_RET_STS_SUCCESS;
528: BEGIN
529:
530: x_resultout := FND_API.G_RET_STS_SUCCESS;
531:

Line 530: x_resultout := FND_API.G_RET_STS_SUCCESS;

526: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
527: x_resultout := FND_API.G_RET_STS_SUCCESS;
528: BEGIN
529:
530: x_resultout := FND_API.G_RET_STS_SUCCESS;
531:
532: FOR cItemRec IN cItem LOOP
533: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
534: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

Line 551: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

547: EXCEPTION
548: WHEN NO_DATA_FOUND THEN
549: l_item := NULL;
550: WHEN OTHERS THEN
551: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
552: x_errormsg := sqlerrm;
553: END;
554: END item;
555:

Line 584: x_resultout := FND_API.G_RET_STS_SUCCESS;

580: ln_seq_number NUMBER :=1;
581:
582: BEGIN
583: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
584: x_resultout := FND_API.G_RET_STS_SUCCESS;
585: BEGIN
586:
587: x_resultout := FND_API.G_RET_STS_SUCCESS;
588:

Line 587: x_resultout := FND_API.G_RET_STS_SUCCESS;

583: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
584: x_resultout := FND_API.G_RET_STS_SUCCESS;
585: BEGIN
586:
587: x_resultout := FND_API.G_RET_STS_SUCCESS;
588:
589: FOR cItemDescRec IN cItemDesc LOOP
590: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
591: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

Line 607: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

603: EXCEPTION
604: WHEN NO_DATA_FOUND THEN
605: l_item_description := NULL;
606: WHEN OTHERS THEN
607: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
608: x_errormsg := sqlerrm;
609: END;
610: END item_description ;
611:

Line 641: x_resultout := FND_API.G_RET_STS_SUCCESS;

637:
638: ln_seq_number NUMBER :=1;
639: BEGIN
640: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
641: x_resultout := FND_API.G_RET_STS_SUCCESS;
642: BEGIN
643:
644: x_resultout := FND_API.G_RET_STS_SUCCESS;
645:

Line 644: x_resultout := FND_API.G_RET_STS_SUCCESS;

640: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
641: x_resultout := FND_API.G_RET_STS_SUCCESS;
642: BEGIN
643:
644: x_resultout := FND_API.G_RET_STS_SUCCESS;
645:
646: FOR cItemSuppRec IN cItemSupp LOOP
647: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
648: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

Line 664: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

660: EXCEPTION
661: WHEN NO_DATA_FOUND THEN
662: l_item_supplier := NULL;
663: WHEN OTHERS THEN
664: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
665: x_errormsg := sqlerrm;
666: END;
667: END item_supplier ;
668:

Line 695: x_resultout := FND_API.G_RET_STS_SUCCESS;

691: ln_seq_number NUMBER :=1;
692:
693: BEGIN
694: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
695: x_resultout := FND_API.G_RET_STS_SUCCESS;
696: BEGIN
697:
698: x_resultout := FND_API.G_RET_STS_SUCCESS;
699:

Line 698: x_resultout := FND_API.G_RET_STS_SUCCESS;

694: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
695: x_resultout := FND_API.G_RET_STS_SUCCESS;
696: BEGIN
697:
698: x_resultout := FND_API.G_RET_STS_SUCCESS;
699:
700: FOR cModelNumRec IN cModelNum LOOP
701: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
702: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

Line 718: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

714: EXCEPTION
715: WHEN NO_DATA_FOUND THEN
716: l_model := NULL;
717: WHEN OTHERS THEN
718: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
719: x_errormsg := sqlerrm;
720: END;
721: END model ;
722:

Line 749: x_resultout := FND_API.G_RET_STS_SUCCESS;

745: ln_seq_number NUMBER :=1;
746:
747: BEGIN
748: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
749: x_resultout := FND_API.G_RET_STS_SUCCESS;
750: BEGIN
751:
752: x_resultout := FND_API.G_RET_STS_SUCCESS;
753:

Line 752: x_resultout := FND_API.G_RET_STS_SUCCESS;

748: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
749: x_resultout := FND_API.G_RET_STS_SUCCESS;
750: BEGIN
751:
752: x_resultout := FND_API.G_RET_STS_SUCCESS;
753:
754: FOR cMfgNameRec IN cMfgName LOOP
755: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
756: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

Line 772: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

768: EXCEPTION
769: WHEN NO_DATA_FOUND THEN
770: l_manufacturer := NULL;
771: WHEN OTHERS THEN
772: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
773: x_errormsg := sqlerrm;
774: END;
775: END manufacturer;
776:

Line 803: x_resultout := FND_API.G_RET_STS_SUCCESS;

799: ln_seq_number NUMBER :=1;
800:
801: BEGIN
802: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
803: x_resultout := FND_API.G_RET_STS_SUCCESS;
804: BEGIN
805: x_resultout := FND_API.G_RET_STS_SUCCESS;
806:
807: FOR cYearMfgRec IN cYearMfg LOOP

Line 805: x_resultout := FND_API.G_RET_STS_SUCCESS;

801: BEGIN
802: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
803: x_resultout := FND_API.G_RET_STS_SUCCESS;
804: BEGIN
805: x_resultout := FND_API.G_RET_STS_SUCCESS;
806:
807: FOR cYearMfgRec IN cYearMfg LOOP
808: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
809: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

Line 825: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

821: EXCEPTION
822: WHEN NO_DATA_FOUND THEN
823: l_year_of_manufacture := NULL;
824: WHEN OTHERS THEN
825: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
826: x_errormsg := sqlerrm;
827: END;
828: END year_of_manufacture ;
829:

Line 855: x_resultout := FND_API.G_RET_STS_SUCCESS;

851:
852: ln_seq_number NUMBER :=1;
853: BEGIN
854: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
855: x_resultout := FND_API.G_RET_STS_SUCCESS;
856: BEGIN
857: x_resultout := FND_API.G_RET_STS_SUCCESS;
858:
859: FOR cNoOfUnitsRec IN cNoOfUnits LOOP

Line 857: x_resultout := FND_API.G_RET_STS_SUCCESS;

853: BEGIN
854: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
855: x_resultout := FND_API.G_RET_STS_SUCCESS;
856: BEGIN
857: x_resultout := FND_API.G_RET_STS_SUCCESS;
858:
859: FOR cNoOfUnitsRec IN cNoOfUnits LOOP
860: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
861: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

Line 877: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

873: EXCEPTION
874: WHEN NO_DATA_FOUND THEN
875: l_no_of_units := NULL;
876: WHEN OTHERS THEN
877: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
878: x_errormsg := sqlerrm;
879: END;
880: END no_of_units ;
881:

Line 909: x_resultout := FND_API.G_RET_STS_SUCCESS;

905:
906:
907: BEGIN
908: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
909: x_resultout := FND_API.G_RET_STS_SUCCESS;
910: BEGIN
911: x_resultout := FND_API.G_RET_STS_SUCCESS;
912:
913: FOR cUnitCostRec IN cUnitCost LOOP

Line 911: x_resultout := FND_API.G_RET_STS_SUCCESS;

907: BEGIN
908: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
909: x_resultout := FND_API.G_RET_STS_SUCCESS;
910: BEGIN
911: x_resultout := FND_API.G_RET_STS_SUCCESS;
912:
913: FOR cUnitCostRec IN cUnitCost LOOP
914: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
915: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

Line 931: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

927: EXCEPTION
928: WHEN NO_DATA_FOUND THEN
929: l_unit_cost := NULL;
930: WHEN OTHERS THEN
931: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
932: x_errormsg := sqlerrm;
933: END;
934: END unit_cost ;
935:

Line 961: x_resultout := FND_API.G_RET_STS_SUCCESS;

957: ln_seq_number NUMBER :=1;
958:
959: BEGIN
960: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
961: x_resultout := FND_API.G_RET_STS_SUCCESS;
962: BEGIN
963: x_resultout := FND_API.G_RET_STS_SUCCESS;
964:
965: FOR cInstallSiteRec IN cInstallSite LOOP

Line 963: x_resultout := FND_API.G_RET_STS_SUCCESS;

959: BEGIN
960: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
961: x_resultout := FND_API.G_RET_STS_SUCCESS;
962: BEGIN
963: x_resultout := FND_API.G_RET_STS_SUCCESS;
964:
965: FOR cInstallSiteRec IN cInstallSite LOOP
966: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
967: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

Line 983: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

979: EXCEPTION
980: WHEN NO_DATA_FOUND THEN
981: l_install_site := NULL;
982: WHEN OTHERS THEN
983: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
984: x_errormsg := sqlerrm;
985: END;
986: END install_site ;
987:

Line 999: x_resultout := FND_API.G_RET_STS_SUCCESS;

995: l_usage_of_equipment VARCHAR2(30);
996:
997: BEGIN
998: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
999: x_resultout := FND_API.G_RET_STS_SUCCESS;
1000: BEGIN
1001: -- gboomina Bug 7110500 - Start
1002: SELECT QUOTE.USAGE_CATEGORY --QUOTE.USAGE_INDUSTRY_CLASS
1003: INTO l_usage_of_equipment

Line 1016: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

1012: EXCEPTION
1013: WHEN NO_DATA_FOUND THEN
1014: l_usage_of_equipment := NULL;
1015: WHEN OTHERS THEN
1016: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1017: x_errormsg := sqlerrm;
1018: END;
1019:
1020: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

Line 1037: x_resultout := FND_API.G_RET_STS_SUCCESS;

1033: l_usage_industry VARCHAR2(1995);
1034:
1035: BEGIN
1036: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1037: x_resultout := FND_API.G_RET_STS_SUCCESS;
1038: BEGIN
1039: -- gboomina Bug 7110500 - Start
1040: /*
1041: SELECT QUOTE.USAGE_INDUSTRY_CODE

Line 1065: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

1061: EXCEPTION
1062: WHEN NO_DATA_FOUND THEN
1063: l_usage_industry := NULL;
1064: WHEN OTHERS THEN
1065: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1066: x_errormsg := sqlerrm;
1067: END;
1068:
1069: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

Line 1086: x_resultout := FND_API.G_RET_STS_SUCCESS;

1082: l_usage_category VARCHAR2(30);
1083:
1084: BEGIN
1085: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1086: x_resultout := FND_API.G_RET_STS_SUCCESS;
1087: BEGIN
1088: SELECT QUOTE.USAGE_CATEGORY
1089: INTO l_usage_category
1090: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_LEASE_QUOTES_B QUOTE

Line 1101: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

1097: EXCEPTION
1098: WHEN NO_DATA_FOUND THEN
1099: l_usage_category := NULL;
1100: WHEN OTHERS THEN
1101: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1102: x_errormsg := sqlerrm;
1103: END;
1104:
1105: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

Line 1122: x_resultout := FND_API.G_RET_STS_SUCCESS;

1118: l_usage_amount NUMBER;
1119:
1120: BEGIN
1121: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1122: x_resultout := FND_API.G_RET_STS_SUCCESS;
1123: BEGIN
1124: -- gboomina Bug 7110500 - Start
1125: /*
1126: SELECT QUOTE.USAGE_AMOUNT

Line 1146: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

1142: EXCEPTION
1143: WHEN NO_DATA_FOUND THEN
1144: l_usage_amount := NULL;
1145: WHEN OTHERS THEN
1146: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1147: x_errormsg := sqlerrm;
1148: END;
1149:
1150: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

Line 1178: x_resultout := FND_API.G_RET_STS_SUCCESS;

1174:
1175: ln_seq_number NUMBER :=1;
1176: BEGIN
1177: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1178: x_resultout := FND_API.G_RET_STS_SUCCESS;
1179: BEGIN
1180: x_resultout := FND_API.G_RET_STS_SUCCESS;
1181:
1182: FOR cAddOnItemRec IN cAddOnItem LOOP

Line 1180: x_resultout := FND_API.G_RET_STS_SUCCESS;

1176: BEGIN
1177: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1178: x_resultout := FND_API.G_RET_STS_SUCCESS;
1179: BEGIN
1180: x_resultout := FND_API.G_RET_STS_SUCCESS;
1181:
1182: FOR cAddOnItemRec IN cAddOnItem LOOP
1183: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1184: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

Line 1199: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

1195: EXCEPTION
1196: WHEN NO_DATA_FOUND THEN
1197: l_add_on_item := NULL;
1198: WHEN OTHERS THEN
1199: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1200: x_errormsg := sqlerrm;
1201: END;
1202: END add_on_item ;
1203:

Line 1226: x_resultout := FND_API.G_RET_STS_SUCCESS;

1222:
1223: ln_seq_number NUMBER :=1;
1224: BEGIN
1225: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1226: x_resultout := FND_API.G_RET_STS_SUCCESS;
1227: BEGIN
1228:
1229: x_resultout := FND_API.G_RET_STS_SUCCESS;
1230:

Line 1229: x_resultout := FND_API.G_RET_STS_SUCCESS;

1225: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1226: x_resultout := FND_API.G_RET_STS_SUCCESS;
1227: BEGIN
1228:
1229: x_resultout := FND_API.G_RET_STS_SUCCESS;
1230:
1231: FOR cItemDescriptionRec IN cItemDescription LOOP
1232: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1233: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

Line 1249: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

1245: EXCEPTION
1246: WHEN NO_DATA_FOUND THEN
1247: l_add_on_item_description := NULL;
1248: WHEN OTHERS THEN
1249: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1250: x_errormsg := sqlerrm;
1251: END;
1252: END add_on_item_description ;
1253:

Line 1275: x_resultout := FND_API.G_RET_STS_SUCCESS;

1271:
1272: ln_seq_number NUMBER :=1;
1273: BEGIN
1274: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1275: x_resultout := FND_API.G_RET_STS_SUCCESS;
1276: BEGIN
1277: x_resultout := FND_API.G_RET_STS_SUCCESS;
1278:
1279: FOR cItemSupplierRec IN cItemSupplier LOOP

Line 1277: x_resultout := FND_API.G_RET_STS_SUCCESS;

1273: BEGIN
1274: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1275: x_resultout := FND_API.G_RET_STS_SUCCESS;
1276: BEGIN
1277: x_resultout := FND_API.G_RET_STS_SUCCESS;
1278:
1279: FOR cItemSupplierRec IN cItemSupplier LOOP
1280: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1281: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

Line 1297: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

1293: EXCEPTION
1294: WHEN NO_DATA_FOUND THEN
1295: l_add_on_item_supplier := NULL;
1296: WHEN OTHERS THEN
1297: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1298: x_errormsg := sqlerrm;
1299: END;
1300: END add_on_item_supplier ;
1301:

Line 1323: x_resultout := FND_API.G_RET_STS_SUCCESS;

1319: ln_seq_number NUMBER :=1;
1320:
1321: BEGIN
1322: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1323: x_resultout := FND_API.G_RET_STS_SUCCESS;
1324: BEGIN
1325:
1326: x_resultout := FND_API.G_RET_STS_SUCCESS;
1327:

Line 1326: x_resultout := FND_API.G_RET_STS_SUCCESS;

1322: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1323: x_resultout := FND_API.G_RET_STS_SUCCESS;
1324: BEGIN
1325:
1326: x_resultout := FND_API.G_RET_STS_SUCCESS;
1327:
1328: FOR cItemModelRec IN cItemModel LOOP
1329: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1330: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

Line 1345: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

1341: EXCEPTION
1342: WHEN NO_DATA_FOUND THEN
1343: l_add_on_item_model := NULL;
1344: WHEN OTHERS THEN
1345: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1346: x_errormsg := sqlerrm;
1347: END;
1348: END add_on_item_model ;
1349:

Line 1370: x_resultout := FND_API.G_RET_STS_SUCCESS;

1366:
1367: ln_seq_number NUMBER :=1;
1368: BEGIN
1369: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1370: x_resultout := FND_API.G_RET_STS_SUCCESS;
1371: BEGIN
1372:
1373: x_resultout := FND_API.G_RET_STS_SUCCESS;
1374:

Line 1373: x_resultout := FND_API.G_RET_STS_SUCCESS;

1369: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1370: x_resultout := FND_API.G_RET_STS_SUCCESS;
1371: BEGIN
1372:
1373: x_resultout := FND_API.G_RET_STS_SUCCESS;
1374:
1375: FOR cItemMfgRec IN cItemMfg LOOP
1376: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1377: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

Line 1393: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

1389: EXCEPTION
1390: WHEN NO_DATA_FOUND THEN
1391: l_add_on_item_manufacturer := NULL;
1392: WHEN OTHERS THEN
1393: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1394: x_errormsg := sqlerrm;
1395: END;
1396: END add_on_item_manufacturer ;
1397:

Line 1418: x_resultout := FND_API.G_RET_STS_SUCCESS;

1414:
1415: ln_seq_number NUMBER :=1;
1416: BEGIN
1417: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1418: x_resultout := FND_API.G_RET_STS_SUCCESS;
1419: BEGIN
1420:
1421: x_resultout := FND_API.G_RET_STS_SUCCESS;
1422:

Line 1421: x_resultout := FND_API.G_RET_STS_SUCCESS;

1417: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1418: x_resultout := FND_API.G_RET_STS_SUCCESS;
1419: BEGIN
1420:
1421: x_resultout := FND_API.G_RET_STS_SUCCESS;
1422:
1423: FOR cAddOnItemAmountRec IN cAddOnItemAmount LOOP
1424: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1425: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

Line 1440: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

1436: EXCEPTION
1437: WHEN NO_DATA_FOUND THEN
1438: l_add_on_item_amount := NULL;
1439: WHEN OTHERS THEN
1440: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1441: x_errormsg := sqlerrm;
1442: END;
1443: END add_on_item_amount ;
1444:

Line 1467: x_resultout := FND_API.G_RET_STS_SUCCESS;

1463:
1464: ln_seq_number NUMBER :=1;
1465: BEGIN
1466: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1467: x_resultout := FND_API.G_RET_STS_SUCCESS;
1468: BEGIN
1469:
1470: x_resultout := FND_API.G_RET_STS_SUCCESS;
1471:

Line 1470: x_resultout := FND_API.G_RET_STS_SUCCESS;

1466: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1467: x_resultout := FND_API.G_RET_STS_SUCCESS;
1468: BEGIN
1469:
1470: x_resultout := FND_API.G_RET_STS_SUCCESS;
1471:
1472: FOR cItemResValRec IN cItemResVal LOOP
1473: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
1474: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

Line 1490: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

1486: EXCEPTION
1487: WHEN NO_DATA_FOUND THEN
1488: l_add_on_item_residual_values := NULL;
1489: WHEN OTHERS THEN
1490: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1491: x_errormsg := sqlerrm;
1492: END;
1493: END asset_residual_value ;
1494:

Line 1506: x_resultout := FND_API.G_RET_STS_SUCCESS;

1502: l_down_payment_amount NUMBER;
1503:
1504: BEGIN
1505: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1506: x_resultout := FND_API.G_RET_STS_SUCCESS;
1507: BEGIN
1508: SELECT NVL(SUM(ADJ.VALUE), 0)
1509: INTO l_down_payment_amount
1510: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,

Line 1526: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

1522: EXCEPTION
1523: WHEN NO_DATA_FOUND THEN
1524: l_down_payment_amount := NULL;
1525: WHEN OTHERS THEN
1526: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1527: x_errormsg := sqlerrm;
1528: END;
1529:
1530: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

Line 1546: x_resultout := FND_API.G_RET_STS_SUCCESS;

1542: l_subsidy_amount NUMBER;
1543:
1544: BEGIN
1545: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1546: x_resultout := FND_API.G_RET_STS_SUCCESS;
1547: BEGIN
1548: SELECT SUM(DECODE(ADJ.VALUE, NULL, ADJ.DEFAULT_SUBSIDY_AMOUNT, ADJ.VALUE)) SUBSIDY_AMOUNT
1549: INTO l_subsidy_amount
1550: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,

Line 1566: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

1562: EXCEPTION
1563: WHEN NO_DATA_FOUND THEN
1564: l_subsidy_amount := NULL;
1565: WHEN OTHERS THEN
1566: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1567: x_errormsg := sqlerrm;
1568: END;
1569:
1570: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

Line 1587: x_resultout := FND_API.G_RET_STS_SUCCESS;

1583: l_trade_in_amount NUMBER;
1584:
1585: BEGIN
1586: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1587: x_resultout := FND_API.G_RET_STS_SUCCESS;
1588: BEGIN
1589: SELECT NVL(SUM(ADJ.VALUE), 0)
1590: INTO l_trade_in_amount
1591: FROM OKL_LEASE_APPLICATIONS_B LAP, OKL_ASSETS_B ASSET,

Line 1607: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

1603: EXCEPTION
1604: WHEN NO_DATA_FOUND THEN
1605: l_trade_in_amount := NULL;
1606: WHEN OTHERS THEN
1607: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1608: x_errormsg := sqlerrm;
1609: END;
1610:
1611: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

Line 1643: x_resultout := FND_API.G_RET_STS_SUCCESS;

1639:
1640: ln_seq_number NUMBER :=1;
1641: BEGIN
1642: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1643: x_resultout := FND_API.G_RET_STS_SUCCESS;
1644: BEGIN
1645: x_resultout := FND_API.G_RET_STS_SUCCESS;
1646:
1647: FOR cAssetNumberRec IN cAssetNumber

Line 1645: x_resultout := FND_API.G_RET_STS_SUCCESS;

1641: BEGIN
1642: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1643: x_resultout := FND_API.G_RET_STS_SUCCESS;
1644: BEGIN
1645: x_resultout := FND_API.G_RET_STS_SUCCESS;
1646:
1647: FOR cAssetNumberRec IN cAssetNumber
1648: LOOP
1649: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

Line 1666: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

1662: EXCEPTION
1663: WHEN NO_DATA_FOUND THEN
1664: l_trade_in_asset_number := NULL;
1665: WHEN OTHERS THEN
1666: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1667: x_errormsg := sqlerrm;
1668: END;
1669:
1670: END trade_in_asset_number ;

Line 1744: x_resultout := FND_API.G_RET_STS_SUCCESS;

1740:
1741: ln_seq_number NUMBER :=1;
1742: BEGIN
1743: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1744: x_resultout := FND_API.G_RET_STS_SUCCESS;
1745: BEGIN
1746: x_resultout := FND_API.G_RET_STS_SUCCESS;
1747:
1748: FOR cPmntFreqRec IN cPmntFreq

Line 1746: x_resultout := FND_API.G_RET_STS_SUCCESS;

1742: BEGIN
1743: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1744: x_resultout := FND_API.G_RET_STS_SUCCESS;
1745: BEGIN
1746: x_resultout := FND_API.G_RET_STS_SUCCESS;
1747:
1748: FOR cPmntFreqRec IN cPmntFreq
1749: LOOP
1750: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

Line 1766: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

1762: EXCEPTION
1763: WHEN NO_DATA_FOUND THEN
1764: l_pmnt_frequency := NULL;
1765: WHEN OTHERS THEN
1766: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1767: x_errormsg := sqlerrm;
1768: END;
1769: END pmnt_frequency ;
1770:

Line 1840: x_resultout := FND_API.G_RET_STS_SUCCESS;

1836:
1837: ln_seq_number NUMBER :=1;
1838: BEGIN
1839: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1840: x_resultout := FND_API.G_RET_STS_SUCCESS;
1841: BEGIN
1842:
1843: x_resultout := FND_API.G_RET_STS_SUCCESS;
1844:

Line 1843: x_resultout := FND_API.G_RET_STS_SUCCESS;

1839: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1840: x_resultout := FND_API.G_RET_STS_SUCCESS;
1841: BEGIN
1842:
1843: x_resultout := FND_API.G_RET_STS_SUCCESS;
1844:
1845: FOR cPmntArrYNRec IN cPmntArrYN
1846: LOOP
1847: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

Line 1863: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

1859: EXCEPTION
1860: WHEN NO_DATA_FOUND THEN
1861: l_pmnt_arrears_yn := NULL;
1862: WHEN OTHERS THEN
1863: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1864: x_errormsg := sqlerrm;
1865: END;
1866: END pmnt_arrears_yn ;
1867:

Line 1937: x_resultout := FND_API.G_RET_STS_SUCCESS;

1933:
1934: ln_seq_number NUMBER :=1;
1935: BEGIN
1936: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1937: x_resultout := FND_API.G_RET_STS_SUCCESS;
1938: BEGIN
1939: x_resultout := FND_API.G_RET_STS_SUCCESS;
1940:
1941: FOR cPmntPeriodsRec IN cPmntPeriods

Line 1939: x_resultout := FND_API.G_RET_STS_SUCCESS;

1935: BEGIN
1936: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
1937: x_resultout := FND_API.G_RET_STS_SUCCESS;
1938: BEGIN
1939: x_resultout := FND_API.G_RET_STS_SUCCESS;
1940:
1941: FOR cPmntPeriodsRec IN cPmntPeriods
1942: LOOP
1943: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

Line 1959: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

1955: EXCEPTION
1956: WHEN NO_DATA_FOUND THEN
1957: l_pmnt_periods := NULL;
1958: WHEN OTHERS THEN
1959: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1960: x_errormsg := sqlerrm;
1961: END;
1962: END pmnt_periods ;
1963:

Line 2033: x_resultout := FND_API.G_RET_STS_SUCCESS;

2029:
2030: ln_seq_number NUMBER :=1;
2031: BEGIN
2032: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2033: x_resultout := FND_API.G_RET_STS_SUCCESS;
2034: BEGIN
2035: x_resultout := FND_API.G_RET_STS_SUCCESS;
2036:
2037: FOR cPmntAmountRec IN cPmntAmount

Line 2035: x_resultout := FND_API.G_RET_STS_SUCCESS;

2031: BEGIN
2032: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2033: x_resultout := FND_API.G_RET_STS_SUCCESS;
2034: BEGIN
2035: x_resultout := FND_API.G_RET_STS_SUCCESS;
2036:
2037: FOR cPmntAmountRec IN cPmntAmount
2038: LOOP
2039: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

Line 2056: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

2052: EXCEPTION
2053: WHEN NO_DATA_FOUND THEN
2054: l_pmnt_amounts := NULL;
2055: WHEN OTHERS THEN
2056: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
2057: x_errormsg := sqlerrm;
2058: END;
2059: END pmnt_amounts ;
2060:

Line 2129: x_resultout := FND_API.G_RET_STS_SUCCESS;

2125:
2126: ln_seq_number NUMBER :=1;
2127: BEGIN
2128: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2129: x_resultout := FND_API.G_RET_STS_SUCCESS;
2130: BEGIN
2131:
2132: x_resultout := FND_API.G_RET_STS_SUCCESS;
2133:

Line 2132: x_resultout := FND_API.G_RET_STS_SUCCESS;

2128: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2129: x_resultout := FND_API.G_RET_STS_SUCCESS;
2130: BEGIN
2131:
2132: x_resultout := FND_API.G_RET_STS_SUCCESS;
2133:
2134: FOR cPmntStartDateRec IN cPmntStartDate
2135: LOOP
2136: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

Line 2152: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

2148: EXCEPTION
2149: WHEN NO_DATA_FOUND THEN
2150: l_pmnt_start_date := NULL;
2151: WHEN OTHERS THEN
2152: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
2153: x_errormsg := sqlerrm;
2154: END;
2155: END pmnt_start_date ;
2156:

Line 2171: x_resultout := FND_API.G_RET_STS_SUCCESS;

2167:
2168: ln_seq_number NUMBER :=1;
2169: BEGIN
2170: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2171: x_resultout := FND_API.G_RET_STS_SUCCESS;
2172: BEGIN
2173:
2174: x_resultout := FND_API.G_RET_STS_SUCCESS;
2175:

Line 2174: x_resultout := FND_API.G_RET_STS_SUCCESS;

2170: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2171: x_resultout := FND_API.G_RET_STS_SUCCESS;
2172: BEGIN
2173:
2174: x_resultout := FND_API.G_RET_STS_SUCCESS;
2175:
2176: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2177: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;
2178: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_parent_data_point_id := l_asset_id;

Line 2190: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

2186: EXCEPTION
2187: WHEN NO_DATA_FOUND THEN
2188: l_payment_structure := NULL;
2189: WHEN OTHERS THEN
2190: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
2191: x_errormsg := sqlerrm;
2192: END;
2193: END payment_structure ;
2194:

Line 2367: x_resultout := FND_API.G_RET_STS_SUCCESS;

2363: l_term NUMBER;
2364: l_return_status VARCHAR2(1);
2365: BEGIN
2366: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2367: x_resultout := FND_API.G_RET_STS_SUCCESS;
2368: BEGIN
2369: x_resultout := FND_API.G_RET_STS_SUCCESS;
2370:
2371: -- Fetch the frequency code, term

Line 2369: x_resultout := FND_API.G_RET_STS_SUCCESS;

2365: BEGIN
2366: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2367: x_resultout := FND_API.G_RET_STS_SUCCESS;
2368: BEGIN
2369: x_resultout := FND_API.G_RET_STS_SUCCESS;
2370:
2371: -- Fetch the frequency code, term
2372: OPEN c_get_info;
2373: FETCH c_get_info INTO l_freq_code, l_term;

Line 2424: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

2420:
2421: WHEN NO_DATA_FOUND THEN
2422: l_pmnt_end_date := NULL;
2423: WHEN OTHERS THEN
2424: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
2425: x_errormsg := sqlerrm;
2426: END;
2427: END pmnt_end_date ;
2428:

Line 2468: x_resultout := FND_API.G_RET_STS_SUCCESS;

2464: ln_seq_number NUMBER :=1;
2465:
2466: BEGIN
2467: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2468: x_resultout := FND_API.G_RET_STS_SUCCESS;
2469: BEGIN
2470: x_resultout := FND_API.G_RET_STS_SUCCESS;
2471:
2472: FOR cFeeNameRec IN cFeeName LOOP

Line 2470: x_resultout := FND_API.G_RET_STS_SUCCESS;

2466: BEGIN
2467: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2468: x_resultout := FND_API.G_RET_STS_SUCCESS;
2469: BEGIN
2470: x_resultout := FND_API.G_RET_STS_SUCCESS;
2471:
2472: FOR cFeeNameRec IN cFeeName LOOP
2473: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2474: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

Line 2490: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

2486: EXCEPTION
2487: WHEN NO_DATA_FOUND THEN
2488: l_fee_name := NULL;
2489: WHEN OTHERS THEN
2490: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
2491: x_errormsg := sqlerrm;
2492: END;
2493: END fee_name ;
2494:

Line 2520: x_resultout := FND_API.G_RET_STS_SUCCESS;

2516: ln_seq_number NUMBER :=1;
2517:
2518: BEGIN
2519: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2520: x_resultout := FND_API.G_RET_STS_SUCCESS;
2521: BEGIN
2522: x_resultout := FND_API.G_RET_STS_SUCCESS;
2523:
2524: FOR cFeeTypeRec IN cFeeType LOOP

Line 2522: x_resultout := FND_API.G_RET_STS_SUCCESS;

2518: BEGIN
2519: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2520: x_resultout := FND_API.G_RET_STS_SUCCESS;
2521: BEGIN
2522: x_resultout := FND_API.G_RET_STS_SUCCESS;
2523:
2524: FOR cFeeTypeRec IN cFeeType LOOP
2525: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2526: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

Line 2542: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

2538: EXCEPTION
2539: WHEN NO_DATA_FOUND THEN
2540: l_fee_type := NULL;
2541: WHEN OTHERS THEN
2542: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
2543: x_errormsg := sqlerrm;
2544: END;
2545: END fee_type ;
2546:

Line 2570: x_resultout := FND_API.G_RET_STS_SUCCESS;

2566:
2567: ln_seq_number NUMBER :=1;
2568: BEGIN
2569: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2570: x_resultout := FND_API.G_RET_STS_SUCCESS;
2571: BEGIN
2572: x_resultout := FND_API.G_RET_STS_SUCCESS;
2573:
2574: FOR cFeeAmountRec IN cFeeAmount LOOP

Line 2572: x_resultout := FND_API.G_RET_STS_SUCCESS;

2568: BEGIN
2569: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2570: x_resultout := FND_API.G_RET_STS_SUCCESS;
2571: BEGIN
2572: x_resultout := FND_API.G_RET_STS_SUCCESS;
2573:
2574: FOR cFeeAmountRec IN cFeeAmount LOOP
2575: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2576: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

Line 2592: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

2588: EXCEPTION
2589: WHEN NO_DATA_FOUND THEN
2590: l_fee_amount := NULL;
2591: WHEN OTHERS THEN
2592: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
2593: x_errormsg := sqlerrm;
2594: END;
2595: END fee_amount ;
2596:

Line 2620: x_resultout := FND_API.G_RET_STS_SUCCESS;

2616:
2617: ln_seq_number NUMBER :=1;
2618: BEGIN
2619: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2620: x_resultout := FND_API.G_RET_STS_SUCCESS;
2621: BEGIN
2622: x_resultout := FND_API.G_RET_STS_SUCCESS;
2623:
2624: FOR cFeeEffFromRec IN cFeeEffFrom LOOP

Line 2622: x_resultout := FND_API.G_RET_STS_SUCCESS;

2618: BEGIN
2619: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2620: x_resultout := FND_API.G_RET_STS_SUCCESS;
2621: BEGIN
2622: x_resultout := FND_API.G_RET_STS_SUCCESS;
2623:
2624: FOR cFeeEffFromRec IN cFeeEffFrom LOOP
2625: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=
2626: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_id;

Line 2642: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

2638: EXCEPTION
2639: WHEN NO_DATA_FOUND THEN
2640: l_fee_date := NULL;
2641: WHEN OTHERS THEN
2642: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
2643: x_errormsg := sqlerrm;
2644: END;
2645:
2646: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

Line 2684: x_resultout := FND_API.G_RET_STS_SUCCESS;

2680: l_adj_amount NUMBER; -- added for bug 6596860 --
2681:
2682: BEGIN
2683: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2684: x_resultout := FND_API.G_RET_STS_SUCCESS;
2685:
2686: SELECT NVL(SUM(AST.OEC), 0)
2687: INTO ln_asset_cost
2688: FROM OKL_ASSETS_B AST, OKL_LEASE_QUOTES_B QUOTE, OKL_LEASE_APPLICATIONS_B LAP

Line 2745: x_resultout := FND_API.G_RET_STS_SUCCESS;

2741: ln_financed_amount NUMBER;
2742:
2743: BEGIN
2744: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2745: x_resultout := FND_API.G_RET_STS_SUCCESS;
2746:
2747: ln_financed_amount := amount_requested(x_resultout => x_resultout,
2748: x_errormsg => x_errormsg);
2749:

Line 2785: x_resultout := FND_API.G_RET_STS_SUCCESS;

2781: AND QUOTE.PARENT_OBJECT_CODE = 'LEASEAPP'
2782: AND QUOTE.PRIMARY_QUOTE = 'Y'
2783: AND LAP.ID = l_lease_app_id;
2784:
2785: x_resultout := FND_API.G_RET_STS_SUCCESS;
2786:
2787: ln_financed_amount := amount_requested(x_resultout => x_resultout,
2788: x_errormsg => x_errormsg);
2789:

Line 2825: x_resultout := FND_API.G_RET_STS_SUCCESS;

2821: ln_seq_number NUMBER :=1;
2822:
2823: BEGIN
2824: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2825: x_resultout := FND_API.G_RET_STS_SUCCESS;
2826: BEGIN
2827: x_resultout := FND_API.G_RET_STS_SUCCESS;
2828:
2829: FOR cSecDepositRec IN cSecDeposit

Line 2827: x_resultout := FND_API.G_RET_STS_SUCCESS;

2823: BEGIN
2824: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2825: x_resultout := FND_API.G_RET_STS_SUCCESS;
2826: BEGIN
2827: x_resultout := FND_API.G_RET_STS_SUCCESS;
2828:
2829: FOR cSecDepositRec IN cSecDeposit
2830: LOOP
2831: OCM_ADD_DATA_POINTS.pg_ocm_dp_values_tbl(ln_seq_number).p_data_point_id :=

Line 2849: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

2845: EXCEPTION
2846: WHEN NO_DATA_FOUND THEN
2847: l_security_deposit := NULL;
2848: WHEN OTHERS THEN
2849: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
2850: x_errormsg := sqlerrm;
2851: END;
2852:
2853: END security_deposit ;

Line 2866: x_resultout := FND_API.G_RET_STS_SUCCESS;

2862: l_billed_tax NUMBER;
2863:
2864: BEGIN
2865: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
2866: x_resultout := FND_API.G_RET_STS_SUCCESS;
2867: BEGIN
2868: SELECT SUM(TRXD.TAX_AMT)
2869: INTO l_billed_tax
2870: FROM

Line 2889: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

2885: EXCEPTION
2886: WHEN NO_DATA_FOUND THEN
2887: l_billed_tax := NULL;
2888: WHEN OTHERS THEN
2889: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
2890: x_errormsg := sqlerrm;
2891: END;
2892:
2893: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value :=

Line 3179: x_resultout := FND_API.G_RET_STS_SUCCESS;

3175: lv_data_point_value okl_leaseapp_datapoints.data_point_value%TYPE;
3176:
3177: BEGIN
3178: mo_global.set_policy_context('S',OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_source_org_id); --Bug#7030452
3179: x_resultout := FND_API.G_RET_STS_SUCCESS;
3180: BEGIN
3181: SELECT DATA_POINT_VALUE
3182: INTO lv_data_point_value
3183: FROM OKL_LEASEAPP_DATAPOINTS

Line 3191: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

3187: EXCEPTION
3188: WHEN NO_DATA_FOUND THEN
3189: lv_data_point_value := NULL;
3190: WHEN OTHERS THEN
3191: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
3192: x_errormsg := sqlerrm;
3193: END;
3194:
3195: OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.p_data_point_value := lv_data_point_value;