[Home] [Help]
48: IF G_DEBUG='Y' THEN
49: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- Begin');
50: END IF;
51:
52: l_object_id := wf_engine.getitemattrnumber
53: (
54: itemtype => itemtype
55: ,itemkey => itemkey
56: ,aname => 'OBJECT_ID'
84: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
85: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
86: l_subject := fnd_message.get;
87:
88: wf_engine.setitemattrtext
89: (
90: itemtype => itemtype
91: ,itemkey => itemkey
92: ,aname => 'FORWARD_SUBJECT'
100: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
101: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
102: l_subject := fnd_message.get;
103:
104: wf_engine.setitemattrtext
105: (
106: itemtype => itemtype
107: ,itemkey => itemkey
108: ,aname => 'APPROVAL_SUBJECT'
116: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
117: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
118: l_subject := fnd_message.get;
119:
120: wf_engine.setitemattrtext
121: (
122: itemtype => itemtype
123: ,itemkey => itemkey
124: ,aname => 'REJECT_SUBJECT'
132: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
133: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
134: l_subject := fnd_message.get;
135:
136: wf_engine.setitemattrtext
137: (
138: itemtype => itemtype
139: ,itemkey => itemkey
140: ,aname => 'APPROVED_SUBJECT'
148: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
149: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
150: l_subject := fnd_message.get;
151:
152: wf_engine.setitemattrtext
153: (
154: itemtype => itemtype
155: ,itemkey => itemkey
156: ,aname => 'FINAL_SUBJECT'
164: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
165: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
166: l_subject := fnd_message.get;
167:
168: wf_engine.setitemattrtext
169: (
170: itemtype => itemtype
171: ,itemkey => itemkey
172: ,aname => 'REMIND_SUBJECT'
180: fnd_message.set_token('PC_HEADER_ID', l_pc_header_rec.PC_HEADER_ID, false);
181: fnd_message.set_token('NAME',l_pc_header_rec.NAME, false);
182: l_subject := fnd_message.get;
183:
184: wf_engine.setitemattrtext
185: (
186: itemtype => itemtype
187: ,itemkey => itemkey
188: ,aname => 'ERROR_SUBJECT'
206: END IF;
207:
208: IF l_return_status = FND_API.g_ret_sts_success
209: THEN
210: wf_engine.setitemattrnumber
211: (
212: itemtype => itemtype,
213: itemkey => itemkey,
214: aname => 'RULE_ID',
217: IF G_DEBUG='Y' THEN
218: AHL_DEBUG_PUB.debug('PCWF -- SET_ACTIVITY_DETAILS -- RULE_ID='||l_approval_rule_id);
219: END IF;
220:
221: wf_engine.setitemattrnumber
222: (
223: itemtype => itemtype,
224: itemkey => itemkey,
225: aname => 'APPROVER_SEQ',
344: l_hyphen_pos1 := INSTR(document_id, ':');
345: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
346: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
347:
348: l_object := wf_engine.getitemattrtext
349: (
350: itemtype => l_item_type
351: ,itemkey => l_item_key
352: ,aname => 'OBJECT_TYPE'
351: ,itemkey => l_item_key
352: ,aname => 'OBJECT_TYPE'
353: );
354:
355: l_object_id := wf_engine.getitemattrNumber
356: (
357: itemtype => l_item_type
358: ,itemkey => l_item_key
359: ,aname => 'OBJECT_ID'
358: ,itemkey => l_item_key
359: ,aname => 'OBJECT_ID'
360: );
361:
362: l_approver := wf_engine.getitemattrtext
363: (
364: itemtype => l_item_type
365: ,itemkey => l_item_key
366: ,aname => 'APPROVER'
474: l_hyphen_pos1 := INSTR(document_id, ':');
475: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
476: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
477:
478: l_object := wf_engine.getitemattrtext
479: (
480: itemtype => l_item_type
481: ,itemkey => l_item_key
482: ,aname => 'OBJECT_TYPE'
481: ,itemkey => l_item_key
482: ,aname => 'OBJECT_TYPE'
483: );
484:
485: l_object_id := wf_engine.getitemattrNumber
486: (
487: itemtype => l_item_type
488: ,itemkey => l_item_key
489: ,aname => 'OBJECT_ID'
488: ,itemkey => l_item_key
489: ,aname => 'OBJECT_ID'
490: );
491:
492: l_approver := wf_engine.getitemattrtext
493: (
494: itemtype => l_item_type
495: ,itemkey => l_item_key
496: ,aname => 'APPROVER'
601: l_hyphen_pos1 := INSTR(document_id, ':');
602: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
603: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
604:
605: l_object := wf_engine.getitemattrtext
606: (
607: itemtype => l_item_type
608: ,itemkey => l_item_key
609: ,aname => 'OBJECT_TYPE'
608: ,itemkey => l_item_key
609: ,aname => 'OBJECT_TYPE'
610: );
611:
612: l_object_id := wf_engine.getitemattrNumber
613: (
614: itemtype => l_item_type
615: ,itemkey => l_item_key
616: ,aname => 'OBJECT_ID'
723: l_hyphen_pos1 := INSTR(document_id, ':');
724: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
725: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
726:
727: l_object := wf_engine.getitemattrtext
728: (
729: itemtype => l_item_type
730: ,itemkey => l_item_key
731: ,aname => 'OBJECT_TYPE'
730: ,itemkey => l_item_key
731: ,aname => 'OBJECT_TYPE'
732: );
733:
734: l_object_id := wf_engine.getitemattrNumber
735: (
736: itemtype => l_item_type
737: ,itemkey => l_item_key
738: ,aname => 'OBJECT_ID'
737: ,itemkey => l_item_key
738: ,aname => 'OBJECT_ID'
739: );
740:
741: l_approver := wf_engine.getitemattrtext
742: (
743: itemtype => l_item_type
744: ,itemkey => l_item_key
745: ,aname => 'APPROVER'
853: l_hyphen_pos1 := INSTR(document_id, ':');
854: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
855: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
856:
857: l_object := wf_engine.getitemattrtext
858: (
859: itemtype => l_item_type
860: ,itemkey => l_item_key
861: ,aname => 'OBJECT_TYPE'
860: ,itemkey => l_item_key
861: ,aname => 'OBJECT_TYPE'
862: );
863:
864: l_object_id := wf_engine.getitemattrNumber
865: (
866: itemtype => l_item_type
867: ,itemkey => l_item_key
868: ,aname => 'OBJECT_ID'
867: ,itemkey => l_item_key
868: ,aname => 'OBJECT_ID'
869: );
870:
871: l_requester := wf_engine.getitemattrtext
872: (
873: itemtype => l_item_type
874: ,itemkey => l_item_key
875: ,aname => 'REQUESTER'
874: ,itemkey => l_item_key
875: ,aname => 'REQUESTER'
876: );
877:
878: l_requester_note := wf_engine.getitemattrtext
879: (
880: itemtype => l_item_type
881: ,itemkey => l_item_key
882: ,aname => 'REQUESTER_NOTE'
991: l_hyphen_pos1 := INSTR(document_id, ':');
992: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
993: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
994:
995: l_object := wf_engine.getitemattrtext
996: (
997: itemtype => l_item_type
998: ,itemkey => l_item_key
999: ,aname => 'OBJECT_TYPE'
998: ,itemkey => l_item_key
999: ,aname => 'OBJECT_TYPE'
1000: );
1001:
1002: l_object_id := wf_engine.getitemattrNumber
1003: (
1004: itemtype => l_item_type
1005: ,itemkey => l_item_key
1006: ,aname => 'OBJECT_ID'
1005: ,itemkey => l_item_key
1006: ,aname => 'OBJECT_ID'
1007: );
1008:
1009: l_requester := wf_engine.getitemattrtext
1010: (
1011: itemtype => l_item_type
1012: ,itemkey => l_item_key
1013: ,aname => 'REQUESTER'
1012: ,itemkey => l_item_key
1013: ,aname => 'REQUESTER'
1014: );
1015:
1016: l_requester_note := wf_engine.getitemattrtext
1017: (
1018: itemtype => l_item_type
1019: ,itemkey => l_item_key
1020: ,aname => 'REQUESTER_NOTE'
1127: l_hyphen_pos1 := INSTR(document_id, ':');
1128: l_item_type := SUBSTR(document_id, 1, l_hyphen_pos1 - 1);
1129: l_item_key := SUBSTR(document_id, l_hyphen_pos1 + 1);
1130:
1131: l_object := wf_engine.getitemattrtext
1132: (
1133: itemtype => l_item_type
1134: ,itemkey => l_item_key
1135: ,aname => 'OBJECT_TYPE'
1134: ,itemkey => l_item_key
1135: ,aname => 'OBJECT_TYPE'
1136: );
1137:
1138: l_object_id := wf_engine.getitemattrNumber
1139: (
1140: itemtype => l_item_type
1141: ,itemkey => l_item_key
1142: ,aname => 'OBJECT_ID'
1141: ,itemkey => l_item_key
1142: ,aname => 'OBJECT_ID'
1143: );
1144:
1145: l_error_msg := wf_engine.getitemattrText
1146: (
1147: itemtype => l_item_type
1148: ,itemkey => l_item_key
1149: ,aname => 'ERROR_MSG'
1274: -- RUN Mode
1275: --
1276: IF (funcmode = 'RUN')
1277: THEN
1278: l_approval_status := wf_engine.getitemattrtext
1279: (
1280: itemtype => itemtype
1281: ,itemkey => itemkey
1282: ,aname => 'UPDATE_GEN_STATUS'
1287:
1288: /*
1289: IF l_approval_status = 'APPROVED'
1290: THEN
1291: l_next_status := wf_engine.getitemattrText
1292: (
1293: itemtype => itemtype
1294: ,itemkey => itemkey
1295: ,aname => 'NEW_STATUS_ID'
1294: ,itemkey => itemkey
1295: ,aname => 'NEW_STATUS_ID'
1296: );
1297: ELSE
1298: l_next_status := wf_engine.getitemattrText
1299: (
1300: itemtype => itemtype
1301: ,itemkey => itemkey
1302: ,aname => 'REJECT_STATUS_ID'
1309: */
1310:
1311: l_next_status := l_approval_status;
1312:
1313: l_object_version_number := wf_engine.getitemattrnumber
1314: (
1315: itemtype => itemtype
1316: ,itemkey => itemkey
1317: ,aname => 'OBJECT_VER'
1319: IF G_DEBUG='Y' THEN
1320: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_object_version_number='||l_object_version_number);
1321: END IF;
1322:
1323: l_object_id := wf_engine.getitemattrnumber
1324: (
1325: itemtype => itemtype
1326: ,itemkey => itemkey
1327: ,aname => 'OBJECT_ID'
1327: ,aname => 'OBJECT_ID'
1328: );
1329:
1330: -- AJPRASAN:: Bug #9596384 - Retrieve the attribute 'REQUESTER_NOTE' which stores a hint on whether to run BUE or not, as per the logic mentioned in AHL_PC_HEADER_PVT.INITIATE_PC_APPROVAL
1331: l_bue_msg := wf_engine.getitemattrText
1332: (
1333: itemtype => itemtype
1334: ,itemkey => itemkey
1335: ,aname => 'REQUESTER_NOTE'
1521: -- RUN mode
1522: --
1523: IF (funcmode = 'RUN')
1524: THEN
1525: l_next_status := wf_engine.getitemattrText
1526: (
1527: itemtype => itemtype
1528: ,itemkey => itemkey
1529: ,aname => 'ORG_STATUS_ID'
1531: IF G_DEBUG='Y' THEN
1532: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_next_status'||l_next_status);
1533: END IF;
1534:
1535: l_object_version_number := wf_engine.getitemattrnumber
1536: (
1537: itemtype => itemtype
1538: ,itemkey => itemkey
1539: ,aname => 'OBJECT_VER'
1541: IF G_DEBUG='Y' THEN
1542: AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_object_version_number'||l_object_version_number);
1543: END IF;
1544:
1545: l_object_id := wf_engine.getitemattrnumber
1546: (
1547: itemtype => itemtype
1548: ,itemkey => itemkey
1549: ,aname => 'OBJECT_ID'