DBA Data[Home] [Help]

APPS.BIS_PMF_ALERT_REG_PVT dependencies on BIS_UTILITIES_PVT

Line 86: l_role_display_name := BIS_UTILITIES_PVT.getPrompt

82: --||p_Param_Set_Rec.NOTIFIERS_CODE);
83:
84: IF p_Param_Set_Rec.NOTIFIERS_CODE IS NULL THEN
85: l_role_name := G_BIS_ALERT_ROLE || to_char(l_registration_id);
86: l_role_display_name := BIS_UTILITIES_PVT.getPrompt
87: ( G_PERFORMANCE_ALERT_PROMPTS
88: , G_AD_HOC_ROLE_DISPLAY_NAME
89: );
90: --BIS_UTILITIES_PUB.put_line(p_text =>'role name, display name: '||l_role_name

Line 194: BIS_UTILITIES_PVT.Add_Error_Message

190: when others then
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
192: BIS_UTILITIES_PUB.put_line(p_text =>'exception 3 in Create_Parameter_set'||sqlerrm);
193: l_error_tbl := x_error_Tbl;
194: BIS_UTILITIES_PVT.Add_Error_Message
195: ( p_error_msg_id => SQLCODE
196: , p_error_description => SQLERRM
197: , p_error_proc_name => G_PKG_NAME||'.Create_Parameter_set'
198: , p_error_table => l_error_tbl

Line 241: BIS_UTILITIES_PVT.Add_Error_Message

237: when others then
238: BIS_UTILITIES_PUB.put_line(p_text =>'exception 3 in delete parameter set: '||sqlerrm);
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
240: l_error_tbl := x_error_Tbl;
241: BIS_UTILITIES_PVT.Add_Error_Message
242: ( p_error_msg_id => SQLCODE
243: , p_error_description => SQLERRM
244: , p_error_proc_name => G_PKG_NAME||'.Delete_Parameter_set'
245: , p_error_table => l_error_tbl

Line 375: BIS_UTILITIES_PVT.Add_Error_Message

371: when others then
372: IF parameter_set_list%ISOPEN THEN close parameter_set_list; END IF;
373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
374: l_error_tbl := x_error_Tbl;
375: BIS_UTILITIES_PVT.Add_Error_Message
376: ( p_error_msg_id => SQLCODE
377: , p_error_description => SQLERRM
378: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Parameter_set'
379: , p_error_table => l_error_tbl

Line 546: BIS_UTILITIES_PVT.Add_Error_Message

542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
543: when others then
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
545: l_error_tbl := x_error_Tbl;
546: BIS_UTILITIES_PVT.Add_Error_Message
547: ( p_error_msg_id => SQLCODE
548: , p_error_description => SQLERRM
549: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Parameter_set'
550: , p_error_table => l_error_tbl

Line 612: BIS_UTILITIES_PVT.Add_Error_Message

608: when others then
609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
610: x_return_status := 'exception 3 at Retrieve_Notifiers_Code: '||sqlerrm;
611: l_error_tbl_p := l_error_tbl;
612: BIS_UTILITIES_PVT.Add_Error_Message
613: ( p_error_msg_id => SQLCODE
614: , p_error_description => SQLERRM
615: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Notifiers_Code'
616: , p_error_table => l_error_tbl_p

Line 659: BIS_UTILITIES_PVT.Add_Error_Message

655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
656: x_return_status := 'exception 1 at Retrieve_Notifiers_Code: '||sqlerrm;
657: BIS_UTILITIES_PUB.put_line(p_text =>x_return_status);
658: l_error_tbl_p := l_error_tbl;
659: BIS_UTILITIES_PVT.Add_Error_Message
660: ( p_error_msg_id => SQLCODE
661: , p_error_description => SQLERRM
662: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Notifiers_Code'
663: , p_error_table => l_error_tbl_p

Line 704: BIS_UTILITIES_PVT.Add_Error_Message

700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
701: when others then
702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
703: l_error_tbl := x_error_tbl;
704: BIS_UTILITIES_PVT.Add_Error_Message
705: ( p_error_msg_id => SQLCODE
706: , p_error_description => SQLERRM
707: , p_error_proc_name => G_PKG_NAME||'.Manage_Alert_Registrations'
708: , p_error_table => l_error_tbl

Line 747: BIS_UTILITIES_PVT.Add_Error_Message

743: when others then
744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
745: BIS_UTILITIES_PUB.put_line(p_text =>'exception 3 in Manage_Alert_Registrations: '||sqlerrm);
746: l_error_tbl := x_error_Tbl;
747: BIS_UTILITIES_PVT.Add_Error_Message
748: ( p_error_msg_id => SQLCODE
749: , p_error_description => SQLERRM
750: , p_error_proc_name => G_PKG_NAME||'.Manage_Alert_Registrations'
751: , p_error_table => l_error_tbl

Line 927: BIS_UTILITIES_PVT.Add_Error_Message

923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
924: x_return_status := ' exception 3 at Parameter_set_exist '||sqlerrm;
925: return FALSE;
926: l_error_tbl := x_error_Tbl;
927: BIS_UTILITIES_PVT.Add_Error_Message
928: ( p_error_msg_id => SQLCODE
929: , p_error_description => SQLERRM
930: , p_error_proc_name => G_PKG_NAME||'.Parameter_set_exist'
931: , p_error_table => l_error_tbl

Line 1007: BIS_UTILITIES_PVT.concatenateErrorTables

1003: EXCEPTION
1004: WHEN FND_API.G_EXC_ERROR THEN
1005: x_return_status:= FND_API.G_RET_STS_ERROR;
1006: l_error_tbl_p := x_error_Tbl;
1007: BIS_UTILITIES_PVT.concatenateErrorTables
1008: ( p_error_Tbl1 => l_error_Tbl_p
1009: , p_error_Tbl2 => l_error_Tbl
1010: , x_error_Tbl => x_error_Tbl
1011: );

Line 1057: BIS_UTILITIES_PVT.concatenateErrorTables

1053: EXCEPTION
1054: WHEN FND_API.G_EXC_ERROR THEN
1055: x_return_status:= FND_API.G_RET_STS_ERROR;
1056: l_error_tbl_p := x_error_Tbl;
1057: BIS_UTILITIES_PVT.concatenateErrorTables
1058: ( p_error_Tbl1 => l_error_Tbl_p
1059: , p_error_Tbl2 => l_error_Tbl
1060: , x_error_Tbl => x_error_Tbl
1061: );

Line 1087: BIS_UTILITIES_PVT.concatenateErrorTables

1083: EXCEPTION
1084: WHEN FND_API.G_EXC_ERROR THEN
1085: x_return_status:= FND_API.G_RET_STS_ERROR;
1086: l_error_tbl_p := x_error_Tbl;
1087: BIS_UTILITIES_PVT.concatenateErrorTables
1088: ( p_error_Tbl1 => l_error_Tbl_p
1089: , p_error_Tbl2 => l_error_Tbl
1090: , x_error_Tbl => x_error_Tbl
1091: );

Line 1118: BIS_UTILITIES_PVT.concatenateErrorTables

1114: EXCEPTION
1115: WHEN FND_API.G_EXC_ERROR THEN
1116: x_return_status:= FND_API.G_RET_STS_ERROR;
1117: l_error_tbl_p := x_error_Tbl;
1118: BIS_UTILITIES_PVT.concatenateErrorTables
1119: ( p_error_Tbl1 => l_error_Tbl_p
1120: , p_error_Tbl2 => l_error_Tbl
1121: , x_error_Tbl => x_error_Tbl
1122: );

Line 1150: BIS_UTILITIES_PVT.concatenateErrorTables

1146: EXCEPTION
1147: WHEN FND_API.G_EXC_ERROR THEN
1148: x_return_status:= FND_API.G_RET_STS_ERROR;
1149: l_error_tbl_p := x_error_Tbl;
1150: BIS_UTILITIES_PVT.concatenateErrorTables
1151: ( p_error_Tbl1 => l_error_Tbl_p
1152: , p_error_Tbl2 => l_error_Tbl
1153: , x_error_Tbl => x_error_Tbl
1154: );

Line 1182: BIS_UTILITIES_PVT.concatenateErrorTables

1178: EXCEPTION
1179: WHEN FND_API.G_EXC_ERROR THEN
1180: x_return_status:= FND_API.G_RET_STS_ERROR;
1181: l_error_tbl_p := x_error_Tbl;
1182: BIS_UTILITIES_PVT.concatenateErrorTables
1183: ( p_error_Tbl1 => l_error_Tbl_p
1184: , p_error_Tbl2 => l_error_Tbl
1185: , x_error_Tbl => x_error_Tbl
1186: );

Line 1215: BIS_UTILITIES_PVT.concatenateErrorTables

1211: EXCEPTION
1212: WHEN FND_API.G_EXC_ERROR THEN
1213: x_return_status:= FND_API.G_RET_STS_ERROR;
1214: l_error_tbl_p := x_error_Tbl;
1215: BIS_UTILITIES_PVT.concatenateErrorTables
1216: ( p_error_Tbl1 => l_error_Tbl_p
1217: , p_error_Tbl2 => l_error_Tbl
1218: , x_error_Tbl => x_error_Tbl
1219: );

Line 1247: BIS_UTILITIES_PVT.concatenateErrorTables

1243: EXCEPTION
1244: WHEN FND_API.G_EXC_ERROR THEN
1245: x_return_status:= FND_API.G_RET_STS_ERROR;
1246: l_error_tbl_p := x_error_Tbl;
1247: BIS_UTILITIES_PVT.concatenateErrorTables
1248: ( p_error_Tbl1 => l_error_Tbl_p
1249: , p_error_Tbl2 => l_error_Tbl
1250: , x_error_Tbl => x_error_Tbl
1251: );

Line 1270: BIS_UTILITIES_PVT.Add_Error_Message

1266: RAISE;
1267: WHEN OTHERS THEN
1268: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
1269: l_error_tbl_p := x_error_Tbl;
1270: BIS_UTILITIES_PVT.Add_Error_Message
1271: ( p_error_table => l_error_Tbl_p
1272: , p_error_msg_id => SQLCODE
1273: , p_error_description => SQLERRM
1274: , x_error_table => x_error_Tbl