887: -------------------------------------------------------------------------
888: -- Create or update ECX tp detail
889: IF NOT l_record_found THEN
890: --Create
891: m4u_dmd_utils.log('Call ecx_tp_api.create_tp_detail',1);
892: l_progress := 'Call ecx_tp_api.create_tp_detail';
893:
894: ecx_tp_api.create_tp_detail
895: (
888: -- Create or update ECX tp detail
889: IF NOT l_record_found THEN
890: --Create
891: m4u_dmd_utils.log('Call ecx_tp_api.create_tp_detail',1);
892: l_progress := 'Call ecx_tp_api.create_tp_detail';
893:
894: ecx_tp_api.create_tp_detail
895: (
896: x_return_status => l_ret_sts,
890: --Create
891: m4u_dmd_utils.log('Call ecx_tp_api.create_tp_detail',1);
892: l_progress := 'Call ecx_tp_api.create_tp_detail';
893:
894: ecx_tp_api.create_tp_detail
895: (
896: x_return_status => l_ret_sts,
897: x_msg => l_ret_msg,
898: x_tp_detail_id => l_tp_dtl_id,
923: RETURN;
924: END IF;
925: ELSE
926: --Update
927: m4u_dmd_utils.log('Call ecx_tp_api.update_tp_detail',1);
928: l_progress := 'Call ecx_tp_api.update_tp_detail';
929:
930: ecx_tp_api.update_tp_detail
931: (
924: END IF;
925: ELSE
926: --Update
927: m4u_dmd_utils.log('Call ecx_tp_api.update_tp_detail',1);
928: l_progress := 'Call ecx_tp_api.update_tp_detail';
929:
930: ecx_tp_api.update_tp_detail
931: (
932: x_return_status => l_ret_sts,
926: --Update
927: m4u_dmd_utils.log('Call ecx_tp_api.update_tp_detail',1);
928: l_progress := 'Call ecx_tp_api.update_tp_detail';
929:
930: ecx_tp_api.update_tp_detail
931: (
932: x_return_status => l_ret_sts,
933: x_msg => l_ret_msg,
934: p_tp_detail_id => l_tp_dtl_id,
1103: -----------------------------------------------------------------------------
1104: --ECX TP Header
1105: IF NOT l_record_found THEN
1106: --create
1107: m4u_dmd_utils.log('Call ecx_tp_api.create_trading_partner', 2);
1108: l_progress := 'Call ecx_tp_api.create_trading_partner';
1109:
1110: ecx_tp_api.create_trading_partner
1111: (
1104: --ECX TP Header
1105: IF NOT l_record_found THEN
1106: --create
1107: m4u_dmd_utils.log('Call ecx_tp_api.create_trading_partner', 2);
1108: l_progress := 'Call ecx_tp_api.create_trading_partner';
1109:
1110: ecx_tp_api.create_trading_partner
1111: (
1112: x_return_status => l_ret_sts,
1106: --create
1107: m4u_dmd_utils.log('Call ecx_tp_api.create_trading_partner', 2);
1108: l_progress := 'Call ecx_tp_api.create_trading_partner';
1109:
1110: ecx_tp_api.create_trading_partner
1111: (
1112: x_return_status => l_ret_sts,
1113: x_msg => l_ret_msg,
1114: x_tp_header_id => l_tp_hdr_id,
1127:
1128:
1129: ELSE
1130: --Update
1131: m4u_dmd_utils.log('Call ecx_tp_api.update_trading_partner', 2);
1132: l_progress := 'Call ecx_tp_api.update_trading_partner';
1133:
1134: ecx_tp_api.update_trading_partner
1135: (
1128:
1129: ELSE
1130: --Update
1131: m4u_dmd_utils.log('Call ecx_tp_api.update_trading_partner', 2);
1132: l_progress := 'Call ecx_tp_api.update_trading_partner';
1133:
1134: ecx_tp_api.update_trading_partner
1135: (
1136: x_return_status => l_ret_sts,
1130: --Update
1131: m4u_dmd_utils.log('Call ecx_tp_api.update_trading_partner', 2);
1132: l_progress := 'Call ecx_tp_api.update_trading_partner';
1133:
1134: ecx_tp_api.update_trading_partner
1135: (
1136: x_return_status => l_ret_sts,
1137: x_msg => l_ret_msg,
1138: p_tp_header_id => l_tp_hdr_id,