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 WF_ENGINE

Line 121: result := wf_engine.eng_null;

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;
122: return;
123: end if;
124:
125: -- IF PG_DEBUG < 10 THEN

Line 133: l_party_id := wf_engine.GetItemAttrNumber(

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,
136: aname => 'PARTY_ID');
137:

Line 153: l_strategy_id := wf_engine.GetItemAttrNumber(

149: else -- party_id could not be null
150: result := 'COMPLETE:'||'N';
151: return;
152: end if;
153: l_strategy_id := wf_engine.GetItemAttrNumber(
154: itemtype => itemtype,
155: itemkey => itemkey,
156: aname => 'STRATEGY_ID');
157: if (l_strategy_id <> 0) then

Line 168: l_delinquency_id := wf_engine.GetItemAttrNumber(

164: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';
165: l_fulfillment_bind_tbl(l_count).key_value := to_char(l_strategy_id);
166: end if;
167:
168: l_delinquency_id := wf_engine.GetItemAttrNumber(
169: itemtype => itemtype,
170: itemkey => itemkey,
171: aname => 'DELINQUENCY_ID');
172: if (l_delinquency_id <> 0) then

Line 183: l_cust_account_id := wf_engine.GetItemAttrNumber(

179: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';
180: l_fulfillment_bind_tbl(l_count).key_value := to_char(l_delinquency_id);
181: end if;
182:
183: l_cust_account_id := wf_engine.GetItemAttrNumber(
184: itemtype => itemtype,
185: itemkey => itemkey,
186: aname => 'CUST_ACCOUNT_ID');
187: if (l_cust_account_id <> 0) then

Line 206: l_overdue_amount := wf_engine.GetItemAttrNumber(

202:
203: end if;
204:
205:
206: l_overdue_amount := wf_engine.GetItemAttrNumber(
207: itemtype => itemtype,
208: itemkey => itemkey,
209: aname => 'OVERDUE_AMOUNT');
210: if (l_overdue_amount <> 0) then

Line 223: l_delinquency_status := wf_engine.GetItemAttrText(

219: end if;
220:
221:
222: /* pass org_id instead
223: l_delinquency_status := wf_engine.GetItemAttrText(
224: itemtype => itemtype,
225: itemkey => itemkey,
226: aname => 'DELINQUENCY_STATUS');
227: if (l_delinquency_status is not null) then

Line 250: l_aging_bucket_line_id := wf_engine.GetItemAttrNumber(

246: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';
247: l_fulfillment_bind_tbl(l_count).key_value := l_org_id;
248: end if;
249:
250: l_aging_bucket_line_id := wf_engine.GetItemAttrNumber(
251: itemtype => itemtype,
252: itemkey => itemkey,
253: aname => 'AGING_BUCKET_LINE_ID');
254: /* not pass the l_aging_bucket_line_id - pass customer_site_use_id instead

Line 267: l_customer_site_use_id := wf_engine.GetItemAttrNumber(

263: l_fulfillment_bind_tbl(l_count).key_value := to_char(l_aging_bucket_line_id);
264: end if;
265: */
266:
267: l_customer_site_use_id := wf_engine.GetItemAttrNumber(
268: itemtype => itemtype,
269: itemkey => itemkey,
270: aname => 'CUSTOMER_SITE_USE_ID');
271: if (l_customer_site_use_id <> 0) then

Line 283: l_payment_schedule_id := wf_engine.GetItemAttrNumber(

279: l_fulfillment_bind_tbl(l_count).key_value := to_char(l_customer_site_use_id);
280:
281: end if;
282:
283: l_payment_schedule_id := wf_engine.GetItemAttrNumber(
284: itemtype => itemtype,
285: itemkey => itemkey,
286: aname => 'PAYMENT_SCHEDULE_ID');
287: if (l_payment_schedule_id <> 0) then

Line 298: l_template_id := wf_engine.GetItemAttrNumber(

294: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';
295: l_fulfillment_bind_tbl(l_count).key_value := to_char(l_payment_schedule_id);
296: end if;
297:
298: l_template_id := wf_engine.GetItemAttrNumber(
299: itemtype => itemtype,
300: itemkey => itemkey,
301: aname => 'TEMPLATE_ID');
302: l_xdo_template_id := wf_engine.GetItemAttrNumber(

Line 302: l_xdo_template_id := wf_engine.GetItemAttrNumber(

298: l_template_id := wf_engine.GetItemAttrNumber(
299: itemtype => itemtype,
300: itemkey => itemkey,
301: aname => 'TEMPLATE_ID');
302: l_xdo_template_id := wf_engine.GetItemAttrNumber(
303: itemtype => itemtype,
304: itemkey => itemkey,
305: aname => 'XDO_TEMPLATE_ID');
306: if (l_template_id <> 0) then

Line 331: l_workitem_id := wf_engine.GetItemAttrNumber(

327:
328:
329:
330:
331: l_workitem_id := wf_engine.GetItemAttrNumber(
332: itemtype => itemtype,
333: itemkey => itemkey,
334: aname => 'WORKITEM_ID');
335: if (l_workitem_id <> 0) then

Line 366: wf_engine.SetItemAttrText(itemtype => itemtype,

362: ) then
363: result := 'COMPLETE:' || 'Y'; -- Bug #6679939 bibeura 11-Dec-2007 Changed from 'N' to 'Y'
364: begin
365: -- Bug #6679939 bibeura 11-Dec-2007 Value for parameter "avalue" is changed in the following calls
366: wf_engine.SetItemAttrText(itemtype => itemtype,
367: itemkey => itemkey,
368: aname => 'ERROR_MESSAGE',
369: avalue => 'The customer is excluded from dunning in the customer profile');
370: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 370: wf_engine.SetItemAttrText(itemtype => itemtype,

366: wf_engine.SetItemAttrText(itemtype => itemtype,
367: itemkey => itemkey,
368: aname => 'ERROR_MESSAGE',
369: avalue => 'The customer is excluded from dunning in the customer profile');
370: wf_engine.SetItemAttrText(itemtype => itemtype,
371: itemkey => itemkey,
372: aname => 'RETURN_STATUS',
373: avalue => 'S');
374: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 374: wf_engine.SetItemAttrText(itemtype => itemtype,

370: wf_engine.SetItemAttrText(itemtype => itemtype,
371: itemkey => itemkey,
372: aname => 'RETURN_STATUS',
373: avalue => 'S');
374: wf_engine.SetItemAttrText(itemtype => itemtype,
375: itemkey => itemkey,
376: aname => 'WK_STATUS',
377: avalue => 'SKIP');
378: EXCEPTION

Line 397: wf_engine.SetItemAttrText(itemtype => itemtype,

393: ) then
394: result := 'COMPLETE:' || 'Y'; -- Bug #6679939 bibeura 11-Dec-2007 Changed from 'N' to 'Y'
395: begin
396: -- Bug #6679939 bibeura 11-Dec-2007 Value for parameter "avalue" is changed in the following calls
397: wf_engine.SetItemAttrText(itemtype => itemtype,
398: itemkey => itemkey,
399: aname => 'ERROR_MESSAGE',
400: avalue => 'The dunning amount does not exceed the minimum dunning amount in the customer profile');
401: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 401: wf_engine.SetItemAttrText(itemtype => itemtype,

397: wf_engine.SetItemAttrText(itemtype => itemtype,
398: itemkey => itemkey,
399: aname => 'ERROR_MESSAGE',
400: avalue => 'The dunning amount does not exceed the minimum dunning amount in the customer profile');
401: wf_engine.SetItemAttrText(itemtype => itemtype,
402: itemkey => itemkey,
403: aname => 'RETURN_STATUS',
404: avalue => 'S');
405: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 405: wf_engine.SetItemAttrText(itemtype => itemtype,

401: wf_engine.SetItemAttrText(itemtype => itemtype,
402: itemkey => itemkey,
403: aname => 'RETURN_STATUS',
404: avalue => 'S');
405: wf_engine.SetItemAttrText(itemtype => itemtype,
406: itemkey => itemkey,
407: aname => 'WK_STATUS',
408: avalue => 'SKIP');
409: EXCEPTION

Line 618: wf_engine.SetItemAttrNumber(itemtype => itemtype,

614: END IF;
615:
616: --- share a request id between xdo and ffm
617: begin
618: wf_engine.SetItemAttrNumber(itemtype => itemtype,
619: itemkey => itemkey,
620: aname => 'REQUEST_ID',
621: avalue => l_request_id);
622:

Line 623: wf_engine.SetItemAttrText(itemtype => itemtype,

619: itemkey => itemkey,
620: aname => 'REQUEST_ID',
621: avalue => l_request_id);
622:
623: wf_engine.SetItemAttrText(itemtype => itemtype,
624: itemkey => itemkey,
625: aname => 'ERROR_MESSAGE',
626: avalue => l_msg_data);
627: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 627: wf_engine.SetItemAttrText(itemtype => itemtype,

623: wf_engine.SetItemAttrText(itemtype => itemtype,
624: itemkey => itemkey,
625: aname => 'ERROR_MESSAGE',
626: avalue => l_msg_data);
627: wf_engine.SetItemAttrText(itemtype => itemtype,
628: itemkey => itemkey,
629: aname => 'RETURN_STATUS',
630: avalue => l_return_status);
631: EXCEPTION

Line 637: wf_engine.SetItemAttrText(itemtype => itemtype,

633: NULL;
634: END;
635: -- return to workflow
636: if (l_request_id is null OR l_return_status <> 'S') then
637: wf_engine.SetItemAttrText(itemtype => itemtype,
638: itemkey => itemkey,
639: aname => 'WK_STATUS',
640: avalue => 'INERROR');
641:

Line 657: wf_engine.SetItemAttrText(itemtype => itemtype,

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',
660: avalue => all_message);
661: result := 'COMPLETE:' || 'N';

Line 673: wf_engine.SetItemAttrText(itemtype => itemtype,

669: x_msg_count => l_msg_count,
670: x_msg_data => l_msg_data
671: );
672: else
673: wf_engine.SetItemAttrText(itemtype => itemtype,
674: itemkey => itemkey,
675: aname => 'WK_STATUS',
676: avalue => 'COMPLETE');
677: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 677: wf_engine.SetItemAttrText(itemtype => itemtype,

673: wf_engine.SetItemAttrText(itemtype => itemtype,
674: itemkey => itemkey,
675: aname => 'WK_STATUS',
676: avalue => 'COMPLETE');
677: wf_engine.SetItemAttrText(itemtype => itemtype,
678: itemkey => itemkey,
679: aname => 'ERROR_MESSAGE',
680: avalue => null);
681: result := 'COMPLETE:'||'Y';

Line 822: wf_engine.SetItemAttrText(itemtype => itemtype,

818: l_username := 'SYSADMIN';
819: end if;
820:
821:
822: wf_engine.SetItemAttrText(itemtype => itemtype,
823: itemkey => itemkey,
824: aname => 'NOTIFICATION_USERNAME',
825: avalue => l_username);
826:

Line 840: wf_engine.SetItemAttrNumber(itemtype => itemtype,

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',
843: avalue => party_rec.party_id);
844: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 844: wf_engine.SetItemAttrText(itemtype => itemtype,

840: wf_engine.SetItemAttrNumber(itemtype => itemtype,
841: itemkey => itemkey,
842: aname => 'PARTY_ID',
843: avalue => party_rec.party_id);
844: wf_engine.SetItemAttrText(itemtype => itemtype,
845: itemkey => itemkey,
846: aname => 'PARTY_TYPE',
847: avalue => party_rec.party_type);
848: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 848: wf_engine.SetItemAttrText(itemtype => itemtype,

844: wf_engine.SetItemAttrText(itemtype => itemtype,
845: itemkey => itemkey,
846: aname => 'PARTY_TYPE',
847: avalue => party_rec.party_type);
848: wf_engine.SetItemAttrText(itemtype => itemtype,
849: itemkey => itemkey,
850: aname => 'PARTY_NAME',
851: avalue => party_rec.party_name);
852: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 852: wf_engine.SetItemAttrText(itemtype => itemtype,

848: wf_engine.SetItemAttrText(itemtype => itemtype,
849: itemkey => itemkey,
850: aname => 'PARTY_NAME',
851: avalue => party_rec.party_name);
852: wf_engine.SetItemAttrText(itemtype => itemtype,
853: itemkey => itemkey,
854: aname => 'FIRST_NAME',
855: avalue => party_rec.person_first_name);
856: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 856: wf_engine.SetItemAttrText(itemtype => itemtype,

852: wf_engine.SetItemAttrText(itemtype => itemtype,
853: itemkey => itemkey,
854: aname => 'FIRST_NAME',
855: avalue => party_rec.person_first_name);
856: wf_engine.SetItemAttrText(itemtype => itemtype,
857: itemkey => itemkey,
858: aname => 'LAST_NAME',
859: avalue => party_rec.person_last_name);
860: wf_engine.SetItemAttrNumber(itemtype => itemtype,

Line 860: wf_engine.SetItemAttrNumber(itemtype => itemtype,

856: wf_engine.SetItemAttrText(itemtype => itemtype,
857: itemkey => itemkey,
858: aname => 'LAST_NAME',
859: avalue => party_rec.person_last_name);
860: wf_engine.SetItemAttrNumber(itemtype => itemtype,
861: itemkey => itemkey,
862: aname => 'CUST_ACCOUNT_ID',
863: avalue => party_rec.cust_account_id);
864: wf_engine.SetItemAttrNumber(itemtype => itemtype,

Line 864: wf_engine.SetItemAttrNumber(itemtype => itemtype,

860: wf_engine.SetItemAttrNumber(itemtype => itemtype,
861: itemkey => itemkey,
862: aname => 'CUST_ACCOUNT_ID',
863: avalue => party_rec.cust_account_id);
864: wf_engine.SetItemAttrNumber(itemtype => itemtype,
865: itemkey => itemkey,
866: aname => 'CUSTOMER_SITE_USE_ID',
867: avalue => party_rec.customer_site_use_id);
868: exit;

Line 877: wf_engine.SetItemAttrNumber(itemtype => itemtype,

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',
880: avalue => d_rec.party_id);
881: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 881: wf_engine.SetItemAttrText(itemtype => itemtype,

877: wf_engine.SetItemAttrNumber(itemtype => itemtype,
878: itemkey => itemkey,
879: aname => 'PARTY_ID',
880: avalue => d_rec.party_id);
881: wf_engine.SetItemAttrText(itemtype => itemtype,
882: itemkey => itemkey,
883: aname => 'PARTY_TYPE',
884: avalue => d_rec.party_type);
885: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 885: wf_engine.SetItemAttrText(itemtype => itemtype,

881: wf_engine.SetItemAttrText(itemtype => itemtype,
882: itemkey => itemkey,
883: aname => 'PARTY_TYPE',
884: avalue => d_rec.party_type);
885: wf_engine.SetItemAttrText(itemtype => itemtype,
886: itemkey => itemkey,
887: aname => 'PARTY_NAME',
888: avalue => d_rec.party_name);
889: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 889: wf_engine.SetItemAttrText(itemtype => itemtype,

885: wf_engine.SetItemAttrText(itemtype => itemtype,
886: itemkey => itemkey,
887: aname => 'PARTY_NAME',
888: avalue => d_rec.party_name);
889: wf_engine.SetItemAttrText(itemtype => itemtype,
890: itemkey => itemkey,
891: aname => 'FIRST_NAME',
892: avalue => d_rec.person_first_name);
893: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 893: wf_engine.SetItemAttrText(itemtype => itemtype,

889: wf_engine.SetItemAttrText(itemtype => itemtype,
890: itemkey => itemkey,
891: aname => 'FIRST_NAME',
892: avalue => d_rec.person_first_name);
893: wf_engine.SetItemAttrText(itemtype => itemtype,
894: itemkey => itemkey,
895: aname => 'LAST_NAME',
896: avalue => d_rec.person_last_name);
897: wf_engine.SetItemAttrNumber(itemtype => itemtype,

Line 897: wf_engine.SetItemAttrNumber(itemtype => itemtype,

893: wf_engine.SetItemAttrText(itemtype => itemtype,
894: itemkey => itemkey,
895: aname => 'LAST_NAME',
896: avalue => d_rec.person_last_name);
897: wf_engine.SetItemAttrNumber(itemtype => itemtype,
898: itemkey => itemkey,
899: aname => 'CUST_ACCOUNT_ID',
900: avalue => d_rec.cust_account_id);
901: wf_engine.SetItemAttrText(itemtype => itemtype,

Line 901: wf_engine.SetItemAttrText(itemtype => itemtype,

897: wf_engine.SetItemAttrNumber(itemtype => itemtype,
898: itemkey => itemkey,
899: aname => 'CUST_ACCOUNT_ID',
900: avalue => d_rec.cust_account_id);
901: wf_engine.SetItemAttrText(itemtype => itemtype,
902: itemkey => itemkey,
903: aname => 'DELINQUENCY_STATUS',
904: avalue => d_rec.status);
905: wf_engine.SetItemAttrNumber(itemtype => itemtype,

Line 905: wf_engine.SetItemAttrNumber(itemtype => itemtype,

901: wf_engine.SetItemAttrText(itemtype => itemtype,
902: itemkey => itemkey,
903: aname => 'DELINQUENCY_STATUS',
904: avalue => d_rec.status);
905: wf_engine.SetItemAttrNumber(itemtype => itemtype,
906: itemkey => itemkey,
907: aname => 'AGING_BUCKET_LINE_ID',
908: avalue => d_rec.aging_bucket_LINE_id);
909: wf_engine.SetItemAttrNumber(itemtype => itemtype,

Line 909: wf_engine.SetItemAttrNumber(itemtype => itemtype,

905: wf_engine.SetItemAttrNumber(itemtype => itemtype,
906: itemkey => itemkey,
907: aname => 'AGING_BUCKET_LINE_ID',
908: avalue => d_rec.aging_bucket_LINE_id);
909: wf_engine.SetItemAttrNumber(itemtype => itemtype,
910: itemkey => itemkey,
911: aname => 'PAYMENT_SCHEDULE_ID',
912: avalue => d_rec.payment_schedule_id);
913: wf_engine.SetItemAttrNumber(itemtype => itemtype,

Line 913: wf_engine.SetItemAttrNumber(itemtype => itemtype,

909: wf_engine.SetItemAttrNumber(itemtype => itemtype,
910: itemkey => itemkey,
911: aname => 'PAYMENT_SCHEDULE_ID',
912: avalue => d_rec.payment_schedule_id);
913: wf_engine.SetItemAttrNumber(itemtype => itemtype,
914: itemkey => itemkey,
915: aname => 'CUSTOMER_SITE_USE_ID',
916: avalue => d_rec.customer_site_use_id);
917: exit;

Line 921: wf_engine.SetItemAttrNumber(itemtype => itemtype,

917: exit;
918: END LOOP;
919: FOR p_rec in c_get_payment(p_delinquency_id)
920: LOOP
921: wf_engine.SetItemAttrNumber(itemtype => itemtype,
922: itemkey => itemkey,
923: aname => 'OVERDUE_AMOUNT',
924: avalue => p_rec.amount_due_remaining);
925: exit;

Line 987: wf_engine.SetItemAttrDate(itemtype => itemtype,

983: END IF;
984:
985:
986: --set execution wait attribute
987: wf_engine.SetItemAttrDate(itemtype => itemtype,
988: itemkey => itemkey,
989: aname => 'SCHEDULE_TIME',
990: avalue => l_fulfillment_schedule);
991:

Line 1009: wf_engine.SetItemAttrDate(itemtype => itemtype,

1005: END IF;
1006:
1007:
1008: --set execution wait attribute
1009: wf_engine.SetItemAttrDate(itemtype => itemtype,
1010: itemkey => itemkey,
1011: aname => 'EXECUTION_TIME',
1012: avalue => l_fulfillment_wait);
1013:

Line 1086: wf_engine.createprocess ( itemtype => l_itemtype,

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,
1088: process => l_workflowprocess);
1089: --IF PG_DEBUG < 10 THEN
1090: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1097: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,

1093:
1094:
1095:
1096: if (p_strategy_mailer_rec.strategy_id is not null) then
1097: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
1098: itemkey => l_itemkey,
1099: aname => 'STRATEGY_ID',
1100: avalue => p_strategy_mailer_rec.strategy_id);
1101: end if;

Line 1103: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,

1099: aname => 'STRATEGY_ID',
1100: avalue => p_strategy_mailer_rec.strategy_id);
1101: end if;
1102: if (p_strategy_mailer_rec.delinquency_id is not null) then
1103: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
1104: itemkey => l_itemkey,
1105: aname => 'DELINQUENCY_ID',
1106: avalue => p_strategy_mailer_rec.delinquency_id);
1107: end if;

Line 1109: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,

1105: aname => 'DELINQUENCY_ID',
1106: avalue => p_strategy_mailer_rec.delinquency_id);
1107: end if;
1108: if (p_strategy_mailer_rec.template_id is not null) then
1109: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
1110: itemkey => l_itemkey,
1111: aname => 'TEMPLATE_ID',
1112: avalue => p_strategy_mailer_rec.template_id);
1113: end if;

Line 1115: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,

1111: aname => 'TEMPLATE_ID',
1112: avalue => p_strategy_mailer_rec.template_id);
1113: end if;
1114: if (p_strategy_mailer_rec.xdo_template_id is not null) then
1115: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
1116: itemkey => l_itemkey,
1117: aname => 'XDO_TEMPLATE_ID',
1118: avalue => p_strategy_mailer_rec.xdo_template_id);
1119: end if;

Line 1121: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,

1117: aname => 'XDO_TEMPLATE_ID',
1118: avalue => p_strategy_mailer_rec.xdo_template_id);
1119: end if;
1120: if (p_strategy_mailer_rec.workitem_id is not null) then
1121: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
1122: itemkey => l_itemkey,
1123: aname => 'WORKITEM_ID',
1124: avalue => p_strategy_mailer_rec.workitem_id);
1125: end if;

Line 1128: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,

1124: avalue => p_strategy_mailer_rec.workitem_id);
1125: end if;
1126:
1127: if (p_strategy_mailer_rec.user_id is not null) then
1128: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
1129: itemkey => l_itemkey,
1130: aname => 'USER_ID',
1131: avalue => p_strategy_mailer_rec.user_id);
1132: end if;

Line 1135: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,

1131: avalue => p_strategy_mailer_rec.user_id);
1132: end if;
1133:
1134: if (p_strategy_mailer_rec.resp_id is not null) then
1135: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
1136: itemkey => l_itemkey,
1137: aname => 'RESP_ID',
1138: avalue => p_strategy_mailer_rec.resp_id);
1139: end if;

Line 1142: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,

1138: avalue => p_strategy_mailer_rec.resp_id);
1139: end if;
1140:
1141: if (p_strategy_mailer_rec.resp_appl_id is not null) then
1142: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
1143: itemkey => l_itemkey,
1144: aname => 'RESP_APPL_ID',
1145: avalue => p_strategy_mailer_rec.resp_appl_id);
1146: end if;

Line 1162: wf_engine.startprocess(itemtype => l_itemtype, itemkey => l_itemkey);

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
1164: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1165: iex_debug_pub.logmessage ('strategy_mailer: ' || ' after start workflow process');
1166: END IF;

Line 1167: wf_engine.ItemStatus(

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,
1170: status => l_return_status,
1171: result => l_result);

Line 1220: result := wf_engine.eng_null;

1216: exc EXCEPTION;
1217: l_error VARCHAR2(32767);
1218: begin
1219: if funcmode <> 'RUN' then
1220: result := wf_engine.eng_null;
1221: return;
1222: end if;
1223:
1224: l_work_item_id := wf_engine.GetItemAttrNumber(

Line 1224: l_work_item_id := wf_engine.GetItemAttrNumber(

1220: result := wf_engine.eng_null;
1221: return;
1222: end if;
1223:
1224: l_work_item_id := wf_engine.GetItemAttrNumber(
1225: itemtype => itemtype,
1226: itemkey => itemkey,
1227: aname => 'WORKITEM_ID');
1228: l_strategy_id := wf_engine.GetItemAttrNumber(

Line 1228: l_strategy_id := wf_engine.GetItemAttrNumber(

1224: l_work_item_id := wf_engine.GetItemAttrNumber(
1225: itemtype => itemtype,
1226: itemkey => itemkey,
1227: aname => 'WORKITEM_ID');
1228: l_strategy_id := wf_engine.GetItemAttrNumber(
1229: itemtype => itemtype,
1230: itemkey => itemkey,
1231: aname => 'STRATEGY_ID');
1232: if (l_work_item_id is not null) then

Line 1237: l_wk_status := wf_engine.GetItemAttrText(

1233: --04/04 jsanju
1234: -- do not update the send signal will update
1235: --04/16/02 -- update it here and send signal if successful
1236: --05/20/02 -- update it work item status
1237: l_wk_status := wf_engine.GetItemAttrText(
1238: itemtype => itemtype,
1239: itemkey => itemkey,
1240: aname => 'WK_STATUS');
1241:

Line 1269: result := wf_engine.eng_completed;

1265:
1266: end if;-- if update successful
1267:
1268: end if;
1269: result := wf_engine.eng_completed;
1270:
1271: EXCEPTION
1272: WHEN EXC THEN
1273: --pass the error message

Line 1338: l_user_id := wf_engine.GetItemAttrNumber(

1334: return;
1335: end if;
1336: */
1337:
1338: l_user_id := wf_engine.GetItemAttrNumber(
1339: itemtype => itemtype,
1340: itemkey => itemkey,
1341: aname => 'USER_ID');
1342:

Line 1343: l_resp_id := wf_engine.GetItemAttrNumber(

1339: itemtype => itemtype,
1340: itemkey => itemkey,
1341: aname => 'USER_ID');
1342:
1343: l_resp_id := wf_engine.GetItemAttrNumber(
1344: itemtype => itemtype,
1345: itemkey => itemkey,
1346: aname => 'RESP_ID');
1347:

Line 1348: l_resp_appl_id := wf_engine.GetItemAttrNumber(

1344: itemtype => itemtype,
1345: itemkey => itemkey,
1346: aname => 'RESP_ID');
1347:
1348: l_resp_appl_id := wf_engine.GetItemAttrNumber(
1349: itemtype => itemtype,
1350: itemkey => itemkey,
1351: aname => 'RESP_APPL_ID');
1352:

Line 1353: l_delinquency_id := wf_engine.GetItemAttrNumber(

1349: itemtype => itemtype,
1350: itemkey => itemkey,
1351: aname => 'RESP_APPL_ID');
1352:
1353: l_delinquency_id := wf_engine.GetItemAttrNumber(
1354: itemtype => itemtype,
1355: itemkey => itemkey,
1356: aname => 'DELINQUENCY_ID');
1357: l_work_item_id := wf_engine.GetItemAttrNumber(

Line 1357: l_work_item_id := wf_engine.GetItemAttrNumber(

1353: l_delinquency_id := wf_engine.GetItemAttrNumber(
1354: itemtype => itemtype,
1355: itemkey => itemkey,
1356: aname => 'DELINQUENCY_ID');
1357: l_work_item_id := wf_engine.GetItemAttrNumber(
1358: itemtype => itemtype,
1359: itemkey => itemkey,
1360: aname => 'WORKITEM_ID');
1361: l_strategy_id := wf_engine.GetItemAttrNumber(

Line 1361: l_strategy_id := wf_engine.GetItemAttrNumber(

1357: l_work_item_id := wf_engine.GetItemAttrNumber(
1358: itemtype => itemtype,
1359: itemkey => itemkey,
1360: aname => 'WORKITEM_ID');
1361: l_strategy_id := wf_engine.GetItemAttrNumber(
1362: itemtype => itemtype,
1363: itemkey => itemkey,
1364: aname => 'STRATEGY_ID');
1365: l_party_id := wf_engine.GetItemAttrNumber(

Line 1365: l_party_id := wf_engine.GetItemAttrNumber(

1361: l_strategy_id := wf_engine.GetItemAttrNumber(
1362: itemtype => itemtype,
1363: itemkey => itemkey,
1364: aname => 'STRATEGY_ID');
1365: l_party_id := wf_engine.GetItemAttrNumber(
1366: itemtype => itemtype,
1367: itemkey => itemkey,
1368: aname => 'PARTY_ID');
1369: l_cust_account_id := wf_engine.GetItemAttrNumber(

Line 1369: l_cust_account_id := wf_engine.GetItemAttrNumber(

1365: l_party_id := wf_engine.GetItemAttrNumber(
1366: itemtype => itemtype,
1367: itemkey => itemkey,
1368: aname => 'PARTY_ID');
1369: l_cust_account_id := wf_engine.GetItemAttrNumber(
1370: itemtype => itemtype,
1371: itemkey => itemkey,
1372: aname => 'CUST_ACCOUNT_ID');
1373: l_customer_site_use_id := wf_engine.GetItemAttrNumber(

Line 1373: l_customer_site_use_id := wf_engine.GetItemAttrNumber(

1369: l_cust_account_id := wf_engine.GetItemAttrNumber(
1370: itemtype => itemtype,
1371: itemkey => itemkey,
1372: aname => 'CUST_ACCOUNT_ID');
1373: l_customer_site_use_id := wf_engine.GetItemAttrNumber(
1374: itemtype => itemtype,
1375: itemkey => itemkey,
1376: aname => 'CUSTOMER_SITE_USE_ID');
1377: -- IF PG_DEBUG < 10 THEN

Line 1419: wf_engine.SetItemAttrText(itemtype => itemtype,

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,
1421: aname => 'WK_STATUS',
1422: avalue => 'CANCELLED');
1423: result := 'COMPLETE:' || 'Y';

Line 1448: wf_engine.SetItemAttrText(itemtype => itemtype,

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,
1450: aname => 'WK_STATUS',
1451: avalue => 'CANCELLED');
1452: result := 'COMPLETE:' || 'Y';

Line 1477: wf_engine.SetItemAttrText(itemtype => itemtype,

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,
1479: aname => 'WK_STATUS',
1480: avalue => 'CANCELLED');
1481: result := 'COMPLETE:' || 'Y';

Line 1516: wf_engine.SetItemAttrText(itemtype => itemtype,

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,
1518: aname => 'WK_STATUS',
1519: avalue => 'CANCELLED');
1520: result := 'COMPLETE:' || 'Y';

Line 2224: if funcmode <> wf_engine.eng_run then

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);
2227: END IF;
2228: result := wf_engine.eng_null;

Line 2228: result := wf_engine.eng_null;

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;
2231:
2232:

Line 2237: /* l_value :=wf_engine.GetActivityLabel(actid);

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,
2240: aname => 'ACTIVITY_NAME',
2241: avalue => l_value);

Line 2238: wf_engine.SetItemAttrText(itemtype => itemtype,

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,
2240: aname => 'ACTIVITY_NAME',
2241: avalue => l_value);
2242: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2247: result := wf_engine.eng_notified||':'||wf_engine.eng_null||

2243: iex_debug_pub.logMessage('ACTIVITYNAME' ||l_value);
2244: END IF;*/
2245:
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;

Line 2248: ':'||wf_engine.eng_null;

2244: END IF;*/
2245:
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

Line 2254: result := wf_engine.eng_completed ||':'||wf_no;

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;
2255: wf_core.context('IEX_STRATEGY_WORK_PUB','wait_on_hold_signal',itemtype,
2256: itemkey,to_char(actid),funcmode);
2257: raise;
2258: