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.OKC_REP_WF_PVT dependencies on WF_ENGINE

Line 113: l_contract_id := wf_engine.GetItemAttrNumber(

109: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
110: 'Function mode is: ' || funcmode);
111: END IF;
112: IF (funcmode = 'RUN') THEN
113: l_contract_id := wf_engine.GetItemAttrNumber(
114: itemtype => itemtype,
115: itemkey => itemkey,
116: aname => 'CONTRACT_ID');
117:

Line 127: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_TYPE ' || contract_rec.contract_type);

123: END IF;
124:
125: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
126: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
127: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_TYPE ' || contract_rec.contract_type);
128: END IF;
129: WF_ENGINE.SetItemAttrText (
130: itemtype => itemtype,
131: itemkey => itemkey,

Line 129: WF_ENGINE.SetItemAttrText (

125: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
126: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
127: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_TYPE ' || contract_rec.contract_type);
128: END IF;
129: WF_ENGINE.SetItemAttrText (
130: itemtype => itemtype,
131: itemkey => itemkey,
132: aname => 'CONTRACT_TYPE',
133: avalue => contract_rec.contract_type);

Line 137: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_NUMBER ' || contract_rec.contract_number);

133: avalue => contract_rec.contract_type);
134:
135: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
136: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
137: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_NUMBER ' || contract_rec.contract_number);
138: END IF;
139: WF_ENGINE.SetItemAttrText (
140: itemtype => itemtype,
141: itemkey => itemkey,

Line 139: WF_ENGINE.SetItemAttrText (

135: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
136: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
137: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_NUMBER ' || contract_rec.contract_number);
138: END IF;
139: WF_ENGINE.SetItemAttrText (
140: itemtype => itemtype,
141: itemkey => itemkey,
142: aname => 'CONTRACT_NUMBER',
143: avalue => contract_rec.contract_number);

Line 148: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_VERSION_NUM ' || contract_rec.contract_version_num);

144:
145:
146: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
147: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
148: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_VERSION_NUM ' || contract_rec.contract_version_num);
149: END IF;
150: WF_ENGINE.SetItemAttrNumber (
151: itemtype => itemtype,
152: itemkey => itemkey,

Line 150: WF_ENGINE.SetItemAttrNumber (

146: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
147: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
148: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_VERSION_NUM ' || contract_rec.contract_version_num);
149: END IF;
150: WF_ENGINE.SetItemAttrNumber (
151: itemtype => itemtype,
152: itemkey => itemkey,
153: aname => 'CONTRACT_VERSION',
154: avalue => contract_rec.contract_version_num);

Line 158: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_NAME ' || contract_rec.contract_name);

154: avalue => contract_rec.contract_version_num);
155:
156: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
157: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
158: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_NAME ' || contract_rec.contract_name);
159: END IF;
160: WF_ENGINE.SetItemAttrText (
161: itemtype => itemtype,
162: itemkey => itemkey,

Line 160: WF_ENGINE.SetItemAttrText (

156: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
157: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
158: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_NAME ' || contract_rec.contract_name);
159: END IF;
160: WF_ENGINE.SetItemAttrText (
161: itemtype => itemtype,
162: itemkey => itemkey,
163: aname => 'CONTRACT_NAME',
164: avalue => contract_rec.contract_name);

Line 168: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_ATTACHMENTS');

164: avalue => contract_rec.contract_name);
165:
166: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
167: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
168: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_ATTACHMENTS');
169: END IF;
170: WF_ENGINE.SetItemAttrText (
171: itemtype => itemtype,
172: itemkey => itemkey,

Line 170: WF_ENGINE.SetItemAttrText (

166: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
167: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
168: 'Calling WF_ENGINE.setitemattrnumber for CONTRACT_ATTACHMENTS');
169: END IF;
170: WF_ENGINE.SetItemAttrText (
171: itemtype => itemtype,
172: itemkey => itemkey,
173: aname => 'CONTRACT_ATTACHMENTS',
174: avalue => 'FND:entity=OKC_CONTRACT_DOCS&pk1name=BusinessDocumentType&pk1value='||contract_rec.contract_type

Line 294: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');

290: IF (funcmode = 'RUN') then
291: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
292: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
293: g_module || l_api_name,
294: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');
295: END IF;
296: l_contract_id := wf_engine.GetItemAttrNumber(
297: itemtype => itemtype,
298: itemkey => itemkey,

Line 296: l_contract_id := wf_engine.GetItemAttrNumber(

292: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
293: g_module || l_api_name,
294: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');
295: END IF;
296: l_contract_id := wf_engine.GetItemAttrNumber(
297: itemtype => itemtype,
298: itemkey => itemkey,
299: aname => 'CONTRACT_ID');
300: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 326: wf_engine.SetItemAttrText (

322: 'Number of approvers: ' || to_char(l_next_approvers.count));
323: END IF;
324: IF (l_next_approvers.count = 0) THEN
325: -- No more approver.
326: wf_engine.SetItemAttrText (
327: itemtype => itemtype,
328: itemkey => itemkey,
329: aname => 'APPROVER',
330: avalue => NULL);

Line 334: wf_engine.SetItemAttrText (

330: avalue => NULL);
331: resultout := 'COMPLETE:F';
332: ELSIF (l_next_approvers.count = 1) THEN
333: -- Only 1 approver remaining
334: wf_engine.SetItemAttrText (
335: itemtype => itemtype,
336: itemkey => itemkey,
337: aname => 'APPROVER',
338: avalue => l_next_approvers(1).name);

Line 380: wf_engine.SetItemAttrText (

376: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
377: g_module || l_api_name,
378: 'Completed Adhoc role creation');
379: END IF;
380: wf_engine.SetItemAttrText (
381: itemtype => itemtype,
382: itemkey => itemkey,
383: aname => 'APPROVER',
384: avalue => l_role_name);

Line 503: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');

499: IF (funcmode = 'RUN') then
500: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
501: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
502: g_module || l_api_name,
503: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');
504: END IF;
505: l_contract_id := wf_engine.GetItemAttrNumber(
506: itemtype => itemtype,
507: itemkey => itemkey,

Line 505: l_contract_id := wf_engine.GetItemAttrNumber(

501: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
502: g_module || l_api_name,
503: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');
504: END IF;
505: l_contract_id := wf_engine.GetItemAttrNumber(
506: itemtype => itemtype,
507: itemkey => itemkey,
508: aname => 'CONTRACT_ID');
509: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 544: l_contract_number := wf_engine.GetItemAttrText(

540: resultout := 'COMPLETE:T';
541: END IF;
542:
543: IF (l_next_approvers.count > 0) THEN
544: l_contract_number := wf_engine.GetItemAttrText(
545: itemtype => itemtype,
546: itemkey => itemkey,
547: aname => 'CONTRACT_NUMBER');
548: l_requester := wf_engine.GetItemAttrText(

Line 548: l_requester := wf_engine.GetItemAttrText(

544: l_contract_number := wf_engine.GetItemAttrText(
545: itemtype => itemtype,
546: itemkey => itemkey,
547: aname => 'CONTRACT_NUMBER');
548: l_requester := wf_engine.GetItemAttrText(
549: itemtype => itemtype,
550: itemkey => itemkey,
551: aname => 'REQUESTER');
552: l_contract_name := wf_engine.GetItemAttrText(

Line 552: l_contract_name := wf_engine.GetItemAttrText(

548: l_requester := wf_engine.GetItemAttrText(
549: itemtype => itemtype,
550: itemkey => itemkey,
551: aname => 'REQUESTER');
552: l_contract_name := wf_engine.GetItemAttrText(
553: itemtype => itemtype,
554: itemkey => itemkey,
555: aname => 'CONTRACT_NAME');
556: l_contract_version := wf_engine.GetItemAttrNumber(

Line 556: l_contract_version := wf_engine.GetItemAttrNumber(

552: l_contract_name := wf_engine.GetItemAttrText(
553: itemtype => itemtype,
554: itemkey => itemkey,
555: aname => 'CONTRACT_NAME');
556: l_contract_version := wf_engine.GetItemAttrNumber(
557: itemtype => itemtype,
558: itemkey => itemkey,
559: aname => 'CONTRACT_VERSION');
560: l_contract_type := wf_engine.GetItemAttrText(

Line 560: l_contract_type := wf_engine.GetItemAttrText(

556: l_contract_version := wf_engine.GetItemAttrNumber(
557: itemtype => itemtype,
558: itemkey => itemkey,
559: aname => 'CONTRACT_VERSION');
560: l_contract_type := wf_engine.GetItemAttrText(
561: itemtype => itemtype,
562: itemkey => itemkey,
563: aname => 'CONTRACT_TYPE');
564: l_notified_count := wf_engine.GetItemAttrNumber(

Line 564: l_notified_count := wf_engine.GetItemAttrNumber(

560: l_contract_type := wf_engine.GetItemAttrText(
561: itemtype => itemtype,
562: itemkey => itemkey,
563: aname => 'CONTRACT_TYPE');
564: l_notified_count := wf_engine.GetItemAttrNumber(
565: itemtype => itemtype,
566: itemkey => itemkey,
567: aname => 'APPROVER_COUNTER');
568: FOR i IN l_next_approvers.first..l_next_approvers.last LOOP

Line 580: 'Calling WF_ENGINE.createprocess for Notification');

576: l_notified_count := l_notified_count + 1;
577: l_item_key := itemkey || '_' || to_char(l_notified_count);
578: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
579: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
580: 'Calling WF_ENGINE.createprocess for Notification');
581: END IF;
582:
583: WF_ENGINE.createprocess (
584: itemtype => itemtype,

Line 583: WF_ENGINE.createprocess (

579: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
580: 'Calling WF_ENGINE.createprocess for Notification');
581: END IF;
582:
583: WF_ENGINE.createprocess (
584: itemtype => itemtype,
585: itemkey => l_item_key,
586: process => G_APPROVAL_NOTIF_PROCESS);
587:

Line 590: 'Calling WF_ENGINE.SetItemOwner for Notification Process');

586: process => G_APPROVAL_NOTIF_PROCESS);
587:
588: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
589: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
590: 'Calling WF_ENGINE.SetItemOwner for Notification Process');
591: END IF;
592: WF_ENGINE.SetItemOwner (
593: itemtype => itemtype,
594: itemkey => l_item_key,

Line 592: WF_ENGINE.SetItemOwner (

588: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
589: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
590: 'Calling WF_ENGINE.SetItemOwner for Notification Process');
591: END IF;
592: WF_ENGINE.SetItemOwner (
593: itemtype => itemtype,
594: itemkey => l_item_key,
595: owner => fnd_global.user_name);
596:

Line 601: WF_ENGINE.SetItemAttrText (

597: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
598: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
599: 'Setting Notification Process Approver to: ' || l_user_name);
600: END IF;
601: WF_ENGINE.SetItemAttrText (
602: itemtype => itemtype,
603: itemkey => l_item_key,
604: aname => 'APPROVER',
605: avalue => l_user_name);

Line 611: WF_ENGINE.SetItemAttrNumber (

607: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
608: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
609: 'Setting Notification Process Contract Id to: ' || l_contract_id);
610: END IF;
611: WF_ENGINE.SetItemAttrNumber (
612: itemtype => itemtype,
613: itemkey => l_item_key,
614: aname => 'CONTRACT_ID',
615: avalue => l_contract_id);

Line 621: WF_ENGINE.SetItemAttrText (

617: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
618: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
619: 'Setting Notification Process Contract Name: ' || l_contract_name);
620: END IF;
621: WF_ENGINE.SetItemAttrText (
622: itemtype => itemtype,
623: itemkey => l_item_key,
624: aname => 'CONTRACT_NAME',
625: avalue => l_contract_name);

Line 631: WF_ENGINE.SetItemAttrNumber (

627: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
628: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
629: 'Setting Notification Process Contract Version: ' || l_contract_version);
630: END IF;
631: WF_ENGINE.SetItemAttrNumber (
632: itemtype => itemtype,
633: itemkey => l_item_key,
634: aname => 'CONTRACT_VERSION',
635: avalue => l_contract_version);

Line 641: WF_ENGINE.SetItemAttrText (

637: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
638: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
639: 'Setting Notification Process Contract Type: ' || l_contract_type);
640: END IF;
641: WF_ENGINE.SetItemAttrText (
642: itemtype => itemtype,
643: itemkey => l_item_key,
644: aname => 'CONTRACT_TYPE',
645: avalue => l_contract_type);

Line 651: WF_ENGINE.SetItemAttrText (

647: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
648: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
649: 'Setting Notification Process Contract Number: ' || l_contract_number);
650: END IF;
651: WF_ENGINE.SetItemAttrText (
652: itemtype => itemtype,
653: itemkey => l_item_key,
654: aname => 'CONTRACT_NUMBER',
655: avalue => l_contract_number);

Line 661: WF_ENGINE.SetItemAttrText (

657: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
658: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
659: 'Setting Notification Process Requester: ' || l_requester);
660: END IF;
661: WF_ENGINE.SetItemAttrText (
662: itemtype => itemtype,
663: itemkey => l_item_key,
664: aname => 'REQUESTER',
665: avalue => l_requester);

Line 671: WF_ENGINE.SetItemAttrText (

667: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
668: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
669: 'Setting Notification Process Contract Attachment');
670: END IF;
671: WF_ENGINE.SetItemAttrText (
672: itemtype => itemtype,
673: itemkey => l_item_key,
674: aname => 'CONTRACT_ATTACHMENTS',
675: avalue => 'FND:entity=OKC_CONTRACT_DOCS&pk1name=BusinessDocumentType&pk1value='||l_contract_type

Line 683: WF_ENGINE.SetItemAttrText (

679: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
680: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
681: 'Setting Notification Process Master Item Key to: ' || itemkey);
682: END IF;
683: WF_ENGINE.SetItemAttrText (
684: itemtype => itemtype,
685: itemkey => l_item_key,
686: aname => 'MASTER_ITEM_KEY',
687: avalue => itemkey);

Line 692: wf_engine.startProcess(

688: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
689: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
690: 'Starting Notification Process ');
691: END IF;
692: wf_engine.startProcess(
693: itemtype => itemtype,
694: itemkey => l_item_key);
695: END IF; -- l_next_approvers.exists(i)
696: END LOOP;

Line 699: 'Calling WF_ENGINE.setitemattrnumber for APPROVER_COUNTER: ' || l_notified_count);

695: END IF; -- l_next_approvers.exists(i)
696: END LOOP;
697: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
698: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
699: 'Calling WF_ENGINE.setitemattrnumber for APPROVER_COUNTER: ' || l_notified_count);
700: END IF;
701: WF_ENGINE.SetItemAttrNumber (
702: itemtype => itemtype,
703: itemkey => itemkey,

Line 701: WF_ENGINE.SetItemAttrNumber (

697: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
698: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
699: 'Calling WF_ENGINE.setitemattrnumber for APPROVER_COUNTER: ' || l_notified_count);
700: END IF;
701: WF_ENGINE.SetItemAttrNumber (
702: itemtype => itemtype,
703: itemkey => itemkey,
704: aname => 'APPROVER_COUNTER',
705: avalue => l_notified_count);

Line 835: l_contract_id := wf_engine.GetItemAttrNumber(

831: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
832: 'Function mode is: ' || funcmode);
833: END IF;
834: -- Get contract id and version attributes
835: l_contract_id := wf_engine.GetItemAttrNumber(
836: itemtype => itemtype,
837: itemkey => itemkey,
838: aname => 'CONTRACT_ID');
839: l_contract_version := wf_engine.GetItemAttrNumber(

Line 839: l_contract_version := wf_engine.GetItemAttrNumber(

835: l_contract_id := wf_engine.GetItemAttrNumber(
836: itemtype => itemtype,
837: itemkey => itemkey,
838: aname => 'CONTRACT_ID');
839: l_contract_version := wf_engine.GetItemAttrNumber(
840: itemtype => itemtype,
841: itemkey => itemkey,
842: aname => 'CONTRACT_VERSION');
843: -- Get the approver comments

Line 845: nid => WF_ENGINE.context_nid,

841: itemkey => itemkey,
842: aname => 'CONTRACT_VERSION');
843: -- Get the approver comments
844: l_wf_note := WF_NOTIFICATION.GetAttrText(
845: nid => WF_ENGINE.context_nid,
846: aname => 'WF_NOTE');
847: -- Get the approval status
848: l_approval_status := WF_NOTIFICATION.GetAttrText(
849: nid => WF_ENGINE.context_nid,

Line 849: nid => WF_ENGINE.context_nid,

845: nid => WF_ENGINE.context_nid,
846: aname => 'WF_NOTE');
847: -- Get the approval status
848: l_approval_status := WF_NOTIFICATION.GetAttrText(
849: nid => WF_ENGINE.context_nid,
850: aname => 'RESULT');
851:
852: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
853: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 867: OPEN notif_csr(WF_ENGINE.context_nid);

863: g_module || l_api_name,
864: 'Approver action is : ' || l_approval_status);
865: END IF;
866: -- Get the notification recipient
867: OPEN notif_csr(WF_ENGINE.context_nid);
868: FETCH notif_csr into notif_rec;
869: IF(notif_csr%NOTFOUND) THEN
870: RAISE NO_DATA_FOUND;
871: END IF;

Line 1150: l_contract_id := wf_engine.GetItemAttrNumber(

1146: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1147: 'Function mode is: ' || funcmode);
1148: END IF;
1149: -- Get contract id and version attributes
1150: l_contract_id := wf_engine.GetItemAttrNumber(
1151: itemtype => itemtype,
1152: itemkey => itemkey,
1153: aname => 'CONTRACT_ID');
1154: l_contract_version := wf_engine.GetItemAttrNumber(

Line 1154: l_contract_version := wf_engine.GetItemAttrNumber(

1150: l_contract_id := wf_engine.GetItemAttrNumber(
1151: itemtype => itemtype,
1152: itemkey => itemkey,
1153: aname => 'CONTRACT_ID');
1154: l_contract_version := wf_engine.GetItemAttrNumber(
1155: itemtype => itemtype,
1156: itemkey => itemkey,
1157: aname => 'CONTRACT_VERSION');
1158: -- Get the approver comments

Line 1160: nid => WF_ENGINE.context_nid,

1156: itemkey => itemkey,
1157: aname => 'CONTRACT_VERSION');
1158: -- Get the approver comments
1159: l_wf_note := WF_NOTIFICATION.GetAttrText(
1160: nid => WF_ENGINE.context_nid,
1161: aname => 'WF_NOTE');
1162: -- Get the approval status
1163: l_approval_status := WF_NOTIFICATION.GetAttrText(
1164: nid => WF_ENGINE.context_nid,

Line 1164: nid => WF_ENGINE.context_nid,

1160: nid => WF_ENGINE.context_nid,
1161: aname => 'WF_NOTE');
1162: -- Get the approval status
1163: l_approval_status := WF_NOTIFICATION.GetAttrText(
1164: nid => WF_ENGINE.context_nid,
1165: aname => 'RESULT');
1166:
1167: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1168: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 1182: OPEN notif_csr(WF_ENGINE.context_nid);

1178: g_module || l_api_name,
1179: 'Approver action is : ' || l_approval_status);
1180: END IF;
1181: -- Get the notification recipient
1182: OPEN notif_csr(WF_ENGINE.context_nid);
1183: FETCH notif_csr into notif_rec;
1184: IF(notif_csr%NOTFOUND) THEN
1185: RAISE NO_DATA_FOUND;
1186: END IF;

Line 1194: l_notification_record.notification_id := WF_ENGINE.context_nid;

1190: 'Approver Name is : ' || notif_rec.user_name);
1191: END IF;
1192: -- l_approver_record2.name := notif_rec.user_name;
1193: l_approver_record2.name := notif_rec.original_user_name;
1194: l_notification_record.notification_id := WF_ENGINE.context_nid;
1195: l_notification_record.user_comments := l_wf_note;
1196: -- FUNCTION MODE IS RESPOND.
1197: IF (funcmode = 'RESPOND') THEN
1198: -- CURRENT APPROVER APPROVED THE CONTRACTS

Line 1454: l_contract_id := wf_engine.GetItemAttrNumber(

1450: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1451: 'Function mode is: ' || funcmode);
1452: END IF;
1453: IF (funcmode = 'RUN') THEN
1454: l_contract_id := wf_engine.GetItemAttrNumber(
1455: itemtype => itemtype,
1456: itemkey => itemkey,
1457: aname => 'CONTRACT_ID');
1458: l_contract_version := wf_engine.GetItemAttrNumber(

Line 1458: l_contract_version := wf_engine.GetItemAttrNumber(

1454: l_contract_id := wf_engine.GetItemAttrNumber(
1455: itemtype => itemtype,
1456: itemkey => itemkey,
1457: aname => 'CONTRACT_ID');
1458: l_contract_version := wf_engine.GetItemAttrNumber(
1459: itemtype => itemtype,
1460: itemkey => itemkey,
1461: aname => 'CONTRACT_VERSION');
1462: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1575: l_contract_id := wf_engine.GetItemAttrNumber(

1571: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1572: 'Function mode is: ' || funcmode);
1573: END IF;
1574: if (funcmode = 'RUN') then
1575: l_contract_id := wf_engine.GetItemAttrNumber(
1576: itemtype => itemtype,
1577: itemkey => itemkey,
1578: aname => 'CONTRACT_ID');
1579: l_contract_version := wf_engine.GetItemAttrNumber(

Line 1579: l_contract_version := wf_engine.GetItemAttrNumber(

1575: l_contract_id := wf_engine.GetItemAttrNumber(
1576: itemtype => itemtype,
1577: itemkey => itemkey,
1578: aname => 'CONTRACT_ID');
1579: l_contract_version := wf_engine.GetItemAttrNumber(
1580: itemtype => itemtype,
1581: itemkey => itemkey,
1582: aname => 'CONTRACT_VERSION');
1583: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1700: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');

1696: IF (funcmode = 'RUN') then
1697: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1698: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1699: g_module || l_api_name,
1700: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');
1701: END IF;
1702: l_contract_id := wf_engine.GetItemAttrNumber(
1703: itemtype => itemtype,
1704: itemkey => itemkey,

Line 1702: l_contract_id := wf_engine.GetItemAttrNumber(

1698: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1699: g_module || l_api_name,
1700: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');
1701: END IF;
1702: l_contract_id := wf_engine.GetItemAttrNumber(
1703: itemtype => itemtype,
1704: itemkey => itemkey,
1705: aname => 'CONTRACT_ID');
1706: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1858: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');

1854: IF (funcmode = 'RUN') then
1855: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1856: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1857: g_module || l_api_name,
1858: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');
1859: END IF;
1860: l_contract_id := wf_engine.GetItemAttrNumber(
1861: itemtype => itemtype,
1862: itemkey => itemkey,

Line 1860: l_contract_id := wf_engine.GetItemAttrNumber(

1856: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
1857: g_module || l_api_name,
1858: 'Calling wf_engine.GetItemAttrNumber to get CONTRACT_ID');
1859: END IF;
1860: l_contract_id := wf_engine.GetItemAttrNumber(
1861: itemtype => itemtype,
1862: itemkey => itemkey,
1863: aname => 'CONTRACT_ID');
1864: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1914: 'Calling WF_ENGINE.AbortProcess');

1910: FOR wf_process_rec IN wf_process_csr
1911: LOOP
1912: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1913: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,g_module || l_api_name,
1914: 'Calling WF_ENGINE.AbortProcess');
1915: END IF;
1916:
1917: WF_ENGINE.AbortProcess(
1918: itemtype => itemtype,

Line 1917: WF_ENGINE.AbortProcess(

1913: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,g_module || l_api_name,
1914: 'Calling WF_ENGINE.AbortProcess');
1915: END IF;
1916:
1917: WF_ENGINE.AbortProcess(
1918: itemtype => itemtype,
1919: itemkey => wf_process_rec.item_key,
1920: result => 'COMPLETE:',
1921: verify_lock => false,

Line 2024: l_master_key := wf_engine.GetItemAttrText(

2020: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2021: 'Function mode is: ' || funcmode);
2022: END IF;
2023: if (funcmode = 'RUN') then
2024: l_master_key := wf_engine.GetItemAttrText(
2025: itemtype => itemtype,
2026: itemkey => itemkey,
2027: aname => 'MASTER_ITEM_KEY');
2028: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2035: wf_engine.CompleteActivity(

2031: 'Master Item Key is: ' || l_master_key);
2032: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2033: 'Completing master process waiting activity');
2034: END IF;
2035: wf_engine.CompleteActivity(
2036: itemtype => itemtype,
2037: itemkey => l_master_key,
2038: activity => 'WAIT_FOR_APPROVER_RESPONSE',
2039: result => null);

Line 2121: l_contract_id := wf_engine.GetItemAttrNumber(

2117: 'Function mode is: ' || funcmode);
2118: END IF;
2119:
2120: IF (funcmode = 'RUN') THEN
2121: l_contract_id := wf_engine.GetItemAttrNumber(
2122: itemtype => itemtype,
2123: itemkey => itemkey,
2124: aname => 'CONTRACT_ID');
2125:

Line 2126: l_contract_type := wf_engine.GetItemAttrText(

2122: itemtype => itemtype,
2123: itemkey => itemkey,
2124: aname => 'CONTRACT_ID');
2125:
2126: l_contract_type := wf_engine.GetItemAttrText(
2127: itemtype => itemtype,
2128: itemkey => itemkey,
2129: aname => 'CONTRACT_TYPE');
2130:

Line 2219: l_contract_id := wf_engine.GetItemAttrNumber(

2215: 'Function mode is: ' || funcmode);
2216: END IF;
2217:
2218: IF (funcmode = 'RUN') THEN
2219: l_contract_id := wf_engine.GetItemAttrNumber(
2220: itemtype => itemtype,
2221: itemkey => itemkey,
2222: aname => 'CONTRACT_ID');
2223:

Line 2224: l_contract_type := wf_engine.GetItemAttrText(

2220: itemtype => itemtype,
2221: itemkey => itemkey,
2222: aname => 'CONTRACT_ID');
2223:
2224: l_contract_type := wf_engine.GetItemAttrText(
2225: itemtype => itemtype,
2226: itemkey => itemkey,
2227: aname => 'CONTRACT_TYPE');
2228:

Line 2229: l_con_req_id := wf_engine.GetItemAttrNumber(

2225: itemtype => itemtype,
2226: itemkey => itemkey,
2227: aname => 'CONTRACT_TYPE');
2228:
2229: l_con_req_id := wf_engine.GetItemAttrNumber(
2230: itemtype => itemtype,
2231: itemkey => itemkey,
2232: aname => 'CONC_REQUEST_ID' );
2233: