DBA Data[Home] [Help]

APPS.BIS_ALERT_SERVICE_PVT dependencies on FND_API

Line 277: when FND_API.G_EXC_ERROR then

273: , x_retcode => RETCODE
274: );
275:
276: EXCEPTION
277: when FND_API.G_EXC_ERROR then
278: RETCODE := 1;
279: ERRBUF := SQLERRM;
280: BIS_UTILITIES_PUB.put_line(p_text =>'service alert req error 1');
281: RETURN;

Line 282: when FND_API.G_EXC_UNEXPECTED_ERROR then

278: RETCODE := 1;
279: ERRBUF := SQLERRM;
280: BIS_UTILITIES_PUB.put_line(p_text =>'service alert req error 1');
281: RETURN;
282: when FND_API.G_EXC_UNEXPECTED_ERROR then
283: RETCODE := 1;
284: ERRBUF := SQLERRM;
285: BIS_UTILITIES_PUB.put_line(p_text =>'service alert req error 2');
286: RETURN;

Line 432: when FND_API.G_EXC_ERROR then

428:
429: BIS_UTILITIES_PUB.put_line(p_text => ' ------- End log file for SONAR child request. ------- ');
430:
431: EXCEPTION
432: when FND_API.G_EXC_ERROR then
433: RETCODE := 1;
434: ERRBUF := SQLERRM;
435: RETURN;
436: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 436: when FND_API.G_EXC_UNEXPECTED_ERROR then

432: when FND_API.G_EXC_ERROR then
433: RETCODE := 1;
434: ERRBUF := SQLERRM;
435: RETURN;
436: when FND_API.G_EXC_UNEXPECTED_ERROR then
437: RETCODE := 1;
438: ERRBUF := SQLERRM;
439: RETURN;
440: when others then

Line 468: when FND_API.G_EXC_ERROR then

464: , p_alert_level => p_alert_level
465: );
466:
467: EXCEPTION
468: when FND_API.G_EXC_ERROR then
469: RETURN;
470: when FND_API.G_EXC_UNEXPECTED_ERROR then
471: RETURN;
472: when others then

Line 470: when FND_API.G_EXC_UNEXPECTED_ERROR then

466:
467: EXCEPTION
468: when FND_API.G_EXC_ERROR then
469: RETURN;
470: when FND_API.G_EXC_UNEXPECTED_ERROR then
471: RETURN;
472: when others then
473: BIS_UTILITIES_PVT.Add_Error_Message
474: ( p_error_msg_id => SQLCODE

Line 499: when FND_API.G_EXC_ERROR then

495:
496: null;
497:
498: EXCEPTION
499: when FND_API.G_EXC_ERROR then
500: RETURN;
501: when FND_API.G_EXC_UNEXPECTED_ERROR then
502: RETURN;
503: when others then

Line 501: when FND_API.G_EXC_UNEXPECTED_ERROR then

497:
498: EXCEPTION
499: when FND_API.G_EXC_ERROR then
500: RETURN;
501: when FND_API.G_EXC_UNEXPECTED_ERROR then
502: RETURN;
503: when others then
504: BIS_UTILITIES_PVT.Add_Error_Message
505: ( p_error_msg_id => SQLCODE

Line 646: when FND_API.G_EXC_ERROR then

642: BIS_UTILITIES_PUB.put_line(p_text =>'Number of request successfully formed: '
643: ||x_Concurrent_Request_Tbl.COUNT);
644:
645: EXCEPTION
646: when FND_API.G_EXC_ERROR then
647: BIS_UTILITIES_PUB.put_line(p_text =>'form conc req 1');
648: when FND_API.G_EXC_UNEXPECTED_ERROR then
649: BIS_UTILITIES_PUB.put_line(p_text =>'form conc req 2');
650: when others then

Line 648: when FND_API.G_EXC_UNEXPECTED_ERROR then

644:
645: EXCEPTION
646: when FND_API.G_EXC_ERROR then
647: BIS_UTILITIES_PUB.put_line(p_text =>'form conc req 1');
648: when FND_API.G_EXC_UNEXPECTED_ERROR then
649: BIS_UTILITIES_PUB.put_line(p_text =>'form conc req 2');
650: when others then
651: BIS_UTILITIES_PUB.put_line(p_text =>'form conc req 3: '||SQLERRM);
652: BIS_UTILITIES_PVT.Add_Error_Message

Line 790: when FND_API.G_EXC_ERROR then

786: x_measure_instance := l_measure_instance;
787: x_Dim_Level_Value_Tbl := l_Dim_Level_Value_Tbl;
788:
789: EXCEPTION
790: when FND_API.G_EXC_ERROR then
791: RETURN;
792: when FND_API.G_EXC_UNEXPECTED_ERROR then
793: RETURN;
794: when others then

Line 792: when FND_API.G_EXC_UNEXPECTED_ERROR then

788:
789: EXCEPTION
790: when FND_API.G_EXC_ERROR then
791: RETURN;
792: when FND_API.G_EXC_UNEXPECTED_ERROR then
793: RETURN;
794: when others then
795: BIS_UTILITIES_PVT.Add_Error_Message
796: ( p_error_msg_id => SQLCODE

Line 862: when FND_API.G_EXC_ERROR then

858:
859: null;
860:
861: EXCEPTION
862: when FND_API.G_EXC_ERROR then
863: RETURN;
864: when FND_API.G_EXC_UNEXPECTED_ERROR then
865: RETURN;
866: when others then

Line 864: when FND_API.G_EXC_UNEXPECTED_ERROR then

860:
861: EXCEPTION
862: when FND_API.G_EXC_ERROR then
863: RETURN;
864: when FND_API.G_EXC_UNEXPECTED_ERROR then
865: RETURN;
866: when others then
867: BIS_UTILITIES_PVT.Add_Error_Message
868: ( p_error_msg_id => SQLCODE

Line 1074: IF l_request_scheduled = FND_API.G_TRUE THEN

1070: --||'Manage_Alert_Registration Measure: '||l_request_scheduled
1071: --||' , '||l_return_status;
1072: BIS_UTILITIES_PUB.put_line(p_text =>'after manag: '||l_debug_text);
1073:
1074: IF l_request_scheduled = FND_API.G_TRUE THEN
1075: BIS_UTILITIES_PUB.put_line(p_text =>'Request exist');
1076: l_debug_text := l_debug_text ||': '
1077: ||BIS_PMF_REG_SERVICE_PVT.G_REQUEST_EXIST;
1078: l_request_id := BIS_PMF_REG_SERVICE_PVT.G_REQUEST_EXIST;

Line 1166: when FND_API.G_EXC_ERROR then

1162: BIS_UTILITIES_PUB.put_line(p_text =>'Total number of requests to be submitted: '
1163: ||x_Alert_request_Tbl.count);
1164:
1165: EXCEPTION
1166: when FND_API.G_EXC_ERROR then
1167: x_return_status := FND_API.G_RET_STS_ERROR ;
1168: BIS_UTILITIES_PUB.put_line(p_text =>'Exception at Retrieve_All_Request_Rows: '||sqlerrm);
1169: when FND_API.G_EXC_UNEXPECTED_ERROR then
1170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1167: x_return_status := FND_API.G_RET_STS_ERROR ;

1163: ||x_Alert_request_Tbl.count);
1164:
1165: EXCEPTION
1166: when FND_API.G_EXC_ERROR then
1167: x_return_status := FND_API.G_RET_STS_ERROR ;
1168: BIS_UTILITIES_PUB.put_line(p_text =>'Exception at Retrieve_All_Request_Rows: '||sqlerrm);
1169: when FND_API.G_EXC_UNEXPECTED_ERROR then
1170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1171: BIS_UTILITIES_PUB.put_line(p_text =>'Exception at Retrieve_All_Request_Rows: '||sqlerrm);

Line 1169: when FND_API.G_EXC_UNEXPECTED_ERROR then

1165: EXCEPTION
1166: when FND_API.G_EXC_ERROR then
1167: x_return_status := FND_API.G_RET_STS_ERROR ;
1168: BIS_UTILITIES_PUB.put_line(p_text =>'Exception at Retrieve_All_Request_Rows: '||sqlerrm);
1169: when FND_API.G_EXC_UNEXPECTED_ERROR then
1170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1171: BIS_UTILITIES_PUB.put_line(p_text =>'Exception at Retrieve_All_Request_Rows: '||sqlerrm);
1172: when others then
1173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1166: when FND_API.G_EXC_ERROR then
1167: x_return_status := FND_API.G_RET_STS_ERROR ;
1168: BIS_UTILITIES_PUB.put_line(p_text =>'Exception at Retrieve_All_Request_Rows: '||sqlerrm);
1169: when FND_API.G_EXC_UNEXPECTED_ERROR then
1170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1171: BIS_UTILITIES_PUB.put_line(p_text =>'Exception at Retrieve_All_Request_Rows: '||sqlerrm);
1172: when others then
1173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1174: BIS_UTILITIES_PUB.put_line(p_text =>'Exception at Retrieve_All_Request_Rows: '||sqlerrm);

Line 1173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1169: when FND_API.G_EXC_UNEXPECTED_ERROR then
1170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1171: BIS_UTILITIES_PUB.put_line(p_text =>'Exception at Retrieve_All_Request_Rows: '||sqlerrm);
1172: when others then
1173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1174: BIS_UTILITIES_PUB.put_line(p_text =>'Exception at Retrieve_All_Request_Rows: '||sqlerrm);
1175: l_error_tbl := x_error_tbl;
1176: BIS_UTILITIES_PVT.Add_Error_Message
1177: ( p_error_msg_id => SQLCODE