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_PMF_REG_SERVICE_PVT dependencies on FND_API

Line 463: , p_all_info => FND_API.G_FALSE

459: l_measure_rec_p := l_measure_rec;
460: BIS_Measure_PVT.Retrieve_Measure
461: ( p_api_version => l_api_version
462: , p_measure_rec => l_measure_rec_p
463: , p_all_info => FND_API.G_FALSE
464: , x_measure_rec => l_measure_rec
465: , x_return_status => l_return_status
466: , x_error_Tbl => l_error_Tbl
467: );

Line 480: , p_all_info => FND_API.G_TRUE

476: l_Target_Level_rec_p := l_Target_Level_rec;
477: BIS_Target_Level_PVT.Retrieve_Target_Level
478: ( p_api_version => l_api_version
479: , p_Target_Level_rec => l_Target_Level_rec_p
480: , p_all_info => FND_API.G_TRUE
481: , x_Target_Level_rec => l_Target_Level_rec
482: , x_return_status => l_return_status
483: , x_error_Tbl => l_error_Tbl
484: );

Line 673: when FND_API.G_EXC_ERROR then

669:
670: END IF;
671:
672: EXCEPTION
673: when FND_API.G_EXC_ERROR then
674: l_return_status := FND_API.G_RET_STS_ERROR ;
675: l_debug :=l_debug||' exception 1 at process_parameter_full_set. '||sqlerrm;
676: p_request_id := l_request_id ||l_debug;
677: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 674: l_return_status := FND_API.G_RET_STS_ERROR ;

670: END IF;
671:
672: EXCEPTION
673: when FND_API.G_EXC_ERROR then
674: l_return_status := FND_API.G_RET_STS_ERROR ;
675: l_debug :=l_debug||' exception 1 at process_parameter_full_set. '||sqlerrm;
676: p_request_id := l_request_id ||l_debug;
677: when FND_API.G_EXC_UNEXPECTED_ERROR then
678: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 677: when FND_API.G_EXC_UNEXPECTED_ERROR then

673: when FND_API.G_EXC_ERROR then
674: l_return_status := FND_API.G_RET_STS_ERROR ;
675: l_debug :=l_debug||' exception 1 at process_parameter_full_set. '||sqlerrm;
676: p_request_id := l_request_id ||l_debug;
677: when FND_API.G_EXC_UNEXPECTED_ERROR then
678: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
679: l_debug :=l_debug||' exception 2 at process_parameter_full_set. '||sqlerrm;
680: p_request_id := l_request_id ||l_debug;
681: when others then

Line 678: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

674: l_return_status := FND_API.G_RET_STS_ERROR ;
675: l_debug :=l_debug||' exception 1 at process_parameter_full_set. '||sqlerrm;
676: p_request_id := l_request_id ||l_debug;
677: when FND_API.G_EXC_UNEXPECTED_ERROR then
678: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
679: l_debug :=l_debug||' exception 2 at process_parameter_full_set. '||sqlerrm;
680: p_request_id := l_request_id ||l_debug;
681: when others then
682: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 682: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

678: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
679: l_debug :=l_debug||' exception 2 at process_parameter_full_set. '||sqlerrm;
680: p_request_id := l_request_id ||l_debug;
681: when others then
682: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
683: l_debug :=l_debug||' exception 3 at process_parameter_full_set. '||sqlerrm;
684: p_request_id := l_request_id ||l_debug;
685: l_error_tbl_p := l_error_tbl;
686: BIS_UTILITIES_PVT.Add_Error_Message

Line 867: IF l_request_scheduled = FND_API.G_TRUE THEN

863: ||'Manage_Alert_Registration Target level '||l_request_scheduled
864: ||' , '||l_return_status;
865: --BIS_UTILITIES_PUB.put_line(p_text =>'ARSB: after managing reg: '||l_debug_text);
866:
867: IF l_request_scheduled = FND_API.G_TRUE THEN
868:
869: --BIS_UTILITIES_PUB.put_line(p_text =>'Request exist');
870: l_debug_text := l_debug_text||': '||G_REQUEST_EXIST;
871: l_request_id := G_REQUEST_EXIST;

Line 913: when FND_API.G_EXC_ERROR then

909: p_request_id := l_request_id;
910: --p_request_id := l_request_id||' ..debug..'||l_debug_text;
911:
912: EXCEPTION
913: when FND_API.G_EXC_ERROR then
914: l_return_status := FND_API.G_RET_STS_ERROR ;
915: p_request_id := l_request_id
916: ||' exception 1 in submit_parameter_set_request ';
917: BIS_UTILITIES_PUB.put_line(p_text =>'debug: '||l_debug_text);

Line 914: l_return_status := FND_API.G_RET_STS_ERROR ;

910: --p_request_id := l_request_id||' ..debug..'||l_debug_text;
911:
912: EXCEPTION
913: when FND_API.G_EXC_ERROR then
914: l_return_status := FND_API.G_RET_STS_ERROR ;
915: p_request_id := l_request_id
916: ||' exception 1 in submit_parameter_set_request ';
917: BIS_UTILITIES_PUB.put_line(p_text =>'debug: '||l_debug_text);
918: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 918: when FND_API.G_EXC_UNEXPECTED_ERROR then

914: l_return_status := FND_API.G_RET_STS_ERROR ;
915: p_request_id := l_request_id
916: ||' exception 1 in submit_parameter_set_request ';
917: BIS_UTILITIES_PUB.put_line(p_text =>'debug: '||l_debug_text);
918: when FND_API.G_EXC_UNEXPECTED_ERROR then
919: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
920: p_request_id := l_request_id
921: ||' exception 2 in submit_parameter_set_request ';
922: BIS_UTILITIES_PUB.put_line(p_text =>'debug: '||l_debug_text);

Line 919: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

915: p_request_id := l_request_id
916: ||' exception 1 in submit_parameter_set_request ';
917: BIS_UTILITIES_PUB.put_line(p_text =>'debug: '||l_debug_text);
918: when FND_API.G_EXC_UNEXPECTED_ERROR then
919: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
920: p_request_id := l_request_id
921: ||' exception 2 in submit_parameter_set_request ';
922: BIS_UTILITIES_PUB.put_line(p_text =>'debug: '||l_debug_text);
923: when others then

Line 924: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

920: p_request_id := l_request_id
921: ||' exception 2 in submit_parameter_set_request ';
922: BIS_UTILITIES_PUB.put_line(p_text =>'debug: '||l_debug_text);
923: when others then
924: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
925: p_request_id := l_request_id||', debug: '||l_debug_text
926: ||' exception 3 in submit_parameter_set_request '||sqlerrm;
927: BIS_UTILITIES_PUB.put_line(p_text =>'debug: '||l_debug_text);
928: l_error_Tbl_p := l_error_Tbl;

Line 1151: when FND_API.G_EXC_ERROR then

1147:
1148: x_request_id := l_request_id;
1149:
1150: EXCEPTION
1151: when FND_API.G_EXC_ERROR then
1152: l_return_status := FND_API.G_RET_STS_ERROR ;
1153: l_debug :=l_debug||' exception 1 at add_parameter_set. '||sqlerrm;
1154: x_request_id := x_request_id ||l_debug;
1155: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 1152: l_return_status := FND_API.G_RET_STS_ERROR ;

1148: x_request_id := l_request_id;
1149:
1150: EXCEPTION
1151: when FND_API.G_EXC_ERROR then
1152: l_return_status := FND_API.G_RET_STS_ERROR ;
1153: l_debug :=l_debug||' exception 1 at add_parameter_set. '||sqlerrm;
1154: x_request_id := x_request_id ||l_debug;
1155: when FND_API.G_EXC_UNEXPECTED_ERROR then
1156: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1155: when FND_API.G_EXC_UNEXPECTED_ERROR then

1151: when FND_API.G_EXC_ERROR then
1152: l_return_status := FND_API.G_RET_STS_ERROR ;
1153: l_debug :=l_debug||' exception 1 at add_parameter_set. '||sqlerrm;
1154: x_request_id := x_request_id ||l_debug;
1155: when FND_API.G_EXC_UNEXPECTED_ERROR then
1156: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1157: l_debug :=l_debug||' exception 2 at add_parameter_set. '||sqlerrm;
1158: x_request_id := x_request_id ||l_debug;
1159: when others then

Line 1156: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1152: l_return_status := FND_API.G_RET_STS_ERROR ;
1153: l_debug :=l_debug||' exception 1 at add_parameter_set. '||sqlerrm;
1154: x_request_id := x_request_id ||l_debug;
1155: when FND_API.G_EXC_UNEXPECTED_ERROR then
1156: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1157: l_debug :=l_debug||' exception 2 at add_parameter_set. '||sqlerrm;
1158: x_request_id := x_request_id ||l_debug;
1159: when others then
1160: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1160: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1156: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1157: l_debug :=l_debug||' exception 2 at add_parameter_set. '||sqlerrm;
1158: x_request_id := x_request_id ||l_debug;
1159: when others then
1160: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1161: l_debug :=l_debug||' exception 3 at add_parameter_set. '||sqlerrm;
1162: x_request_id := x_request_id ||l_debug;
1163: l_error_tbl_p := l_error_tbl;
1164: BIS_UTILITIES_PVT.Add_Error_Message

Line 1308: when FND_API.G_EXC_ERROR then

1304: x_request_id := l_request_id_tbl(l_request_id_tbl.FIRST);
1305: END IF;
1306:
1307: EXCEPTION
1308: when FND_API.G_EXC_ERROR then
1309: l_return_status := FND_API.G_RET_STS_ERROR ;
1310: l_debug :=l_debug||' exception 1 at process_report_set_request. '||sqlerrm;
1311: x_request_id := x_request_id ||l_debug;
1312: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 1309: l_return_status := FND_API.G_RET_STS_ERROR ;

1305: END IF;
1306:
1307: EXCEPTION
1308: when FND_API.G_EXC_ERROR then
1309: l_return_status := FND_API.G_RET_STS_ERROR ;
1310: l_debug :=l_debug||' exception 1 at process_report_set_request. '||sqlerrm;
1311: x_request_id := x_request_id ||l_debug;
1312: when FND_API.G_EXC_UNEXPECTED_ERROR then
1313: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1312: when FND_API.G_EXC_UNEXPECTED_ERROR then

1308: when FND_API.G_EXC_ERROR then
1309: l_return_status := FND_API.G_RET_STS_ERROR ;
1310: l_debug :=l_debug||' exception 1 at process_report_set_request. '||sqlerrm;
1311: x_request_id := x_request_id ||l_debug;
1312: when FND_API.G_EXC_UNEXPECTED_ERROR then
1313: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1314: l_debug :=l_debug||' exception 2 at process_report_set_request. '||sqlerrm;
1315: x_request_id := x_request_id ||l_debug;
1316: when others then

Line 1313: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1309: l_return_status := FND_API.G_RET_STS_ERROR ;
1310: l_debug :=l_debug||' exception 1 at process_report_set_request. '||sqlerrm;
1311: x_request_id := x_request_id ||l_debug;
1312: when FND_API.G_EXC_UNEXPECTED_ERROR then
1313: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1314: l_debug :=l_debug||' exception 2 at process_report_set_request. '||sqlerrm;
1315: x_request_id := x_request_id ||l_debug;
1316: when others then
1317: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1317: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1313: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1314: l_debug :=l_debug||' exception 2 at process_report_set_request. '||sqlerrm;
1315: x_request_id := x_request_id ||l_debug;
1316: when others then
1317: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1318: l_debug :=l_debug||' exception 3 at process_report_set_request. '||sqlerrm;
1319: x_request_id := x_request_id ||l_debug;
1320: l_error_tbl_p := l_error_Tbl;
1321: BIS_UTILITIES_PVT.Add_Error_Message

Line 1378: when FND_API.G_EXC_ERROR then

1374:
1375: BIS_UTILITIES_PUB.put_line(p_text =>'IN process_batch_report_request');
1376:
1377: EXCEPTION
1378: when FND_API.G_EXC_ERROR then
1379: l_return_status := FND_API.G_RET_STS_ERROR ;
1380: l_debug :=l_debug
1381: ||' exception 1 at process_batch_report_request. '||sqlerrm;
1382: x_request_id := x_request_id ||l_debug;

Line 1379: l_return_status := FND_API.G_RET_STS_ERROR ;

1375: BIS_UTILITIES_PUB.put_line(p_text =>'IN process_batch_report_request');
1376:
1377: EXCEPTION
1378: when FND_API.G_EXC_ERROR then
1379: l_return_status := FND_API.G_RET_STS_ERROR ;
1380: l_debug :=l_debug
1381: ||' exception 1 at process_batch_report_request. '||sqlerrm;
1382: x_request_id := x_request_id ||l_debug;
1383: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 1383: when FND_API.G_EXC_UNEXPECTED_ERROR then

1379: l_return_status := FND_API.G_RET_STS_ERROR ;
1380: l_debug :=l_debug
1381: ||' exception 1 at process_batch_report_request. '||sqlerrm;
1382: x_request_id := x_request_id ||l_debug;
1383: when FND_API.G_EXC_UNEXPECTED_ERROR then
1384: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1385: l_debug :=l_debug
1386: ||' exception 2 at process_batch_report_request. '||sqlerrm;
1387: x_request_id := x_request_id ||l_debug;

Line 1384: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1380: l_debug :=l_debug
1381: ||' exception 1 at process_batch_report_request. '||sqlerrm;
1382: x_request_id := x_request_id ||l_debug;
1383: when FND_API.G_EXC_UNEXPECTED_ERROR then
1384: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1385: l_debug :=l_debug
1386: ||' exception 2 at process_batch_report_request. '||sqlerrm;
1387: x_request_id := x_request_id ||l_debug;
1388: when others then

Line 1389: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1385: l_debug :=l_debug
1386: ||' exception 2 at process_batch_report_request. '||sqlerrm;
1387: x_request_id := x_request_id ||l_debug;
1388: when others then
1389: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1390: l_debug :=l_debug
1391: ||' exception 3 at process_batch_report_request. '||sqlerrm;
1392: x_request_id := x_request_id ||l_debug;
1393: l_error_tbl_p := l_error_tbl;

Line 1467: when FND_API.G_EXC_ERROR then

1463: --p_request_id := p_request_id||l_debug_text;
1464: p_request_id := l_request_id;
1465:
1466: EXCEPTION
1467: when FND_API.G_EXC_ERROR then
1468: l_return_status := FND_API.G_RET_STS_ERROR ;
1469: BIS_UTILITIES_PUB.put_line(p_text =>'process_parameter_set exception1: '||sqlerrm);
1470: p_request_id := l_request_id
1471: ||' exception 1 in process_parameter_set ';

Line 1468: l_return_status := FND_API.G_RET_STS_ERROR ;

1464: p_request_id := l_request_id;
1465:
1466: EXCEPTION
1467: when FND_API.G_EXC_ERROR then
1468: l_return_status := FND_API.G_RET_STS_ERROR ;
1469: BIS_UTILITIES_PUB.put_line(p_text =>'process_parameter_set exception1: '||sqlerrm);
1470: p_request_id := l_request_id
1471: ||' exception 1 in process_parameter_set ';
1472: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 1472: when FND_API.G_EXC_UNEXPECTED_ERROR then

1468: l_return_status := FND_API.G_RET_STS_ERROR ;
1469: BIS_UTILITIES_PUB.put_line(p_text =>'process_parameter_set exception1: '||sqlerrm);
1470: p_request_id := l_request_id
1471: ||' exception 1 in process_parameter_set ';
1472: when FND_API.G_EXC_UNEXPECTED_ERROR then
1473: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1474: p_request_id := l_request_id
1475: ||' exception 2 in process_parameter_set ';
1476: BIS_UTILITIES_PUB.put_line(p_text =>'process_parameter_set exception2: '||sqlerrm);

Line 1473: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1469: BIS_UTILITIES_PUB.put_line(p_text =>'process_parameter_set exception1: '||sqlerrm);
1470: p_request_id := l_request_id
1471: ||' exception 1 in process_parameter_set ';
1472: when FND_API.G_EXC_UNEXPECTED_ERROR then
1473: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1474: p_request_id := l_request_id
1475: ||' exception 2 in process_parameter_set ';
1476: BIS_UTILITIES_PUB.put_line(p_text =>'process_parameter_set exception2: '||sqlerrm);
1477: when others then

Line 1478: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1474: p_request_id := l_request_id
1475: ||' exception 2 in process_parameter_set ';
1476: BIS_UTILITIES_PUB.put_line(p_text =>'process_parameter_set exception2: '||sqlerrm);
1477: when others then
1478: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1479: p_request_id := l_request_id
1480: ||' exception 3 in process_parameter_set ';
1481: BIS_UTILITIES_PUB.put_line(p_text =>'process_parameter_set exception3: '||sqlerrm);
1482: l_error_tbl_p := l_error_tbl;

Line 1513: l_commit VARCHAR2(32000) := FND_API.G_TRUE;

1509: l_param_exist BOOLEAN := FALSE;
1510: l_request_id VARCHAR2(32000);
1511: l_debug VARCHAR2(32000);
1512: l_notifiers_code VARCHAR2(32000);
1513: l_commit VARCHAR2(32000) := FND_API.G_TRUE;
1514: l_Param_Set_Rec BIS_PMF_ALERT_REG_PUB.parameter_set_rec_type;
1515: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1516:
1517: BEGIN

Line 1587: when FND_API.G_EXC_ERROR then

1583: p_request_id := l_request_id||l_debug;
1584: --p_request_id := l_request_id;
1585:
1586: EXCEPTION
1587: when FND_API.G_EXC_ERROR then
1588: x_return_status := FND_API.G_RET_STS_ERROR ;
1589: x_return_status := ' exception 1 in Register_Parameter_Set '||sqlerrm;
1590: when FND_API.G_EXC_UNEXPECTED_ERROR then
1591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1588: x_return_status := FND_API.G_RET_STS_ERROR ;

1584: --p_request_id := l_request_id;
1585:
1586: EXCEPTION
1587: when FND_API.G_EXC_ERROR then
1588: x_return_status := FND_API.G_RET_STS_ERROR ;
1589: x_return_status := ' exception 1 in Register_Parameter_Set '||sqlerrm;
1590: when FND_API.G_EXC_UNEXPECTED_ERROR then
1591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1592: x_return_status := ' exception 2 in Register_Parameter_Set '||sqlerrm;

Line 1590: when FND_API.G_EXC_UNEXPECTED_ERROR then

1586: EXCEPTION
1587: when FND_API.G_EXC_ERROR then
1588: x_return_status := FND_API.G_RET_STS_ERROR ;
1589: x_return_status := ' exception 1 in Register_Parameter_Set '||sqlerrm;
1590: when FND_API.G_EXC_UNEXPECTED_ERROR then
1591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1592: x_return_status := ' exception 2 in Register_Parameter_Set '||sqlerrm;
1593: BIS_UTILITIES_PUB.put_line(p_text =>'register_parameter_set exception2: '||sqlerrm);
1594: when others then

Line 1591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1587: when FND_API.G_EXC_ERROR then
1588: x_return_status := FND_API.G_RET_STS_ERROR ;
1589: x_return_status := ' exception 1 in Register_Parameter_Set '||sqlerrm;
1590: when FND_API.G_EXC_UNEXPECTED_ERROR then
1591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1592: x_return_status := ' exception 2 in Register_Parameter_Set '||sqlerrm;
1593: BIS_UTILITIES_PUB.put_line(p_text =>'register_parameter_set exception2: '||sqlerrm);
1594: when others then
1595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1592: x_return_status := ' exception 2 in Register_Parameter_Set '||sqlerrm;
1593: BIS_UTILITIES_PUB.put_line(p_text =>'register_parameter_set exception2: '||sqlerrm);
1594: when others then
1595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1596: x_return_status := ' exception 3 in Register_Parameter_Set '||sqlerrm;
1597: BIS_UTILITIES_PUB.put_line(p_text =>'register_parameter_set exception3: '||sqlerrm);
1598: l_error_tbl := x_error_Tbl;
1599: BIS_UTILITIES_PVT.Add_Error_Message

Line 1665: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1661: END IF;
1662:
1663: x_request_id := l_request_id;
1664: --x_request_id := l_request_id||'--'||l_debug;
1665: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1666:
1667: EXCEPTION
1668: WHEN OTHERS THEN
1669: x_request_id := 'Exception while adding user. '||sqlerrm;

Line 1670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1666:
1667: EXCEPTION
1668: WHEN OTHERS THEN
1669: x_request_id := 'Exception while adding user. '||sqlerrm;
1670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1671: END Add_Subscribers;
1672:
1673: --
1674: -- Retrieve a All Target information for the given performance measure

Line 1740: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1736: END IF;
1737:
1738: BIS_UTILITIES_PUB.put_line(p_text => ' --------------------------------------------- ' );
1739:
1740: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1741: l_Measure_Rec.Measure_id := p_measure_id;
1742: BIS_TARGET_LEVEL_PVT.Retrieve_Target_Levels
1743: ( p_api_version => p_api_version
1744: , p_all_info => FND_API.G_FALSE

Line 1744: , p_all_info => FND_API.G_FALSE

1740: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1741: l_Measure_Rec.Measure_id := p_measure_id;
1742: BIS_TARGET_LEVEL_PVT.Retrieve_Target_Levels
1743: ( p_api_version => p_api_version
1744: , p_all_info => FND_API.G_FALSE
1745: , p_Measure_Rec => l_Measure_Rec
1746: , x_Target_Level_tbl => l_Target_Level_tbl
1747: , x_return_status => x_return_status
1748: , x_error_Tbl => x_error_Tbl

Line 1792: and (BIS_UTILITIES_PUB.Value_Missing(l_Dimension_Level_Rec.dimension_level_id) = FND_API.G_TRUE

1788: -- summary levels of the measure contains a time dim level which is equal to the time dim level passed in, then
1789: -- continue with using that to spawn child requests.
1790:
1791: IF p_time_dimension_level_id IS NULL or (l_is_total_time = TRUE
1792: and (BIS_UTILITIES_PUB.Value_Missing(l_Dimension_Level_Rec.dimension_level_id) = FND_API.G_TRUE
1793: or BIS_UTILITIES_PUB.Value_NULL(l_Dimension_Level_Rec.dimension_level_id)= FND_API.G_TRUE))
1794: OR l_Dimension_Level_Rec.dimension_level_id = p_time_dimension_level_id
1795: THEN
1796:

Line 1793: or BIS_UTILITIES_PUB.Value_NULL(l_Dimension_Level_Rec.dimension_level_id)= FND_API.G_TRUE))

1789: -- continue with using that to spawn child requests.
1790:
1791: IF p_time_dimension_level_id IS NULL or (l_is_total_time = TRUE
1792: and (BIS_UTILITIES_PUB.Value_Missing(l_Dimension_Level_Rec.dimension_level_id) = FND_API.G_TRUE
1793: or BIS_UTILITIES_PUB.Value_NULL(l_Dimension_Level_Rec.dimension_level_id)= FND_API.G_TRUE))
1794: OR l_Dimension_Level_Rec.dimension_level_id = p_time_dimension_level_id
1795: THEN
1796:
1797: BIS_UTILITIES_PUB.put_line(p_text => ' --------~~~~~~~~~~~~~~~~~~~~~~~~~~~~~-------- ' );

Line 1803: , p_all_info => FND_API.G_FALSE

1799:
1800: BIS_TARGET_PUB.Retrieve_targets
1801: ( p_api_version => p_api_version
1802: , p_Target_Level_Rec => l_Target_Level_tbl(i)
1803: , p_all_info => FND_API.G_FALSE
1804: , x_Target_tbl => l_Target_tbl_tmp
1805: , x_return_status => x_return_status
1806: , x_error_Tbl => x_error_Tbl
1807: );

Line 1955: when FND_API.G_EXC_ERROR then

1951: BIS_UTILITIES_PUB.put_line(p_text => ' Finish Retrieving target info ' );
1952: BIS_UTILITIES_PUB.put_line(p_text =>' ***************************************************** ');
1953:
1954: EXCEPTION
1955: when FND_API.G_EXC_ERROR then
1956: x_return_status := FND_API.G_RET_STS_ERROR ;
1957: BIS_UTILITIES_PUB.put_line(p_text =>'exception 1 at Retrieve_target_info: '||sqlerrm);
1958: when FND_API.G_EXC_UNEXPECTED_ERROR then
1959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1956: x_return_status := FND_API.G_RET_STS_ERROR ;

1952: BIS_UTILITIES_PUB.put_line(p_text =>' ***************************************************** ');
1953:
1954: EXCEPTION
1955: when FND_API.G_EXC_ERROR then
1956: x_return_status := FND_API.G_RET_STS_ERROR ;
1957: BIS_UTILITIES_PUB.put_line(p_text =>'exception 1 at Retrieve_target_info: '||sqlerrm);
1958: when FND_API.G_EXC_UNEXPECTED_ERROR then
1959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1960: BIS_UTILITIES_PUB.put_line(p_text =>'exception 2 at Retrieve_target_info: '||sqlerrm);

Line 1958: when FND_API.G_EXC_UNEXPECTED_ERROR then

1954: EXCEPTION
1955: when FND_API.G_EXC_ERROR then
1956: x_return_status := FND_API.G_RET_STS_ERROR ;
1957: BIS_UTILITIES_PUB.put_line(p_text =>'exception 1 at Retrieve_target_info: '||sqlerrm);
1958: when FND_API.G_EXC_UNEXPECTED_ERROR then
1959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1960: BIS_UTILITIES_PUB.put_line(p_text =>'exception 2 at Retrieve_target_info: '||sqlerrm);
1961: when others then
1962: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1955: when FND_API.G_EXC_ERROR then
1956: x_return_status := FND_API.G_RET_STS_ERROR ;
1957: BIS_UTILITIES_PUB.put_line(p_text =>'exception 1 at Retrieve_target_info: '||sqlerrm);
1958: when FND_API.G_EXC_UNEXPECTED_ERROR then
1959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1960: BIS_UTILITIES_PUB.put_line(p_text =>'exception 2 at Retrieve_target_info: '||sqlerrm);
1961: when others then
1962: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1963: BIS_UTILITIES_PUB.put_line(p_text =>'exception 3 at Retrieve_target_info: '||sqlerrm);

Line 1962: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1958: when FND_API.G_EXC_UNEXPECTED_ERROR then
1959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1960: BIS_UTILITIES_PUB.put_line(p_text =>'exception 2 at Retrieve_target_info: '||sqlerrm);
1961: when others then
1962: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1963: BIS_UTILITIES_PUB.put_line(p_text =>'exception 3 at Retrieve_target_info: '||sqlerrm);
1964: l_error_tbl := x_error_tbl;
1965: BIS_UTILITIES_PVT.Add_Error_Message
1966: ( p_error_msg_id => SQLCODE

Line 2083: x_return_status := FND_API.G_RET_STS_SUCCESS ;

2079: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieving target information 0002.'
2080: ||' , target level id: '||p_target_level_id
2081: ||', Curent row? '||p_current_row);
2082:
2083: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2084:
2085: l_Target_Level_Rec.Target_Level_id := p_Target_Level_id;
2086: l_Target_Level_rec_p := l_Target_Level_rec;
2087: BIS_TARGET_LEVEL_PVT.Retrieve_Target_Level

Line 2089: , p_all_info => FND_API.G_FALSE

2085: l_Target_Level_Rec.Target_Level_id := p_Target_Level_id;
2086: l_Target_Level_rec_p := l_Target_Level_rec;
2087: BIS_TARGET_LEVEL_PVT.Retrieve_Target_Level
2088: ( p_api_version => p_api_version
2089: , p_all_info => FND_API.G_FALSE
2090: , p_Target_Level_rec => l_Target_Level_rec_p
2091: , x_Target_Level_rec => l_Target_Level_rec
2092: , x_return_status => x_return_status
2093: , x_error_Tbl => x_error_Tbl

Line 2121: , p_all_info => FND_API.G_FALSE

2117:
2118: BIS_TARGET_PUB.Retrieve_targets
2119: ( p_api_version => p_api_version
2120: , p_Target_Level_Rec => l_Target_Level_rec
2121: , p_all_info => FND_API.G_FALSE
2122: , x_Target_tbl => l_Target_tbl_tmp
2123: , x_return_status => x_return_status
2124: , x_error_Tbl => x_error_Tbl
2125: );

Line 2172: when FND_API.G_EXC_ERROR then

2168: --x_target_tbl := l_target_tbl;
2169: BIS_UTILITIES_PUB.put_line(p_text =>'!!Number of targets retrieved: '||x_target_tbl.count);
2170:
2171: EXCEPTION
2172: when FND_API.G_EXC_ERROR then
2173: x_return_status := FND_API.G_RET_STS_ERROR ;
2174: BIS_UTILITIES_PUB.put_line(p_text =>'exception 1 at Retrieve_target_info: '||sqlerrm);
2175: when FND_API.G_EXC_UNEXPECTED_ERROR then
2176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2173: x_return_status := FND_API.G_RET_STS_ERROR ;

2169: BIS_UTILITIES_PUB.put_line(p_text =>'!!Number of targets retrieved: '||x_target_tbl.count);
2170:
2171: EXCEPTION
2172: when FND_API.G_EXC_ERROR then
2173: x_return_status := FND_API.G_RET_STS_ERROR ;
2174: BIS_UTILITIES_PUB.put_line(p_text =>'exception 1 at Retrieve_target_info: '||sqlerrm);
2175: when FND_API.G_EXC_UNEXPECTED_ERROR then
2176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2177: BIS_UTILITIES_PUB.put_line(p_text =>'exception 2 at Retrieve_target_info: '||sqlerrm);

Line 2175: when FND_API.G_EXC_UNEXPECTED_ERROR then

2171: EXCEPTION
2172: when FND_API.G_EXC_ERROR then
2173: x_return_status := FND_API.G_RET_STS_ERROR ;
2174: BIS_UTILITIES_PUB.put_line(p_text =>'exception 1 at Retrieve_target_info: '||sqlerrm);
2175: when FND_API.G_EXC_UNEXPECTED_ERROR then
2176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2177: BIS_UTILITIES_PUB.put_line(p_text =>'exception 2 at Retrieve_target_info: '||sqlerrm);
2178: when others then
2179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2172: when FND_API.G_EXC_ERROR then
2173: x_return_status := FND_API.G_RET_STS_ERROR ;
2174: BIS_UTILITIES_PUB.put_line(p_text =>'exception 1 at Retrieve_target_info: '||sqlerrm);
2175: when FND_API.G_EXC_UNEXPECTED_ERROR then
2176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2177: BIS_UTILITIES_PUB.put_line(p_text =>'exception 2 at Retrieve_target_info: '||sqlerrm);
2178: when others then
2179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2180: BIS_UTILITIES_PUB.put_line(p_text =>'exception 3 at Retrieve_target_info: '||sqlerrm);

Line 2179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2175: when FND_API.G_EXC_UNEXPECTED_ERROR then
2176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2177: BIS_UTILITIES_PUB.put_line(p_text =>'exception 2 at Retrieve_target_info: '||sqlerrm);
2178: when others then
2179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2180: BIS_UTILITIES_PUB.put_line(p_text =>'exception 3 at Retrieve_target_info: '||sqlerrm);
2181: l_error_tbl := x_error_Tbl;
2182: BIS_UTILITIES_PVT.Add_Error_Message
2183: ( p_error_msg_id => SQLCODE

Line 2211: x_return_status := FND_API.G_RET_STS_SUCCESS ;

2207: l_Org_Level_Value_ID VARCHAR2(40);
2208: l_Org_Short_Name VARCHAR2(80);
2209:
2210: BEGIN
2211: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2212: --l_target_tbl := x_target_tbl ;
2213:
2214: FOR j in 1..p_Target_tbl.COUNT
2215: LOOP

Line 2233: (BIS_UTILITIES_PUB.Value_Not_Missing( l_Org_Level_Value_ID ) = FND_API.G_TRUE)

2229: l_Org_Short_Name := l_Dim_Level_value_Rec.Dimension_Level_Short_Name;
2230:
2231: /*
2232: if (
2233: (BIS_UTILITIES_PUB.Value_Not_Missing( l_Org_Level_Value_ID ) = FND_API.G_TRUE)
2234: and (BIS_UTILITIES_PUB.Value_Not_Null( l_Org_Level_Value_ID ) = FND_API.G_TRUE)
2235: )
2236: then
2237: BIS_UTILITIES_PUB.put_line(p_text =>' Org level value id for prev tgt is: ' || l_Org_Level_Value_ID);

Line 2234: and (BIS_UTILITIES_PUB.Value_Not_Null( l_Org_Level_Value_ID ) = FND_API.G_TRUE)

2230:
2231: /*
2232: if (
2233: (BIS_UTILITIES_PUB.Value_Not_Missing( l_Org_Level_Value_ID ) = FND_API.G_TRUE)
2234: and (BIS_UTILITIES_PUB.Value_Not_Null( l_Org_Level_Value_ID ) = FND_API.G_TRUE)
2235: )
2236: then
2237: BIS_UTILITIES_PUB.put_line(p_text =>' Org level value id for prev tgt is: ' || l_Org_Level_Value_ID);
2238: else

Line 2243: (BIS_UTILITIES_PUB.Value_Not_Missing( l_Org_Short_Name ) = FND_API.G_TRUE)

2239: BIS_UTILITIES_PUB.put_line(p_text =>' Org level value id is prev tgt null/missing ' );
2240: end if;
2241:
2242: if (
2243: (BIS_UTILITIES_PUB.Value_Not_Missing( l_Org_Short_Name ) = FND_API.G_TRUE)
2244: and (BIS_UTILITIES_PUB.Value_Not_Null( l_Org_Short_Name ) = FND_API.G_TRUE)
2245: )
2246: then
2247: BIS_UTILITIES_PUB.put_line(p_text =>' Org short name is prev tgt: ' || l_Org_Short_Name );

Line 2244: and (BIS_UTILITIES_PUB.Value_Not_Null( l_Org_Short_Name ) = FND_API.G_TRUE)

2240: end if;
2241:
2242: if (
2243: (BIS_UTILITIES_PUB.Value_Not_Missing( l_Org_Short_Name ) = FND_API.G_TRUE)
2244: and (BIS_UTILITIES_PUB.Value_Not_Null( l_Org_Short_Name ) = FND_API.G_TRUE)
2245: )
2246: then
2247: BIS_UTILITIES_PUB.put_line(p_text =>' Org short name is prev tgt: ' || l_Org_Short_Name );
2248: else

Line 2282: if BIS_UTILITIES_PUB.Value_Missing(p_Target_tbl(j).target) = FND_API.G_TRUE

2278: ELSIF (p_target_tbl(j).is_pm_region = BIS_TARGET_PUB.G_IS_PM_REGION) THEN -- see Get_Current_Target
2279:
2280: -- BIS_UTILITIES_PUB.put_line(p_text => ' BISVARSB: this time level value is NOT PREVIOUS time period ' ) ;
2281:
2282: if BIS_UTILITIES_PUB.Value_Missing(p_Target_tbl(j).target) = FND_API.G_TRUE
2283: or BIS_UTILITIES_PUB.Value_NULL(p_Target_tbl(j).target)= FND_API.G_TRUE
2284: then
2285: l_target_count := l_target_tbl.COUNT+1;
2286:

Line 2283: or BIS_UTILITIES_PUB.Value_NULL(p_Target_tbl(j).target)= FND_API.G_TRUE

2279:
2280: -- BIS_UTILITIES_PUB.put_line(p_text => ' BISVARSB: this time level value is NOT PREVIOUS time period ' ) ;
2281:
2282: if BIS_UTILITIES_PUB.Value_Missing(p_Target_tbl(j).target) = FND_API.G_TRUE
2283: or BIS_UTILITIES_PUB.Value_NULL(p_Target_tbl(j).target)= FND_API.G_TRUE
2284: then
2285: l_target_count := l_target_tbl.COUNT+1;
2286:
2287: l_target_tbl(l_target_count) := p_target_tbl(j);

Line 2326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2322: x_target_tbl := l_target_tbl ;
2323:
2324: EXCEPTION
2325: when others then
2326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2327: BIS_UTILITIES_PUB.put_line(p_text =>'exception at Get_previous_Target: '||sqlerrm);
2328:
2329: END Get_Previous_Target;
2330:

Line 2354: x_return_status := FND_API.G_RET_STS_SUCCESS ;

2350:
2351:
2352: BEGIN
2353:
2354: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2355: --l_target_tbl := x_target_tbl ;
2356: --BIS_UTILITIES_PUB.put_line(p_text =>'Retrieving current target.');
2357:
2358: FOR j in 1..p_Target_tbl.COUNT

Line 2378: (BIS_UTILITIES_PUB.Value_Not_Missing( l_Org_Level_Value_ID ) = FND_API.G_TRUE)

2374: l_Org_Short_Name := l_Dim_Level_value_Rec.Dimension_Level_Short_Name;
2375:
2376: /*
2377: if (
2378: (BIS_UTILITIES_PUB.Value_Not_Missing( l_Org_Level_Value_ID ) = FND_API.G_TRUE)
2379: and (BIS_UTILITIES_PUB.Value_Not_Null( l_Org_Level_Value_ID ) = FND_API.G_TRUE)
2380: )
2381: then
2382: BIS_UTILITIES_PUB.put_line(p_text =>' Org level value id current target is: ' || l_Org_Level_Value_ID);

Line 2379: and (BIS_UTILITIES_PUB.Value_Not_Null( l_Org_Level_Value_ID ) = FND_API.G_TRUE)

2375:
2376: /*
2377: if (
2378: (BIS_UTILITIES_PUB.Value_Not_Missing( l_Org_Level_Value_ID ) = FND_API.G_TRUE)
2379: and (BIS_UTILITIES_PUB.Value_Not_Null( l_Org_Level_Value_ID ) = FND_API.G_TRUE)
2380: )
2381: then
2382: BIS_UTILITIES_PUB.put_line(p_text =>' Org level value id current target is: ' || l_Org_Level_Value_ID);
2383: else

Line 2388: (BIS_UTILITIES_PUB.Value_Not_Missing( l_Org_Short_Name ) = FND_API.G_TRUE)

2384: BIS_UTILITIES_PUB.put_line(p_text =>' Org level value id is current target null/missing ' );
2385: end if;
2386:
2387: if (
2388: (BIS_UTILITIES_PUB.Value_Not_Missing( l_Org_Short_Name ) = FND_API.G_TRUE)
2389: and (BIS_UTILITIES_PUB.Value_Not_Null( l_Org_Short_Name ) = FND_API.G_TRUE)
2390: )
2391: then
2392: BIS_UTILITIES_PUB.put_line(p_text =>' Org short name is current target : ' || l_Org_Short_Name );

Line 2389: and (BIS_UTILITIES_PUB.Value_Not_Null( l_Org_Short_Name ) = FND_API.G_TRUE)

2385: end if;
2386:
2387: if (
2388: (BIS_UTILITIES_PUB.Value_Not_Missing( l_Org_Short_Name ) = FND_API.G_TRUE)
2389: and (BIS_UTILITIES_PUB.Value_Not_Null( l_Org_Short_Name ) = FND_API.G_TRUE)
2390: )
2391: then
2392: BIS_UTILITIES_PUB.put_line(p_text =>' Org short name is current target : ' || l_Org_Short_Name );
2393: else

Line 2433: if BIS_UTILITIES_PUB.Value_Missing(p_Target_tbl(j).target) = FND_API.G_TRUE

2429:
2430: -- Following step is for the records retrieved
2431: -- from user_ind_selection table
2432:
2433: if BIS_UTILITIES_PUB.Value_Missing(p_Target_tbl(j).target) = FND_API.G_TRUE
2434: or BIS_UTILITIES_PUB.Value_NULL(p_Target_tbl(j).target)= FND_API.G_TRUE
2435: then
2436: l_target_count := l_target_tbl.COUNT+1;
2437:

Line 2434: or BIS_UTILITIES_PUB.Value_NULL(p_Target_tbl(j).target)= FND_API.G_TRUE

2430: -- Following step is for the records retrieved
2431: -- from user_ind_selection table
2432:
2433: if BIS_UTILITIES_PUB.Value_Missing(p_Target_tbl(j).target) = FND_API.G_TRUE
2434: or BIS_UTILITIES_PUB.Value_NULL(p_Target_tbl(j).target)= FND_API.G_TRUE
2435: then
2436: l_target_count := l_target_tbl.COUNT+1;
2437:
2438: l_target_tbl(l_target_count) := p_target_tbl(j);

Line 2479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2475: x_target_tbl := l_target_tbl ;
2476:
2477: EXCEPTION
2478: when others then
2479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2480: BIS_UTILITIES_PUB.put_line(p_text =>'exception at Get_current_Target: '||sqlerrm);
2481:
2482: END Get_current_Target;
2483:

Line 2504: x_return_status := FND_API.G_RET_STS_SUCCESS ;

2500: l_target_count NUMBER := 1;
2501:
2502: BEGIN
2503:
2504: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2505: --l_target_tbl := x_target_tbl ;
2506: BIS_UTILITIES_PUB.put_line(p_text =>'Total Record in ' || p_Target_tbl.count);
2507:
2508: FOR j in 1..p_Target_tbl.COUNT

Line 2530: ((BIS_UTILITIES_PUB.Value_Missing(p_Target_tbl(j).target) = FND_API.G_TRUE) OR (BIS_UTILITIES_PUB.Value_NULL(p_Target_tbl(j).target)= FND_API.G_TRUE)) ) THEN

2526: BIS_UTILITIES_PUB.put_line(p_text =>'OLTP Total Time ');
2527: end if;
2528: -- Explained in Get_Current_Target() above.
2529: IF ( (p_Target_tbl(j).is_pm_region = BIS_TARGET_PUB.G_IS_PM_REGION) AND
2530: ((BIS_UTILITIES_PUB.Value_Missing(p_Target_tbl(j).target) = FND_API.G_TRUE) OR (BIS_UTILITIES_PUB.Value_NULL(p_Target_tbl(j).target)= FND_API.G_TRUE)) ) THEN
2531:
2532: l_target_count := l_target_tbl.COUNT+1;
2533:
2534: l_target_tbl(l_target_count) := p_target_tbl(j);

Line 2575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2571: BIS_UTILITIES_PUB.put_line(p_text =>'Total Record out NOCOPY ' || x_Target_tbl.count);
2572:
2573: EXCEPTION
2574: when others then
2575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2576: BIS_UTILITIES_PUB.put_line(p_text =>'exception at Get_current_Target: '||sqlerrm);
2577:
2578: END update_total_time;
2579:

Line 2685: , p_all_info => FND_API.G_FALSE

2681: l_measure_rec_p := l_measure_rec;
2682: BIS_MEASURE_PUB.Retrieve_Measure
2683: ( p_api_version => l_api_version
2684: , p_measure_rec => l_measure_rec_p
2685: , p_all_info => FND_API.G_FALSE
2686: , x_Measure_rec => l_measure_rec
2687: , x_return_status => l_return_status
2688: , x_error_Tbl => l_error_tbl
2689: );

Line 2782: when FND_API.G_EXC_ERROR then

2778:
2779: p_request_id := l_submit_result;
2780:
2781: EXCEPTION
2782: when FND_API.G_EXC_ERROR then
2783: l_return_status := FND_API.G_RET_STS_ERROR ;
2784: p_request_id := l_request_id
2785: ||' exception 1 in submit_conc_request '||sqlerrm;
2786: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 2783: l_return_status := FND_API.G_RET_STS_ERROR ;

2779: p_request_id := l_submit_result;
2780:
2781: EXCEPTION
2782: when FND_API.G_EXC_ERROR then
2783: l_return_status := FND_API.G_RET_STS_ERROR ;
2784: p_request_id := l_request_id
2785: ||' exception 1 in submit_conc_request '||sqlerrm;
2786: when FND_API.G_EXC_UNEXPECTED_ERROR then
2787: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2786: when FND_API.G_EXC_UNEXPECTED_ERROR then

2782: when FND_API.G_EXC_ERROR then
2783: l_return_status := FND_API.G_RET_STS_ERROR ;
2784: p_request_id := l_request_id
2785: ||' exception 1 in submit_conc_request '||sqlerrm;
2786: when FND_API.G_EXC_UNEXPECTED_ERROR then
2787: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2788: p_request_id := l_request_id
2789: ||' exception 2 in submit_conc_request '||sqlerrm;
2790: when others then

Line 2787: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2783: l_return_status := FND_API.G_RET_STS_ERROR ;
2784: p_request_id := l_request_id
2785: ||' exception 1 in submit_conc_request '||sqlerrm;
2786: when FND_API.G_EXC_UNEXPECTED_ERROR then
2787: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2788: p_request_id := l_request_id
2789: ||' exception 2 in submit_conc_request '||sqlerrm;
2790: when others then
2791: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2791: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2787: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2788: p_request_id := l_request_id
2789: ||' exception 2 in submit_conc_request '||sqlerrm;
2790: when others then
2791: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2792: p_request_id := l_request_id
2793: ||' exception 3 in submit_conc_request '||sqlerrm;
2794: l_error_tbl_p := l_error_tbl;
2795: BIS_UTILITIES_PVT.Add_Error_Message

Line 2838: when FND_API.G_EXC_ERROR then

2834:
2835: BIS_UTILITIES_PUB.put_line(p_text =>'submitting report data concurrent request');
2836:
2837: EXCEPTION
2838: when FND_API.G_EXC_ERROR then
2839: BIS_UTILITIES_PUB.put_line(p_text =>'exception 1 in submit_Concurrent_Request');
2840: when FND_API.G_EXC_UNEXPECTED_ERROR then
2841: BIS_UTILITIES_PUB.put_line(p_text =>'exception 2 in submit_Concurrent_Request');
2842: when others then

Line 2840: when FND_API.G_EXC_UNEXPECTED_ERROR then

2836:
2837: EXCEPTION
2838: when FND_API.G_EXC_ERROR then
2839: BIS_UTILITIES_PUB.put_line(p_text =>'exception 1 in submit_Concurrent_Request');
2840: when FND_API.G_EXC_UNEXPECTED_ERROR then
2841: BIS_UTILITIES_PUB.put_line(p_text =>'exception 2 in submit_Concurrent_Request');
2842: when others then
2843: BIS_UTILITIES_PUB.put_line(p_text =>'exception 3 submit_Concurrent_Request: '||sqlerrm);
2844:

Line 2892: , p_all_info => FND_API.G_FALSE

2888: l_Measure_Rec.Measure_id := p_measure_id;
2889:
2890: BIS_TARGET_LEVEL_PVT.Retrieve_Target_Levels
2891: ( p_api_version => 1.0
2892: , p_all_info => FND_API.G_FALSE
2893: , p_Measure_Rec => l_Measure_Rec
2894: , x_Target_Level_tbl => l_Target_Level_tbl_tmp
2895: , x_return_status => l_return_status
2896: , x_error_Tbl => l_error_Tbl

Line 2921: = FND_API.G_TRUE

2917: , x_Target_Level_rec => l_Target_Level_rec
2918: );
2919:
2920: IF BIS_UTILITIES_PUB.Value_NOT_Missing(l_Target_Level_rec.Target_Level_ID)
2921: = FND_API.G_TRUE
2922: AND BIS_UTILITIES_PUB.Value_NOT_Null(l_Target_Level_rec.Target_Level_ID)
2923: = FND_API.G_TRUE
2924: THEN
2925: l_Target_Level_tbl(l_Target_Level_tbl.COUNT+1) := l_Target_Level_rec;

Line 2923: = FND_API.G_TRUE

2919:
2920: IF BIS_UTILITIES_PUB.Value_NOT_Missing(l_Target_Level_rec.Target_Level_ID)
2921: = FND_API.G_TRUE
2922: AND BIS_UTILITIES_PUB.Value_NOT_Null(l_Target_Level_rec.Target_Level_ID)
2923: = FND_API.G_TRUE
2924: THEN
2925: l_Target_Level_tbl(l_Target_Level_tbl.COUNT+1) := l_Target_Level_rec;
2926: BIS_UTILITIES_PUB.put_line(p_text =>'Verified target level: '
2927: ||l_Target_Level_tbl(l_Target_Level_tbl.COUNT).Target_level_id);

Line 2969: = FND_API.G_TRUE

2965: );
2966: BIS_UTILITIES_PUB.put_line(p_text =>'AFTER Verify: '||l_Target_rec.Target_level_id);
2967:
2968: IF BIS_UTILITIES_PUB.Value_NOT_Missing(l_Target_rec.Target_Level_ID)
2969: = FND_API.G_TRUE
2970: AND BIS_UTILITIES_PUB.Value_NOT_Null(l_Target_rec.Target_Level_ID)
2971: = FND_API.G_TRUE
2972: THEN
2973: l_Target_tbl(l_Target_tbl.COUNT+1) := l_Target_rec;

Line 2971: = FND_API.G_TRUE

2967:
2968: IF BIS_UTILITIES_PUB.Value_NOT_Missing(l_Target_rec.Target_Level_ID)
2969: = FND_API.G_TRUE
2970: AND BIS_UTILITIES_PUB.Value_NOT_Null(l_Target_rec.Target_Level_ID)
2971: = FND_API.G_TRUE
2972: THEN
2973: l_Target_tbl(l_Target_tbl.COUNT+1) := l_Target_rec;
2974: BIS_UTILITIES_PUB.put_line(p_text =>'Verified target: '
2975: ||l_Target_tbl(l_Target_tbl.COUNT).Target_level_id);

Line 2989: when FND_API.G_EXC_ERROR then

2985: x_target_level_tbl := l_target_level_tbl;
2986: x_target_tbl := l_target_tbl;
2987:
2988: EXCEPTION
2989: when FND_API.G_EXC_ERROR then
2990: BIS_UTILITIES_PUB.put_line(p_text =>'exception 1 in Retrieve_Report_Info');
2991: when FND_API.G_EXC_UNEXPECTED_ERROR then
2992: BIS_UTILITIES_PUB.put_line(p_text =>'exception 2 in Retrieve_Report_Info');
2993: when others then

Line 2991: when FND_API.G_EXC_UNEXPECTED_ERROR then

2987:
2988: EXCEPTION
2989: when FND_API.G_EXC_ERROR then
2990: BIS_UTILITIES_PUB.put_line(p_text =>'exception 1 in Retrieve_Report_Info');
2991: when FND_API.G_EXC_UNEXPECTED_ERROR then
2992: BIS_UTILITIES_PUB.put_line(p_text =>'exception 2 in Retrieve_Report_Info');
2993: when others then
2994: BIS_UTILITIES_PUB.put_line(p_text =>'exception 3 in Retrieve_Report_Info: '||sqlerrm);
2995:

Line 3096: when FND_API.G_EXC_ERROR then

3092: x_Concurrent_Request_rec := l_Concurrent_Request_rec;
3093: BIS_UTILITIES_PUB.put_line(p_text =>'Request successfully formed.');
3094:
3095: EXCEPTION
3096: when FND_API.G_EXC_ERROR then
3097: BIS_UTILITIES_PUB.put_line(p_text =>'form conc req 1');
3098: when FND_API.G_EXC_UNEXPECTED_ERROR then
3099: BIS_UTILITIES_PUB.put_line(p_text =>'form conc req 2');
3100: when others then

Line 3098: when FND_API.G_EXC_UNEXPECTED_ERROR then

3094:
3095: EXCEPTION
3096: when FND_API.G_EXC_ERROR then
3097: BIS_UTILITIES_PUB.put_line(p_text =>'form conc req 1');
3098: when FND_API.G_EXC_UNEXPECTED_ERROR then
3099: BIS_UTILITIES_PUB.put_line(p_text =>'form conc req 2');
3100: when others then
3101: BIS_UTILITIES_PUB.put_line(p_text =>'form conc req 3: '||SQLERRM);
3102: BIS_UTILITIES_PVT.Add_Error_Message

Line 3288: when FND_API.G_EXC_ERROR then

3284: END LOOP;
3285: x_parameter_set_tbl := l_param_set_tbl;
3286:
3287: EXCEPTION
3288: when FND_API.G_EXC_ERROR then
3289: BIS_UTILITIES_PUB.put_line(p_text =>'form_parameter_set exception1: '||sqlerrm);
3290: when FND_API.G_EXC_UNEXPECTED_ERROR then
3291: BIS_UTILITIES_PUB.put_line(p_text =>'form_parameter_set exception2: '||sqlerrm);
3292: when others then

Line 3290: when FND_API.G_EXC_UNEXPECTED_ERROR then

3286:
3287: EXCEPTION
3288: when FND_API.G_EXC_ERROR then
3289: BIS_UTILITIES_PUB.put_line(p_text =>'form_parameter_set exception1: '||sqlerrm);
3290: when FND_API.G_EXC_UNEXPECTED_ERROR then
3291: BIS_UTILITIES_PUB.put_line(p_text =>'form_parameter_set exception2: '||sqlerrm);
3292: when others then
3293: BIS_UTILITIES_PUB.put_line(p_text =>'form_parameter_set exception3: '||sqlerrm);
3294: l_error_tbl_p := l_error_tbl;

Line 3435: , p_all_info => FND_API.G_FALSE

3431: l_Target_Level_rec.Dimension1_Level_Id := l_viewby_level_id;
3432: l_Target_Level_rec_p := l_Target_Level_rec;
3433: BIS_TARGET_LEVEL_PVT.Retrieve_Target_Level
3434: ( p_api_version => 1.0
3435: , p_all_info => FND_API.G_FALSE
3436: , p_Target_Level_rec => l_Target_Level_rec_p
3437: , x_Target_Level_rec => l_Target_Level_rec
3438: , x_return_status => l_return_status
3439: , x_error_Tbl => l_error_Tbl

Line 3446: , p_all_info => FND_API.G_FALSE

3442: l_Target_Level_rec.Dimension2_Level_Id := l_viewby_level_id;
3443: l_Target_Level_rec_p := l_Target_Level_rec;
3444: BIS_TARGET_LEVEL_PVT.Retrieve_Target_Level
3445: ( p_api_version => 1.0
3446: , p_all_info => FND_API.G_FALSE
3447: , p_Target_Level_rec => l_Target_Level_rec_p
3448: , x_Target_Level_rec => l_Target_Level_rec
3449: , x_return_status => l_return_status
3450: , x_error_Tbl => l_error_Tbl

Line 3457: , p_all_info => FND_API.G_FALSE

3453: l_Target_Level_rec.Dimension3_Level_Id := l_viewby_level_id;
3454: l_Target_Level_rec_p := l_Target_Level_rec;
3455: BIS_TARGET_LEVEL_PVT.Retrieve_Target_Level
3456: ( p_api_version => 1.0
3457: , p_all_info => FND_API.G_FALSE
3458: , p_Target_Level_rec => l_Target_Level_rec_p
3459: , x_Target_Level_rec => l_Target_Level_rec
3460: , x_return_status => l_return_status
3461: , x_error_Tbl => l_error_Tbl

Line 3468: , p_all_info => FND_API.G_FALSE

3464: l_Target_Level_rec.Dimension4_Level_Id := l_viewby_level_id;
3465: l_Target_Level_rec_p := l_Target_Level_rec;
3466: BIS_TARGET_LEVEL_PVT.Retrieve_Target_Level
3467: ( p_api_version => 1.0
3468: , p_all_info => FND_API.G_FALSE
3469: , p_Target_Level_rec => l_Target_Level_rec_p
3470: , x_Target_Level_rec => l_Target_Level_rec
3471: , x_return_status => l_return_status
3472: , x_error_Tbl => l_error_Tbl

Line 3479: , p_all_info => FND_API.G_FALSE

3475: l_Target_Level_rec.Dimension5_Level_Id := l_viewby_level_id;
3476: l_Target_Level_rec_p := l_Target_Level_rec;
3477: BIS_TARGET_LEVEL_PVT.Retrieve_Target_Level
3478: ( p_api_version => 1.0
3479: , p_all_info => FND_API.G_FALSE
3480: , p_Target_Level_rec => l_Target_Level_rec_p
3481: , x_Target_Level_rec => l_Target_Level_rec
3482: , x_return_status => l_return_status
3483: , x_error_Tbl => l_error_Tbl

Line 3490: , p_all_info => FND_API.G_FALSE

3486: l_Target_Level_rec.Dimension6_Level_Id := l_viewby_level_id;
3487: l_Target_Level_rec_p := l_Target_Level_rec;
3488: BIS_TARGET_LEVEL_PVT.Retrieve_Target_Level
3489: ( p_api_version => 1.0
3490: , p_all_info => FND_API.G_FALSE
3491: , p_Target_Level_rec => l_Target_Level_rec_p
3492: , x_Target_Level_rec => l_Target_Level_rec
3493: , x_return_status => l_return_status
3494: , x_error_Tbl => l_error_Tbl

Line 3501: , p_all_info => FND_API.G_FALSE

3497: l_Target_Level_rec.Dimension7_Level_Id := l_viewby_level_id;
3498: l_Target_Level_rec_p := l_Target_Level_rec;
3499: BIS_TARGET_LEVEL_PVT.Retrieve_Target_Level
3500: ( p_api_version => 1.0
3501: , p_all_info => FND_API.G_FALSE
3502: , p_Target_Level_rec => l_Target_Level_rec_p
3503: , x_Target_Level_rec => l_Target_Level_rec
3504: , x_return_status => l_return_status
3505: , x_error_Tbl => l_error_Tbl

Line 3516: when FND_API.G_EXC_ERROR then

3512:
3513: x_Target_Level_rec := l_Target_Level_rec;
3514:
3515: EXCEPTION
3516: when FND_API.G_EXC_ERROR then
3517: BIS_UTILITIES_PUB.put_line(p_text =>'Verify_Target_Level exception1: '||sqlerrm);
3518: when FND_API.G_EXC_UNEXPECTED_ERROR then
3519: BIS_UTILITIES_PUB.put_line(p_text =>'Verify_Target_Level exception2: '||sqlerrm);
3520: when others then

Line 3518: when FND_API.G_EXC_UNEXPECTED_ERROR then

3514:
3515: EXCEPTION
3516: when FND_API.G_EXC_ERROR then
3517: BIS_UTILITIES_PUB.put_line(p_text =>'Verify_Target_Level exception1: '||sqlerrm);
3518: when FND_API.G_EXC_UNEXPECTED_ERROR then
3519: BIS_UTILITIES_PUB.put_line(p_text =>'Verify_Target_Level exception2: '||sqlerrm);
3520: when others then
3521: BIS_UTILITIES_PUB.put_line(p_text =>'Verify_Target_Level exception3: '||sqlerrm);
3522: l_error_Tbl_p := l_error_Tbl;

Line 3602: = FND_API.G_TRUE

3598: BIS_UTILITIES_PUB.put_line(p_text =>'in verify DIM LEV. Pdim3: '||p_parameter3_level);
3599: */
3600:
3601: IF ((BIS_UTILITIES_PUB.Value_Null(p_Target_Level_rec.Dimension1_Level_id)
3602: = FND_API.G_TRUE
3603: AND p_parameter1_level IS NULL)
3604: OR p_Target_Level_rec.Dimension1_Level_Id = TO_NUMBER(p_parameter1_level))
3605: AND ((BIS_UTILITIES_PUB.Value_Null(p_Target_Level_rec.Dimension2_Level_id)
3606: = FND_API.G_TRUE

Line 3606: = FND_API.G_TRUE

3602: = FND_API.G_TRUE
3603: AND p_parameter1_level IS NULL)
3604: OR p_Target_Level_rec.Dimension1_Level_Id = TO_NUMBER(p_parameter1_level))
3605: AND ((BIS_UTILITIES_PUB.Value_Null(p_Target_Level_rec.Dimension2_Level_id)
3606: = FND_API.G_TRUE
3607: AND p_parameter2_level IS NULL)
3608: OR p_Target_Level_rec.Dimension2_Level_Id = TO_NUMBER(p_parameter2_level))
3609: AND ((BIS_UTILITIES_PUB.Value_Null(p_Target_Level_rec.Dimension3_Level_id)
3610: = FND_API.G_TRUE

Line 3610: = FND_API.G_TRUE

3606: = FND_API.G_TRUE
3607: AND p_parameter2_level IS NULL)
3608: OR p_Target_Level_rec.Dimension2_Level_Id = TO_NUMBER(p_parameter2_level))
3609: AND ((BIS_UTILITIES_PUB.Value_Null(p_Target_Level_rec.Dimension3_Level_id)
3610: = FND_API.G_TRUE
3611: AND p_parameter3_level IS NULL)
3612: OR p_Target_Level_rec.Dimension3_Level_Id = TO_NUMBER(p_parameter3_level))
3613: AND ((BIS_UTILITIES_PUB.Value_Null(p_Target_Level_rec.Dimension4_Level_id)
3614: = FND_API.G_TRUE

Line 3614: = FND_API.G_TRUE

3610: = FND_API.G_TRUE
3611: AND p_parameter3_level IS NULL)
3612: OR p_Target_Level_rec.Dimension3_Level_Id = TO_NUMBER(p_parameter3_level))
3613: AND ((BIS_UTILITIES_PUB.Value_Null(p_Target_Level_rec.Dimension4_Level_id)
3614: = FND_API.G_TRUE
3615: AND p_parameter4_level IS NULL)
3616: OR p_Target_Level_rec.Dimension4_Level_Id = TO_NUMBER(p_parameter4_level))
3617: AND ((BIS_UTILITIES_PUB.Value_Null(p_Target_Level_rec.Dimension5_Level_id)
3618: = FND_API.G_TRUE

Line 3618: = FND_API.G_TRUE

3614: = FND_API.G_TRUE
3615: AND p_parameter4_level IS NULL)
3616: OR p_Target_Level_rec.Dimension4_Level_Id = TO_NUMBER(p_parameter4_level))
3617: AND ((BIS_UTILITIES_PUB.Value_Null(p_Target_Level_rec.Dimension5_Level_id)
3618: = FND_API.G_TRUE
3619: AND p_parameter5_level IS NULL)
3620: OR p_Target_Level_rec.Dimension5_Level_Id = TO_NUMBER(p_parameter5_level))
3621: AND ((BIS_UTILITIES_PUB.Value_Null(p_Target_Level_rec.Dimension6_Level_id)
3622: = FND_API.G_TRUE

Line 3622: = FND_API.G_TRUE

3618: = FND_API.G_TRUE
3619: AND p_parameter5_level IS NULL)
3620: OR p_Target_Level_rec.Dimension5_Level_Id = TO_NUMBER(p_parameter5_level))
3621: AND ((BIS_UTILITIES_PUB.Value_Null(p_Target_Level_rec.Dimension6_Level_id)
3622: = FND_API.G_TRUE
3623: AND p_parameter6_level IS NULL)
3624: OR p_Target_Level_rec.Dimension6_Level_Id = TO_NUMBER(p_parameter6_level))
3625: AND ((BIS_UTILITIES_PUB.Value_Null(p_Target_Level_rec.Dimension7_Level_id)
3626: = FND_API.G_TRUE

Line 3626: = FND_API.G_TRUE

3622: = FND_API.G_TRUE
3623: AND p_parameter6_level IS NULL)
3624: OR p_Target_Level_rec.Dimension6_Level_Id = TO_NUMBER(p_parameter6_level))
3625: AND ((BIS_UTILITIES_PUB.Value_Null(p_Target_Level_rec.Dimension7_Level_id)
3626: = FND_API.G_TRUE
3627: AND p_parameter7_level IS NULL)
3628: OR p_Target_Level_rec.Dimension7_Level_Id = TO_NUMBER(p_parameter7_level))
3629: THEN
3630: RETURN TRUE;