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_MO_PRESET_TIERS_PVT dependencies on FND_API

Line 30: x_return_status := FND_API.G_RET_STS_SUCCESS;

26: , x_return_status OUT NOCOPY VARCHAR2
27: )
28: IS
29: BEGIN
30: x_return_status := FND_API.G_RET_STS_SUCCESS;
31: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
32: IF p_preset_tier_rec.offer_market_option_id IS NULL OR p_preset_tier_rec.offer_market_option_id = FND_API.G_MISS_NUM THEN
33: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_market_option_id');
34: x_return_status := FND_API.g_ret_sts_error;

Line 32: IF p_preset_tier_rec.offer_market_option_id IS NULL OR p_preset_tier_rec.offer_market_option_id = FND_API.G_MISS_NUM THEN

28: IS
29: BEGIN
30: x_return_status := FND_API.G_RET_STS_SUCCESS;
31: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
32: IF p_preset_tier_rec.offer_market_option_id IS NULL OR p_preset_tier_rec.offer_market_option_id = FND_API.G_MISS_NUM THEN
33: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_market_option_id');
34: x_return_status := FND_API.g_ret_sts_error;
35: return;
36: END IF;

Line 34: x_return_status := FND_API.g_ret_sts_error;

30: x_return_status := FND_API.G_RET_STS_SUCCESS;
31: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
32: IF p_preset_tier_rec.offer_market_option_id IS NULL OR p_preset_tier_rec.offer_market_option_id = FND_API.G_MISS_NUM THEN
33: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_market_option_id');
34: x_return_status := FND_API.g_ret_sts_error;
35: return;
36: END IF;
37: IF p_preset_tier_rec.pbh_offer_discount_id IS NULL OR p_preset_tier_rec.pbh_offer_discount_id = FND_API.G_MISS_NUM THEN
38: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','pbh_offer_discount_id');

Line 37: IF p_preset_tier_rec.pbh_offer_discount_id IS NULL OR p_preset_tier_rec.pbh_offer_discount_id = FND_API.G_MISS_NUM THEN

33: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_market_option_id');
34: x_return_status := FND_API.g_ret_sts_error;
35: return;
36: END IF;
37: IF p_preset_tier_rec.pbh_offer_discount_id IS NULL OR p_preset_tier_rec.pbh_offer_discount_id = FND_API.G_MISS_NUM THEN
38: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','pbh_offer_discount_id');
39: x_return_status := FND_API.g_ret_sts_error;
40: return;
41: END IF;

Line 39: x_return_status := FND_API.g_ret_sts_error;

35: return;
36: END IF;
37: IF p_preset_tier_rec.pbh_offer_discount_id IS NULL OR p_preset_tier_rec.pbh_offer_discount_id = FND_API.G_MISS_NUM THEN
38: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','pbh_offer_discount_id');
39: x_return_status := FND_API.g_ret_sts_error;
40: return;
41: END IF;
42: IF p_preset_tier_rec.dis_offer_discount_id IS NULL OR p_preset_tier_rec.dis_offer_discount_id = FND_API.G_MISS_NUM THEN
43: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','dis_offer_discount_id');

Line 42: IF p_preset_tier_rec.dis_offer_discount_id IS NULL OR p_preset_tier_rec.dis_offer_discount_id = FND_API.G_MISS_NUM THEN

38: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','pbh_offer_discount_id');
39: x_return_status := FND_API.g_ret_sts_error;
40: return;
41: END IF;
42: IF p_preset_tier_rec.dis_offer_discount_id IS NULL OR p_preset_tier_rec.dis_offer_discount_id = FND_API.G_MISS_NUM THEN
43: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','dis_offer_discount_id');
44: x_return_status := FND_API.g_ret_sts_error;
45: return;
46: END IF;

Line 44: x_return_status := FND_API.g_ret_sts_error;

40: return;
41: END IF;
42: IF p_preset_tier_rec.dis_offer_discount_id IS NULL OR p_preset_tier_rec.dis_offer_discount_id = FND_API.G_MISS_NUM THEN
43: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','dis_offer_discount_id');
44: x_return_status := FND_API.g_ret_sts_error;
45: return;
46: END IF;
47: ELSE
48: IF p_preset_tier_rec.market_preset_tier_id = FND_API.G_MISS_NUM THEN

Line 48: IF p_preset_tier_rec.market_preset_tier_id = FND_API.G_MISS_NUM THEN

44: x_return_status := FND_API.g_ret_sts_error;
45: return;
46: END IF;
47: ELSE
48: IF p_preset_tier_rec.market_preset_tier_id = FND_API.G_MISS_NUM THEN
49: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','market_preset_tier_id');
50: x_return_status := FND_API.g_ret_sts_error;
51: return;
52: END IF;

Line 50: x_return_status := FND_API.g_ret_sts_error;

46: END IF;
47: ELSE
48: IF p_preset_tier_rec.market_preset_tier_id = FND_API.G_MISS_NUM THEN
49: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','market_preset_tier_id');
50: x_return_status := FND_API.g_ret_sts_error;
51: return;
52: END IF;
53: IF p_preset_tier_rec.offer_market_option_id = FND_API.G_MISS_NUM THEN
54: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_market_option_id');

Line 53: IF p_preset_tier_rec.offer_market_option_id = FND_API.G_MISS_NUM THEN

49: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','market_preset_tier_id');
50: x_return_status := FND_API.g_ret_sts_error;
51: return;
52: END IF;
53: IF p_preset_tier_rec.offer_market_option_id = FND_API.G_MISS_NUM THEN
54: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_market_option_id');
55: x_return_status := FND_API.g_ret_sts_error;
56: return;
57: END IF;

Line 55: x_return_status := FND_API.g_ret_sts_error;

51: return;
52: END IF;
53: IF p_preset_tier_rec.offer_market_option_id = FND_API.G_MISS_NUM THEN
54: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_market_option_id');
55: x_return_status := FND_API.g_ret_sts_error;
56: return;
57: END IF;
58: IF p_preset_tier_rec.pbh_offer_discount_id = FND_API.G_MISS_NUM THEN
59: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','pbh_offer_discount_id');

Line 58: IF p_preset_tier_rec.pbh_offer_discount_id = FND_API.G_MISS_NUM THEN

54: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','offer_market_option_id');
55: x_return_status := FND_API.g_ret_sts_error;
56: return;
57: END IF;
58: IF p_preset_tier_rec.pbh_offer_discount_id = FND_API.G_MISS_NUM THEN
59: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','pbh_offer_discount_id');
60: x_return_status := FND_API.g_ret_sts_error;
61: return;
62: END IF;

Line 60: x_return_status := FND_API.g_ret_sts_error;

56: return;
57: END IF;
58: IF p_preset_tier_rec.pbh_offer_discount_id = FND_API.G_MISS_NUM THEN
59: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','pbh_offer_discount_id');
60: x_return_status := FND_API.g_ret_sts_error;
61: return;
62: END IF;
63: IF p_preset_tier_rec.dis_offer_discount_id = FND_API.G_MISS_NUM THEN
64: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','dis_offer_discount_id');

Line 63: IF p_preset_tier_rec.dis_offer_discount_id = FND_API.G_MISS_NUM THEN

59: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','pbh_offer_discount_id');
60: x_return_status := FND_API.g_ret_sts_error;
61: return;
62: END IF;
63: IF p_preset_tier_rec.dis_offer_discount_id = FND_API.G_MISS_NUM THEN
64: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','dis_offer_discount_id');
65: x_return_status := FND_API.g_ret_sts_error;
66: return;
67: END IF;

Line 65: x_return_status := FND_API.g_ret_sts_error;

61: return;
62: END IF;
63: IF p_preset_tier_rec.dis_offer_discount_id = FND_API.G_MISS_NUM THEN
64: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','dis_offer_discount_id');
65: x_return_status := FND_API.g_ret_sts_error;
66: return;
67: END IF;
68: IF p_preset_tier_rec.object_version_number = FND_API.G_MISS_NUM THEN
69: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','object_version_number');

Line 68: IF p_preset_tier_rec.object_version_number = FND_API.G_MISS_NUM THEN

64: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','dis_offer_discount_id');
65: x_return_status := FND_API.g_ret_sts_error;
66: return;
67: END IF;
68: IF p_preset_tier_rec.object_version_number = FND_API.G_MISS_NUM THEN
69: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','object_version_number');
70: x_return_status := FND_API.g_ret_sts_error;
71: return;
72: END IF;

Line 70: x_return_status := FND_API.g_ret_sts_error;

66: return;
67: END IF;
68: IF p_preset_tier_rec.object_version_number = FND_API.G_MISS_NUM THEN
69: OZF_Utility_PVT.Error_Message('OZF_API_MISSING_FIELD','MISS_FIELD','object_version_number');
70: x_return_status := FND_API.g_ret_sts_error;
71: return;
72: END IF;
73: END IF;
74:

Line 85: x_return_status := FND_API.G_RET_STS_SUCCESS;

81: , x_return_status OUT NOCOPY VARCHAR2
82: )
83: IS
84: BEGIN
85: x_return_status := FND_API.G_RET_STS_SUCCESS;
86: IF p_validation_mode = JTF_PLSQL_API.G_CREATE THEN
87: IF p_preset_tier_rec.market_preset_tier_id IS NOT NULL AND p_preset_tier_rec.market_preset_tier_id <> FND_API.G_MISS_NUM THEN
88: IF ozf_utility_pvt.check_uniqueness('ozf_market_preset_tiers','market_preset_tier_id = '||p_preset_tier_rec.market_preset_tier_id) = FND_API.g_false THEN
89: OZF_Utility_PVT.Error_Message('OZF_MO_PRESET_ID_DUP');

Line 87: IF p_preset_tier_rec.market_preset_tier_id IS NOT NULL AND p_preset_tier_rec.market_preset_tier_id <> FND_API.G_MISS_NUM THEN

83: IS
84: BEGIN
85: x_return_status := FND_API.G_RET_STS_SUCCESS;
86: IF p_validation_mode = JTF_PLSQL_API.G_CREATE THEN
87: IF p_preset_tier_rec.market_preset_tier_id IS NOT NULL AND p_preset_tier_rec.market_preset_tier_id <> FND_API.G_MISS_NUM THEN
88: IF ozf_utility_pvt.check_uniqueness('ozf_market_preset_tiers','market_preset_tier_id = '||p_preset_tier_rec.market_preset_tier_id) = FND_API.g_false THEN
89: OZF_Utility_PVT.Error_Message('OZF_MO_PRESET_ID_DUP');
90: x_return_status := FND_API.g_ret_sts_error;
91: return;

Line 88: IF ozf_utility_pvt.check_uniqueness('ozf_market_preset_tiers','market_preset_tier_id = '||p_preset_tier_rec.market_preset_tier_id) = FND_API.g_false THEN

84: BEGIN
85: x_return_status := FND_API.G_RET_STS_SUCCESS;
86: IF p_validation_mode = JTF_PLSQL_API.G_CREATE THEN
87: IF p_preset_tier_rec.market_preset_tier_id IS NOT NULL AND p_preset_tier_rec.market_preset_tier_id <> FND_API.G_MISS_NUM THEN
88: IF ozf_utility_pvt.check_uniqueness('ozf_market_preset_tiers','market_preset_tier_id = '||p_preset_tier_rec.market_preset_tier_id) = FND_API.g_false THEN
89: OZF_Utility_PVT.Error_Message('OZF_MO_PRESET_ID_DUP');
90: x_return_status := FND_API.g_ret_sts_error;
91: return;
92: END IF;

Line 90: x_return_status := FND_API.g_ret_sts_error;

86: IF p_validation_mode = JTF_PLSQL_API.G_CREATE THEN
87: IF p_preset_tier_rec.market_preset_tier_id IS NOT NULL AND p_preset_tier_rec.market_preset_tier_id <> FND_API.G_MISS_NUM THEN
88: IF ozf_utility_pvt.check_uniqueness('ozf_market_preset_tiers','market_preset_tier_id = '||p_preset_tier_rec.market_preset_tier_id) = FND_API.g_false THEN
89: OZF_Utility_PVT.Error_Message('OZF_MO_PRESET_ID_DUP');
90: x_return_status := FND_API.g_ret_sts_error;
91: return;
92: END IF;
93: END IF;
94: END IF;

Line 99: p_preset_tier_rec.offer_market_option_id IS NOT NULL AND p_preset_tier_rec.offer_market_option_id <> FND_API.G_MISS_NUM

95:
96: IF p_validation_mode = JTF_PLSQL_API.G_UPDATE THEN
97: IF
98: (
99: p_preset_tier_rec.offer_market_option_id IS NOT NULL AND p_preset_tier_rec.offer_market_option_id <> FND_API.G_MISS_NUM
100: )
101: AND
102: (
103: p_preset_tier_rec.pbh_offer_discount_id IS NOT NULL AND p_preset_tier_rec.pbh_offer_discount_id <> FND_API.G_MISS_NUM

Line 103: p_preset_tier_rec.pbh_offer_discount_id IS NOT NULL AND p_preset_tier_rec.pbh_offer_discount_id <> FND_API.G_MISS_NUM

99: p_preset_tier_rec.offer_market_option_id IS NOT NULL AND p_preset_tier_rec.offer_market_option_id <> FND_API.G_MISS_NUM
100: )
101: AND
102: (
103: p_preset_tier_rec.pbh_offer_discount_id IS NOT NULL AND p_preset_tier_rec.pbh_offer_discount_id <> FND_API.G_MISS_NUM
104: )
105: AND
106: (
107: p_preset_tier_rec.dis_offer_discount_id IS NOT NULL AND p_preset_tier_rec.dis_offer_discount_id <> FND_API.G_MISS_NUM

Line 107: p_preset_tier_rec.dis_offer_discount_id IS NOT NULL AND p_preset_tier_rec.dis_offer_discount_id <> FND_API.G_MISS_NUM

103: p_preset_tier_rec.pbh_offer_discount_id IS NOT NULL AND p_preset_tier_rec.pbh_offer_discount_id <> FND_API.G_MISS_NUM
104: )
105: AND
106: (
107: p_preset_tier_rec.dis_offer_discount_id IS NOT NULL AND p_preset_tier_rec.dis_offer_discount_id <> FND_API.G_MISS_NUM
108: )
109: AND
110: (
111: p_preset_tier_rec.market_preset_tier_id IS NOT NULL AND p_preset_tier_rec.market_preset_tier_id <> FND_API.G_MISS_NUM

Line 111: p_preset_tier_rec.market_preset_tier_id IS NOT NULL AND p_preset_tier_rec.market_preset_tier_id <> FND_API.G_MISS_NUM

107: p_preset_tier_rec.dis_offer_discount_id IS NOT NULL AND p_preset_tier_rec.dis_offer_discount_id <> FND_API.G_MISS_NUM
108: )
109: AND
110: (
111: p_preset_tier_rec.market_preset_tier_id IS NOT NULL AND p_preset_tier_rec.market_preset_tier_id <> FND_API.G_MISS_NUM
112: )
113: THEN
114: IF ozf_utility_pvt.check_uniqueness('ozf_market_preset_tiers'
115: ,'offer_market_option_id = '||p_preset_tier_rec.offer_market_option_id

Line 120: = FND_API.G_FALSE

116: ||' AND pbh_offer_discount_id = '|| p_preset_tier_rec.pbh_offer_discount_id
117: || ' AND dis_offer_discount_id = '||p_preset_tier_rec.dis_offer_discount_id
118: || ' AND market_preset_tier_id <> ' ||p_preset_tier_rec.market_preset_tier_id
119: )
120: = FND_API.G_FALSE
121: THEN
122: OZF_Utility_PVT.Error_Message('OZF_MO_PRESTE_TIER_DUP');
123: x_return_status := FND_API.g_ret_sts_error;
124: return;

Line 123: x_return_status := FND_API.g_ret_sts_error;

119: )
120: = FND_API.G_FALSE
121: THEN
122: OZF_Utility_PVT.Error_Message('OZF_MO_PRESTE_TIER_DUP');
123: x_return_status := FND_API.g_ret_sts_error;
124: return;
125: END IF;
126: END IF;
127: ELSE

Line 130: p_preset_tier_rec.offer_market_option_id IS NOT NULL AND p_preset_tier_rec.offer_market_option_id <> FND_API.G_MISS_NUM

126: END IF;
127: ELSE
128: IF
129: (
130: p_preset_tier_rec.offer_market_option_id IS NOT NULL AND p_preset_tier_rec.offer_market_option_id <> FND_API.G_MISS_NUM
131: )
132: AND
133: (
134: p_preset_tier_rec.pbh_offer_discount_id IS NOT NULL AND p_preset_tier_rec.pbh_offer_discount_id <> FND_API.G_MISS_NUM

Line 134: p_preset_tier_rec.pbh_offer_discount_id IS NOT NULL AND p_preset_tier_rec.pbh_offer_discount_id <> FND_API.G_MISS_NUM

130: p_preset_tier_rec.offer_market_option_id IS NOT NULL AND p_preset_tier_rec.offer_market_option_id <> FND_API.G_MISS_NUM
131: )
132: AND
133: (
134: p_preset_tier_rec.pbh_offer_discount_id IS NOT NULL AND p_preset_tier_rec.pbh_offer_discount_id <> FND_API.G_MISS_NUM
135: )
136: AND
137: (
138: p_preset_tier_rec.dis_offer_discount_id IS NOT NULL AND p_preset_tier_rec.dis_offer_discount_id <> FND_API.G_MISS_NUM

Line 138: p_preset_tier_rec.dis_offer_discount_id IS NOT NULL AND p_preset_tier_rec.dis_offer_discount_id <> FND_API.G_MISS_NUM

134: p_preset_tier_rec.pbh_offer_discount_id IS NOT NULL AND p_preset_tier_rec.pbh_offer_discount_id <> FND_API.G_MISS_NUM
135: )
136: AND
137: (
138: p_preset_tier_rec.dis_offer_discount_id IS NOT NULL AND p_preset_tier_rec.dis_offer_discount_id <> FND_API.G_MISS_NUM
139: )
140: THEN
141: IF ozf_utility_pvt.check_uniqueness('ozf_market_preset_tiers'
142: ,'offer_market_option_id = '||p_preset_tier_rec.offer_market_option_id ||' AND pbh_offer_discount_id = '|| p_preset_tier_rec.pbh_offer_discount_id || ' AND dis_offer_discount_id = '||p_preset_tier_rec.dis_offer_discount_id ) = FND_API.G_FALSE

Line 142: ,'offer_market_option_id = '||p_preset_tier_rec.offer_market_option_id ||' AND pbh_offer_discount_id = '|| p_preset_tier_rec.pbh_offer_discount_id || ' AND dis_offer_discount_id = '||p_preset_tier_rec.dis_offer_discount_id ) = FND_API.G_FALSE

138: p_preset_tier_rec.dis_offer_discount_id IS NOT NULL AND p_preset_tier_rec.dis_offer_discount_id <> FND_API.G_MISS_NUM
139: )
140: THEN
141: IF ozf_utility_pvt.check_uniqueness('ozf_market_preset_tiers'
142: ,'offer_market_option_id = '||p_preset_tier_rec.offer_market_option_id ||' AND pbh_offer_discount_id = '|| p_preset_tier_rec.pbh_offer_discount_id || ' AND dis_offer_discount_id = '||p_preset_tier_rec.dis_offer_discount_id ) = FND_API.G_FALSE
143: THEN
144: OZF_Utility_PVT.Error_Message('OZF_MO_PRESTE_TIER_DUP');
145: x_return_status := FND_API.g_ret_sts_error;
146: return;

Line 145: x_return_status := FND_API.g_ret_sts_error;

141: IF ozf_utility_pvt.check_uniqueness('ozf_market_preset_tiers'
142: ,'offer_market_option_id = '||p_preset_tier_rec.offer_market_option_id ||' AND pbh_offer_discount_id = '|| p_preset_tier_rec.pbh_offer_discount_id || ' AND dis_offer_discount_id = '||p_preset_tier_rec.dis_offer_discount_id ) = FND_API.G_FALSE
143: THEN
144: OZF_Utility_PVT.Error_Message('OZF_MO_PRESTE_TIER_DUP');
145: x_return_status := FND_API.g_ret_sts_error;
146: return;
147: END IF;
148: END IF;
149:

Line 171: x_return_status := FND_API.G_RET_STS_SUCCESS;

167: SELECT 1 FROM dual WHERE EXISTS (SELECT 'X' FROM ozf_offer_discount_lines WHERE offer_discount_line_id = p_dis_discount_id AND tier_type = 'DIS');
168:
169: l_dummy NUMBER;
170: BEGIN
171: x_return_status := FND_API.G_RET_STS_SUCCESS;
172: IF p_preset_tier_rec.offer_market_option_id IS NOT NULL AND p_preset_tier_rec.offer_market_option_id <> FND_API.G_MISS_NUM THEN
173: IF ozf_utility_pvt.check_fk_exists('ozf_offr_market_options','offer_market_option_id',to_char(p_preset_tier_rec.offer_market_option_id)) = FND_API.G_FALSE THEN
174: OZF_Utility_PVT.Error_Message('OZF_MO_PRESET_TIER_INV_MO_ID');
175: x_return_status := FND_API.g_ret_sts_error;

Line 172: IF p_preset_tier_rec.offer_market_option_id IS NOT NULL AND p_preset_tier_rec.offer_market_option_id <> FND_API.G_MISS_NUM THEN

168:
169: l_dummy NUMBER;
170: BEGIN
171: x_return_status := FND_API.G_RET_STS_SUCCESS;
172: IF p_preset_tier_rec.offer_market_option_id IS NOT NULL AND p_preset_tier_rec.offer_market_option_id <> FND_API.G_MISS_NUM THEN
173: IF ozf_utility_pvt.check_fk_exists('ozf_offr_market_options','offer_market_option_id',to_char(p_preset_tier_rec.offer_market_option_id)) = FND_API.G_FALSE THEN
174: OZF_Utility_PVT.Error_Message('OZF_MO_PRESET_TIER_INV_MO_ID');
175: x_return_status := FND_API.g_ret_sts_error;
176: return;

Line 173: IF ozf_utility_pvt.check_fk_exists('ozf_offr_market_options','offer_market_option_id',to_char(p_preset_tier_rec.offer_market_option_id)) = FND_API.G_FALSE THEN

169: l_dummy NUMBER;
170: BEGIN
171: x_return_status := FND_API.G_RET_STS_SUCCESS;
172: IF p_preset_tier_rec.offer_market_option_id IS NOT NULL AND p_preset_tier_rec.offer_market_option_id <> FND_API.G_MISS_NUM THEN
173: IF ozf_utility_pvt.check_fk_exists('ozf_offr_market_options','offer_market_option_id',to_char(p_preset_tier_rec.offer_market_option_id)) = FND_API.G_FALSE THEN
174: OZF_Utility_PVT.Error_Message('OZF_MO_PRESET_TIER_INV_MO_ID');
175: x_return_status := FND_API.g_ret_sts_error;
176: return;
177: END IF;

Line 175: x_return_status := FND_API.g_ret_sts_error;

171: x_return_status := FND_API.G_RET_STS_SUCCESS;
172: IF p_preset_tier_rec.offer_market_option_id IS NOT NULL AND p_preset_tier_rec.offer_market_option_id <> FND_API.G_MISS_NUM THEN
173: IF ozf_utility_pvt.check_fk_exists('ozf_offr_market_options','offer_market_option_id',to_char(p_preset_tier_rec.offer_market_option_id)) = FND_API.G_FALSE THEN
174: OZF_Utility_PVT.Error_Message('OZF_MO_PRESET_TIER_INV_MO_ID');
175: x_return_status := FND_API.g_ret_sts_error;
176: return;
177: END IF;
178: END IF;
179:

Line 180: IF p_preset_tier_rec.pbh_offer_discount_id IS NOT NULL AND p_preset_tier_rec.pbh_offer_discount_id <> FND_API.G_MISS_NUM THEN

176: return;
177: END IF;
178: END IF;
179:
180: IF p_preset_tier_rec.pbh_offer_discount_id IS NOT NULL AND p_preset_tier_rec.pbh_offer_discount_id <> FND_API.G_MISS_NUM THEN
181: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_DISCOUNT_LINES','offer_discount_line_id',to_char(p_preset_tier_rec.pbh_offer_discount_id)) =FND_API.G_FALSE THEN
182: OZF_Utility_PVT.Error_Message('OZF_MO_PRESET_TIER_INV_PBH_ID');
183: x_return_status := FND_API.g_ret_sts_error;
184: return;

Line 181: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_DISCOUNT_LINES','offer_discount_line_id',to_char(p_preset_tier_rec.pbh_offer_discount_id)) =FND_API.G_FALSE THEN

177: END IF;
178: END IF;
179:
180: IF p_preset_tier_rec.pbh_offer_discount_id IS NOT NULL AND p_preset_tier_rec.pbh_offer_discount_id <> FND_API.G_MISS_NUM THEN
181: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_DISCOUNT_LINES','offer_discount_line_id',to_char(p_preset_tier_rec.pbh_offer_discount_id)) =FND_API.G_FALSE THEN
182: OZF_Utility_PVT.Error_Message('OZF_MO_PRESET_TIER_INV_PBH_ID');
183: x_return_status := FND_API.g_ret_sts_error;
184: return;
185: END IF;

Line 183: x_return_status := FND_API.g_ret_sts_error;

179:
180: IF p_preset_tier_rec.pbh_offer_discount_id IS NOT NULL AND p_preset_tier_rec.pbh_offer_discount_id <> FND_API.G_MISS_NUM THEN
181: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_DISCOUNT_LINES','offer_discount_line_id',to_char(p_preset_tier_rec.pbh_offer_discount_id)) =FND_API.G_FALSE THEN
182: OZF_Utility_PVT.Error_Message('OZF_MO_PRESET_TIER_INV_PBH_ID');
183: x_return_status := FND_API.g_ret_sts_error;
184: return;
185: END IF;
186: IF p_preset_tier_rec.dis_offer_discount_id IS NOT NULL AND p_preset_tier_rec.dis_offer_discount_id <> FND_API.G_MISS_NUM THEN
187: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_DISCOUNT_LINES', 'OFFER_DISCOUNT_LINE_ID', to_char(p_preset_tier_rec.dis_offer_discount_id)) = FND_API.G_FALSE THEN

Line 186: IF p_preset_tier_rec.dis_offer_discount_id IS NOT NULL AND p_preset_tier_rec.dis_offer_discount_id <> FND_API.G_MISS_NUM THEN

182: OZF_Utility_PVT.Error_Message('OZF_MO_PRESET_TIER_INV_PBH_ID');
183: x_return_status := FND_API.g_ret_sts_error;
184: return;
185: END IF;
186: IF p_preset_tier_rec.dis_offer_discount_id IS NOT NULL AND p_preset_tier_rec.dis_offer_discount_id <> FND_API.G_MISS_NUM THEN
187: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_DISCOUNT_LINES', 'OFFER_DISCOUNT_LINE_ID', to_char(p_preset_tier_rec.dis_offer_discount_id)) = FND_API.G_FALSE THEN
188: OZF_Utility_PVT.Error_Message('OZF_MO_PRESET_TIERS_INV_DIS_ID');
189: x_return_status := FND_API.g_ret_sts_error;
190: return;

Line 187: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_DISCOUNT_LINES', 'OFFER_DISCOUNT_LINE_ID', to_char(p_preset_tier_rec.dis_offer_discount_id)) = FND_API.G_FALSE THEN

183: x_return_status := FND_API.g_ret_sts_error;
184: return;
185: END IF;
186: IF p_preset_tier_rec.dis_offer_discount_id IS NOT NULL AND p_preset_tier_rec.dis_offer_discount_id <> FND_API.G_MISS_NUM THEN
187: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_DISCOUNT_LINES', 'OFFER_DISCOUNT_LINE_ID', to_char(p_preset_tier_rec.dis_offer_discount_id)) = FND_API.G_FALSE THEN
188: OZF_Utility_PVT.Error_Message('OZF_MO_PRESET_TIERS_INV_DIS_ID');
189: x_return_status := FND_API.g_ret_sts_error;
190: return;
191: END IF;

Line 189: x_return_status := FND_API.g_ret_sts_error;

185: END IF;
186: IF p_preset_tier_rec.dis_offer_discount_id IS NOT NULL AND p_preset_tier_rec.dis_offer_discount_id <> FND_API.G_MISS_NUM THEN
187: IF ozf_utility_pvt.check_fk_exists('OZF_OFFER_DISCOUNT_LINES', 'OFFER_DISCOUNT_LINE_ID', to_char(p_preset_tier_rec.dis_offer_discount_id)) = FND_API.G_FALSE THEN
188: OZF_Utility_PVT.Error_Message('OZF_MO_PRESET_TIERS_INV_DIS_ID');
189: x_return_status := FND_API.g_ret_sts_error;
190: return;
191: END IF;
192: END IF;
193: END IF;

Line 206: x_return_status := FND_API.G_RET_STS_SUCCESS;

202: , x_return_status OUT NOCOPY VARCHAR2
203: )
204: IS
205: BEGIN
206: x_return_status := FND_API.G_RET_STS_SUCCESS;
207: END check_preset_tiers_attr;
208:
209: PROCEDURE check_preset_tiers_inter_attr
210: (

Line 224: x_return_status := FND_API.G_RET_STS_SUCCESS;

220: WHERE offer_discount_line_id = p_dis_discount_id
221: AND parent_discount_line_id = p_pbh_discount_id);
222: l_dummy NUMBER;
223: BEGIN
224: x_return_status := FND_API.G_RET_STS_SUCCESS;
225: IF
226: (p_preset_tier_rec.pbh_offer_discount_id IS NOT NULL AND p_preset_tier_rec.pbh_offer_discount_id <> FND_API.G_MISS_NUM )
227: AND
228: (p_preset_tier_rec.dis_offer_discount_id IS NOT NULL AND p_preset_tier_rec.dis_offer_discount_id <> FND_API.G_MISS_NUM )

Line 226: (p_preset_tier_rec.pbh_offer_discount_id IS NOT NULL AND p_preset_tier_rec.pbh_offer_discount_id <> FND_API.G_MISS_NUM )

222: l_dummy NUMBER;
223: BEGIN
224: x_return_status := FND_API.G_RET_STS_SUCCESS;
225: IF
226: (p_preset_tier_rec.pbh_offer_discount_id IS NOT NULL AND p_preset_tier_rec.pbh_offer_discount_id <> FND_API.G_MISS_NUM )
227: AND
228: (p_preset_tier_rec.dis_offer_discount_id IS NOT NULL AND p_preset_tier_rec.dis_offer_discount_id <> FND_API.G_MISS_NUM )
229: THEN
230: OPEN c_valid(p_preset_tier_rec.dis_offer_discount_id,p_preset_tier_rec.pbh_offer_discount_id);

Line 228: (p_preset_tier_rec.dis_offer_discount_id IS NOT NULL AND p_preset_tier_rec.dis_offer_discount_id <> FND_API.G_MISS_NUM )

224: x_return_status := FND_API.G_RET_STS_SUCCESS;
225: IF
226: (p_preset_tier_rec.pbh_offer_discount_id IS NOT NULL AND p_preset_tier_rec.pbh_offer_discount_id <> FND_API.G_MISS_NUM )
227: AND
228: (p_preset_tier_rec.dis_offer_discount_id IS NOT NULL AND p_preset_tier_rec.dis_offer_discount_id <> FND_API.G_MISS_NUM )
229: THEN
230: OPEN c_valid(p_preset_tier_rec.dis_offer_discount_id,p_preset_tier_rec.pbh_offer_discount_id);
231: FETCH c_valid INTO l_dummy;
232: IF (c_valid%NOTFOUND) THEN

Line 235: x_return_status := FND_API.g_ret_sts_error;

231: FETCH c_valid INTO l_dummy;
232: IF (c_valid%NOTFOUND) THEN
233: CLOSE c_valid;
234: OZF_Utility_PVT.Error_Message('OZF_MO_PRESET_TIER_INV_DIS_PBH');
235: x_return_status := FND_API.g_ret_sts_error;
236: return;
237: END IF;
238: CLOSE c_valid;
239: END IF;

Line 251: x_return_status := FND_API.G_RET_STS_SUCCESS;

247: , x_return_status OUT NOCOPY VARCHAR2
248: )
249: IS
250: BEGIN
251: x_return_status := FND_API.G_RET_STS_SUCCESS;
252: check_preset_tiers_req_items
253: (
254: p_preset_tier_rec => p_preset_tier_rec
255: , p_validation_mode => p_validation_mode

Line 258: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

254: p_preset_tier_rec => p_preset_tier_rec
255: , p_validation_mode => p_validation_mode
256: , x_return_status => x_return_status
257: );
258: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
259: RAISE FND_API.G_EXC_ERROR;
260: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
262: END IF;

Line 259: RAISE FND_API.G_EXC_ERROR;

255: , p_validation_mode => p_validation_mode
256: , x_return_status => x_return_status
257: );
258: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
259: RAISE FND_API.G_EXC_ERROR;
260: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
262: END IF;
263: check_preset_tiers_uk_items

Line 260: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

256: , x_return_status => x_return_status
257: );
258: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
259: RAISE FND_API.G_EXC_ERROR;
260: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
262: END IF;
263: check_preset_tiers_uk_items
264: (

Line 261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

257: );
258: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
259: RAISE FND_API.G_EXC_ERROR;
260: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
262: END IF;
263: check_preset_tiers_uk_items
264: (
265: p_preset_tier_rec => p_preset_tier_rec

Line 269: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

265: p_preset_tier_rec => p_preset_tier_rec
266: , p_validation_mode => p_validation_mode
267: , x_return_status => x_return_status
268: );
269: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
270: RAISE FND_API.G_EXC_ERROR;
271: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
273: END IF;

Line 270: RAISE FND_API.G_EXC_ERROR;

266: , p_validation_mode => p_validation_mode
267: , x_return_status => x_return_status
268: );
269: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
270: RAISE FND_API.G_EXC_ERROR;
271: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
273: END IF;
274: check_preset_tiers_fk_items

Line 271: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

267: , x_return_status => x_return_status
268: );
269: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
270: RAISE FND_API.G_EXC_ERROR;
271: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
273: END IF;
274: check_preset_tiers_fk_items
275: (

Line 272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

268: );
269: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
270: RAISE FND_API.G_EXC_ERROR;
271: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
273: END IF;
274: check_preset_tiers_fk_items
275: (
276: p_preset_tier_rec => p_preset_tier_rec

Line 280: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

276: p_preset_tier_rec => p_preset_tier_rec
277: , p_validation_mode => p_validation_mode
278: , x_return_status => x_return_status
279: );
280: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
281: RAISE FND_API.G_EXC_ERROR;
282: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
284: END IF;

Line 281: RAISE FND_API.G_EXC_ERROR;

277: , p_validation_mode => p_validation_mode
278: , x_return_status => x_return_status
279: );
280: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
281: RAISE FND_API.G_EXC_ERROR;
282: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
284: END IF;
285: check_preset_tiers_attr

Line 282: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

278: , x_return_status => x_return_status
279: );
280: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
281: RAISE FND_API.G_EXC_ERROR;
282: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
284: END IF;
285: check_preset_tiers_attr
286: (

Line 283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

279: );
280: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
281: RAISE FND_API.G_EXC_ERROR;
282: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
284: END IF;
285: check_preset_tiers_attr
286: (
287: p_preset_tier_rec => p_preset_tier_rec

Line 291: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

287: p_preset_tier_rec => p_preset_tier_rec
288: , p_validation_mode => p_validation_mode
289: , x_return_status => x_return_status
290: );
291: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
292: RAISE FND_API.G_EXC_ERROR;
293: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
295: END IF;

Line 292: RAISE FND_API.G_EXC_ERROR;

288: , p_validation_mode => p_validation_mode
289: , x_return_status => x_return_status
290: );
291: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
292: RAISE FND_API.G_EXC_ERROR;
293: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
295: END IF;
296: check_preset_tiers_inter_attr

Line 293: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

289: , x_return_status => x_return_status
290: );
291: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
292: RAISE FND_API.G_EXC_ERROR;
293: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
295: END IF;
296: check_preset_tiers_inter_attr
297: (

Line 294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

290: );
291: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
292: RAISE FND_API.G_EXC_ERROR;
293: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
295: END IF;
296: check_preset_tiers_inter_attr
297: (
298: p_preset_tier_rec => p_preset_tier_rec

Line 302: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

298: p_preset_tier_rec => p_preset_tier_rec
299: , p_validation_mode => p_validation_mode
300: , x_return_status => x_return_status
301: );
302: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
303: RAISE FND_API.G_EXC_ERROR;
304: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
306: END IF;

Line 303: RAISE FND_API.G_EXC_ERROR;

299: , p_validation_mode => p_validation_mode
300: , x_return_status => x_return_status
301: );
302: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
303: RAISE FND_API.G_EXC_ERROR;
304: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
306: END IF;
307: END check_preset_tier_items;

Line 304: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

300: , x_return_status => x_return_status
301: );
302: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
303: RAISE FND_API.G_EXC_ERROR;
304: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
306: END IF;
307: END check_preset_tier_items;
308:

Line 305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

301: );
302: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
303: RAISE FND_API.G_EXC_ERROR;
304: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
306: END IF;
307: END check_preset_tier_items;
308:
309: PROCEDURE Validate_mo_preset_tiers

Line 312: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

308:
309: PROCEDURE Validate_mo_preset_tiers
310: (
311: p_api_version_number IN NUMBER,
312: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
313: p_commit IN VARCHAR2 := FND_API.G_FALSE,
314: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
315: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_CREATE,
316: x_return_status OUT NOCOPY VARCHAR2,

Line 313: p_commit IN VARCHAR2 := FND_API.G_FALSE,

309: PROCEDURE Validate_mo_preset_tiers
310: (
311: p_api_version_number IN NUMBER,
312: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
313: p_commit IN VARCHAR2 := FND_API.G_FALSE,
314: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
315: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_CREATE,
316: x_return_status OUT NOCOPY VARCHAR2,
317: x_msg_count OUT NOCOPY NUMBER,

Line 314: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

310: (
311: p_api_version_number IN NUMBER,
312: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
313: p_commit IN VARCHAR2 := FND_API.G_FALSE,
314: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
315: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.G_CREATE,
316: x_return_status OUT NOCOPY VARCHAR2,
317: x_msg_count OUT NOCOPY NUMBER,
318: x_msg_data OUT NOCOPY VARCHAR2,

Line 325: x_return_status := FND_API.G_RET_STS_SUCCESS;

321: )
322: IS
323: l_api_name CONSTANT VARCHAR2(30) := 'Validate_mo_preset_tiers';
324: BEGIN
325: x_return_status := FND_API.G_RET_STS_SUCCESS;
326:
327: ozf_utility_pvt.debug_message('Private API: '|| l_api_name||' Start');
328:
329: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

Line 336: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

332: p_preset_tier_rec => p_preset_tier_rec
333: , p_validation_mode => p_validation_mode
334: , x_return_status => x_return_status
335: );
336: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
337: RAISE FND_API.G_EXC_ERROR;
338: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
340: END IF;

Line 337: RAISE FND_API.G_EXC_ERROR;

333: , p_validation_mode => p_validation_mode
334: , x_return_status => x_return_status
335: );
336: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
337: RAISE FND_API.G_EXC_ERROR;
338: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
340: END IF;
341: END IF;

Line 338: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

334: , x_return_status => x_return_status
335: );
336: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
337: RAISE FND_API.G_EXC_ERROR;
338: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
340: END IF;
341: END IF;
342: ozf_utility_pvt.debug_message('Private API: '||l_api_name ||' End');

Line 339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

335: );
336: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
337: RAISE FND_API.G_EXC_ERROR;
338: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
340: END IF;
341: END IF;
342: ozf_utility_pvt.debug_message('Private API: '||l_api_name ||' End');
343:

Line 348: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

344: END Validate_mo_preset_tiers;
345:
346: PROCEDURE Create_mo_preset_tiers(
347: p_api_version_number IN NUMBER,
348: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
349: p_commit IN VARCHAR2 := FND_API.G_FALSE,
350: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
351:
352: x_return_status OUT NOCOPY VARCHAR2,

Line 349: p_commit IN VARCHAR2 := FND_API.G_FALSE,

345:
346: PROCEDURE Create_mo_preset_tiers(
347: p_api_version_number IN NUMBER,
348: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
349: p_commit IN VARCHAR2 := FND_API.G_FALSE,
350: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
351:
352: x_return_status OUT NOCOPY VARCHAR2,
353: x_msg_count OUT NOCOPY NUMBER,

Line 350: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

346: PROCEDURE Create_mo_preset_tiers(
347: p_api_version_number IN NUMBER,
348: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
349: p_commit IN VARCHAR2 := FND_API.G_FALSE,
350: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
351:
352: x_return_status OUT NOCOPY VARCHAR2,
353: x_msg_count OUT NOCOPY NUMBER,
354: x_msg_data OUT NOCOPY VARCHAR2,

Line 379: IF NOT FND_API.Compatible_api_call(

375: -- initialize
376: -- savepoint
377: SAVEPOINT Create_mo_preset_tiers;
378: -- api compatibility
379: IF NOT FND_API.Compatible_api_call(
380: l_api_version_number
381: , p_api_version_number
382: , g_pkg_name
383: , l_api_name

Line 385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

381: , p_api_version_number
382: , g_pkg_name
383: , l_api_name
384: ) THEN
385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
386: END IF;
387: -- initialize messages
388: IF FND_API.to_boolean(p_init_msg_list) THEN
389: FND_MSG_PUB.initialize;

Line 388: IF FND_API.to_boolean(p_init_msg_list) THEN

384: ) THEN
385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
386: END IF;
387: -- initialize messages
388: IF FND_API.to_boolean(p_init_msg_list) THEN
389: FND_MSG_PUB.initialize;
390: END IF;
391:
392: ozf_utility_pvt.debug_message('Private API: '|| l_api_name || ' Start');

Line 393: x_return_status := FND_API.G_RET_STS_SUCCESS;

389: FND_MSG_PUB.initialize;
390: END IF;
391:
392: ozf_utility_pvt.debug_message('Private API: '|| l_api_name || ' Start');
393: x_return_status := FND_API.G_RET_STS_SUCCESS;
394:
395: IF FND_GLOBAL.USER_ID IS NULL
396: THEN
397: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 398: RAISE FND_API.G_EXC_ERROR;

394:
395: IF FND_GLOBAL.USER_ID IS NULL
396: THEN
397: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
398: RAISE FND_API.G_EXC_ERROR;
399: END IF;
400:
401: l_preset_tier_rec := p_preset_tier_rec;
402:

Line 403: IF p_preset_tier_rec.market_preset_tier_id IS NULL OR p_preset_tier_rec.market_preset_tier_id = FND_API.G_MISS_NUM THEN

399: END IF;
400:
401: l_preset_tier_rec := p_preset_tier_rec;
402:
403: IF p_preset_tier_rec.market_preset_tier_id IS NULL OR p_preset_tier_rec.market_preset_tier_id = FND_API.G_MISS_NUM THEN
404: LOOP
405: l_dummy := null;
406: OPEN c_id;
407: FETCH c_id INTO l_market_preset_tier_id;

Line 431: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

427: , x_msg_data => x_msg_data
428: , p_preset_tier_rec => l_preset_tier_rec
429: );
430:
431: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
432: RAISE FND_API.G_EXC_ERROR;
433: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
435: END IF;

Line 432: RAISE FND_API.G_EXC_ERROR;

428: , p_preset_tier_rec => l_preset_tier_rec
429: );
430:
431: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
432: RAISE FND_API.G_EXC_ERROR;
433: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
435: END IF;
436:

Line 433: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

429: );
430:
431: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
432: RAISE FND_API.G_EXC_ERROR;
433: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
435: END IF;
436:
437: -- insert

Line 434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

430:
431: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
432: RAISE FND_API.G_EXC_ERROR;
433: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
435: END IF;
436:
437: -- insert
438: OZF_MO_PRESET_TIERS_PKG.Insert_row

Line 452: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

448: , p_last_updated_by => FND_GLOBAL.user_id
449: , p_last_update_login => FND_GLOBAL.conc_login_id
450: );
451:
452: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
453: RAISE FND_API.G_EXC_ERROR;
454: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
456: END IF;

Line 453: RAISE FND_API.G_EXC_ERROR;

449: , p_last_update_login => FND_GLOBAL.conc_login_id
450: );
451:
452: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
453: RAISE FND_API.G_EXC_ERROR;
454: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
456: END IF;
457:

Line 454: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

450: );
451:
452: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
453: RAISE FND_API.G_EXC_ERROR;
454: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
456: END IF;
457:
458: x_market_preset_tier_id := l_market_preset_tier_id;

Line 455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

451:
452: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
453: RAISE FND_API.G_EXC_ERROR;
454: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
455: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
456: END IF;
457:
458: x_market_preset_tier_id := l_market_preset_tier_id;
459:

Line 462: IF FND_API.to_boolean(p_commit) THEN

458: x_market_preset_tier_id := l_market_preset_tier_id;
459:
460: ozf_utility_pvt.debug_message('Private API: '|| l_api_name || ' Start');
461:
462: IF FND_API.to_boolean(p_commit) THEN
463: COMMIT WORK;
464: END IF;
465: -- commit
466: EXCEPTION

Line 467: WHEN FND_API.G_EXC_ERROR THEN

463: COMMIT WORK;
464: END IF;
465: -- commit
466: EXCEPTION
467: WHEN FND_API.G_EXC_ERROR THEN
468: ROLLBACK TO Create_mo_preset_tiers;
469: x_return_status := FND_API.G_RET_STS_ERROR;
470: FND_MSG_PUB.count_and_get(
471: p_encoded => FND_API.g_false

Line 469: x_return_status := FND_API.G_RET_STS_ERROR;

465: -- commit
466: EXCEPTION
467: WHEN FND_API.G_EXC_ERROR THEN
468: ROLLBACK TO Create_mo_preset_tiers;
469: x_return_status := FND_API.G_RET_STS_ERROR;
470: FND_MSG_PUB.count_and_get(
471: p_encoded => FND_API.g_false
472: , p_count => x_msg_count
473: , p_data => x_msg_data

Line 471: p_encoded => FND_API.g_false

467: WHEN FND_API.G_EXC_ERROR THEN
468: ROLLBACK TO Create_mo_preset_tiers;
469: x_return_status := FND_API.G_RET_STS_ERROR;
470: FND_MSG_PUB.count_and_get(
471: p_encoded => FND_API.g_false
472: , p_count => x_msg_count
473: , p_data => x_msg_data
474: );
475: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 475: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

471: p_encoded => FND_API.g_false
472: , p_count => x_msg_count
473: , p_data => x_msg_data
474: );
475: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
476: ROLLBACK TO Create_mo_preset_tiers;
477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
478: FND_MSG_PUB.count_and_get(
479: p_encoded => FND_API.g_false

Line 477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

473: , p_data => x_msg_data
474: );
475: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
476: ROLLBACK TO Create_mo_preset_tiers;
477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
478: FND_MSG_PUB.count_and_get(
479: p_encoded => FND_API.g_false
480: , p_count => x_msg_count
481: , p_data => x_msg_data

Line 479: p_encoded => FND_API.g_false

475: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
476: ROLLBACK TO Create_mo_preset_tiers;
477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
478: FND_MSG_PUB.count_and_get(
479: p_encoded => FND_API.g_false
480: , p_count => x_msg_count
481: , p_data => x_msg_data
482: );
483: WHEN OTHERS THEN

Line 484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

480: , p_count => x_msg_count
481: , p_data => x_msg_data
482: );
483: WHEN OTHERS THEN
484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
485: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
486: THEN
487: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
488: END IF;

Line 491: p_encoded => FND_API.G_FALSE,

487: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
488: END IF;
489: -- Standard call to get message count and if count=1, get the message
490: FND_MSG_PUB.Count_And_Get (
491: p_encoded => FND_API.G_FALSE,
492: p_count => x_msg_count,
493: p_data => x_msg_data
494: );
495: -- exception

Line 501: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

497: END Create_mo_preset_tiers;
498:
499: PROCEDURE Update_mo_preset_tiers(
500: p_api_version_number IN NUMBER,
501: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
502: p_commit IN VARCHAR2 := FND_API.G_FALSE,
503: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
504:
505: x_return_status OUT NOCOPY VARCHAR2,

Line 502: p_commit IN VARCHAR2 := FND_API.G_FALSE,

498:
499: PROCEDURE Update_mo_preset_tiers(
500: p_api_version_number IN NUMBER,
501: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
502: p_commit IN VARCHAR2 := FND_API.G_FALSE,
503: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
504:
505: x_return_status OUT NOCOPY VARCHAR2,
506: x_msg_count OUT NOCOPY NUMBER,

Line 503: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

499: PROCEDURE Update_mo_preset_tiers(
500: p_api_version_number IN NUMBER,
501: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
502: p_commit IN VARCHAR2 := FND_API.G_FALSE,
503: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
504:
505: x_return_status OUT NOCOPY VARCHAR2,
506: x_msg_count OUT NOCOPY NUMBER,
507: x_msg_data OUT NOCOPY VARCHAR2,

Line 526: IF NOT FND_API.Compatible_api_call

522:
523: BEGIN
524: --initialize
525: SAVEPOINT Update_mo_preset_tiers;
526: IF NOT FND_API.Compatible_api_call
527: (
528: l_api_version_number
529: , p_api_version_number
530: , G_PKG_NAME

Line 534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

530: , G_PKG_NAME
531: , l_api_name
532: )
533: THEN
534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
535: END IF;
536:
537: IF FND_API.to_boolean(p_init_msg_list) THEN
538: FND_MSG_PUB.initialize;

Line 537: IF FND_API.to_boolean(p_init_msg_list) THEN

533: THEN
534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
535: END IF;
536:
537: IF FND_API.to_boolean(p_init_msg_list) THEN
538: FND_MSG_PUB.initialize;
539: END IF;
540:
541: ozf_utility_pvt.debug_message('Private API: '|| l_api_name || ' Start');

Line 542: x_return_status := FND_API.G_RET_STS_SUCCESS;

538: FND_MSG_PUB.initialize;
539: END IF;
540:
541: ozf_utility_pvt.debug_message('Private API: '|| l_api_name || ' Start');
542: x_return_status := FND_API.G_RET_STS_SUCCESS;
543:
544: open c_get_preset_tiers(l_tar_preset_rec.market_preset_tier_id, l_tar_preset_rec.object_version_number);
545: FETCH c_get_preset_tiers INTO l_ref_preset_tiers;
546: IF (c_get_preset_tiers%NOTFOUND) THEN

Line 550: RAISE FND_API.G_EXC_ERROR;

546: IF (c_get_preset_tiers%NOTFOUND) THEN
547: OZF_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET'
548: , p_token_name => 'INFO'
549: , p_token_value => 'OZF_MO_PRESET_TIERS') ;
550: RAISE FND_API.G_EXC_ERROR;
551: END IF;
552: IF l_tar_preset_rec.object_version_number = FND_API.G_MISS_NUM OR l_tar_preset_rec.object_version_number IS NULL THEN
553: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING'
554: , p_token_name => 'COLUMN'

Line 552: IF l_tar_preset_rec.object_version_number = FND_API.G_MISS_NUM OR l_tar_preset_rec.object_version_number IS NULL THEN

548: , p_token_name => 'INFO'
549: , p_token_value => 'OZF_MO_PRESET_TIERS') ;
550: RAISE FND_API.G_EXC_ERROR;
551: END IF;
552: IF l_tar_preset_rec.object_version_number = FND_API.G_MISS_NUM OR l_tar_preset_rec.object_version_number IS NULL THEN
553: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING'
554: , p_token_name => 'COLUMN'
555: , p_token_value => 'Last_Update_Date') ;
556: RAISE FND_API.G_EXC_ERROR;

Line 556: RAISE FND_API.G_EXC_ERROR;

552: IF l_tar_preset_rec.object_version_number = FND_API.G_MISS_NUM OR l_tar_preset_rec.object_version_number IS NULL THEN
553: OZF_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING'
554: , p_token_name => 'COLUMN'
555: , p_token_value => 'Last_Update_Date') ;
556: RAISE FND_API.G_EXC_ERROR;
557: END IF;
558: IF l_tar_preset_rec.object_version_number <> l_ref_preset_tiers.object_version_number THEN
559: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED'
560: , p_token_name => 'INFO'

Line 562: RAISE FND_API.G_EXC_ERROR;

558: IF l_tar_preset_rec.object_version_number <> l_ref_preset_tiers.object_version_number THEN
559: OZF_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED'
560: , p_token_name => 'INFO'
561: , p_token_value => 'Ozf_Market_Options') ;
562: RAISE FND_API.G_EXC_ERROR;
563: END IF;
564: -- validate
565: -- update
566: -- commit

Line 581: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

577: , x_msg_data => x_msg_data
578: , p_preset_tier_rec => p_preset_tier_rec
579: );
580:
581: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
582: RAISE FND_API.G_EXC_ERROR;
583: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
585: END IF;

Line 582: RAISE FND_API.G_EXC_ERROR;

578: , p_preset_tier_rec => p_preset_tier_rec
579: );
580:
581: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
582: RAISE FND_API.G_EXC_ERROR;
583: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
585: END IF;
586:

Line 583: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

579: );
580:
581: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
582: RAISE FND_API.G_EXC_ERROR;
583: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
585: END IF;
586:
587: OZF_MO_PRESET_TIERS_PKG.Update_row

Line 584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

580:
581: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
582: RAISE FND_API.G_EXC_ERROR;
583: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
585: END IF;
586:
587: OZF_MO_PRESET_TIERS_PKG.Update_row
588: (

Line 598: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

594: , p_last_update_date => sysdate
595: , p_last_updated_by => FND_GLOBAL.user_id
596: , p_last_update_login => FND_GLOBAL.conc_login_id
597: );
598: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
599: RAISE FND_API.G_EXC_ERROR;
600: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
602: END IF;

Line 599: RAISE FND_API.G_EXC_ERROR;

595: , p_last_updated_by => FND_GLOBAL.user_id
596: , p_last_update_login => FND_GLOBAL.conc_login_id
597: );
598: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
599: RAISE FND_API.G_EXC_ERROR;
600: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
602: END IF;
603:

Line 600: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

596: , p_last_update_login => FND_GLOBAL.conc_login_id
597: );
598: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
599: RAISE FND_API.G_EXC_ERROR;
600: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
602: END IF;
603:
604: ozf_utility_pvt.debug_message('Private API: '|| l_api_name ||' End');

Line 601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

597: );
598: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
599: RAISE FND_API.G_EXC_ERROR;
600: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
602: END IF;
603:
604: ozf_utility_pvt.debug_message('Private API: '|| l_api_name ||' End');
605:

Line 606: IF FND_API.to_boolean(p_commit) THEN

602: END IF;
603:
604: ozf_utility_pvt.debug_message('Private API: '|| l_api_name ||' End');
605:
606: IF FND_API.to_boolean(p_commit) THEN
607: COMMIT WORK;
608: END IF;
609: EXCEPTION
610: WHEN FND_API.G_EXC_ERROR THEN

Line 610: WHEN FND_API.G_EXC_ERROR THEN

606: IF FND_API.to_boolean(p_commit) THEN
607: COMMIT WORK;
608: END IF;
609: EXCEPTION
610: WHEN FND_API.G_EXC_ERROR THEN
611: ROLLBACK TO UPDATE_mo_PRESET_TIERS;
612: x_return_status := FND_API.G_RET_STS_ERROR;
613: FND_MSG_PUB.count_and_get(
614: p_encoded => FND_API.g_false

Line 612: x_return_status := FND_API.G_RET_STS_ERROR;

608: END IF;
609: EXCEPTION
610: WHEN FND_API.G_EXC_ERROR THEN
611: ROLLBACK TO UPDATE_mo_PRESET_TIERS;
612: x_return_status := FND_API.G_RET_STS_ERROR;
613: FND_MSG_PUB.count_and_get(
614: p_encoded => FND_API.g_false
615: , p_count => x_msg_count
616: , p_data => x_msg_data

Line 614: p_encoded => FND_API.g_false

610: WHEN FND_API.G_EXC_ERROR THEN
611: ROLLBACK TO UPDATE_mo_PRESET_TIERS;
612: x_return_status := FND_API.G_RET_STS_ERROR;
613: FND_MSG_PUB.count_and_get(
614: p_encoded => FND_API.g_false
615: , p_count => x_msg_count
616: , p_data => x_msg_data
617: );
618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

614: p_encoded => FND_API.g_false
615: , p_count => x_msg_count
616: , p_data => x_msg_data
617: );
618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
619: ROLLBACK TO UPDATE_mo_PRESET_TIERS;
620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
621: FND_MSG_PUB.count_and_get(
622: p_encoded => FND_API.g_false

Line 620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

616: , p_data => x_msg_data
617: );
618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
619: ROLLBACK TO UPDATE_mo_PRESET_TIERS;
620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
621: FND_MSG_PUB.count_and_get(
622: p_encoded => FND_API.g_false
623: , p_count => x_msg_count
624: , p_data => x_msg_data

Line 622: p_encoded => FND_API.g_false

618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
619: ROLLBACK TO UPDATE_mo_PRESET_TIERS;
620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
621: FND_MSG_PUB.count_and_get(
622: p_encoded => FND_API.g_false
623: , p_count => x_msg_count
624: , p_data => x_msg_data
625: );
626: WHEN OTHERS THEN

Line 628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

624: , p_data => x_msg_data
625: );
626: WHEN OTHERS THEN
627: ROLLBACK TO UPDATE_mo_PRESET_TIERS;
628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
629: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
630: THEN
631: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
632: END IF;

Line 635: p_encoded => FND_API.G_FALSE,

631: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
632: END IF;
633: -- Standard call to get message count and if count=1, get the message
634: FND_MSG_PUB.Count_And_Get (
635: p_encoded => FND_API.G_FALSE,
636: p_count => x_msg_count,
637: p_data => x_msg_data
638: );
639:

Line 644: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

640: END UPDATE_mo_PRESET_TIERS;
641:
642: PROCEDURE Delete_mo_preset_tiers(
643: p_api_version_number IN NUMBER,
644: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
645: p_commit IN VARCHAR2 := FND_API.G_FALSE,
646: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
647: x_return_status OUT NOCOPY VARCHAR2,
648: x_msg_count OUT NOCOPY NUMBER,

Line 645: p_commit IN VARCHAR2 := FND_API.G_FALSE,

641:
642: PROCEDURE Delete_mo_preset_tiers(
643: p_api_version_number IN NUMBER,
644: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
645: p_commit IN VARCHAR2 := FND_API.G_FALSE,
646: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
647: x_return_status OUT NOCOPY VARCHAR2,
648: x_msg_count OUT NOCOPY NUMBER,
649: x_msg_data OUT NOCOPY VARCHAR2,

Line 646: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

642: PROCEDURE Delete_mo_preset_tiers(
643: p_api_version_number IN NUMBER,
644: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
645: p_commit IN VARCHAR2 := FND_API.G_FALSE,
646: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
647: x_return_status OUT NOCOPY VARCHAR2,
648: x_msg_count OUT NOCOPY NUMBER,
649: x_msg_data OUT NOCOPY VARCHAR2,
650: p_market_preset_tier_id IN NUMBER,

Line 659: IF NOT FND_API.Compatible_api_call

655: l_api_name CONSTANT VARCHAR2(30) := 'Delete_mo_preset_tiers';
656: BEGIN
657: --INITIALIZE
658: SAVEPOINT Delete_mo_preset_tiers;
659: IF NOT FND_API.Compatible_api_call
660: (
661: l_api_version_number
662: , p_api_version_number
663: , G_PKG_NAME

Line 667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

663: , G_PKG_NAME
664: , l_api_name
665: )
666: THEN
667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
668: END IF;
669:
670: IF FND_API.to_boolean(p_init_msg_list) THEN
671: FND_MSG_PUB.initialize;

Line 670: IF FND_API.to_boolean(p_init_msg_list) THEN

666: THEN
667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
668: END IF;
669:
670: IF FND_API.to_boolean(p_init_msg_list) THEN
671: FND_MSG_PUB.initialize;
672: END IF;
673:
674: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 674: x_return_status := FND_API.G_RET_STS_SUCCESS;

670: IF FND_API.to_boolean(p_init_msg_list) THEN
671: FND_MSG_PUB.initialize;
672: END IF;
673:
674: x_return_status := FND_API.G_RET_STS_SUCCESS;
675: ozf_utility_pvt.debug_message('Private API: '|| l_api_name || ' Start');
676:
677: OZF_MO_PRESET_TIERS_PKG.Delete_row(p_market_preset_tier_id => p_market_preset_tier_id, p_object_version_number => p_object_version_number);
678:

Line 679: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

675: ozf_utility_pvt.debug_message('Private API: '|| l_api_name || ' Start');
676:
677: OZF_MO_PRESET_TIERS_PKG.Delete_row(p_market_preset_tier_id => p_market_preset_tier_id, p_object_version_number => p_object_version_number);
678:
679: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
680: RAISE FND_API.G_EXC_ERROR;
681: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
683: END IF;

Line 680: RAISE FND_API.G_EXC_ERROR;

676:
677: OZF_MO_PRESET_TIERS_PKG.Delete_row(p_market_preset_tier_id => p_market_preset_tier_id, p_object_version_number => p_object_version_number);
678:
679: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
680: RAISE FND_API.G_EXC_ERROR;
681: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
683: END IF;
684:

Line 681: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

677: OZF_MO_PRESET_TIERS_PKG.Delete_row(p_market_preset_tier_id => p_market_preset_tier_id, p_object_version_number => p_object_version_number);
678:
679: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
680: RAISE FND_API.G_EXC_ERROR;
681: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
683: END IF;
684:
685: ozf_utility_pvt.debug_message('Private API: '|| l_api_name || ' End');

Line 682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

678:
679: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
680: RAISE FND_API.G_EXC_ERROR;
681: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
683: END IF;
684:
685: ozf_utility_pvt.debug_message('Private API: '|| l_api_name || ' End');
686: IF FND_API.to_boolean(p_commit) THEN

Line 686: IF FND_API.to_boolean(p_commit) THEN

682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
683: END IF;
684:
685: ozf_utility_pvt.debug_message('Private API: '|| l_api_name || ' End');
686: IF FND_API.to_boolean(p_commit) THEN
687: COMMIT WORK;
688: END IF;
689:
690: EXCEPTION

Line 691: WHEN FND_API.G_EXC_ERROR THEN

687: COMMIT WORK;
688: END IF;
689:
690: EXCEPTION
691: WHEN FND_API.G_EXC_ERROR THEN
692: ROLLBACK TO Delete_mo_preset_tiers;
693: x_return_status := FND_API.G_RET_STS_ERROR;
694: FND_MSG_PUB.count_and_get(
695: p_encoded => FND_API.g_false

Line 693: x_return_status := FND_API.G_RET_STS_ERROR;

689:
690: EXCEPTION
691: WHEN FND_API.G_EXC_ERROR THEN
692: ROLLBACK TO Delete_mo_preset_tiers;
693: x_return_status := FND_API.G_RET_STS_ERROR;
694: FND_MSG_PUB.count_and_get(
695: p_encoded => FND_API.g_false
696: , p_count => x_msg_count
697: , p_data => x_msg_data

Line 695: p_encoded => FND_API.g_false

691: WHEN FND_API.G_EXC_ERROR THEN
692: ROLLBACK TO Delete_mo_preset_tiers;
693: x_return_status := FND_API.G_RET_STS_ERROR;
694: FND_MSG_PUB.count_and_get(
695: p_encoded => FND_API.g_false
696: , p_count => x_msg_count
697: , p_data => x_msg_data
698: );
699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

695: p_encoded => FND_API.g_false
696: , p_count => x_msg_count
697: , p_data => x_msg_data
698: );
699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
700: ROLLBACK TO Delete_mo_preset_tiers;
701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
702: FND_MSG_PUB.count_and_get(
703: p_encoded => FND_API.g_false

Line 701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

697: , p_data => x_msg_data
698: );
699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
700: ROLLBACK TO Delete_mo_preset_tiers;
701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
702: FND_MSG_PUB.count_and_get(
703: p_encoded => FND_API.g_false
704: , p_count => x_msg_count
705: , p_data => x_msg_data

Line 703: p_encoded => FND_API.g_false

699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
700: ROLLBACK TO Delete_mo_preset_tiers;
701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
702: FND_MSG_PUB.count_and_get(
703: p_encoded => FND_API.g_false
704: , p_count => x_msg_count
705: , p_data => x_msg_data
706: );
707: WHEN OTHERS THEN

Line 709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

705: , p_data => x_msg_data
706: );
707: WHEN OTHERS THEN
708: ROLLBACK TO Delete_mo_preset_tiers;
709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
710: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
711: FND_MSG_PUB.Add_exc_msg(G_PKG_NAME,l_api_name);
712: END IF;
713: FND_MSG_PUB.count_and_get(

Line 714: p_encoded => FND_API.g_false

710: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
711: FND_MSG_PUB.Add_exc_msg(G_PKG_NAME,l_api_name);
712: END IF;
713: FND_MSG_PUB.count_and_get(
714: p_encoded => FND_API.g_false
715: , p_count => x_msg_count
716: , p_data => x_msg_data
717: );
718: