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

Line 1181: /* Use the 'WF_Notification.send' procedure to send the notification */

1177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1178: END IF;
1179: END IF;
1180:
1181: /* Use the 'WF_Notification.send' procedure to send the notification */
1182:
1183: l_notif_id := WF_Notification.send ( role => l_role_name
1184: , msg_type => 'PVXNUTIL'
1185: -- , msg_name => 'DOC_MESSAGE');

Line 1183: l_notif_id := WF_Notification.send ( role => l_role_name

1179: END IF;
1180:
1181: /* Use the 'WF_Notification.send' procedure to send the notification */
1182:
1183: l_notif_id := WF_Notification.send ( role => l_role_name
1184: , msg_type => 'PVXNUTIL'
1185: -- , msg_name => 'DOC_MESSAGE');
1186: , msg_name => 'ALERT_MESSAGE');
1187: /* Set all the entity attributes by replacing the supplyied parameters.*/

Line 1188: -- WF_Notification.SetAttrText(l_notif_id,'DOCUMENT_ID', 'PVXNUTIL:'||l_notif_id);

1184: , msg_type => 'PVXNUTIL'
1185: -- , msg_name => 'DOC_MESSAGE');
1186: , msg_name => 'ALERT_MESSAGE');
1187: /* Set all the entity attributes by replacing the supplyied parameters.*/
1188: -- WF_Notification.SetAttrText(l_notif_id,'DOCUMENT_ID', 'PVXNUTIL:'||l_notif_id);
1189: /* Set the Vendor Name */
1190: /*
1191: fnd_message.set_name('PV', 'PV_VENDOR_NM');
1192: fnd_message.set_token('PV_VENDOR_NAME', l_vendor_name);

Line 1193: WF_Notification.SetAttrText (l_notif_id, 'PV_VENDOR_NM', fnd_message.get);

1189: /* Set the Vendor Name */
1190: /*
1191: fnd_message.set_name('PV', 'PV_VENDOR_NM');
1192: fnd_message.set_token('PV_VENDOR_NAME', l_vendor_name);
1193: WF_Notification.SetAttrText (l_notif_id, 'PV_VENDOR_NM', fnd_message.get);
1194: */
1195:
1196: -- Set the subject line
1197: fnd_message.set_name('PV', 'PV_NTF_THANKYOU_SUBJECT');

Line 1199: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);

1195:
1196: -- Set the subject line
1197: fnd_message.set_name('PV', 'PV_NTF_THANKYOU_SUBJECT');
1198: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);
1199: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);
1200:
1201:
1202: -- Set the Message Header
1203: fnd_message.set_name('PV', 'PV_NTF_ENRL_ALERT');

Line 1248: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);

1244: l_message_footer := l_newline || fnd_message.get_string('PV', 'PV_NTF_ALERT_THANKS') || l_newline;
1245: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ALERT_CLOSING')|| l_newline;
1246: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ENROLLMENT_TEAM') || l_newline;
1247:
1248: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);
1249: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_BODY', l_message_body);
1250: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_FOOTER', l_message_footer);
1251:
1252: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);

Line 1249: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_BODY', l_message_body);

1245: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ALERT_CLOSING')|| l_newline;
1246: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ENROLLMENT_TEAM') || l_newline;
1247:
1248: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);
1249: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_BODY', l_message_body);
1250: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_FOOTER', l_message_footer);
1251:
1252: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);
1253:

Line 1250: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_FOOTER', l_message_footer);

1246: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ENROLLMENT_TEAM') || l_newline;
1247:
1248: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);
1249: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_BODY', l_message_body);
1250: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_FOOTER', l_message_footer);
1251:
1252: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);
1253:
1254: /* Set the record for Create_Ge_Party_Notif API */

Line 1252: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);

1248: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);
1249: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_BODY', l_message_body);
1250: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_FOOTER', l_message_footer);
1251:
1252: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);
1253:
1254: /* Set the record for Create_Ge_Party_Notif API */
1255: Set_Pgp_Notif(
1256: p_notif_id => l_notif_id,

Line 1651: /* Use the 'WF_Notification.send' procedure to send the notification */

1647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1648: END IF;
1649: END IF;
1650:
1651: /* Use the 'WF_Notification.send' procedure to send the notification */
1652:
1653: l_notif_id := WF_Notification.send (
1654: role => l_role_name
1655: , msg_type => l_item_type

Line 1653: l_notif_id := WF_Notification.send (

1649: END IF;
1650:
1651: /* Use the 'WF_Notification.send' procedure to send the notification */
1652:
1653: l_notif_id := WF_Notification.send (
1654: role => l_role_name
1655: , msg_type => l_item_type
1656: , msg_name => l_message_name );
1657:

Line 1658: WF_Notification.SetAttrText(l_notif_id,'NOTIF_DOC_ID', 'PVXNUTIL:'||l_notif_id); -- passing the doc id

1654: role => l_role_name
1655: , msg_type => l_item_type
1656: , msg_name => l_message_name );
1657:
1658: WF_Notification.SetAttrText(l_notif_id,'NOTIF_DOC_ID', 'PVXNUTIL:'||l_notif_id); -- passing the doc id
1659:
1660: /* Set the subject line */
1661: fnd_message.set_name('PV', 'PV_NTF_WELCOME_SUBJECT');
1662: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);

Line 1663: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);

1659:
1660: /* Set the subject line */
1661: fnd_message.set_name('PV', 'PV_NTF_WELCOME_SUBJECT');
1662: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);
1663: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);
1664:
1665: /* Set the Message Header */
1666: fnd_message.set_name('PV', 'PV_NTF_ENRL_ALERT');
1667: fnd_message.set_token('PV_VENDOR_NM', l_vendor_name);

Line 1675: WF_Notification.SetAttrText (l_notif_id, 'PV_VENDOR_NM', fnd_message.get);

1671:
1672: /* Set the Vendor Name
1673: fnd_message.set_name('PV', 'PV_VENDOR_NM');
1674: fnd_message.set_token('PV_VENDOR_NAME', l_vendor_name);
1675: WF_Notification.SetAttrText (l_notif_id, 'PV_VENDOR_NM', fnd_message.get);
1676: */
1677:
1678: /* Set the welcome greeting Line */
1679: fnd_message.set_name('PV', 'PV_NTF_WELCOME_GREETINGS');

Line 1746: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);

1742: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ALERT_CLOSING')|| l_newline;
1743: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ENROLLMENT_TEAM') || l_newline;
1744:
1745:
1746: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);
1747: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_BODY', l_message_body);
1748: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_FOOTER', l_message_footer);
1749:
1750: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);

Line 1747: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_BODY', l_message_body);

1743: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ENROLLMENT_TEAM') || l_newline;
1744:
1745:
1746: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);
1747: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_BODY', l_message_body);
1748: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_FOOTER', l_message_footer);
1749:
1750: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);
1751:

Line 1748: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_FOOTER', l_message_footer);

1744:
1745:
1746: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);
1747: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_BODY', l_message_body);
1748: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_FOOTER', l_message_footer);
1749:
1750: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);
1751:
1752: /* Set the record for Create_Ge_Party_Notif API */

Line 1750: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);

1746: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);
1747: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_BODY', l_message_body);
1748: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_FOOTER', l_message_footer);
1749:
1750: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);
1751:
1752: /* Set the record for Create_Ge_Party_Notif API */
1753: Set_Pgp_Notif(
1754: p_notif_id => l_notif_id,

Line 2167: /* Use the 'WF_Notification.send' procedure to send the notification */

2163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2164: END IF;
2165: END IF;
2166:
2167: /* Use the 'WF_Notification.send' procedure to send the notification */
2168: l_notif_id := WF_Notification.send (
2169: role => l_role_name
2170: , msg_type => l_item_type
2171: , msg_name => l_message_name );

Line 2168: l_notif_id := WF_Notification.send (

2164: END IF;
2165: END IF;
2166:
2167: /* Use the 'WF_Notification.send' procedure to send the notification */
2168: l_notif_id := WF_Notification.send (
2169: role => l_role_name
2170: , msg_type => l_item_type
2171: , msg_name => l_message_name );
2172:

Line 2174: -- WF_Notification.SetAttrText(l_notif_id,'DOCUMENT_ID', 'PVXNUTIL:'||l_notif_id);

2170: , msg_type => l_item_type
2171: , msg_name => l_message_name );
2172:
2173: /* Set all the entity attributes by replacing the supplyied parameters. */
2174: -- WF_Notification.SetAttrText(l_notif_id,'DOCUMENT_ID', 'PVXNUTIL:'||l_notif_id);
2175: /* Set the Vendor Name */
2176: /*
2177: fnd_message.set_name('PV', 'PV_VENDOR_NM');
2178: fnd_message.set_token('PV_VENDOR_NAME', l_vendor_name);

Line 2179: WF_Notification.SetAttrText (l_notif_id, 'PV_VENDOR_NM', fnd_message.get);

2175: /* Set the Vendor Name */
2176: /*
2177: fnd_message.set_name('PV', 'PV_VENDOR_NM');
2178: fnd_message.set_token('PV_VENDOR_NAME', l_vendor_name);
2179: WF_Notification.SetAttrText (l_notif_id, 'PV_VENDOR_NM', fnd_message.get);
2180: */
2181:
2182: /* Set the subject line */
2183: fnd_message.set_name('PV', 'PV_NTF_REJECTION_SUBJECT');

Line 2185: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);

2181:
2182: /* Set the subject line */
2183: fnd_message.set_name('PV', 'PV_NTF_REJECTION_SUBJECT');
2184: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);
2185: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);
2186:
2187: /* Set the Message Header */
2188: fnd_message.set_name('PV', 'PV_NTF_ENRL_ALERT');
2189: fnd_message.set_token('PV_VENDOR_NM', l_vendor_name);

Line 2191: -- WF_Notification.SetAttrText (l_notif_id, 'MESSAGE_HEADER', l_message_hdr);

2187: /* Set the Message Header */
2188: fnd_message.set_name('PV', 'PV_NTF_ENRL_ALERT');
2189: fnd_message.set_token('PV_VENDOR_NM', l_vendor_name);
2190: l_message_hdr := fnd_message.get || l_newline;
2191: -- WF_Notification.SetAttrText (l_notif_id, 'MESSAGE_HEADER', l_message_hdr);
2192:
2193: /* Set the Message Body */
2194: fnd_message.set_name('PV', 'PV_NTF_REJECTION_MESG');
2195: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);

Line 2229: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);

2225: l_message_footer := l_newline || fnd_message.get_string('PV', 'PV_NTF_ALERT_THANKS') || l_newline;
2226: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ALERT_CLOSING')|| l_newline;
2227: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ENROLLMENT_TEAM') || l_newline;
2228:
2229: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);
2230: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_BODY', l_message_body);
2231: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_FOOTER', l_message_footer);
2232:
2233: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);

Line 2230: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_BODY', l_message_body);

2226: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ALERT_CLOSING')|| l_newline;
2227: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ENROLLMENT_TEAM') || l_newline;
2228:
2229: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);
2230: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_BODY', l_message_body);
2231: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_FOOTER', l_message_footer);
2232:
2233: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);
2234:

Line 2231: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_FOOTER', l_message_footer);

2227: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ENROLLMENT_TEAM') || l_newline;
2228:
2229: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);
2230: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_BODY', l_message_body);
2231: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_FOOTER', l_message_footer);
2232:
2233: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);
2234:
2235: /* Set the record for Create_Ge_Party_Notif API */

Line 2233: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);

2229: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);
2230: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_BODY', l_message_body);
2231: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_FOOTER', l_message_footer);
2232:
2233: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);
2234:
2235: /* Set the record for Create_Ge_Party_Notif API */
2236: Set_Pgp_Notif(
2237: p_notif_id => l_notif_id,

Line 2626: /* Use the 'WF_Notification.send' procedure to send the notification */

2622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2623: END IF;
2624: END IF;
2625:
2626: /* Use the 'WF_Notification.send' procedure to send the notification */
2627: l_notif_id := WF_Notification.send (
2628: role => l_role_name
2629: , msg_type => l_item_type
2630: , msg_name => l_message_name );

Line 2627: l_notif_id := WF_Notification.send (

2623: END IF;
2624: END IF;
2625:
2626: /* Use the 'WF_Notification.send' procedure to send the notification */
2627: l_notif_id := WF_Notification.send (
2628: role => l_role_name
2629: , msg_type => l_item_type
2630: , msg_name => l_message_name );
2631:

Line 2633: -- WF_Notification.SetAttrText(l_notif_id,'DOCUMENT_ID', 'PVXNUTIL:'||l_notif_id);

2629: , msg_type => l_item_type
2630: , msg_name => l_message_name );
2631:
2632: /* Set all the entity attributes by replacing the supplied parameters. */
2633: -- WF_Notification.SetAttrText(l_notif_id,'DOCUMENT_ID', 'PVXNUTIL:'||l_notif_id);
2634:
2635: /* Set the subject line */
2636: fnd_message.set_name('PV', 'PV_NTF_CONTRACT_SUBJECT');
2637: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);

Line 2638: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);

2634:
2635: /* Set the subject line */
2636: fnd_message.set_name('PV', 'PV_NTF_CONTRACT_SUBJECT');
2637: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);
2638: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);
2639:
2640: /* Set the Message Header */
2641: fnd_message.set_name('PV', 'PV_NTF_ENRL_ALERT');
2642: fnd_message.set_token('PV_VENDOR_NM', l_vendor_name);

Line 2649: WF_Notification.SetAttrText (l_notif_id, 'PV_VENDOR_NM', fnd_message.get);

2645: /* Set the Vendor Name */
2646: /*
2647: fnd_message.set_name('PV', 'PV_VENDOR_NM');
2648: fnd_message.set_token('PV_VENDOR_NAME', l_vendor_name);
2649: WF_Notification.SetAttrText (l_notif_id, 'PV_VENDOR_NM', fnd_message.get);
2650: */
2651:
2652: l_message_body := fnd_message.get_string('PV', 'PV_NTF_CONTRACT_MESG')|| l_newline;
2653: l_message_body := l_message_body || l_newline;

Line 2689: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);

2685: l_message_footer := l_newline || fnd_message.get_string('PV', 'PV_NTF_ALERT_THANKS') || l_newline;
2686: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ALERT_CLOSING')|| l_newline;
2687: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ENROLLMENT_TEAM') || l_newline;
2688:
2689: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);
2690: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_BODY', l_message_body);
2691: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_FOOTER', l_message_footer);
2692:
2693: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);

Line 2690: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_BODY', l_message_body);

2686: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ALERT_CLOSING')|| l_newline;
2687: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ENROLLMENT_TEAM') || l_newline;
2688:
2689: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);
2690: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_BODY', l_message_body);
2691: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_FOOTER', l_message_footer);
2692:
2693: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);
2694:

Line 2691: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_FOOTER', l_message_footer);

2687: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ENROLLMENT_TEAM') || l_newline;
2688:
2689: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);
2690: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_BODY', l_message_body);
2691: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_FOOTER', l_message_footer);
2692:
2693: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);
2694:
2695: /* Set the record for Create_Ge_Party_Notif API */

Line 2693: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);

2689: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);
2690: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_BODY', l_message_body);
2691: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_FOOTER', l_message_footer);
2692:
2693: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);
2694:
2695: /* Set the record for Create_Ge_Party_Notif API */
2696: Set_Pgp_Notif(
2697: p_notif_id => l_notif_id,

Line 3120: /* Use the 'WF_Notification.send' procedure to send the notification */

3116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3117: END IF;
3118: END IF;
3119:
3120: /* Use the 'WF_Notification.send' procedure to send the notification */
3121: l_notif_id := WF_Notification.send (
3122: role => l_role_name
3123: , msg_type => l_item_type
3124: , msg_name => l_message_name );

Line 3121: l_notif_id := WF_Notification.send (

3117: END IF;
3118: END IF;
3119:
3120: /* Use the 'WF_Notification.send' procedure to send the notification */
3121: l_notif_id := WF_Notification.send (
3122: role => l_role_name
3123: , msg_type => l_item_type
3124: , msg_name => l_message_name );
3125:

Line 3126: WF_Notification.SetAttrText(l_notif_id,'NOTIF_DOC_ID', 'PVXNUTIL:'||l_notif_id); -- passing the doc id

3122: role => l_role_name
3123: , msg_type => l_item_type
3124: , msg_name => l_message_name );
3125:
3126: WF_Notification.SetAttrText(l_notif_id,'NOTIF_DOC_ID', 'PVXNUTIL:'||l_notif_id); -- passing the doc id
3127:
3128: /* Set the subject line */
3129: fnd_message.set_name('PV', 'PV_NTF_EXPIRY_SUBJECT');
3130: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);

Line 3131: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);

3127:
3128: /* Set the subject line */
3129: fnd_message.set_name('PV', 'PV_NTF_EXPIRY_SUBJECT');
3130: fnd_message.set_token('PV_PARTNER_PROGRAM', l_partner_program);
3131: WF_Notification.SetAttrText (l_notif_id, 'SUBJECT', fnd_message.get);
3132:
3133: /* Set the Message Header */
3134: fnd_message.set_name('PV', 'PV_NTF_ENRL_ALERT');
3135: fnd_message.set_token('PV_VENDOR_NM', l_vendor_name);

Line 3144: WF_Notification.SetAttrText (l_notif_id, 'PV_VENDOR_NM', fnd_message.get);

3140: /* Set the Vendor Name */
3141: /*
3142: fnd_message.set_name('PV', 'PV_VENDOR_NM');
3143: fnd_message.set_token('PV_VENDOR_NAME', l_vendor_name);
3144: WF_Notification.SetAttrText (l_notif_id, 'PV_VENDOR_NM', fnd_message.get);
3145: */
3146:
3147: l_message_body := fnd_message.get_string('PV', 'PV_NTF_EXPIRY_MESG')|| l_newline;
3148: l_message_body := l_message_body || l_newline;

Line 3202: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);

3198: l_message_footer := l_newline || fnd_message.get_string('PV', 'PV_NTF_ALERT_THANKS') || l_newline;
3199: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ALERT_CLOSING')|| l_newline;
3200: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ENROLLMENT_TEAM') || l_newline;
3201:
3202: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);
3203: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_BODY', l_message_body);
3204: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_FOOTER', l_message_footer);
3205:
3206: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);

Line 3203: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_BODY', l_message_body);

3199: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ALERT_CLOSING')|| l_newline;
3200: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ENROLLMENT_TEAM') || l_newline;
3201:
3202: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);
3203: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_BODY', l_message_body);
3204: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_FOOTER', l_message_footer);
3205:
3206: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);
3207:

Line 3204: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_FOOTER', l_message_footer);

3200: l_message_footer := l_message_footer || fnd_message.get_string('PV', 'PV_NTF_ENROLLMENT_TEAM') || l_newline;
3201:
3202: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);
3203: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_BODY', l_message_body);
3204: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_FOOTER', l_message_footer);
3205:
3206: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);
3207:
3208: /* Set the record for Create_Ge_Party_Notif API */

Line 3206: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);

3202: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_HEADER', l_message_hdr);
3203: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_BODY', l_message_body);
3204: WF_Notification.SetAttrText(l_notif_id,'MESSAGE_FOOTER', l_message_footer);
3205:
3206: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);
3207:
3208: /* Set the record for Create_Ge_Party_Notif API */
3209: Set_Pgp_Notif(
3210: p_notif_id => l_notif_id,

Line 3557: l_notif_id := WF_Notification.send ( role => l_role_name

3553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3554: END IF;
3555: END IF;
3556:
3557: l_notif_id := WF_Notification.send ( role => l_role_name
3558: , msg_type => l_item_type
3559: , msg_name => l_message_name );
3560:
3561: -- WF_Notification.SetAttrText(l_notif_id,'DOCUMENT_ID', 'PVXNUTIL:'||l_notif_id);

Line 3561: -- WF_Notification.SetAttrText(l_notif_id,'DOCUMENT_ID', 'PVXNUTIL:'||l_notif_id);

3557: l_notif_id := WF_Notification.send ( role => l_role_name
3558: , msg_type => l_item_type
3559: , msg_name => l_message_name );
3560:
3561: -- WF_Notification.SetAttrText(l_notif_id,'DOCUMENT_ID', 'PVXNUTIL:'||l_notif_id);
3562: /* Set all entity attributes by replacing the supplied parameters. */
3563: WF_Notification.SetAttrText(l_notif_id, 'SUBJECT',p_mbrship_chng_rec.MESSAGE_SUBJ );
3564:
3565: WF_Notification.SetAttrText(l_notif_id, 'MESSAGE_HEADER', l_message_hdr);

Line 3563: WF_Notification.SetAttrText(l_notif_id, 'SUBJECT',p_mbrship_chng_rec.MESSAGE_SUBJ );

3559: , msg_name => l_message_name );
3560:
3561: -- WF_Notification.SetAttrText(l_notif_id,'DOCUMENT_ID', 'PVXNUTIL:'||l_notif_id);
3562: /* Set all entity attributes by replacing the supplied parameters. */
3563: WF_Notification.SetAttrText(l_notif_id, 'SUBJECT',p_mbrship_chng_rec.MESSAGE_SUBJ );
3564:
3565: WF_Notification.SetAttrText(l_notif_id, 'MESSAGE_HEADER', l_message_hdr);
3566: WF_Notification.SetAttrText(l_notif_id, 'MESSAGE_BODY',p_mbrship_chng_rec.MESSAGE_BODY );
3567: WF_Notification.SetAttrText(l_notif_id, 'MESSAGE_FOOTER', l_message_footer);

Line 3565: WF_Notification.SetAttrText(l_notif_id, 'MESSAGE_HEADER', l_message_hdr);

3561: -- WF_Notification.SetAttrText(l_notif_id,'DOCUMENT_ID', 'PVXNUTIL:'||l_notif_id);
3562: /* Set all entity attributes by replacing the supplied parameters. */
3563: WF_Notification.SetAttrText(l_notif_id, 'SUBJECT',p_mbrship_chng_rec.MESSAGE_SUBJ );
3564:
3565: WF_Notification.SetAttrText(l_notif_id, 'MESSAGE_HEADER', l_message_hdr);
3566: WF_Notification.SetAttrText(l_notif_id, 'MESSAGE_BODY',p_mbrship_chng_rec.MESSAGE_BODY );
3567: WF_Notification.SetAttrText(l_notif_id, 'MESSAGE_FOOTER', l_message_footer);
3568:
3569: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);

Line 3566: WF_Notification.SetAttrText(l_notif_id, 'MESSAGE_BODY',p_mbrship_chng_rec.MESSAGE_BODY );

3562: /* Set all entity attributes by replacing the supplied parameters. */
3563: WF_Notification.SetAttrText(l_notif_id, 'SUBJECT',p_mbrship_chng_rec.MESSAGE_SUBJ );
3564:
3565: WF_Notification.SetAttrText(l_notif_id, 'MESSAGE_HEADER', l_message_hdr);
3566: WF_Notification.SetAttrText(l_notif_id, 'MESSAGE_BODY',p_mbrship_chng_rec.MESSAGE_BODY );
3567: WF_Notification.SetAttrText(l_notif_id, 'MESSAGE_FOOTER', l_message_footer);
3568:
3569: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);
3570:

Line 3567: WF_Notification.SetAttrText(l_notif_id, 'MESSAGE_FOOTER', l_message_footer);

3563: WF_Notification.SetAttrText(l_notif_id, 'SUBJECT',p_mbrship_chng_rec.MESSAGE_SUBJ );
3564:
3565: WF_Notification.SetAttrText(l_notif_id, 'MESSAGE_HEADER', l_message_hdr);
3566: WF_Notification.SetAttrText(l_notif_id, 'MESSAGE_BODY',p_mbrship_chng_rec.MESSAGE_BODY );
3567: WF_Notification.SetAttrText(l_notif_id, 'MESSAGE_FOOTER', l_message_footer);
3568:
3569: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);
3570:
3571: /* Set the record for Set_Pgp_Notif API */

Line 3569: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);

