DBA Data[Home] [Help]

APPS.POS_SUPPLIER_UDA_BO_PKG dependencies on FND_API

Line 185: WHEN fnd_api.g_exc_error THEN

181: IF pos_obj_list IS NOT NULL THEN
182: pos_obj_list.delete;
183: END IF;
184: EXCEPTION
185: WHEN fnd_api.g_exc_error THEN
186: x_return_status := fnd_api.g_ret_sts_error;
187: fnd_msg_pub.count_and_get(p_count => x_msg_count,
188: p_data => x_msg_data);
189:

Line 186: x_return_status := fnd_api.g_ret_sts_error;

182: pos_obj_list.delete;
183: END IF;
184: EXCEPTION
185: WHEN fnd_api.g_exc_error THEN
186: x_return_status := fnd_api.g_ret_sts_error;
187: fnd_msg_pub.count_and_get(p_count => x_msg_count,
188: p_data => x_msg_data);
189:
190: WHEN fnd_api.g_exc_unexpected_error THEN

Line 190: WHEN fnd_api.g_exc_unexpected_error THEN

186: x_return_status := fnd_api.g_ret_sts_error;
187: fnd_msg_pub.count_and_get(p_count => x_msg_count,
188: p_data => x_msg_data);
189:
190: WHEN fnd_api.g_exc_unexpected_error THEN
191: x_return_status := fnd_api.g_ret_sts_unexp_error;
192: fnd_msg_pub.count_and_get(p_count => x_msg_count,
193: p_data => x_msg_data);
194: WHEN OTHERS THEN

Line 191: x_return_status := fnd_api.g_ret_sts_unexp_error;

187: fnd_msg_pub.count_and_get(p_count => x_msg_count,
188: p_data => x_msg_data);
189:
190: WHEN fnd_api.g_exc_unexpected_error THEN
191: x_return_status := fnd_api.g_ret_sts_unexp_error;
192: fnd_msg_pub.count_and_get(p_count => x_msg_count,
193: p_data => x_msg_data);
194: WHEN OTHERS THEN
195: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 195: x_return_status := fnd_api.g_ret_sts_unexp_error;

191: x_return_status := fnd_api.g_ret_sts_unexp_error;
192: fnd_msg_pub.count_and_get(p_count => x_msg_count,
193: p_data => x_msg_data);
194: WHEN OTHERS THEN
195: x_return_status := fnd_api.g_ret_sts_unexp_error;
196: fnd_msg_pub.count_and_get(p_count => x_msg_count,
197: p_data => x_msg_data);
198:
199: END get_uda_data;

Line 281: x_return_status := fnd_api.g_ret_sts_success;

277:
278: create_update_mode VARCHAR2(100);
279:
280: BEGIN
281: x_return_status := fnd_api.g_ret_sts_success;
282:
283: l_pk_column_values := ego_col_name_value_pair_array(ego_col_name_value_pair_obj('PARTY_ID',
284: to_char(l_party_id)));
285:

Line 291: x_return_status := fnd_api.g_ret_sts_unexp_error;

287: create_update_mode := ego_user_attrs_data_pvt.g_create_mode;
288: ELSIF p_create_update_flag = 'U' THEN
289: create_update_mode := ego_user_attrs_data_pvt.g_update_mode;
290: ELSE
291: x_return_status := fnd_api.g_ret_sts_unexp_error;
292: x_msg_data := 'create update flag is not set';
293: RETURN;
294: END IF;
295:

Line 367: p_commit => fnd_api.g_false,

363: p_entity_id => NULL,
364: p_entity_index => NULL,
365: p_entity_code => NULL,
366: p_debug_level => NULL, --p_debug_level,
367: p_commit => fnd_api.g_false,
368: p_init_error_handler => 'T',
369: p_init_fnd_msg_list => 'T',
370: x_failed_row_id_list => l_failed_row_id_buffer,
371: x_return_status => l_return_status,

Line 376: IF l_return_status <> fnd_api.g_ret_sts_success THEN

372: x_errorcode => l_errorcode,
373: x_msg_count => l_msg_count,
374: x_msg_data => l_msg_data);
375:
376: IF l_return_status <> fnd_api.g_ret_sts_success THEN
377: error_handler.get_message_list(l_error_msg_tbl);
378: IF l_error_msg_tbl.first IS NOT NULL THEN
379: l_msg_count := l_error_msg_tbl.first;
380: WHILE l_msg_count IS NOT NULL LOOP

Line 392: WHEN fnd_api.g_exc_error THEN

388: x_msg_data := l_msg_data;
389: l_attributes_row_table.trim;
390:
391: EXCEPTION
392: WHEN fnd_api.g_exc_error THEN
393: x_return_status := fnd_api.g_ret_sts_error;
394: fnd_msg_pub.count_and_get(p_count => x_msg_count,
395: p_data => x_msg_data);
396:

Line 393: x_return_status := fnd_api.g_ret_sts_error;

389: l_attributes_row_table.trim;
390:
391: EXCEPTION
392: WHEN fnd_api.g_exc_error THEN
393: x_return_status := fnd_api.g_ret_sts_error;
394: fnd_msg_pub.count_and_get(p_count => x_msg_count,
395: p_data => x_msg_data);
396:
397: WHEN fnd_api.g_exc_unexpected_error THEN

Line 397: WHEN fnd_api.g_exc_unexpected_error THEN

393: x_return_status := fnd_api.g_ret_sts_error;
394: fnd_msg_pub.count_and_get(p_count => x_msg_count,
395: p_data => x_msg_data);
396:
397: WHEN fnd_api.g_exc_unexpected_error THEN
398: x_return_status := fnd_api.g_ret_sts_unexp_error;
399: fnd_msg_pub.count_and_get(p_count => x_msg_count,
400: p_data => x_msg_data);
401:

Line 398: x_return_status := fnd_api.g_ret_sts_unexp_error;

394: fnd_msg_pub.count_and_get(p_count => x_msg_count,
395: p_data => x_msg_data);
396:
397: WHEN fnd_api.g_exc_unexpected_error THEN
398: x_return_status := fnd_api.g_ret_sts_unexp_error;
399: fnd_msg_pub.count_and_get(p_count => x_msg_count,
400: p_data => x_msg_data);
401:
402: WHEN OTHERS THEN

Line 403: x_return_status := fnd_api.g_ret_sts_unexp_error;

399: fnd_msg_pub.count_and_get(p_count => x_msg_count,
400: p_data => x_msg_data);
401:
402: WHEN OTHERS THEN
403: x_return_status := fnd_api.g_ret_sts_unexp_error;
404: fnd_msg_pub.count_and_get(p_count => x_msg_count,
405: p_data => x_msg_data);
406: END;
407:

Line 423: x_return_status := fnd_api.g_ret_sts_success;

419: v_sql VARCHAR2(2000);
420: l_row_identifier NUMBER := 0;
421:
422: BEGIN
423: x_return_status := fnd_api.g_ret_sts_success;
424:
425: FOR i IN p_pos_supplier_uda.first .. p_pos_supplier_uda.last LOOP
426: IF p_pos_supplier_uda(i).party_site_id IS NOT NULL AND p_pos_supplier_uda(i)
427: .supplier_site_id IS NOT NULL THEN

Line 469: WHEN fnd_api.g_exc_error THEN

465: */
466: /* Call the EGO API to process the attributes based on the mode */
467:
468: EXCEPTION
469: WHEN fnd_api.g_exc_error THEN
470: x_return_status := fnd_api.g_ret_sts_error;
471: fnd_msg_pub.count_and_get(p_count => x_msg_count,
472: p_data => x_msg_data);
473:

Line 470: x_return_status := fnd_api.g_ret_sts_error;

466: /* Call the EGO API to process the attributes based on the mode */
467:
468: EXCEPTION
469: WHEN fnd_api.g_exc_error THEN
470: x_return_status := fnd_api.g_ret_sts_error;
471: fnd_msg_pub.count_and_get(p_count => x_msg_count,
472: p_data => x_msg_data);
473:
474: WHEN fnd_api.g_exc_unexpected_error THEN

Line 474: WHEN fnd_api.g_exc_unexpected_error THEN

470: x_return_status := fnd_api.g_ret_sts_error;
471: fnd_msg_pub.count_and_get(p_count => x_msg_count,
472: p_data => x_msg_data);
473:
474: WHEN fnd_api.g_exc_unexpected_error THEN
475: x_return_status := fnd_api.g_ret_sts_unexp_error;
476: fnd_msg_pub.count_and_get(p_count => x_msg_count,
477: p_data => x_msg_data);
478: WHEN OTHERS THEN

Line 475: x_return_status := fnd_api.g_ret_sts_unexp_error;

471: fnd_msg_pub.count_and_get(p_count => x_msg_count,
472: p_data => x_msg_data);
473:
474: WHEN fnd_api.g_exc_unexpected_error THEN
475: x_return_status := fnd_api.g_ret_sts_unexp_error;
476: fnd_msg_pub.count_and_get(p_count => x_msg_count,
477: p_data => x_msg_data);
478: WHEN OTHERS THEN
479: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 479: x_return_status := fnd_api.g_ret_sts_unexp_error;

475: x_return_status := fnd_api.g_ret_sts_unexp_error;
476: fnd_msg_pub.count_and_get(p_count => x_msg_count,
477: p_data => x_msg_data);
478: WHEN OTHERS THEN
479: x_return_status := fnd_api.g_ret_sts_unexp_error;
480: fnd_msg_pub.count_and_get(p_count => x_msg_count,
481: p_data => x_msg_data);
482: END;
483: