73: fnd_msg_pub.initialize;
74:
75: l_return_status := fnd_api.g_ret_sts_success;
76:
77: l_object_id := wf_engine.getitemattrnumber(
78: itemtype => itemtype
79: ,itemkey => itemkey
80: ,aname => 'OBJECT_ID'
81: );
111:
112: END IF;
113:
114:
115: wf_engine.setitemattrtext(
116: itemtype => itemtype
117: ,itemkey => itemkey
118: ,aname => 'FORWARD_SUBJECT'
119: ,avalue => l_subject);
116: itemtype => itemtype
117: ,itemkey => itemkey
118: ,aname => 'FORWARD_SUBJECT'
119: ,avalue => l_subject);
120: wf_engine.setitemattrtext(
121: itemtype => itemtype
122: ,itemkey => itemkey
123: ,aname => 'APPROVAL_SUBJECT'
124: ,avalue => l_subject);
123: ,aname => 'APPROVAL_SUBJECT'
124: ,avalue => l_subject);
125:
126:
127: wf_engine.setitemattrtext(
128: itemtype => itemtype
129: ,itemkey => itemkey
130: ,aname => 'REJECT_SUBJECT'
131: ,avalue => l_subject);
130: ,aname => 'REJECT_SUBJECT'
131: ,avalue => l_subject);
132:
133:
134: wf_engine.setitemattrtext(
135: itemtype => itemtype
136: ,itemkey => itemkey
137: ,aname => 'APPROVED_SUBJECT'
138: ,avalue => l_subject);
136: ,itemkey => itemkey
137: ,aname => 'APPROVED_SUBJECT'
138: ,avalue => l_subject);
139:
140: wf_engine.setitemattrtext(
141: itemtype => itemtype
142: ,itemkey => itemkey
143: ,aname => 'APPROVED_SUBJECT'
144: ,avalue => l_subject);
142: ,itemkey => itemkey
143: ,aname => 'APPROVED_SUBJECT'
144: ,avalue => l_subject);
145:
146: wf_engine.setitemattrtext(
147: itemtype => itemtype
148: ,itemkey => itemkey
149: ,aname => 'FINAL_SUBJECT'
150: ,avalue => l_subject);
148: ,itemkey => itemkey
149: ,aname => 'FINAL_SUBJECT'
150: ,avalue => l_subject);
151:
152: wf_engine.setitemattrtext(
153: itemtype => itemtype
154: ,itemkey => itemkey
155: ,aname => 'REMIND_SUBJECT'
156: ,avalue => l_subject);
154: ,itemkey => itemkey
155: ,aname => 'REMIND_SUBJECT'
156: ,avalue => l_subject);
157:
158: wf_engine.setitemattrtext(
159: itemtype => itemtype
160: ,itemkey => itemkey
161: ,aname => 'ERROR_SUBJECT'
162: ,avalue => l_subject
201: END IF;
202:
203: IF l_return_status = fnd_api.g_ret_sts_success THEN
204:
205: wf_engine.setitemattrnumber(
206: itemtype => itemtype,
207: itemkey => itemkey,
208: aname => 'RULE_ID',
209: avalue => l_approval_rule_id
208: aname => 'RULE_ID',
209: avalue => l_approval_rule_id
210: );
211:
212: wf_engine.setitemattrnumber(
213: itemtype => itemtype,
214: itemkey => itemkey,
215: aname => 'APPROVER_SEQ',
216: avalue => l_approver_seq
340: l_hyphen_pos1 := INSTR(document_id, ':');
341: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
342: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
343:
344: l_object := wf_engine.getitemattrtext(
345: itemtype => l_item_type
346: ,itemkey => l_item_key
347: ,aname => 'OBJECT_TYPE'
348: );
346: ,itemkey => l_item_key
347: ,aname => 'OBJECT_TYPE'
348: );
349:
350: l_object_id := wf_engine.getitemattrNumber(
351: itemtype => l_item_type
352: ,itemkey => l_item_key
353: ,aname => 'OBJECT_ID'
354: );
352: ,itemkey => l_item_key
353: ,aname => 'OBJECT_ID'
354: );
355:
356: l_approver := wf_engine.getitemattrtext(
357: itemtype => l_item_type
358: ,itemkey => l_item_key
359: ,aname => 'APPROVER'
360: );
464: l_hyphen_pos1 := INSTR(document_id, ':');
465: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
466: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
467:
468: l_object := wf_engine.getitemattrtext(
469: itemtype => l_item_type
470: ,itemkey => l_item_key
471: ,aname => 'OBJECT_TYPE'
472: );
470: ,itemkey => l_item_key
471: ,aname => 'OBJECT_TYPE'
472: );
473:
474: l_object_id := wf_engine.getitemattrNumber(
475: itemtype => l_item_type
476: ,itemkey => l_item_key
477: ,aname => 'OBJECT_ID'
478: );
476: ,itemkey => l_item_key
477: ,aname => 'OBJECT_ID'
478: );
479:
480: l_approver := wf_engine.getitemattrtext(
481: itemtype => l_item_type
482: ,itemkey => l_item_key
483: ,aname => 'APPROVER'
484: );
620: l_hyphen_pos1 := INSTR(document_id, ':');
621: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
622: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
623:
624: l_object := wf_engine.getitemattrtext(
625: itemtype => l_item_type
626: ,itemkey => l_item_key
627: ,aname => 'OBJECT_TYPE'
628: );
626: ,itemkey => l_item_key
627: ,aname => 'OBJECT_TYPE'
628: );
629:
630: l_object_id := wf_engine.getitemattrNumber(
631: itemtype => l_item_type
632: ,itemkey => l_item_key
633: ,aname => 'OBJECT_ID'
634: );
763: l_hyphen_pos1 := INSTR(document_id, ':');
764: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
765: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
766:
767: l_object := wf_engine.getitemattrtext(
768: itemtype => l_item_type
769: ,itemkey => l_item_key
770: ,aname => 'OBJECT_TYPE'
771: );
769: ,itemkey => l_item_key
770: ,aname => 'OBJECT_TYPE'
771: );
772:
773: l_object_id := wf_engine.getitemattrNumber(
774: itemtype => l_item_type
775: ,itemkey => l_item_key
776: ,aname => 'OBJECT_ID'
777: );
775: ,itemkey => l_item_key
776: ,aname => 'OBJECT_ID'
777: );
778:
779: l_approver := wf_engine.getitemattrtext(
780: itemtype => l_item_type
781: ,itemkey => l_item_key
782: ,aname => 'APPROVER'
783: );
909: l_hyphen_pos1 := INSTR(document_id, ':');
910: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
911: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
912:
913: l_object := wf_engine.getitemattrtext(
914: itemtype => l_item_type
915: ,itemkey => l_item_key
916: ,aname => 'OBJECT_TYPE'
917: );
915: ,itemkey => l_item_key
916: ,aname => 'OBJECT_TYPE'
917: );
918:
919: l_object_id := wf_engine.getitemattrNumber(
920: itemtype => l_item_type
921: ,itemkey => l_item_key
922: ,aname => 'OBJECT_ID'
923: );
921: ,itemkey => l_item_key
922: ,aname => 'OBJECT_ID'
923: );
924:
925: l_requester := wf_engine.getitemattrtext(
926: itemtype => l_item_type
927: ,itemkey => l_item_key
928: ,aname => 'REQUESTER'
929: );
927: ,itemkey => l_item_key
928: ,aname => 'REQUESTER'
929: );
930:
931: l_requester_note := wf_engine.getitemattrtext(
932: itemtype => l_item_type
933: ,itemkey => l_item_key
934: ,aname => 'REQUESTER_NOTE'
935: );
1067: l_hyphen_pos1 := INSTR(document_id, ':');
1068: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
1069: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
1070:
1071: l_object := wf_engine.getitemattrtext(
1072: itemtype => l_item_type
1073: ,itemkey => l_item_key
1074: ,aname => 'OBJECT_TYPE'
1075: );
1073: ,itemkey => l_item_key
1074: ,aname => 'OBJECT_TYPE'
1075: );
1076:
1077: l_object_id := wf_engine.getitemattrNumber(
1078: itemtype => l_item_type
1079: ,itemkey => l_item_key
1080: ,aname => 'OBJECT_ID'
1081: );
1079: ,itemkey => l_item_key
1080: ,aname => 'OBJECT_ID'
1081: );
1082:
1083: l_requester := wf_engine.getitemattrtext(
1084: itemtype => l_item_type
1085: ,itemkey => l_item_key
1086: ,aname => 'REQUESTER'
1087: );
1085: ,itemkey => l_item_key
1086: ,aname => 'REQUESTER'
1087: );
1088:
1089: l_requester_note := wf_engine.getitemattrtext(
1090: itemtype => l_item_type
1091: ,itemkey => l_item_key
1092: ,aname => 'REQUESTER_NOTE'
1093: );
1224: l_hyphen_pos1 := INSTR(document_id, ':');
1225: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
1226: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
1227:
1228: l_object := wf_engine.getitemattrtext(
1229: itemtype => l_item_type
1230: ,itemkey => l_item_key
1231: ,aname => 'OBJECT_TYPE'
1232: );
1230: ,itemkey => l_item_key
1231: ,aname => 'OBJECT_TYPE'
1232: );
1233:
1234: l_object_id := wf_engine.getitemattrNumber(
1235: itemtype => l_item_type
1236: ,itemkey => l_item_key
1237: ,aname => 'OBJECT_ID'
1238: );
1236: ,itemkey => l_item_key
1237: ,aname => 'OBJECT_ID'
1238: );
1239:
1240: l_error_msg := wf_engine.getitemattrText(
1241: itemtype => l_item_type
1242: ,itemkey => l_item_key
1243: ,aname => 'ERROR_MSG'
1244: );
1364: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'Start UpdateStatus');
1365: END IF;
1366:
1367: IF funcmode = 'RUN' THEN
1368: l_approval_status := wf_engine.getitemattrtext(
1369: itemtype => itemtype
1370: ,itemkey => itemkey
1371: ,aname => 'UPDATE_GEN_STATUS'
1372: );
1375: 'AHL_ITEMGROUPS_APPROVAL_PVT.Set_Activity_Details', 'After GetItemAttrText UpdateStatus');
1376: END IF;
1377:
1378: IF l_approval_status = 'APPROVED' THEN
1379: l_next_status := wf_engine.getitemattrText(
1380: itemtype => itemtype
1381: ,itemkey => itemkey
1382: ,aname => 'NEW_STATUS_ID'
1383: );
1382: ,aname => 'NEW_STATUS_ID'
1383: );
1384:
1385: ELSE
1386: l_next_status := wf_engine.getitemattrText(
1387: itemtype => itemtype
1388: ,itemkey => itemkey
1389: ,aname => 'REJECT_STATUS_ID'
1390: );
1389: ,aname => 'REJECT_STATUS_ID'
1390: );
1391: END IF;
1392:
1393: l_object_version_number := wf_engine.getitemattrnumber(
1394: itemtype => itemtype
1395: ,itemkey => itemkey
1396: ,aname => 'OBJECT_VER'
1397: );
1394: itemtype => itemtype
1395: ,itemkey => itemkey
1396: ,aname => 'OBJECT_VER'
1397: );
1398: l_object_id := wf_engine.getitemattrnumber(
1399: itemtype => itemtype
1400: ,itemkey => itemkey
1401: ,aname => 'OBJECT_ID'
1402: );
1590: END IF;
1591:
1592: l_return_Status:='S';
1593: IF funcmode = 'RUN' THEN
1594: l_next_status := wf_engine.getitemattrText(
1595: itemtype => itemtype
1596: ,itemkey => itemkey
1597: ,aname => 'ORG_STATUS_ID'
1598: );
1596: ,itemkey => itemkey
1597: ,aname => 'ORG_STATUS_ID'
1598: );
1599:
1600: l_object_version_number := wf_engine.getitemattrnumber(
1601: itemtype => itemtype
1602: ,itemkey => itemkey
1603: ,aname => 'OBJECT_VER'
1604: );
1601: itemtype => itemtype
1602: ,itemkey => itemkey
1603: ,aname => 'OBJECT_VER'
1604: );
1605: l_object_id := wf_engine.getitemattrnumber(
1606: itemtype => itemtype
1607: ,itemkey => itemkey
1608: ,aname => 'OBJECT_ID'
1609: );