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_STRATEGY_WORK_PUB dependencies on IEX_DEBUG_PUB

Line 117: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, funcmode = ' || funcmode);

113:
114:
115: -- IF PG_DEBUG < 10 THEN
116: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
117: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, funcmode = ' || funcmode);
118: END IF;
119:
120: if funcmode <> 'RUN' then
121: result := wf_engine.eng_null;

Line 127: iex_debug_pub.logmessage ('send_mail: ' || 'itemtype = ' || itemtype);

123: end if;
124:
125: -- IF PG_DEBUG < 10 THEN
126: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
127: iex_debug_pub.logmessage ('send_mail: ' || 'itemtype = ' || itemtype);
128: END IF;
129: -- IF PG_DEBUG < 10 THEN
130: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
131: iex_debug_pub.logmessage ('send_mail: ' || 'itemtkey = ' || itemkey);

Line 131: iex_debug_pub.logmessage ('send_mail: ' || 'itemtkey = ' || itemkey);

127: iex_debug_pub.logmessage ('send_mail: ' || 'itemtype = ' || itemtype);
128: END IF;
129: -- IF PG_DEBUG < 10 THEN
130: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
131: iex_debug_pub.logmessage ('send_mail: ' || 'itemtkey = ' || itemkey);
132: END IF;
133: l_party_id := wf_engine.GetItemAttrNumber(
134: itemtype => itemtype,
135: itemkey => itemkey,

Line 142: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, after PARTY_ID ='|| l_PARTY_ID );

138: if (l_party_id <> 0) then
139:
140: -- IF PG_DEBUG < 10 THEN
141: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
142: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, after PARTY_ID ='|| l_PARTY_ID );
143: END IF;
144:
145: l_count := l_count +1;
146: l_fulfillment_bind_tbl(l_count).key_name := 'party_id';

Line 160: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, strategy_id ' );

156: aname => 'STRATEGY_ID');
157: if (l_strategy_id <> 0) then
158: -- IF PG_DEBUG < 10 THEN
159: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
160: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, strategy_id ' );
161: END IF;
162: l_count := l_count +1;
163: l_fulfillment_bind_tbl(l_count).key_name := 'strategy_id';
164: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';

Line 175: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, delinquency_id ' );

171: aname => 'DELINQUENCY_ID');
172: if (l_delinquency_id <> 0) then
173: -- IF PG_DEBUG < 10 THEN
174: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
175: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, delinquency_id ' );
176: END IF;
177: l_count := l_count +1;
178: l_fulfillment_bind_tbl(l_count).key_name := 'delinquency_id';
179: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';

Line 190: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, cust_account_id ' );

186: aname => 'CUST_ACCOUNT_ID');
187: if (l_cust_account_id <> 0) then
188: -- IF PG_DEBUG < 10 THEN
189: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
190: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, cust_account_id ' );
191: END IF;
192: l_count := l_count +1;
193: l_fulfillment_bind_tbl(l_count).key_name := 'cust_account_id';
194: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';

Line 213: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, overdue_amount ');

209: aname => 'OVERDUE_AMOUNT');
210: if (l_overdue_amount <> 0) then
211: -- IF PG_DEBUG < 10 THEN
212: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
213: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, overdue_amount ');
214: END IF;
215: l_count := l_count +1;
216: l_fulfillment_bind_tbl(l_count).key_name := 'overdue_amount';
217: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';

Line 230: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, delinquency_status ' );

226: aname => 'DELINQUENCY_STATUS');
227: if (l_delinquency_status is not null) then
228: -- IF PG_DEBUG < 10 THEN
229: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
230: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, delinquency_status ' );
231: END IF;
232: l_count := l_count +1;
233: l_fulfillment_bind_tbl(l_count).key_name := 'delinquency_status';
234: l_fulfillment_bind_tbl(l_count).key_type := 'VARCHAR2';

Line 242: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, org_id ' );

238:
239: if (l_org_id is not null) then
240: -- IF PG_DEBUG < 10 THEN
241: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
242: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, org_id ' );
243: END IF;
244: l_count := l_count +1;
245: l_fulfillment_bind_tbl(l_count).key_name := 'org_id';
246: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';

Line 258: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, aging_bucket_line_id ' );

254: /* not pass the l_aging_bucket_line_id - pass customer_site_use_id instead
255: if (l_aging_bucket_line_id <> 0) then
256: --IF PG_DEBUG < 10 THEN
257: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
258: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, aging_bucket_line_id ' );
259: END IF;
260: l_count := l_count +1;
261: l_fulfillment_bind_tbl(l_count).key_name := 'aging_bucket_line_id';
262: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';

Line 274: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, customer_site_use_id ' );

270: aname => 'CUSTOMER_SITE_USE_ID');
271: if (l_customer_site_use_id <> 0) then
272: -- IF PG_DEBUG < 10 THEN
273: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
274: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, customer_site_use_id ' );
275: END IF;
276: l_count := l_count +1;
277: l_fulfillment_bind_tbl(l_count).key_name := 'customer_site_use_id';
278: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';

Line 290: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, payment_schedule_id ');

286: aname => 'PAYMENT_SCHEDULE_ID');
287: if (l_payment_schedule_id <> 0) then
288: -- IF PG_DEBUG < 10 THEN
289: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
290: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, payment_schedule_id ');
291: END IF;
292: l_count := l_count +1;
293: l_fulfillment_bind_tbl(l_count).key_name := 'payment_schedule_id';
294: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';

Line 308: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, template_id ' );

304: itemkey => itemkey,
305: aname => 'XDO_TEMPLATE_ID');
306: if (l_template_id <> 0) then
307: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
308: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, template_id ' );
309: END IF;
310: end if;
311:
312: if (l_xdo_template_id <> 0) then

Line 314: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, xdo_template_id ' );

310: end if;
311:
312: if (l_xdo_template_id <> 0) then
313: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
314: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, xdo_template_id ' );
315: END IF;
316: end if;
317: /*
318: l_count := l_count +1;

Line 338: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, workitem_id ' );

334: aname => 'WORKITEM_ID');
335: if (l_workitem_id <> 0) then
336: -- IF PG_DEBUG < 10 THEN
337: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
338: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, workitem_id ' );
339: END IF;
340: /*
341: l_count := l_count +1;
342: l_fulfillment_bind_tbl(l_count).key_name := 'workitem_id';

Line 353: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, l_count ='|| l_count );

349: end if;
350:
351: -- IF PG_DEBUG < 10 THEN
352: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
353: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, l_count ='|| l_count );
354: END IF;
355:
356: -- ctlee - check the hz_customer_profiles.dunning_letter
357: if ( iex_utilities.DunningProfileCheck (

Line 383: iex_debug_pub.logmessage ('send_mail: ' || ' check fail dunning profile check ' );

379: WHEN OTHERS THEN
380: NULL;
381: END;
382: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
383: iex_debug_pub.logmessage ('send_mail: ' || ' check fail dunning profile check ' );
384: END IF;
385: return;
386: end if;
387:

Line 414: iex_debug_pub.logmessage ('send_mail: ' || ' check fail dunning min amount check ' );

410: WHEN OTHERS THEN
411: NULL;
412: END;
413: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
414: iex_debug_pub.logmessage ('send_mail: ' || ' check fail dunning min amount check ' );
415: END IF;
416: return;
417:
418: end if;

Line 448: iex_debug_pub.logmessage ('send_mail: ' || ' after fulfil method');

444: end;
445:
446: -- IF PG_DEBUG < 10 THEN
447: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
448: iex_debug_pub.logmessage ('send_mail: ' || ' after fulfil method');
449: END IF;
450:
451: -- ctlee - 5/20 create dunning record; 11/21/2002 remove checking profile error when update a non-existing record
452: -- l_unique_fulfillment := nvl(fnd_profile.value('IEX_STRY_UNIQUE_FULFILMENT'), 'N');

Line 475: iex_debug_pub.logmessage('Default StrategyLevel ' || l_DefaultStrategyLevel);

471: from iex_strategies
472: where strategy_id = l_strategy_id;
473:
474: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
475: iex_debug_pub.logmessage('Default StrategyLevel ' || l_DefaultStrategyLevel);
476: END IF;
477: EXCEPTION
478: WHEN OTHERS THEN
479: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 480: iex_debug_pub.logmessage('Strategy Level Rised Exception ');

476: END IF;
477: EXCEPTION
478: WHEN OTHERS THEN
479: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
480: iex_debug_pub.logmessage('Strategy Level Rised Exception ');
481: END IF;
482: l_DefaultStrategyLevel := 'DELINQUENCY';
483: END;
484: IF l_DefaultStrategyLevel = 'CUSTOMER' THEN

Line 530: iex_debug_pub.logmessage ('close dunning before fulfillment exception');

526: );
527: exception
528: when others then
529: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
530: iex_debug_pub.logmessage ('close dunning before fulfillment exception');
531: END IF;
532: end;
533: END LOOP;
534:

Line 537: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, before create dunning ' );

533: END LOOP;
534:
535: -- IF PG_DEBUG < 10 THEN
536: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
537: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, before create dunning ' );
538: END IF;
539: -- Start Added by gnramasa for bug 5661324 14-Mar-07
540: l_dunning_rec.template_id:= l_template_id;
541: l_dunning_rec.xml_template_id:= l_xdo_template_id;

Line 561: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, before send_fulfillment ' );

557: l_fulfillment_bind_tbl(l_count).key_value := to_char(l_dunning_id);
558: -- End Added by gnramasa for bug 5661324 14-Mar-07
559: -- IF PG_DEBUG < 10 THEN
560: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
561: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, before send_fulfillment ' );
562: END IF;
563: -- call fulfilment function with multiple bind variables.
564: -- ctlee - 6/18 fulfillment printer method available
565: l_curr_dmethod := iex_send_xml_pvt.getCurrDeliveryMethod();

Line 609: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, after send_fulfillment ' );

605: x_contact_party_id => l_contact_party_id); -- bug 3955222
606: end if;
607: -- Start Change by gnramasa for bug 5661324 14-Mar-07
608: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
609: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, after send_fulfillment ' );
610: iex_debug_pub.logmessage ('send_mail: ' || 'request_id =>'|| l_request_id);
611: iex_debug_pub.logmessage ('send_mail: ' || 'return_status =>'|| l_return_status);
612: iex_debug_pub.logmessage ('send_mail: ' || 'msg_count =>' || l_msg_count);
613: iex_debug_pub.logmessage ('send_mail: ' || 'msg_data =>' || l_msg_data);

Line 610: iex_debug_pub.logmessage ('send_mail: ' || 'request_id =>'|| l_request_id);

606: end if;
607: -- Start Change by gnramasa for bug 5661324 14-Mar-07
608: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
609: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, after send_fulfillment ' );
610: iex_debug_pub.logmessage ('send_mail: ' || 'request_id =>'|| l_request_id);
611: iex_debug_pub.logmessage ('send_mail: ' || 'return_status =>'|| l_return_status);
612: iex_debug_pub.logmessage ('send_mail: ' || 'msg_count =>' || l_msg_count);
613: iex_debug_pub.logmessage ('send_mail: ' || 'msg_data =>' || l_msg_data);
614: END IF;

Line 611: iex_debug_pub.logmessage ('send_mail: ' || 'return_status =>'|| l_return_status);

607: -- Start Change by gnramasa for bug 5661324 14-Mar-07
608: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
609: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, after send_fulfillment ' );
610: iex_debug_pub.logmessage ('send_mail: ' || 'request_id =>'|| l_request_id);
611: iex_debug_pub.logmessage ('send_mail: ' || 'return_status =>'|| l_return_status);
612: iex_debug_pub.logmessage ('send_mail: ' || 'msg_count =>' || l_msg_count);
613: iex_debug_pub.logmessage ('send_mail: ' || 'msg_data =>' || l_msg_data);
614: END IF;
615:

Line 612: iex_debug_pub.logmessage ('send_mail: ' || 'msg_count =>' || l_msg_count);

608: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
609: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, after send_fulfillment ' );
610: iex_debug_pub.logmessage ('send_mail: ' || 'request_id =>'|| l_request_id);
611: iex_debug_pub.logmessage ('send_mail: ' || 'return_status =>'|| l_return_status);
612: iex_debug_pub.logmessage ('send_mail: ' || 'msg_count =>' || l_msg_count);
613: iex_debug_pub.logmessage ('send_mail: ' || 'msg_data =>' || l_msg_data);
614: END IF;
615:
616: --- share a request id between xdo and ffm

Line 613: iex_debug_pub.logmessage ('send_mail: ' || 'msg_data =>' || l_msg_data);

609: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, after send_fulfillment ' );
610: iex_debug_pub.logmessage ('send_mail: ' || 'request_id =>'|| l_request_id);
611: iex_debug_pub.logmessage ('send_mail: ' || 'return_status =>'|| l_return_status);
612: iex_debug_pub.logmessage ('send_mail: ' || 'msg_count =>' || l_msg_count);
613: iex_debug_pub.logmessage ('send_mail: ' || 'msg_data =>' || l_msg_data);
614: END IF;
615:
616: --- share a request id between xdo and ffm
617: begin

Line 647: iex_debug_pub.logmessage ('send_mail: ' || my_message);

643: FOR l_index IN 1..l_msg_count LOOP
644: my_message := FND_MSG_PUB.Get(p_msg_index => l_index,
645: p_encoded => 'F');
646: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
647: iex_debug_pub.logmessage ('send_mail: ' || my_message);
648: END IF;
649: if all_message is null then
650: all_message := my_message;
651: else

Line 655: iex_debug_pub.logmessage ('all_message: ' || all_message);

651: else
652: all_message := all_message || '; ' || chr(0) || my_message;
653: end if;
654: END LOOP;
655: iex_debug_pub.logmessage ('all_message: ' || all_message);
656:
657: wf_engine.SetItemAttrText(itemtype => itemtype,
658: itemkey => itemkey,
659: aname => 'ERROR_MESSAGE',

Line 707: iex_debug_pub.logmessage ('update dunning l_status =>' || l_return_status);

703: , x_msg_data => l_msg_data
704: );
705:
706: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
707: iex_debug_pub.logmessage ('update dunning l_status =>' || l_return_status);
708: iex_debug_pub.logmessage ('send_mail: ' || 'result =>' || result);
709: END IF;
710:
711: exception

Line 708: iex_debug_pub.logmessage ('send_mail: ' || 'result =>' || result);

704: );
705:
706: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
707: iex_debug_pub.logmessage ('update dunning l_status =>' || l_return_status);
708: iex_debug_pub.logmessage ('send_mail: ' || 'result =>' || result);
709: END IF;
710:
711: exception
712: when others then

Line 730: iex_debug_pub.logmessage (' BEGIN get_username ********');

726:
727: BEGIN
728: -- IF PG_DEBUG < 10 THEN
729: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
730: iex_debug_pub.logmessage ('**** BEGIN get_username ************');
731: END IF;
732: OPEN c_getname(p_resource_id);
733: FETCH c_getname INTO x_username;
734: CLOSE c_getname;

Line 737: iex_debug_pub.logmessage (' END get_username ********');

733: FETCH c_getname INTO x_username;
734: CLOSE c_getname;
735: -- IF PG_DEBUG < 10 THEN
736: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
737: iex_debug_pub.logmessage ('**** END get_username ************');
738: END IF;
739: END get_username;
740: -- End Change by gnramasa for bug 5661324 14-Mar-07
741: -----populate execution_times---------------------------------

Line 794: iex_debug_pub.logmessage('populate_fulfillment_wait: ' || 'DEL ID = ' ||p_delinquency_id);

790: --End bug#5502077 schekuri 02-May-2007
791: BEGIN
792: -- IF PG_DEBUG < 10 THEN
793: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
794: iex_debug_pub.logmessage('populate_fulfillment_wait: ' || 'DEL ID = ' ||p_delinquency_id);
795: END IF;
796:
797: -- IF PG_DEBUG < 10 THEN
798: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 799: iex_debug_pub.logmessage('populate_fulfillment_wait: ' || 'work item id = ' ||p_work_item_id);

795: END IF;
796:
797: -- IF PG_DEBUG < 10 THEN
798: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
799: iex_debug_pub.logmessage('populate_fulfillment_wait: ' || 'work item id = ' ||p_work_item_id);
800: END IF;
801: begin
802: select a.strategy_level,b.resource_id,a.strategy_id --Added strategy_id for bug#5502077 schekuri 02-May-2007
803: into l_strategy_level,l_resource_id,l_strategy_id

Line 829: iex_debug_pub.logmessage('populate_fulfillment_wait: ' || 'strategy_level = ' ||l_strategy_level);

825: avalue => l_username);
826:
827: -- IF PG_DEBUG < 10 THEN
828: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
829: iex_debug_pub.logmessage('populate_fulfillment_wait: ' || 'strategy_level = ' ||l_strategy_level);
830: END IF;
831:
832: if l_strategy_level = 10 or l_strategy_level = 20 or l_strategy_level = 30 then
833: FOR party_rec in c_get_party(p_work_item_id)

Line 837: iex_debug_pub.logmessage('populate_fulfillment_wait: ' || 'INSIDE THE LOOP ' ||party_rec.party_id);

833: FOR party_rec in c_get_party(p_work_item_id)
834: LOOP
835: -- IF PG_DEBUG < 10 THEN
836: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
837: iex_debug_pub.logmessage('populate_fulfillment_wait: ' || 'INSIDE THE LOOP ' ||party_rec.party_id);
838: iex_debug_pub.logmessage('populate_fulfillment_wait: ' || 'INSIDE THE LOOP ' ||party_rec.cust_account_id);
839: END IF;
840: wf_engine.SetItemAttrNumber(itemtype => itemtype,
841: itemkey => itemkey,

Line 838: iex_debug_pub.logmessage('populate_fulfillment_wait: ' || 'INSIDE THE LOOP ' ||party_rec.cust_account_id);

834: LOOP
835: -- IF PG_DEBUG < 10 THEN
836: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
837: iex_debug_pub.logmessage('populate_fulfillment_wait: ' || 'INSIDE THE LOOP ' ||party_rec.party_id);
838: iex_debug_pub.logmessage('populate_fulfillment_wait: ' || 'INSIDE THE LOOP ' ||party_rec.cust_account_id);
839: END IF;
840: wf_engine.SetItemAttrNumber(itemtype => itemtype,
841: itemkey => itemkey,
842: aname => 'PARTY_ID',

Line 875: iex_debug_pub.logmessage('populate_fulfillment_wait: ' || 'INSIDE THE LOOP ' ||d_rec.party_id);

871: FOR d_rec in c_get_del(p_delinquency_id)
872: LOOP
873: -- IF PG_DEBUG < 10 THEN
874: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
875: iex_debug_pub.logmessage('populate_fulfillment_wait: ' || 'INSIDE THE LOOP ' ||d_rec.party_id);
876: END IF;
877: wf_engine.SetItemAttrNumber(itemtype => itemtype,
878: itemkey => itemkey,
879: aname => 'PARTY_ID',

Line 958: iex_debug_pub.logmessage ('populate_fulfillment_wait: check for skip ' || ' SKIP FLAG = ' ||

954: WHEN OTHERS THEN NULL;
955: END;
956:
957: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
958: iex_debug_pub.logmessage ('populate_fulfillment_wait: check for skip ' || ' SKIP FLAG = ' ||
959: l_SkipFlag);
960: END IF;
961:
962: end if;

Line 981: iex_debug_pub.logmessage ('populate_fulfillment_wait: ' || ' SCHEDULE TIME WAIT = ' ||

977: l_UNIT =>c_rec.schedule_wait);*/
978: --End bug#5502077 schekuri 02-May-2007
979: -- IF PG_DEBUG < 10 THEN
980: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
981: iex_debug_pub.logmessage ('populate_fulfillment_wait: ' || ' SCHEDULE TIME WAIT = ' ||
982: to_char(l_fulfillment_schedule, 'ss:mi:hh24 mm/dd/yyyy'));
983: END IF;
984:
985:

Line 1003: iex_debug_pub.logmessage ('populate_fulfillment_wait: ' || ' EXECUTION TIME WAIT = ' ||

999: --end bug#5502077 schekuri 30-Apr-2007
1000:
1001: -- IF PG_DEBUG < 10 THEN
1002: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1003: iex_debug_pub.logmessage ('populate_fulfillment_wait: ' || ' EXECUTION TIME WAIT = ' ||
1004: to_char(l_fulfillment_wait, 'ss:mi:hh24 mm/dd/yyyy'));
1005: END IF;
1006:
1007:

Line 1051: iex_debug_pub.logmessage ('in strategy_mailer');

1047:
1048:
1049: --IF PG_DEBUG < 10 THEN
1050: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1051: iex_debug_pub.logmessage ('in strategy_mailer');
1052: END IF;
1053: -- Standard Start of API savepoint
1054: -- SAVEPOINT STRATEGY_MAILER; -- Standard call to check for call compatibility.
1055: --IF PG_DEBUG < 10 THEN

Line 1057: iex_debug_pub.logmessage ('in strategy_mailer 1');

1053: -- Standard Start of API savepoint
1054: -- SAVEPOINT STRATEGY_MAILER; -- Standard call to check for call compatibility.
1055: --IF PG_DEBUG < 10 THEN
1056: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1057: iex_debug_pub.logmessage ('in strategy_mailer 1');
1058: END IF;
1059: IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version, l_api_name, G_PKG_NAME) THEN
1060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1061: END IF;

Line 1064: iex_debug_pub.logmessage ('in strategy_mailer 2');

1060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1061: END IF;
1062: --IF PG_DEBUG < 10 THEN
1063: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1064: iex_debug_pub.logmessage ('in strategy_mailer 2');
1065: END IF;
1066: -- Initialize message list IF p_init_msg_list is set to TRUE.
1067: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1068: FND_MSG_PUB.initialize;

Line 1072: iex_debug_pub.logmessage ('in strategy_mailer 3');

1068: FND_MSG_PUB.initialize;
1069: END IF;
1070: --IF PG_DEBUG < 10 THEN
1071: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1072: iex_debug_pub.logmessage ('in strategy_mailer 3');
1073: END IF;
1074:
1075:
1076: -- Initialize API return status to SUCCESS

Line 1083: iex_debug_pub.logmessage ('in strategy_mailer 4');

1079: l_workflowprocess := 'IEXSTFFM';
1080: l_itemkey := p_strategy_mailer_rec.workitem_id;
1081: --IF PG_DEBUG < 10 THEN
1082: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1083: iex_debug_pub.logmessage ('in strategy_mailer 4');
1084: END IF;
1085:
1086: wf_engine.createprocess ( itemtype => l_itemtype,
1087: itemkey => l_itemkey,

Line 1091: iex_debug_pub.logmessage ('in strategy_mailer 5');

1087: itemkey => l_itemkey,
1088: process => l_workflowprocess);
1089: --IF PG_DEBUG < 10 THEN
1090: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1091: iex_debug_pub.logmessage ('in strategy_mailer 5');
1092: END IF;
1093:
1094:
1095:

Line 1159: iex_debug_pub.logmessage ('strategy_mailer: ' || ' before start workflow process');

1155: );
1156:
1157: -- IF PG_DEBUG < 10 THEN
1158: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1159: iex_debug_pub.logmessage ('strategy_mailer: ' || ' before start workflow process');
1160: END IF;
1161:
1162: wf_engine.startprocess(itemtype => l_itemtype, itemkey => l_itemkey);
1163: -- IF PG_DEBUG < 10 THEN

Line 1165: iex_debug_pub.logmessage ('strategy_mailer: ' || ' after start workflow process');

1161:
1162: wf_engine.startprocess(itemtype => l_itemtype, itemkey => l_itemkey);
1163: -- IF PG_DEBUG < 10 THEN
1164: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1165: iex_debug_pub.logmessage ('strategy_mailer: ' || ' after start workflow process');
1166: END IF;
1167: wf_engine.ItemStatus(
1168: itemtype => l_itemType,
1169: itemkey => l_itemKey,

Line 1180: iex_debug_pub.logmessage ('strategy_mailer: ' || ' workflow return status = ' || l_return_status);

1176: x_return_status := 'F';
1177: end if;
1178: -- IF PG_DEBUG < 10 THEN
1179: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1180: iex_debug_pub.logmessage ('strategy_mailer: ' || ' workflow return status = ' || l_return_status);
1181: END IF;
1182:
1183:
1184: EXCEPTION

Line 1187: iex_debug_pub.logmessage('UNEXPECTED ERROR. PUB: ' || l_api_name || ' end');

1183:
1184: EXCEPTION
1185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1186: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1187: iex_debug_pub.logmessage('UNEXPECTED ERROR. PUB: ' || l_api_name || ' end');
1188: iex_debug_pub.logmessage('PUB: ' || l_api_name || ' end');
1189: iex_debug_pub.logmessage('End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1190: END IF;
1191:

Line 1188: iex_debug_pub.logmessage('PUB: ' || l_api_name || ' end');

1184: EXCEPTION
1185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1186: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1187: iex_debug_pub.logmessage('UNEXPECTED ERROR. PUB: ' || l_api_name || ' end');
1188: iex_debug_pub.logmessage('PUB: ' || l_api_name || ' end');
1189: iex_debug_pub.logmessage('End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1190: END IF;
1191:
1192: WHEN OTHERS THEN

Line 1189: iex_debug_pub.logmessage('End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

1185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1186: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1187: iex_debug_pub.logmessage('UNEXPECTED ERROR. PUB: ' || l_api_name || ' end');
1188: iex_debug_pub.logmessage('PUB: ' || l_api_name || ' end');
1189: iex_debug_pub.logmessage('End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1190: END IF;
1191:
1192: WHEN OTHERS THEN
1193: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1194: iex_debug_pub.logmessage('UNHANDLED WORKFLOW EXCEPTION. Strategy ID ' || p_strategy_mailer_rec.strategy_id);

1190: END IF;
1191:
1192: WHEN OTHERS THEN
1193: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1194: iex_debug_pub.logmessage('UNHANDLED WORKFLOW EXCEPTION. Strategy ID ' || p_strategy_mailer_rec.strategy_id);
1195: iex_debug_pub.logmessage('PUB: ' || l_api_name || ' end');
1196: iex_debug_pub.logmessage('End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1197: END IF;
1198:

Line 1195: iex_debug_pub.logmessage('PUB: ' || l_api_name || ' end');

1191:
1192: WHEN OTHERS THEN
1193: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1194: iex_debug_pub.logmessage('UNHANDLED WORKFLOW EXCEPTION. Strategy ID ' || p_strategy_mailer_rec.strategy_id);
1195: iex_debug_pub.logmessage('PUB: ' || l_api_name || ' end');
1196: iex_debug_pub.logmessage('End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1197: END IF;
1198:
1199: end strategy_mailer;

Line 1196: iex_debug_pub.logmessage('End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

1192: WHEN OTHERS THEN
1193: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1194: iex_debug_pub.logmessage('UNHANDLED WORKFLOW EXCEPTION. Strategy ID ' || p_strategy_mailer_rec.strategy_id);
1195: iex_debug_pub.logmessage('PUB: ' || l_api_name || ' end');
1196: iex_debug_pub.logmessage('End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1197: END IF;
1198:
1199: end strategy_mailer;
1200:

Line 1278: iex_debug_pub.logmessage('wf_send_signal: ' || 'error message is ' || l_error);

1274: -- get error message and pass
1275: iex_strategy_wf.Get_Messages(l_msg_count,l_error);
1276: -- IF PG_DEBUG < 10 THEN
1277: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1278: iex_debug_pub.logmessage('wf_send_signal: ' || 'error message is ' || l_error);
1279: END IF;
1280: wf_core.context('IEX_STRATEGY_WORK_PUB','wf_send_signal',itemtype,
1281: itemkey,to_char(actid),funcmode,l_error);
1282: raise;

Line 1379: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, delinquency_id = ' || l_delinquency_id);

1375: itemkey => itemkey,
1376: aname => 'CUSTOMER_SITE_USE_ID');
1377: -- IF PG_DEBUG < 10 THEN
1378: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1379: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, delinquency_id = ' || l_delinquency_id);
1380: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, party_id = ' || l_party_id);
1381: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, cust_account_id = ' || l_cust_account_id);
1382: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, strategy_id = ' || l_strategy_id);
1383: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, work_item_id = ' || l_work_item_id);

Line 1380: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, party_id = ' || l_party_id);

1376: aname => 'CUSTOMER_SITE_USE_ID');
1377: -- IF PG_DEBUG < 10 THEN
1378: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1379: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, delinquency_id = ' || l_delinquency_id);
1380: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, party_id = ' || l_party_id);
1381: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, cust_account_id = ' || l_cust_account_id);
1382: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, strategy_id = ' || l_strategy_id);
1383: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, work_item_id = ' || l_work_item_id);
1384: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, customer_site_use_id = ' || l_customer_site_use_id);

Line 1381: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, cust_account_id = ' || l_cust_account_id);

1377: -- IF PG_DEBUG < 10 THEN
1378: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1379: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, delinquency_id = ' || l_delinquency_id);
1380: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, party_id = ' || l_party_id);
1381: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, cust_account_id = ' || l_cust_account_id);
1382: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, strategy_id = ' || l_strategy_id);
1383: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, work_item_id = ' || l_work_item_id);
1384: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, customer_site_use_id = ' || l_customer_site_use_id);
1385: END IF;

Line 1382: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, strategy_id = ' || l_strategy_id);

1378: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1379: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, delinquency_id = ' || l_delinquency_id);
1380: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, party_id = ' || l_party_id);
1381: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, cust_account_id = ' || l_cust_account_id);
1382: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, strategy_id = ' || l_strategy_id);
1383: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, work_item_id = ' || l_work_item_id);
1384: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, customer_site_use_id = ' || l_customer_site_use_id);
1385: END IF;
1386:

Line 1383: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, work_item_id = ' || l_work_item_id);

1379: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, delinquency_id = ' || l_delinquency_id);
1380: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, party_id = ' || l_party_id);
1381: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, cust_account_id = ' || l_cust_account_id);
1382: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, strategy_id = ' || l_strategy_id);
1383: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, work_item_id = ' || l_work_item_id);
1384: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, customer_site_use_id = ' || l_customer_site_use_id);
1385: END IF;
1386:
1387: -- IF PG_DEBUG < 10 THEN

Line 1384: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, customer_site_use_id = ' || l_customer_site_use_id);

1380: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, party_id = ' || l_party_id);
1381: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, cust_account_id = ' || l_cust_account_id);
1382: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, strategy_id = ' || l_strategy_id);
1383: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, work_item_id = ' || l_work_item_id);
1384: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, customer_site_use_id = ' || l_customer_site_use_id);
1385: END IF;
1386:
1387: -- IF PG_DEBUG < 10 THEN
1388: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1389: iex_debug_pub.logmessage ('check_dunning: ' || 'USER_ID' || l_user_id || ' RESP_ID ' || l_resp_id);

1385: END IF;
1386:
1387: -- IF PG_DEBUG < 10 THEN
1388: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1389: iex_debug_pub.logmessage ('check_dunning: ' || 'USER_ID' || l_user_id || ' RESP_ID ' || l_resp_id);
1390: END IF;
1391: -- IF PG_DEBUG < 10 THEN
1392: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1393: iex_debug_pub.logmessage ('check_dunning: ' || 'RESP_APPL_ID' ||l_resp_appl_id);

Line 1393: iex_debug_pub.logmessage ('check_dunning: ' || 'RESP_APPL_ID' ||l_resp_appl_id);

1389: iex_debug_pub.logmessage ('check_dunning: ' || 'USER_ID' || l_user_id || ' RESP_ID ' || l_resp_id);
1390: END IF;
1391: -- IF PG_DEBUG < 10 THEN
1392: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1393: iex_debug_pub.logmessage ('check_dunning: ' || 'RESP_APPL_ID' ||l_resp_appl_id);
1394: END IF;
1395: --set the session
1396: --FND_GLOBAL.Apps_Initialize(l_user_id, l_resp_id, l_resp_appl_id);
1397:

Line 1405: iex_debug_pub.logmessage ('check_dunning: level 10' || ' check dunning, party_id = ' || l_party_id);

1401: if l_strategy_level = 'CUSTOMER' then
1402: begin
1403: -- IF PG_DEBUG < 10 THEN
1404: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1405: iex_debug_pub.logmessage ('check_dunning: level 10' || ' check dunning, party_id = ' || l_party_id);
1406: END IF;
1407: if l_party_id is not null then
1408: select count(*) into l_count from iex_dunnings where dunning_id in (
1409: select dun.dunning_id from iex_dunnings dun

Line 1416: iex_debug_pub.logmessage ('check_dunning: level 10' || ' check dunning, l_count = ' || l_count);

1412: and dun.status = 'CLOSE'
1413: and trunc(sysdate) = trunc(dun.creation_date) );
1414: -- IF PG_DEBUG < 10 THEN
1415: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1416: iex_debug_pub.logmessage ('check_dunning: level 10' || ' check dunning, l_count = ' || l_count);
1417: END IF;
1418: if l_count > 0 and l_unique_fulfillment = 'Y' then
1419: wf_engine.SetItemAttrText(itemtype => itemtype,
1420: itemkey => itemkey,

Line 1434: iex_debug_pub.logmessage ('check_dunning: level 20' || ' check dunning, cust_account_id = ' || l_cust_account_id);

1430: elsif l_strategy_level = 'ACCOUNT' then
1431: begin
1432: -- IF PG_DEBUG < 10 THEN
1433: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1434: iex_debug_pub.logmessage ('check_dunning: level 20' || ' check dunning, cust_account_id = ' || l_cust_account_id);
1435: END IF;
1436: if l_cust_account_id is not null then
1437: select count(*) into l_count from iex_dunnings where dunning_id in (
1438: select dun.dunning_id from iex_dunnings dun

Line 1445: iex_debug_pub.logmessage ('check_dunning: level 20' || ' check dunning, l_count = ' || l_count);

1441: and dun.status = 'CLOSE'
1442: and trunc(sysdate) = trunc(dun.creation_date) );
1443: -- IF PG_DEBUG < 10 THEN
1444: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1445: iex_debug_pub.logmessage ('check_dunning: level 20' || ' check dunning, l_count = ' || l_count);
1446: END IF;
1447: if l_count > 0 and l_unique_fulfillment = 'Y' then
1448: wf_engine.SetItemAttrText(itemtype => itemtype,
1449: itemkey => itemkey,

Line 1463: iex_debug_pub.logmessage ('check_dunning: level 30' || ' check dunning, customer_site_use_id = ' || l_customer_site_use_id);

1459: elsif l_strategy_level = 'BILL_TO' then
1460: begin
1461: -- IF PG_DEBUG < 10 THEN
1462: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1463: iex_debug_pub.logmessage ('check_dunning: level 30' || ' check dunning, customer_site_use_id = ' || l_customer_site_use_id);
1464: END IF;
1465: if l_customer_site_use_id is not null then
1466: select count(*) into l_count from iex_dunnings where dunning_id in (
1467: select dun.dunning_id from iex_dunnings dun

Line 1474: iex_debug_pub.logmessage ('check_dunning: level 30' || ' check dunning, l_count = ' || l_count);

1470: and dun.status = 'CLOSE'
1471: and trunc(sysdate) = trunc(dun.creation_date) );
1472: -- IF PG_DEBUG < 10 THEN
1473: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1474: iex_debug_pub.logmessage ('check_dunning: level 30' || ' check dunning, l_count = ' || l_count);
1475: END IF;
1476: if l_count > 0 and l_unique_fulfillment = 'Y' then
1477: wf_engine.SetItemAttrText(itemtype => itemtype,
1478: itemkey => itemkey,

Line 1493: iex_debug_pub.logmessage ('check_dunning: 40 ' || ' check dunning, delinquency_id = ' || l_delinquency_id);

1489: begin
1490: select cust_account_id into l_cust_account_id from iex_delinquencies
1491: where delinquency_id = l_delinquency_id;
1492: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1493: iex_debug_pub.logmessage ('check_dunning: 40 ' || ' check dunning, delinquency_id = ' || l_delinquency_id);
1494: END IF;
1495: if l_cust_account_id is not null then
1496: -- begin bug #4230209 03/09/2005 by ctlee, multiple letters were sent in the same day even unique = 'Y'
1497: -- select count(*) into l_count from iex_dunnings where dunning_id in (

Line 1513: iex_debug_pub.logmessage ('check_dunning: 40' || ' check dunning, l_count = ' || l_count);

1509: )
1510: and trunc(sysdate) = trunc(dun.creation_date) );
1511: -- end bug #4230209 03/09/2005 by ctlee, multiple letters were sent in the same day even unique = 'Y'
1512: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1513: iex_debug_pub.logmessage ('check_dunning: 40' || ' check dunning, l_count = ' || l_count);
1514: END IF;
1515: if l_count > 0 and l_unique_fulfillment = 'Y' then
1516: wf_engine.SetItemAttrText(itemtype => itemtype,
1517: itemkey => itemkey,

Line 1682: iex_debug_pub.logmessage('resend_fulfillment: ' || 'DEL ID ' ||l_delinquency_id);

1678: END LOOP;
1679:
1680: -- IF PG_DEBUG < 10 THEN
1681: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1682: iex_debug_pub.logmessage('resend_fulfillment: ' || 'DEL ID ' ||l_delinquency_id);
1683: END IF;
1684:
1685: FOR x_rec in c_get_xdo_template(p_work_item_id)
1686: LOOP

Line 1710: iex_debug_pub.logmessage('resend_fulfillment: ' || 'strategy_level = ' ||l_strategy_level);

1706: l_strategy_level := 40; -- default to delinquency level
1707: end;
1708: -- IF PG_DEBUG < 10 THEN
1709: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1710: iex_debug_pub.logmessage('resend_fulfillment: ' || 'strategy_level = ' ||l_strategy_level);
1711: END IF;
1712:
1713: if l_strategy_level = 10 or l_strategy_level = 20 or l_strategy_level = 30 then
1714: FOR party_rec in c_get_party(p_work_item_id)

Line 1733: iex_debug_pub.logmessage('resend_fulfillment: ' || 'INSIDE THE LOOP ' ||d_rec.party_id);

1729: FOR d_rec in c_get_del(l_delinquency_id)
1730: LOOP
1731: -- IF PG_DEBUG < 10 THEN
1732: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1733: iex_debug_pub.logmessage('resend_fulfillment: ' || 'INSIDE THE LOOP ' ||d_rec.party_id);
1734: END IF;
1735: l_party_id := d_rec.party_id;
1736: l_party_type := d_rec.party_type;
1737: l_party_name := d_rec.party_name;

Line 1760: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, after PARTY_ID ='|| l_PARTY_ID );

1756: if (l_party_id <> 0) then
1757:
1758: -- IF PG_DEBUG < 10 THEN
1759: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1760: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, after PARTY_ID ='|| l_PARTY_ID );
1761: END IF;
1762:
1763: l_count := l_count +1;
1764: l_fulfillment_bind_tbl(l_count).key_name := 'party_id';

Line 1775: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, strategy_id ' );

1771:
1772: if (l_strategy_id <> 0) then
1773: -- IF PG_DEBUG < 10 THEN
1774: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1775: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, strategy_id ' );
1776: END IF;
1777: l_count := l_count +1;
1778: l_fulfillment_bind_tbl(l_count).key_name := 'strategy_id';
1779: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';

Line 1787: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, delinquency_id ' );

1783:
1784: if (l_delinquency_id <> 0) then
1785: -- IF PG_DEBUG < 10 THEN
1786: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1787: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, delinquency_id ' );
1788: END IF;
1789: l_count := l_count +1;
1790: l_fulfillment_bind_tbl(l_count).key_name := 'delinquency_id';
1791: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';

Line 1798: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, cust_account_id ' );

1794:
1795: if (l_cust_account_id <> 0) then
1796: -- IF PG_DEBUG < 10 THEN
1797: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1798: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, cust_account_id ' );
1799: END IF;
1800: l_count := l_count +1;
1801: l_fulfillment_bind_tbl(l_count).key_name := 'cust_account_id';
1802: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';

Line 1815: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, customer_site_use_id ' );

1811:
1812: if (l_customer_site_use_id <> 0) then
1813: -- IF PG_DEBUG < 10 THEN
1814: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1815: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, customer_site_use_id ' );
1816: END IF;
1817: l_count := l_count +1;
1818: l_fulfillment_bind_tbl(l_count).key_name := 'customer_site_use_id';
1819: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';

Line 1828: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, overdue_amount ');

1824: if l_strategy_level = 40 then
1825: if (l_overdue_amount <> 0) then
1826: -- IF PG_DEBUG < 10 THEN
1827: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1828: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, overdue_amount ');
1829: END IF;
1830: l_count := l_count +1;
1831: l_fulfillment_bind_tbl(l_count).key_name := 'overdue_amount';
1832: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';

Line 1840: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, delinquency_status ' );

1836:
1837: if (l_status is not null) then
1838: -- IF PG_DEBUG < 10 THEN
1839: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1840: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, delinquency_status ' );
1841: END IF;
1842: l_count := l_count +1;
1843: l_fulfillment_bind_tbl(l_count).key_name := 'delinquency_status';
1844: l_fulfillment_bind_tbl(l_count).key_type := 'VARCHAR2';

Line 1852: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, aging_bucket_line_id ' );

1848: /*
1849: if (l_aging_bucket_line_id <> 0) then
1850: -- IF PG_DEBUG < 10 THEN
1851: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1852: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, aging_bucket_line_id ' );
1853: END IF;
1854: l_count := l_count +1;
1855: l_fulfillment_bind_tbl(l_count).key_name := 'aging_bucket_line_id';
1856: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';

Line 1865: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, payment_schedule_id ');

1861:
1862: if (l_payment_schedule_id <> 0) then
1863: -- IF PG_DEBUG < 10 THEN
1864: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1865: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, payment_schedule_id ');
1866: END IF;
1867: l_count := l_count +1;
1868: l_fulfillment_bind_tbl(l_count).key_name := 'payment_schedule_id';
1869: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';

Line 1879: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, template_id ' );

1875: l_curr_dmethod := iex_send_xml_pvt.getCurrDeliveryMethod();
1876: if (l_curr_dmethod = 'FFM') then
1877: if (l_fulfil_temp_id <> 0) then
1878: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1879: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, template_id ' );
1880: END IF;
1881: else -- template_id could not be null
1882: x_error_message := 'No fulfillment template id';
1883: return;

Line 1888: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, xdo_template_id ' );

1884: end if;
1885: else
1886: if (l_xdo_template_id <> 0) then
1887: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1888: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, xdo_template_id ' );
1889: END IF;
1890: else -- template_id could not be null
1891: x_error_message := 'No xdo template id';
1892: return;

Line 1900: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, workitem_id ' );

1896:
1897: if (p_work_item_id <> 0) then
1898: -- IF PG_DEBUG < 10 THEN
1899: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1900: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, workitem_id ' );
1901: END IF;
1902: /*
1903: l_count := l_count +1;
1904: l_fulfillment_bind_tbl(l_count).key_name := 'workitem_id';

Line 1915: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, l_count ='|| l_count );

1911: end if;
1912:
1913: -- IF PG_DEBUG < 10 THEN
1914: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1915: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, l_count ='|| l_count );
1916: END IF;
1917:
1918:
1919: -- ctlee - check the hz_customer_profiles.dunning_letter

Line 1928: iex_debug_pub.logmessage ('resend_fulfillment: ' || x_error_message);

1924: , p_delinquency_id => l_delinquency_id ) = 'N'
1925: ) then
1926: x_error_message := 'Customer profile has set the dunning flag to NO';
1927: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1928: iex_debug_pub.logmessage ('resend_fulfillment: ' || x_error_message);
1929: END IF;
1930: return;
1931: end if;
1932:

Line 1941: iex_debug_pub.logmessage ('resend_fulfillment: ' || x_error_message);

1937: , p_site_use_id => l_customer_site_use_id) = 'N'
1938: ) then
1939: x_error_message := 'The dunning amount does not exceed the minimum dunning amount in customer profile';
1940: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1941: iex_debug_pub.logmessage ('resend_fulfillment: ' || x_error_message);
1942: END IF;
1943: return;
1944:
1945: end if;

Line 1974: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' after fulfil method');

1970: end;
1971:
1972: -- IF PG_DEBUG < 10 THEN
1973: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1974: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' after fulfil method');
1975: END IF;
1976:
1977: -- ctlee - 5/20 create dunning record
1978: -- l_unique_fulfillment := nvl(fnd_profile.value('IEX_STRY_UNIQUE_FULFILMENT'), 'N');

Line 2001: iex_debug_pub.logmessage('resend_fulfillment Default StrategyLevel ' || l_DefaultStrategyLevel);

1997: from iex_strategies
1998: where strategy_id = l_strategy_id;
1999:
2000: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2001: iex_debug_pub.logmessage('resend_fulfillment Default StrategyLevel ' || l_DefaultStrategyLevel);
2002: END IF;
2003: EXCEPTION
2004: WHEN OTHERS THEN
2005: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2006: iex_debug_pub.logmessage('Strategy Level Rised Exception ');

2002: END IF;
2003: EXCEPTION
2004: WHEN OTHERS THEN
2005: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2006: iex_debug_pub.logmessage('Strategy Level Rised Exception ');
2007: END IF;
2008: l_DefaultStrategyLevel := 'DELINQUENCY';
2009: END;
2010: IF l_DefaultStrategyLevel = 'CUSTOMER' THEN

Line 2056: iex_debug_pub.logmessage ('close dunning before fulfillment exception');

2052: );
2053: exception
2054: when others then
2055: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2056: iex_debug_pub.logmessage ('close dunning before fulfillment exception');
2057: END IF;
2058: end;
2059: END LOOP;
2060:

Line 2064: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, before create dunning ' );

2060:
2061: -- ctlee - 6/18 fulfillment printer method available
2062: -- IF PG_DEBUG < 10 THEN
2063: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2064: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, before create dunning ' );
2065: END IF;
2066: IEX_DUNNING_PVT.CREATE_DUNNING(
2067: p_api_version => 1.0
2068: , p_init_msg_list => FND_API.G_FALSE

Line 2079: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, before send_fulfillment ' );

2075: -- end if;
2076:
2077: --IF PG_DEBUG < 10 THEN
2078: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2079: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, before send_fulfillment ' );
2080: END IF;
2081:
2082:
2083: -- call fulfilment function with multiple bind variables.

Line 2128: -- IEX_DEBUG_PUB.setDebugFileDir(P_FILEDIR => '/sqlcom/log', P_FILENAME =>'james.IEX');

2124: end if;
2125: --- share a request id between xdo and ffm
2126:
2127:
2128: -- IEX_DEBUG_PUB.setDebugFileDir(P_FILEDIR => '/sqlcom/log', P_FILENAME =>'james.IEX');
2129: --IEX_DEBUG_PUB.setDebugFileDir(P_FILEDIR => '/sqlcom/log');
2130:
2131:
2132: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2129: --IEX_DEBUG_PUB.setDebugFileDir(P_FILEDIR => '/sqlcom/log');

2125: --- share a request id between xdo and ffm
2126:
2127:
2128: -- IEX_DEBUG_PUB.setDebugFileDir(P_FILEDIR => '/sqlcom/log', P_FILENAME =>'james.IEX');
2129: --IEX_DEBUG_PUB.setDebugFileDir(P_FILEDIR => '/sqlcom/log');
2130:
2131:
2132: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2133: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, after send_fulfillment ' );

Line 2133: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, after send_fulfillment ' );

2129: --IEX_DEBUG_PUB.setDebugFileDir(P_FILEDIR => '/sqlcom/log');
2130:
2131:
2132: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2133: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, after send_fulfillment ' );
2134: END IF;
2135:
2136: -- return to workflow
2137: if (l_request_id is null OR l_return_status <> 'S') then

Line 2139: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'request_id =>'|| l_request_id);

2135:
2136: -- return to workflow
2137: if (l_request_id is null OR l_return_status <> 'S') then
2138: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2139: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'request_id =>'|| l_request_id);
2140: END IF;
2141: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2142: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'return_status =>'|| l_return_status);
2143: END IF;

Line 2142: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'return_status =>'|| l_return_status);

2138: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2139: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'request_id =>'|| l_request_id);
2140: END IF;
2141: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2142: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'return_status =>'|| l_return_status);
2143: END IF;
2144: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2145: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'msg_count =>' || l_msg_count);
2146: END IF;

Line 2145: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'msg_count =>' || l_msg_count);

2141: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2142: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'return_status =>'|| l_return_status);
2143: END IF;
2144: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2145: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'msg_count =>' || l_msg_count);
2146: END IF;
2147:
2148: -- IF PG_DEBUG < 10 THEN
2149: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2150: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'msg_data =>');

2146: END IF;
2147:
2148: -- IF PG_DEBUG < 10 THEN
2149: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2150: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'msg_data =>');
2151: END IF;
2152: FOR l_index IN 1..l_msg_count LOOP
2153: my_message := FND_MSG_PUB.Get(p_msg_index => l_index,
2154: p_encoded => 'F');

Line 2157: iex_debug_pub.logmessage ('resend_fulfillment: ' || my_message);

2153: my_message := FND_MSG_PUB.Get(p_msg_index => l_index,
2154: p_encoded => 'F');
2155: -- IF PG_DEBUG < 10 THEN
2156: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2157: iex_debug_pub.logmessage ('resend_fulfillment: ' || my_message);
2158: END IF;
2159: END LOOP;
2160: x_error_message := my_message;
2161: else

Line 2164: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'request_id =>'|| l_request_id);

2160: x_error_message := my_message;
2161: else
2162: -- IF PG_DEBUG < 10 THEN
2163: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2164: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'request_id =>'|| l_request_id);
2165: END IF;
2166: -- IF PG_DEBUG < 10 THEN
2167: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2168: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'return_status =>'|| l_return_status);

Line 2168: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'return_status =>'|| l_return_status);

2164: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'request_id =>'|| l_request_id);
2165: END IF;
2166: -- IF PG_DEBUG < 10 THEN
2167: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2168: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'return_status =>'|| l_return_status);
2169: END IF;
2170: -- IF PG_DEBUG < 10 THEN
2171: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2172: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'msg_count =>' || l_msg_count);

Line 2172: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'msg_count =>' || l_msg_count);

2168: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'return_status =>'|| l_return_status);
2169: END IF;
2170: -- IF PG_DEBUG < 10 THEN
2171: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2172: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'msg_count =>' || l_msg_count);
2173: END IF;
2174:
2175: x_status := 'S';
2176: x_request_id := l_request_id;

Line 2222: iex_debug_pub.logmessage (' START wait_on_hold_signal ********');

2218: l_value VARCHAR2(300);
2219:
2220: BEGIN
2221: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2222: iex_debug_pub.logmessage ('**** START wait_on_hold_signal ************');
2223: END IF;
2224: if funcmode <> wf_engine.eng_run then
2225: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2226: iex_debug_pub.logmessage('SECOND TIME FUNCMODE' ||funcmode);

Line 2226: iex_debug_pub.logmessage('SECOND TIME FUNCMODE' ||funcmode);

2222: iex_debug_pub.logmessage ('**** START wait_on_hold_signal ************');
2223: END IF;
2224: if funcmode <> wf_engine.eng_run then
2225: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2226: iex_debug_pub.logmessage('SECOND TIME FUNCMODE' ||funcmode);
2227: END IF;
2228: result := wf_engine.eng_null;
2229: return;
2230: end if;

Line 2235: iex_debug_pub.logmessage('FUNCMODE' ||funcmode);

2231:
2232:
2233:
2234: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2235: iex_debug_pub.logmessage('FUNCMODE' ||funcmode);
2236: END IF;
2237: /* l_value :=wf_engine.GetActivityLabel(actid);
2238: wf_engine.SetItemAttrText(itemtype => itemtype,
2239: itemkey => itemkey,

Line 2243: iex_debug_pub.logMessage('ACTIVITYNAME' ||l_value);

2239: itemkey => itemkey,
2240: aname => 'ACTIVITY_NAME',
2241: avalue => l_value);
2242: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2243: iex_debug_pub.logMessage('ACTIVITYNAME' ||l_value);
2244: END IF;*/
2245:
2246:
2247: result := wf_engine.eng_notified||':'||wf_engine.eng_null||

Line 2250: iex_debug_pub.logmessage (' END wait_on_hold_signal ********');

2246:
2247: result := wf_engine.eng_notified||':'||wf_engine.eng_null||
2248: ':'||wf_engine.eng_null;
2249: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2250: iex_debug_pub.logmessage ('**** END wait_on_hold_signal ************');
2251: END IF;
2252: exception
2253: when others then
2254: result := wf_engine.eng_completed ||':'||wf_no;