DBA Data[Home] [Help]

APPS.BIS_CONCURRENT_MANAGER_PVT dependencies on FND_API

Line 72: x_return_status := FND_API.G_RET_STS_SUCCESS;

68:
69: BEGIN
70:
71: BIS_UTILITIES_PUB.put_line(p_text =>'Managing alert registrations (concurrent manager mode)');
72: x_return_status := FND_API.G_RET_STS_SUCCESS;
73:
74: Get_All_Requests
75: ( p_Param_Set_rec => p_Param_Set_rec
76: , x_Concurrent_Request_tbl => l_Concurrent_Request_tbl

Line 110: x_request_scheduled := FND_API.G_TRUE;

106: END IF;
107: END LOOP;
108:
109: IF l_request_scheduled THEN
110: x_request_scheduled := FND_API.G_TRUE;
111: ELSE
112: x_request_scheduled := FND_API.G_FALSE;
113:
114: IF p_Param_Set_Rec.Target_Level_id IS NOT NULL THEN

Line 112: x_request_scheduled := FND_API.G_FALSE;

108:
109: IF l_request_scheduled THEN
110: x_request_scheduled := FND_API.G_TRUE;
111: ELSE
112: x_request_scheduled := FND_API.G_FALSE;
113:
114: IF p_Param_Set_Rec.Target_Level_id IS NOT NULL THEN
115: BIS_UTILITIES_PUB.put_line(p_text =>'Managing request by target level: '
116: ||p_Param_Set_Rec.Target_Level_id );

Line 172: when FND_API.G_EXC_ERROR then

168:
169: END IF;
170:
171: EXCEPTION
172: when FND_API.G_EXC_ERROR then
173: x_return_status := FND_API.G_RET_STS_ERROR ;
174: BIS_UTILITIES_PUB.put_line(p_text =>'exception 1 in Manage_Alert_Registrations: '||sqlerrm);
175: when FND_API.G_EXC_UNEXPECTED_ERROR then
176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 173: x_return_status := FND_API.G_RET_STS_ERROR ;

169: END IF;
170:
171: EXCEPTION
172: when FND_API.G_EXC_ERROR then
173: x_return_status := FND_API.G_RET_STS_ERROR ;
174: BIS_UTILITIES_PUB.put_line(p_text =>'exception 1 in Manage_Alert_Registrations: '||sqlerrm);
175: when FND_API.G_EXC_UNEXPECTED_ERROR then
176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
177: BIS_UTILITIES_PUB.put_line(p_text =>'exception 2 in Manage_Alert_Registrations: '||sqlerrm);

Line 175: when FND_API.G_EXC_UNEXPECTED_ERROR then

171: EXCEPTION
172: when FND_API.G_EXC_ERROR then
173: x_return_status := FND_API.G_RET_STS_ERROR ;
174: BIS_UTILITIES_PUB.put_line(p_text =>'exception 1 in Manage_Alert_Registrations: '||sqlerrm);
175: when FND_API.G_EXC_UNEXPECTED_ERROR then
176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
177: BIS_UTILITIES_PUB.put_line(p_text =>'exception 2 in Manage_Alert_Registrations: '||sqlerrm);
178: when others then
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

172: when FND_API.G_EXC_ERROR then
173: x_return_status := FND_API.G_RET_STS_ERROR ;
174: BIS_UTILITIES_PUB.put_line(p_text =>'exception 1 in Manage_Alert_Registrations: '||sqlerrm);
175: when FND_API.G_EXC_UNEXPECTED_ERROR then
176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
177: BIS_UTILITIES_PUB.put_line(p_text =>'exception 2 in Manage_Alert_Registrations: '||sqlerrm);
178: when others then
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
180: BIS_UTILITIES_PUB.put_line(p_text =>'exception 3 in Manage_Alert_Registrations: '||sqlerrm);

Line 179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

175: when FND_API.G_EXC_UNEXPECTED_ERROR then
176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
177: BIS_UTILITIES_PUB.put_line(p_text =>'exception 2 in Manage_Alert_Registrations: '||sqlerrm);
178: when others then
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
180: BIS_UTILITIES_PUB.put_line(p_text =>'exception 3 in Manage_Alert_Registrations: '||sqlerrm);
181: BIS_UTILITIES_PVT.Add_Error_Message
182: ( p_error_msg_id => SQLCODE
183: , p_error_description => SQLERRM

Line 332: ( p_main_request_flag => FND_API.G_TRUE

328:
329: ELSIF p_param_set_rec.performance_measure_id IS NOT NULL THEN
330:
331: Get_PMF_Concurrent_Program_ID
332: ( p_main_request_flag => FND_API.G_TRUE
333: , x_Concurrent_Program_ID => l_Concurrent_Program_ID
334: , x_Application_ID => l_Application_ID
335: );
336:

Line 390: ( p_main_request_flag IN VARCHAR2 := FND_API.G_FALSE

386:
387: END Get_All_Requests;
388:
389: Procedure Get_PMF_Concurrent_Program_ID
390: ( p_main_request_flag IN VARCHAR2 := FND_API.G_FALSE
391: , x_Concurrent_Program_ID OUT NOCOPY NUMBER
392: , x_Application_ID OUT NOCOPY NUMBER
393: )
394: IS

Line 398: IF p_main_request_flag = FND_API.G_TRUE THEN

394: IS
395: l_conc_program_name VARCHAR2(32000);
396: BEGIN
397:
398: IF p_main_request_flag = FND_API.G_TRUE THEN
399: l_conc_program_name := G_ALERT_PROGRAM;
400: ELSE
401: l_conc_program_name := G_ALERT_PROGRAM_PVT;
402: END IF;

Line 596: when FND_API.G_EXC_ERROR then

592: END IF;
593:
594:
595: EXCEPTION
596: when FND_API.G_EXC_ERROR then
597: x_errbuf := 'Request: '||to_char(l_request_number)
598: ||', Error1: '||SQLERRM
599: || 'Error from FND_REQUEST.SUBMIT_REQUEST : ' || FND_MESSAGE.GET;
600: x_retcode := SQLCODE;

Line 603: when FND_API.G_EXC_UNEXPECTED_ERROR then

599: || 'Error from FND_REQUEST.SUBMIT_REQUEST : ' || FND_MESSAGE.GET;
600: x_retcode := SQLCODE;
601:
602: RETURN;
603: when FND_API.G_EXC_UNEXPECTED_ERROR then
604: x_errbuf := 'Request: '||to_char(l_request_number)
605: ||', Error2: '||SQLERRM
606: || 'Error from FND_REQUEST.SUBMIT_REQUEST : ' || FND_MESSAGE.GET;
607: x_retcode := SQLCODE;

Line 1027: x_result := FND_API.G_RET_STS_SUCCESS;

1023: ELSE
1024: l_debug_text := l_debug_text||' -- Repeat interval NOT set.';
1025: END IF;
1026:
1027: x_result := FND_API.G_RET_STS_SUCCESS;
1028:
1029: EXCEPTION
1030: WHEN OTHERS THEN
1031: BIS_UTILITIES_PUB.put_line(p_text =>'exception in Set_Repeat_Options: '||sqlerrm);