3565: WF_Notification.SetAttrText(l_notif_id, 'MESSAGE_HEADER', l_message_hdr);
3566: WF_Notification.SetAttrText(l_notif_id, 'MESSAGE_BODY',p_mbrship_chng_rec.MESSAGE_BODY );
3567: WF_Notification.SetAttrText(l_notif_id, 'MESSAGE_FOOTER', l_message_footer);
3568:
3569: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);
3570:
3571: /* Set the record for Set_Pgp_Notif API */
3572: Set_Pgp_Notif(
3573: p_notif_id => l_notif_id,

Line 4535: WF_NOTIFICATION.GetFullBody( nid => p_notif_id

4531: --l_flag BOOLEAN DEFAULT FALSE;
4532:
4533: BEGIN
4534: /*
4535: WF_NOTIFICATION.GetFullBody( nid => p_notif_id
4536: , msgbody => l_msgBody
4537: , end_of_body => l_flag
4538: , disptype => l_disptype
4539: );

Line 4541: l_msgBody := WF_NOTIFICATION.getBody( nid => p_notif_id

4537: , end_of_body => l_flag
4538: , disptype => l_disptype
4539: );
4540: */
4541: l_msgBody := WF_NOTIFICATION.getBody( nid => p_notif_id
4542: , disptype => wf_notification.doc_html
4543: );
4544: RETURN l_msgBody;
4545: END get_Notification_Body;

Line 4542: , disptype => wf_notification.doc_html

4538: , disptype => l_disptype
4539: );
4540: */
4541: l_msgBody := WF_NOTIFICATION.getBody( nid => p_notif_id
4542: , disptype => wf_notification.doc_html
4543: );
4544: RETURN l_msgBody;
4545: END get_Notification_Body;
4546:

Line 4584: document := document || wf_notification.getAttrText(l_notif_id,'MESSAGE_HEADER');

4580: || document_id
4581: );
4582:
4583: l_notif_id := TO_NUMBER(SUBSTR(document_id,10)); --'PVXNUTIL:';
4584: document := document || wf_notification.getAttrText(l_notif_id,'MESSAGE_HEADER');
4585: document := document ||'
'||wf_notification.getAttrText(l_notif_id,'MESSAGE_BODY');
4586: document := document ||'
'||wf_notification.getAttrText(l_notif_id,'MESSAGE_FOOTER');
4587:
4588: document_type := wf_notification.doc_html;

Line 4585: document := document ||'
'||wf_notification.getAttrText(l_notif_id,'MESSAGE_BODY');

4581: );
4582:
4583: l_notif_id := TO_NUMBER(SUBSTR(document_id,10)); --'PVXNUTIL:';
4584: document := document || wf_notification.getAttrText(l_notif_id,'MESSAGE_HEADER');
4585: document := document ||'
'||wf_notification.getAttrText(l_notif_id,'MESSAGE_BODY');
4586: document := document ||'
'||wf_notification.getAttrText(l_notif_id,'MESSAGE_FOOTER');
4587:
4588: document_type := wf_notification.doc_html;
4589: -- document := document || g_message_body_doc;

Line 4586: document := document ||'
'||wf_notification.getAttrText(l_notif_id,'MESSAGE_FOOTER');

4582:
4583: l_notif_id := TO_NUMBER(SUBSTR(document_id,10)); --'PVXNUTIL:';
4584: document := document || wf_notification.getAttrText(l_notif_id,'MESSAGE_HEADER');
4585: document := document ||'
'||wf_notification.getAttrText(l_notif_id,'MESSAGE_BODY');
4586: document := document ||'
'||wf_notification.getAttrText(l_notif_id,'MESSAGE_FOOTER');
4587:
4588: document_type := wf_notification.doc_html;
4589: -- document := document || g_message_body_doc;
4590: RETURN;

Line 4588: document_type := wf_notification.doc_html;

4584: document := document || wf_notification.getAttrText(l_notif_id,'MESSAGE_HEADER');
4585: document := document ||'
'||wf_notification.getAttrText(l_notif_id,'MESSAGE_BODY');
4586: document := document ||'
'||wf_notification.getAttrText(l_notif_id,'MESSAGE_FOOTER');
4587:
4588: document_type := wf_notification.doc_html;
4589: -- document := document || g_message_body_doc;
4590: RETURN;
4591: END set_msg_doc;
4592: