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_ALERT_SERVICE_PVT dependencies on BIS_UTILITIES_PUB

Line 180: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

176: , p_alert_type IN VARCHAR2 := NULL
177: , p_alert_level IN VARCHAR2 := NULL
178: ,x_Alert_request_Tbl OUT NOCOPY BIS_ALERT_SERVICE_PVT.Alert_request_Tbl_type
179: ,x_return_status OUT NOCOPY VARCHAR2
180: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
181: );
182:
183: -----------------------------------------------------
184: -- Procedures

Line 232: l_request_id_tbl BIS_UTILITIES_PUB.BIS_VARCHAR_TBL;

228: IS
229:
230: l_alert_request_tbl BIS_ALERT_SERVICE_PVT.Alert_Request_Tbl_Type;
231: l_Concurrent_Request_Tbl BIS_CONCURRENT_MANAGER_PVT.PMF_Request_Tbl_Type;
232: l_request_id_tbl BIS_UTILITIES_PUB.BIS_VARCHAR_TBL;
233:
234: l_return_status VARCHAR2(1000);
235: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
236: l_api_version NUMBER := 1;

Line 235: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

231: l_Concurrent_Request_Tbl BIS_CONCURRENT_MANAGER_PVT.PMF_Request_Tbl_Type;
232: l_request_id_tbl BIS_UTILITIES_PUB.BIS_VARCHAR_TBL;
233:
234: l_return_status VARCHAR2(1000);
235: l_error_Tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
236: l_api_version NUMBER := 1;
237:
238: BEGIN
239:

Line 240: BIS_UTILITIES_PUB.put_line(p_text =>'Servicing main alert request ');

236: l_api_version NUMBER := 1;
237:
238: BEGIN
239:
240: BIS_UTILITIES_PUB.put_line(p_text =>'Servicing main alert request ');
241: BIS_UTILITIES_PUB.put_line(p_text =>'alert type: '||p_alert_type);
242:
243: BIS_UTILITIES_PUB.put_line(p_text =>'Time level : '||p_time_level_id);
244:

Line 241: BIS_UTILITIES_PUB.put_line(p_text =>'alert type: '||p_alert_type);

237:
238: BEGIN
239:
240: BIS_UTILITIES_PUB.put_line(p_text =>'Servicing main alert request ');
241: BIS_UTILITIES_PUB.put_line(p_text =>'alert type: '||p_alert_type);
242:
243: BIS_UTILITIES_PUB.put_line(p_text =>'Time level : '||p_time_level_id);
244:
245: -- Retrieves all rows from ART for this request

Line 243: BIS_UTILITIES_PUB.put_line(p_text =>'Time level : '||p_time_level_id);

239:
240: BIS_UTILITIES_PUB.put_line(p_text =>'Servicing main alert request ');
241: BIS_UTILITIES_PUB.put_line(p_text =>'alert type: '||p_alert_type);
242:
243: BIS_UTILITIES_PUB.put_line(p_text =>'Time level : '||p_time_level_id);
244:
245: -- Retrieves all rows from ART for this request
246: --
247: Retrieve_All_Request_Rows

Line 260: BIS_UTILITIES_PUB.put_line(p_text =>'Number of request rows: '||l_alert_request_tbl.count);

