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.OZF_THRESHOLD_RULE_PVT dependencies on FND_MSG_PUB

Line 20: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

16:
17:
18: G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_Threshold_Rule_PVT';
19: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvtrub.pls';
20: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
21:
22: -----------------------------------------------------------------------
23: -- PROCEDURE
24: -- calculate_converted_day

Line 173: FND_MSG_PUB.initialize;

169:
170: -- Initialize message list if p_init_msg_list is set to TRUE.
171: IF FND_API.to_Boolean( p_init_msg_list )
172: THEN
173: FND_MSG_PUB.initialize;
174: END IF;
175:
176: -- Debug Message
177: IF G_DEBUG THEN

Line 356: FND_MSG_PUB.Count_And_Get

352: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
353: END IF;
354:
355: -- Standard call to get message count and if count is 1, get message info.
356: FND_MSG_PUB.Count_And_Get
357: (p_count => x_msg_count,
358: p_data => x_msg_data
359: );
360: EXCEPTION

Line 370: FND_MSG_PUB.Count_And_Get (

366: WHEN FND_API.G_EXC_ERROR THEN
367: ROLLBACK TO CREATE_Threshold_Rule_PVT;
368: x_return_status := FND_API.G_RET_STS_ERROR;
369: -- Standard call to get message count and if count=1, get the message
370: FND_MSG_PUB.Count_And_Get (
371: p_encoded => FND_API.G_FALSE,
372: p_count => x_msg_count,
373: p_data => x_msg_data
374: );

Line 380: FND_MSG_PUB.Count_And_Get (

376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
377: ROLLBACK TO CREATE_Threshold_Rule_PVT;
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
379: -- Standard call to get message count and if count=1, get the message
380: FND_MSG_PUB.Count_And_Get (
381: p_encoded => FND_API.G_FALSE,
382: p_count => x_msg_count,
383: p_data => x_msg_data
384: );

Line 389: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

385:
386: WHEN OTHERS THEN
387: ROLLBACK TO CREATE_Threshold_Rule_PVT;
388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
389: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
390: THEN
391: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
392: END IF;
393: -- Standard call to get message count and if count=1, get the message

Line 391: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

387: ROLLBACK TO CREATE_Threshold_Rule_PVT;
388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
389: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
390: THEN
391: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
392: END IF;
393: -- Standard call to get message count and if count=1, get the message
394: FND_MSG_PUB.Count_And_Get (
395: p_encoded => FND_API.G_FALSE,

Line 394: FND_MSG_PUB.Count_And_Get (

390: THEN
391: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
392: END IF;
393: -- Standard call to get message count and if count=1, get the message
394: FND_MSG_PUB.Count_And_Get (
395: p_encoded => FND_API.G_FALSE,
396: p_count => x_msg_count,
397: p_data => x_msg_data
398: );

Line 453: FND_MSG_PUB.initialize;

449:
450: -- Initialize message list if p_init_msg_list is set to TRUE.
451: IF FND_API.to_Boolean( p_init_msg_list )
452: THEN
453: FND_MSG_PUB.initialize;
454: END IF;
455:
456: -- Debug Message
457: IF G_DEBUG THEN

Line 630: FND_MSG_PUB.Count_And_Get

626: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
627: END IF;
628:
629: -- Standard call to get message count and if count is 1, get message info.
630: FND_MSG_PUB.Count_And_Get
631: (p_count => x_msg_count,
632: p_data => x_msg_data
633: );
634: EXCEPTION

Line 644: FND_MSG_PUB.Count_And_Get (

640: WHEN FND_API.G_EXC_ERROR THEN
641: ROLLBACK TO UPDATE_Threshold_Rule_PVT;
642: x_return_status := FND_API.G_RET_STS_ERROR;
643: -- Standard call to get message count and if count=1, get the message
644: FND_MSG_PUB.Count_And_Get (
645: p_encoded => FND_API.G_FALSE,
646: p_count => x_msg_count,
647: p_data => x_msg_data
648: );

Line 654: FND_MSG_PUB.Count_And_Get (

650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
651: ROLLBACK TO UPDATE_Threshold_Rule_PVT;
652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
653: -- Standard call to get message count and if count=1, get the message
654: FND_MSG_PUB.Count_And_Get (
655: p_encoded => FND_API.G_FALSE,
656: p_count => x_msg_count,
657: p_data => x_msg_data
658: );

Line 663: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

659:
660: WHEN OTHERS THEN
661: ROLLBACK TO UPDATE_Threshold_Rule_PVT;
662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
663: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
664: THEN
665: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
666: END IF;
667: -- Standard call to get message count and if count=1, get the message

Line 665: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

661: ROLLBACK TO UPDATE_Threshold_Rule_PVT;
662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
663: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
664: THEN
665: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
666: END IF;
667: -- Standard call to get message count and if count=1, get the message
668: FND_MSG_PUB.Count_And_Get (
669: p_encoded => FND_API.G_FALSE,

Line 668: FND_MSG_PUB.Count_And_Get (

664: THEN
665: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
666: END IF;
667: -- Standard call to get message count and if count=1, get the message
668: FND_MSG_PUB.Count_And_Get (
669: p_encoded => FND_API.G_FALSE,
670: p_count => x_msg_count,
671: p_data => x_msg_data
672: );

Line 709: FND_MSG_PUB.initialize;

705:
706: -- Initialize message list if p_init_msg_list is set to TRUE.
707: IF FND_API.to_Boolean( p_init_msg_list )
708: THEN
709: FND_MSG_PUB.initialize;
710: END IF;
711:
712: -- Debug Message
713: IF G_DEBUG THEN

Line 749: FND_MSG_PUB.Count_And_Get

745: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
746: END IF;
747:
748: -- Standard call to get message count and if count is 1, get message info.
749: FND_MSG_PUB.Count_And_Get
750: (p_count => x_msg_count,
751: p_data => x_msg_data
752: );
753: EXCEPTION

Line 763: FND_MSG_PUB.Count_And_Get (

759: WHEN FND_API.G_EXC_ERROR THEN
760: ROLLBACK TO DELETE_Threshold_Rule_PVT;
761: x_return_status := FND_API.G_RET_STS_ERROR;
762: -- Standard call to get message count and if count=1, get the message
763: FND_MSG_PUB.Count_And_Get (
764: p_encoded => FND_API.G_FALSE,
765: p_count => x_msg_count,
766: p_data => x_msg_data
767: );

Line 773: FND_MSG_PUB.Count_And_Get (

769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
770: ROLLBACK TO DELETE_Threshold_Rule_PVT;
771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
772: -- Standard call to get message count and if count=1, get the message
773: FND_MSG_PUB.Count_And_Get (
774: p_encoded => FND_API.G_FALSE,
775: p_count => x_msg_count,
776: p_data => x_msg_data
777: );

Line 782: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

778:
779: WHEN OTHERS THEN
780: ROLLBACK TO DELETE_Threshold_Rule_PVT;
781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
782: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
783: THEN
784: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
785: END IF;
786: -- Standard call to get message count and if count=1, get the message

Line 784: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

780: ROLLBACK TO DELETE_Threshold_Rule_PVT;
781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
782: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
783: THEN
784: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
785: END IF;
786: -- Standard call to get message count and if count=1, get the message
787: FND_MSG_PUB.Count_And_Get (
788: p_encoded => FND_API.G_FALSE,

Line 787: FND_MSG_PUB.Count_And_Get (

783: THEN
784: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
785: END IF;
786: -- Standard call to get message count and if count=1, get the message
787: FND_MSG_PUB.Count_And_Get (
788: p_encoded => FND_API.G_FALSE,
789: p_count => x_msg_count,
790: p_data => x_msg_data
791: );

Line 832: FND_MSG_PUB.initialize;

828:
829: -- Initialize message list if p_init_msg_list is set to TRUE.
830: IF FND_API.to_Boolean( p_init_msg_list )
831: THEN
832: FND_MSG_PUB.initialize;
833: END IF;
834:
835: -- Standard call to check for call compatibility.
836: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 860: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

856: FETCH c_Threshold_Rule INTO l_THRESHOLD_RULE_ID;
857:
858: IF (c_Threshold_Rule%NOTFOUND) THEN
859: CLOSE c_Threshold_Rule;
860: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
861: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
862: FND_MSG_PUB.add;
863: END IF;
864: RAISE FND_API.g_exc_error;

Line 862: FND_MSG_PUB.add;

858: IF (c_Threshold_Rule%NOTFOUND) THEN
859: CLOSE c_Threshold_Rule;
860: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
861: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
862: FND_MSG_PUB.add;
863: END IF;
864: RAISE FND_API.g_exc_error;
865: END IF;
866:

Line 870: FND_MSG_PUB.count_and_get(

866:
867: CLOSE c_Threshold_Rule;
868:
869: -------------------- finish --------------------------
870: FND_MSG_PUB.count_and_get(
871: p_encoded => FND_API.g_false,
872: p_count => x_msg_count,
873: p_data => x_msg_data);
874: IF G_DEBUG THEN

Line 887: FND_MSG_PUB.Count_And_Get (

883: WHEN FND_API.G_EXC_ERROR THEN
884: ROLLBACK TO LOCK_Threshold_Rule_PVT;
885: x_return_status := FND_API.G_RET_STS_ERROR;
886: -- Standard call to get message count and if count=1, get the message
887: FND_MSG_PUB.Count_And_Get (
888: p_encoded => FND_API.G_FALSE,
889: p_count => x_msg_count,
890: p_data => x_msg_data
891: );

Line 897: FND_MSG_PUB.Count_And_Get (

893: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
894: ROLLBACK TO LOCK_Threshold_Rule_PVT;
895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
896: -- Standard call to get message count and if count=1, get the message
897: FND_MSG_PUB.Count_And_Get (
898: p_encoded => FND_API.G_FALSE,
899: p_count => x_msg_count,
900: p_data => x_msg_data
901: );

Line 906: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

902:
903: WHEN OTHERS THEN
904: ROLLBACK TO LOCK_Threshold_Rule_PVT;
905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
906: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
907: THEN
908: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
909: END IF;
910: -- Standard call to get message count and if count=1, get the message

Line 908: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

904: ROLLBACK TO LOCK_Threshold_Rule_PVT;
905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
906: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
907: THEN
908: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
909: END IF;
910: -- Standard call to get message count and if count=1, get the message
911: FND_MSG_PUB.Count_And_Get (
912: p_encoded => FND_API.G_FALSE,

Line 911: FND_MSG_PUB.Count_And_Get (

907: THEN
908: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
909: END IF;
910: -- Standard call to get message count and if count=1, get the message
911: FND_MSG_PUB.Count_And_Get (
912: p_encoded => FND_API.G_FALSE,
913: p_count => x_msg_count,
914: p_data => x_msg_data
915: );

Line 966: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

962: BEGIN
963: x_return_status := FND_API.g_ret_sts_success;
964:
965: IF p_threshold_rule_rec.start_date IS NULL THEN
966: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
967: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
968: FND_MESSAGE.set_token('COLUMN', 'Start Date');
969: FND_MSG_PUB.add;
970: END IF;

Line 969: FND_MSG_PUB.add;

965: IF p_threshold_rule_rec.start_date IS NULL THEN
966: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
967: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
968: FND_MESSAGE.set_token('COLUMN', 'Start Date');
969: FND_MSG_PUB.add;
970: END IF;
971: x_return_status := FND_API.g_ret_sts_error;
972: RETURN;
973: END IF;

Line 976: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

972: RETURN;
973: END IF;
974:
975: IF p_threshold_rule_rec.end_date IS NULL THEN
976: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
977: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
978: FND_MESSAGE.set_token('COLUMN', 'End Date');
979: FND_MSG_PUB.add;
980: END IF;

Line 979: FND_MSG_PUB.add;

975: IF p_threshold_rule_rec.end_date IS NULL THEN
976: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
977: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
978: FND_MESSAGE.set_token('COLUMN', 'End Date');
979: FND_MSG_PUB.add;
980: END IF;
981: x_return_status := FND_API.g_ret_sts_error;
982: RETURN;
983: END IF;

Line 986: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

982: RETURN;
983: END IF;
984:
985: IF p_threshold_rule_rec.value_limit IS NULL THEN
986: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
987: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
988: FND_MESSAGE.set_token('COLUMN', 'Value Limit');
989: FND_MSG_PUB.add;
990: END IF;

Line 989: FND_MSG_PUB.add;

985: IF p_threshold_rule_rec.value_limit IS NULL THEN
986: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
987: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
988: FND_MESSAGE.set_token('COLUMN', 'Value Limit');
989: FND_MSG_PUB.add;
990: END IF;
991: x_return_status := FND_API.g_ret_sts_error;
992: RETURN;
993: END IF;

Line 996: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

992: RETURN;
993: END IF;
994:
995: IF p_threshold_rule_rec.operator_code IS NULL THEN
996: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
997: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
998: FND_MESSAGE.set_token('COLUMN', 'Operator');
999: FND_MSG_PUB.add;
1000: END IF;

Line 999: FND_MSG_PUB.add;

995: IF p_threshold_rule_rec.operator_code IS NULL THEN
996: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
997: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
998: FND_MESSAGE.set_token('COLUMN', 'Operator');
999: FND_MSG_PUB.add;
1000: END IF;
1001: x_return_status := FND_API.g_ret_sts_error;
1002: RETURN;
1003: END IF;

Line 1013: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1009:
1010: IF l_threshold_type IS NOT NULL THEN
1011: IF l_threshold_type = 'QUOTA' THEN
1012: IF p_threshold_rule_rec.comparison_type IS NULL THEN
1013: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1014: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1015: FND_MESSAGE.set_token('COLUMN', 'Comparision Type');
1016: FND_MSG_PUB.add;
1017: END IF;

Line 1016: FND_MSG_PUB.add;

1012: IF p_threshold_rule_rec.comparison_type IS NULL THEN
1013: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1014: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1015: FND_MESSAGE.set_token('COLUMN', 'Comparision Type');
1016: FND_MSG_PUB.add;
1017: END IF;
1018: x_return_status := FND_API.g_ret_sts_error;
1019: RETURN;
1020: END IF;

Line 1022: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1018: x_return_status := FND_API.g_ret_sts_error;
1019: RETURN;
1020: END IF;
1021: IF p_threshold_rule_rec.percent_amount IS NULL THEN
1022: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1023: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1024: FND_MESSAGE.set_token('COLUMN', 'Comparision Value');
1025: FND_MSG_PUB.add;
1026: END IF;

Line 1025: FND_MSG_PUB.add;

1021: IF p_threshold_rule_rec.percent_amount IS NULL THEN
1022: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1023: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1024: FND_MESSAGE.set_token('COLUMN', 'Comparision Value');
1025: FND_MSG_PUB.add;
1026: END IF;
1027: x_return_status := FND_API.g_ret_sts_error;
1028: RETURN;
1029: END IF;

Line 1032: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1028: RETURN;
1029: END IF;
1030: IF p_threshold_rule_rec.comparison_type = 'PERCENT' THEN
1031: IF p_threshold_rule_rec.base_line IS NULL THEN
1032: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1033: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1034: FND_MESSAGE.set_token('COLUMN', 'OfBaseline');
1035: FND_MSG_PUB.add;
1036: END IF;

Line 1035: FND_MSG_PUB.add;

1031: IF p_threshold_rule_rec.base_line IS NULL THEN
1032: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1033: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1034: FND_MESSAGE.set_token('COLUMN', 'OfBaseline');
1035: FND_MSG_PUB.add;
1036: END IF;
1037: x_return_status := FND_API.g_ret_sts_error;
1038: RETURN;
1039: END IF;

Line 1042: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1038: RETURN;
1039: END IF;
1040: END IF;
1041: IF p_threshold_rule_rec.repeat_frequency IS NULL THEN
1042: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1043: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1044: FND_MESSAGE.set_token('COLUMN', 'Frequency');
1045: FND_MSG_PUB.add;
1046: END IF;

Line 1045: FND_MSG_PUB.add;

1041: IF p_threshold_rule_rec.repeat_frequency IS NULL THEN
1042: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1043: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1044: FND_MESSAGE.set_token('COLUMN', 'Frequency');
1045: FND_MSG_PUB.add;
1046: END IF;
1047: x_return_status := FND_API.g_ret_sts_error;
1048: RETURN;
1049: END IF;

Line 1051: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1047: x_return_status := FND_API.g_ret_sts_error;
1048: RETURN;
1049: END IF;
1050: IF p_threshold_rule_rec.frequency_period IS NULL THEN
1051: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1052: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1053: FND_MESSAGE.set_token('COLUMN', 'Period Type');
1054: FND_MSG_PUB.add;
1055: END IF;

Line 1054: FND_MSG_PUB.add;

1050: IF p_threshold_rule_rec.frequency_period IS NULL THEN
1051: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1052: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1053: FND_MESSAGE.set_token('COLUMN', 'Period Type');
1054: FND_MSG_PUB.add;
1055: END IF;
1056: x_return_status := FND_API.g_ret_sts_error;
1057: RETURN;
1058: END IF;

Line 1060: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1056: x_return_status := FND_API.g_ret_sts_error;
1057: RETURN;
1058: END IF;
1059: IF p_threshold_rule_rec.alert_type IS NULL THEN
1060: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1061: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1062: FND_MESSAGE.set_token('COLUMN', 'Alert Type');
1063: FND_MSG_PUB.add;
1064: END IF;

Line 1063: FND_MSG_PUB.add;

1059: IF p_threshold_rule_rec.alert_type IS NULL THEN
1060: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1061: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1062: FND_MESSAGE.set_token('COLUMN', 'Alert Type');
1063: FND_MSG_PUB.add;
1064: END IF;
1065: x_return_status := FND_API.g_ret_sts_error;
1066: RETURN;
1067: END IF;

Line 1070: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1066: RETURN;
1067: END IF;
1068: ELSIF l_threshold_type = 'BUDGET' THEN
1069: IF p_threshold_rule_rec.percent_amount IS NULL THEN
1070: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1071: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1072: FND_MESSAGE.set_token('COLUMN', 'Percent');
1073: FND_MSG_PUB.add;
1074: END IF;

Line 1073: FND_MSG_PUB.add;

1069: IF p_threshold_rule_rec.percent_amount IS NULL THEN
1070: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1071: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1072: FND_MESSAGE.set_token('COLUMN', 'Percent');
1073: FND_MSG_PUB.add;
1074: END IF;
1075: x_return_status := FND_API.g_ret_sts_error;
1076: RETURN;
1077: END IF;

Line 1079: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1075: x_return_status := FND_API.g_ret_sts_error;
1076: RETURN;
1077: END IF;
1078: IF p_threshold_rule_rec.base_line IS NULL THEN
1079: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1080: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1081: FND_MESSAGE.set_token('COLUMN', 'OfBaseline');
1082: FND_MSG_PUB.add;
1083: END IF;

Line 1082: FND_MSG_PUB.add;

1078: IF p_threshold_rule_rec.base_line IS NULL THEN
1079: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1080: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1081: FND_MESSAGE.set_token('COLUMN', 'OfBaseline');
1082: FND_MSG_PUB.add;
1083: END IF;
1084: x_return_status := FND_API.g_ret_sts_error;
1085: RETURN;
1086: END IF;

Line 1088: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1084: x_return_status := FND_API.g_ret_sts_error;
1085: RETURN;
1086: END IF;
1087: IF p_threshold_rule_rec.repeat_frequency IS NULL THEN
1088: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1089: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1090: FND_MESSAGE.set_token('COLUMN', 'Frequency');
1091: FND_MSG_PUB.add;
1092: END IF;

Line 1091: FND_MSG_PUB.add;

1087: IF p_threshold_rule_rec.repeat_frequency IS NULL THEN
1088: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1089: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1090: FND_MESSAGE.set_token('COLUMN', 'Frequency');
1091: FND_MSG_PUB.add;
1092: END IF;
1093: x_return_status := FND_API.g_ret_sts_error;
1094: RETURN;
1095: END IF;

Line 1097: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1093: x_return_status := FND_API.g_ret_sts_error;
1094: RETURN;
1095: END IF;
1096: IF p_threshold_rule_rec.frequency_period IS NULL THEN
1097: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1098: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1099: FND_MESSAGE.set_token('COLUMN', 'Period Type');
1100: FND_MSG_PUB.add;
1101: END IF;

Line 1100: FND_MSG_PUB.add;

1096: IF p_threshold_rule_rec.frequency_period IS NULL THEN
1097: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1098: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1099: FND_MESSAGE.set_token('COLUMN', 'Period Type');
1100: FND_MSG_PUB.add;
1101: END IF;
1102: x_return_status := FND_API.g_ret_sts_error;
1103: RETURN;
1104: END IF;

Line 1712: FND_MSG_PUB.initialize;

1708:
1709: -- Initialize message list if p_init_msg_list is set to TRUE.
1710: IF FND_API.to_Boolean( p_init_msg_list )
1711: THEN
1712: FND_MSG_PUB.initialize;
1713: END IF;
1714:
1715: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1716: Check_threshold_rule_Items(

Line 1751: FND_MSG_PUB.Count_And_Get

1747: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1748: END IF;
1749:
1750: -- Standard call to get message count and if count is 1, get message info.
1751: FND_MSG_PUB.Count_And_Get
1752: (p_count => x_msg_count,
1753: p_data => x_msg_data
1754: );
1755: EXCEPTION

Line 1765: FND_MSG_PUB.Count_And_Get (

1761: WHEN FND_API.G_EXC_ERROR THEN
1762: ROLLBACK TO VALIDATE_Threshold_Rule_;
1763: x_return_status := FND_API.G_RET_STS_ERROR;
1764: -- Standard call to get message count and if count=1, get the message
1765: FND_MSG_PUB.Count_And_Get (
1766: p_encoded => FND_API.G_FALSE,
1767: p_count => x_msg_count,
1768: p_data => x_msg_data
1769: );

Line 1775: FND_MSG_PUB.Count_And_Get (

1771: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1772: ROLLBACK TO VALIDATE_Threshold_Rule_;
1773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1774: -- Standard call to get message count and if count=1, get the message
1775: FND_MSG_PUB.Count_And_Get (
1776: p_encoded => FND_API.G_FALSE,
1777: p_count => x_msg_count,
1778: p_data => x_msg_data
1779: );

Line 1784: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1780:
1781: WHEN OTHERS THEN
1782: ROLLBACK TO VALIDATE_Threshold_Rule_;
1783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1784: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1785: THEN
1786: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1787: END IF;
1788: -- Standard call to get message count and if count=1, get the message

Line 1786: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1782: ROLLBACK TO VALIDATE_Threshold_Rule_;
1783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1784: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1785: THEN
1786: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1787: END IF;
1788: -- Standard call to get message count and if count=1, get the message
1789: FND_MSG_PUB.Count_And_Get (
1790: p_encoded => FND_API.G_FALSE,

Line 1789: FND_MSG_PUB.Count_And_Get (

1785: THEN
1786: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1787: END IF;
1788: -- Standard call to get message count and if count=1, get the message
1789: FND_MSG_PUB.Count_And_Get (
1790: p_encoded => FND_API.G_FALSE,
1791: p_count => x_msg_count,
1792: p_data => x_msg_data
1793: );

Line 1812: FND_MSG_PUB.initialize;

1808: BEGIN
1809: -- Initialize message list if p_init_msg_list is set to TRUE.
1810: IF FND_API.to_Boolean( p_init_msg_list )
1811: THEN
1812: FND_MSG_PUB.initialize;
1813: END IF;
1814:
1815: -- Initialize API return status to SUCCESS
1816: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1844: FND_MSG_PUB.Count_And_Get

1840: IF G_DEBUG THEN
1841: OZF_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1842: END IF;
1843: -- Standard call to get message count and if count is 1, get message info.
1844: FND_MSG_PUB.Count_And_Get
1845: (p_count => x_msg_count,
1846: p_data => x_msg_data
1847: );
1848: END Validate_threshold_rule_Rec;