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

Line 1363: p_notification_id := WF_NOTIFICATION.send(role => bidder.trading_partner_contact_name,

1359: aname => 'BIDDER_DISPLAY_NAME',
1360: avalue => bidder.trading_partner_contact_name);
1361:
1362:
1363: p_notification_id := WF_NOTIFICATION.send(role => bidder.trading_partner_contact_name,
1364: context => p_itemtype||':'||p_itemkey||':'||to_char(p_actid),
1365: msg_type => 'PONAUCT',
1366: msg_name => p_message_name);
1367: END LOOP;

Line 3407: x_nid := WF_NOTIFICATION.send(role => p_user ,

3403: aname => 'DOC_INTERNAL_NAME'));
3404:
3405: UNSET_SESSION_LANGUAGE;
3406:
3407: x_nid := WF_NOTIFICATION.send(role => p_user ,
3408: context => itemtype||':'||itemkey||':'||actid,
3409: msg_type => itemtype,
3410: msg_name => p_message_name);
3411:

Line 3429: wf_Notification.setAttrText(x_nid, 'STAGGERED_CLOSE_NOTE', x_staggered_close_note);

3425: x_staggered_close_note := wf_core.newline || wf_core.newline ||
3426: getMessage('PON_STAGGERED_CLOSE_NOTIF_MSG') ||
3427: wf_core.newline || wf_core.newline;
3428: END IF;
3429: wf_Notification.setAttrText(x_nid, 'STAGGERED_CLOSE_NOTE', x_staggered_close_note);
3430:
3431: BEGIN
3432: wf_Notification.setAttrText(x_nid,'#WFM_HTMLAGENT', pon_wf_utl_pkg.get_base_external_supplier_url);
3433: EXCEPTION

Line 3432: wf_Notification.setAttrText(x_nid,'#WFM_HTMLAGENT', pon_wf_utl_pkg.get_base_external_supplier_url);

3428: END IF;
3429: wf_Notification.setAttrText(x_nid, 'STAGGERED_CLOSE_NOTE', x_staggered_close_note);
3430:
3431: BEGIN
3432: wf_Notification.setAttrText(x_nid,'#WFM_HTMLAGENT', pon_wf_utl_pkg.get_base_external_supplier_url);
3433: EXCEPTION
3434: WHEN OTHERS THEN
3435: NULL;
3436: END;

Line 3515: wf_Notification.setAttrDate(x_nid, 'AUCTION_START_DATE', x_new_auction_start_date);

3511: x_timezone1_disp := null;
3512: END IF;
3513:
3514: -- Setup common attributes
3515: wf_Notification.setAttrDate(x_nid, 'AUCTION_START_DATE', x_new_auction_start_date);
3516: wf_Notification.setAttrDate(x_nid, 'AUCTION_END_DATE', x_new_auction_end_date);
3517: wf_Notification.SetAttrDate(x_nid, 'PREVIEW_DATE', x_new_auction_preview_date);
3518: wf_Notification.SetAttrText(x_nid, 'TP_TIME_ZONE1', x_timezone1_disp);
3519: wf_Notification.setAttrText(x_nid, '#HDR_NEG_TITLE', p_auction_title);

Line 3516: wf_Notification.setAttrDate(x_nid, 'AUCTION_END_DATE', x_new_auction_end_date);

3512: END IF;
3513:
3514: -- Setup common attributes
3515: wf_Notification.setAttrDate(x_nid, 'AUCTION_START_DATE', x_new_auction_start_date);
3516: wf_Notification.setAttrDate(x_nid, 'AUCTION_END_DATE', x_new_auction_end_date);
3517: wf_Notification.SetAttrDate(x_nid, 'PREVIEW_DATE', x_new_auction_preview_date);
3518: wf_Notification.SetAttrText(x_nid, 'TP_TIME_ZONE1', x_timezone1_disp);
3519: wf_Notification.setAttrText(x_nid, '#HDR_NEG_TITLE', p_auction_title);
3520: wf_Notification.setAttrText(x_nid, '#HDR_NEG_NUMBER', p_doc_number_dsp);

Line 3517: wf_Notification.SetAttrDate(x_nid, 'PREVIEW_DATE', x_new_auction_preview_date);

3513:
3514: -- Setup common attributes
3515: wf_Notification.setAttrDate(x_nid, 'AUCTION_START_DATE', x_new_auction_start_date);
3516: wf_Notification.setAttrDate(x_nid, 'AUCTION_END_DATE', x_new_auction_end_date);
3517: wf_Notification.SetAttrDate(x_nid, 'PREVIEW_DATE', x_new_auction_preview_date);
3518: wf_Notification.SetAttrText(x_nid, 'TP_TIME_ZONE1', x_timezone1_disp);
3519: wf_Notification.setAttrText(x_nid, '#HDR_NEG_TITLE', p_auction_title);
3520: wf_Notification.setAttrText(x_nid, '#HDR_NEG_NUMBER', p_doc_number_dsp);
3521: wf_Notification.setAttrText(x_nid, '#HDR_NEG_TP_NAME', wf_engine.GetItemAttrText (itemtype => itemtype,

Line 3518: wf_Notification.SetAttrText(x_nid, 'TP_TIME_ZONE1', x_timezone1_disp);

3514: -- Setup common attributes
3515: wf_Notification.setAttrDate(x_nid, 'AUCTION_START_DATE', x_new_auction_start_date);
3516: wf_Notification.setAttrDate(x_nid, 'AUCTION_END_DATE', x_new_auction_end_date);
3517: wf_Notification.SetAttrDate(x_nid, 'PREVIEW_DATE', x_new_auction_preview_date);
3518: wf_Notification.SetAttrText(x_nid, 'TP_TIME_ZONE1', x_timezone1_disp);
3519: wf_Notification.setAttrText(x_nid, '#HDR_NEG_TITLE', p_auction_title);
3520: wf_Notification.setAttrText(x_nid, '#HDR_NEG_NUMBER', p_doc_number_dsp);
3521: wf_Notification.setAttrText(x_nid, '#HDR_NEG_TP_NAME', wf_engine.GetItemAttrText (itemtype => itemtype,
3522: itemkey => itemkey,

Line 3519: wf_Notification.setAttrText(x_nid, '#HDR_NEG_TITLE', p_auction_title);

3515: wf_Notification.setAttrDate(x_nid, 'AUCTION_START_DATE', x_new_auction_start_date);
3516: wf_Notification.setAttrDate(x_nid, 'AUCTION_END_DATE', x_new_auction_end_date);
3517: wf_Notification.SetAttrDate(x_nid, 'PREVIEW_DATE', x_new_auction_preview_date);
3518: wf_Notification.SetAttrText(x_nid, 'TP_TIME_ZONE1', x_timezone1_disp);
3519: wf_Notification.setAttrText(x_nid, '#HDR_NEG_TITLE', p_auction_title);
3520: wf_Notification.setAttrText(x_nid, '#HDR_NEG_NUMBER', p_doc_number_dsp);
3521: wf_Notification.setAttrText(x_nid, '#HDR_NEG_TP_NAME', wf_engine.GetItemAttrText (itemtype => itemtype,
3522: itemkey => itemkey,
3523: aname =>'PREPARER_TP_NAME'));

Line 3520: wf_Notification.setAttrText(x_nid, '#HDR_NEG_NUMBER', p_doc_number_dsp);

3516: wf_Notification.setAttrDate(x_nid, 'AUCTION_END_DATE', x_new_auction_end_date);
3517: wf_Notification.SetAttrDate(x_nid, 'PREVIEW_DATE', x_new_auction_preview_date);
3518: wf_Notification.SetAttrText(x_nid, 'TP_TIME_ZONE1', x_timezone1_disp);
3519: wf_Notification.setAttrText(x_nid, '#HDR_NEG_TITLE', p_auction_title);
3520: wf_Notification.setAttrText(x_nid, '#HDR_NEG_NUMBER', p_doc_number_dsp);
3521: wf_Notification.setAttrText(x_nid, '#HDR_NEG_TP_NAME', wf_engine.GetItemAttrText (itemtype => itemtype,
3522: itemkey => itemkey,
3523: aname =>'PREPARER_TP_NAME'));
3524:

Line 3521: wf_Notification.setAttrText(x_nid, '#HDR_NEG_TP_NAME', wf_engine.GetItemAttrText (itemtype => itemtype,

3517: wf_Notification.SetAttrDate(x_nid, 'PREVIEW_DATE', x_new_auction_preview_date);
3518: wf_Notification.SetAttrText(x_nid, 'TP_TIME_ZONE1', x_timezone1_disp);
3519: wf_Notification.setAttrText(x_nid, '#HDR_NEG_TITLE', p_auction_title);
3520: wf_Notification.setAttrText(x_nid, '#HDR_NEG_NUMBER', p_doc_number_dsp);
3521: wf_Notification.setAttrText(x_nid, '#HDR_NEG_TP_NAME', wf_engine.GetItemAttrText (itemtype => itemtype,
3522: itemkey => itemkey,
3523: aname =>'PREPARER_TP_NAME'));
3524:
3525: wf_Notification.setAttrText(x_nid, '#FROM_ROLE', l_origin_user_name);

Line 3525: wf_Notification.setAttrText(x_nid, '#FROM_ROLE', l_origin_user_name);

3521: wf_Notification.setAttrText(x_nid, '#HDR_NEG_TP_NAME', wf_engine.GetItemAttrText (itemtype => itemtype,
3522: itemkey => itemkey,
3523: aname =>'PREPARER_TP_NAME'));
3524:
3525: wf_Notification.setAttrText(x_nid, '#FROM_ROLE', l_origin_user_name);
3526:
3527: IF (x_new_auction_preview_date is null) THEN
3528: wf_Notification.SetAttrText(x_nid, 'PREVIEW_DATE_NOTSPECIFIED', PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
3529:

Line 3528: wf_Notification.SetAttrText(x_nid, 'PREVIEW_DATE_NOTSPECIFIED', PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));

3524:
3525: wf_Notification.setAttrText(x_nid, '#FROM_ROLE', l_origin_user_name);
3526:
3527: IF (x_new_auction_preview_date is null) THEN
3528: wf_Notification.SetAttrText(x_nid, 'PREVIEW_DATE_NOTSPECIFIED', PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
3529:
3530: ELSE
3531: wf_Notification.SetAttrText(x_nid, 'PREVIEW_DATE_NOTSPECIFIED', wf_engine.GetItemAttrText (itemtype => itemtype,
3532: itemkey => itemkey,

Line 3531: wf_Notification.SetAttrText(x_nid, 'PREVIEW_DATE_NOTSPECIFIED', wf_engine.GetItemAttrText (itemtype => itemtype,

3527: IF (x_new_auction_preview_date is null) THEN
3528: wf_Notification.SetAttrText(x_nid, 'PREVIEW_DATE_NOTSPECIFIED', PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
3529:
3530: ELSE
3531: wf_Notification.SetAttrText(x_nid, 'PREVIEW_DATE_NOTSPECIFIED', wf_engine.GetItemAttrText (itemtype => itemtype,
3532: itemkey => itemkey,
3533: aname => 'PREVIEW_DATE_NOTSPECIFIED'));
3534: END IF;
3535:

Line 3537: wf_Notification.setAttrText(x_nid, 'BIDDER_TP_NAME', p_bidder_tp_name);

3533: aname => 'PREVIEW_DATE_NOTSPECIFIED'));
3534: END IF;
3535:
3536: if (p_action_code <> 'DISQUALIFY_BID') then
3537: wf_Notification.setAttrText(x_nid, 'BIDDER_TP_NAME', p_bidder_tp_name);
3538: wf_Notification.setAttrText(x_nid, 'BIDDER_TP_ADDRESS_NAME', p_vendor_site_code);
3539: end if;
3540:
3541: IF (p_action_code is not null and p_action_code = 'CLOSEEARLY') THEN

Line 3538: wf_Notification.setAttrText(x_nid, 'BIDDER_TP_ADDRESS_NAME', p_vendor_site_code);

3534: END IF;
3535:
3536: if (p_action_code <> 'DISQUALIFY_BID') then
3537: wf_Notification.setAttrText(x_nid, 'BIDDER_TP_NAME', p_bidder_tp_name);
3538: wf_Notification.setAttrText(x_nid, 'BIDDER_TP_ADDRESS_NAME', p_vendor_site_code);
3539: end if;
3540:
3541: IF (p_action_code is not null and p_action_code = 'CLOSEEARLY') THEN
3542:

Line 3543: wf_Notification.setAttrText(x_nid, 'TP_TIME_ZONE_AUCTION', x_timezone_disp);

3539: end if;
3540:
3541: IF (p_action_code is not null and p_action_code = 'CLOSEEARLY') THEN
3542:
3543: wf_Notification.setAttrText(x_nid, 'TP_TIME_ZONE_AUCTION', x_timezone_disp);
3544: wf_Notification.SetAttrText(x_nid, 'AUCTION_CLOSE_EARLY_SUB', x_close_early_subject);
3545: wf_Notification.SetAttrDate(x_nid, 'AUCTION_CLOSE_EARLY_DATE', x_new_close_early_date);
3546: wf_Notification.SetAttrText(x_nid, 'CLOSECHANGED_REASON', wf_engine.GetItemAttrText (itemtype => itemtype,
3547: itemkey => itemkey,

Line 3544: wf_Notification.SetAttrText(x_nid, 'AUCTION_CLOSE_EARLY_SUB', x_close_early_subject);

3540:
3541: IF (p_action_code is not null and p_action_code = 'CLOSEEARLY') THEN
3542:
3543: wf_Notification.setAttrText(x_nid, 'TP_TIME_ZONE_AUCTION', x_timezone_disp);
3544: wf_Notification.SetAttrText(x_nid, 'AUCTION_CLOSE_EARLY_SUB', x_close_early_subject);
3545: wf_Notification.SetAttrDate(x_nid, 'AUCTION_CLOSE_EARLY_DATE', x_new_close_early_date);
3546: wf_Notification.SetAttrText(x_nid, 'CLOSECHANGED_REASON', wf_engine.GetItemAttrText (itemtype => itemtype,
3547: itemkey => itemkey,
3548: aname => 'CLOSECHANGED_REASON'));

Line 3545: wf_Notification.SetAttrDate(x_nid, 'AUCTION_CLOSE_EARLY_DATE', x_new_close_early_date);

3541: IF (p_action_code is not null and p_action_code = 'CLOSEEARLY') THEN
3542:
3543: wf_Notification.setAttrText(x_nid, 'TP_TIME_ZONE_AUCTION', x_timezone_disp);
3544: wf_Notification.SetAttrText(x_nid, 'AUCTION_CLOSE_EARLY_SUB', x_close_early_subject);
3545: wf_Notification.SetAttrDate(x_nid, 'AUCTION_CLOSE_EARLY_DATE', x_new_close_early_date);
3546: wf_Notification.SetAttrText(x_nid, 'CLOSECHANGED_REASON', wf_engine.GetItemAttrText (itemtype => itemtype,
3547: itemkey => itemkey,
3548: aname => 'CLOSECHANGED_REASON'));
3549: ELSIF (p_action_code = 'CLOSECHANGED') then

Line 3546: wf_Notification.SetAttrText(x_nid, 'CLOSECHANGED_REASON', wf_engine.GetItemAttrText (itemtype => itemtype,

3542:
3543: wf_Notification.setAttrText(x_nid, 'TP_TIME_ZONE_AUCTION', x_timezone_disp);
3544: wf_Notification.SetAttrText(x_nid, 'AUCTION_CLOSE_EARLY_SUB', x_close_early_subject);
3545: wf_Notification.SetAttrDate(x_nid, 'AUCTION_CLOSE_EARLY_DATE', x_new_close_early_date);
3546: wf_Notification.SetAttrText(x_nid, 'CLOSECHANGED_REASON', wf_engine.GetItemAttrText (itemtype => itemtype,
3547: itemkey => itemkey,
3548: aname => 'CLOSECHANGED_REASON'));
3549: ELSIF (p_action_code = 'CLOSECHANGED') then
3550:

Line 3551: wf_Notification.setAttrText(x_nid, 'TP_TIME_ZONE_AUCTION', x_timezone_disp);

3547: itemkey => itemkey,
3548: aname => 'CLOSECHANGED_REASON'));
3549: ELSIF (p_action_code = 'CLOSECHANGED') then
3550:
3551: wf_Notification.setAttrText(x_nid, 'TP_TIME_ZONE_AUCTION', x_timezone_disp);
3552: wf_Notification.SetAttrText(x_nid, 'CLOSE_DATE_CHANGED_SUBJECT', x_close_changed_subject);
3553: wf_Notification.SetAttrDate(x_nid, 'CLOSE_DATE_CHANGED', x_new_close_changed_date);
3554: wf_Notification.SetAttrText(x_nid, 'NEG_SUMMARY_URL_SUPPLIER', x_neg_summary_url_supplier);
3555: wf_Notification.SetAttrNumber(x_nid, 'VENDOR_SITE_ID', p_vendor_site_id);

Line 3552: wf_Notification.SetAttrText(x_nid, 'CLOSE_DATE_CHANGED_SUBJECT', x_close_changed_subject);

3548: aname => 'CLOSECHANGED_REASON'));
3549: ELSIF (p_action_code = 'CLOSECHANGED') then
3550:
3551: wf_Notification.setAttrText(x_nid, 'TP_TIME_ZONE_AUCTION', x_timezone_disp);
3552: wf_Notification.SetAttrText(x_nid, 'CLOSE_DATE_CHANGED_SUBJECT', x_close_changed_subject);
3553: wf_Notification.SetAttrDate(x_nid, 'CLOSE_DATE_CHANGED', x_new_close_changed_date);
3554: wf_Notification.SetAttrText(x_nid, 'NEG_SUMMARY_URL_SUPPLIER', x_neg_summary_url_supplier);
3555: wf_Notification.SetAttrNumber(x_nid, 'VENDOR_SITE_ID', p_vendor_site_id);
3556:

Line 3553: wf_Notification.SetAttrDate(x_nid, 'CLOSE_DATE_CHANGED', x_new_close_changed_date);

3549: ELSIF (p_action_code = 'CLOSECHANGED') then
3550:
3551: wf_Notification.setAttrText(x_nid, 'TP_TIME_ZONE_AUCTION', x_timezone_disp);
3552: wf_Notification.SetAttrText(x_nid, 'CLOSE_DATE_CHANGED_SUBJECT', x_close_changed_subject);
3553: wf_Notification.SetAttrDate(x_nid, 'CLOSE_DATE_CHANGED', x_new_close_changed_date);
3554: wf_Notification.SetAttrText(x_nid, 'NEG_SUMMARY_URL_SUPPLIER', x_neg_summary_url_supplier);
3555: wf_Notification.SetAttrNumber(x_nid, 'VENDOR_SITE_ID', p_vendor_site_id);
3556:
3557: IF p_change_type <> 1 THEN --i.e if it is 'NEGOTIATION_SHORTENED'

Line 3554: wf_Notification.SetAttrText(x_nid, 'NEG_SUMMARY_URL_SUPPLIER', x_neg_summary_url_supplier);

3550:
3551: wf_Notification.setAttrText(x_nid, 'TP_TIME_ZONE_AUCTION', x_timezone_disp);
3552: wf_Notification.SetAttrText(x_nid, 'CLOSE_DATE_CHANGED_SUBJECT', x_close_changed_subject);
3553: wf_Notification.SetAttrDate(x_nid, 'CLOSE_DATE_CHANGED', x_new_close_changed_date);
3554: wf_Notification.SetAttrText(x_nid, 'NEG_SUMMARY_URL_SUPPLIER', x_neg_summary_url_supplier);
3555: wf_Notification.SetAttrNumber(x_nid, 'VENDOR_SITE_ID', p_vendor_site_id);
3556:
3557: IF p_change_type <> 1 THEN --i.e if it is 'NEGOTIATION_SHORTENED'
3558: wf_Notification.SetAttrText(x_nid, 'CLOSECHANGED_REASON', wf_engine.GetItemAttrText (itemtype => itemtype,

Line 3555: wf_Notification.SetAttrNumber(x_nid, 'VENDOR_SITE_ID', p_vendor_site_id);

3551: wf_Notification.setAttrText(x_nid, 'TP_TIME_ZONE_AUCTION', x_timezone_disp);
3552: wf_Notification.SetAttrText(x_nid, 'CLOSE_DATE_CHANGED_SUBJECT', x_close_changed_subject);
3553: wf_Notification.SetAttrDate(x_nid, 'CLOSE_DATE_CHANGED', x_new_close_changed_date);
3554: wf_Notification.SetAttrText(x_nid, 'NEG_SUMMARY_URL_SUPPLIER', x_neg_summary_url_supplier);
3555: wf_Notification.SetAttrNumber(x_nid, 'VENDOR_SITE_ID', p_vendor_site_id);
3556:
3557: IF p_change_type <> 1 THEN --i.e if it is 'NEGOTIATION_SHORTENED'
3558: wf_Notification.SetAttrText(x_nid, 'CLOSECHANGED_REASON', wf_engine.GetItemAttrText (itemtype => itemtype,
3559: itemkey => itemkey,

Line 3558: wf_Notification.SetAttrText(x_nid, 'CLOSECHANGED_REASON', wf_engine.GetItemAttrText (itemtype => itemtype,

3554: wf_Notification.SetAttrText(x_nid, 'NEG_SUMMARY_URL_SUPPLIER', x_neg_summary_url_supplier);
3555: wf_Notification.SetAttrNumber(x_nid, 'VENDOR_SITE_ID', p_vendor_site_id);
3556:
3557: IF p_change_type <> 1 THEN --i.e if it is 'NEGOTIATION_SHORTENED'
3558: wf_Notification.SetAttrText(x_nid, 'CLOSECHANGED_REASON', wf_engine.GetItemAttrText (itemtype => itemtype,
3559: itemkey => itemkey,
3560: aname => 'CLOSECHANGED_REASON'));
3561: END IF;
3562:

Line 3565: wf_Notification.SetAttrText(x_nid, 'TP_TIME_ZONE',x_timezone_disp);

3561: END IF;
3562:
3563: ELSIF (p_action_code = 'CANCEL') THEN
3564:
3565: wf_Notification.SetAttrText(x_nid, 'TP_TIME_ZONE',x_timezone_disp);
3566: wf_Notification.SetAttrDate(x_nid, 'CANCEL_DATE', x_new_cancel_date);
3567:
3568: IF (p_event_title is not null) THEN
3569: wf_Notification.SetAttrText(x_nid, 'EVENT_TITLE', p_event_title);

Line 3566: wf_Notification.SetAttrDate(x_nid, 'CANCEL_DATE', x_new_cancel_date);

3562:
3563: ELSIF (p_action_code = 'CANCEL') THEN
3564:
3565: wf_Notification.SetAttrText(x_nid, 'TP_TIME_ZONE',x_timezone_disp);
3566: wf_Notification.SetAttrDate(x_nid, 'CANCEL_DATE', x_new_cancel_date);
3567:
3568: IF (p_event_title is not null) THEN
3569: wf_Notification.SetAttrText(x_nid, 'EVENT_TITLE', p_event_title);
3570: wf_Notification.SetAttrText(x_nid, 'AUCTION_CANCELED_SUB',

Line 3569: wf_Notification.SetAttrText(x_nid, 'EVENT_TITLE', p_event_title);

3565: wf_Notification.SetAttrText(x_nid, 'TP_TIME_ZONE',x_timezone_disp);
3566: wf_Notification.SetAttrDate(x_nid, 'CANCEL_DATE', x_new_cancel_date);
3567:
3568: IF (p_event_title is not null) THEN
3569: wf_Notification.SetAttrText(x_nid, 'EVENT_TITLE', p_event_title);
3570: wf_Notification.SetAttrText(x_nid, 'AUCTION_CANCELED_SUB',
3571: getMessage('PON_AUC_WF_CANCEL_EVENT_SUB', x_msg_suffix,
3572: 'DOC_NUMBER', p_doc_number_dsp,
3573: 'AUCTION_TITLE', p_auction_title,

Line 3570: wf_Notification.SetAttrText(x_nid, 'AUCTION_CANCELED_SUB',

3566: wf_Notification.SetAttrDate(x_nid, 'CANCEL_DATE', x_new_cancel_date);
3567:
3568: IF (p_event_title is not null) THEN
3569: wf_Notification.SetAttrText(x_nid, 'EVENT_TITLE', p_event_title);
3570: wf_Notification.SetAttrText(x_nid, 'AUCTION_CANCELED_SUB',
3571: getMessage('PON_AUC_WF_CANCEL_EVENT_SUB', x_msg_suffix,
3572: 'DOC_NUMBER', p_doc_number_dsp,
3573: 'AUCTION_TITLE', p_auction_title,
3574: 'EVENT_TITLE', p_event_title));

Line 3576: wf_Notification.SetAttrText(x_nid, 'AUCTION_CANCELED_SUB',

3572: 'DOC_NUMBER', p_doc_number_dsp,
3573: 'AUCTION_TITLE', p_auction_title,
3574: 'EVENT_TITLE', p_event_title));
3575: ELSE
3576: wf_Notification.SetAttrText(x_nid, 'AUCTION_CANCELED_SUB',
3577: getMessage('PON_AUC_WF_AUC_CANCEL_SUB', x_msg_suffix,
3578: 'DOC_NUMBER', p_doc_number_dsp,
3579: 'AUCTION_TITLE', p_auction_title));
3580: END IF;

Line 3583: wf_Notification.SetAttrText(x_nid, 'CANCEL_REASON', x_cancel_reason);

3579: 'AUCTION_TITLE', p_auction_title));
3580: END IF;
3581:
3582: IF (empty_reason(x_cancel_reason) = 'N') then
3583: wf_Notification.SetAttrText(x_nid, 'CANCEL_REASON', x_cancel_reason);
3584: END IF;
3585:
3586: ELSIF (p_action_code = 'DISQUALIFY_BID') then
3587:

Line 3588: wf_Notification.SetAttrText(x_nid, 'TP_TIME_ZONE', x_timezone_disp);

3584: END IF;
3585:
3586: ELSIF (p_action_code = 'DISQUALIFY_BID') then
3587:
3588: wf_Notification.SetAttrText(x_nid, 'TP_TIME_ZONE', x_timezone_disp);
3589:
3590: -- convert the disqualify date to user's timezone
3591: x_new_disqualify_date := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(x_disqualify_date,x_oex_timezone,x_timezone);
3592:

Line 3593: wf_Notification.SetAttrDate(x_nid, 'DISQUALIFY_DATE', x_new_disqualify_date);

3589:
3590: -- convert the disqualify date to user's timezone
3591: x_new_disqualify_date := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(x_disqualify_date,x_oex_timezone,x_timezone);
3592:
3593: wf_Notification.SetAttrDate(x_nid, 'DISQUALIFY_DATE', x_new_disqualify_date);
3594: wf_Notification.SetAttrText(x_nid, 'BID', x_bid_name);
3595: wf_Notification.SetAttrText ( x_nid, 'PON_WF_AUC_DSQ_OTH_SUB',
3596: getMessage('PON_WF_AUC_DSQ_OTH_SUB', x_msg_suffix,
3597: 'DOC_NUMBER', p_doc_number_dsp,

Line 3594: wf_Notification.SetAttrText(x_nid, 'BID', x_bid_name);

3590: -- convert the disqualify date to user's timezone
3591: x_new_disqualify_date := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(x_disqualify_date,x_oex_timezone,x_timezone);
3592:
3593: wf_Notification.SetAttrDate(x_nid, 'DISQUALIFY_DATE', x_new_disqualify_date);
3594: wf_Notification.SetAttrText(x_nid, 'BID', x_bid_name);
3595: wf_Notification.SetAttrText ( x_nid, 'PON_WF_AUC_DSQ_OTH_SUB',
3596: getMessage('PON_WF_AUC_DSQ_OTH_SUB', x_msg_suffix,
3597: 'DOC_NUMBER', p_doc_number_dsp,
3598: 'AUCTION_TITLE', p_auction_title));

Line 3595: wf_Notification.SetAttrText ( x_nid, 'PON_WF_AUC_DSQ_OTH_SUB',

3591: x_new_disqualify_date := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(x_disqualify_date,x_oex_timezone,x_timezone);
3592:
3593: wf_Notification.SetAttrDate(x_nid, 'DISQUALIFY_DATE', x_new_disqualify_date);
3594: wf_Notification.SetAttrText(x_nid, 'BID', x_bid_name);
3595: wf_Notification.SetAttrText ( x_nid, 'PON_WF_AUC_DSQ_OTH_SUB',
3596: getMessage('PON_WF_AUC_DSQ_OTH_SUB', x_msg_suffix,
3597: 'DOC_NUMBER', p_doc_number_dsp,
3598: 'AUCTION_TITLE', p_auction_title));
3599: END IF;

Line 10097: Wf_Notification.SetAttrText(l_notification_id, 'RESULT', l_supp_ack);

10093: l_supp_ack :='B-NO';
10094: END IF;
10095:
10096: if (l_notification_id > 0) then
10097: Wf_Notification.SetAttrText(l_notification_id, 'RESULT', l_supp_ack);
10098: Wf_Notification.SetAttrText(l_notification_id, 'NOTE_TO_BUYER', p_ack_note);
10099: Wf_Notification.Respond(l_notification_id, 'On-Line', p_user_name);
10100: end if;
10101:

Line 10098: Wf_Notification.SetAttrText(l_notification_id, 'NOTE_TO_BUYER', p_ack_note);

10094: END IF;
10095:
10096: if (l_notification_id > 0) then
10097: Wf_Notification.SetAttrText(l_notification_id, 'RESULT', l_supp_ack);
10098: Wf_Notification.SetAttrText(l_notification_id, 'NOTE_TO_BUYER', p_ack_note);
10099: Wf_Notification.Respond(l_notification_id, 'On-Line', p_user_name);
10100: end if;
10101:
10102: x_return_status := 0;

Line 10099: Wf_Notification.Respond(l_notification_id, 'On-Line', p_user_name);

10095:
10096: if (l_notification_id > 0) then
10097: Wf_Notification.SetAttrText(l_notification_id, 'RESULT', l_supp_ack);
10098: Wf_Notification.SetAttrText(l_notification_id, 'NOTE_TO_BUYER', p_ack_note);
10099: Wf_Notification.Respond(l_notification_id, 'On-Line', p_user_name);
10100: end if;
10101:
10102: x_return_status := 0;
10103:

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

15111: fnd_message.set_token('VIEW_QUOTE_URL_SUPPLIER',x_view_quote_url);
15112: fnd_message.set_token('BID',x_bid_name);
15113: fnd_message.set_token('STAGGERED_CLOSE_NOTE',x_staggered_close_note);
15114: l_document := l_document || NL || NL || fnd_message.get;
15115: WF_NOTIFICATION.WriteToClob(document, l_document);
15116:
15117: ELSE
15118: l_disp_type:= display_type;
15119: fnd_message.set_name('PON','PON_WF_AUC_DSQBID_TB');

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

15130: fnd_message.set_token('VIEW_QUOTE_URL_SUPPLIER',x_view_quote_url);
15131: fnd_message.set_token('BID',x_bid_name);
15132: fnd_message.set_token('STAGGERED_CLOSE_NOTE',x_staggered_close_note);
15133: l_document := l_document || NL || NL || fnd_message.get;
15134: WF_NOTIFICATION.WriteToClob(document, l_document);
15135: END IF;
15136: EXCEPTION
15137: WHEN OTHERS THEN
15138: RAISE;

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

15277: fnd_message.set_token('BIDDER_TP_ADDRESS_NAME',x_bidder_tp_addresssname);
15278: fnd_message.set_token('REFUND_SUPPLIER',x_refund_supplier);
15279: fnd_message.set_token('STAGGERED_CLOSE_NOTE',x_staggered_close_note);
15280: l_document := l_document || NL || NL || fnd_message.get;
15281: WF_NOTIFICATION.WriteToClob(document, l_document);
15282:
15283: ELSE
15284: l_disp_type:= display_type;
15285: fnd_message.set_name('PON','PON_NON_INV_NEW_RND_START_TB');

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

15293: fnd_message.set_token('BIDDER_TP_ADDRESS_NAME',x_bidder_tp_addresssname);
15294: fnd_message.set_token('REFUND_SUPPLIER',x_refund_supplier);
15295: fnd_message.set_token('STAGGERED_CLOSE_NOTE',x_staggered_close_note);
15296: l_document := l_document || NL || NL || fnd_message.get;
15297: WF_NOTIFICATION.WriteToClob(document, l_document);
15298: END IF;
15299: EXCEPTION
15300: WHEN OTHERS THEN
15301: RAISE;

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

15488: fnd_message.set_token('NOTE_TO_SUPPLIER',x_note_to_supplier);
15489: fnd_message.set_token('VIEW_QUOTE_URL_SUPPLIER',x_view_quote_url);
15490: fnd_message.set_token('STAGGERED_CLOSE_NOTE',x_staggered_close_note);
15491: l_document := l_document || NL || NL || fnd_message.get;
15492: WF_NOTIFICATION.WriteToClob(document, l_document);
15493:
15494: ELSE
15495: l_disp_type:= display_type;
15496: fnd_message.set_name('PON','PON_AUC_WF_AWARD_L_TB');

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

15511: fnd_message.set_token('NOTE_TO_SUPPLIER',x_note_to_supplier);
15512: fnd_message.set_token('VIEW_QUOTE_URL_SUPPLIER',x_view_quote_url);
15513: fnd_message.set_token('STAGGERED_CLOSE_NOTE',x_staggered_close_note);
15514: l_document := l_document || NL || NL || fnd_message.get;
15515: WF_NOTIFICATION.WriteToClob(document, l_document);
15516: END IF;
15517: EXCEPTION
15518: WHEN OTHERS THEN
15519: RAISE;

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

15698: fnd_message.set_token('VIEW_QUOTE_URL_SUPPLIER',x_view_quote_url);
15699: fnd_message.set_token('BID',x_bid_name);
15700: fnd_message.set_token('STAGGERED_CLOSE_NOTE',x_staggered_close_note);
15701: l_document := l_document || NL || NL || fnd_message.get;
15702: WF_NOTIFICATION.WriteToClob(document, l_document);
15703:
15704: ELSE
15705: l_disp_type:= display_type;
15706: fnd_message.set_name('PON','PON_AUC_WF_AWARD_NL_TB');

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

15719: fnd_message.set_token('VIEW_QUOTE_URL_SUPPLIER',x_view_quote_url);
15720: fnd_message.set_token('BID',x_bid_name);
15721: fnd_message.set_token('STAGGERED_CLOSE_NOTE',x_staggered_close_note);
15722: l_document := l_document || NL || NL || fnd_message.get;
15723: WF_NOTIFICATION.WriteToClob(document, l_document);
15724: END IF;
15725: EXCEPTION
15726: WHEN OTHERS THEN
15727: RAISE;

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

15927: fnd_message.set_token('NOTE_TO_SUPPLIER',x_note_to_supplier);
15928: fnd_message.set_token('VIEW_QUOTE_URL_SUPPLIER',x_view_quote_url);
15929: fnd_message.set_token('STAGGERED_CLOSE_NOTE',x_staggered_close_note);
15930: l_document := l_document || NL || NL || fnd_message.get;
15931: WF_NOTIFICATION.WriteToClob(document, l_document);
15932:
15933: ELSE
15934: l_disp_type:= display_type;
15935: fnd_message.set_name('PON','PON_AUC_WF_AWARD_EVENT_L_TB');

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

15951: fnd_message.set_token('NOTE_TO_SUPPLIER',x_note_to_supplier);
15952: fnd_message.set_token('VIEW_QUOTE_URL_SUPPLIER',x_view_quote_url);
15953: fnd_message.set_token('STAGGERED_CLOSE_NOTE',x_staggered_close_note);
15954: l_document := l_document || NL || NL || fnd_message.get;
15955: WF_NOTIFICATION.WriteToClob(document, l_document);
15956: END IF;
15957: EXCEPTION
15958: WHEN OTHERS THEN
15959: RAISE;

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

16139: fnd_message.set_token('VIEW_QUOTE_URL_SUPPLIER',x_view_quote_url);
16140: fnd_message.set_token('BID',x_bid_name);
16141: fnd_message.set_token('STAGGERED_CLOSE_NOTE',x_staggered_close_note);
16142: l_document := l_document || NL || NL || fnd_message.get;
16143: WF_NOTIFICATION.WriteToClob(document, l_document);
16144:
16145: ELSE
16146: l_disp_type:= display_type;
16147: fnd_message.set_name('PON','PON_AUC_WF_AWARD_EVENT_NL_TB');

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

16161: fnd_message.set_token('VIEW_QUOTE_URL_SUPPLIER',x_view_quote_url);
16162: fnd_message.set_token('BID',x_bid_name);
16163: fnd_message.set_token('STAGGERED_CLOSE_NOTE',x_staggered_close_note);
16164: l_document := l_document || NL || NL || fnd_message.get;
16165: WF_NOTIFICATION.WriteToClob(document, l_document);
16166: END IF;
16167: EXCEPTION
16168: WHEN OTHERS THEN
16169: RAISE;

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

16296: fnd_message.set_token('REFUND_SUPPLIER',x_refund_supplier);
16297: fnd_message.set_token('NEG_SUMMARY_URL_SUPPLIER',x_neg_summary_url);
16298: fnd_message.set_token('STAGGERED_CLOSE_NOTE',x_staggered_close_note);
16299: l_document := l_document || NL || NL || fnd_message.get;
16300: WF_NOTIFICATION.WriteToClob(document, l_document);
16301:
16302: ELSE
16303: l_disp_type:= display_type;
16304: fnd_message.set_name('PON','PON_AMENDMENT_START_TB');

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

16310: fnd_message.set_token('REFUND_SUPPLIER',x_refund_supplier);
16311: fnd_message.set_token('NEG_SUMMARY_URL_SUPPLIER',x_neg_summary_url);
16312: fnd_message.set_token('STAGGERED_CLOSE_NOTE',x_staggered_close_note);
16313: l_document := l_document || NL || NL || fnd_message.get;
16314: WF_NOTIFICATION.WriteToClob(document, l_document);
16315: END IF;
16316: EXCEPTION
16317: WHEN OTHERS THEN
16318: RAISE;

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

16518: END IF;
16519: -- End Bug 9309785
16520:
16521: l_document := l_document || NL || NL || fnd_message.get;
16522: WF_NOTIFICATION.WriteToClob(document, l_document);
16523: ELSE
16524: l_disp_type:= display_type;
16525:
16526: -- Begin Bug 9309785

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

16549: END IF;
16550: -- End Bug 9309785
16551:
16552: l_document := l_document || NL || NL || fnd_message.get;
16553: WF_NOTIFICATION.WriteToClob(document, l_document);
16554: END IF;
16555: EXCEPTION
16556: WHEN OTHERS THEN
16557: RAISE;

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

16716: fnd_message.set_token('SUPPLIER_EXEMPTED_INFO',x_supplier_exempted_info);
16717: fnd_message.set_token('NEG_SUMMARY_URL_SUPPLIER',x_neg_summary_url);
16718: fnd_message.set_token('STAGGERED_CLOSE_NOTE',x_staggered_close_note);
16719: l_document := l_document || NL || NL || fnd_message.get;
16720: WF_NOTIFICATION.WriteToClob(document, l_document);
16721:
16722: ELSE
16723: l_disp_type:= display_type;
16724: fnd_message.set_name('PON','PON_INVITE_RESPONSE_TB');

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

16733: fnd_message.set_token('SUPPLIER_EXEMPTED_INFO',x_supplier_exempted_info);
16734: fnd_message.set_token('NEG_SUMMARY_URL_SUPPLIER',x_neg_summary_url);
16735: fnd_message.set_token('STAGGERED_CLOSE_NOTE',x_staggered_close_note);
16736: l_document := l_document || NL || NL || fnd_message.get;
16737: WF_NOTIFICATION.WriteToClob(document, l_document);
16738: END IF;
16739: EXCEPTION
16740: WHEN OTHERS THEN
16741: RAISE;

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

16913: fnd_message.set_token('NEG_SUMMARY_URL_SUPPLIER',x_neg_summary_url);
16914: fnd_message.set_token('ISP_SUPPLIER_REG_URL',x_isupplier_reg_url);
16915: fnd_message.set_token('STAGGERED_CLOSE_NOTE',x_staggered_close_note);
16916: l_document := l_document || NL || NL || fnd_message.get;
16917: WF_NOTIFICATION.WriteToClob(document, l_document);
16918:
16919: ELSE
16920: l_disp_type:= display_type;
16921: fnd_message.set_name('PON','PON_INV_RESP_ADD_CONT_TB');

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

16932: fnd_message.set_token('NEG_SUMMARY_URL_SUPPLIER',x_neg_summary_url);
16933: fnd_message.set_token('ISP_SUPPLIER_REG_URL',x_isupplier_reg_url);
16934: fnd_message.set_token('STAGGERED_CLOSE_NOTE',x_staggered_close_note);
16935: l_document := l_document || NL || NL || fnd_message.get;
16936: WF_NOTIFICATION.WriteToClob(document, l_document);
16937: END IF;
16938: EXCEPTION
16939: WHEN OTHERS THEN
16940: RAISE;

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

17097: fnd_message.set_token('REFUND_SUPPLIER',x_refund_supplier);
17098: fnd_message.set_token('NEG_SUMMARY_URL_SUPPLIER',x_neg_summary_url);
17099: fnd_message.set_token('STAGGERED_CLOSE_NOTE',x_staggered_close_note);
17100: l_document := l_document || NL || NL || fnd_message.get;
17101: WF_NOTIFICATION.WriteToClob(document, l_document);
17102: ELSE
17103: l_disp_type:= display_type;
17104: fnd_message.set_name('PON','PON_INV_NEW_RND_START_TB');
17105: fnd_message.set_token('PREVIEW_DATE',x_preview_date_format);

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

17113: fnd_message.set_token('REFUND_SUPPLIER',x_refund_supplier);
17114: fnd_message.set_token('NEG_SUMMARY_URL_SUPPLIER',x_neg_summary_url);
17115: fnd_message.set_token('STAGGERED_CLOSE_NOTE',x_staggered_close_note);
17116: l_document := l_document || NL || NL || fnd_message.get;
17117: WF_NOTIFICATION.WriteToClob(document, l_document);
17118: END IF;
17119: EXCEPTION
17120: WHEN OTHERS THEN
17121: RAISE;

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

17295: fnd_message.set_token('NEG_SUMMARY_URL_SUPPLIER',x_neg_summary_url);
17296: fnd_message.set_token('ISP_SUPPLIER_REG_URL',x_isupplier_reg_url);
17297: fnd_message.set_token('STAGGERED_CLOSE_NOTE',x_staggered_close_note);
17298: l_document := l_document || NL || NL || fnd_message.get;
17299: WF_NOTIFICATION.WriteToClob(document, l_document);
17300:
17301: ELSE
17302: l_disp_type:= display_type;
17303: fnd_message.set_name('PON','PON_INV_NEW_RND_START_AD_TB');

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

17314: fnd_message.set_token('NEG_SUMMARY_URL_SUPPLIER',x_neg_summary_url);
17315: fnd_message.set_token('ISP_SUPPLIER_REG_URL',x_isupplier_reg_url);
17316: fnd_message.set_token('STAGGERED_CLOSE_NOTE',x_staggered_close_note);
17317: l_document := l_document || NL || NL || fnd_message.get;
17318: WF_NOTIFICATION.WriteToClob(document, l_document);
17319: END IF;
17320: EXCEPTION
17321: WHEN OTHERS THEN
17322: RAISE;

Line 17408: p_notification_id := WF_NOTIFICATION.send(role => x_username,

17404: FOR preparer IN preparer_list LOOP
17405:
17406: PO_REQAPPROVAL_INIT1.get_user_name(preparer.preparer_id, x_username, x_user_display_name);
17407:
17408: p_notification_id := WF_NOTIFICATION.send(role => x_username,
17409: context => p_itemtype||':'||p_itemkey||':'||to_char(p_actid),
17410: msg_type => 'PONAUCT',
17411: msg_name => p_message_name);
17412:

Line 17413: wf_Notification.SetAttrText(p_notification_id, 'DOC_PUBLISHED_REQ_SUBJECT',

17409: context => p_itemtype||':'||p_itemkey||':'||to_char(p_actid),
17410: msg_type => 'PONAUCT',
17411: msg_name => p_message_name);
17412:
17413: wf_Notification.SetAttrText(p_notification_id, 'DOC_PUBLISHED_REQ_SUBJECT',
17414: getMessage('PON_AUC_WF_PUBLISHED_SUB', x_msg_suffix,
17415: 'DOCUMENT_NUMBER', x_doc_number_wf,
17416: 'AUCTION_TITLE', wf_engine.GetItemAttrText (itemtype => p_itemtype,
17417: itemkey => p_itemkey,

Line 17420: wf_Notification.setAttrDate(p_notification_id, 'AUCTION_START_DATE', wf_engine.GetItemAttrdate (itemtype => p_itemtype,

17416: 'AUCTION_TITLE', wf_engine.GetItemAttrText (itemtype => p_itemtype,
17417: itemkey => p_itemkey,
17418: aname =>'AUCTION_TITLE')));
17419:
17420: wf_Notification.setAttrDate(p_notification_id, 'AUCTION_START_DATE', wf_engine.GetItemAttrdate (itemtype => p_itemtype,
17421: itemkey => p_itemkey,
17422: aname =>'AUCTION_START_DATE'));
17423:
17424: wf_Notification.setAttrDate(p_notification_id, 'AUCTION_END_DATE', wf_engine.GetItemAttrdate (itemtype => p_itemtype,

Line 17424: wf_Notification.setAttrDate(p_notification_id, 'AUCTION_END_DATE', wf_engine.GetItemAttrdate (itemtype => p_itemtype,

17420: wf_Notification.setAttrDate(p_notification_id, 'AUCTION_START_DATE', wf_engine.GetItemAttrdate (itemtype => p_itemtype,
17421: itemkey => p_itemkey,
17422: aname =>'AUCTION_START_DATE'));
17423:
17424: wf_Notification.setAttrDate(p_notification_id, 'AUCTION_END_DATE', wf_engine.GetItemAttrdate (itemtype => p_itemtype,
17425: itemkey => p_itemkey,
17426: aname =>'AUCTION_END_DATE'));
17427: wf_Notification.setAttrText (p_notification_id, 'PR_NUMBER', get_all_pr_number(x_auction_header_id));
17428: wf_Notification.setAttrText(p_notification_id, 'NEG_SUMMARY_URL', wf_engine.GetItemAttrText (itemtype => p_itemtype,

Line 17427: wf_Notification.setAttrText (p_notification_id, 'PR_NUMBER', get_all_pr_number(x_auction_header_id));

17423:
17424: wf_Notification.setAttrDate(p_notification_id, 'AUCTION_END_DATE', wf_engine.GetItemAttrdate (itemtype => p_itemtype,
17425: itemkey => p_itemkey,
17426: aname =>'AUCTION_END_DATE'));
17427: wf_Notification.setAttrText (p_notification_id, 'PR_NUMBER', get_all_pr_number(x_auction_header_id));
17428: wf_Notification.setAttrText(p_notification_id, 'NEG_SUMMARY_URL', wf_engine.GetItemAttrText (itemtype => p_itemtype,
17429: itemkey => p_itemkey,
17430: aname =>'NEG_SUMMARY_URL'));
17431:

Line 17428: wf_Notification.setAttrText(p_notification_id, 'NEG_SUMMARY_URL', wf_engine.GetItemAttrText (itemtype => p_itemtype,

17424: wf_Notification.setAttrDate(p_notification_id, 'AUCTION_END_DATE', wf_engine.GetItemAttrdate (itemtype => p_itemtype,
17425: itemkey => p_itemkey,
17426: aname =>'AUCTION_END_DATE'));
17427: wf_Notification.setAttrText (p_notification_id, 'PR_NUMBER', get_all_pr_number(x_auction_header_id));
17428: wf_Notification.setAttrText(p_notification_id, 'NEG_SUMMARY_URL', wf_engine.GetItemAttrText (itemtype => p_itemtype,
17429: itemkey => p_itemkey,
17430: aname =>'NEG_SUMMARY_URL'));
17431:
17432:

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

17632: fnd_message.set_token('AUCTION_END_DATE', l_auction_end_date_format);
17633: fnd_message.set_token('TP_TIME_ZONE', l_timezone_disp);
17634: l_document := l_document || fnd_global.newline || fnd_global.newline ||
17635: fnd_message.get;
17636: WF_NOTIFICATION.WriteToClob(document, l_document);
17637: ELSE
17638: fnd_message.set_name('PON','PON_SM_REQ_SUPP_AMEND_TB');
17639: fnd_message.set_token('AUCTION_TITLE', l_auction_title);
17640: fnd_message.set_token('DOC_NUMBER', l_doc_number);

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

17643: fnd_message.set_token('AUCTION_END_DATE', l_auction_end_date_format);
17644: fnd_message.set_token('TP_TIME_ZONE', l_timezone_disp);
17645: l_document := l_document || fnd_global.newline || fnd_global.newline ||
17646: fnd_message.get;
17647: WF_NOTIFICATION.WriteToClob(document, l_document);
17648: END IF;
17649:
17650: END GEN_REQ_SUPP_AUC_AMEND_BODY;
17651:

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

17713: fnd_message.set_token('AUCTION_END_DATE', l_auction_end_date_format);
17714: fnd_message.set_token('TP_TIME_ZONE', l_timezone_disp);
17715: l_document := l_document || fnd_global.newline || fnd_global.newline ||
17716: fnd_message.get;
17717: WF_NOTIFICATION.WriteToClob(document, l_document);
17718: ELSE
17719: fnd_message.set_name('PON','PON_SM_INV_REQ_SUPP_NEWRND_TB');
17720: fnd_message.set_token('AUCTION_TITLE', l_auction_title);
17721: fnd_message.set_token('DOC_NUMBER', l_doc_number);

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

17724: fnd_message.set_token('AUCTION_END_DATE', l_auction_end_date_format);
17725: fnd_message.set_token('TP_TIME_ZONE', l_timezone_disp);
17726: l_document := l_document || fnd_global.newline || fnd_global.newline ||
17727: fnd_message.get;
17728: WF_NOTIFICATION.WriteToClob(document, l_document);
17729: END IF;
17730:
17731: END GEN_INV_REQ_SUPP_NEWRND_BODY;
17732: