26: EXCEPTION
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:
87: */
88:
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
88:
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:
107: END IF;
108:
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;
108:
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:
115: END IF;
116:
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;
116:
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:
123: END IF;
124:
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
124:
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:
139: END IF;
140:
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;
140:
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:
147: END IF;
148:
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;
148:
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:
155: END IF;
156:
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;
156:
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:
163: END IF;
164:
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;
164:
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:
171: END IF;
172:
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;
172:
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:
179: END IF;
180:
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;
180:
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: