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.PO_CHANGEORDERWF_PVT dependencies on WF_NOTIFICATION

Line 1088: from wf_notifications a,

1084: --dbms_output.put_line('For std pos');
1085: begin
1086: select a.notification_id, a.recipient_role
1087: INTO l_nid, l_ntf_role_name
1088: from wf_notifications a,
1089: wf_item_activity_statuses wa
1090: where itemkey=wa.item_key
1091: and itemtype=wa.item_type
1092: and a.message_name in ('PO_EMAIL_PO_WITH_RESPONSE', 'PO_EMAIL_PO_PDF_WITH_RESPONSE')

Line 1103: from wf_notifications a,

1099: begin
1100: --dbms_output.put_line('For Releases');
1101: select a.notification_id, a.recipient_role
1102: INTO l_nid, l_ntf_role_name
1103: from wf_notifications a,
1104: wf_item_activity_statuses wa
1105: where itemkey=wa.item_key
1106: and itemtype=wa.item_type
1107: and a.message_name in ('PO_EMAIL_PO_WITH_RESPONSE', 'PO_EMAIL_PO_PDF_WITH_RESPONSE')

Line 1118: x_supp_user_name := wf_notification.responder(l_nid);

1114: if (l_nid is null) then
1115: --we do not want to continue if the notification is not closed.
1116: return;
1117: else
1118: x_supp_user_name := wf_notification.responder(l_nid);
1119: end if;
1120:
1121: if (substr(x_supp_user_name, 1, 6) = 'email:') then
1122: --Get the username and store that in the supplier_user_name.

Line 1953: WF_NOTIFICATION.WriteToClob(document,l_document);

1949:
1950:
1951:
1952:

';
1953: WF_NOTIFICATION.WriteToClob(document,l_document);
1954:
1955:
1956: lc_line_num := null;
1957: if(l_header_cancel = 'N') then

Line 2019: WF_NOTIFICATION.WriteToClob(document,l_document);

2015: '||fnd_message.get_string('PO','PO_WF_NOTIF_SPLIT')||'
2016:
2017: ';
2018:
2019: WF_NOTIFICATION.WriteToClob(document,l_document);
2020:
2021: open l_po_chg_req_csr(l_grp_id,l_requester_id);
2022: loop
2023: fetch l_po_chg_req_csr

Line 2252: WF_NOTIFICATION.WriteToClob(document,l_document);

2248: '
2249:
2250:
2251: ';
2252: WF_NOTIFICATION.WriteToClob(document,l_document);
2253:
2254: END LOOP;
2255: CLOSE l_po_chg_req_csr;
2256: WF_NOTIFICATION.WriteToClob(document, '

Line 2256: WF_NOTIFICATION.WriteToClob(document, '

2252: WF_NOTIFICATION.WriteToClob(document,l_document);
2253:
2254: END LOOP;
2255: CLOSE l_po_chg_req_csr;
2256: WF_NOTIFICATION.WriteToClob(document, '
2257:

2258: ');
2259:
2260:

Line 2269: WF_NOTIFICATION.WriteToClob(document,l_document);

2265:
2266: if(l_additional_changes is not null) then
2267: l_document := '
'||fnd_message.get_string('PO','PO_WF_NOTIF_ADD_CHN_REQ')||''||
2268: ' ` '||l_additional_changes||'
';
2269: WF_NOTIFICATION.WriteToClob(document,l_document);
2270: end if;
2271:
2272: else
2273: fnd_message.set_name('PO','PO_WF_NOTIF_CAN_ENTIER');

Line 2276: WF_NOTIFICATION.WriteToClob(document,l_document);

2272: else
2273: fnd_message.set_name('PO','PO_WF_NOTIF_CAN_ENTIER');
2274: fnd_message.set_token('DOC',l_document_type);
2275: l_document := fnd_message.get;
2276: WF_NOTIFICATION.WriteToClob(document,l_document);
2277: end if;
2278: exception when others then
2279: WF_NOTIFICATION.WriteToClob(document,'Exception occured:'||sqlerrm);
2280: END GEN_NTF_FOR_REQ_SUP_CHN;

Line 2279: WF_NOTIFICATION.WriteToClob(document,'Exception occured:'||sqlerrm);

2275: l_document := fnd_message.get;
2276: WF_NOTIFICATION.WriteToClob(document,l_document);
2277: end if;
2278: exception when others then
2279: WF_NOTIFICATION.WriteToClob(document,'Exception occured:'||sqlerrm);
2280: END GEN_NTF_FOR_REQ_SUP_CHN;
2281:
2282:
2283: PROCEDURE GEN_NTF_FOR_PLAN_SUP_CHN( p_code IN varchar2,

Line 2785: WF_NOTIFICATION.WriteToClob(document,l_document);

2781:
2782:
2783:
2784:

';
2785: WF_NOTIFICATION.WriteToClob(document,l_document);
2786:
2787: lc_line_num := null;
2788: if(l_header_cancel = 'N') then
2789: open l_po_chg_req_csr(l_grp_id,l_planner_id);

Line 2846: WF_NOTIFICATION.WriteToClob(document,l_document);

2842: '||fnd_message.get_string('PO','PO_WF_NOTIF_SPLIT')||'
2843:
2844: ';
2845:
2846: WF_NOTIFICATION.WriteToClob(document,l_document);
2847:
2848: open l_po_chg_req_csr(l_grp_id,l_planner_id);
2849: loop
2850: fetch l_po_chg_req_csr

Line 3074: WF_NOTIFICATION.WriteToClob(document,l_document);

3070: '
3071:
3072:
3073: ';
3074: WF_NOTIFICATION.WriteToClob(document,l_document);
3075:
3076: END LOOP;
3077: CLOSE l_po_chg_req_csr;
3078: WF_NOTIFICATION.WriteToClob(document, '

Line 3078: WF_NOTIFICATION.WriteToClob(document, '

3074: WF_NOTIFICATION.WriteToClob(document,l_document);
3075:
3076: END LOOP;
3077: CLOSE l_po_chg_req_csr;
3078: WF_NOTIFICATION.WriteToClob(document, '
3079:

3080: ');
3081: end if;
3082: open l_header_changes_csr(l_grp_id);

Line 3089: WF_NOTIFICATION.WriteToClob(document,l_document);

3085:
3086: if(l_additional_changes is not null) then
3087: l_document := '
'||fnd_message.get_string('PO','PO_WF_NOTIF_ADD_CHN_REQ')||''||
3088: ' ` '||l_additional_changes||'
';
3089: WF_NOTIFICATION.WriteToClob(document,l_document);
3090: end if;
3091:
3092: else
3093: fnd_message.set_name('PO','PO_WF_NOTIF_CAN_ENTIER');

Line 3096: WF_NOTIFICATION.WriteToClob(document,l_document);

3092: else
3093: fnd_message.set_name('PO','PO_WF_NOTIF_CAN_ENTIER');
3094: fnd_message.set_token('DOC',l_document_type);
3095: l_document := fnd_message.get;
3096: WF_NOTIFICATION.WriteToClob(document,l_document);
3097: end if;
3098: exception when others then
3099: WF_NOTIFICATION.WriteToClob(document,'Exception occured:'||sqlerrm);
3100:

Line 3099: WF_NOTIFICATION.WriteToClob(document,'Exception occured:'||sqlerrm);

3095: l_document := fnd_message.get;
3096: WF_NOTIFICATION.WriteToClob(document,l_document);
3097: end if;
3098: exception when others then
3099: WF_NOTIFICATION.WriteToClob(document,'Exception occured:'||sqlerrm);
3100:
3101: END GEN_NTF_FOR_PLAN_SUP_CHN;
3102:
3103: /*

Line 3728: WF_NOTIFICATION.WriteToClob(document,l_document);

3724:
3725:
3726:
3727:

';
3728: WF_NOTIFICATION.WriteToClob(document,l_document);
3729:
3730: if(l_header_cancel = 'N') then
3731: open l_po_ack_csr(l_po_doc_id, l_rel_doc_id, l_revision_num);
3732: fetch l_po_ack_csr

Line 3770: WF_NOTIFICATION.WriteToClob(document,l_document);

3766: '||fnd_message.get_string('PO','PO_WF_NOTIF_REASON')||'
3767:
3768: ';
3769:
3770: WF_NOTIFICATION.WriteToClob(document,l_document);
3771: open l_po_ack_csr(l_po_doc_id, l_rel_doc_id, l_revision_num);
3772: loop
3773: fetch l_po_ack_csr
3774: into

Line 3843: WF_NOTIFICATION.WriteToClob(document,l_document);

3839: '
3840:
3841:
3842: ';
3843: WF_NOTIFICATION.WriteToClob(document,l_document);
3844:
3845: END LOOP;
3846: CLOSE l_po_ack_csr;
3847: WF_NOTIFICATION.WriteToClob(document, '

Line 3847: WF_NOTIFICATION.WriteToClob(document, '

3843: WF_NOTIFICATION.WriteToClob(document,l_document);
3844:
3845: END LOOP;
3846: CLOSE l_po_ack_csr;
3847: WF_NOTIFICATION.WriteToClob(document, '
3848:

3849: ');
3850: end if;
3851:

Line 3910: WF_NOTIFICATION.WriteToClob(document,l_document);

3906: '||fnd_message.get_string('PO','PO_WF_NOTIF_SPLIT')||'
3907:
3908: ';
3909:
3910: WF_NOTIFICATION.WriteToClob(document,l_document);
3911: --, l_po_doc_id, l_rel_doc_id
3912: open l_po_chg_req_csr(l_grp_id);
3913: loop
3914: fetch l_po_chg_req_csr

Line 4148: WF_NOTIFICATION.WriteToClob(document,l_document);

4144: '
4145:
4146:
4147: ';
4148: WF_NOTIFICATION.WriteToClob(document,l_document);
4149:
4150: END LOOP;
4151: CLOSE l_po_chg_req_csr;
4152: WF_NOTIFICATION.WriteToClob(document, '

Line 4152: WF_NOTIFICATION.WriteToClob(document, '

4148: WF_NOTIFICATION.WriteToClob(document,l_document);
4149:
4150: END LOOP;
4151: CLOSE l_po_chg_req_csr;
4152: WF_NOTIFICATION.WriteToClob(document, '
4153:

4154: ');
4155: end if;
4156: open l_header_changes_csr(l_grp_id);

Line 4163: WF_NOTIFICATION.WriteToClob(document,l_document);

4159:
4160: if(l_additional_changes is not null) then
4161: l_document := '
'||fnd_message.get_string('PO','PO_WF_NOTIF_ADD_CHN_REQ')||''||
4162: ' ` '||l_additional_changes||'
';
4163: WF_NOTIFICATION.WriteToClob(document,l_document);
4164: end if;
4165: else
4166: fnd_message.set_name('PO','PO_WF_NOTIF_CAN_ENTIER');
4167: fnd_message.set_token('DOC',l_document_type);

Line 4169: WF_NOTIFICATION.WriteToClob(document,l_document);

4165: else
4166: fnd_message.set_name('PO','PO_WF_NOTIF_CAN_ENTIER');
4167: fnd_message.set_token('DOC',l_document_type);
4168: l_document := fnd_message.get;
4169: WF_NOTIFICATION.WriteToClob(document,l_document);
4170: end if;
4171: exception when others then
4172: IF g_fnd_debug = 'Y' THEN
4173: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

Line 4176: WF_NOTIFICATION.WriteToClob(document,'Exception occured:'||sqlerrm); */

4172: IF g_fnd_debug = 'Y' THEN
4173: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
4174: l_api_name || '.others_exception', l_progress||':'||sqlerrm);
4175: END IF;
4176: WF_NOTIFICATION.WriteToClob(document,'Exception occured:'||sqlerrm); */
4177: null;
4178:
4179: END GEN_NTF_FOR_BUYER_SUP_CHG;
4180:

Line 4633: WF_Notification.WriteToClob(document,l_document);

4629:
4630:
4631:

';
4632:
4633: WF_Notification.WriteToClob(document,l_document);
4634: if(l_header_cancel = 'N') then
4635: l_document := ''||fnd_message.get_string('PO', 'PO_WF_NOTIF_PO_DETAILS')||'

';
4636: --LEGENDS
4637: l_document := l_document||''|| NL;

Line 4666: WF_NOTIFICATION.WriteToClob(document,l_document);

4662:

4663:
4664:
4665: ';
4666: WF_NOTIFICATION.WriteToClob(document,l_document);
4667: open l_po_chg_req_csr(p_chg_req_grp_id);
4668: loop
4669: fetch l_po_chg_req_csr
4670: into

Line 4895: WF_NOTIFICATION.WriteToClob(document,l_document);

4891: '
4892:
4893:
4894: ';
4895: WF_NOTIFICATION.WriteToClob(document,l_document);
4896: END LOOP;
4897: CLOSE l_po_chg_req_csr;
4898: WF_NOTIFICATION.WriteToClob(document, '
4899:

'\|\|fnd_message.get_string('PO','PO_WF_NOTIF_REASON')\|\|'	'\|\|fnd_message.get_string('PO','PO_WF_NOTIF_SPLIT')\|\|'

Line 4898: WF_NOTIFICATION.WriteToClob(document, '

4894: ';
4895: WF_NOTIFICATION.WriteToClob(document,l_document);
4896: END LOOP;
4897: CLOSE l_po_chg_req_csr;
4898: WF_NOTIFICATION.WriteToClob(document, '
4899:

4900: ');
4901: open l_header_changes_csr(p_chg_req_grp_id);
4902: fetch l_header_changes_csr into l_additional_changes, l_header_response ;

Line 4924: WF_NOTIFICATION.WriteToClob(document,l_document);

4920:
4921: '' ||
4922: '';
4923:
4924: WF_NOTIFICATION.WriteToClob(document,l_document);
4925: end if;
4926:
4927: else --if header_cnacel = N
4928: if(l_header_response = 'ACCEPTED') then

Line 4937: WF_NOTIFICATION.WriteToClob(document,l_document);

4933: fnd_message.set_name('PO','PO_WF_NOTIF_BUY_RESP_CAN');
4934: fnd_message.set_token('DOC',l_doc_hdr_info);
4935: fnd_message.set_token('RESPONSE',l_header_response);
4936: l_document := fnd_message.get;
4937: WF_NOTIFICATION.WriteToClob(document,l_document);
4938: end if;
4939: else
4940: WF_NOTIFICATION.WriteToClob(document,'GEN_NTF_FOR_SUP_BUY_RP for no html customer');
4941: end if;

Line 4940: WF_NOTIFICATION.WriteToClob(document,'GEN_NTF_FOR_SUP_BUY_RP for no html customer');

4936: l_document := fnd_message.get;
4937: WF_NOTIFICATION.WriteToClob(document,l_document);
4938: end if;
4939: else
4940: WF_NOTIFICATION.WriteToClob(document,'GEN_NTF_FOR_SUP_BUY_RP for no html customer');
4941: end if;
4942: exception when others then
4943: IF g_fnd_debug = 'Y' THEN
4944: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

Line 4947: WF_NOTIFICATION.WriteToClob(document,'Exception occured:'||sqlerrm); */

4943: IF g_fnd_debug = 'Y' THEN
4944: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
4945: l_api_name || '.others_exception', l_progress||':'||sqlerrm);
4946: END IF;
4947: WF_NOTIFICATION.WriteToClob(document,'Exception occured:'||sqlerrm); */
4948: null;
4949:
4950: END GEN_NTF_FOR_SUP_BUY_RP;
4951: