eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_WF_DEL_REQ_CREDIT_PUB dependencies on IEX_DEBUG_PUB

Line 480: iex_debug_pub.logmessage ('IEX_WF_DEL_REQ_CREDIT_PUB: Starting update_approval_status......= ');

476: l_msg_data VARCHAR2(2000);
477:
478: BEGIN
479:
480: iex_debug_pub.logmessage ('IEX_WF_DEL_REQ_CREDIT_PUB: Starting update_approval_status......= ');
481:
482: if funcmode <> 'RUN' then
483: result := wf_engine.eng_null;
484: return;

Line 522: iex_debug_pub.logmessage ('IEX_WF_DEL_REQ_CREDIT_PUB: l_del_type ......= '||l_del_type);

518: itemtype => itemtype,
519: itemkey => itemkey,
520: aname => 'BANKRUPTCY_ID');
521:
522: iex_debug_pub.logmessage ('IEX_WF_DEL_REQ_CREDIT_PUB: l_del_type ......= '||l_del_type);
523:
524: IF l_del_type = 'Delinquency' THEN
525: update IEX_DELINQUENCIES_ALL
526: set CREDIT_HOLD_APPROVED_FLAG = 'Y'

Line 541: iex_debug_pub.logmessage ('IEX_WF_DEL_REQ_CREDIT_PUB: Bankrutpcy Start ......= ');

537: update IEX_WRITEOFFS
538: set CREDIT_HOLD_APPROVED_FLAG = 'Y'
539: where writeoff_id = l_writeoff_id;
540: ELSIF l_del_type = 'Bankrupt' THEN
541: iex_debug_pub.logmessage ('IEX_WF_DEL_REQ_CREDIT_PUB: Bankrutpcy Start ......= ');
542: update IEX_BANKRUPTCIES
543: set CREDIT_HOLD_APPROVED_FLAG = 'Y'
544: where bankruptcy_id = l_bankruptcy_id;
545: iex_debug_pub.logmessage ('IEX_WF_DEL_REQ_CREDIT_PUB: Bankrutpcy End ......= ');

Line 545: iex_debug_pub.logmessage ('IEX_WF_DEL_REQ_CREDIT_PUB: Bankrutpcy End ......= ');

541: iex_debug_pub.logmessage ('IEX_WF_DEL_REQ_CREDIT_PUB: Bankrutpcy Start ......= ');
542: update IEX_BANKRUPTCIES
543: set CREDIT_HOLD_APPROVED_FLAG = 'Y'
544: where bankruptcy_id = l_bankruptcy_id;
545: iex_debug_pub.logmessage ('IEX_WF_DEL_REQ_CREDIT_PUB: Bankrutpcy End ......= ');
546:
547: -- Bug 6936225 by Ehuh Starting....
548: begin
549: Open c_get_acct(l_bankruptcy_id);

Line 555: iex_debug_pub.logmessage('IEX:no acct');

551: Fetch c_get_acct into l_account_id;
552:
553: If (C_GET_ACCT%NOTFOUND) THEN
554: if (iIdx = 0) then
555: iex_debug_pub.logmessage('IEX:no acct');
556: end if;
557: exit;
558: else
559: iIdx := iIdx + 1;

Line 561: iex_debug_pub.logmessage ('IEX: INDEX ......= '||iIdx);

557: exit;
558: else
559: iIdx := iIdx + 1;
560: l_acct_id_tbl(iIdx) := l_account_id;
561: iex_debug_pub.logmessage ('IEX: INDEX ......= '||iIdx);
562: iex_debug_pub.logmessage ('IEX: l_account_id ......= '||l_account_id);
563: end if;
564: End Loop;
565:

Line 562: iex_debug_pub.logmessage ('IEX: l_account_id ......= '||l_account_id);

558: else
559: iIdx := iIdx + 1;
560: l_acct_id_tbl(iIdx) := l_account_id;
561: iex_debug_pub.logmessage ('IEX: INDEX ......= '||iIdx);
562: iex_debug_pub.logmessage ('IEX: l_account_id ......= '||l_account_id);
563: end if;
564: End Loop;
565:
566: Close C_GET_ACCT;

Line 569: iex_debug_pub.logmessage ('IEX: l_acct_id_tbl(i) .....= '||l_acct_id_tbl(i));

565:
566: Close C_GET_ACCT;
567: --
568: For i in 1..iIdx loop
569: iex_debug_pub.logmessage ('IEX: l_acct_id_tbl(i) .....= '||l_acct_id_tbl(i));
570: IEX_CREDIT_HOLD_API.UPDATE_CREDIT_HOLD
571: (p_api_version => 1.0,
572: p_init_msg_list => 'T',
573: p_commit => 'T',

Line 581: iex_debug_pub.logmessage ('IEX_CREDIT_HOLD: l_return_status .....= '||l_return_status);

577: x_return_status => l_return_status,
578: x_msg_count => l_msg_count,
579: x_msg_data => l_msg_data);
580:
581: iex_debug_pub.logmessage ('IEX_CREDIT_HOLD: l_return_status .....= '||l_return_status);
582: End loop;
583:
584: exception
585: when others then

Line 586: iex_debug_pub.logmessage ('Exception from 2nd Begin...... ');

582: End loop;
583:
584: exception
585: when others then
586: iex_debug_pub.logmessage ('Exception from 2nd Begin...... ');
587: null;
588: end;
589: -- Bug 6936225 by Ehuh Ending....
590:

Line 592: iex_debug_pub.logmessage ('IEX_WF_DEL_REQ_CREDIT_PUB: Else ......= ');

588: end;
589: -- Bug 6936225 by Ehuh Ending....
590:
591: ELSE
592: iex_debug_pub.logmessage ('IEX_WF_DEL_REQ_CREDIT_PUB: Else ......= ');
593: null;
594: END IF;
595:
596: result := 'COMPLETE';

Line 600: iex_debug_pub.logmessage ('IEX_WF_DEL_REQ_CREDIT_PUB: l_errmsg_name......= '||l_errmsg_name);

596: result := 'COMPLETE';
597:
598: EXCEPTION
599: WHEN L_API_ERROR then
600: iex_debug_pub.logmessage ('IEX_WF_DEL_REQ_CREDIT_PUB: l_errmsg_name......= '||l_errmsg_name);
601: WF_CORE.Raise(l_errmsg_name);
602: WHEN OTHERS THEN
603: iex_debug_pub.logmessage ('IEX_WF_DEL_REQ_CREDIT_PUB: Exception Others ......= ');
604: WF_CORE.Context('IEX_DEL_REQ_CREDIT_WF_PUB', 'Reject_Contract',

Line 603: iex_debug_pub.logmessage ('IEX_WF_DEL_REQ_CREDIT_PUB: Exception Others ......= ');

599: WHEN L_API_ERROR then
600: iex_debug_pub.logmessage ('IEX_WF_DEL_REQ_CREDIT_PUB: l_errmsg_name......= '||l_errmsg_name);
601: WF_CORE.Raise(l_errmsg_name);
602: WHEN OTHERS THEN
603: iex_debug_pub.logmessage ('IEX_WF_DEL_REQ_CREDIT_PUB: Exception Others ......= ');
604: WF_CORE.Context('IEX_DEL_REQ_CREDIT_WF_PUB', 'Reject_Contract',
605: itemtype, itemkey, actid, funcmode);
606: RAISE;
607: END update_approval_status;