256: , x_return_status => l_return_status
257: , x_error_Tbl => l_error_Tbl
258: );
259:
260: BIS_UTILITIES_PUB.put_line(p_text =>'Number of request rows: '||l_alert_request_tbl.count);
261:
262: Form_Concurrent_Request
263: ( p_Alert_Request_Tbl => l_Alert_Request_Tbl
264: , x_Concurrent_Request_Tbl => l_Concurrent_Request_Tbl

Line 267: BIS_UTILITIES_PUB.put_line(p_text =>'Submit concurrent requests for Detial Alert Service');

263: ( p_Alert_Request_Tbl => l_Alert_Request_Tbl
264: , x_Concurrent_Request_Tbl => l_Concurrent_Request_Tbl
265: );
266:
267: BIS_UTILITIES_PUB.put_line(p_text =>'Submit concurrent requests for Detial Alert Service');
268: --
269: BIS_CONCURRENT_MANAGER_PVT.Submit_Concurrent_Request
270: ( p_Concurrent_Request_Tbl => l_Concurrent_Request_Tbl
271: , x_request_id_tbl => l_request_id_tbl

Line 280: BIS_UTILITIES_PUB.put_line(p_text =>'service alert req error 1');

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;
282: when FND_API.G_EXC_UNEXPECTED_ERROR then
283: RETCODE := 1;
284: ERRBUF := SQLERRM;

Line 285: BIS_UTILITIES_PUB.put_line(p_text =>'service alert req error 2');

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;
287: when others then
288: RETCODE := 1;
289: BIS_UTILITIES_PUB.put_line(p_text =>'service alert req error 3: '||SQLERRM);

Line 289: BIS_UTILITIES_PUB.put_line(p_text =>'service alert req error 3: '||SQLERRM);

285: BIS_UTILITIES_PUB.put_line(p_text =>'service alert req error 2');
286: RETURN;
287: when others then
288: RETCODE := 1;
289: BIS_UTILITIES_PUB.put_line(p_text =>'service alert req error 3: '||SQLERRM);
290:
291: BIS_UTILITIES_PVT.Add_Error_Message
292: ( p_error_msg_id => SQLCODE
293: , p_error_description => SQLERRM

Line 366: BIS_UTILITIES_PUB.put_line(p_text =>' ------- Begin log file for SONAR child request. ------- ');

362: ) ;
363:
364: -- fnd_file.put_line(fnd_file.log, ' Return status is = ' || nvl(l_return_status, 'X!!' ));
365:
366: BIS_UTILITIES_PUB.put_line(p_text =>' ------- Begin log file for SONAR child request. ------- ');
367:
368: BIS_UTILITIES_PUB.put_line(p_text =>'Servicing detailed alert request.');
369:
370: -- Form generic planning request record

Line 368: BIS_UTILITIES_PUB.put_line(p_text =>'Servicing detailed alert request.');

364: -- fnd_file.put_line(fnd_file.log, ' Return status is = ' || nvl(l_return_status, 'X!!' ));
365:
366: BIS_UTILITIES_PUB.put_line(p_text =>' ------- Begin log file for SONAR child request. ------- ');
367:
368: BIS_UTILITIES_PUB.put_line(p_text =>'Servicing detailed alert request.');
369:
370: -- Form generic planning request record
371: --
372: Form_Planning_Request

Line 418: BIS_UTILITIES_PUB.put_line(p_text =>'Target level id: '||l_Measure_Instance.target_level_id);

414: , x_measure_instance => l_Measure_Instance
415: , x_Dim_Level_Value_Tbl => l_Dim_Level_Value_Tbl
416: );
417:
418: BIS_UTILITIES_PUB.put_line(p_text =>'Target level id: '||l_Measure_Instance.target_level_id);
419:
420: -- submit generic planning request
421: --
422: Submit_Planning_Request

Line 429: BIS_UTILITIES_PUB.put_line(p_text => ' ------- End log file for SONAR child request. ------- ');

425: , p_alert_type => p_alert_type
426: , p_alert_level => p_alert_level
427: );
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;

Line 526: BIS_UTILITIES_PUB.put_line(p_text =>'Forming concurrent requests. Number of alert requests: '

522:
523: BEGIN
524:
525: l_Concurrent_Request_Tbl := x_Concurrent_Request_Tbl;
526: BIS_UTILITIES_PUB.put_line(p_text =>'Forming concurrent requests. Number of alert requests: '
527: ||p_Alert_Request_Tbl.COUNT );
528:
529: FOR i IN 1..p_Alert_Request_Tbl.COUNT LOOP
530: --BIS_UTILITIES_PUB.put_line(p_text =>'in form concurrent request: target level id: '

Line 530: --BIS_UTILITIES_PUB.put_line(p_text =>'in form concurrent request: target level id: '

526: BIS_UTILITIES_PUB.put_line(p_text =>'Forming concurrent requests. Number of alert requests: '
527: ||p_Alert_Request_Tbl.COUNT );
528:
529: FOR i IN 1..p_Alert_Request_Tbl.COUNT LOOP
530: --BIS_UTILITIES_PUB.put_line(p_text =>'in form concurrent request: target level id: '
531: --||p_Alert_Request_Tbl(i).target_level_id);
532:
533: l_count := l_Concurrent_Request_Tbl.COUNT+1;
534:

Line 642: BIS_UTILITIES_PUB.put_line(p_text =>'Number of request successfully formed: '

638: := p_alert_request_tbl(i).alert_based_on;
639: END LOOP;
640:
641: x_Concurrent_Request_Tbl := l_Concurrent_Request_Tbl;
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

Line 647: BIS_UTILITIES_PUB.put_line(p_text =>'form conc req 1');

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
651: BIS_UTILITIES_PUB.put_line(p_text =>'form conc req 3: '||SQLERRM);

Line 649: BIS_UTILITIES_PUB.put_line(p_text =>'form conc req 2');

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
653: ( p_error_msg_id => SQLCODE

Line 651: BIS_UTILITIES_PUB.put_line(p_text =>'form conc req 3: '||SQLERRM);

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
653: ( p_error_msg_id => SQLCODE
654: , p_error_description => SQLERRM
655: , p_error_proc_name => G_PKG_NAME||'.Form_Concurrent_Request'

Line 889: --BIS_UTILITIES_PUB.put_line(p_text =>'in form alert request: target id: '||p_target_rec.target_id);

885:
886: l_Alert_Request_rec BIS_ALERT_SERVICE_PVT.Alert_Request_rec_Type;
887:
888: BEGIN
889: --BIS_UTILITIES_PUB.put_line(p_text =>'in form alert request: target id: '||p_target_rec.target_id);
890:
891: l_Alert_Request_rec := x_Alert_Request_rec;
892:
893: l_alert_request_rec.measure_id

Line 980: --BIS_UTILITIES_PUB.put_line(p_text =>'target reqest formed : target id : '

976: l_alert_request_rec.alert_level := p_alert_level;
977:
978: x_Alert_Request_rec := l_Alert_Request_rec;
979:
980: --BIS_UTILITIES_PUB.put_line(p_text =>'target reqest formed : target id : '
981: --||x_Alert_Request_rec.target_id);
982:
983: EXCEPTION
984: WHEN OTHERS THEN

Line 985: BIS_UTILITIES_PUB.put_line(p_text =>'Form alert request error: '||sqlerrm);

981: --||x_Alert_Request_rec.target_id);
982:
983: EXCEPTION
984: WHEN OTHERS THEN
985: BIS_UTILITIES_PUB.put_line(p_text =>'Form alert request error: '||sqlerrm);
986: return;
987:
988: END Form_Alert_Request_rec;
989:

Line 1002: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

998: , p_alert_type IN VARCHAR2 := NULL
999: , p_alert_level IN VARCHAR2 := NULL
1000: ,x_Alert_request_Tbl OUT NOCOPY BIS_ALERT_SERVICE_PVT.Alert_request_Tbl_type
1001: ,x_return_status OUT NOCOPY VARCHAR2
1002: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1003: )
1004: IS
1005:
1006: l_param_set_tbl_orig BIS_PMF_ALERT_REG_PUB.parameter_set_tbl_type;

Line 1014: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

1010: l_debug_text VARCHAR2(32000);
1011:
1012: l_count NUMBER := 0;
1013: l_target_tbl BIS_TARGET_PUB.Target_Tbl_type;
1014: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1015: c_num NUMBER := -9999;
1016: c_var VARCHAR2(5) := '-9999';
1017: l_flag BOOLEAN := FALSE;
1018: l_count_param_set_tbl NUMBER := 0;

Line 1021: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieving all request rows. Current row? '||p_current_row);

1017: l_flag BOOLEAN := FALSE;
1018: l_count_param_set_tbl NUMBER := 0;
1019: Begin
1020:
1021: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieving all request rows. Current row? '||p_current_row);
1022: BIS_UTILITIES_PUB.put_line(p_text =>'alert type: '||p_alert_type);
1023:
1024: BIS_PMF_ALERT_REG_PUB.Retrieve_Parameter_set
1025: ( p_api_version => p_api_version

Line 1022: BIS_UTILITIES_PUB.put_line(p_text =>'alert type: '||p_alert_type);

1018: l_count_param_set_tbl NUMBER := 0;
1019: Begin
1020:
1021: BIS_UTILITIES_PUB.put_line(p_text =>'Retrieving all request rows. Current row? '||p_current_row);
1022: BIS_UTILITIES_PUB.put_line(p_text =>'alert type: '||p_alert_type);
1023:
1024: BIS_PMF_ALERT_REG_PUB.Retrieve_Parameter_set
1025: ( p_api_version => p_api_version
1026: , p_measure_id => p_perf_measure_id

Line 1033: BIS_UTILITIES_PUB.put_line(p_text =>'Original number of parameter sets: '|| l_Param_Set_Tbl_orig.count);

1029: , x_Param_Set_Tbl => l_Param_Set_Tbl_orig
1030: , x_return_status => x_return_status
1031: , x_error_Tbl => x_error_Tbl
1032: );
1033: BIS_UTILITIES_PUB.put_line(p_text =>'Original number of parameter sets: '|| l_Param_Set_Tbl_orig.count);
1034:
1035: BIS_PMF_REG_SERVICE_PVT.Retrieve_target_info
1036: ( p_api_version => p_api_version
1037: , p_measure_id => p_perf_measure_id

Line 1061: BIS_UTILITIES_PUB.put_line(p_text =>'Managing '||i||'th TARGET registrations: '

1057: );
1058: END LOOP;
1059:
1060: FOR i IN 1..l_Param_Set_tbl.COUNT LOOP
1061: BIS_UTILITIES_PUB.put_line(p_text =>'Managing '||i||'th TARGET registrations: '
1062: ||l_Param_Set_tbl(i).Target_Level_ID);
1063: BIS_PMF_ALERT_REG_PVT.Manage_Alert_Registrations
1064: ( p_Param_Set_rec => l_Param_Set_tbl(i)
1065: , x_request_scheduled => l_request_scheduled

Line 1072: BIS_UTILITIES_PUB.put_line(p_text =>'after manag: '||l_debug_text);

1068: );
1069: --l_debug_text := l_debug_text||': '
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 ||': '

Line 1075: BIS_UTILITIES_PUB.put_line(p_text =>'Request exist');

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;
1079: ELSE

Line 1082: BIS_UTILITIES_PUB.put_line(p_text =>'Managing alert registration by Target result: '

1078: l_request_id := BIS_PMF_REG_SERVICE_PVT.G_REQUEST_EXIST;
1079: ELSE
1080: --l_debug_text := l_debug_text ||'--process param set debug--'
1081: --||x_return_status;
1082: BIS_UTILITIES_PUB.put_line(p_text =>'Managing alert registration by Target result: '
1083: ||x_return_status);
1084:
1085: BIS_PMF_REG_SERVICE_PVT.Register_Parameter_set
1086: ( p_api_version => p_api_version

Line 1093: BIS_UTILITIES_PUB.put_line(p_text =>'registering target row: '||i||', status: '||x_return_status);

1089: , x_return_status => x_return_status
1090: , x_error_Tbl => x_error_Tbl
1091: );
1092: ---_debug_text := l_debug_text ||l_request_id;
1093: BIS_UTILITIES_PUB.put_line(p_text =>'registering target row: '||i||', status: '||x_return_status);
1094: END IF;
1095: END LOOP;
1096: -- records from bis_pmf_alert_parameters are retrieved into
1097: -- l_Param_Set_tbl_orig table.

Line 1099: BIS_UTILITIES_PUB.put_line(p_text =>'stuffing l_Param_Set_tbl. i: '||i

1095: END LOOP;
1096: -- records from bis_pmf_alert_parameters are retrieved into
1097: -- l_Param_Set_tbl_orig table.
1098: FOR i IN 1..l_Param_Set_tbl_orig.COUNT LOOP
1099: BIS_UTILITIES_PUB.put_line(p_text =>'stuffing l_Param_Set_tbl. i: '||i
1100: ||', tbl count: '||l_Param_Set_tbl.COUNT);
1101: -- Filter out duplicate records while they are added to l_Param_Set_tbl table
1102: -- from l_Param_Set_tbl_Orig table
1103: -- reset the flag for every record of l_Param_Set_tbl_Orig table

Line 1137: BIS_UTILITIES_PUB.put_line(p_text =>'l_Param_Set_tbl_orig.COUNT='||l_Param_Set_tbl_orig.COUNT);

1133: l_Param_Set_tbl(l_count_param_set_tbl) := l_Param_Set_tbl_orig(i);
1134: END IF;
1135: END LOOP;
1136:
1137: BIS_UTILITIES_PUB.put_line(p_text =>'l_Param_Set_tbl_orig.COUNT='||l_Param_Set_tbl_orig.COUNT);
1138: BIS_UTILITIES_PUB.put_line(p_text =>'l_Param_Set_tbl.COUNT='||l_Param_Set_tbl.COUNT);
1139: BIS_UTILITIES_PUB.put_line(p_text =>'x_Alert_request_Tbl.COUNT='||x_Alert_request_Tbl.COUNT);
1140:
1141: l_count := x_Alert_request_Tbl.COUNT;

Line 1138: BIS_UTILITIES_PUB.put_line(p_text =>'l_Param_Set_tbl.COUNT='||l_Param_Set_tbl.COUNT);

1134: END IF;
1135: END LOOP;
1136:
1137: BIS_UTILITIES_PUB.put_line(p_text =>'l_Param_Set_tbl_orig.COUNT='||l_Param_Set_tbl_orig.COUNT);
1138: BIS_UTILITIES_PUB.put_line(p_text =>'l_Param_Set_tbl.COUNT='||l_Param_Set_tbl.COUNT);
1139: BIS_UTILITIES_PUB.put_line(p_text =>'x_Alert_request_Tbl.COUNT='||x_Alert_request_Tbl.COUNT);
1140:
1141: l_count := x_Alert_request_Tbl.COUNT;
1142: FOR i IN 1..l_Param_Set_tbl.COUNT LOOP

Line 1139: BIS_UTILITIES_PUB.put_line(p_text =>'x_Alert_request_Tbl.COUNT='||x_Alert_request_Tbl.COUNT);

1135: END LOOP;
1136:
1137: BIS_UTILITIES_PUB.put_line(p_text =>'l_Param_Set_tbl_orig.COUNT='||l_Param_Set_tbl_orig.COUNT);
1138: BIS_UTILITIES_PUB.put_line(p_text =>'l_Param_Set_tbl.COUNT='||l_Param_Set_tbl.COUNT);
1139: BIS_UTILITIES_PUB.put_line(p_text =>'x_Alert_request_Tbl.COUNT='||x_Alert_request_Tbl.COUNT);
1140:
1141: l_count := x_Alert_request_Tbl.COUNT;
1142: FOR i IN 1..l_Param_Set_tbl.COUNT LOOP
1143: IF l_Param_Set_tbl(i).TARGET_LEVEL_ID IS NOT NULL THEN

Line 1162: BIS_UTILITIES_PUB.put_line(p_text =>'Total number of requests to be submitted: '

1158: x_Alert_request_Tbl(l_count).alert_based_on := p_alert_based_on;
1159: x_Alert_request_Tbl(l_count).current_row := p_current_row;
1160: END IF;
1161: END LOOP;
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

Line 1168: BIS_UTILITIES_PUB.put_line(p_text =>'Exception at Retrieve_All_Request_Rows: '||sqlerrm);

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);
1172: when others then

Line 1171: BIS_UTILITIES_PUB.put_line(p_text =>'Exception at Retrieve_All_Request_Rows: '||sqlerrm);

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);
1175: l_error_tbl := x_error_tbl;

Line 1174: BIS_UTILITIES_PUB.put_line(p_text =>'Exception at Retrieve_All_Request_Rows: '||sqlerrm);

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
1178: , p_error_description => SQLERRM