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 141: result := wf_engine.eng_null;

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;
142: return;
143: end if;
144:
145: -- IF PG_DEBUG < 10 THEN

Line 153: l_party_id := wf_engine.GetItemAttrNumber(

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

Line 173: l_strategy_id := wf_engine.GetItemAttrNumber(

169: else -- party_id could not be null
170: result := 'COMPLETE:'||'N';
171: return;
172: end if;
173: l_strategy_id := wf_engine.GetItemAttrNumber(
174: itemtype => itemtype,
175: itemkey => itemkey,
176: aname => 'STRATEGY_ID');
177: if (l_strategy_id <> 0) then

Line 188: l_delinquency_id := wf_engine.GetItemAttrNumber(

184: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';
185: l_fulfillment_bind_tbl(l_count).key_value := to_char(l_strategy_id);
186: end if;
187:
188: l_delinquency_id := wf_engine.GetItemAttrNumber(
189: itemtype => itemtype,
190: itemkey => itemkey,
191: aname => 'DELINQUENCY_ID');
192: if (l_delinquency_id <> 0) then

Line 203: l_cust_account_id := wf_engine.GetItemAttrNumber(

199: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';
200: l_fulfillment_bind_tbl(l_count).key_value := to_char(l_delinquency_id);
201: end if;
202:
203: l_cust_account_id := wf_engine.GetItemAttrNumber(
204: itemtype => itemtype,
205: itemkey => itemkey,
206: aname => 'CUST_ACCOUNT_ID');
207: if (l_cust_account_id <> 0) then

Line 226: l_overdue_amount := wf_engine.GetItemAttrNumber(

222:
223: end if;
224:
225:
226: l_overdue_amount := wf_engine.GetItemAttrNumber(
227: itemtype => itemtype,
228: itemkey => itemkey,
229: aname => 'OVERDUE_AMOUNT');
230: if (l_overdue_amount <> 0) then

Line 243: l_delinquency_status := wf_engine.GetItemAttrText(

239: end if;
240:
241:
242: /* pass org_id instead
243: l_delinquency_status := wf_engine.GetItemAttrText(
244: itemtype => itemtype,
245: itemkey => itemkey,
246: aname => 'DELINQUENCY_STATUS');
247: if (l_delinquency_status is not null) then

Line 261: l_aging_bucket_line_id := wf_engine.GetItemAttrNumber(

257: */
258:
259:
260: --End Bug 10401991 20-Jan-2011 barathsr
261: l_aging_bucket_line_id := wf_engine.GetItemAttrNumber(
262: itemtype => itemtype,
263: itemkey => itemkey,
264: aname => 'AGING_BUCKET_LINE_ID');
265: /* not pass the l_aging_bucket_line_id - pass customer_site_use_id instead

Line 278: l_customer_site_use_id := wf_engine.GetItemAttrNumber(

274: l_fulfillment_bind_tbl(l_count).key_value := to_char(l_aging_bucket_line_id);
275: end if;
276: */
277:
278: l_customer_site_use_id := wf_engine.GetItemAttrNumber(
279: itemtype => itemtype,
280: itemkey => itemkey,
281: aname => 'CUSTOMER_SITE_USE_ID');
282: if (l_customer_site_use_id <> 0) then

Line 362: l_payment_schedule_id := wf_engine.GetItemAttrNumber(

358: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';
359: l_fulfillment_bind_tbl(l_count).key_value := v_org_id;
360: end if;
361:
362: l_payment_schedule_id := wf_engine.GetItemAttrNumber(
363: itemtype => itemtype,
364: itemkey => itemkey,
365: aname => 'PAYMENT_SCHEDULE_ID');
366: if (l_payment_schedule_id <> 0) then

Line 377: l_template_id := wf_engine.GetItemAttrNumber(

373: l_fulfillment_bind_tbl(l_count).key_type := 'NUMBER';
374: l_fulfillment_bind_tbl(l_count).key_value := to_char(l_payment_schedule_id);
375: end if;
376:
377: l_template_id := wf_engine.GetItemAttrNumber(
378: itemtype => itemtype,
379: itemkey => itemkey,
380: aname => 'TEMPLATE_ID');
381: l_xdo_template_id := wf_engine.GetItemAttrNumber(

Line 381: l_xdo_template_id := wf_engine.GetItemAttrNumber(

377: l_template_id := wf_engine.GetItemAttrNumber(
378: itemtype => itemtype,
379: itemkey => itemkey,
380: aname => 'TEMPLATE_ID');
381: l_xdo_template_id := wf_engine.GetItemAttrNumber(
382: itemtype => itemtype,
383: itemkey => itemkey,
384: aname => 'XDO_TEMPLATE_ID');
385: if (l_template_id <> 0) then

Line 410: l_workitem_id := wf_engine.GetItemAttrNumber(

406:
407:
408:
409:
410: l_workitem_id := wf_engine.GetItemAttrNumber(
411: itemtype => itemtype,
412: itemkey => itemkey,
413: aname => 'WORKITEM_ID');
414: if (l_workitem_id <> 0) then

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

441: ) then
442: result := 'COMPLETE:' || 'Y'; -- Bug #6679939 bibeura 11-Dec-2007 Changed from 'N' to 'Y'
443: begin
444: -- Bug #6679939 bibeura 11-Dec-2007 Value for parameter "avalue" is changed in the following calls
445: wf_engine.SetItemAttrText(itemtype => itemtype,
446: itemkey => itemkey,
447: aname => 'ERROR_MESSAGE',
448: avalue => 'The customer is excluded from dunning in the customer profile');
449: wf_engine.SetItemAttrText(itemtype => itemtype,

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

445: wf_engine.SetItemAttrText(itemtype => itemtype,
446: itemkey => itemkey,
447: aname => 'ERROR_MESSAGE',
448: avalue => 'The customer is excluded from dunning in the customer profile');
449: wf_engine.SetItemAttrText(itemtype => itemtype,
450: itemkey => itemkey,
451: aname => 'RETURN_STATUS',
452: avalue => 'S');
453: wf_engine.SetItemAttrText(itemtype => itemtype,

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

449: wf_engine.SetItemAttrText(itemtype => itemtype,
450: itemkey => itemkey,
451: aname => 'RETURN_STATUS',
452: avalue => 'S');
453: wf_engine.SetItemAttrText(itemtype => itemtype,
454: itemkey => itemkey,
455: aname => 'WK_STATUS',
456: avalue => 'SKIP');
457: EXCEPTION

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

487: if l_dun_yn = 'N' then -- added for bug 15933013
488: result := 'COMPLETE:' || 'Y'; -- Bug #6679939 bibeura 11-Dec-2007 Changed from 'N' to 'Y'
489: begin
490: -- Bug #6679939 bibeura 11-Dec-2007 Value for parameter "avalue" is changed in the following calls
491: wf_engine.SetItemAttrText(itemtype => itemtype,
492: itemkey => itemkey,
493: aname => 'ERROR_MESSAGE',
494: avalue => 'The dunning amount does not exceed the minimum dunning amount in the customer profile');
495: wf_engine.SetItemAttrText(itemtype => itemtype,

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

491: wf_engine.SetItemAttrText(itemtype => itemtype,
492: itemkey => itemkey,
493: aname => 'ERROR_MESSAGE',
494: avalue => 'The dunning amount does not exceed the minimum dunning amount in the customer profile');
495: wf_engine.SetItemAttrText(itemtype => itemtype,
496: itemkey => itemkey,
497: aname => 'RETURN_STATUS',
498: avalue => 'S');
499: wf_engine.SetItemAttrText(itemtype => itemtype,

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

495: wf_engine.SetItemAttrText(itemtype => itemtype,
496: itemkey => itemkey,
497: aname => 'RETURN_STATUS',
498: avalue => 'S');
499: wf_engine.SetItemAttrText(itemtype => itemtype,
500: itemkey => itemkey,
501: aname => 'WK_STATUS',
502: avalue => 'SKIP');
503: EXCEPTION

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

510: return;
511: elsif l_dun_yn = 'E' then -- start for bug 15933013
512: result := 'COMPLETE:' || 'Y';
513: begin
514: wf_engine.SetItemAttrText(itemtype => itemtype,
515: itemkey => itemkey,
516: aname => 'ERROR_MESSAGE',
517: avalue => 'When strategy level is Account,value of profile "IEX: Minimum Dunning Amount Profile Check" can''t be "Bill To" or "Bill To and Account". ');
518: wf_engine.SetItemAttrText(itemtype => itemtype,

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

514: wf_engine.SetItemAttrText(itemtype => itemtype,
515: itemkey => itemkey,
516: aname => 'ERROR_MESSAGE',
517: avalue => 'When strategy level is Account,value of profile "IEX: Minimum Dunning Amount Profile Check" can''t be "Bill To" or "Bill To and Account". ');
518: wf_engine.SetItemAttrText(itemtype => itemtype,
519: itemkey => itemkey,
520: aname => 'RETURN_STATUS',
521: avalue => 'S');
522: wf_engine.SetItemAttrText(itemtype => itemtype,

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

518: wf_engine.SetItemAttrText(itemtype => itemtype,
519: itemkey => itemkey,
520: aname => 'RETURN_STATUS',
521: avalue => 'S');
522: wf_engine.SetItemAttrText(itemtype => itemtype,
523: itemkey => itemkey,
524: aname => 'WK_STATUS',
525: avalue => 'SKIP');
526: EXCEPTION

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

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,
550: itemkey => itemkey,
551: aname => 'ERROR_MESSAGE',
552: avalue => 'Profile IEX: Turn Off Collections Activity for Bankruptcy is Yes and bankruptcy record is exist, so will skip send dunning');
553: wf_engine.SetItemAttrText(itemtype => itemtype,

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

549: wf_engine.SetItemAttrText(itemtype => itemtype,
550: itemkey => itemkey,
551: aname => 'ERROR_MESSAGE',
552: avalue => 'Profile IEX: Turn Off Collections Activity for Bankruptcy is Yes and bankruptcy record is exist, so will skip send dunning');
553: wf_engine.SetItemAttrText(itemtype => itemtype,
554: itemkey => itemkey,
555: aname => 'RETURN_STATUS',
556: avalue => 'S');
557: wf_engine.SetItemAttrText(itemtype => itemtype,

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

553: wf_engine.SetItemAttrText(itemtype => itemtype,
554: itemkey => itemkey,
555: aname => 'RETURN_STATUS',
556: avalue => 'S');
557: wf_engine.SetItemAttrText(itemtype => itemtype,
558: itemkey => itemkey,
559: aname => 'WK_STATUS',
560: avalue => 'SKIP');
561: EXCEPTION

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

836: END IF;
837:
838: --- share a request id between xdo and ffm
839: begin
840: wf_engine.SetItemAttrNumber(itemtype => itemtype,
841: itemkey => itemkey,
842: aname => 'REQUEST_ID',
843: avalue => l_request_id);
844:

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

841: itemkey => itemkey,
842: aname => 'REQUEST_ID',
843: avalue => l_request_id);
844:
845: wf_engine.SetItemAttrText(itemtype => itemtype,
846: itemkey => itemkey,
847: aname => 'ERROR_MESSAGE',
848: avalue => l_msg_data);
849: wf_engine.SetItemAttrText(itemtype => itemtype,

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

845: wf_engine.SetItemAttrText(itemtype => itemtype,
846: itemkey => itemkey,
847: aname => 'ERROR_MESSAGE',
848: avalue => l_msg_data);
849: wf_engine.SetItemAttrText(itemtype => itemtype,
850: itemkey => itemkey,
851: aname => 'RETURN_STATUS',
852: avalue => l_return_status);
853: EXCEPTION

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

855: NULL;
856: END;
857: -- return to workflow
858: if (l_request_id is null OR l_return_status <> 'S') then
859: wf_engine.SetItemAttrText(itemtype => itemtype,
860: itemkey => itemkey,
861: aname => 'WK_STATUS',
862: avalue => 'INERROR');
863:

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

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

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

891: x_msg_count => l_msg_count,
892: x_msg_data => l_msg_data
893: );
894: else
895: wf_engine.SetItemAttrText(itemtype => itemtype,
896: itemkey => itemkey,
897: aname => 'WK_STATUS',
898: avalue => 'COMPLETE');
899: wf_engine.SetItemAttrText(itemtype => itemtype,

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

895: wf_engine.SetItemAttrText(itemtype => itemtype,
896: itemkey => itemkey,
897: aname => 'WK_STATUS',
898: avalue => 'COMPLETE');
899: wf_engine.SetItemAttrText(itemtype => itemtype,
900: itemkey => itemkey,
901: aname => 'ERROR_MESSAGE',
902: avalue => null);
903: result := 'COMPLETE:'||'Y';

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

900: itemkey => itemkey,
901: aname => 'ERROR_MESSAGE',
902: avalue => null);
903: result := 'COMPLETE:'||'Y';
904: wf_engine.SetItemAttrDate(itemtype => itemtype,
905: itemkey => itemkey,
906: aname => 'DELIVERY_WAIT_TIME',
907: avalue => sysdate+nvl(fnd_profile.value('IEX_DELIVERY_WAIT_DAYS'),0));
908:

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

1045: l_username := 'SYSADMIN';
1046: end if;
1047:
1048:
1049: wf_engine.SetItemAttrText(itemtype => itemtype,
1050: itemkey => itemkey,
1051: aname => 'NOTIFICATION_USERNAME',
1052: avalue => l_username);
1053:

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

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

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

1067: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1068: itemkey => itemkey,
1069: aname => 'PARTY_ID',
1070: avalue => party_rec.party_id);
1071: wf_engine.SetItemAttrText(itemtype => itemtype,
1072: itemkey => itemkey,
1073: aname => 'PARTY_TYPE',
1074: avalue => party_rec.party_type);
1075: wf_engine.SetItemAttrText(itemtype => itemtype,

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

1071: wf_engine.SetItemAttrText(itemtype => itemtype,
1072: itemkey => itemkey,
1073: aname => 'PARTY_TYPE',
1074: avalue => party_rec.party_type);
1075: wf_engine.SetItemAttrText(itemtype => itemtype,
1076: itemkey => itemkey,
1077: aname => 'PARTY_NAME',
1078: avalue => party_rec.party_name);
1079: wf_engine.SetItemAttrText(itemtype => itemtype,

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

1075: wf_engine.SetItemAttrText(itemtype => itemtype,
1076: itemkey => itemkey,
1077: aname => 'PARTY_NAME',
1078: avalue => party_rec.party_name);
1079: wf_engine.SetItemAttrText(itemtype => itemtype,
1080: itemkey => itemkey,
1081: aname => 'FIRST_NAME',
1082: avalue => party_rec.person_first_name);
1083: wf_engine.SetItemAttrText(itemtype => itemtype,

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

1079: wf_engine.SetItemAttrText(itemtype => itemtype,
1080: itemkey => itemkey,
1081: aname => 'FIRST_NAME',
1082: avalue => party_rec.person_first_name);
1083: wf_engine.SetItemAttrText(itemtype => itemtype,
1084: itemkey => itemkey,
1085: aname => 'LAST_NAME',
1086: avalue => party_rec.person_last_name);
1087: wf_engine.SetItemAttrNumber(itemtype => itemtype,

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

1083: wf_engine.SetItemAttrText(itemtype => itemtype,
1084: itemkey => itemkey,
1085: aname => 'LAST_NAME',
1086: avalue => party_rec.person_last_name);
1087: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1088: itemkey => itemkey,
1089: aname => 'CUST_ACCOUNT_ID',
1090: avalue => party_rec.cust_account_id);
1091: wf_engine.SetItemAttrNumber(itemtype => itemtype,

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

1087: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1088: itemkey => itemkey,
1089: aname => 'CUST_ACCOUNT_ID',
1090: avalue => party_rec.cust_account_id);
1091: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1092: itemkey => itemkey,
1093: aname => 'CUSTOMER_SITE_USE_ID',
1094: avalue => party_rec.customer_site_use_id);
1095: exit;

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

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

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

1104: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1105: itemkey => itemkey,
1106: aname => 'PARTY_ID',
1107: avalue => d_rec.party_id);
1108: wf_engine.SetItemAttrText(itemtype => itemtype,
1109: itemkey => itemkey,
1110: aname => 'PARTY_TYPE',
1111: avalue => d_rec.party_type);
1112: wf_engine.SetItemAttrText(itemtype => itemtype,

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

1108: wf_engine.SetItemAttrText(itemtype => itemtype,
1109: itemkey => itemkey,
1110: aname => 'PARTY_TYPE',
1111: avalue => d_rec.party_type);
1112: wf_engine.SetItemAttrText(itemtype => itemtype,
1113: itemkey => itemkey,
1114: aname => 'PARTY_NAME',
1115: avalue => d_rec.party_name);
1116: wf_engine.SetItemAttrText(itemtype => itemtype,

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

1112: wf_engine.SetItemAttrText(itemtype => itemtype,
1113: itemkey => itemkey,
1114: aname => 'PARTY_NAME',
1115: avalue => d_rec.party_name);
1116: wf_engine.SetItemAttrText(itemtype => itemtype,
1117: itemkey => itemkey,
1118: aname => 'FIRST_NAME',
1119: avalue => d_rec.person_first_name);
1120: wf_engine.SetItemAttrText(itemtype => itemtype,

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

1116: wf_engine.SetItemAttrText(itemtype => itemtype,
1117: itemkey => itemkey,
1118: aname => 'FIRST_NAME',
1119: avalue => d_rec.person_first_name);
1120: wf_engine.SetItemAttrText(itemtype => itemtype,
1121: itemkey => itemkey,
1122: aname => 'LAST_NAME',
1123: avalue => d_rec.person_last_name);
1124: wf_engine.SetItemAttrNumber(itemtype => itemtype,

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

1120: wf_engine.SetItemAttrText(itemtype => itemtype,
1121: itemkey => itemkey,
1122: aname => 'LAST_NAME',
1123: avalue => d_rec.person_last_name);
1124: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1125: itemkey => itemkey,
1126: aname => 'CUST_ACCOUNT_ID',
1127: avalue => d_rec.cust_account_id);
1128: wf_engine.SetItemAttrText(itemtype => itemtype,

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

1124: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1125: itemkey => itemkey,
1126: aname => 'CUST_ACCOUNT_ID',
1127: avalue => d_rec.cust_account_id);
1128: wf_engine.SetItemAttrText(itemtype => itemtype,
1129: itemkey => itemkey,
1130: aname => 'DELINQUENCY_STATUS',
1131: avalue => d_rec.status);
1132: wf_engine.SetItemAttrNumber(itemtype => itemtype,

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

1128: wf_engine.SetItemAttrText(itemtype => itemtype,
1129: itemkey => itemkey,
1130: aname => 'DELINQUENCY_STATUS',
1131: avalue => d_rec.status);
1132: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1133: itemkey => itemkey,
1134: aname => 'AGING_BUCKET_LINE_ID',
1135: avalue => d_rec.aging_bucket_LINE_id);
1136: wf_engine.SetItemAttrNumber(itemtype => itemtype,

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

1132: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1133: itemkey => itemkey,
1134: aname => 'AGING_BUCKET_LINE_ID',
1135: avalue => d_rec.aging_bucket_LINE_id);
1136: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1137: itemkey => itemkey,
1138: aname => 'PAYMENT_SCHEDULE_ID',
1139: avalue => d_rec.payment_schedule_id);
1140: wf_engine.SetItemAttrNumber(itemtype => itemtype,

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

1136: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1137: itemkey => itemkey,
1138: aname => 'PAYMENT_SCHEDULE_ID',
1139: avalue => d_rec.payment_schedule_id);
1140: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1141: itemkey => itemkey,
1142: aname => 'CUSTOMER_SITE_USE_ID',
1143: avalue => d_rec.customer_site_use_id);
1144: exit;

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

1144: exit;
1145: END LOOP;
1146: FOR p_rec in c_get_payment(p_delinquency_id)
1147: LOOP
1148: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1149: itemkey => itemkey,
1150: aname => 'OVERDUE_AMOUNT',
1151: avalue => p_rec.amount_due_remaining);
1152: exit;

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

1210: END IF;
1211:
1212:
1213: --set execution wait attribute
1214: wf_engine.SetItemAttrDate(itemtype => itemtype,
1215: itemkey => itemkey,
1216: aname => 'SCHEDULE_TIME',
1217: avalue => l_fulfillment_schedule);
1218:

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

1232: END IF;
1233:
1234:
1235: --set execution wait attribute
1236: wf_engine.SetItemAttrDate(itemtype => itemtype,
1237: itemkey => itemkey,
1238: aname => 'EXECUTION_TIME',
1239: avalue => l_fulfillment_wait);
1240:

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

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,
1324: process => l_workflowprocess);
1325: --IF PG_DEBUG < 10 THEN
1326: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

1332: fetch c_party_id into l_party_id;
1333: close c_party_id;
1334:
1335: if (l_party_id is not null) then
1336: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
1337: itemkey => l_itemkey,
1338: aname => 'PARTY_ID',
1339: avalue => l_party_id);
1340: end if;

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

1341: -- end for bug 9668367
1342:
1343:
1344: if (p_strategy_mailer_rec.strategy_id is not null) then
1345: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
1346: itemkey => l_itemkey,
1347: aname => 'STRATEGY_ID',
1348: avalue => p_strategy_mailer_rec.strategy_id);
1349: end if;

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

1347: aname => 'STRATEGY_ID',
1348: avalue => p_strategy_mailer_rec.strategy_id);
1349: end if;
1350: if (p_strategy_mailer_rec.delinquency_id is not null) then
1351: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
1352: itemkey => l_itemkey,
1353: aname => 'DELINQUENCY_ID',
1354: avalue => p_strategy_mailer_rec.delinquency_id);
1355: end if;

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

1353: aname => 'DELINQUENCY_ID',
1354: avalue => p_strategy_mailer_rec.delinquency_id);
1355: end if;
1356: if (p_strategy_mailer_rec.template_id is not null) then
1357: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
1358: itemkey => l_itemkey,
1359: aname => 'TEMPLATE_ID',
1360: avalue => p_strategy_mailer_rec.template_id);
1361: end if;

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

1359: aname => 'TEMPLATE_ID',
1360: avalue => p_strategy_mailer_rec.template_id);
1361: end if;
1362: if (p_strategy_mailer_rec.xdo_template_id is not null) then
1363: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
1364: itemkey => l_itemkey,
1365: aname => 'XDO_TEMPLATE_ID',
1366: avalue => p_strategy_mailer_rec.xdo_template_id);
1367: end if;

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

1365: aname => 'XDO_TEMPLATE_ID',
1366: avalue => p_strategy_mailer_rec.xdo_template_id);
1367: end if;
1368: if (p_strategy_mailer_rec.workitem_id is not null) then
1369: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
1370: itemkey => l_itemkey,
1371: aname => 'WORKITEM_ID',
1372: avalue => p_strategy_mailer_rec.workitem_id);
1373: end if;

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

1372: avalue => p_strategy_mailer_rec.workitem_id);
1373: end if;
1374:
1375: if (p_strategy_mailer_rec.user_id is not null) then
1376: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
1377: itemkey => l_itemkey,
1378: aname => 'USER_ID',
1379: avalue => p_strategy_mailer_rec.user_id);
1380: end if;

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

1379: avalue => p_strategy_mailer_rec.user_id);
1380: end if;
1381:
1382: if (p_strategy_mailer_rec.resp_id is not null) then
1383: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
1384: itemkey => l_itemkey,
1385: aname => 'RESP_ID',
1386: avalue => p_strategy_mailer_rec.resp_id);
1387: end if;

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

1386: avalue => p_strategy_mailer_rec.resp_id);
1387: end if;
1388:
1389: if (p_strategy_mailer_rec.resp_appl_id is not null) then
1390: wf_engine.SetItemAttrNumber(itemtype => l_itemtype,
1391: itemkey => l_itemkey,
1392: aname => 'RESP_APPL_ID',
1393: avalue => p_strategy_mailer_rec.resp_appl_id);
1394: end if;

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

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

Line 1415: wf_engine.ItemStatus(

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

Line 1468: result := wf_engine.eng_null;

1464: exc EXCEPTION;
1465: l_error VARCHAR2(32767);
1466: begin
1467: if funcmode <> 'RUN' then
1468: result := wf_engine.eng_null;
1469: return;
1470: end if;
1471:
1472: l_work_item_id := wf_engine.GetItemAttrNumber(

Line 1472: l_work_item_id := wf_engine.GetItemAttrNumber(

1468: result := wf_engine.eng_null;
1469: return;
1470: end if;
1471:
1472: l_work_item_id := wf_engine.GetItemAttrNumber(
1473: itemtype => itemtype,
1474: itemkey => itemkey,
1475: aname => 'WORKITEM_ID');
1476: l_strategy_id := wf_engine.GetItemAttrNumber(

Line 1476: l_strategy_id := wf_engine.GetItemAttrNumber(

1472: l_work_item_id := wf_engine.GetItemAttrNumber(
1473: itemtype => itemtype,
1474: itemkey => itemkey,
1475: aname => 'WORKITEM_ID');
1476: l_strategy_id := wf_engine.GetItemAttrNumber(
1477: itemtype => itemtype,
1478: itemkey => itemkey,
1479: aname => 'STRATEGY_ID');
1480: if (l_work_item_id is not null) then

Line 1485: l_wk_status := wf_engine.GetItemAttrText(

1481: --04/04 jsanju
1482: -- do not update the send signal will update
1483: --04/16/02 -- update it here and send signal if successful
1484: --05/20/02 -- update it work item status
1485: l_wk_status := wf_engine.GetItemAttrText(
1486: itemtype => itemtype,
1487: itemkey => itemkey,
1488: aname => 'WK_STATUS');
1489:

Line 1517: result := wf_engine.eng_completed;

1513:
1514: end if;-- if update successful
1515:
1516: end if;
1517: result := wf_engine.eng_completed;
1518:
1519: EXCEPTION
1520: WHEN EXC THEN
1521: --pass the error message

Line 1586: l_user_id := wf_engine.GetItemAttrNumber(

1582: return;
1583: end if;
1584: */
1585:
1586: l_user_id := wf_engine.GetItemAttrNumber(
1587: itemtype => itemtype,
1588: itemkey => itemkey,
1589: aname => 'USER_ID');
1590:

Line 1591: l_resp_id := wf_engine.GetItemAttrNumber(

1587: itemtype => itemtype,
1588: itemkey => itemkey,
1589: aname => 'USER_ID');
1590:
1591: l_resp_id := wf_engine.GetItemAttrNumber(
1592: itemtype => itemtype,
1593: itemkey => itemkey,
1594: aname => 'RESP_ID');
1595:

Line 1596: l_resp_appl_id := wf_engine.GetItemAttrNumber(

1592: itemtype => itemtype,
1593: itemkey => itemkey,
1594: aname => 'RESP_ID');
1595:
1596: l_resp_appl_id := wf_engine.GetItemAttrNumber(
1597: itemtype => itemtype,
1598: itemkey => itemkey,
1599: aname => 'RESP_APPL_ID');
1600:

Line 1601: l_delinquency_id := wf_engine.GetItemAttrNumber(

1597: itemtype => itemtype,
1598: itemkey => itemkey,
1599: aname => 'RESP_APPL_ID');
1600:
1601: l_delinquency_id := wf_engine.GetItemAttrNumber(
1602: itemtype => itemtype,
1603: itemkey => itemkey,
1604: aname => 'DELINQUENCY_ID');
1605: l_work_item_id := wf_engine.GetItemAttrNumber(

Line 1605: l_work_item_id := wf_engine.GetItemAttrNumber(

1601: l_delinquency_id := wf_engine.GetItemAttrNumber(
1602: itemtype => itemtype,
1603: itemkey => itemkey,
1604: aname => 'DELINQUENCY_ID');
1605: l_work_item_id := wf_engine.GetItemAttrNumber(
1606: itemtype => itemtype,
1607: itemkey => itemkey,
1608: aname => 'WORKITEM_ID');
1609: l_strategy_id := wf_engine.GetItemAttrNumber(

Line 1609: l_strategy_id := wf_engine.GetItemAttrNumber(

1605: l_work_item_id := wf_engine.GetItemAttrNumber(
1606: itemtype => itemtype,
1607: itemkey => itemkey,
1608: aname => 'WORKITEM_ID');
1609: l_strategy_id := wf_engine.GetItemAttrNumber(
1610: itemtype => itemtype,
1611: itemkey => itemkey,
1612: aname => 'STRATEGY_ID');
1613: l_party_id := wf_engine.GetItemAttrNumber(

Line 1613: l_party_id := wf_engine.GetItemAttrNumber(

1609: l_strategy_id := wf_engine.GetItemAttrNumber(
1610: itemtype => itemtype,
1611: itemkey => itemkey,
1612: aname => 'STRATEGY_ID');
1613: l_party_id := wf_engine.GetItemAttrNumber(
1614: itemtype => itemtype,
1615: itemkey => itemkey,
1616: aname => 'PARTY_ID');
1617: l_cust_account_id := wf_engine.GetItemAttrNumber(

Line 1617: l_cust_account_id := wf_engine.GetItemAttrNumber(

1613: l_party_id := wf_engine.GetItemAttrNumber(
1614: itemtype => itemtype,
1615: itemkey => itemkey,
1616: aname => 'PARTY_ID');
1617: l_cust_account_id := wf_engine.GetItemAttrNumber(
1618: itemtype => itemtype,
1619: itemkey => itemkey,
1620: aname => 'CUST_ACCOUNT_ID');
1621: l_customer_site_use_id := wf_engine.GetItemAttrNumber(

Line 1621: l_customer_site_use_id := wf_engine.GetItemAttrNumber(

1617: l_cust_account_id := wf_engine.GetItemAttrNumber(
1618: itemtype => itemtype,
1619: itemkey => itemkey,
1620: aname => 'CUST_ACCOUNT_ID');
1621: l_customer_site_use_id := wf_engine.GetItemAttrNumber(
1622: itemtype => itemtype,
1623: itemkey => itemkey,
1624: aname => 'CUSTOMER_SITE_USE_ID');
1625: -- IF PG_DEBUG < 10 THEN

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

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,
1669: aname => 'WK_STATUS',
1670: avalue => 'CANCELLED');
1671: result := 'COMPLETE:' || 'Y';

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

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,
1698: aname => 'WK_STATUS',
1699: avalue => 'CANCELLED');
1700: result := 'COMPLETE:' || 'Y';

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

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,
1727: aname => 'WK_STATUS',
1728: avalue => 'CANCELLED');
1729: result := 'COMPLETE:' || 'Y';

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

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,
1766: aname => 'WK_STATUS',
1767: avalue => 'CANCELLED');
1768: result := 'COMPLETE:' || 'Y';

Line 2617: if funcmode <> wf_engine.eng_run then

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

Line 2621: result := wf_engine.eng_null;

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;
2624:
2625:

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

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

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

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

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

2636: iex_debug_pub.logMessage('ACTIVITYNAME' ||l_value);
2637: END IF;*/
2638:
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;

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

2637: END IF;*/
2638:
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

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

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;
2648: wf_core.context('IEX_STRATEGY_WORK_PUB','wait_on_hold_signal',itemtype,
2649: itemkey,to_char(actid),funcmode);
2650: raise;
2651:

Line 2672: if funcmode <> wf_engine.eng_run then

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

Line 2676: result := wf_engine.eng_null;

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;
2679:
2680:

Line 2685: l_value :=wf_engine.GetActivityLabel(actid);

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

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

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

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

2691: iex_debug_pub.logMessage('ACTIVITYNAME' ||l_value);
2692: END IF;
2693:
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;

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

2692: END IF;
2693:
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

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

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;
2703: wf_core.context('IEX_STRATEGY_WORK_PUB','wait_delivery_signal',itemtype,
2704: itemkey,to_char(actid),funcmode);
2705: raise;
2706:

Line 2727: result := wf_engine.eng_null;

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;
2729: end if;
2730:
2731: l_wait_days:=nvl(fnd_profile.value('IEX_DELIVERY_WAIT_DAYS'),0);

Line 2733: l_workitem_status := wf_engine.GetItemAttrText(Itemtype => itemtype,

2729: end if;
2730:
2731: l_wait_days:=nvl(fnd_profile.value('IEX_DELIVERY_WAIT_DAYS'),0);
2732:
2733: l_workitem_status := wf_engine.GetItemAttrText(Itemtype => itemtype,
2734: Itemkey => itemkey,
2735: aname => 'WK_STATUS');
2736:
2737: l_value :=wf_engine.GetActivityLabel(actid);

Line 2737: l_value :=wf_engine.GetActivityLabel(actid);

2733: l_workitem_status := wf_engine.GetItemAttrText(Itemtype => itemtype,
2734: Itemkey => itemkey,
2735: aname => 'WK_STATUS');
2736:
2737: l_value :=wf_engine.GetActivityLabel(actid);
2738: wf_engine.SetItemAttrText(itemtype => itemtype,
2739: itemkey => itemkey,
2740: aname => 'ACTIVITY_NAME',
2741: avalue => l_value);

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

2734: Itemkey => itemkey,
2735: aname => 'WK_STATUS');
2736:
2737: l_value :=wf_engine.GetActivityLabel(actid);
2738: wf_engine.SetItemAttrText(itemtype => itemtype,
2739: itemkey => itemkey,
2740: aname => 'ACTIVITY_NAME',
2741: avalue => l_value);
2742:

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

2747: if (l_wait_days = 0 or l_workitem_status = 'SKIP') then
2748: l_return := wf_no;
2749: else
2750: l_schedule:= sysdate+l_wait_days;
2751: wf_engine.SetItemAttrDate(itemtype => itemtype,
2752: itemkey => itemkey,
2753: aname => 'DELIVERY_WAIT_TIME',
2754: avalue => l_schedule);
2755: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2766: result := wf_engine.eng_completed ||':'||l_return;

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:
2768: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2769: iex_debug_pub.logmessage ('Collections **** END cal_delivery_wait ************');
2770: END IF;

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

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;
2774: wf_core.context('IEX_STRATEGY_WORK_PUB','cal_delivery_wait',itemtype,
2775: itemkey,to_char(actid),funcmode);
2776: raise;
2777:

Line 2809: l_activity_label := wf_engine.GetItemAttrText(itemtype => 'IEXSTFFM',

2805: where dun.object_id=wi.work_item_id
2806: and dun.object_type='IEX_STRATEGY'
2807: and wi.status_code in ('OPEN','INERROR_CHECK_NOTIFY')
2808: and dun.xml_request_id=p_xml_request_id;
2809: l_activity_label := wf_engine.GetItemAttrText(itemtype => 'IEXSTFFM',
2810: itemkey => l_work_item_id,
2811: aname => 'ACTIVITY_NAME');
2812: EXCEPTION
2813: WHEN NO_DATA_FOUND THEN

Line 2824: wf_engine.CompleteActivity(itemtype => 'IEXSTFFM',

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');
2828: iex_debug_pub.logmessage('IEX_STRATEGY_WORK_PUB.SEND_DELIVERY_SIGNAL:Sent Success Signal');

Line 2831: wf_engine.SetItemAttrText(itemtype => 'IEXSTFFM',

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');
2835:

Line 2847: wf_engine.CompleteActivity(itemtype => 'IEXSTFFM',

2843: x_msg_count => l_msg_count,
2844: x_msg_data => l_msg_data
2845: );
2846:
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');

Line 2932: result := wf_engine.eng_null;

2928: l_failure_reason varchar2(2000);
2929:
2930: BEGIN
2931: if funcmode <> 'RUN' then
2932: result := wf_engine.eng_null;
2933: return;
2934: end if;
2935:
2936: l_work_item_id := wf_engine.GetItemAttrNumber(

Line 2936: l_work_item_id := wf_engine.GetItemAttrNumber(

2932: result := wf_engine.eng_null;
2933: return;
2934: end if;
2935:
2936: l_work_item_id := wf_engine.GetItemAttrNumber(
2937: itemtype => itemtype,
2938: itemkey => itemkey,
2939: aname => 'WORKITEM_ID');
2940: if l_work_item_id is not null then

Line 2954: wf_engine.SetItemAttrText(itemtype => 'IEXSTFFM',

2950: from iex_dunnings
2951: where object_type='IEX_STRATEGY'
2952: and object_id=l_work_item_id);
2953:
2954: wf_engine.SetItemAttrText(itemtype => 'IEXSTFFM',
2955: itemkey =>l_work_item_id,
2956: aname => 'WK_STATUS',
2957: avalue => 'INERROR');
2958:

Line 2970: result := wf_engine.eng_completed;

2966: x_msg_count => l_msg_count,
2967: x_msg_data => l_msg_data
2968: );
2969:
2970: result := wf_engine.eng_completed;
2971:
2972: -- Start for the bug#8435665 by PNAVEENK on 15-May-2009
2973: select failure_reason into l_failure_reason from iex_xml_request_histories where xml_request_id = (select max(xml_request_id) from
2974: iex_dunnings

Line 2980: wf_engine.SetItemAttrText(itemtype => 'IEXSTFFM',

2976: and object_id=l_work_item_id)
2977: and failure_reason is not null;
2978: if l_failure_reason is not null then
2979:
2980: wf_engine.SetItemAttrText(itemtype => 'IEXSTFFM',
2981: itemkey =>l_work_item_id,
2982: aname => 'FAILURE_REASON',
2983: avalue => l_failure_reason);
2984: end if;

Line 2996: result := wf_engine.eng_completed ||':'||NULL;

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;
3000: END delivery_failed;