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 137: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, funcmode = ' || funcmode);

133:
134:
135: -- IF PG_DEBUG < 10 THEN
136: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
137: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, funcmode = ' || funcmode);
138: END IF;
139:
140: if funcmode <> 'RUN' then
141: result := wf_engine.eng_null;

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

143: end if;
144:
145: -- IF PG_DEBUG < 10 THEN
146: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
147: iex_debug_pub.logmessage ('send_mail: ' || 'itemtype = ' || itemtype);
148: END IF;
149: -- IF PG_DEBUG < 10 THEN
150: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
151: iex_debug_pub.logmessage ('send_mail: ' || 'itemtkey = ' || itemkey);

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

147: iex_debug_pub.logmessage ('send_mail: ' || 'itemtype = ' || itemtype);
148: END IF;
149: -- IF PG_DEBUG < 10 THEN
150: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
151: iex_debug_pub.logmessage ('send_mail: ' || 'itemtkey = ' || itemkey);
152: END IF;
153: l_party_id := wf_engine.GetItemAttrNumber(
154: itemtype => itemtype,
155: itemkey => itemkey,

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

158: if (l_party_id <> 0) then
159:
160: -- IF PG_DEBUG < 10 THEN
161: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
162: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, after PARTY_ID ='|| l_PARTY_ID );
163: END IF;
164:
165: l_count := l_count +1;
166: l_fulfillment_bind_tbl(l_count).key_name := 'party_id';

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

176: aname => 'STRATEGY_ID');
177: if (l_strategy_id <> 0) then
178: -- IF PG_DEBUG < 10 THEN
179: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
180: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, strategy_id ' );
181: END IF;
182: l_count := l_count +1;
183: l_fulfillment_bind_tbl(l_count).key_name := 'strategy_id';
184: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';

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

191: aname => 'DELINQUENCY_ID');
192: if (l_delinquency_id <> 0) then
193: -- IF PG_DEBUG < 10 THEN
194: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
195: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, delinquency_id ' );
196: END IF;
197: l_count := l_count +1;
198: l_fulfillment_bind_tbl(l_count).key_name := 'delinquency_id';
199: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';

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

206: aname => 'CUST_ACCOUNT_ID');
207: if (l_cust_account_id <> 0) then
208: -- IF PG_DEBUG < 10 THEN
209: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
210: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, cust_account_id ' );
211: END IF;
212: l_count := l_count +1;
213: l_fulfillment_bind_tbl(l_count).key_name := 'cust_account_id';
214: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';

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

229: aname => 'OVERDUE_AMOUNT');
230: if (l_overdue_amount <> 0) then
231: -- IF PG_DEBUG < 10 THEN
232: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
233: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, overdue_amount ');
234: END IF;
235: l_count := l_count +1;
236: l_fulfillment_bind_tbl(l_count).key_name := 'overdue_amount';
237: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';

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

246: aname => 'DELINQUENCY_STATUS');
247: if (l_delinquency_status is not null) then
248: -- IF PG_DEBUG < 10 THEN
249: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
250: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, delinquency_status ' );
251: END IF;
252: l_count := l_count +1;
253: l_fulfillment_bind_tbl(l_count).key_name := 'delinquency_status';
254: l_fulfillment_bind_tbl(l_count).key_type := 'VARCHAR2';

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

265: /* not pass the l_aging_bucket_line_id - pass customer_site_use_id instead
266: if (l_aging_bucket_line_id <> 0) then
267: --IF PG_DEBUG < 10 THEN
268: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
269: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, aging_bucket_line_id ' );
270: END IF;
271: l_count := l_count +1;
272: l_fulfillment_bind_tbl(l_count).key_name := 'aging_bucket_line_id';
273: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';

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

281: aname => 'CUSTOMER_SITE_USE_ID');
282: if (l_customer_site_use_id <> 0) then
283: -- IF PG_DEBUG < 10 THEN
284: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
285: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, customer_site_use_id ' );
286: END IF;
287: l_count := l_count +1;
288: l_fulfillment_bind_tbl(l_count).key_name := 'customer_site_use_id';
289: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';

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

299:
300: if (v_org_id is not null) then
301: -- IF PG_DEBUG < 10 THEN
302: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
303: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, org_id ' );
304: END IF;
305: --Begin Bug 10401991 20-Jan-2011 barathsr
306: l_count := l_count +1;
307: l_fulfillment_bind_tbl(l_count).key_name := 'org_id';

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

310: ELSE
311:
312: -- bug 12363991 PNAVEENK
313: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
314: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, v_org_id is null ' );
315: END IF;
316: IF l_delinquency_id > 0 THEN
317: select org_id
318: into v_org_id

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

349: END IF;
350: END IF;
351: END IF;
352: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
353: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, v_org_id '||v_org_id );
354: END IF;
355: -- bug 12363991
356: l_count := l_count +1;
357: l_fulfillment_bind_tbl(l_count).key_name := 'org_id';

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

365: aname => 'PAYMENT_SCHEDULE_ID');
366: if (l_payment_schedule_id <> 0) then
367: -- IF PG_DEBUG < 10 THEN
368: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
369: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, payment_schedule_id ');
370: END IF;
371: l_count := l_count +1;
372: l_fulfillment_bind_tbl(l_count).key_name := 'payment_schedule_id';
373: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';

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

383: itemkey => itemkey,
384: aname => 'XDO_TEMPLATE_ID');
385: if (l_template_id <> 0) then
386: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
387: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, template_id ' );
388: END IF;
389: end if;
390:
391: if (l_xdo_template_id <> 0) then

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

389: end if;
390:
391: if (l_xdo_template_id <> 0) then
392: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
393: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, xdo_template_id ' );
394: END IF;
395: end if;
396: /*
397: l_count := l_count +1;

Line 417: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, workitem_id => '||l_workitem_id );

413: aname => 'WORKITEM_ID');
414: if (l_workitem_id <> 0) then
415: -- IF PG_DEBUG < 10 THEN
416: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
417: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, workitem_id => '||l_workitem_id );
418: END IF;
419: /*
420: l_count := l_count +1;
421: l_fulfillment_bind_tbl(l_count).key_name := 'workitem_id';

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

428: end if;
429:
430: -- IF PG_DEBUG < 10 THEN
431: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
432: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, l_count ='|| l_count );
433: END IF;
434:
435: -- ctlee - check the hz_customer_profiles.dunning_letter
436: if ( iex_utilities.DunningProfileCheck (

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

458: WHEN OTHERS THEN
459: NULL;
460: END;
461: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
462: iex_debug_pub.logmessage ('send_mail: ' || ' check fail dunning profile check ' );
463: END IF;
464: return;
465: end if;
466:

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

504: WHEN OTHERS THEN
505: NULL;
506: END;
507: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
508: iex_debug_pub.logmessage ('send_mail: ' || ' check fail dunning min amount check ' );
509: END IF;
510: return;
511: elsif l_dun_yn = 'E' then -- start for bug 15933013
512: result := 'COMPLETE:' || 'Y';

Line 531: iex_debug_pub.logmessage ('send_mail: ' || 'When strategy level is Account,value of profile "IEX: Minimum Dunning Amount Profile Check" can''t be "Bill To" or "Bill To and Account".' );

527: WHEN OTHERS THEN
528: NULL;
529: END;
530: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
531: iex_debug_pub.logmessage ('send_mail: ' || 'When strategy level is Account,value of profile "IEX: Minimum Dunning Amount Profile Check" can''t be "Bill To" or "Bill To and Account".' );
532: END IF;
533: return; --end for bug 15933013
534: end if;
535:

Line 537: iex_debug_pub.logmessage ('send_mail: ' || ' - l_turnoff_coll_on_bankru: ' || l_turnoff_coll_on_bankru);

533: return; --end for bug 15933013
534: end if;
535:
536: l_turnoff_coll_on_bankru := nvl(fnd_profile.value('IEX_TURNOFF_COLLECT_BANKRUPTCY'),'N');
537: iex_debug_pub.logmessage ('send_mail: ' || ' - l_turnoff_coll_on_bankru: ' || l_turnoff_coll_on_bankru);
538:
539:
540: if l_turnoff_coll_on_bankru = 'Y' then
541: open c_no_of_bankruptcy (l_party_id);

Line 545: iex_debug_pub.logmessage ('send_mail: ' || ' - l_no_of_bankruptcy: ' || l_no_of_bankruptcy);

541: open c_no_of_bankruptcy (l_party_id);
542: fetch c_no_of_bankruptcy into l_no_of_bankruptcy;
543: close c_no_of_bankruptcy;
544: end if;
545: iex_debug_pub.logmessage ('send_mail: ' || ' - l_no_of_bankruptcy: ' || l_no_of_bankruptcy);
546: if (l_turnoff_coll_on_bankru = 'Y' and l_no_of_bankruptcy >0 ) then
547: result := 'COMPLETE:' || 'Y';
548: begin
549: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 566: iex_debug_pub.logmessage ('send_mail: ' || ' bankruptcy exist for this customer, so will skip send dunning ' );

562: WHEN OTHERS THEN
563: NULL;
564: END;
565: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
566: iex_debug_pub.logmessage ('send_mail: ' || ' bankruptcy exist for this customer, so will skip send dunning ' );
567: END IF;
568: return;
569:
570: end if;

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

606: l_dunning_rec.org_id := v_org_id;
607: -- end
608: -- IF PG_DEBUG < 10 THEN
609: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
610: iex_debug_pub.logmessage ('send_mail: ' || ' after fulfil method');
611: END IF;
612: iex_debug_pub.logmessage(' Org_id value ' || l_dunning_rec.org_id);
613: -- ctlee - 5/20 create dunning record; 11/21/2002 remove checking profile error when update a non-existing record
614: -- l_unique_fulfillment := nvl(fnd_profile.value('IEX_STRY_UNIQUE_FULFILMENT'), 'N');

Line 612: iex_debug_pub.logmessage(' Org_id value ' || l_dunning_rec.org_id);

608: -- IF PG_DEBUG < 10 THEN
609: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
610: iex_debug_pub.logmessage ('send_mail: ' || ' after fulfil method');
611: END IF;
612: iex_debug_pub.logmessage(' Org_id value ' || l_dunning_rec.org_id);
613: -- ctlee - 5/20 create dunning record; 11/21/2002 remove checking profile error when update a non-existing record
614: -- l_unique_fulfillment := nvl(fnd_profile.value('IEX_STRY_UNIQUE_FULFILMENT'), 'N');
615: -- if (l_unique_fulfillment = 'Y') then
616: l_dunning_rec.delinquency_id := l_delinquency_id;

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

633: from iex_strategies
634: where strategy_id = l_strategy_id;
635:
636: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
637: iex_debug_pub.logmessage('Default StrategyLevel ' || l_DefaultStrategyLevel);
638: END IF;
639: EXCEPTION
640: WHEN OTHERS THEN
641: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

638: END IF;
639: EXCEPTION
640: WHEN OTHERS THEN
641: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
642: iex_debug_pub.logmessage('Strategy Level Rised Exception ');
643: END IF;
644: l_DefaultStrategyLevel := 'DELINQUENCY';
645: END;
646: IF l_DefaultStrategyLevel = 'CUSTOMER' THEN

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

702: );
703: exception
704: when others then
705: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
706: iex_debug_pub.logmessage ('close dunning before fulfillment exception');
707: END IF;
708: end;
709: END LOOP;
710:

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

709: END LOOP;
710:
711: -- IF PG_DEBUG < 10 THEN
712: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
713: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, before create dunning ' );
714: END IF;
715: -- Start Added by gnramasa for bug 5661324 14-Mar-07
716: l_dunning_rec.template_id:= l_template_id;
717: l_dunning_rec.xml_template_id:= l_xdo_template_id;

Line 719: iex_debug_pub.logmessage(' Org_id value ' || l_dunning_rec.org_id);

715: -- Start Added by gnramasa for bug 5661324 14-Mar-07
716: l_dunning_rec.template_id:= l_template_id;
717: l_dunning_rec.xml_template_id:= l_xdo_template_id;
718:
719: iex_debug_pub.logmessage(' Org_id value ' || l_dunning_rec.org_id);
720: iex_debug_pub.logmessage ('send_mail: ' || ' WorkItem Id = '||l_workitem_id );
721: -- End Added by gnramasa for bug 5661324 14-Mar-07
722: IEX_DUNNING_PVT.CREATE_DUNNING(
723: p_api_version => 1.0

Line 720: iex_debug_pub.logmessage ('send_mail: ' || ' WorkItem Id = '||l_workitem_id );

716: l_dunning_rec.template_id:= l_template_id;
717: l_dunning_rec.xml_template_id:= l_xdo_template_id;
718:
719: iex_debug_pub.logmessage(' Org_id value ' || l_dunning_rec.org_id);
720: iex_debug_pub.logmessage ('send_mail: ' || ' WorkItem Id = '||l_workitem_id );
721: -- End Added by gnramasa for bug 5661324 14-Mar-07
722: IEX_DUNNING_PVT.CREATE_DUNNING(
723: p_api_version => 1.0
724: , p_init_msg_list => FND_API.G_FALSE

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

755: l_fulfillment_bind_tbl(l_count).key_value := to_char(l_dunning_id);
756: -- End Added by gnramasa for bug 5661324 14-Mar-07
757: -- IF PG_DEBUG < 10 THEN
758: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
759: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, before send_fulfillment ' );
760: END IF;
761: -- call fulfilment function with multiple bind variables.
762: -- ctlee - 6/18 fulfillment printer method available
763: l_curr_dmethod := iex_send_xml_pvt.getCurrDeliveryMethod();

Line 784: iex_debug_pub.logmessage ('send_mail: cancelling all xml requests for this workitem: ' || SQLERRM );

780: else
781: --Added for bug#8490070 by SNUTHALA on 29-May-2009
782: BEGIN
783: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
784: iex_debug_pub.logmessage ('send_mail: cancelling all xml requests for this workitem: ' || SQLERRM );
785: END IF;
786: update iex_xml_request_histories
787: set status='CANCELLED'
788: where object_type='IEX_STRATEGY'

Line 797: iex_debug_pub.logmessage ('send_mail: ' || ' no active previous xml request exists for this workitem ' );

793: and object_id=l_workitem_id);
794: EXCEPTION
795: WHEN NO_DATA_FOUND THEN
796: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
797: iex_debug_pub.logmessage ('send_mail: ' || ' no active previous xml request exists for this workitem ' );
798: END IF;
799: WHEN OTHERS THEN
800: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
801: iex_debug_pub.logmessage ('send_mail: error while checking for previous active xml requests for this workitem: ' || SQLERRM );

Line 801: iex_debug_pub.logmessage ('send_mail: error while checking for previous active xml requests for this workitem: ' || SQLERRM );

797: iex_debug_pub.logmessage ('send_mail: ' || ' no active previous xml request exists for this workitem ' );
798: END IF;
799: WHEN OTHERS THEN
800: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
801: iex_debug_pub.logmessage ('send_mail: error while checking for previous active xml requests for this workitem: ' || SQLERRM );
802: END IF;
803: END;
804: iex_dunning_pvt.send_xml(
805: p_api_version => 1.0,

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

827: x_contact_party_id => l_contact_party_id); -- bug 3955222
828: end if;
829: -- Start Change by gnramasa for bug 5661324 14-Mar-07
830: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
831: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, after send_fulfillment ' );
832: iex_debug_pub.logmessage ('send_mail: ' || 'request_id =>'|| l_request_id);
833: iex_debug_pub.logmessage ('send_mail: ' || 'return_status =>'|| l_return_status);
834: iex_debug_pub.logmessage ('send_mail: ' || 'msg_count =>' || l_msg_count);
835: iex_debug_pub.logmessage ('send_mail: ' || 'msg_data =>' || l_msg_data);

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

828: end if;
829: -- Start Change by gnramasa for bug 5661324 14-Mar-07
830: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
831: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, after send_fulfillment ' );
832: iex_debug_pub.logmessage ('send_mail: ' || 'request_id =>'|| l_request_id);
833: iex_debug_pub.logmessage ('send_mail: ' || 'return_status =>'|| l_return_status);
834: iex_debug_pub.logmessage ('send_mail: ' || 'msg_count =>' || l_msg_count);
835: iex_debug_pub.logmessage ('send_mail: ' || 'msg_data =>' || l_msg_data);
836: END IF;

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

829: -- Start Change by gnramasa for bug 5661324 14-Mar-07
830: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
831: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, after send_fulfillment ' );
832: iex_debug_pub.logmessage ('send_mail: ' || 'request_id =>'|| l_request_id);
833: iex_debug_pub.logmessage ('send_mail: ' || 'return_status =>'|| l_return_status);
834: iex_debug_pub.logmessage ('send_mail: ' || 'msg_count =>' || l_msg_count);
835: iex_debug_pub.logmessage ('send_mail: ' || 'msg_data =>' || l_msg_data);
836: END IF;
837:

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

830: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
831: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, after send_fulfillment ' );
832: iex_debug_pub.logmessage ('send_mail: ' || 'request_id =>'|| l_request_id);
833: iex_debug_pub.logmessage ('send_mail: ' || 'return_status =>'|| l_return_status);
834: iex_debug_pub.logmessage ('send_mail: ' || 'msg_count =>' || l_msg_count);
835: iex_debug_pub.logmessage ('send_mail: ' || 'msg_data =>' || l_msg_data);
836: END IF;
837:
838: --- share a request id between xdo and ffm

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

831: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, after send_fulfillment ' );
832: iex_debug_pub.logmessage ('send_mail: ' || 'request_id =>'|| l_request_id);
833: iex_debug_pub.logmessage ('send_mail: ' || 'return_status =>'|| l_return_status);
834: iex_debug_pub.logmessage ('send_mail: ' || 'msg_count =>' || l_msg_count);
835: iex_debug_pub.logmessage ('send_mail: ' || 'msg_data =>' || l_msg_data);
836: END IF;
837:
838: --- share a request id between xdo and ffm
839: begin

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

865: FOR l_index IN 1..l_msg_count LOOP
866: my_message := FND_MSG_PUB.Get(p_msg_index => l_index,
867: p_encoded => 'F');
868: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
869: iex_debug_pub.logmessage ('send_mail: ' || my_message);
870: END IF;
871: if all_message is null then
872: all_message := my_message;
873: else

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

873: else
874: all_message := all_message || '; ' || chr(0) || my_message;
875: end if;
876: END LOOP;
877: iex_debug_pub.logmessage ('all_message: ' || all_message);
878:
879: wf_engine.SetItemAttrText(itemtype => itemtype,
880: itemkey => itemkey,
881: aname => 'ERROR_MESSAGE',

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

930: , x_msg_data => l_msg_data
931: );
932:
933: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
934: iex_debug_pub.logmessage ('update dunning l_status =>' || l_return_status);
935: iex_debug_pub.logmessage ('send_mail: ' || 'result =>' || result);
936: END IF;
937:
938: exception

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

931: );
932:
933: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
934: iex_debug_pub.logmessage ('update dunning l_status =>' || l_return_status);
935: iex_debug_pub.logmessage ('send_mail: ' || 'result =>' || result);
936: END IF;
937:
938: exception
939: when others then

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

953:
954: BEGIN
955: -- IF PG_DEBUG < 10 THEN
956: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
957: iex_debug_pub.logmessage ('**** BEGIN get_username ************');
958: END IF;
959: OPEN c_getname(p_resource_id);
960: FETCH c_getname INTO x_username;
961: CLOSE c_getname;

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

960: FETCH c_getname INTO x_username;
961: CLOSE c_getname;
962: -- IF PG_DEBUG < 10 THEN
963: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
964: iex_debug_pub.logmessage ('**** END get_username ************');
965: END IF;
966: END get_username;
967: -- End Change by gnramasa for bug 5661324 14-Mar-07
968: -----populate execution_times---------------------------------

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

1017: --End bug#5502077 schekuri 02-May-2007
1018: BEGIN
1019: -- IF PG_DEBUG < 10 THEN
1020: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1021: iex_debug_pub.logmessage('populate_fulfillment_wait: ' || 'DEL ID = ' ||p_delinquency_id);
1022: END IF;
1023:
1024: -- IF PG_DEBUG < 10 THEN
1025: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

1022: END IF;
1023:
1024: -- IF PG_DEBUG < 10 THEN
1025: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1026: iex_debug_pub.logmessage('populate_fulfillment_wait: ' || 'work item id = ' ||p_work_item_id);
1027: END IF;
1028: begin
1029: select a.strategy_level,b.resource_id,a.strategy_id --Added strategy_id for bug#5502077 schekuri 02-May-2007
1030: into l_strategy_level,l_resource_id,l_strategy_id

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

1052: avalue => l_username);
1053:
1054: -- IF PG_DEBUG < 10 THEN
1055: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1056: iex_debug_pub.logmessage('populate_fulfillment_wait: ' || 'strategy_level = ' ||l_strategy_level);
1057: END IF;
1058:
1059: if l_strategy_level = 10 or l_strategy_level = 20 or l_strategy_level = 30 then
1060: FOR party_rec in c_get_party(p_work_item_id)

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

1060: FOR party_rec in c_get_party(p_work_item_id)
1061: LOOP
1062: -- IF PG_DEBUG < 10 THEN
1063: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1064: iex_debug_pub.logmessage('populate_fulfillment_wait: ' || 'INSIDE THE LOOP ' ||party_rec.party_id);
1065: iex_debug_pub.logmessage('populate_fulfillment_wait: ' || 'INSIDE THE LOOP ' ||party_rec.cust_account_id);
1066: END IF;
1067: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1068: itemkey => itemkey,

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

1061: LOOP
1062: -- IF PG_DEBUG < 10 THEN
1063: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1064: iex_debug_pub.logmessage('populate_fulfillment_wait: ' || 'INSIDE THE LOOP ' ||party_rec.party_id);
1065: iex_debug_pub.logmessage('populate_fulfillment_wait: ' || 'INSIDE THE LOOP ' ||party_rec.cust_account_id);
1066: END IF;
1067: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1068: itemkey => itemkey,
1069: aname => 'PARTY_ID',

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

1098: FOR d_rec in c_get_del(p_delinquency_id)
1099: LOOP
1100: -- IF PG_DEBUG < 10 THEN
1101: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1102: iex_debug_pub.logmessage('populate_fulfillment_wait: ' || 'INSIDE THE LOOP ' ||d_rec.party_id);
1103: END IF;
1104: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1105: itemkey => itemkey,
1106: aname => 'PARTY_ID',

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

1181: WHEN OTHERS THEN NULL;
1182: END;
1183:
1184: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1185: iex_debug_pub.logmessage ('populate_fulfillment_wait: check for skip ' || ' SKIP FLAG = ' ||
1186: l_SkipFlag);
1187: END IF;
1188:
1189: end if;

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

1204: l_UNIT =>c_rec.schedule_wait);*/
1205: --End bug#5502077 schekuri 02-May-2007
1206: -- IF PG_DEBUG < 10 THEN
1207: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1208: iex_debug_pub.logmessage ('populate_fulfillment_wait: ' || ' SCHEDULE TIME WAIT = ' ||
1209: to_char(l_fulfillment_schedule, 'ss:mi:hh24 mm/dd/yyyy'));
1210: END IF;
1211:
1212:

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

1226: --end bug#5502077 schekuri 30-Apr-2007
1227:
1228: -- IF PG_DEBUG < 10 THEN
1229: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1230: iex_debug_pub.logmessage ('populate_fulfillment_wait: ' || ' EXECUTION TIME WAIT = ' ||
1231: to_char(l_fulfillment_wait, 'ss:mi:hh24 mm/dd/yyyy'));
1232: END IF;
1233:
1234:

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

1283:
1284:
1285: --IF PG_DEBUG < 10 THEN
1286: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1287: iex_debug_pub.logmessage ('in strategy_mailer');
1288: END IF;
1289: -- Standard Start of API savepoint
1290: -- SAVEPOINT STRATEGY_MAILER; -- Standard call to check for call compatibility.
1291: --IF PG_DEBUG < 10 THEN

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

1289: -- Standard Start of API savepoint
1290: -- SAVEPOINT STRATEGY_MAILER; -- Standard call to check for call compatibility.
1291: --IF PG_DEBUG < 10 THEN
1292: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1293: iex_debug_pub.logmessage ('in strategy_mailer 1');
1294: END IF;
1295: IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version, l_api_name, G_PKG_NAME) THEN
1296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1297: END IF;

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

1296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1297: END IF;
1298: --IF PG_DEBUG < 10 THEN
1299: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1300: iex_debug_pub.logmessage ('in strategy_mailer 2');
1301: END IF;
1302: -- Initialize message list IF p_init_msg_list is set to TRUE.
1303: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1304: FND_MSG_PUB.initialize;

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

1304: FND_MSG_PUB.initialize;
1305: END IF;
1306: --IF PG_DEBUG < 10 THEN
1307: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1308: iex_debug_pub.logmessage ('in strategy_mailer 3');
1309: END IF;
1310:
1311:
1312: -- Initialize API return status to SUCCESS

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

1315: l_workflowprocess := 'IEXSTFFM';
1316: l_itemkey := p_strategy_mailer_rec.workitem_id;
1317: --IF PG_DEBUG < 10 THEN
1318: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1319: iex_debug_pub.logmessage ('in strategy_mailer 4');
1320: END IF;
1321:
1322: wf_engine.createprocess ( itemtype => l_itemtype,
1323: itemkey => l_itemkey,

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

1323: itemkey => l_itemkey,
1324: process => l_workflowprocess);
1325: --IF PG_DEBUG < 10 THEN
1326: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1327: iex_debug_pub.logmessage ('in strategy_mailer 5');
1328: END IF;
1329:
1330: -- start for bug 9668367
1331: open c_party_id(p_strategy_mailer_rec.strategy_id);

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

1403: );
1404:
1405: -- IF PG_DEBUG < 10 THEN
1406: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1407: iex_debug_pub.logmessage ('strategy_mailer: ' || ' before start workflow process');
1408: END IF;
1409:
1410: wf_engine.startprocess(itemtype => l_itemtype, itemkey => l_itemkey);
1411: -- IF PG_DEBUG < 10 THEN

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

1409:
1410: wf_engine.startprocess(itemtype => l_itemtype, itemkey => l_itemkey);
1411: -- IF PG_DEBUG < 10 THEN
1412: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1413: iex_debug_pub.logmessage ('strategy_mailer: ' || ' after start workflow process');
1414: END IF;
1415: wf_engine.ItemStatus(
1416: itemtype => l_itemType,
1417: itemkey => l_itemKey,

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

1424: x_return_status := 'F';
1425: end if;
1426: -- IF PG_DEBUG < 10 THEN
1427: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1428: iex_debug_pub.logmessage ('strategy_mailer: ' || ' workflow return status = ' || l_return_status);
1429: END IF;
1430:
1431:
1432: EXCEPTION

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

1431:
1432: EXCEPTION
1433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1434: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1435: iex_debug_pub.logmessage('UNEXPECTED ERROR. PUB: ' || l_api_name || ' end');
1436: iex_debug_pub.logmessage('PUB: ' || l_api_name || ' end');
1437: iex_debug_pub.logmessage('End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1438: END IF;
1439:

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

1432: EXCEPTION
1433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1434: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1435: iex_debug_pub.logmessage('UNEXPECTED ERROR. PUB: ' || l_api_name || ' end');
1436: iex_debug_pub.logmessage('PUB: ' || l_api_name || ' end');
1437: iex_debug_pub.logmessage('End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1438: END IF;
1439:
1440: WHEN OTHERS THEN

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

1433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1434: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1435: iex_debug_pub.logmessage('UNEXPECTED ERROR. PUB: ' || l_api_name || ' end');
1436: iex_debug_pub.logmessage('PUB: ' || l_api_name || ' end');
1437: iex_debug_pub.logmessage('End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1438: END IF;
1439:
1440: WHEN OTHERS THEN
1441: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

1438: END IF;
1439:
1440: WHEN OTHERS THEN
1441: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1442: iex_debug_pub.logmessage('UNHANDLED WORKFLOW EXCEPTION. Strategy ID ' || p_strategy_mailer_rec.strategy_id);
1443: iex_debug_pub.logmessage('PUB: ' || l_api_name || ' end');
1444: iex_debug_pub.logmessage('End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1445: END IF;
1446:

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

1439:
1440: WHEN OTHERS THEN
1441: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1442: iex_debug_pub.logmessage('UNHANDLED WORKFLOW EXCEPTION. Strategy ID ' || p_strategy_mailer_rec.strategy_id);
1443: iex_debug_pub.logmessage('PUB: ' || l_api_name || ' end');
1444: iex_debug_pub.logmessage('End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1445: END IF;
1446:
1447: end strategy_mailer;

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

1440: WHEN OTHERS THEN
1441: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1442: iex_debug_pub.logmessage('UNHANDLED WORKFLOW EXCEPTION. Strategy ID ' || p_strategy_mailer_rec.strategy_id);
1443: iex_debug_pub.logmessage('PUB: ' || l_api_name || ' end');
1444: iex_debug_pub.logmessage('End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1445: END IF;
1446:
1447: end strategy_mailer;
1448:

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

1522: -- get error message and pass
1523: iex_strategy_wf.Get_Messages(l_msg_count,l_error);
1524: -- IF PG_DEBUG < 10 THEN
1525: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1526: iex_debug_pub.logmessage('wf_send_signal: ' || 'error message is ' || l_error);
1527: END IF;
1528: wf_core.context('IEX_STRATEGY_WORK_PUB','wf_send_signal',itemtype,
1529: itemkey,to_char(actid),funcmode,l_error);
1530: raise;

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

1623: itemkey => itemkey,
1624: aname => 'CUSTOMER_SITE_USE_ID');
1625: -- IF PG_DEBUG < 10 THEN
1626: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1627: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, delinquency_id = ' || l_delinquency_id);
1628: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, party_id = ' || l_party_id);
1629: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, cust_account_id = ' || l_cust_account_id);
1630: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, strategy_id = ' || l_strategy_id);
1631: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, work_item_id = ' || l_work_item_id);

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

1624: aname => 'CUSTOMER_SITE_USE_ID');
1625: -- IF PG_DEBUG < 10 THEN
1626: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1627: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, delinquency_id = ' || l_delinquency_id);
1628: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, party_id = ' || l_party_id);
1629: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, cust_account_id = ' || l_cust_account_id);
1630: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, strategy_id = ' || l_strategy_id);
1631: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, work_item_id = ' || l_work_item_id);
1632: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, customer_site_use_id = ' || l_customer_site_use_id);

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

1625: -- IF PG_DEBUG < 10 THEN
1626: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1627: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, delinquency_id = ' || l_delinquency_id);
1628: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, party_id = ' || l_party_id);
1629: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, cust_account_id = ' || l_cust_account_id);
1630: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, strategy_id = ' || l_strategy_id);
1631: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, work_item_id = ' || l_work_item_id);
1632: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, customer_site_use_id = ' || l_customer_site_use_id);
1633: END IF;

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

1626: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1627: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, delinquency_id = ' || l_delinquency_id);
1628: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, party_id = ' || l_party_id);
1629: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, cust_account_id = ' || l_cust_account_id);
1630: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, strategy_id = ' || l_strategy_id);
1631: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, work_item_id = ' || l_work_item_id);
1632: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, customer_site_use_id = ' || l_customer_site_use_id);
1633: END IF;
1634:

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

1627: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, delinquency_id = ' || l_delinquency_id);
1628: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, party_id = ' || l_party_id);
1629: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, cust_account_id = ' || l_cust_account_id);
1630: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, strategy_id = ' || l_strategy_id);
1631: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, work_item_id = ' || l_work_item_id);
1632: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, customer_site_use_id = ' || l_customer_site_use_id);
1633: END IF;
1634:
1635: -- IF PG_DEBUG < 10 THEN

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

1628: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, party_id = ' || l_party_id);
1629: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, cust_account_id = ' || l_cust_account_id);
1630: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, strategy_id = ' || l_strategy_id);
1631: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, work_item_id = ' || l_work_item_id);
1632: iex_debug_pub.logmessage ('check_dunning: ' || ' check dunning, customer_site_use_id = ' || l_customer_site_use_id);
1633: END IF;
1634:
1635: -- IF PG_DEBUG < 10 THEN
1636: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

1633: END IF;
1634:
1635: -- IF PG_DEBUG < 10 THEN
1636: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1637: iex_debug_pub.logmessage ('check_dunning: ' || 'USER_ID' || l_user_id || ' RESP_ID ' || l_resp_id);
1638: END IF;
1639: -- IF PG_DEBUG < 10 THEN
1640: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1641: iex_debug_pub.logmessage ('check_dunning: ' || 'RESP_APPL_ID' ||l_resp_appl_id);

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

1637: iex_debug_pub.logmessage ('check_dunning: ' || 'USER_ID' || l_user_id || ' RESP_ID ' || l_resp_id);
1638: END IF;
1639: -- IF PG_DEBUG < 10 THEN
1640: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1641: iex_debug_pub.logmessage ('check_dunning: ' || 'RESP_APPL_ID' ||l_resp_appl_id);
1642: END IF;
1643: --set the session
1644: --FND_GLOBAL.Apps_Initialize(l_user_id, l_resp_id, l_resp_appl_id);
1645:

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

1649: if l_strategy_level = 'CUSTOMER' then
1650: begin
1651: -- IF PG_DEBUG < 10 THEN
1652: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1653: iex_debug_pub.logmessage ('check_dunning: level 10' || ' check dunning, party_id = ' || l_party_id);
1654: END IF;
1655: if l_party_id is not null then
1656: select count(*) into l_count from iex_dunnings where dunning_id in (
1657: select dun.dunning_id from iex_dunnings dun

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

1660: and dun.status = 'CLOSE'
1661: and trunc(sysdate) = trunc(dun.creation_date) );
1662: -- IF PG_DEBUG < 10 THEN
1663: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1664: iex_debug_pub.logmessage ('check_dunning: level 10' || ' check dunning, l_count = ' || l_count);
1665: END IF;
1666: if l_count > 0 and l_unique_fulfillment = 'Y' then
1667: wf_engine.SetItemAttrText(itemtype => itemtype,
1668: itemkey => itemkey,

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

1678: elsif l_strategy_level = 'ACCOUNT' then
1679: begin
1680: -- IF PG_DEBUG < 10 THEN
1681: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1682: iex_debug_pub.logmessage ('check_dunning: level 20' || ' check dunning, cust_account_id = ' || l_cust_account_id);
1683: END IF;
1684: if l_cust_account_id is not null then
1685: select count(*) into l_count from iex_dunnings where dunning_id in (
1686: select dun.dunning_id from iex_dunnings dun

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

1689: and dun.status = 'CLOSE'
1690: and trunc(sysdate) = trunc(dun.creation_date) );
1691: -- IF PG_DEBUG < 10 THEN
1692: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1693: iex_debug_pub.logmessage ('check_dunning: level 20' || ' check dunning, l_count = ' || l_count);
1694: END IF;
1695: if l_count > 0 and l_unique_fulfillment = 'Y' then
1696: wf_engine.SetItemAttrText(itemtype => itemtype,
1697: itemkey => itemkey,

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

1707: elsif l_strategy_level = 'BILL_TO' then
1708: begin
1709: -- IF PG_DEBUG < 10 THEN
1710: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1711: iex_debug_pub.logmessage ('check_dunning: level 30' || ' check dunning, customer_site_use_id = ' || l_customer_site_use_id);
1712: END IF;
1713: if l_customer_site_use_id is not null then
1714: select count(*) into l_count from iex_dunnings where dunning_id in (
1715: select dun.dunning_id from iex_dunnings dun

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

1718: and dun.status = 'CLOSE'
1719: and trunc(sysdate) = trunc(dun.creation_date) );
1720: -- IF PG_DEBUG < 10 THEN
1721: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1722: iex_debug_pub.logmessage ('check_dunning: level 30' || ' check dunning, l_count = ' || l_count);
1723: END IF;
1724: if l_count > 0 and l_unique_fulfillment = 'Y' then
1725: wf_engine.SetItemAttrText(itemtype => itemtype,
1726: itemkey => itemkey,

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

1737: begin
1738: select cust_account_id into l_cust_account_id from iex_delinquencies_all
1739: where delinquency_id = l_delinquency_id;
1740: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1741: iex_debug_pub.logmessage ('check_dunning: 40 ' || ' check dunning, delinquency_id = ' || l_delinquency_id);
1742: END IF;
1743: if l_cust_account_id is not null then
1744: -- begin bug #4230209 03/09/2005 by ctlee, multiple letters were sent in the same day even unique = 'Y'
1745: -- select count(*) into l_count from iex_dunnings where dunning_id in (

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

1757: )
1758: and trunc(sysdate) = trunc(dun.creation_date) );
1759: -- end bug #4230209 03/09/2005 by ctlee, multiple letters were sent in the same day even unique = 'Y'
1760: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1761: iex_debug_pub.logmessage ('check_dunning: 40' || ' check dunning, l_count = ' || l_count);
1762: END IF;
1763: if l_count > 0 and l_unique_fulfillment = 'Y' then
1764: wf_engine.SetItemAttrText(itemtype => itemtype,
1765: itemkey => itemkey,

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

1936: END LOOP;
1937:
1938: -- IF PG_DEBUG < 10 THEN
1939: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1940: iex_debug_pub.logmessage('resend_fulfillment: ' || 'DEL ID ' ||l_delinquency_id);
1941: END IF;
1942:
1943: FOR x_rec in c_get_xdo_template(p_work_item_id)
1944: LOOP

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

1964: l_strategy_level := 40; -- default to delinquency level
1965: end;
1966: -- IF PG_DEBUG < 10 THEN
1967: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1968: iex_debug_pub.logmessage('resend_fulfillment: ' || 'strategy_level = ' ||l_strategy_level);
1969: END IF;
1970:
1971: if l_strategy_level = 10 or l_strategy_level = 20 or l_strategy_level = 30 then
1972: FOR party_rec in c_get_party(p_work_item_id)

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

1987: FOR d_rec in c_get_del(l_delinquency_id)
1988: LOOP
1989: -- IF PG_DEBUG < 10 THEN
1990: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1991: iex_debug_pub.logmessage('resend_fulfillment: ' || 'INSIDE THE LOOP ' ||d_rec.party_id);
1992: END IF;
1993: l_party_id := d_rec.party_id;
1994: l_party_type := d_rec.party_type;
1995: l_party_name := d_rec.party_name;

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

2014: if (l_party_id <> 0) then
2015:
2016: -- IF PG_DEBUG < 10 THEN
2017: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2018: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, after PARTY_ID ='|| l_PARTY_ID );
2019: END IF;
2020:
2021: l_count := l_count +1;
2022: l_fulfillment_bind_tbl(l_count).key_name := 'party_id';

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

2029:
2030: if (l_strategy_id <> 0) then
2031: -- IF PG_DEBUG < 10 THEN
2032: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2033: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, strategy_id ' );
2034: END IF;
2035: l_count := l_count +1;
2036: l_fulfillment_bind_tbl(l_count).key_name := 'strategy_id';
2037: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';

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

2041:
2042: if (l_delinquency_id <> 0) then
2043: -- IF PG_DEBUG < 10 THEN
2044: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2045: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, delinquency_id ' );
2046: END IF;
2047: l_count := l_count +1;
2048: l_fulfillment_bind_tbl(l_count).key_name := 'delinquency_id';
2049: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';

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

2052:
2053: if (l_cust_account_id <> 0) then
2054: -- IF PG_DEBUG < 10 THEN
2055: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2056: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, cust_account_id ' );
2057: END IF;
2058: l_count := l_count +1;
2059: l_fulfillment_bind_tbl(l_count).key_name := 'cust_account_id';
2060: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';

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

2069:
2070: if (l_customer_site_use_id <> 0) then
2071: -- IF PG_DEBUG < 10 THEN
2072: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2073: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, customer_site_use_id ' );
2074: END IF;
2075: l_count := l_count +1;
2076: l_fulfillment_bind_tbl(l_count).key_name := 'customer_site_use_id';
2077: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';

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

2146: if l_strategy_level = 40 then
2147: if (l_overdue_amount <> 0) then
2148: -- IF PG_DEBUG < 10 THEN
2149: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2150: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, overdue_amount ');
2151: END IF;
2152: l_count := l_count +1;
2153: l_fulfillment_bind_tbl(l_count).key_name := 'overdue_amount';
2154: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';

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

2158:
2159: if (l_status is not null) then
2160: -- IF PG_DEBUG < 10 THEN
2161: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2162: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, delinquency_status ' );
2163: END IF;
2164: l_count := l_count +1;
2165: l_fulfillment_bind_tbl(l_count).key_name := 'delinquency_status';
2166: l_fulfillment_bind_tbl(l_count).key_type := 'VARCHAR2';

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

2170: /*
2171: if (l_aging_bucket_line_id <> 0) then
2172: -- IF PG_DEBUG < 10 THEN
2173: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2174: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, aging_bucket_line_id ' );
2175: END IF;
2176: l_count := l_count +1;
2177: l_fulfillment_bind_tbl(l_count).key_name := 'aging_bucket_line_id';
2178: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';

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

2183:
2184: if (l_payment_schedule_id <> 0) then
2185: -- IF PG_DEBUG < 10 THEN
2186: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2187: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, payment_schedule_id ');
2188: END IF;
2189: l_count := l_count +1;
2190: l_fulfillment_bind_tbl(l_count).key_name := 'payment_schedule_id';
2191: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';

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

2197: l_curr_dmethod := iex_send_xml_pvt.getCurrDeliveryMethod();
2198: if (l_curr_dmethod = 'FFM') then
2199: if (l_fulfil_temp_id <> 0) then
2200: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2201: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, template_id ' );
2202: END IF;
2203: else -- template_id could not be null
2204: x_error_message := 'No fulfillment template id';
2205: return;

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

2206: end if;
2207: else
2208: if (l_xdo_template_id <> 0) then
2209: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2210: iex_debug_pub.logmessage ('send_mail: ' || ' in send mail, xdo_template_id ' );
2211: END IF;
2212: else -- template_id could not be null
2213: x_error_message := 'No xdo template id';
2214: return;

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

2218:
2219: if (p_work_item_id <> 0) then
2220: -- IF PG_DEBUG < 10 THEN
2221: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2222: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, workitem_id ' );
2223: END IF;
2224: /*
2225: l_count := l_count +1;
2226: l_fulfillment_bind_tbl(l_count).key_name := 'workitem_id';

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

2233: end if;
2234:
2235: -- IF PG_DEBUG < 10 THEN
2236: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2237: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, l_count ='|| l_count );
2238: END IF;
2239:
2240:
2241: -- ctlee - check the hz_customer_profiles.dunning_letter

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

2246: , p_delinquency_id => l_delinquency_id ) = 'N'
2247: ) then
2248: x_error_message := 'Customer profile has set the dunning flag to NO';
2249: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2250: iex_debug_pub.logmessage ('resend_fulfillment: ' || x_error_message);
2251: END IF;
2252: return;
2253: end if;
2254:

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

2274: );
2275: if l_dun_yn = 'N' then
2276: x_error_message := 'The dunning amount does not exceed the minimum dunning amount in customer profile';
2277: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2278: iex_debug_pub.logmessage ('resend_fulfillment: ' || x_error_message);
2279: END IF;
2280: return;
2281: elsif l_dun_yn = 'E' then
2282: x_error_message := 'When strategy level is Account,value of profile "IEX: Minimum Dunning Amount Profile Check" can''t be "Bill To" or "Bill To and Account". ';

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

2280: return;
2281: elsif l_dun_yn = 'E' then
2282: x_error_message := 'When strategy level is Account,value of profile "IEX: Minimum Dunning Amount Profile Check" can''t be "Bill To" or "Bill To and Account". ';
2283: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2284: iex_debug_pub.logmessage ('resend_fulfillment: ' || x_error_message);
2285: END IF;
2286: return;
2287: end if;
2288:

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

2321: end;
2322:
2323: -- IF PG_DEBUG < 10 THEN
2324: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2325: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' after fulfil method');
2326: END IF;
2327:
2328: select max(dunning_id) into l_parent_dunning_id from iex_dunnings where object_id = p_work_item_id; -- added to fix 16433137 SNUTHALA MAR/08/2013
2329: -- ctlee - 5/20 create dunning record

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

2350: from iex_strategies
2351: where strategy_id = l_strategy_id;
2352:
2353: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2354: iex_debug_pub.logmessage('resend_fulfillment Default StrategyLevel ' || l_DefaultStrategyLevel);
2355: END IF;
2356: EXCEPTION
2357: WHEN OTHERS THEN
2358: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

2355: END IF;
2356: EXCEPTION
2357: WHEN OTHERS THEN
2358: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2359: iex_debug_pub.logmessage('Strategy Level Rised Exception ');
2360: END IF;
2361: l_DefaultStrategyLevel := 'DELINQUENCY';
2362: END;
2363: IF l_DefaultStrategyLevel = 'CUSTOMER' THEN

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

2418: );
2419: exception
2420: when others then
2421: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2422: iex_debug_pub.logmessage ('close dunning before fulfillment exception');
2423: END IF;
2424: end;
2425: END LOOP;
2426:

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

2426:
2427: -- ctlee - 6/18 fulfillment printer method available
2428: -- IF PG_DEBUG < 10 THEN
2429: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2430: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, before create dunning ' );
2431: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' WorkItem Id = '||l_workitem_id );
2432: END IF;
2433: IEX_DUNNING_PVT.CREATE_DUNNING(
2434: p_api_version => 1.0

Line 2431: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' WorkItem Id = '||l_workitem_id );

2427: -- ctlee - 6/18 fulfillment printer method available
2428: -- IF PG_DEBUG < 10 THEN
2429: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2430: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, before create dunning ' );
2431: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' WorkItem Id = '||l_workitem_id );
2432: END IF;
2433: IEX_DUNNING_PVT.CREATE_DUNNING(
2434: p_api_version => 1.0
2435: , p_init_msg_list => FND_API.G_FALSE

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

2466: -- end if;
2467:
2468: --IF PG_DEBUG < 10 THEN
2469: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2470: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, before send_fulfillment ' );
2471: END IF;
2472:
2473:
2474: -- call fulfilment function with multiple bind variables.

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

2517: end if;
2518: --- share a request id between xdo and ffm
2519:
2520:
2521: -- IEX_DEBUG_PUB.setDebugFileDir(P_FILEDIR => '/sqlcom/log', P_FILENAME =>'james.IEX');
2522: --IEX_DEBUG_PUB.setDebugFileDir(P_FILEDIR => '/sqlcom/log');
2523:
2524:
2525: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

2518: --- share a request id between xdo and ffm
2519:
2520:
2521: -- IEX_DEBUG_PUB.setDebugFileDir(P_FILEDIR => '/sqlcom/log', P_FILENAME =>'james.IEX');
2522: --IEX_DEBUG_PUB.setDebugFileDir(P_FILEDIR => '/sqlcom/log');
2523:
2524:
2525: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2526: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, after send_fulfillment ' );

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

2522: --IEX_DEBUG_PUB.setDebugFileDir(P_FILEDIR => '/sqlcom/log');
2523:
2524:
2525: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2526: iex_debug_pub.logmessage ('resend_fulfillment: ' || ' in send mail, after send_fulfillment ' );
2527: END IF;
2528:
2529: -- return to workflow
2530: if (l_request_id is null OR l_return_status <> 'S') then

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

2528:
2529: -- return to workflow
2530: if (l_request_id is null OR l_return_status <> 'S') then
2531: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2532: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'request_id =>'|| l_request_id);
2533: END IF;
2534: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2535: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'return_status =>'|| l_return_status);
2536: END IF;

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

2531: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2532: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'request_id =>'|| l_request_id);
2533: END IF;
2534: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2535: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'return_status =>'|| l_return_status);
2536: END IF;
2537: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2538: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'msg_count =>' || l_msg_count);
2539: END IF;

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

2534: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2535: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'return_status =>'|| l_return_status);
2536: END IF;
2537: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2538: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'msg_count =>' || l_msg_count);
2539: END IF;
2540:
2541: -- IF PG_DEBUG < 10 THEN
2542: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

2539: END IF;
2540:
2541: -- IF PG_DEBUG < 10 THEN
2542: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2543: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'msg_data =>');
2544: END IF;
2545: FOR l_index IN 1..l_msg_count LOOP
2546: my_message := FND_MSG_PUB.Get(p_msg_index => l_index,
2547: p_encoded => 'F');

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

2546: my_message := FND_MSG_PUB.Get(p_msg_index => l_index,
2547: p_encoded => 'F');
2548: -- IF PG_DEBUG < 10 THEN
2549: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2550: iex_debug_pub.logmessage ('resend_fulfillment: ' || my_message);
2551: END IF;
2552: END LOOP;
2553: x_error_message := my_message;
2554: else

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

2553: x_error_message := my_message;
2554: else
2555: -- IF PG_DEBUG < 10 THEN
2556: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2557: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'request_id =>'|| l_request_id);
2558: END IF;
2559: -- IF PG_DEBUG < 10 THEN
2560: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2561: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'return_status =>'|| l_return_status);

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

2557: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'request_id =>'|| l_request_id);
2558: END IF;
2559: -- IF PG_DEBUG < 10 THEN
2560: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2561: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'return_status =>'|| l_return_status);
2562: END IF;
2563: -- IF PG_DEBUG < 10 THEN
2564: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2565: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'msg_count =>' || l_msg_count);

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

2561: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'return_status =>'|| l_return_status);
2562: END IF;
2563: -- IF PG_DEBUG < 10 THEN
2564: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2565: iex_debug_pub.logmessage ('resend_fulfillment: ' || 'msg_count =>' || l_msg_count);
2566: END IF;
2567:
2568: x_status := 'S';
2569: x_request_id := l_request_id;

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

2611: l_value VARCHAR2(300);
2612:
2613: BEGIN
2614: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2615: iex_debug_pub.logmessage ('**** START wait_on_hold_signal ************');
2616: END IF;
2617: if funcmode <> wf_engine.eng_run then
2618: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2619: iex_debug_pub.logmessage('SECOND TIME FUNCMODE' ||funcmode);

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

2615: iex_debug_pub.logmessage ('**** START wait_on_hold_signal ************');
2616: END IF;
2617: if funcmode <> wf_engine.eng_run then
2618: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2619: iex_debug_pub.logmessage('SECOND TIME FUNCMODE' ||funcmode);
2620: END IF;
2621: result := wf_engine.eng_null;
2622: return;
2623: end if;

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

2624:
2625:
2626:
2627: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2628: iex_debug_pub.logmessage('FUNCMODE' ||funcmode);
2629: END IF;
2630: /* l_value :=wf_engine.GetActivityLabel(actid);
2631: wf_engine.SetItemAttrText(itemtype => itemtype,
2632: itemkey => itemkey,

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

2632: itemkey => itemkey,
2633: aname => 'ACTIVITY_NAME',
2634: avalue => l_value);
2635: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2636: iex_debug_pub.logMessage('ACTIVITYNAME' ||l_value);
2637: END IF;*/
2638:
2639:
2640: result := wf_engine.eng_notified||':'||wf_engine.eng_null||

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

2639:
2640: result := wf_engine.eng_notified||':'||wf_engine.eng_null||
2641: ':'||wf_engine.eng_null;
2642: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2643: iex_debug_pub.logmessage ('**** END wait_on_hold_signal ************');
2644: END IF;
2645: exception
2646: when others then
2647: result := wf_engine.eng_completed ||':'||wf_no;

Line 2670: iex_debug_pub.logmessage (' START wait_delivery_signal ********');

2666: l_value VARCHAR2(300);
2667:
2668: BEGIN
2669: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2670: iex_debug_pub.logmessage ('**** START wait_delivery_signal ************');
2671: END IF;
2672: if funcmode <> wf_engine.eng_run then
2673: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2674: iex_debug_pub.logmessage('SECOND TIME FUNCMODE' ||funcmode);

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

2670: iex_debug_pub.logmessage ('**** START wait_delivery_signal ************');
2671: END IF;
2672: if funcmode <> wf_engine.eng_run then
2673: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2674: iex_debug_pub.logmessage('SECOND TIME FUNCMODE' ||funcmode);
2675: END IF;
2676: result := wf_engine.eng_null;
2677: return;
2678: end if;

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

2679:
2680:
2681:
2682: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2683: iex_debug_pub.logmessage('FUNCMODE' ||funcmode);
2684: END IF;
2685: l_value :=wf_engine.GetActivityLabel(actid);
2686: wf_engine.SetItemAttrText(itemtype => itemtype,
2687: itemkey => itemkey,

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

2687: itemkey => itemkey,
2688: aname => 'ACTIVITY_NAME',
2689: avalue => l_value);
2690: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2691: iex_debug_pub.logMessage('ACTIVITYNAME' ||l_value);
2692: END IF;
2693:
2694:
2695: result := wf_engine.eng_notified||':'||wf_engine.eng_null||

Line 2698: iex_debug_pub.logmessage (' END wait_delivery_signal ********');

2694:
2695: result := wf_engine.eng_notified||':'||wf_engine.eng_null||
2696: ':'||wf_engine.eng_null;
2697: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2698: iex_debug_pub.logmessage ('**** END wait_delivery_signal ************');
2699: END IF;
2700: exception
2701: when others then
2702: result := wf_engine.eng_completed ||':'||wf_no;

Line 2724: iex_debug_pub.logmessage (' START cal_pre_wait ********');

2720: l_workitem_status varchar2(300);
2721:
2722: BEGIN
2723: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2724: iex_debug_pub.logmessage ('**** START cal_pre_wait ************');
2725: END IF;
2726: if funcmode <> 'RUN' then
2727: result := wf_engine.eng_null;
2728: return;

Line 2744: iex_debug_pub.logMessage('Number of days to wait after submitting delivery request = ' ||l_wait_days);

2740: aname => 'ACTIVITY_NAME',
2741: avalue => l_value);
2742:
2743: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2744: iex_debug_pub.logMessage('Number of days to wait after submitting delivery request = ' ||l_wait_days);
2745: END IF;
2746:
2747: if (l_wait_days = 0 or l_workitem_status = 'SKIP') then
2748: l_return := wf_no;

Line 2756: iex_debug_pub.logMessage('Letter Delivery wait time = ' || to_char(l_schedule, 'hh24:mi:ss mm/dd/yyyy'));

2752: itemkey => itemkey,
2753: aname => 'DELIVERY_WAIT_TIME',
2754: avalue => l_schedule);
2755: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2756: iex_debug_pub.logMessage('Letter Delivery wait time = ' || to_char(l_schedule, 'hh24:mi:ss mm/dd/yyyy'));
2757: END IF;
2758: l_return := wf_yes;
2759: END IF;
2760:

Line 2763: iex_debug_pub.logMessage('Collections cal_delivery_wait result = ' ||l_return);

2759: END IF;
2760:
2761:
2762: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2763: iex_debug_pub.logMessage('Collections cal_delivery_wait result = ' ||l_return);
2764: END IF;
2765:
2766: result := wf_engine.eng_completed ||':'||l_return;
2767:

Line 2769: iex_debug_pub.logmessage ('Collections END cal_delivery_wait ********');

2765:
2766: result := wf_engine.eng_completed ||':'||l_return;
2767:
2768: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2769: iex_debug_pub.logmessage ('Collections **** END cal_delivery_wait ************');
2770: END IF;
2771: exception
2772: when others then
2773: result := wf_engine.eng_completed ||':'||wf_no;

Line 2793: iex_debug_pub.logmessage('Collections BEGIN send_delivery_signal ********');

2789: l_msg_count NUMBER;
2790: l_msg_data VARCHAR2(2000);
2791:
2792: begin
2793: iex_debug_pub.logmessage('Collections **** BEGIN send_delivery_signal ************');
2794:
2795: IF NVL(fnd_profile.value('IEX_DELIVERY_WAIT_DAYS'),0)=0 THEN
2796: iex_debug_pub.logmessage('Collections **** send_delivery_signal : Value of profile IEX: Workitem waiting time in days to get delivery status is 0 ************');
2797: return;

Line 2796: iex_debug_pub.logmessage('Collections send_delivery_signal : Value of profile IEX: Workitem waiting time in days to get delivery status is 0 ********');

2792: begin
2793: iex_debug_pub.logmessage('Collections **** BEGIN send_delivery_signal ************');
2794:
2795: IF NVL(fnd_profile.value('IEX_DELIVERY_WAIT_DAYS'),0)=0 THEN
2796: iex_debug_pub.logmessage('Collections **** send_delivery_signal : Value of profile IEX: Workitem waiting time in days to get delivery status is 0 ************');
2797: return;
2798: END IF;
2799:
2800: BEGIN

Line 2814: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Unable to find work item id corresponding to xml request id '||p_xml_request_id);

2810: itemkey => l_work_item_id,
2811: aname => 'ACTIVITY_NAME');
2812: EXCEPTION
2813: WHEN NO_DATA_FOUND THEN
2814: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Unable to find work item id corresponding to xml request id '||p_xml_request_id);
2815: RETURN;
2816: WHEN OTHERS THEN
2817: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Exception'|| SQLERRM ||' while finding work item id corresponding to xml request id '||p_xml_request_id);
2818: RETURN;

Line 2817: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Exception'|| SQLERRM ||' while finding work item id corresponding to xml request id '||p_xml_request_id);

2813: WHEN NO_DATA_FOUND THEN
2814: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Unable to find work item id corresponding to xml request id '||p_xml_request_id);
2815: RETURN;
2816: WHEN OTHERS THEN
2817: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Exception'|| SQLERRM ||' while finding work item id corresponding to xml request id '||p_xml_request_id);
2818: RETURN;
2819: END;
2820: iex_debug_pub.logmessage('Activity label='||l_activity_label);
2821: IF l_activity_label = 'IEXSTFFM:WAIT_DELIVERY_SIGNAL' and l_work_item_id is not null then

Line 2820: iex_debug_pub.logmessage('Activity label='||l_activity_label);

2816: WHEN OTHERS THEN
2817: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Exception'|| SQLERRM ||' while finding work item id corresponding to xml request id '||p_xml_request_id);
2818: RETURN;
2819: END;
2820: iex_debug_pub.logmessage('Activity label='||l_activity_label);
2821: IF l_activity_label = 'IEXSTFFM:WAIT_DELIVERY_SIGNAL' and l_work_item_id is not null then
2822: IF p_status = 'SUCCESS' THEN
2823: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Sending Success Signal');
2824: wf_engine.CompleteActivity(itemtype => 'IEXSTFFM',

Line 2823: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Sending Success Signal');

2819: END;
2820: iex_debug_pub.logmessage('Activity label='||l_activity_label);
2821: IF l_activity_label = 'IEXSTFFM:WAIT_DELIVERY_SIGNAL' and l_work_item_id is not null then
2822: IF p_status = 'SUCCESS' THEN
2823: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Sending Success Signal');
2824: wf_engine.CompleteActivity(itemtype => 'IEXSTFFM',
2825: itemkey => l_work_item_id,
2826: activity =>l_activity_label,
2827: result =>'#DEFAULT');

Line 2828: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Sent Success Signal');

2824: wf_engine.CompleteActivity(itemtype => 'IEXSTFFM',
2825: itemkey => l_work_item_id,
2826: activity =>l_activity_label,
2827: result =>'#DEFAULT');
2828: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Sent Success Signal');
2829: ELSE
2830: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Sending Failure Signal');
2831: wf_engine.SetItemAttrText(itemtype => 'IEXSTFFM',
2832: itemkey =>l_work_item_id,

Line 2830: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Sending Failure Signal');

2826: activity =>l_activity_label,
2827: result =>'#DEFAULT');
2828: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Sent Success Signal');
2829: ELSE
2830: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Sending Failure Signal');
2831: wf_engine.SetItemAttrText(itemtype => 'IEXSTFFM',
2832: itemkey =>l_work_item_id,
2833: aname => 'WK_STATUS',
2834: avalue => 'INERROR');

Line 2851: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Sent Failure Signal');

2847: wf_engine.CompleteActivity(itemtype => 'IEXSTFFM',
2848: itemkey => l_work_item_id,
2849: activity =>l_activity_label,
2850: result =>'#TIMEOUT');
2851: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Sent Failure Signal');
2852: END IF;
2853: END IF;
2854: COMMIT;
2855: iex_debug_pub.logmessage('Collections **** END send_delivery_signal ************');

Line 2855: iex_debug_pub.logmessage('Collections END send_delivery_signal ********');

2851: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Sent Failure Signal');
2852: END IF;
2853: END IF;
2854: COMMIT;
2855: iex_debug_pub.logmessage('Collections **** END send_delivery_signal ************');
2856: EXCEPTION
2857: WHEN OTHERS THEN
2858: x_error_message:='Exception:'||SQLERRM;
2859: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:::Exception:::'||SQLERRM);

Line 2859: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:::Exception:::'||SQLERRM);

2855: iex_debug_pub.logmessage('Collections **** END send_delivery_signal ************');
2856: EXCEPTION
2857: WHEN OTHERS THEN
2858: x_error_message:='Exception:'||SQLERRM;
2859: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:::Exception:::'||SQLERRM);
2860: END SEND_DELIVERY_SIGNAL;
2861:
2862:
2863: PROCEDURE auto_retry_notifications(p_from_date in date,

Line 2885: iex_debug_pub.logmessage('Collections BEGIN auto_retry_notifications ********');

2881: and status='OPEN'
2882: AND context like p_context; -- 'IEXSTFFM:14515%' ;
2883:
2884: BEGIN
2885: iex_debug_pub.logmessage('Collections **** BEGIN auto_retry_notifications ************');
2886:
2887: IF NVL(fnd_profile.value('IEX_DELIVERY_WAIT_DAYS'),0)=0 THEN
2888: iex_debug_pub.logmessage('Collections **** auto_retry_notifications : Value of profile IEX: Workitem waiting time in days to get delivery status is 0 ************');
2889: return;

Line 2888: iex_debug_pub.logmessage('Collections auto_retry_notifications : Value of profile IEX: Workitem waiting time in days to get delivery status is 0 ********');

2884: BEGIN
2885: iex_debug_pub.logmessage('Collections **** BEGIN auto_retry_notifications ************');
2886:
2887: IF NVL(fnd_profile.value('IEX_DELIVERY_WAIT_DAYS'),0)=0 THEN
2888: iex_debug_pub.logmessage('Collections **** auto_retry_notifications : Value of profile IEX: Workitem waiting time in days to get delivery status is 0 ************');
2889: return;
2890: END IF;
2891:
2892: for rec_error_wi in c_error_workitems(p_from_date) loop

Line 2893: iex_debug_pub.logmessage('Collections Before retrying notifications for work item :'||rec_error_wi.work_item_id||'********');

2889: return;
2890: END IF;
2891:
2892: for rec_error_wi in c_error_workitems(p_from_date) loop
2893: iex_debug_pub.logmessage('Collections **** Before retrying notifications for work item :'||rec_error_wi.work_item_id||'************');
2894: for rec_notif in c_notification('IEXSTFFM:'||rec_error_wi.work_item_id||':%') loop
2895: begin
2896: wf_notification.setattrtext ( nid => rec_notif.notification_id
2897: , aname => 'RESULT'

Line 2904: iex_debug_pub.logmessage('Collections Erro auto retrying notifications with id :'||rec_notif.notification_id||'********');

2900: WF_NOTIFICATION.respond(nid =>rec_notif.notification_id,
2901: respond_comment=>'Response sent by IEX: Bulk XML Delivery Manager cp');
2902: exception
2903: when others then
2904: iex_debug_pub.logmessage('Collections **** Erro auto retrying notifications with id :'||rec_notif.notification_id||'************');
2905: end;
2906: end loop;
2907: iex_debug_pub.logmessage('Collections **** After retrying notifications for work item :'||rec_error_wi.work_item_id||'************');
2908: commit;

Line 2907: iex_debug_pub.logmessage('Collections After retrying notifications for work item :'||rec_error_wi.work_item_id||'********');

2903: when others then
2904: iex_debug_pub.logmessage('Collections **** Erro auto retrying notifications with id :'||rec_notif.notification_id||'************');
2905: end;
2906: end loop;
2907: iex_debug_pub.logmessage('Collections **** After retrying notifications for work item :'||rec_error_wi.work_item_id||'************');
2908: commit;
2909: end loop;
2910:
2911: iex_debug_pub.logmessage('Collections **** END auto_retry_notifications ************');

Line 2911: iex_debug_pub.logmessage('Collections END auto_retry_notifications ********');

2907: iex_debug_pub.logmessage('Collections **** After retrying notifications for work item :'||rec_error_wi.work_item_id||'************');
2908: commit;
2909: end loop;
2910:
2911: iex_debug_pub.logmessage('Collections **** END auto_retry_notifications ************');
2912: EXCEPTION
2913: WHEN OTHERS THEN
2914: x_error_message:='Exception:'||SQLERRM;
2915: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.auto_retry_notifications:::Exception:::'||SQLERRM);

Line 2915: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.auto_retry_notifications:::Exception:::'||SQLERRM);

2911: iex_debug_pub.logmessage('Collections **** END auto_retry_notifications ************');
2912: EXCEPTION
2913: WHEN OTHERS THEN
2914: x_error_message:='Exception:'||SQLERRM;
2915: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.auto_retry_notifications:::Exception:::'||SQLERRM);
2916: END auto_retry_notifications;
2917:
2918: procedure delivery_failed(
2919: itemtype in varchar2,

Line 2942: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.DELIVERY_FAILED:updating status of xml request for work item '||l_work_item_id);

2938: itemkey => itemkey,
2939: aname => 'WORKITEM_ID');
2940: if l_work_item_id is not null then
2941: begin
2942: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.DELIVERY_FAILED:updating status of xml request for work item '||l_work_item_id);
2943: update iex_xml_request_histories
2944: set status='OTHER PROCESSING FAILURE',
2945: failure_reason='Request status timed out'
2946: where object_type='IEX_STRATEGY'

Line 2989: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.DELIVERY_FAILED:exception while updating status of xml request'||SQLERRM);

2985: -- End for the bug#8435665
2986:
2987: exception
2988: when others then
2989: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.DELIVERY_FAILED:exception while updating status of xml request'||SQLERRM);
2990: end;
2991:
2992: end if;
2993: EXCEPTION

Line 2995: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.DELIVERY_FAILED:exception'||SQLERRM);

2991:
2992: end if;
2993: EXCEPTION
2994: WHEN OTHERS THEN
2995: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.DELIVERY_FAILED:exception'||SQLERRM);
2996: result := wf_engine.eng_completed ||':'||NULL;
2997: wf_core.context('IEX_STRATEGY_WORK_PUB','delivery_failed',itemtype,
2998: itemkey,to_char(actid),funcmode);
2999: raise;