DBA Data[Home] [Help]

APPS.IGW_PROP_SPECIAL_REVIEWS_PUB dependencies on FND_API

Line 46: x_return_status := Fnd_Api.G_Ret_Sts_Success;

42: /*
43: ** Initialize Processing
44: */
45:
46: x_return_status := Fnd_Api.G_Ret_Sts_Success;
47:
48: Fnd_Msg_Pub.Initialize;
49:
50: /*

Line 134: RAISE Fnd_Api.G_Exc_Error;

130: */
131:
132: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
133:
134: RAISE Fnd_Api.G_Exc_Error;
135:
136: END IF;
137:
138: Igw_Prop_Special_Reviews_Pvt.Create_Prop_Special_Reviews

Line 140: p_init_msg_list => Fnd_Api.G_True,

136: END IF;
137:
138: Igw_Prop_Special_Reviews_Pvt.Create_Prop_Special_Reviews
139: (
140: p_init_msg_list => Fnd_Api.G_True,
141: p_commit => Fnd_Api.G_False,
142: p_validate_only => p_validate_only,
143: x_rowid => l_rowid,
144: p_proposal_id => l_proposal_id,

Line 141: p_commit => Fnd_Api.G_False,

137:
138: Igw_Prop_Special_Reviews_Pvt.Create_Prop_Special_Reviews
139: (
140: p_init_msg_list => Fnd_Api.G_True,
141: p_commit => Fnd_Api.G_False,
142: p_validate_only => p_validate_only,
143: x_rowid => l_rowid,
144: p_proposal_id => l_proposal_id,
145: p_proposal_number => null,

Line 163: RAISE Fnd_Api.G_Exc_Error;

159: );
160:
161: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
162:
163: RAISE Fnd_Api.G_Exc_Error;
164:
165: END IF;
166:
167: /*

Line 171: IF Fnd_Api.To_Boolean(p_commit) THEN

167: /*
168: ** Commit data if API invoked in commit mode
169: */
170:
171: IF Fnd_Api.To_Boolean(p_commit) THEN
172:
173: COMMIT;
174:
175: END IF;

Line 179: WHEN Fnd_Api.G_Exc_Error THEN

175: END IF;
176:
177: EXCEPTION
178:
179: WHEN Fnd_Api.G_Exc_Error THEN
180:
181: ROLLBACK TO Create_Prop_Special_Review_Pub;
182:
183: x_return_status := Fnd_Api.G_Ret_Sts_Error;

Line 183: x_return_status := Fnd_Api.G_Ret_Sts_Error;

179: WHEN Fnd_Api.G_Exc_Error THEN
180:
181: ROLLBACK TO Create_Prop_Special_Review_Pub;
182:
183: x_return_status := Fnd_Api.G_Ret_Sts_Error;
184:
185: Fnd_Msg_Pub.Count_And_Get
186: (
187: p_encoded => Fnd_Api.G_False,

Line 187: p_encoded => Fnd_Api.G_False,

183: x_return_status := Fnd_Api.G_Ret_Sts_Error;
184:
185: Fnd_Msg_Pub.Count_And_Get
186: (
187: p_encoded => Fnd_Api.G_False,
188: p_count => x_msg_count,
189: p_data => x_msg_data
190: );
191:

Line 196: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

192: WHEN others THEN
193:
194: ROLLBACK TO Create_Prop_Special_Review_Pub;
195:
196: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
197:
198: Fnd_Msg_Pub.Add_Exc_Msg
199: (
200: p_pkg_name => G_PKG_NAME,

Line 206: p_encoded => Fnd_Api.G_False,

202: );
203:
204: Fnd_Msg_Pub.Count_And_Get
205: (
206: p_encoded => Fnd_Api.G_False,
207: p_count => x_msg_count,
208: p_data => x_msg_data
209: );
210: