DBA Data[Home] [Help]

APPS.M4U_SETUP_PACKAGE dependencies on ECX_TP_API

Line 15: -- => corresponds to the ecx_tp_api, nothing to talk abt

11: -- If detail record is present it updates else inserts
12: -- Arguments
13: -- x_err_buf => API param for concurrent program calls
14: -- x_retcode => API param for concurrent program calls
15: -- => corresponds to the ecx_tp_api, nothing to talk abt
16: -- Notes
17: -- none
18: PROCEDURE add_or_update_tp_detail(
19: x_errbuf OUT NOCOPY VARCHAR2,

Line 236: cln_debug_pub.Add('---- Call ecx_tp_api.create_tp_detail ----', 1);

232:
233: IF NOT l_record_found THEN
234: IF (l_Debug_Level <= 1) THEN
235: cln_debug_pub.Add('---- Setup ECX TP Detail Values in DB ----', 1);
236: cln_debug_pub.Add('---- Call ecx_tp_api.create_tp_detail ----', 1);
237: END IF;
238:
239: ecx_tp_api.create_tp_detail(
240: x_return_status => l_retcode,

Line 239: ecx_tp_api.create_tp_detail(

235: cln_debug_pub.Add('---- Setup ECX TP Detail Values in DB ----', 1);
236: cln_debug_pub.Add('---- Call ecx_tp_api.create_tp_detail ----', 1);
237: END IF;
238:
239: ecx_tp_api.create_tp_detail(
240: x_return_status => l_retcode,
241: x_msg => l_retmesg,
242: x_tp_detail_id => l_tp_dtl_id,
243: p_tp_header_id => l_tp_hdr_id,

Line 266: cln_debug_pub.Add('---- ecx_tp_api.update_trading_partner returns Normal----', 1);

262: RAISE FND_API.G_EXC_ERROR;
263: END IF;
264:
265: IF (l_Debug_Level <= 1) THEN
266: cln_debug_pub.Add('---- ecx_tp_api.update_trading_partner returns Normal----', 1);
267: END IF;
268: ELSE
269:
270: IF (l_Debug_Level <= 1) THEN

Line 272: cln_debug_pub.Add('---- Call ecx_tp_api.update_tp_detail ----', 1);

268: ELSE
269:
270: IF (l_Debug_Level <= 1) THEN
271: cln_debug_pub.Add('---- Setup ECX TP Detail Values in DB ----', 1);
272: cln_debug_pub.Add('---- Call ecx_tp_api.update_tp_detail ----', 1);
273: END IF;
274: ecx_tp_api.update_tp_detail(
275: x_return_status => l_retcode,
276: x_msg => l_retmesg,

Line 274: ecx_tp_api.update_tp_detail(

270: IF (l_Debug_Level <= 1) THEN
271: cln_debug_pub.Add('---- Setup ECX TP Detail Values in DB ----', 1);
272: cln_debug_pub.Add('---- Call ecx_tp_api.update_tp_detail ----', 1);
273: END IF;
274: ecx_tp_api.update_tp_detail(
275: x_return_status => l_retcode,
276: x_msg => l_retmesg,
277: p_tp_detail_id => l_tp_dtl_id,
278: p_map_code => l_map,

Line 301: cln_debug_pub.Add('---- ecx_tp_api.update_trading_partner returns Normal----', 1);

297: RAISE FND_API.G_EXC_ERROR;
298: END IF;
299:
300: IF (l_Debug_Level <= 1) THEN
301: cln_debug_pub.Add('---- ecx_tp_api.update_trading_partner returns Normal----', 1);
302: END IF;
303: END IF;
304:
305: IF l_retcode = 0 THEN

Line 555: cln_debug_pub.Add('---- Call ecx_tp_api.create_trading_partner ----', 1);

551:
552: IF NOT l_record_found THEN
553: IF (l_Debug_Level <= 1) THEN
554: cln_debug_pub.Add('---- Setup ECX TP Header Values in DB ----', 1);
555: cln_debug_pub.Add('---- Call ecx_tp_api.create_trading_partner ----', 1);
556: END IF;
557:
558: ecx_tp_api.create_trading_partner(
559: x_return_status => l_retcode,

Line 558: ecx_tp_api.create_trading_partner(

554: cln_debug_pub.Add('---- Setup ECX TP Header Values in DB ----', 1);
555: cln_debug_pub.Add('---- Call ecx_tp_api.create_trading_partner ----', 1);
556: END IF;
557:
558: ecx_tp_api.create_trading_partner(
559: x_return_status => l_retcode,
560: x_msg => l_retmesg,
561: x_tp_header_id => l_tp_hdr_id,
562: p_party_type => 'I',

Line 582: cln_debug_pub.Add('---- ecx_tp_api.create_trading_partner returns Normal----', 1);

578: RAISE FND_API.G_EXC_ERROR;
579: END IF;
580:
581: IF (l_Debug_Level <= 1) THEN
582: cln_debug_pub.Add('---- ecx_tp_api.create_trading_partner returns Normal----', 1);
583: END IF;
584: ELSE
585: IF (l_Debug_Level <= 1) THEN
586: cln_debug_pub.Add('---- Update ECX TP Header Values in DB ----', 1);

Line 587: cln_debug_pub.Add('---- Call ecx_tp_api.update_trading_partner ----', 1);

583: END IF;
584: ELSE
585: IF (l_Debug_Level <= 1) THEN
586: cln_debug_pub.Add('---- Update ECX TP Header Values in DB ----', 1);
587: cln_debug_pub.Add('---- Call ecx_tp_api.update_trading_partner ----', 1);
588: END IF;
589:
590: ecx_tp_api.update_trading_partner(
591: x_return_status => l_retcode,

Line 590: ecx_tp_api.update_trading_partner(

586: cln_debug_pub.Add('---- Update ECX TP Header Values in DB ----', 1);
587: cln_debug_pub.Add('---- Call ecx_tp_api.update_trading_partner ----', 1);
588: END IF;
589:
590: ecx_tp_api.update_trading_partner(
591: x_return_status => l_retcode,
592: x_msg => l_retmesg,
593: p_tp_header_id => l_tp_hdr_id,
594: p_company_admin_email => '[email protected]'

Line 611: cln_debug_pub.Add('---- ecx_tp_api.update_trading_partner returns Normal----', 1);

607: RAISE FND_API.G_EXC_ERROR;
608: END IF;
609:
610: IF (l_Debug_Level <= 1) THEN
611: cln_debug_pub.Add('---- ecx_tp_api.update_trading_partner returns Normal----', 1);
612: END IF;
613: END IF;
614:
615: IF (l_Debug_Level <= 1) THEN