DBA Data[Home] [Help]

APPS.POS_HZ_LOCATION_BO_PKG dependencies on FND_API

Line 156: WHEN fnd_api.g_exc_error THEN

152:
153: x_hz_location_bo := l_pos_hz_location_bo;
154:
155: EXCEPTION
156: WHEN fnd_api.g_exc_error THEN
157:
158: x_return_status := fnd_api.g_ret_sts_error;
159: x_msg_count := 1;
160: x_msg_data := SQLCODE || SQLERRM;

Line 158: x_return_status := fnd_api.g_ret_sts_error;

154:
155: EXCEPTION
156: WHEN fnd_api.g_exc_error THEN
157:
158: x_return_status := fnd_api.g_ret_sts_error;
159: x_msg_count := 1;
160: x_msg_data := SQLCODE || SQLERRM;
161: WHEN fnd_api.g_exc_unexpected_error THEN
162:

Line 161: WHEN fnd_api.g_exc_unexpected_error THEN

157:
158: x_return_status := fnd_api.g_ret_sts_error;
159: x_msg_count := 1;
160: x_msg_data := SQLCODE || SQLERRM;
161: WHEN fnd_api.g_exc_unexpected_error THEN
162:
163: x_return_status := fnd_api.g_ret_sts_unexp_error;
164: x_msg_count := 1;
165: x_msg_data := SQLCODE || SQLERRM;

Line 163: x_return_status := fnd_api.g_ret_sts_unexp_error;

159: x_msg_count := 1;
160: x_msg_data := SQLCODE || SQLERRM;
161: WHEN fnd_api.g_exc_unexpected_error THEN
162:
163: x_return_status := fnd_api.g_ret_sts_unexp_error;
164: x_msg_count := 1;
165: x_msg_data := SQLCODE || SQLERRM;
166: WHEN OTHERS THEN
167:

Line 168: x_return_status := fnd_api.g_ret_sts_unexp_error;

164: x_msg_count := 1;
165: x_msg_data := SQLCODE || SQLERRM;
166: WHEN OTHERS THEN
167:
168: x_return_status := fnd_api.g_ret_sts_unexp_error;
169:
170: x_msg_count := 1;
171: x_msg_data := SQLCODE || SQLERRM;
172: END get_hz_location_bo;

Line 189: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

185: * @rep:catagory BUSSINESS_ENTITY AP_SUPPLIER
186: */
187:
188: PROCEDURE create_hz_location_bo(p_api_version IN NUMBER DEFAULT NULL,
189: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
190: p_orig_system IN VARCHAR2,
191: p_orig_system_reference IN VARCHAR2,
192: p_hz_location_bo IN pos_hz_location_bo,
193: p_create_update_flag IN VARCHAR2,

Line 287: WHEN fnd_api.g_exc_error THEN

283: x_msg_data);
284: END IF;
285:
286: EXCEPTION
287: WHEN fnd_api.g_exc_error THEN
288:
289: x_return_status := fnd_api.g_ret_sts_error;
290: fnd_msg_pub.count_and_get(p_count => x_msg_count,
291: p_data => x_msg_data);

Line 289: x_return_status := fnd_api.g_ret_sts_error;

285:
286: EXCEPTION
287: WHEN fnd_api.g_exc_error THEN
288:
289: x_return_status := fnd_api.g_ret_sts_error;
290: fnd_msg_pub.count_and_get(p_count => x_msg_count,
291: p_data => x_msg_data);
292: WHEN fnd_api.g_exc_unexpected_error THEN
293:

Line 292: WHEN fnd_api.g_exc_unexpected_error THEN

288:
289: x_return_status := fnd_api.g_ret_sts_error;
290: fnd_msg_pub.count_and_get(p_count => x_msg_count,
291: p_data => x_msg_data);
292: WHEN fnd_api.g_exc_unexpected_error THEN
293:
294: x_return_status := fnd_api.g_ret_sts_unexp_error;
295: fnd_msg_pub.count_and_get(p_count => x_msg_count,
296: p_data => x_msg_data);

Line 294: x_return_status := fnd_api.g_ret_sts_unexp_error;

290: fnd_msg_pub.count_and_get(p_count => x_msg_count,
291: p_data => x_msg_data);
292: WHEN fnd_api.g_exc_unexpected_error THEN
293:
294: x_return_status := fnd_api.g_ret_sts_unexp_error;
295: fnd_msg_pub.count_and_get(p_count => x_msg_count,
296: p_data => x_msg_data);
297: WHEN OTHERS THEN
298:

Line 299: x_return_status := fnd_api.g_ret_sts_unexp_error;

295: fnd_msg_pub.count_and_get(p_count => x_msg_count,
296: p_data => x_msg_data);
297: WHEN OTHERS THEN
298:
299: x_return_status := fnd_api.g_ret_sts_unexp_error;
300:
301: fnd_msg_pub.count_and_get(p_count => x_msg_count,
302: p_data => x_msg_data);
303: END;

Line 319: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

315: * @rep:displayname Update Vendor Contact
316: * @rep:catagory BUSSINESS_ENTITY AP_SUPPLIER
317: */
318: /*PROCEDURE update_hz_location_bo(p_api_version IN NUMBER DEFAULT NULL,
319: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
320: p_location_rec IN hz_location_v2pub.location_rec_type,
321: x_object_version_number IN OUT NOCOPY NUMBER,
322: x_return_status OUT NOCOPY VARCHAR2,
323: x_msg_count OUT NOCOPY NUMBER,

Line 336: WHEN fnd_api.g_exc_error THEN

332: x_msg_count,
333: x_msg_data);
334:
335: EXCEPTION
336: WHEN fnd_api.g_exc_error THEN
337:
338: x_return_status := fnd_api.g_ret_sts_error;
339: fnd_msg_pub.count_and_get(p_count => x_msg_count,
340: p_data => x_msg_data);

Line 338: x_return_status := fnd_api.g_ret_sts_error;

334:
335: EXCEPTION
336: WHEN fnd_api.g_exc_error THEN
337:
338: x_return_status := fnd_api.g_ret_sts_error;
339: fnd_msg_pub.count_and_get(p_count => x_msg_count,
340: p_data => x_msg_data);
341: WHEN fnd_api.g_exc_unexpected_error THEN
342:

Line 341: WHEN fnd_api.g_exc_unexpected_error THEN

337:
338: x_return_status := fnd_api.g_ret_sts_error;
339: fnd_msg_pub.count_and_get(p_count => x_msg_count,
340: p_data => x_msg_data);
341: WHEN fnd_api.g_exc_unexpected_error THEN
342:
343: x_return_status := fnd_api.g_ret_sts_unexp_error;
344: fnd_msg_pub.count_and_get(p_count => x_msg_count,
345: p_data => x_msg_data);

Line 343: x_return_status := fnd_api.g_ret_sts_unexp_error;

339: fnd_msg_pub.count_and_get(p_count => x_msg_count,
340: p_data => x_msg_data);
341: WHEN fnd_api.g_exc_unexpected_error THEN
342:
343: x_return_status := fnd_api.g_ret_sts_unexp_error;
344: fnd_msg_pub.count_and_get(p_count => x_msg_count,
345: p_data => x_msg_data);
346: WHEN OTHERS THEN
347:

Line 348: x_return_status := fnd_api.g_ret_sts_unexp_error;

344: fnd_msg_pub.count_and_get(p_count => x_msg_count,
345: p_data => x_msg_data);
346: WHEN OTHERS THEN
347:
348: x_return_status := fnd_api.g_ret_sts_unexp_error;
349:
350: fnd_msg_pub.count_and_get(p_count => x_msg_count,
351: p_data => x_msg_data);
352: END update_hz_location_bo;