DBA Data[Home] [Help]

APPS.BIS_MEASURE_VALIDATE_PVT dependencies on BIS_UTILITIES_PVT

Line 60: BIS_UTILITIES_PVT.Add_Error_Message

56: if (chk_dimension%NOTFOUND) then
57: close chk_dimension;
58: --added last two params
59: l_error_tbl := x_error_tbl;
60: BIS_UTILITIES_PVT.Add_Error_Message
61: ( p_error_msg_name => 'BIS_INVALID_DIMENSION_ID'
62: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
63: , p_error_proc_name => G_PKG_NAME||'.Validate_Dimension_ID'
64: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 88: BIS_UTILITIES_PVT.Add_Error_Message

84: when others then
85: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
86: --added last two params
87: l_error_tbl := x_error_tbl;
88: BIS_UTILITIES_PVT.Add_Error_Message
89: ( p_error_msg_id => SQLCODE
90: , p_error_description => SQLERRM
91: , p_error_proc_name => G_PKG_NAME||'.Validate_Dimension_Id'
92: , p_error_table => l_error_tbl

Line 128: BIS_UTILITIES_PVT.Add_Error_Message

124: FETCH chk_actual_data_source_type INTO l_dummy;
125: IF chk_actual_data_source_type%NOTFOUND THEN
126: CLOSE chk_actual_data_source_type;
127: l_error_tbl := x_error_tbl;
128: BIS_UTILITIES_PVT.Add_Error_Message
129: ( p_error_msg_name => 'BIS_INVALID_ACTUAL_DATA_SOURCE_TYPE'
130: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
131: , p_error_proc_name => G_PKG_NAME||'.Val_Actual_Data_Sour_Type'
132: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 154: BIS_UTILITIES_PVT.Add_Error_Message

150: when others then
151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
152: --added last two params
153: l_error_tbl := x_error_tbl;
154: BIS_UTILITIES_PVT.Add_Error_Message
155: ( p_error_msg_id => SQLCODE
156: , p_error_description => SQLERRM
157: , p_error_proc_name => G_PKG_NAME||'.Val_Actual_Data_Sour_Type'
158: , p_error_table => l_error_tbl

Line 196: BIS_UTILITIES_PVT.Add_Error_Message

192: FETCH chk_actual_data_source INTO l_dummy;
193: IF chk_actual_data_source%NOTFOUND THEN
194: CLOSE chk_actual_data_source;
195: l_error_tbl := x_error_tbl;
196: BIS_UTILITIES_PVT.Add_Error_Message
197: ( p_error_msg_name => 'BIS_INVALID_ACTUAL_DATA_SOURCE'
198: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
199: , p_error_proc_name => G_PKG_NAME||'.Val_Actual_Data_Sour'
200: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 222: BIS_UTILITIES_PVT.Add_Error_Message

218: when others then
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
220: --added last two params
221: l_error_tbl := x_error_tbl;
222: BIS_UTILITIES_PVT.Add_Error_Message
223: ( p_error_msg_id => SQLCODE
224: , p_error_description => SQLERRM
225: , p_error_proc_name => G_PKG_NAME||'.Val_Actual_Data_Sour'
226: , p_error_table => l_error_tbl

Line 259: BIS_UTILITIES_PVT.Add_Error_Message

255: FETCH chk_function_name INTO l_dummy;
256: IF chk_function_name%NOTFOUND THEN
257: CLOSE chk_function_name;
258: l_error_tbl := x_error_tbl;
259: BIS_UTILITIES_PVT.Add_Error_Message
260: ( p_error_msg_name => 'BIS_INVALID_FUNCTION_NAME'
261: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
262: , p_error_proc_name => G_PKG_NAME||'.Val_Func_Name'
263: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 285: BIS_UTILITIES_PVT.Add_Error_Message

281: when others then
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
283: --added last two params
284: l_error_tbl := x_error_tbl;
285: BIS_UTILITIES_PVT.Add_Error_Message
286: ( p_error_msg_id => SQLCODE
287: , p_error_description => SQLERRM
288: , p_error_proc_name => G_PKG_NAME||'.Val_Func_Name'
289: , p_error_table => l_error_tbl

Line 327: BIS_UTILITIES_PVT.Add_Error_Message

323: FETCH chk_comparison_source INTO l_dummy;
324: IF chk_comparison_source%NOTFOUND THEN
325: CLOSE chk_comparison_source;
326: l_error_tbl := x_error_tbl;
327: BIS_UTILITIES_PVT.Add_Error_Message
328: ( p_error_msg_name => 'BIS_INVALID_COMPARISON_SOURCE'
329: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
330: , p_error_proc_name => G_PKG_NAME||'.Val_Comparison_Source'
331: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 353: BIS_UTILITIES_PVT.Add_Error_Message

349: when others then
350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
351: --added last two params
352: l_error_tbl := x_error_tbl;
353: BIS_UTILITIES_PVT.Add_Error_Message
354: ( p_error_msg_id => SQLCODE
355: , p_error_description => SQLERRM
356: , p_error_proc_name => G_PKG_NAME||'.Val_Comparison_Source'
357: , p_error_table => l_error_tbl

Line 391: BIS_UTILITIES_PVT.Add_Error_Message

387: FETCH chk_increase_in_measure INTO l_dummy;
388: IF chk_increase_in_measure%NOTFOUND THEN
389: CLOSE chk_increase_in_measure;
390: l_error_tbl := x_error_tbl;
391: BIS_UTILITIES_PVT.Add_Error_Message
392: ( p_error_msg_name => 'BIS_INVALID_INCREASE_IN_MEASURE'
393: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
394: , p_error_proc_name => G_PKG_NAME||'.Val_Incr_In_Measure'
395: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 417: BIS_UTILITIES_PVT.Add_Error_Message

413: when others then
414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
415: --added last two params
416: l_error_tbl := x_error_tbl;
417: BIS_UTILITIES_PVT.Add_Error_Message
418: ( p_error_msg_id => SQLCODE
419: , p_error_description => SQLERRM
420: , p_error_proc_name => G_PKG_NAME||'.Val_Incr_In_Measure'
421: , p_error_table => l_error_tbl

Line 459: BIS_UTILITIES_PVT.Add_Error_Message

455: FETCH chk_enable_link INTO l_dummy;
456: IF chk_enable_link%NOTFOUND THEN
457: CLOSE chk_enable_link;
458: l_error_tbl := x_error_tbl;
459: BIS_UTILITIES_PVT.Add_Error_Message
460: ( p_error_msg_name => 'BIS_INVALID_enable_link'
461: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
462: , p_error_proc_name => G_PKG_NAME||'.Val_enable_link'
463: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 497: BIS_UTILITIES_PVT.Add_Error_Message

493: IF ( chk_enable_link%ISOPEN ) THEN
494: CLOSE chk_enable_link;
495: END IF;
496: l_error_tbl := x_error_tbl;
497: BIS_UTILITIES_PVT.Add_Error_Message
498: ( p_error_msg_id => SQLCODE
499: , p_error_description => SQLERRM
500: , p_error_proc_name => G_PKG_NAME||'.Val_enable_link'
501: , p_error_table => l_error_tbl

Line 529: BIS_UTILITIES_PVT.Add_Error_Message

525: AND BIS_UTILITIES_PUB.Value_Not_NULL(p_enabled)= FND_API.G_TRUE)
526: THEN
527: IF ((p_enabled <> FND_API.G_TRUE) AND (p_enabled <> FND_API.G_FALSE)) THEN
528: l_error_tbl := x_error_tbl;
529: BIS_UTILITIES_PVT.Add_Error_Message
530: ( p_error_msg_name => 'BIS_PMF_INVALID_ENABLED'
531: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
532: , p_error_proc_name => G_PKG_NAME||'.Val_enabled'
533: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 551: BIS_UTILITIES_PVT.Add_Error_Message

547: when others then
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
549: --added last two params
550: l_error_tbl := x_error_tbl;
551: BIS_UTILITIES_PVT.Add_Error_Message
552: ( p_error_msg_id => SQLCODE
553: , p_error_description => SQLERRM
554: , p_error_proc_name => G_PKG_NAME||'.Val_enabled'
555: , p_error_table => l_error_tbl

Line 576: IF ((p_obsolete <> FND_API.G_TRUE) AND (p_obsolete <> FND_API.G_FALSE) AND ( BIS_UTILITIES_PVT.Value_Missing_Or_Null(p_obsolete) <> FND_API.G_TRUE) ) THEN

572: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
573:
574: BEGIN
575: x_return_status := FND_API.G_RET_STS_SUCCESS;
576: IF ((p_obsolete <> FND_API.G_TRUE) AND (p_obsolete <> FND_API.G_FALSE) AND ( BIS_UTILITIES_PVT.Value_Missing_Or_Null(p_obsolete) <> FND_API.G_TRUE) ) THEN
577: l_error_tbl := x_error_tbl;
578: BIS_UTILITIES_PVT.Add_Error_Message
579: ( p_error_msg_name => 'BIS_PMF_INVALID_OBSOLETE_FLAG'
580: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 578: BIS_UTILITIES_PVT.Add_Error_Message

574: BEGIN
575: x_return_status := FND_API.G_RET_STS_SUCCESS;
576: IF ((p_obsolete <> FND_API.G_TRUE) AND (p_obsolete <> FND_API.G_FALSE) AND ( BIS_UTILITIES_PVT.Value_Missing_Or_Null(p_obsolete) <> FND_API.G_TRUE) ) THEN
577: l_error_tbl := x_error_tbl;
578: BIS_UTILITIES_PVT.Add_Error_Message
579: ( p_error_msg_name => 'BIS_PMF_INVALID_OBSOLETE_FLAG'
580: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
581: , p_error_proc_name => G_PKG_NAME||'.Val_Obsolete'
582: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 597: BIS_UTILITIES_PVT.Add_Error_Message

593: when others then
594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
595: --added last two params
596: l_error_tbl := x_error_tbl;
597: BIS_UTILITIES_PVT.Add_Error_Message
598: ( p_error_msg_id => SQLCODE
599: , p_error_description => SQLERRM
600: , p_error_proc_name => G_PKG_NAME||'.Val_Obsolete'
601: , p_error_table => l_error_tbl

Line 620: AND ( BIS_UTILITIES_PVT.Value_Missing_Or_Null(p_Measure_Type) <> FND_API.G_TRUE) ) THEN

616:
617: BEGIN
618: x_return_status := FND_API.G_RET_STS_SUCCESS;
619: IF ((p_Measure_type <> 'CDS_SCORE') AND (p_Measure_Type <> 'CDS_PERF') AND (p_Measure_Type <> 'CDS_CALC')
620: AND ( BIS_UTILITIES_PVT.Value_Missing_Or_Null(p_Measure_Type) <> FND_API.G_TRUE) ) THEN
621: l_error_tbl := x_error_tbl;
622: BIS_UTILITIES_PVT.Add_Error_Message
623: ( p_error_msg_name => 'BIS_PMF_INVALID_MEASURE_TYPE'
624: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 622: BIS_UTILITIES_PVT.Add_Error_Message

618: x_return_status := FND_API.G_RET_STS_SUCCESS;
619: IF ((p_Measure_type <> 'CDS_SCORE') AND (p_Measure_Type <> 'CDS_PERF') AND (p_Measure_Type <> 'CDS_CALC')
620: AND ( BIS_UTILITIES_PVT.Value_Missing_Or_Null(p_Measure_Type) <> FND_API.G_TRUE) ) THEN
621: l_error_tbl := x_error_tbl;
622: BIS_UTILITIES_PVT.Add_Error_Message
623: ( p_error_msg_name => 'BIS_PMF_INVALID_MEASURE_TYPE'
624: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
625: , p_error_proc_name => G_PKG_NAME||'.Val_Measure_Type'
626: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 641: BIS_UTILITIES_PVT.Add_Error_Message

637: when others then
638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
639: --added last two params
640: l_error_tbl := x_error_tbl;
641: BIS_UTILITIES_PVT.Add_Error_Message
642: ( p_error_msg_id => SQLCODE
643: , p_error_description => SQLERRM
644: , p_error_proc_name => G_PKG_NAME||'.Val_Measure_Type'
645: , p_error_table => l_error_tbl

Line 682: BIS_UTILITIES_PVT.Add_Error_Message

678: when others then
679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
680: --added last two params
681: l_error_tbl := x_error_tbl;
682: BIS_UTILITIES_PVT.Add_Error_Message
683: ( p_error_msg_id => SQLCODE
684: , p_error_description => SQLERRM
685: , p_error_proc_name => G_PKG_NAME||'.Val_Actual_Data_Sour_Type_Wrap'
686: , p_error_table => l_error_tbl

Line 724: BIS_UTILITIES_PVT.Add_Error_Message

720: when others then
721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
722: --added last two params
723: l_error_tbl := x_error_tbl;
724: BIS_UTILITIES_PVT.Add_Error_Message
725: ( p_error_msg_id => SQLCODE
726: , p_error_description => SQLERRM
727: , p_error_proc_name => G_PKG_NAME||'.Val_Actual_Data_Sour_Wrap'
728: , p_error_table => l_error_tbl

Line 766: BIS_UTILITIES_PVT.Add_Error_Message

762: when others then
763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
764: --added last two params
765: l_error_tbl := x_error_tbl;
766: BIS_UTILITIES_PVT.Add_Error_Message
767: ( p_error_msg_id => SQLCODE
768: , p_error_description => SQLERRM
769: , p_error_proc_name => G_PKG_NAME||'.Val_Func_Name_Wrap'
770: , p_error_table => l_error_tbl

Line 808: BIS_UTILITIES_PVT.Add_Error_Message

804: when others then
805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
806: --added last two params
807: l_error_tbl := x_error_tbl;
808: BIS_UTILITIES_PVT.Add_Error_Message
809: ( p_error_msg_id => SQLCODE
810: , p_error_description => SQLERRM
811: , p_error_proc_name => G_PKG_NAME||'.Val_Comparison_Source_Wrap'
812: , p_error_table => l_error_tbl

Line 850: BIS_UTILITIES_PVT.Add_Error_Message

846: when others then
847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
848: --added last two params
849: l_error_tbl := x_error_tbl;
850: BIS_UTILITIES_PVT.Add_Error_Message
851: ( p_error_msg_id => SQLCODE
852: , p_error_description => SQLERRM
853: , p_error_proc_name => G_PKG_NAME||'.Val_Incr_In_Measure_Wrap'
854: , p_error_table => l_error_tbl

Line 894: BIS_UTILITIES_PVT.Add_Error_Message

890: when others then
891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
892: --added last two params
893: l_error_tbl := x_error_tbl;
894: BIS_UTILITIES_PVT.Add_Error_Message
895: ( p_error_msg_id => SQLCODE
896: , p_error_description => SQLERRM
897: , p_error_proc_name => G_PKG_NAME||'.Val_enable_link_Wrap'
898: , p_error_table => l_error_tbl

Line 939: BIS_UTILITIES_PVT.Add_Error_Message

935: when others then
936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
937: --added last two params
938: l_error_tbl := x_error_tbl;
939: BIS_UTILITIES_PVT.Add_Error_Message
940: ( p_error_msg_id => SQLCODE
941: , p_error_description => SQLERRM
942: , p_error_proc_name => G_PKG_NAME||'.Val_enabled_Wrap'
943: , p_error_table => l_error_tbl

Line 980: BIS_UTILITIES_PVT.Add_Error_Message

976: when others then
977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
978: --added last two params
979: l_error_tbl := x_error_tbl;
980: BIS_UTILITIES_PVT.Add_Error_Message
981: ( p_error_msg_id => SQLCODE
982: , p_error_description => SQLERRM
983: , p_error_proc_name => G_PKG_NAME||'.Val_Obsolete_Wrap'
984: , p_error_table => l_error_tbl

Line 1017: BIS_UTILITIES_PVT.Add_Error_Message

1013: when others then
1014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1015: --added last two params
1016: l_error_tbl := x_error_tbl;
1017: BIS_UTILITIES_PVT.Add_Error_Message
1018: ( p_error_msg_id => SQLCODE
1019: , p_error_description => SQLERRM
1020: , p_error_proc_name => G_PKG_NAME||'.Val_Measure_Type_Wrap'
1021: , p_error_table => l_error_tbl

Line 1059: BIS_UTILITIES_PVT.Add_Error_Message

1055: when others then
1056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1057: --added last two params
1058: l_error_tbl := x_error_tbl;
1059: BIS_UTILITIES_PVT.Add_Error_Message
1060: ( p_error_msg_id => SQLCODE
1061: , p_error_description => SQLERRM
1062: , p_error_proc_name => G_PKG_NAME||'.Validate_Dimension1_ID'
1063: , p_error_table => l_error_tbl

Line 1103: BIS_UTILITIES_PVT.Add_Error_Message

1099: when others then
1100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1101: --added last two params
1102: l_error_tbl := x_error_tbl;
1103: BIS_UTILITIES_PVT.Add_Error_Message
1104: ( p_error_msg_id => SQLCODE
1105: , p_error_description => SQLERRM
1106: , p_error_proc_name => G_PKG_NAME||'.Validate_Dimension2_ID'
1107: , p_error_table => l_error_tbl

Line 1147: BIS_UTILITIES_PVT.Add_Error_Message

1143: when others then
1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1145: --added last two params
1146: l_error_tbl := x_error_tbl;
1147: BIS_UTILITIES_PVT.Add_Error_Message
1148: ( p_error_msg_id => SQLCODE
1149: , p_error_description => SQLERRM
1150: , p_error_proc_name => G_PKG_NAME||'.Validate_Dimension3_ID'
1151: , p_error_table => l_error_tbl

Line 1191: BIS_UTILITIES_PVT.Add_Error_Message

1187: when others then
1188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1189: --added last two params
1190: l_error_tbl := x_error_tbl;
1191: BIS_UTILITIES_PVT.Add_Error_Message
1192: ( p_error_msg_id => SQLCODE
1193: , p_error_description => SQLERRM
1194: , p_error_proc_name => G_PKG_NAME||'.Validate_Dimension4_ID'
1195: , p_error_table => l_error_tbl

Line 1235: BIS_UTILITIES_PVT.Add_Error_Message

1231: when others then
1232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1233: --added last two params
1234: l_error_tbl := x_error_tbl;
1235: BIS_UTILITIES_PVT.Add_Error_Message
1236: ( p_error_msg_id => SQLCODE
1237: , p_error_description => SQLERRM
1238: , p_error_proc_name => G_PKG_NAME||'.Validate_Dimension5_ID'
1239: , p_error_table => l_error_tbl

Line 1279: BIS_UTILITIES_PVT.Add_Error_Message

1275: when others then
1276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1277: --added last two params
1278: l_error_tbl := x_error_tbl;
1279: BIS_UTILITIES_PVT.Add_Error_Message
1280: ( p_error_msg_id => SQLCODE
1281: , p_error_description => SQLERRM
1282: , p_error_proc_name => G_PKG_NAME||'.Validate_Dimension6_ID'
1283: , p_error_table => l_error_tbl

Line 1323: BIS_UTILITIES_PVT.Add_Error_Message

1319: when others then
1320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1321: --added last two params
1322: l_error_tbl := x_error_tbl;
1323: BIS_UTILITIES_PVT.Add_Error_Message
1324: ( p_error_msg_id => SQLCODE
1325: , p_error_description => SQLERRM
1326: , p_error_proc_name => G_PKG_NAME||'.Validate_Dimension7_ID'
1327: , p_error_table => l_error_tbl