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.BIS_PMV_PMF_PVT dependencies on FND_API

Line 187: IF (l_return_Status = FND_API.G_RET_STS_ERROR) THEN

183: ,x_Target_Rec => l_target_rec
184: ,x_return_status => l_return_status
185: ,x_error_Tbl => l_error_tbl
186: );
187: IF (l_return_Status = FND_API.G_RET_STS_ERROR) THEN
188: vTarget := 'NONE';
189: v_range1_high := 'NONE';
190: v_range1_low := 'NONE';
191: else

Line 195: if (l_target_rec.target_id is null) or (l_target_rec.target_id = FND_API.G_MISS_NUM) then

191: else
192: vTarget := l_target_rec.target;
193: v_range1_low := l_target_rec.range1_low;
194: v_range1_high := l_target_rec.range1_high;
195: if (l_target_rec.target_id is null) or (l_target_rec.target_id = FND_API.G_MISS_NUM) then
196: vTarget := 'NONE';
197: v_range1_low := 'NONE';
198: v_Range1_high := 'NONE';
199: else

Line 200: if (v_range1_low = FND_API.G_MISS_NUM) or (v_range1_low is null) then

196: vTarget := 'NONE';
197: v_range1_low := 'NONE';
198: v_Range1_high := 'NONE';
199: else
200: if (v_range1_low = FND_API.G_MISS_NUM) or (v_range1_low is null) then
201: v_range1_low := 'NONE';
202: end if;
203: if (v_range1_high = FND_API.G_MISS_NUM) or (v_range1_high is null) then
204: v_range1_high := 'NONE';

Line 203: if (v_range1_high = FND_API.G_MISS_NUM) or (v_range1_high is null) then

199: else
200: if (v_range1_low = FND_API.G_MISS_NUM) or (v_range1_low is null) then
201: v_range1_low := 'NONE';
202: end if;
203: if (v_range1_high = FND_API.G_MISS_NUM) or (v_range1_high is null) then
204: v_range1_high := 'NONE';
205: end if;
206: end if;
207: END IF;

Line 265: /*if v_return_status = FND_API.G_RET_STS_ERROR then

261: ,x_msg_count=> v_msg_count
262: ,x_msg_data=> v_msg_data
263: );
264:
265: /*if v_return_status = FND_API.G_RET_STS_ERROR then
266: for i in 1..v_msg_count loop
267: htp.print(fnd_msg_pub.get(p_msg_index=>i, p_encoded=>FND_API.G_FALSE));
268: htp.br;
269: end loop;

Line 267: htp.print(fnd_msg_pub.get(p_msg_index=>i, p_encoded=>FND_API.G_FALSE));

263: );
264:
265: /*if v_return_status = FND_API.G_RET_STS_ERROR then
266: for i in 1..v_msg_count loop
267: htp.print(fnd_msg_pub.get(p_msg_index=>i, p_encoded=>FND_API.G_FALSE));
268: htp.br;
269: end loop;
270: end if;*/
271:

Line 436: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

432:
433:
434: --jprabhud added for enhancement#2184054
435: l_err varchar2(2000);
436: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
437:
438: l_nested_region_code varchar2(100);
439:
440: lAsOfDateValue varchar2(100);

Line 500: l_return_status := FND_API.G_RET_STS_ERROR;

496: END IF;
497: exception
498: --jprabhud added l_return_status for enhancement#2184054
499: when NO_DATA_FOUND then
500: l_return_status := FND_API.G_RET_STS_ERROR;
501: htp.print(p_parm1Level_short_name ||' does not match the level short name defined in AK .');
502: when others then
503: l_return_status := FND_API.G_RET_STS_ERROR;
504: htp.print('cannot obtain correct info for level short name: '||p_parm1Level_short_name);

Line 503: l_return_status := FND_API.G_RET_STS_ERROR;

499: when NO_DATA_FOUND then
500: l_return_status := FND_API.G_RET_STS_ERROR;
501: htp.print(p_parm1Level_short_name ||' does not match the level short name defined in AK .');
502: when others then
503: l_return_status := FND_API.G_RET_STS_ERROR;
504: htp.print('cannot obtain correct info for level short name: '||p_parm1Level_short_name);
505: end;
506: END IF;
507:

Line 523: l_return_status := FND_API.G_RET_STS_ERROR;

519: END IF;
520: exception
521: --jprabhud added l_return_status for enhancement#2184054
522: when NO_DATA_FOUND then
523: l_return_status := FND_API.G_RET_STS_ERROR;
524: htp.print(p_parm2Level_short_name ||' does not match the level short name defined in AK .');
525: when others then
526: l_return_status := FND_API.G_RET_STS_ERROR;
527: htp.print('cannot obtain correct info for level short name: '||p_parm2Level_short_name);

Line 526: l_return_status := FND_API.G_RET_STS_ERROR;

522: when NO_DATA_FOUND then
523: l_return_status := FND_API.G_RET_STS_ERROR;
524: htp.print(p_parm2Level_short_name ||' does not match the level short name defined in AK .');
525: when others then
526: l_return_status := FND_API.G_RET_STS_ERROR;
527: htp.print('cannot obtain correct info for level short name: '||p_parm2Level_short_name);
528: end;
529:
530: END IF;

Line 547: l_return_status := FND_API.G_RET_STS_ERROR;

543:
544: exception
545: --jprabhud added l_return_status for enhancement#2184054
546: when NO_DATA_FOUND then
547: l_return_status := FND_API.G_RET_STS_ERROR;
548: htp.print(p_parm3Level_short_name ||' does not match the level short name defined in AK .');
549: when others then
550: l_return_status := FND_API.G_RET_STS_ERROR;
551: htp.print('cannot obtain correct info for level short name: '||p_parm3Level_short_name);

Line 550: l_return_status := FND_API.G_RET_STS_ERROR;

546: when NO_DATA_FOUND then
547: l_return_status := FND_API.G_RET_STS_ERROR;
548: htp.print(p_parm3Level_short_name ||' does not match the level short name defined in AK .');
549: when others then
550: l_return_status := FND_API.G_RET_STS_ERROR;
551: htp.print('cannot obtain correct info for level short name: '||p_parm3Level_short_name);
552: end;
553:
554: END IF;

Line 570: l_return_status := FND_API.G_RET_STS_ERROR;

566: END IF;
567: exception
568: --jprabhud added l_return_status for enhancement#2184054
569: when NO_DATA_FOUND then
570: l_return_status := FND_API.G_RET_STS_ERROR;
571: htp.print(p_parm4Level_short_name ||' does not match the level short name defined in AK .');
572: when others then
573: l_return_status := FND_API.G_RET_STS_ERROR;
574: htp.print('cannot obtain correct info for level short name: '||p_parm4Level_short_name);

Line 573: l_return_status := FND_API.G_RET_STS_ERROR;

569: when NO_DATA_FOUND then
570: l_return_status := FND_API.G_RET_STS_ERROR;
571: htp.print(p_parm4Level_short_name ||' does not match the level short name defined in AK .');
572: when others then
573: l_return_status := FND_API.G_RET_STS_ERROR;
574: htp.print('cannot obtain correct info for level short name: '||p_parm4Level_short_name);
575: end;
576:
577: END IF;

Line 593: l_return_status := FND_API.G_RET_STS_ERROR;

589: END IF;
590: exception
591: --jprabhud added l_return_status for enhancement#2184054
592: when NO_DATA_FOUND then
593: l_return_status := FND_API.G_RET_STS_ERROR;
594: htp.print(p_parm5Level_short_name ||' does not match the level short name defined in AK .');
595: when others then
596: l_return_status := FND_API.G_RET_STS_ERROR;
597: htp.print('cannot obtain correct info for level short name: '||p_parm5Level_short_name);

Line 596: l_return_status := FND_API.G_RET_STS_ERROR;

592: when NO_DATA_FOUND then
593: l_return_status := FND_API.G_RET_STS_ERROR;
594: htp.print(p_parm5Level_short_name ||' does not match the level short name defined in AK .');
595: when others then
596: l_return_status := FND_API.G_RET_STS_ERROR;
597: htp.print('cannot obtain correct info for level short name: '||p_parm5Level_short_name);
598: end;
599:
600: END IF;

Line 616: l_return_status := FND_API.G_RET_STS_ERROR;

612: END IF;
613: exception
614: --jprabhud added l_return_status for enhancement#2184054
615: when NO_DATA_FOUND then
616: l_return_status := FND_API.G_RET_STS_ERROR;
617: htp.print(p_parm6Level_short_name ||' does not match the level short name defined in AK .');
618: when others then
619: l_return_status := FND_API.G_RET_STS_ERROR;
620: htp.print('cannot obtain correct info for level short name: '||p_parm6Level_short_name);

Line 619: l_return_status := FND_API.G_RET_STS_ERROR;

615: when NO_DATA_FOUND then
616: l_return_status := FND_API.G_RET_STS_ERROR;
617: htp.print(p_parm6Level_short_name ||' does not match the level short name defined in AK .');
618: when others then
619: l_return_status := FND_API.G_RET_STS_ERROR;
620: htp.print('cannot obtain correct info for level short name: '||p_parm6Level_short_name);
621: end;
622:
623: END IF;

Line 636: l_return_status := FND_API.G_RET_STS_ERROR;

632: AND ak.node_query_flag = 'Y';
633: exception
634: --jprabhud added l_return_status for enhancement#2184054
635: when NO_DATA_FOUND then
636: l_return_status := FND_API.G_RET_STS_ERROR;
637: htp.print(p_parm7Level_short_name ||' does not match the level short name defined in AK .');
638: when others then
639: l_return_status := FND_API.G_RET_STS_ERROR;
640: htp.print('cannot obtain correct info for level short name: '||p_parm7Level_short_name);

Line 639: l_return_status := FND_API.G_RET_STS_ERROR;

635: when NO_DATA_FOUND then
636: l_return_status := FND_API.G_RET_STS_ERROR;
637: htp.print(p_parm7Level_short_name ||' does not match the level short name defined in AK .');
638: when others then
639: l_return_status := FND_API.G_RET_STS_ERROR;
640: htp.print('cannot obtain correct info for level short name: '||p_parm7Level_short_name);
641: end;
642:
643: END IF;

Line 659: l_return_status := FND_API.G_RET_STS_ERROR;

655: END IF;
656: exception
657: --jprabhud added l_return_status for enhancement#2184054
658: when NO_DATA_FOUND then
659: l_return_status := FND_API.G_RET_STS_ERROR;
660: htp.print(p_parm8Level_short_name ||' does not match the level short name defined in AK .');
661: when others then
662: l_return_status := FND_API.G_RET_STS_ERROR;
663: htp.print('cannot obtain correct info for level short name: '||p_parm8Level_short_name);

Line 662: l_return_status := FND_API.G_RET_STS_ERROR;

658: when NO_DATA_FOUND then
659: l_return_status := FND_API.G_RET_STS_ERROR;
660: htp.print(p_parm8Level_short_name ||' does not match the level short name defined in AK .');
661: when others then
662: l_return_status := FND_API.G_RET_STS_ERROR;
663: htp.print('cannot obtain correct info for level short name: '||p_parm8Level_short_name);
664: end;
665:
666: END IF;

Line 682: l_return_status := FND_API.G_RET_STS_ERROR;

678: END IF;
679: exception
680: --jprabhud added l_return_status for enhancement#2184054
681: when NO_DATA_FOUND then
682: l_return_status := FND_API.G_RET_STS_ERROR;
683: htp.print(p_parm9Level_short_name ||' does not match the level short name defined in AK .');
684: when others then
685: l_return_status := FND_API.G_RET_STS_ERROR;
686: htp.print('cannot obtain correct info for level short name: '||p_parm9Level_short_name);

Line 685: l_return_status := FND_API.G_RET_STS_ERROR;

681: when NO_DATA_FOUND then
682: l_return_status := FND_API.G_RET_STS_ERROR;
683: htp.print(p_parm9Level_short_name ||' does not match the level short name defined in AK .');
684: when others then
685: l_return_status := FND_API.G_RET_STS_ERROR;
686: htp.print('cannot obtain correct info for level short name: '||p_parm9Level_short_name);
687: end;
688:
689: END IF;

Line 705: l_return_status := FND_API.G_RET_STS_ERROR;

701: END IF;
702: exception
703: --jprabhud added l_return_status for enhancement#2184054
704: when NO_DATA_FOUND then
705: l_return_status := FND_API.G_RET_STS_ERROR;
706: htp.print(p_parm10Level_short_name ||' does not match the level short name defined in AK .');
707: when others then
708: l_return_status := FND_API.G_RET_STS_ERROR;
709: htp.print('cannot obtain correct info for level short name: '||p_parm10Level_short_name);

Line 708: l_return_status := FND_API.G_RET_STS_ERROR;

704: when NO_DATA_FOUND then
705: l_return_status := FND_API.G_RET_STS_ERROR;
706: htp.print(p_parm10Level_short_name ||' does not match the level short name defined in AK .');
707: when others then
708: l_return_status := FND_API.G_RET_STS_ERROR;
709: htp.print('cannot obtain correct info for level short name: '||p_parm10Level_short_name);
710: end;
711:
712: END IF;

Line 728: l_return_status := FND_API.G_RET_STS_ERROR;

724: END IF;
725: exception
726: --jprabhud added l_return_status for enhancement#2184054
727: when NO_DATA_FOUND then
728: l_return_status := FND_API.G_RET_STS_ERROR;
729: htp.print(p_parm11Level_short_name ||' does not match the level short name defined in AK .');
730: when others then
731: l_return_status := FND_API.G_RET_STS_ERROR;
732: htp.print('cannot obtain correct info for level short name: '||p_parm11Level_short_name);

Line 731: l_return_status := FND_API.G_RET_STS_ERROR;

727: when NO_DATA_FOUND then
728: l_return_status := FND_API.G_RET_STS_ERROR;
729: htp.print(p_parm11Level_short_name ||' does not match the level short name defined in AK .');
730: when others then
731: l_return_status := FND_API.G_RET_STS_ERROR;
732: htp.print('cannot obtain correct info for level short name: '||p_parm11Level_short_name);
733: end;
734:
735: END IF;

Line 751: l_return_status := FND_API.G_RET_STS_ERROR;

747: END IF;
748: exception
749: --jprabhud added l_return_status for enhancement#2184054
750: when NO_DATA_FOUND then
751: l_return_status := FND_API.G_RET_STS_ERROR;
752: htp.print(p_parm12Level_short_name ||' does not match the level short name defined in AK .');
753: when others then
754: l_return_status := FND_API.G_RET_STS_ERROR;
755: htp.print('cannot obtain correct info for level short name: '||p_parm12Level_short_name);

Line 754: l_return_status := FND_API.G_RET_STS_ERROR;

750: when NO_DATA_FOUND then
751: l_return_status := FND_API.G_RET_STS_ERROR;
752: htp.print(p_parm12Level_short_name ||' does not match the level short name defined in AK .');
753: when others then
754: l_return_status := FND_API.G_RET_STS_ERROR;
755: htp.print('cannot obtain correct info for level short name: '||p_parm12Level_short_name);
756: end;
757:
758: END IF;

Line 774: l_return_status := FND_API.G_RET_STS_ERROR;

770: END IF;
771: exception
772: --jprabhud added l_return_status for enhancement#2184054
773: when NO_DATA_FOUND then
774: l_return_status := FND_API.G_RET_STS_ERROR;
775: htp.print(p_parm13Level_short_name ||' does not match the level short name defined in AK .');
776: when others then
777: l_return_status := FND_API.G_RET_STS_ERROR;
778: htp.print('cannot obtain correct info for level short name: '||p_parm13Level_short_name);

Line 777: l_return_status := FND_API.G_RET_STS_ERROR;

773: when NO_DATA_FOUND then
774: l_return_status := FND_API.G_RET_STS_ERROR;
775: htp.print(p_parm13Level_short_name ||' does not match the level short name defined in AK .');
776: when others then
777: l_return_status := FND_API.G_RET_STS_ERROR;
778: htp.print('cannot obtain correct info for level short name: '||p_parm13Level_short_name);
779: end;
780:
781: END IF;

Line 800: l_return_status := FND_API.G_RET_STS_ERROR;

796: AND substr(ak.attribute2, instr(ak.attribute2, '+')+1) = p_viewby_level_short_name
797: AND ak.attribute1 in ('DIMENSION LEVEL', 'DIM LEVEL SINGLE VALUE');
798: exception
799: when NO_DATA_FOUND then
800: l_return_status := FND_API.G_RET_STS_ERROR;
801: htp.print(p_viewby_level_short_name ||' does not match the level short name defined in AK.');
802: when others then
803: l_return_status := FND_API.G_RET_STS_ERROR;
804: htp.print('cannot obtain correct info for level short name: '||p_viewby_level_short_name);

Line 803: l_return_status := FND_API.G_RET_STS_ERROR;

799: when NO_DATA_FOUND then
800: l_return_status := FND_API.G_RET_STS_ERROR;
801: htp.print(p_viewby_level_short_name ||' does not match the level short name defined in AK.');
802: when others then
803: l_return_status := FND_API.G_RET_STS_ERROR;
804: htp.print('cannot obtain correct info for level short name: '||p_viewby_level_short_name);
805: end;
806:
807: END IF;

Line 857: l_return_status := FND_API.G_RET_STS_ERROR;

853: end if;
854: EXCEPTION
855: --jprabhud added l_return_status enhancement#2184054
856: WHEN NO_DATA_FOUND then
857: l_return_status := FND_API.G_RET_STS_ERROR;
858: htp.print(p_viewby_level_short_name ||' does not match the level short name defined in AK .');
859: WHEN others then
860: l_return_status := FND_API.G_RET_STS_ERROR;
861: htp.print('cannot obtain correct info for level short name: '||p_viewby_level_short_name);

Line 860: l_return_status := FND_API.G_RET_STS_ERROR;

856: WHEN NO_DATA_FOUND then
857: l_return_status := FND_API.G_RET_STS_ERROR;
858: htp.print(p_viewby_level_short_name ||' does not match the level short name defined in AK .');
859: WHEN others then
860: l_return_status := FND_API.G_RET_STS_ERROR;
861: htp.print('cannot obtain correct info for level short name: '||p_viewby_level_short_name);
862: end;
863: END IF;
864:

Line 878: l_return_status := FND_API.G_RET_STS_ERROR;

874: AND ak.attribute1 in ('DIMENSION LEVEL', 'DIM LEVEL SINGLE VALUE', 'HIDE VIEW BY DIMENSION');
875: exception
876: --jprabhud added l_return_status for enhancement#2184054
877: when NO_DATA_FOUND then
878: l_return_status := FND_API.G_RET_STS_ERROR;
879: htp.print(p_TimeparmLevel_short_name ||' does not match the level short name defined in AK .');
880: when others then
881: l_return_status := FND_API.G_RET_STS_ERROR;
882: htp.print('cannot obtain correct info for level short name: '||p_TimeparmLevel_short_name);

Line 881: l_return_status := FND_API.G_RET_STS_ERROR;

877: when NO_DATA_FOUND then
878: l_return_status := FND_API.G_RET_STS_ERROR;
879: htp.print(p_TimeparmLevel_short_name ||' does not match the level short name defined in AK .');
880: when others then
881: l_return_status := FND_API.G_RET_STS_ERROR;
882: htp.print('cannot obtain correct info for level short name: '||p_TimeparmLevel_short_name);
883: end;
884:
885: vTimeFromParameter := p_TimeFromparmValue_name;

Line 977: if(l_return_status <> FND_API.G_RET_STS_ERROR) then

973: );
974:
975:
976: --jprabhud added enhancement#2184054
977: if(l_return_status <> FND_API.G_RET_STS_ERROR) then
978: l_return_status := nvl(vReturnStatus,FND_API.G_RET_STS_SUCCESS);
979: end if;
980:
981:

Line 978: l_return_status := nvl(vReturnStatus,FND_API.G_RET_STS_SUCCESS);

974:
975:
976: --jprabhud added enhancement#2184054
977: if(l_return_status <> FND_API.G_RET_STS_ERROR) then
978: l_return_status := nvl(vReturnStatus,FND_API.G_RET_STS_SUCCESS);
979: end if;
980:
981:
982: /*

Line 989: if(l_return_status = FND_API.G_RET_STS_SUCCESS) then

985: ||'&pSessionId='||vSessionId||'&pUserId='||vUserId||'&pResponsibilityId='||vRespId
986: ||'&pFileId='||vFileId||'&pFirstTime=0&pMode=SONAR';
987: */
988: --jprabhud added enhancement#2184054
989: if(l_return_status = FND_API.G_RET_STS_SUCCESS) then
990: vReportURL := FND_WEB_CONFIG.trail_slash(FND_WEB_CONFIG.WEB_SERVER)||
991: 'OA_HTML/bisviewm.jsp?dbc=' || FND_WEB_CONFIG.DATABASE_ID
992: ||'®ionCode='||BIS_PMV_UTIL.encode(p_region_code)||'&functionName='||BIS_PMV_UTIL.encode(p_function_name)
993: ||'&pSessionId='||vSessionId||'&pUserId='||vUserId||'&pResponsibilityId='||vRespId

Line 1106: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

1102:
1103:
1104: --jprabhud added for enhancement#2184054
1105: l_err varchar2(2000);
1106: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
1107:
1108: l_nested_region_code varchar2(100);
1109:
1110: lAsOfDateValue varchar2(100);

Line 1172: l_return_status := FND_API.G_RET_STS_ERROR;

1168: END IF;
1169: exception
1170: --jprabhud added l_return_status for enhancement#2184054
1171: when NO_DATA_FOUND then
1172: l_return_status := FND_API.G_RET_STS_ERROR;
1173: htp.print(p_parm1Level_short_name ||' does not match the level short name defined in AK .');
1174: when others then
1175: l_return_status := FND_API.G_RET_STS_ERROR;
1176: htp.print('cannot obtain correct info for level short name: '||p_parm1Level_short_name);

Line 1175: l_return_status := FND_API.G_RET_STS_ERROR;

1171: when NO_DATA_FOUND then
1172: l_return_status := FND_API.G_RET_STS_ERROR;
1173: htp.print(p_parm1Level_short_name ||' does not match the level short name defined in AK .');
1174: when others then
1175: l_return_status := FND_API.G_RET_STS_ERROR;
1176: htp.print('cannot obtain correct info for level short name: '||p_parm1Level_short_name);
1177: end;
1178: END IF;
1179:

Line 1195: l_return_status := FND_API.G_RET_STS_ERROR;

1191: END IF;
1192: exception
1193: --jprabhud added l_return_status for enhancement#2184054
1194: when NO_DATA_FOUND then
1195: l_return_status := FND_API.G_RET_STS_ERROR;
1196: htp.print(p_parm2Level_short_name ||' does not match the level short name defined in AK .');
1197: when others then
1198: l_return_status := FND_API.G_RET_STS_ERROR;
1199: htp.print('cannot obtain correct info for level short name: '||p_parm2Level_short_name);

Line 1198: l_return_status := FND_API.G_RET_STS_ERROR;

1194: when NO_DATA_FOUND then
1195: l_return_status := FND_API.G_RET_STS_ERROR;
1196: htp.print(p_parm2Level_short_name ||' does not match the level short name defined in AK .');
1197: when others then
1198: l_return_status := FND_API.G_RET_STS_ERROR;
1199: htp.print('cannot obtain correct info for level short name: '||p_parm2Level_short_name);
1200: end;
1201:
1202: END IF;

Line 1219: l_return_status := FND_API.G_RET_STS_ERROR;

1215:
1216: exception
1217: --jprabhud added l_return_status for enhancement#2184054
1218: when NO_DATA_FOUND then
1219: l_return_status := FND_API.G_RET_STS_ERROR;
1220: htp.print(p_parm3Level_short_name ||' does not match the level short name defined in AK .');
1221: when others then
1222: l_return_status := FND_API.G_RET_STS_ERROR;
1223: htp.print('cannot obtain correct info for level short name: '||p_parm3Level_short_name);

Line 1222: l_return_status := FND_API.G_RET_STS_ERROR;

1218: when NO_DATA_FOUND then
1219: l_return_status := FND_API.G_RET_STS_ERROR;
1220: htp.print(p_parm3Level_short_name ||' does not match the level short name defined in AK .');
1221: when others then
1222: l_return_status := FND_API.G_RET_STS_ERROR;
1223: htp.print('cannot obtain correct info for level short name: '||p_parm3Level_short_name);
1224: end;
1225:
1226: END IF;

Line 1242: l_return_status := FND_API.G_RET_STS_ERROR;

1238: END IF;
1239: exception
1240: --jprabhud added l_return_status for enhancement#2184054
1241: when NO_DATA_FOUND then
1242: l_return_status := FND_API.G_RET_STS_ERROR;
1243: htp.print(p_parm4Level_short_name ||' does not match the level short name defined in AK .');
1244: when others then
1245: l_return_status := FND_API.G_RET_STS_ERROR;
1246: htp.print('cannot obtain correct info for level short name: '||p_parm4Level_short_name);

Line 1245: l_return_status := FND_API.G_RET_STS_ERROR;

1241: when NO_DATA_FOUND then
1242: l_return_status := FND_API.G_RET_STS_ERROR;
1243: htp.print(p_parm4Level_short_name ||' does not match the level short name defined in AK .');
1244: when others then
1245: l_return_status := FND_API.G_RET_STS_ERROR;
1246: htp.print('cannot obtain correct info for level short name: '||p_parm4Level_short_name);
1247: end;
1248:
1249: END IF;

Line 1265: l_return_status := FND_API.G_RET_STS_ERROR;

1261: END IF;
1262: exception
1263: --jprabhud added l_return_status for enhancement#2184054
1264: when NO_DATA_FOUND then
1265: l_return_status := FND_API.G_RET_STS_ERROR;
1266: htp.print(p_parm5Level_short_name ||' does not match the level short name defined in AK .');
1267: when others then
1268: l_return_status := FND_API.G_RET_STS_ERROR;
1269: htp.print('cannot obtain correct info for level short name: '||p_parm5Level_short_name);

Line 1268: l_return_status := FND_API.G_RET_STS_ERROR;

1264: when NO_DATA_FOUND then
1265: l_return_status := FND_API.G_RET_STS_ERROR;
1266: htp.print(p_parm5Level_short_name ||' does not match the level short name defined in AK .');
1267: when others then
1268: l_return_status := FND_API.G_RET_STS_ERROR;
1269: htp.print('cannot obtain correct info for level short name: '||p_parm5Level_short_name);
1270: end;
1271:
1272: END IF;

Line 1288: l_return_status := FND_API.G_RET_STS_ERROR;

1284: END IF;
1285: exception
1286: --jprabhud added l_return_status for enhancement#2184054
1287: when NO_DATA_FOUND then
1288: l_return_status := FND_API.G_RET_STS_ERROR;
1289: htp.print(p_parm6Level_short_name ||' does not match the level short name defined in AK .');
1290: when others then
1291: l_return_status := FND_API.G_RET_STS_ERROR;
1292: htp.print('cannot obtain correct info for level short name: '||p_parm6Level_short_name);

Line 1291: l_return_status := FND_API.G_RET_STS_ERROR;

1287: when NO_DATA_FOUND then
1288: l_return_status := FND_API.G_RET_STS_ERROR;
1289: htp.print(p_parm6Level_short_name ||' does not match the level short name defined in AK .');
1290: when others then
1291: l_return_status := FND_API.G_RET_STS_ERROR;
1292: htp.print('cannot obtain correct info for level short name: '||p_parm6Level_short_name);
1293: end;
1294:
1295: END IF;

Line 1308: l_return_status := FND_API.G_RET_STS_ERROR;

1304: AND ak.node_query_flag = 'Y';
1305: exception
1306: --jprabhud added l_return_status for enhancement#2184054
1307: when NO_DATA_FOUND then
1308: l_return_status := FND_API.G_RET_STS_ERROR;
1309: htp.print(p_parm7Level_short_name ||' does not match the level short name defined in AK .');
1310: when others then
1311: l_return_status := FND_API.G_RET_STS_ERROR;
1312: htp.print('cannot obtain correct info for level short name: '||p_parm7Level_short_name);

Line 1311: l_return_status := FND_API.G_RET_STS_ERROR;

1307: when NO_DATA_FOUND then
1308: l_return_status := FND_API.G_RET_STS_ERROR;
1309: htp.print(p_parm7Level_short_name ||' does not match the level short name defined in AK .');
1310: when others then
1311: l_return_status := FND_API.G_RET_STS_ERROR;
1312: htp.print('cannot obtain correct info for level short name: '||p_parm7Level_short_name);
1313: end;
1314:
1315: END IF;

Line 1331: l_return_status := FND_API.G_RET_STS_ERROR;

1327: END IF;
1328: exception
1329: --jprabhud added l_return_status for enhancement#2184054
1330: when NO_DATA_FOUND then
1331: l_return_status := FND_API.G_RET_STS_ERROR;
1332: htp.print(p_parm8Level_short_name ||' does not match the level short name defined in AK .');
1333: when others then
1334: l_return_status := FND_API.G_RET_STS_ERROR;
1335: htp.print('cannot obtain correct info for level short name: '||p_parm8Level_short_name);

Line 1334: l_return_status := FND_API.G_RET_STS_ERROR;

1330: when NO_DATA_FOUND then
1331: l_return_status := FND_API.G_RET_STS_ERROR;
1332: htp.print(p_parm8Level_short_name ||' does not match the level short name defined in AK .');
1333: when others then
1334: l_return_status := FND_API.G_RET_STS_ERROR;
1335: htp.print('cannot obtain correct info for level short name: '||p_parm8Level_short_name);
1336: end;
1337:
1338: END IF;

Line 1354: l_return_status := FND_API.G_RET_STS_ERROR;

1350: END IF;
1351: exception
1352: --jprabhud added l_return_status for enhancement#2184054
1353: when NO_DATA_FOUND then
1354: l_return_status := FND_API.G_RET_STS_ERROR;
1355: htp.print(p_parm9Level_short_name ||' does not match the level short name defined in AK .');
1356: when others then
1357: l_return_status := FND_API.G_RET_STS_ERROR;
1358: htp.print('cannot obtain correct info for level short name: '||p_parm9Level_short_name);

Line 1357: l_return_status := FND_API.G_RET_STS_ERROR;

1353: when NO_DATA_FOUND then
1354: l_return_status := FND_API.G_RET_STS_ERROR;
1355: htp.print(p_parm9Level_short_name ||' does not match the level short name defined in AK .');
1356: when others then
1357: l_return_status := FND_API.G_RET_STS_ERROR;
1358: htp.print('cannot obtain correct info for level short name: '||p_parm9Level_short_name);
1359: end;
1360:
1361: END IF;

Line 1377: l_return_status := FND_API.G_RET_STS_ERROR;

1373: END IF;
1374: exception
1375: --jprabhud added l_return_status for enhancement#2184054
1376: when NO_DATA_FOUND then
1377: l_return_status := FND_API.G_RET_STS_ERROR;
1378: htp.print(p_parm10Level_short_name ||' does not match the level short name defined in AK .');
1379: when others then
1380: l_return_status := FND_API.G_RET_STS_ERROR;
1381: htp.print('cannot obtain correct info for level short name: '||p_parm10Level_short_name);

Line 1380: l_return_status := FND_API.G_RET_STS_ERROR;

1376: when NO_DATA_FOUND then
1377: l_return_status := FND_API.G_RET_STS_ERROR;
1378: htp.print(p_parm10Level_short_name ||' does not match the level short name defined in AK .');
1379: when others then
1380: l_return_status := FND_API.G_RET_STS_ERROR;
1381: htp.print('cannot obtain correct info for level short name: '||p_parm10Level_short_name);
1382: end;
1383:
1384: END IF;

Line 1400: l_return_status := FND_API.G_RET_STS_ERROR;

1396: END IF;
1397: exception
1398: --jprabhud added l_return_status for enhancement#2184054
1399: when NO_DATA_FOUND then
1400: l_return_status := FND_API.G_RET_STS_ERROR;
1401: htp.print(p_parm11Level_short_name ||' does not match the level short name defined in AK .');
1402: when others then
1403: l_return_status := FND_API.G_RET_STS_ERROR;
1404: htp.print('cannot obtain correct info for level short name: '||p_parm11Level_short_name);

Line 1403: l_return_status := FND_API.G_RET_STS_ERROR;

1399: when NO_DATA_FOUND then
1400: l_return_status := FND_API.G_RET_STS_ERROR;
1401: htp.print(p_parm11Level_short_name ||' does not match the level short name defined in AK .');
1402: when others then
1403: l_return_status := FND_API.G_RET_STS_ERROR;
1404: htp.print('cannot obtain correct info for level short name: '||p_parm11Level_short_name);
1405: end;
1406:
1407: END IF;

Line 1423: l_return_status := FND_API.G_RET_STS_ERROR;

1419: END IF;
1420: exception
1421: --jprabhud added l_return_status for enhancement#2184054
1422: when NO_DATA_FOUND then
1423: l_return_status := FND_API.G_RET_STS_ERROR;
1424: htp.print(p_parm12Level_short_name ||' does not match the level short name defined in AK .');
1425: when others then
1426: l_return_status := FND_API.G_RET_STS_ERROR;
1427: htp.print('cannot obtain correct info for level short name: '||p_parm12Level_short_name);

Line 1426: l_return_status := FND_API.G_RET_STS_ERROR;

1422: when NO_DATA_FOUND then
1423: l_return_status := FND_API.G_RET_STS_ERROR;
1424: htp.print(p_parm12Level_short_name ||' does not match the level short name defined in AK .');
1425: when others then
1426: l_return_status := FND_API.G_RET_STS_ERROR;
1427: htp.print('cannot obtain correct info for level short name: '||p_parm12Level_short_name);
1428: end;
1429:
1430: END IF;

Line 1446: l_return_status := FND_API.G_RET_STS_ERROR;

1442: END IF;
1443: exception
1444: --jprabhud added l_return_status for enhancement#2184054
1445: when NO_DATA_FOUND then
1446: l_return_status := FND_API.G_RET_STS_ERROR;
1447: htp.print(p_parm13Level_short_name ||' does not match the level short name defined in AK .');
1448: when others then
1449: l_return_status := FND_API.G_RET_STS_ERROR;
1450: htp.print('cannot obtain correct info for level short name: '||p_parm13Level_short_name);

Line 1449: l_return_status := FND_API.G_RET_STS_ERROR;

1445: when NO_DATA_FOUND then
1446: l_return_status := FND_API.G_RET_STS_ERROR;
1447: htp.print(p_parm13Level_short_name ||' does not match the level short name defined in AK .');
1448: when others then
1449: l_return_status := FND_API.G_RET_STS_ERROR;
1450: htp.print('cannot obtain correct info for level short name: '||p_parm13Level_short_name);
1451: end;
1452:
1453: END IF;

Line 1472: l_return_status := FND_API.G_RET_STS_ERROR;

1468: AND substr(ak.attribute2, instr(ak.attribute2, '+')+1) = p_viewby_level_short_name
1469: AND ak.attribute1 in ('DIMENSION LEVEL', 'DIM LEVEL SINGLE VALUE');
1470: exception
1471: when NO_DATA_FOUND then
1472: l_return_status := FND_API.G_RET_STS_ERROR;
1473: htp.print(p_viewby_level_short_name ||' does not match the level short name defined in AK.');
1474: when others then
1475: l_return_status := FND_API.G_RET_STS_ERROR;
1476: htp.print('cannot obtain correct info for level short name: '||p_viewby_level_short_name);

Line 1475: l_return_status := FND_API.G_RET_STS_ERROR;

1471: when NO_DATA_FOUND then
1472: l_return_status := FND_API.G_RET_STS_ERROR;
1473: htp.print(p_viewby_level_short_name ||' does not match the level short name defined in AK.');
1474: when others then
1475: l_return_status := FND_API.G_RET_STS_ERROR;
1476: htp.print('cannot obtain correct info for level short name: '||p_viewby_level_short_name);
1477: end;
1478:
1479: END IF;

Line 1529: l_return_status := FND_API.G_RET_STS_ERROR;

1525: end if;
1526: EXCEPTION
1527: --jprabhud added l_return_status enhancement#2184054
1528: WHEN NO_DATA_FOUND then
1529: l_return_status := FND_API.G_RET_STS_ERROR;
1530: htp.print(p_viewby_level_short_name ||' does not match the level short name defined in AK .');
1531: WHEN others then
1532: l_return_status := FND_API.G_RET_STS_ERROR;
1533: htp.print('cannot obtain correct info for level short name: '||p_viewby_level_short_name);

Line 1532: l_return_status := FND_API.G_RET_STS_ERROR;

1528: WHEN NO_DATA_FOUND then
1529: l_return_status := FND_API.G_RET_STS_ERROR;
1530: htp.print(p_viewby_level_short_name ||' does not match the level short name defined in AK .');
1531: WHEN others then
1532: l_return_status := FND_API.G_RET_STS_ERROR;
1533: htp.print('cannot obtain correct info for level short name: '||p_viewby_level_short_name);
1534: end;
1535: END IF;
1536:

Line 1550: l_return_status := FND_API.G_RET_STS_ERROR;

1546: AND ak.attribute1 in ('DIMENSION LEVEL', 'DIM LEVEL SINGLE VALUE', 'HIDE VIEW BY DIMENSION');
1547: exception
1548: --jprabhud added l_return_status for enhancement#2184054
1549: when NO_DATA_FOUND then
1550: l_return_status := FND_API.G_RET_STS_ERROR;
1551: htp.print(p_TimeparmLevel_short_name ||' does not match the level short name defined in AK .');
1552: when others then
1553: l_return_status := FND_API.G_RET_STS_ERROR;
1554: htp.print('cannot obtain correct info for level short name: '||p_TimeparmLevel_short_name);

Line 1553: l_return_status := FND_API.G_RET_STS_ERROR;

1549: when NO_DATA_FOUND then
1550: l_return_status := FND_API.G_RET_STS_ERROR;
1551: htp.print(p_TimeparmLevel_short_name ||' does not match the level short name defined in AK .');
1552: when others then
1553: l_return_status := FND_API.G_RET_STS_ERROR;
1554: htp.print('cannot obtain correct info for level short name: '||p_TimeparmLevel_short_name);
1555: end;
1556:
1557: vTimeFromParameter := p_TimeFromparmValue_name;

Line 1648: if(l_return_status <> FND_API.G_RET_STS_ERROR) then

1644: x_msg_data => vMsgData
1645: );
1646:
1647: --jprabhud added enhancement#2184054
1648: if(l_return_status <> FND_API.G_RET_STS_ERROR) then
1649: l_return_status := nvl(vReturnStatus,FND_API.G_RET_STS_SUCCESS);
1650: end if;
1651:
1652:

Line 1649: l_return_status := nvl(vReturnStatus,FND_API.G_RET_STS_SUCCESS);

1645: );
1646:
1647: --jprabhud added enhancement#2184054
1648: if(l_return_status <> FND_API.G_RET_STS_ERROR) then
1649: l_return_status := nvl(vReturnStatus,FND_API.G_RET_STS_SUCCESS);
1650: end if;
1651:
1652:
1653: --jprabhud added enhancement#2184054

Line 1654: if(l_return_status = FND_API.G_RET_STS_SUCCESS) then

1650: end if;
1651:
1652:
1653: --jprabhud added enhancement#2184054
1654: if(l_return_status = FND_API.G_RET_STS_SUCCESS) then
1655: vReportURL := FND_WEB_CONFIG.trail_slash(FND_WEB_CONFIG.WEB_SERVER)||
1656: 'OA_HTML/bisviewm.jsp?dbc=' || FND_WEB_CONFIG.DATABASE_ID
1657: ||'®ionCode='||BIS_PMV_UTIL.encode(p_region_code)||'&functionName='||BIS_PMV_UTIL.encode(p_function_name)
1658: ||'&pSessionId='||vSessionId||'&pUserId='||vUserId||'&pResponsibilityId='||vRespId

Line 1772: = FND_API.G_TRUE

1768:
1769: -- from retrieve_target_pvt---------------------------------------------
1770:
1771: IF( BIS_UTILITIES_PUB.Value_Not_Missing(l_Target_Rec.Target_ID)
1772: = FND_API.G_TRUE
1773: AND l_Target_Rec.Target_ID IS NOT NULL
1774: ) THEN
1775: SELECT *
1776: INTO l_bisfv_targets_rec

Line 1782: = FND_API.G_TRUE

1778: WHERE bisfv_targets.TARGET_ID = l_Target_Rec.Target_ID;
1779:
1780:
1781: ELSIF( BIS_UTILITIES_PUB.Value_Not_Missing(l_Target_Rec.Target_Level_ID)
1782: = FND_API.G_TRUE
1783: AND l_Target_Rec.Target_Level_ID IS NOT NULL
1784: ) THEN
1785: SELECT *
1786: INTO l_bisbv_target_levels_rec

Line 1794: = FND_API.G_TRUE) then

1790:
1791: ---If Plan Id is not given, get Plan Id from Short name
1792:
1793: if (BIS_UTILITIES_PUB.Value_Missing(l_Target_Rec.Plan_ID)
1794: = FND_API.G_TRUE) then
1795: if (BIS_UTILITIES_PUB.Value_Not_Missing(l_Target_Rec.Plan_Short_Name)
1796: = FND_API.G_TRUE) then
1797: l_Business_Plan_Rec.Business_Plan_Short_Name := l_Target_Rec.Plan_Short_Name;
1798: l_Business_Plan_Rec_p := l_Business_Plan_Rec;

Line 1796: = FND_API.G_TRUE) then

1792:
1793: if (BIS_UTILITIES_PUB.Value_Missing(l_Target_Rec.Plan_ID)
1794: = FND_API.G_TRUE) then
1795: if (BIS_UTILITIES_PUB.Value_Not_Missing(l_Target_Rec.Plan_Short_Name)
1796: = FND_API.G_TRUE) then
1797: l_Business_Plan_Rec.Business_Plan_Short_Name := l_Target_Rec.Plan_Short_Name;
1798: l_Business_Plan_Rec_p := l_Business_Plan_Rec;
1799: -- BugFix 2762795
1800: BIS_BUSINESS_PLAN_PVT.Value_ID_Conversion

Line 1807: if(l_return_status = FND_API.G_RET_STS_SUCCESS) then

1803: , x_Business_Plan_Rec => l_Business_Plan_Rec
1804: , x_return_status => l_return_status
1805: , x_error_Tbl => l_error_tbl
1806: );
1807: if(l_return_status = FND_API.G_RET_STS_SUCCESS) then
1808: l_plan_id := l_Business_Plan_Rec.Business_Plan_ID;
1809: end if;
1810: end if;
1811: else

Line 1815: if(BIS_UTILITIES_PUB.Value_Missing(l_Target_Rec.Org_Level_Value_ID) = FND_API.G_TRUE)

1811: else
1812: l_plan_id := l_Target_Rec.Plan_ID ;
1813: end if;
1814:
1815: if(BIS_UTILITIES_PUB.Value_Missing(l_Target_Rec.Org_Level_Value_ID) = FND_API.G_TRUE)
1816: then l_org_level_value_id := NULL;
1817: else
1818: l_org_level_value_id := l_Target_Rec.Org_Level_Value_ID;
1819: end if;

Line 1822: if(BIS_UTILITIES_PUB.Value_Missing(l_Target_Rec.Time_Level_Value_ID) = FND_API.G_TRUE)

1818: l_org_level_value_id := l_Target_Rec.Org_Level_Value_ID;
1819: end if;
1820:
1821:
1822: if(BIS_UTILITIES_PUB.Value_Missing(l_Target_Rec.Time_Level_Value_ID) = FND_API.G_TRUE)
1823: then l_time_level_value_id := NULL;
1824: else
1825: l_time_level_value_id := l_Target_Rec.Time_Level_Value_ID;
1826: end if;

Line 1845: , FND_API.G_MISS_CHAR

1841: OR NVL(bisfv_targets.TIME_LEVEL_VALUE_ID,'T') = NVL(l_time_level_value_id, 'T'))
1842:
1843: AND NVL(bisfv_targets.DIM1_LEVEL_VALUE_ID, 'T')
1844: = DECODE( l_Target_Rec.Dim1_Level_Value_ID
1845: , FND_API.G_MISS_CHAR
1846: , 'T'
1847: , NVL(l_Target_Rec.Dim1_Level_Value_ID, 'T')
1848: )
1849: AND NVL(bisfv_targets.DIM2_LEVEL_VALUE_ID, 'T')

Line 1851: , FND_API.G_MISS_CHAR

1847: , NVL(l_Target_Rec.Dim1_Level_Value_ID, 'T')
1848: )
1849: AND NVL(bisfv_targets.DIM2_LEVEL_VALUE_ID, 'T')
1850: = DECODE( l_Target_Rec.Dim2_Level_Value_ID
1851: , FND_API.G_MISS_CHAR
1852: , 'T'
1853: , NVL(l_Target_Rec.Dim2_Level_Value_ID, 'T')
1854: )
1855: AND NVL(bisfv_targets.DIM3_LEVEL_VALUE_ID, 'T')

Line 1857: , FND_API.G_MISS_CHAR

1853: , NVL(l_Target_Rec.Dim2_Level_Value_ID, 'T')
1854: )
1855: AND NVL(bisfv_targets.DIM3_LEVEL_VALUE_ID, 'T')
1856: = DECODE( l_Target_Rec.Dim3_Level_Value_ID
1857: , FND_API.G_MISS_CHAR
1858: , 'T'
1859: , NVL(l_Target_Rec.Dim3_Level_Value_ID, 'T')
1860: )
1861: AND NVL(bisfv_targets.DIM4_LEVEL_VALUE_ID, 'T')

Line 1863: , FND_API.G_MISS_CHAR

1859: , NVL(l_Target_Rec.Dim3_Level_Value_ID, 'T')
1860: )
1861: AND NVL(bisfv_targets.DIM4_LEVEL_VALUE_ID, 'T')
1862: = DECODE( l_Target_Rec.Dim4_Level_Value_ID
1863: , FND_API.G_MISS_CHAR
1864: , 'T'
1865: , NVL(l_Target_Rec.Dim4_Level_Value_ID, 'T')
1866: )
1867: AND NVL(bisfv_targets.DIM5_LEVEL_VALUE_ID, 'T')

Line 1869: , FND_API.G_MISS_CHAR

1865: , NVL(l_Target_Rec.Dim4_Level_Value_ID, 'T')
1866: )
1867: AND NVL(bisfv_targets.DIM5_LEVEL_VALUE_ID, 'T')
1868: = DECODE( l_Target_Rec.Dim5_Level_Value_ID
1869: , FND_API.G_MISS_CHAR
1870: , 'T'
1871: , NVL(l_Target_Rec.Dim5_Level_Value_ID, 'T')
1872: )
1873: AND NVL(bisfv_targets.DIM6_LEVEL_VALUE_ID, 'T')

Line 1875: , FND_API.G_MISS_CHAR

1871: , NVL(l_Target_Rec.Dim5_Level_Value_ID, 'T')
1872: )
1873: AND NVL(bisfv_targets.DIM6_LEVEL_VALUE_ID, 'T')
1874: = DECODE( l_Target_Rec.Dim6_Level_Value_ID
1875: , FND_API.G_MISS_CHAR
1876: , 'T'
1877: , NVL(l_Target_Rec.Dim6_Level_Value_ID, 'T')
1878: )
1879: AND NVL(bisfv_targets.DIM7_LEVEL_VALUE_ID, 'T')

Line 1881: , FND_API.G_MISS_CHAR

1877: , NVL(l_Target_Rec.Dim6_Level_Value_ID, 'T')
1878: )
1879: AND NVL(bisfv_targets.DIM7_LEVEL_VALUE_ID, 'T')
1880: = DECODE( l_Target_Rec.Dim7_Level_Value_ID
1881: , FND_API.G_MISS_CHAR
1882: , 'T'
1883: , NVL(l_Target_Rec.Dim7_Level_Value_ID, 'T')
1884: )
1885: ;

Line 1890: IF ((BIS_UTILITIES_PUB.Value_Missing(l_bisfv_targets_rec.Target) = FND_API.G_TRUE)

1886: END IF;
1887: -----------------------------------------------------------------
1888: lTarget := l_bisfv_targets_rec.target;
1889:
1890: IF ((BIS_UTILITIES_PUB.Value_Missing(l_bisfv_targets_rec.Target) = FND_API.G_TRUE)
1891: OR (BIS_UTILITIES_PUB.Value_Null(l_bisfv_targets_rec.Target) = FND_API.G_TRUE))
1892: THEN
1893: IF ((BIS_UTILITIES_PUB.Value_Not_Missing
1894: (l_bisfv_targets_rec.target_level_ID) = FND_API.G_TRUE)

Line 1891: OR (BIS_UTILITIES_PUB.Value_Null(l_bisfv_targets_rec.Target) = FND_API.G_TRUE))

1887: -----------------------------------------------------------------
1888: lTarget := l_bisfv_targets_rec.target;
1889:
1890: IF ((BIS_UTILITIES_PUB.Value_Missing(l_bisfv_targets_rec.Target) = FND_API.G_TRUE)
1891: OR (BIS_UTILITIES_PUB.Value_Null(l_bisfv_targets_rec.Target) = FND_API.G_TRUE))
1892: THEN
1893: IF ((BIS_UTILITIES_PUB.Value_Not_Missing
1894: (l_bisfv_targets_rec.target_level_ID) = FND_API.G_TRUE)
1895: AND (BIS_UTILITIES_PUB.Value_Not_Null

Line 1894: (l_bisfv_targets_rec.target_level_ID) = FND_API.G_TRUE)

1890: IF ((BIS_UTILITIES_PUB.Value_Missing(l_bisfv_targets_rec.Target) = FND_API.G_TRUE)
1891: OR (BIS_UTILITIES_PUB.Value_Null(l_bisfv_targets_rec.Target) = FND_API.G_TRUE))
1892: THEN
1893: IF ((BIS_UTILITIES_PUB.Value_Not_Missing
1894: (l_bisfv_targets_rec.target_level_ID) = FND_API.G_TRUE)
1895: AND (BIS_UTILITIES_PUB.Value_Not_Null
1896: (l_bisfv_targets_rec.target_level_ID) = FND_API.G_TRUE))
1897: THEN
1898: Select

Line 1896: (l_bisfv_targets_rec.target_level_ID) = FND_API.G_TRUE))

1892: THEN
1893: IF ((BIS_UTILITIES_PUB.Value_Not_Missing
1894: (l_bisfv_targets_rec.target_level_ID) = FND_API.G_TRUE)
1895: AND (BIS_UTILITIES_PUB.Value_Not_Null
1896: (l_bisfv_targets_rec.target_level_ID) = FND_API.G_TRUE))
1897: THEN
1898: Select
1899: COMPUTING_FUNCTION_ID
1900: into

Line 1910: (l_Target_Level_Rec.COMPUTING_FUNCTION_ID) = FND_API.G_TRUE)

1906:
1907: -- only compute target if found computing fn id
1908: --
1909: IF ((BIS_UTILITIES_PUB.Value_Not_Missing
1910: (l_Target_Level_Rec.COMPUTING_FUNCTION_ID) = FND_API.G_TRUE)
1911: AND (BIS_UTILITIES_PUB.Value_Not_Null
1912: (l_Target_Level_Rec.COMPUTING_FUNCTION_ID) = FND_API.G_TRUE))
1913: THEN
1914: l_Target_Rec.Target_ID := l_bisfv_targets_rec.Target_ID;

Line 1912: (l_Target_Level_Rec.COMPUTING_FUNCTION_ID) = FND_API.G_TRUE))

1908: --
1909: IF ((BIS_UTILITIES_PUB.Value_Not_Missing
1910: (l_Target_Level_Rec.COMPUTING_FUNCTION_ID) = FND_API.G_TRUE)
1911: AND (BIS_UTILITIES_PUB.Value_Not_Null
1912: (l_Target_Level_Rec.COMPUTING_FUNCTION_ID) = FND_API.G_TRUE))
1913: THEN
1914: l_Target_Rec.Target_ID := l_bisfv_targets_rec.Target_ID;
1915: l_Target_Rec.Target_Level_ID := l_bisfv_targets_rec.Target_Level_ID;
1916: l_Target_Rec.Target_Level_Short_Name

Line 1973: if (l_bisfv_targets_rec.Target_ID is null) or (l_bisfv_targets_rec.Target_ID = FND_API.G_MISS_NUM) then

1969:
1970: xTarget := lTarget;
1971: x_range1_low := l_bisfv_targets_rec.Range1_low;
1972: x_range1_high := l_bisfv_targets_rec.Range1_high;
1973: if (l_bisfv_targets_rec.Target_ID is null) or (l_bisfv_targets_rec.Target_ID = FND_API.G_MISS_NUM) then
1974: xTarget := 'NONE';
1975: x_range1_low := 'NONE';
1976: x_Range1_high := 'NONE';
1977: else

Line 1978: if (x_range1_low = FND_API.G_MISS_NUM) or (x_range1_low is null) then

1974: xTarget := 'NONE';
1975: x_range1_low := 'NONE';
1976: x_Range1_high := 'NONE';
1977: else
1978: if (x_range1_low = FND_API.G_MISS_NUM) or (x_range1_low is null) then
1979: x_range1_low := 'NONE';
1980: end if;
1981: if (x_range1_high = FND_API.G_MISS_NUM) or (x_range1_high is null) then
1982: x_range1_high := 'NONE';

Line 1981: if (x_range1_high = FND_API.G_MISS_NUM) or (x_range1_high is null) then

1977: else
1978: if (x_range1_low = FND_API.G_MISS_NUM) or (x_range1_low is null) then
1979: x_range1_low := 'NONE';
1980: end if;
1981: if (x_range1_high = FND_API.G_MISS_NUM) or (x_range1_high is null) then
1982: x_range1_high := 'NONE';
1983: end if;
1984: end if;
1985: