[Home] [Help]
1: PACKAGE BODY pos_supplier_contact_bo_pkg AS
2: /* $Header: POSSPCONB.pls 120.1 2010/11/25 12:08:36 puppulur noship $ */
3: /*#
4: * Use this routine to get supplier contact
5: * @param p_api_version The version of API
424: -- succeed
425:
426: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
427: fnd_log.string(fnd_log.level_procedure,
428: 'pos_supplier_contact_bo_pkg.create_pos_supp_contact_bo',
429: l_step || ' x_return_status = ' || x_return_status ||
430: ' x_vendor_contact_id = ' || x_vendor_contact_id ||
431: ' x_per_party_id = ' || x_per_party_id ||
432: ' x_rel_party_id = ' || x_rel_party_id ||
439:
440: --ROLLBACK TO upd_vndr_contact;
441: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
442: fnd_log.string(fnd_log.level_error,
443: 'pos_supplier_contact_bo_pkg.create_pos_supp_contact_bo',
444: l_step || ' x_return_status = ' || x_return_status ||
445: ', x_msg_count = ' || x_msg_count ||
446: ', x_msg_data = ' || x_msg_data);
447: END IF;
515: x_return_status = fnd_api.g_ret_sts_success THEN
516: -- succeed
517: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
518: fnd_log.string(fnd_log.level_procedure,
519: 'pos_supplier_contact_bo_pkg.create_pos_supp_contact_bo',
520: l_step || ' x_return_status = ' ||
521: x_return_status || ' x_vendor_contact_id = ' ||
522: x_vendor_contact_id || ' x_per_party_id = ' ||
523: x_per_party_id || ' x_rel_party_id = ' ||
529: -- failed
530: ROLLBACK TO upd_vndr_contact;
531: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level) THEN
532: fnd_log.string(fnd_log.level_error,
533: 'pos_supplier_contact_bo_pkg.create_pos_supp_contact_bo',
534: l_step || ' x_return_status = ' ||
535: x_return_status || ', x_msg_count = ' ||
536: x_msg_count || ', x_msg_data = ' ||
537: x_msg_data);
555: x_msg_count := 1;
556: x_msg_data := SQLCODE || SQLERRM;
557: END update_pos_supp_contact_bo;
558: */
559: END pos_supplier_contact_bo_pkg;