27:
28: WHEN no_data_found THEN
29:
30: Fnd_Message.Set_Name('IGW','IGW_UPLD_OH_RATE_CLASS_INV');
31: Fnd_Msg_Pub.Add;
32:
33: END Get_Oh_Rate_Class_Id;
34:
35: ---------------------------------------------------------------------------
79: */
80:
81: x_return_status := Fnd_Api.G_Ret_Sts_Success;
82:
83: Fnd_Msg_Pub.Initialize;
84:
85: /*
86: ** Verify Mandatory Inputs. Value-Id Conversions.
87: */
89: IF p_proposal_number IS NULL THEN
90:
91: Fnd_Message.Set_Name('IGW','IGW_UPLD_MISSING_PARAMETER');
92: Fnd_Message.Set_Token('PARAM_NAME','P_PROPOSAL_NUMBER');
93: Fnd_Msg_Pub.Add;
94:
95: ELSE
96:
97: Igw_Utils.Get_Proposal_Id
109: IF p_start_date IS NULL THEN
110:
111: Fnd_Message.Set_Name('IGW','IGW_UPLD_MISSING_PARAMETER');
112: Fnd_Message.Set_Token('PARAM_NAME','P_START_DATE');
113: Fnd_Msg_Pub.Add;
114:
115: END IF;
116:
117: IF p_end_date IS NULL THEN
117: IF p_end_date IS NULL THEN
118:
119: Fnd_Message.Set_Name('IGW','IGW_UPLD_MISSING_PARAMETER');
120: Fnd_Message.Set_Token('PARAM_NAME','P_END_DATE');
121: Fnd_Msg_Pub.Add;
122:
123: END IF;
124:
125: IF p_oh_rate_class_name IS NULL THEN
125: IF p_oh_rate_class_name IS NULL THEN
126:
127: Fnd_Message.Set_Name('IGW','IGW_UPLD_MISSING_PARAMETER');
128: Fnd_Message.Set_Token('PARAM_NAME','P_OH_RATE_CLASS_NAME');
129: Fnd_Msg_Pub.Add;
130:
131: ELSE
132:
133: Get_Oh_Rate_Class_Id
141: IF p_proposal_form_number IS NULL THEN
142:
143: Fnd_Message.Set_Name('IGW','IGW_UPLD_MISSING_PARAMETER');
144: Fnd_Message.Set_Token('PARAM_NAME','P_PROPOSAL_FORM_NUMBER');
145: Fnd_Msg_Pub.Add;
146:
147: END IF;
148:
149: IF p_final_version_flag NOT IN ('N','Y') THEN
149: IF p_final_version_flag NOT IN ('N','Y') THEN
150:
151: Fnd_Message.Set_Name('IGW','IGW_UPLD_INVALID_FLAG');
152: Fnd_Message.Set_Token('PARAM_NAME','P_FINAL_VERSION_FLAG');
153: Fnd_Msg_Pub.Add;
154:
155: END IF;
156:
157: IF p_enter_budget_at_period_level NOT IN ('N','Y') THEN
157: IF p_enter_budget_at_period_level NOT IN ('N','Y') THEN
158:
159: Fnd_Message.Set_Name('IGW','IGW_UPLD_INVALID_FLAG');
160: Fnd_Message.Set_Token('PARAM_NAME','P_ENTER_BUDGET_AT_PERIOD_LEVEL');
161: Fnd_Msg_Pub.Add;
162:
163: END IF;
164:
165: IF p_apply_inflation_setup_rates NOT IN ('N','Y') THEN
165: IF p_apply_inflation_setup_rates NOT IN ('N','Y') THEN
166:
167: Fnd_Message.Set_Name('IGW','IGW_UPLD_INVALID_FLAG');
168: Fnd_Message.Set_Token('PARAM_NAME','P_APPLY_INFLATION_SETUP_RATES');
169: Fnd_Msg_Pub.Add;
170:
171: END IF;
172:
173: IF p_apply_eb_setup_rates NOT IN ('N','Y') THEN
173: IF p_apply_eb_setup_rates NOT IN ('N','Y') THEN
174:
175: Fnd_Message.Set_Name('IGW','IGW_UPLD_INVALID_FLAG');
176: Fnd_Message.Set_Token('PARAM_NAME','P_APPLY_EB_SETUP_RATES');
177: Fnd_Msg_Pub.Add;
178:
179: END IF;
180:
181: IF p_apply_oh_setup_rates NOT IN ('N','Y') THEN
181: IF p_apply_oh_setup_rates NOT IN ('N','Y') THEN
182:
183: Fnd_Message.Set_Name('IGW','IGW_UPLD_INVALID_FLAG');
184: Fnd_Message.Set_Token('PARAM_NAME','P_APPLY_OH_SETUP_RATES');
185: Fnd_Msg_Pub.Add;
186:
187: END IF;
188:
189: /*
190: ** Discontinue processing if any error has been encountered during
191: ** the earlier stages
192: */
193:
194: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
195:
196: RAISE Fnd_Api.G_Exc_Error;
197:
198: END IF;
244: x_msg_count => x_msg_count,
245: x_msg_data => x_msg_data
246: );
247:
248: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
249:
250: RAISE Fnd_Api.G_Exc_Error;
251:
252: END IF;
269: ROLLBACK TO Create_Budget_Version_Pub;
270:
271: x_return_status := Fnd_Api.G_Ret_Sts_Error;
272:
273: Fnd_Msg_Pub.Count_And_Get
274: (
275: p_encoded => Fnd_Api.G_False,
276: p_count => x_msg_count,
277: p_data => x_msg_data
282: ROLLBACK TO Create_Budget_Version_Pub;
283:
284: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
285:
286: Fnd_Msg_Pub.Add_Exc_Msg
287: (
288: p_pkg_name => G_PKG_NAME,
289: p_procedure_name => l_api_name
290: );
288: p_pkg_name => G_PKG_NAME,
289: p_procedure_name => l_api_name
290: );
291:
292: Fnd_Msg_Pub.Count_And_Get
293: (
294: p_encoded => Fnd_Api.G_False,
295: p_count => x_msg_count,
296: p_data => x_msg_data