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

[Home] [Help]

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 750: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 753: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 773: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 804: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 806: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 826: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 856: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 858: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 878: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 910: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 912: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 932: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 962: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 964: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 984: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1000: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1017: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1038: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1066: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1087: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1102: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1123: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1147: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1179: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1181: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1200: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1227: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1230: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1250: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1276: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1278: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1298: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1324: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1327: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1346: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1372: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1375: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1395: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1420: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1423: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1442: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1469: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1472: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1492: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1508: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1528: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1548: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1568: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1589: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1609: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1645: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1647: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1668: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1746: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1748: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1768: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1842: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1845: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1865: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1939: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1941: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1961: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2035: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 2037: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 2058: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2131: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 2134: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 2154: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2173: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 2176: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 2192: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2370: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 2372: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 2427: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

2423:
2424: WHEN NO_DATA_FOUND THEN
2425: l_pmnt_end_date := NULL;
2426: WHEN OTHERS THEN
2427: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
2428: x_errormsg := sqlerrm;
2429: END;
2430: END pmnt_end_date ;
2431:

Line 2471: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 2473: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 2493: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2523: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 2525: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 2545: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2573: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 2575: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 2595: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2623: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 2625: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 2645: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2687: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 2748: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 2788: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 2828: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 2830: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 2852: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2869: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 2892: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 3182: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 3194: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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