DBA Data[Home] [Help]

APPS.BIS_RESPONSIBILITY_PVT dependencies on BIS_UTILITIES_PVT

Line 76: BIS_UTILITIES_PVT.Add_Error_Message

72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
73: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
74: when others then
75: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
76: BIS_UTILITIES_PVT.Add_Error_Message
77: ( p_error_msg_id => SQLCODE
78: , p_error_description => SQLERRM
79: , p_error_proc_name => G_PKG_NAME||'.Retrieve_User_Responsibilities'
80: );

Line 139: BIS_UTILITIES_PVT.Add_Error_Message

135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
137: when others then
138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
139: BIS_UTILITIES_PVT.Add_Error_Message
140: ( p_error_msg_id => SQLCODE
141: , p_error_description => SQLERRM
142: , p_error_proc_name => G_PKG_NAME||'.Retrieve_User_Responsibilities'
143: );

Line 186: BIS_UTILITIES_PVT.Add_Error_Message

182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
184: when others then
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
186: BIS_UTILITIES_PVT.Add_Error_Message
187: ( p_error_msg_id => SQLCODE
188: , p_error_description => SQLERRM
189: , p_error_proc_name => G_PKG_NAME||'.Retrieve_All_Responsibilities'
190: );

Line 224: BIS_UTILITIES_PVT.Add_Error_Message

220: EXCEPTION
221: WHEN NO_DATA_FOUND THEN
222: x_return_status := FND_API.G_RET_STS_ERROR ;
223: --Added last two params
224: BIS_UTILITIES_PVT.Add_Error_Message
225: ( p_error_msg_id => SQLCODE
226: , p_error_description => SQLERRM
227: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Responsibility'
228: , p_error_table => x_error_tbl

Line 245: BIS_UTILITIES_PVT.Add_Error_Message

241: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
242: when others then
243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
244: --Added last two params
245: BIS_UTILITIES_PVT.Add_Error_Message
246: ( p_error_msg_id => SQLCODE
247: , p_error_description => SQLERRM
248: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Responsibility'
249: , p_error_table => x_error_tbl

Line 278: BIS_UTILITIES_PVT.Add_Error_Message

274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
276: when others then
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
278: BIS_UTILITIES_PVT.Add_Error_Message
279: ( p_error_msg_id => SQLCODE
280: , p_error_description => SQLERRM
281: , p_error_proc_name => G_PKG_NAME||'.DFR_Value_ID_Conversion'
282: );

Line 318: BIS_UTILITIES_PVT.Add_Error_Message

314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
315: when others then
316:
317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
318: BIS_UTILITIES_PVT.Add_Error_Message
319: ( p_error_msg_id => SQLCODE
320: , p_error_description => SQLERRM
321: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Notify_Resp_Name'
322: );

Line 350: BIS_UTILITIES_PVT.Add_Error_Message

346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
348: when others then
349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
350: BIS_UTILITIES_PVT.Add_Error_Message
351: ( p_error_msg_id => SQLCODE
352: , p_error_description => SQLERRM
353: , p_error_proc_name => G_PKG_NAME||'.Validate_Notify_Resp_ID'
354: );

Line 382: BIS_UTILITIES_PVT.Add_Error_Message

378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
380: when others then
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
382: BIS_UTILITIES_PVT.Add_Error_Message
383: ( p_error_msg_id => SQLCODE
384: , p_error_description => SQLERRM
385: , p_error_proc_name => G_PKG_NAME||'.Value_ID_Conversion'
386: );

Line 414: BIS_UTILITIES_PVT.Add_Error_Message

410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
411:
412: when others then
413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
414: BIS_UTILITIES_PVT.Add_Error_Message
415: ( p_error_msg_id => SQLCODE
416: , p_error_description => SQLERRM
417: , p_error_proc_name => G_PKG_NAME||'.DFR_Value_ID_Conversion'
418: );

Line 467: l_attribute_app_id NUMBER := BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID;

463: IS
464:
465: l_notify_responsibility_rec
466: BIS_Responsibility_PVT.Notify_Responsibility_Rec_type;
467: l_attribute_app_id NUMBER := BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID;
468: l_attribute_code VARCHAR2(32000);
469: l_attribute_name VARCHAR2(32000);
470: l_region_app_id NUMBER := BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID;
471: l_region_code VARCHAR2(32000);

Line 470: l_region_app_id NUMBER := BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID;

466: BIS_Responsibility_PVT.Notify_Responsibility_Rec_type;
467: l_attribute_app_id NUMBER := BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID;
468: l_attribute_code VARCHAR2(32000);
469: l_attribute_name VARCHAR2(32000);
470: l_region_app_id NUMBER := BIS_UTILITIES_PVT.G_BIS_APPLICATION_ID;
471: l_region_code VARCHAR2(32000);
472:
473: CURSOR cr_ak_data IS
474: SELECT