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

APPS.PN_INDEX_RENT_UTILS dependencies on FND_API

Line 49: x_return_status := fnd_api.g_ret_sts_success;

45: WHERE index_lease_id = x_index_lease_id
46: AND org_id=x_org_id;
47: BEGIN
48: -- Initialize the return status.
49: x_return_status := fnd_api.g_ret_sts_success;
50:
51: IF ( x_index_lease_id IS NULL
52: OR x_index_lease_id = pn_index_rent_utils.g_pn_miss_num)
53: THEN

Line 65: x_return_status := fnd_api.g_ret_sts_error;

61: , x_index_id;
62:
63: IF (c_index_lease_num%NOTFOUND)
64: THEN
65: x_return_status := fnd_api.g_ret_sts_error;
66: ELSE
67: x_return_status := fnd_api.g_ret_sts_success;
68: END IF;
69:

Line 67: x_return_status := fnd_api.g_ret_sts_success;

63: IF (c_index_lease_num%NOTFOUND)
64: THEN
65: x_return_status := fnd_api.g_ret_sts_error;
66: ELSE
67: x_return_status := fnd_api.g_ret_sts_success;
68: END IF;
69:
70: IF c_index_lease_num%ISOPEN
71: THEN

Line 86: x_return_status := fnd_api.g_ret_sts_error;

82: ,x_index_id;
83:
84: IF (c_index_lease_id%NOTFOUND)
85: THEN
86: x_return_status := fnd_api.g_ret_sts_error;
87: ELSE
88: x_return_status := fnd_api.g_ret_sts_success;
89: END IF;
90:

Line 88: x_return_status := fnd_api.g_ret_sts_success;

84: IF (c_index_lease_id%NOTFOUND)
85: THEN
86: x_return_status := fnd_api.g_ret_sts_error;
87: ELSE
88: x_return_status := fnd_api.g_ret_sts_success;
89: END IF;
90:
91: IF c_index_lease_id%ISOPEN
92: THEN

Line 115: x_return_status := fnd_api.g_ret_sts_unexp_error;

111: THEN
112: CLOSE c_index_lease_id;
113: END IF;
114:
115: x_return_status := fnd_api.g_ret_sts_unexp_error;
116:
117: END get_index_lease_id;
118: PROCEDURE get_lookup_code (
119: p_parameter_name IN VARCHAR2

Line 158: x_return_status := fnd_api.g_ret_sts_success;

154: AND flv.enabled_flag = 'Y'
155: AND flv.lookup_code = x_lookup_type_code;
156: BEGIN
157: -- Initialize the return status.
158: x_return_status := fnd_api.g_ret_sts_success;
159:
160: IF ( x_lookup_type_code IS NULL
161: OR x_lookup_type_code = pn_index_rent_utils.g_pn_miss_char
162: )

Line 171: x_return_status := fnd_api.g_ret_sts_error;

167: INTO x_lookup_type_code;
168:
169: IF (c_lookup_type%NOTFOUND)
170: THEN
171: x_return_status := fnd_api.g_ret_sts_error;
172: ELSE
173: x_return_status := fnd_api.g_ret_sts_success;
174: END IF;
175:

Line 173: x_return_status := fnd_api.g_ret_sts_success;

169: IF (c_lookup_type%NOTFOUND)
170: THEN
171: x_return_status := fnd_api.g_ret_sts_error;
172: ELSE
173: x_return_status := fnd_api.g_ret_sts_success;
174: END IF;
175:
176: IF c_lookup_type%ISOPEN
177: THEN

Line 188: x_return_status := fnd_api.g_ret_sts_error;

184: INTO x_lookup_type_code;
185:
186: IF (c_lookup_type_code%NOTFOUND)
187: THEN
188: x_return_status := fnd_api.g_ret_sts_error;
189: ELSE
190: x_return_status := fnd_api.g_ret_sts_success;
191: END IF;
192:

Line 190: x_return_status := fnd_api.g_ret_sts_success;

186: IF (c_lookup_type_code%NOTFOUND)
187: THEN
188: x_return_status := fnd_api.g_ret_sts_error;
189: ELSE
190: x_return_status := fnd_api.g_ret_sts_success;
191: END IF;
192:
193: IF c_lookup_type_code%ISOPEN
194: THEN

Line 210: x_return_status := fnd_api.g_ret_sts_unexp_error;

206: THEN
207: CLOSE c_lookup_type_code;
208: END IF;
209:
210: x_return_status := fnd_api.g_ret_sts_unexp_error;
211:
212: END get_lookup_code;
213:
214: PROCEDURE get_lease_id

Line 285: x_return_status := fnd_api.g_ret_sts_success;

281: AND PLD.org_id = PL.org_id
282: AND PL.org_id = p_org_id;
283: BEGIN
284: -- Initialize the return status.
285: x_return_status := fnd_api.g_ret_sts_success;
286:
287: IF ( (x_lease_id IS NULL OR x_lease_id = pn_index_rent_utils.g_pn_miss_num)
288: AND
289: (p_lease_number IS NULL OR p_lease_number = pn_index_rent_utils.g_pn_miss_char)

Line 304: x_return_status := fnd_api.g_ret_sts_error;

300: ,x_lease_extension_end_date;
301:
302: IF (c_lease_name%NOTFOUND)
303: THEN
304: x_return_status := fnd_api.g_ret_sts_error;
305: ELSE
306: x_return_status := fnd_api.g_ret_sts_success;
307: END IF;
308:

Line 306: x_return_status := fnd_api.g_ret_sts_success;

302: IF (c_lease_name%NOTFOUND)
303: THEN
304: x_return_status := fnd_api.g_ret_sts_error;
305: ELSE
306: x_return_status := fnd_api.g_ret_sts_success;
307: END IF;
308:
309: IF c_lease_name%ISOPEN
310: THEN

Line 331: x_return_status := fnd_api.g_ret_sts_error;

327: ,x_lease_extension_end_date;
328:
329: IF (c_lease_num%NOTFOUND)
330: THEN
331: x_return_status := fnd_api.g_ret_sts_error;
332: ELSE
333: x_return_status := fnd_api.g_ret_sts_success;
334: END IF;
335:

Line 333: x_return_status := fnd_api.g_ret_sts_success;

329: IF (c_lease_num%NOTFOUND)
330: THEN
331: x_return_status := fnd_api.g_ret_sts_error;
332: ELSE
333: x_return_status := fnd_api.g_ret_sts_success;
334: END IF;
335:
336: IF c_lease_num%ISOPEN
337: THEN

Line 354: x_return_status := fnd_api.g_ret_sts_error;

350: ,x_lease_extension_end_date;
351:
352: IF (c_lease_id%NOTFOUND)
353: THEN
354: x_return_status := fnd_api.g_ret_sts_error;
355: ELSE
356: x_return_status := fnd_api.g_ret_sts_success;
357: END IF;
358:

Line 356: x_return_status := fnd_api.g_ret_sts_success;

352: IF (c_lease_id%NOTFOUND)
353: THEN
354: x_return_status := fnd_api.g_ret_sts_error;
355: ELSE
356: x_return_status := fnd_api.g_ret_sts_success;
357: END IF;
358:
359: IF c_lease_id%ISOPEN
360: THEN

Line 385: x_return_status := fnd_api.g_ret_sts_unexp_error;

381: THEN
382: CLOSE c_lease_id;
383: END IF;
384:
385: x_return_status := fnd_api.g_ret_sts_unexp_error;
386:
387: END GET_LEASE_ID;
388:
389: PROCEDURE get_location_id (

Line 447: x_return_status := fnd_api.g_ret_sts_success;

443: AND PL.location_id = x_location_id;
444:
445: BEGIN
446: -- Initialize the return status.
447: x_return_status := fnd_api.g_ret_sts_success;
448:
449: IF ( x_location_id IS NULL
450: OR x_location_id = pn_index_rent_utils.g_pn_miss_num)
451: THEN

Line 460: x_return_status := fnd_api.g_ret_sts_error;

456:
457: IF (c_location_code%NOTFOUND)
458: THEN
459:
460: x_return_status := fnd_api.g_ret_sts_error;
461: ELSE
462: x_return_status := fnd_api.g_ret_sts_success;
463: END IF;
464:

Line 462: x_return_status := fnd_api.g_ret_sts_success;

458: THEN
459:
460: x_return_status := fnd_api.g_ret_sts_error;
461: ELSE
462: x_return_status := fnd_api.g_ret_sts_success;
463: END IF;
464:
465: IF c_location_code%ISOPEN
466: THEN

Line 477: x_return_status := fnd_api.g_ret_sts_error;

473: INTO x_location_id;
474:
475: IF (c_location_id%NOTFOUND)
476: THEN
477: x_return_status := fnd_api.g_ret_sts_error;
478: ELSE
479: x_return_status := fnd_api.g_ret_sts_success;
480: END IF;
481:

Line 479: x_return_status := fnd_api.g_ret_sts_success;

475: IF (c_location_id%NOTFOUND)
476: THEN
477: x_return_status := fnd_api.g_ret_sts_error;
478: ELSE
479: x_return_status := fnd_api.g_ret_sts_success;
480: END IF;
481:
482: IF c_location_id%ISOPEN
483: THEN

Line 504: x_return_status := fnd_api.g_ret_sts_unexp_error;

500: ELSIF c_location_id%ISOPEN
501: THEN
502: CLOSE c_location_id;
503: END IF;
504: x_return_status := fnd_api.g_ret_sts_unexp_error;
505: END get_location_id;
506:
507: PROCEDURE get_index_id (
508: p_parameter_name IN VARCHAR2

Line 535: x_return_status := fnd_api.g_ret_sts_success;

531: FROM pn_index_history_headers
532: WHERE index_id = x_index_id;
533: BEGIN
534: -- Initialize the return status.
535: x_return_status := fnd_api.g_ret_sts_success;
536:
537: IF ( x_index_id IS NULL
538: OR x_index_id = pn_index_rent_utils.g_pn_miss_num)
539: THEN

Line 547: x_return_status := fnd_api.g_ret_sts_error;

543: INTO x_index_id;
544:
545: IF (c_index%NOTFOUND)
546: THEN
547: x_return_status := fnd_api.g_ret_sts_error;
548: ELSE
549: x_return_status := fnd_api.g_ret_sts_success;
550: END IF;
551:

Line 549: x_return_status := fnd_api.g_ret_sts_success;

545: IF (c_index%NOTFOUND)
546: THEN
547: x_return_status := fnd_api.g_ret_sts_error;
548: ELSE
549: x_return_status := fnd_api.g_ret_sts_success;
550: END IF;
551:
552: IF c_index%ISOPEN
553: THEN

Line 564: x_return_status := fnd_api.g_ret_sts_error;

560: INTO x_index_id;
561:
562: IF (c_index_id%NOTFOUND)
563: THEN
564: x_return_status := fnd_api.g_ret_sts_error;
565: ELSE
566: x_return_status := fnd_api.g_ret_sts_success;
567: END IF;
568:

Line 566: x_return_status := fnd_api.g_ret_sts_success;

562: IF (c_index_id%NOTFOUND)
563: THEN
564: x_return_status := fnd_api.g_ret_sts_error;
565: ELSE
566: x_return_status := fnd_api.g_ret_sts_success;
567: END IF;
568:
569: IF c_index_id%ISOPEN
570: THEN

Line 592: x_return_status := fnd_api.g_ret_sts_unexp_error;

588: THEN
589: CLOSE c_index_id;
590: END IF;
591:
592: x_return_status := fnd_api.g_ret_sts_unexp_error;
593:
594: END get_index_id;
595:
596: PROCEDURE get_user_id (

Line 627: x_return_status := fnd_api.g_ret_sts_success;

623: AND TRUNC (NVL (end_date, SYSDATE))
624: AND user_id = x_user_id;
625: BEGIN
626: -- Initialize the return status.
627: x_return_status := fnd_api.g_ret_sts_success;
628:
629: IF ( x_user_id IS NULL
630: OR x_user_id = pn_index_rent_utils.g_pn_miss_num)
631: THEN

Line 639: x_return_status := fnd_api.g_ret_sts_error;

635: INTO x_user_id;
636:
637: IF (c_user%NOTFOUND)
638: THEN
639: x_return_status := fnd_api.g_ret_sts_error;
640: ELSE
641: x_return_status := fnd_api.g_ret_sts_success;
642: END IF;
643:

Line 641: x_return_status := fnd_api.g_ret_sts_success;

637: IF (c_user%NOTFOUND)
638: THEN
639: x_return_status := fnd_api.g_ret_sts_error;
640: ELSE
641: x_return_status := fnd_api.g_ret_sts_success;
642: END IF;
643:
644: IF c_user%ISOPEN
645: THEN

Line 656: x_return_status := fnd_api.g_ret_sts_error;

652: INTO x_user_id;
653:
654: IF (c_user_id%NOTFOUND)
655: THEN
656: x_return_status := fnd_api.g_ret_sts_error;
657: ELSE
658: x_return_status := fnd_api.g_ret_sts_success;
659: END IF;
660:

Line 658: x_return_status := fnd_api.g_ret_sts_success;

654: IF (c_user_id%NOTFOUND)
655: THEN
656: x_return_status := fnd_api.g_ret_sts_error;
657: ELSE
658: x_return_status := fnd_api.g_ret_sts_success;
659: END IF;
660:
661: IF c_user_id%ISOPEN
662: THEN

Line 684: x_return_status := fnd_api.g_ret_sts_unexp_error;

680: THEN
681: CLOSE c_user_id;
682: END IF;
683:
684: x_return_status := fnd_api.g_ret_sts_unexp_error;
685: END get_user_id;
686:
687: -----------------------------------------------------------------------
688: PROCEDURE get_currency_code(

Line 716: x_return_status := fnd_api.g_ret_sts_success;

712: --AND pn.currency_code <> NVL(x_currency_code,p_functional_currency_code);
713:
714: BEGIN
715: -- Initialize the return status.
716: x_return_status := fnd_api.g_ret_sts_success;
717:
718: IF ( ( x_currency_code IS NOT NULL
719: AND x_currency_code<> pn_index_rent_utils.g_pn_miss_char
720: )

Line 736: x_return_status := fnd_api.g_ret_sts_error;

732: ,x_conversion_type;
733:
734: IF (c_currency_code%NOTFOUND)
735: THEN
736: x_return_status := fnd_api.g_ret_sts_error;
737: ELSE
738: x_return_status := fnd_api.g_ret_sts_success;
739: END IF;
740:

Line 738: x_return_status := fnd_api.g_ret_sts_success;

734: IF (c_currency_code%NOTFOUND)
735: THEN
736: x_return_status := fnd_api.g_ret_sts_error;
737: ELSE
738: x_return_status := fnd_api.g_ret_sts_success;
739: END IF;
740:
741: IF c_currency_code%ISOPEN
742: THEN

Line 762: x_return_status := fnd_api.g_ret_sts_unexp_error;

758: THEN
759: CLOSE c_currency_code;
760: END IF;
761:
762: x_return_status := fnd_api.g_ret_sts_unexp_error;
763: END get_currency_code;
764: ---------------------------------------------------------------------------
765: PROCEDURE get_increase_on(
766: p_parameter_name IN VARCHAR2

Line 811: x_return_status := fnd_api.g_ret_sts_success;

807: AND currency_code = p_currency_code
808: AND LOOK.lookup_code= x_lookup_code;
809: BEGIN
810: -- Initialize the return status.
811: x_return_status := fnd_api.g_ret_sts_success;
812:
813: IF ( x_lookup_code IS NULL
814: OR x_lookup_code = pn_index_rent_utils.g_pn_miss_char
815: )

Line 824: x_return_status := fnd_api.g_ret_sts_error;

820: INTO x_lookup_code;
821:
822: IF (c_lookup%NOTFOUND)
823: THEN
824: x_return_status := fnd_api.g_ret_sts_error;
825: ELSE
826: x_return_status := fnd_api.g_ret_sts_success;
827: END IF;
828:

Line 826: x_return_status := fnd_api.g_ret_sts_success;

822: IF (c_lookup%NOTFOUND)
823: THEN
824: x_return_status := fnd_api.g_ret_sts_error;
825: ELSE
826: x_return_status := fnd_api.g_ret_sts_success;
827: END IF;
828:
829: IF c_lookup%ISOPEN
830: THEN

Line 841: x_return_status := fnd_api.g_ret_sts_error;

837: INTO x_lookup_code;
838:
839: IF (c_lookup_code%NOTFOUND)
840: THEN
841: x_return_status := fnd_api.g_ret_sts_error;
842: ELSE
843: x_return_status := fnd_api.g_ret_sts_success;
844: END IF;
845:

Line 843: x_return_status := fnd_api.g_ret_sts_success;

839: IF (c_lookup_code%NOTFOUND)
840: THEN
841: x_return_status := fnd_api.g_ret_sts_error;
842: ELSE
843: x_return_status := fnd_api.g_ret_sts_success;
844: END IF;
845:
846: IF c_lookup_code%ISOPEN
847: THEN

Line 869: x_return_status := fnd_api.g_ret_sts_unexp_error;

865: THEN
866: CLOSE c_lookup_code;
867: END IF;
868:
869: x_return_status := fnd_api.g_ret_sts_unexp_error;
870:
871: END get_increase_on;
872:
873: -------------------------------------------------------------------------------------

Line 919: x_return_status := fnd_api.g_ret_sts_success;

915: )
916: AND term_template_id = x_termtemp_id;
917: BEGIN
918: -- Initialize the return status.
919: x_return_status := fnd_api.g_ret_sts_success;
920:
921: IF (x_termtemp_id) IS NULL
922: OR
923: (x_termtemp_id=pn_index_rent_utils.g_pn_miss_num)

Line 932: x_return_status := fnd_api.g_ret_sts_error;

928: INTO x_termtemp_id;
929:
930: IF (c_termtemp%NOTFOUND)
931: THEN
932: x_return_status := fnd_api.g_ret_sts_error;
933: ELSE
934: x_return_status := fnd_api.g_ret_sts_success;
935: END IF;
936:

Line 934: x_return_status := fnd_api.g_ret_sts_success;

930: IF (c_termtemp%NOTFOUND)
931: THEN
932: x_return_status := fnd_api.g_ret_sts_error;
933: ELSE
934: x_return_status := fnd_api.g_ret_sts_success;
935: END IF;
936:
937: IF c_termtemp%ISOPEN
938: THEN

Line 949: x_return_status := fnd_api.g_ret_sts_error;

945: INTO x_termtemp_id;
946:
947: IF (c_termtemp_id%NOTFOUND)
948: THEN
949: x_return_status := fnd_api.g_ret_sts_error;
950: ELSE
951: x_return_status := fnd_api.g_ret_sts_success;
952: END IF;
953:

Line 951: x_return_status := fnd_api.g_ret_sts_success;

947: IF (c_termtemp_id%NOTFOUND)
948: THEN
949: x_return_status := fnd_api.g_ret_sts_error;
950: ELSE
951: x_return_status := fnd_api.g_ret_sts_success;
952: END IF;
953:
954: IF c_termtemp_id%ISOPEN
955: THEN

Line 979: x_return_status := fnd_api.g_ret_sts_unexp_error;

975: THEN
976: CLOSE c_termtemp_id;
977: END IF;
978:
979: x_return_status := fnd_api.g_ret_sts_unexp_error;
980: END get_term_template_id;
981:
982: END PN_INDEX_RENT_UTILS;