36: /*
37: ** Initialize Processing
38: */
39:
40: x_return_status := Fnd_Api.G_Ret_Sts_Success;
41:
42: Fnd_Msg_Pub.Initialize;
43:
44: /*
100: */
101:
102: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
103:
104: RAISE Fnd_Api.G_Exc_Error;
105:
106: END IF;
107:
108: Igw_Prop_Abstracts_Pvt.Populate_Prop_Abstracts(l_proposal_id);
123: AND abstract_type_code = l_abstract_type_code;
124:
125: Igw_Prop_Abstracts_Pvt.Update_Prop_Abstract
126: (
127: p_init_msg_list => Fnd_Api.G_True,
128: p_validate_only => p_validate_only,
129: p_commit => Fnd_Api.G_False,
130: p_rowid => l_rowid,
131: p_proposal_id => l_proposal_id,
125: Igw_Prop_Abstracts_Pvt.Update_Prop_Abstract
126: (
127: p_init_msg_list => Fnd_Api.G_True,
128: p_validate_only => p_validate_only,
129: p_commit => Fnd_Api.G_False,
130: p_rowid => l_rowid,
131: p_proposal_id => l_proposal_id,
132: p_proposal_number => null,
133: p_abstract_type => 'IGW_ABSTRACT_TYPES',
157: );
158:
159: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
160:
161: RAISE Fnd_Api.G_Exc_Error;
162:
163: END IF;
164:
165: /*
165: /*
166: ** Commit data if API invoked in commit mode
167: */
168:
169: IF Fnd_Api.To_Boolean(p_commit) THEN
170:
171: COMMIT;
172:
173: END IF;
173: END IF;
174:
175: EXCEPTION
176:
177: WHEN Fnd_Api.G_Exc_Error THEN
178:
179: ROLLBACK TO Create_Prop_Abstract_Pub;
180:
181: x_return_status := Fnd_Api.G_Ret_Sts_Error;
177: WHEN Fnd_Api.G_Exc_Error THEN
178:
179: ROLLBACK TO Create_Prop_Abstract_Pub;
180:
181: x_return_status := Fnd_Api.G_Ret_Sts_Error;
182:
183: Fnd_Msg_Pub.Count_And_Get
184: (
185: p_encoded => Fnd_Api.G_False,
181: x_return_status := Fnd_Api.G_Ret_Sts_Error;
182:
183: Fnd_Msg_Pub.Count_And_Get
184: (
185: p_encoded => Fnd_Api.G_False,
186: p_count => x_msg_count,
187: p_data => x_msg_data
188: );
189:
190: WHEN others THEN
191:
192: ROLLBACK TO Create_Prop_Abstract_Pub;
193:
194: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
195:
196: Fnd_Msg_Pub.Add_Exc_Msg
197: (
198: p_pkg_name => G_PKG_NAME,
200: );
201:
202: Fnd_Msg_Pub.Count_And_Get
203: (
204: p_encoded => Fnd_Api.G_False,
205: p_count => x_msg_count,
206: p_data => x_msg_data
207: );
208: