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 920: p_notification_id := WF_NOTIFICATION.send(role => bidder.trading_partner_contact_name,

916: aname => 'BIDDER_DISPLAY_NAME',
917: avalue => bidder.trading_partner_contact_name);
918:
919:
920: p_notification_id := WF_NOTIFICATION.send(role => bidder.trading_partner_contact_name,
921: context => p_itemtype||':'||p_itemkey||':'||to_char(p_actid),
922: msg_type => 'PONAUCT',
923: msg_name => p_message_name);
924: END LOOP;

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

2893: aname => 'DOC_INTERNAL_NAME'));
2894:
2895: UNSET_SESSION_LANGUAGE;
2896:
2897: x_nid := WF_NOTIFICATION.send(role => p_user ,
2898: context => itemtype||':'||itemkey||':'||actid,
2899: msg_type => itemtype,
2900: msg_name => p_message_name);
2901:

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

2915: x_staggered_close_note := wf_core.newline || wf_core.newline ||
2916: getMessage('PON_STAGGERED_CLOSE_NOTIF_MSG') ||
2917: wf_core.newline || wf_core.newline;
2918: END IF;
2919: wf_Notification.setAttrText(x_nid, 'STAGGERED_CLOSE_NOTE', x_staggered_close_note);
2920:
2921: BEGIN
2922: wf_Notification.setAttrText(x_nid,'#WFM_HTMLAGENT', pon_wf_utl_pkg.get_base_external_supplier_url);
2923: EXCEPTION

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

2918: END IF;
2919: wf_Notification.setAttrText(x_nid, 'STAGGERED_CLOSE_NOTE', x_staggered_close_note);
2920:
2921: BEGIN
2922: wf_Notification.setAttrText(x_nid,'#WFM_HTMLAGENT', pon_wf_utl_pkg.get_base_external_supplier_url);
2923: EXCEPTION
2924: WHEN OTHERS THEN
2925: NULL;
2926: END;

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

3001: x_timezone1_disp := null;
3002: END IF;
3003:
3004: -- Setup common attributes
3005: wf_Notification.setAttrDate(x_nid, 'AUCTION_START_DATE', x_new_auction_start_date);
3006: wf_Notification.setAttrDate(x_nid, 'AUCTION_END_DATE', x_new_auction_end_date);
3007: wf_Notification.SetAttrDate(x_nid, 'PREVIEW_DATE', x_new_auction_preview_date);
3008: wf_Notification.SetAttrText(x_nid, 'TP_TIME_ZONE1', x_timezone1_disp);
3009: wf_Notification.setAttrText(x_nid, '#HDR_NEG_TITLE', p_auction_title);

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

3002: END IF;
3003:
3004: -- Setup common attributes
3005: wf_Notification.setAttrDate(x_nid, 'AUCTION_START_DATE', x_new_auction_start_date);
3006: wf_Notification.setAttrDate(x_nid, 'AUCTION_END_DATE', x_new_auction_end_date);
3007: wf_Notification.SetAttrDate(x_nid, 'PREVIEW_DATE', x_new_auction_preview_date);
3008: wf_Notification.SetAttrText(x_nid, 'TP_TIME_ZONE1', x_timezone1_disp);
3009: wf_Notification.setAttrText(x_nid, '#HDR_NEG_TITLE', p_auction_title);
3010: wf_Notification.setAttrText(x_nid, '#HDR_NEG_NUMBER', p_doc_number_dsp);

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

3003:
3004: -- Setup common attributes
3005: wf_Notification.setAttrDate(x_nid, 'AUCTION_START_DATE', x_new_auction_start_date);
3006: wf_Notification.setAttrDate(x_nid, 'AUCTION_END_DATE', x_new_auction_end_date);
3007: wf_Notification.SetAttrDate(x_nid, 'PREVIEW_DATE', x_new_auction_preview_date);
3008: wf_Notification.SetAttrText(x_nid, 'TP_TIME_ZONE1', x_timezone1_disp);
3009: wf_Notification.setAttrText(x_nid, '#HDR_NEG_TITLE', p_auction_title);
3010: wf_Notification.setAttrText(x_nid, '#HDR_NEG_NUMBER', p_doc_number_dsp);
3011: wf_Notification.setAttrText(x_nid, '#HDR_NEG_TP_NAME', wf_engine.GetItemAttrText (itemtype => itemtype,

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

3004: -- Setup common attributes
3005: wf_Notification.setAttrDate(x_nid, 'AUCTION_START_DATE', x_new_auction_start_date);
3006: wf_Notification.setAttrDate(x_nid, 'AUCTION_END_DATE', x_new_auction_end_date);
3007: wf_Notification.SetAttrDate(x_nid, 'PREVIEW_DATE', x_new_auction_preview_date);
3008: wf_Notification.SetAttrText(x_nid, 'TP_TIME_ZONE1', x_timezone1_disp);
3009: wf_Notification.setAttrText(x_nid, '#HDR_NEG_TITLE', p_auction_title);
3010: wf_Notification.setAttrText(x_nid, '#HDR_NEG_NUMBER', p_doc_number_dsp);
3011: wf_Notification.setAttrText(x_nid, '#HDR_NEG_TP_NAME', wf_engine.GetItemAttrText (itemtype => itemtype,
3012: itemkey => itemkey,

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

3005: wf_Notification.setAttrDate(x_nid, 'AUCTION_START_DATE', x_new_auction_start_date);
3006: wf_Notification.setAttrDate(x_nid, 'AUCTION_END_DATE', x_new_auction_end_date);
3007: wf_Notification.SetAttrDate(x_nid, 'PREVIEW_DATE', x_new_auction_preview_date);
3008: wf_Notification.SetAttrText(x_nid, 'TP_TIME_ZONE1', x_timezone1_disp);
3009: wf_Notification.setAttrText(x_nid, '#HDR_NEG_TITLE', p_auction_title);
3010: wf_Notification.setAttrText(x_nid, '#HDR_NEG_NUMBER', p_doc_number_dsp);
3011: wf_Notification.setAttrText(x_nid, '#HDR_NEG_TP_NAME', wf_engine.GetItemAttrText (itemtype => itemtype,
3012: itemkey => itemkey,
3013: aname =>'PREPARER_TP_NAME'));

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

3006: wf_Notification.setAttrDate(x_nid, 'AUCTION_END_DATE', x_new_auction_end_date);
3007: wf_Notification.SetAttrDate(x_nid, 'PREVIEW_DATE', x_new_auction_preview_date);
3008: wf_Notification.SetAttrText(x_nid, 'TP_TIME_ZONE1', x_timezone1_disp);
3009: wf_Notification.setAttrText(x_nid, '#HDR_NEG_TITLE', p_auction_title);
3010: wf_Notification.setAttrText(x_nid, '#HDR_NEG_NUMBER', p_doc_number_dsp);
3011: wf_Notification.setAttrText(x_nid, '#HDR_NEG_TP_NAME', wf_engine.GetItemAttrText (itemtype => itemtype,
3012: itemkey => itemkey,
3013: aname =>'PREPARER_TP_NAME'));
3014:

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

3007: wf_Notification.SetAttrDate(x_nid, 'PREVIEW_DATE', x_new_auction_preview_date);
3008: wf_Notification.SetAttrText(x_nid, 'TP_TIME_ZONE1', x_timezone1_disp);
3009: wf_Notification.setAttrText(x_nid, '#HDR_NEG_TITLE', p_auction_title);
3010: wf_Notification.setAttrText(x_nid, '#HDR_NEG_NUMBER', p_doc_number_dsp);
3011: wf_Notification.setAttrText(x_nid, '#HDR_NEG_TP_NAME', wf_engine.GetItemAttrText (itemtype => itemtype,
3012: itemkey => itemkey,
3013: aname =>'PREPARER_TP_NAME'));
3014:
3015: wf_Notification.setAttrText(x_nid, '#FROM_ROLE', l_origin_user_name);

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

3011: wf_Notification.setAttrText(x_nid, '#HDR_NEG_TP_NAME', wf_engine.GetItemAttrText (itemtype => itemtype,
3012: itemkey => itemkey,
3013: aname =>'PREPARER_TP_NAME'));
3014:
3015: wf_Notification.setAttrText(x_nid, '#FROM_ROLE', l_origin_user_name);
3016:
3017: IF (x_new_auction_preview_date is null) THEN
3018: wf_Notification.SetAttrText(x_nid, 'PREVIEW_DATE_NOTSPECIFIED', PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
3019:

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

3014:
3015: wf_Notification.setAttrText(x_nid, '#FROM_ROLE', l_origin_user_name);
3016:
3017: IF (x_new_auction_preview_date is null) THEN
3018: wf_Notification.SetAttrText(x_nid, 'PREVIEW_DATE_NOTSPECIFIED', PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
3019:
3020: ELSE
3021: wf_Notification.SetAttrText(x_nid, 'PREVIEW_DATE_NOTSPECIFIED', wf_engine.GetItemAttrText (itemtype => itemtype,
3022: itemkey => itemkey,

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

3017: IF (x_new_auction_preview_date is null) THEN
3018: wf_Notification.SetAttrText(x_nid, 'PREVIEW_DATE_NOTSPECIFIED', PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
3019:
3020: ELSE
3021: wf_Notification.SetAttrText(x_nid, 'PREVIEW_DATE_NOTSPECIFIED', wf_engine.GetItemAttrText (itemtype => itemtype,
3022: itemkey => itemkey,
3023: aname => 'PREVIEW_DATE_NOTSPECIFIED'));
3024: END IF;
3025:

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

3023: aname => 'PREVIEW_DATE_NOTSPECIFIED'));
3024: END IF;
3025:
3026: if (p_action_code <> 'DISQUALIFY_BID') then
3027: wf_Notification.setAttrText(x_nid, 'BIDDER_TP_NAME', p_bidder_tp_name);
3028: wf_Notification.setAttrText(x_nid, 'BIDDER_TP_ADDRESS_NAME', p_vendor_site_code);
3029: end if;
3030:
3031: IF (p_action_code is not null and p_action_code = 'CLOSEEARLY') THEN

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

3024: END IF;
3025:
3026: if (p_action_code <> 'DISQUALIFY_BID') then
3027: wf_Notification.setAttrText(x_nid, 'BIDDER_TP_NAME', p_bidder_tp_name);
3028: wf_Notification.setAttrText(x_nid, 'BIDDER_TP_ADDRESS_NAME', p_vendor_site_code);
3029: end if;
3030:
3031: IF (p_action_code is not null and p_action_code = 'CLOSEEARLY') THEN
3032:

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

3029: end if;
3030:
3031: IF (p_action_code is not null and p_action_code = 'CLOSEEARLY') THEN
3032:
3033: wf_Notification.setAttrText(x_nid, 'TP_TIME_ZONE_AUCTION', x_timezone_disp);
3034: wf_Notification.SetAttrText(x_nid, 'AUCTION_CLOSE_EARLY_SUB', x_close_early_subject);
3035: wf_Notification.SetAttrDate(x_nid, 'AUCTION_CLOSE_EARLY_DATE', x_new_close_early_date);
3036: wf_Notification.SetAttrText(x_nid, 'CLOSECHANGED_REASON', wf_engine.GetItemAttrText (itemtype => itemtype,
3037: itemkey => itemkey,

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

3030:
3031: IF (p_action_code is not null and p_action_code = 'CLOSEEARLY') THEN
3032:
3033: wf_Notification.setAttrText(x_nid, 'TP_TIME_ZONE_AUCTION', x_timezone_disp);
3034: wf_Notification.SetAttrText(x_nid, 'AUCTION_CLOSE_EARLY_SUB', x_close_early_subject);
3035: wf_Notification.SetAttrDate(x_nid, 'AUCTION_CLOSE_EARLY_DATE', x_new_close_early_date);
3036: wf_Notification.SetAttrText(x_nid, 'CLOSECHANGED_REASON', wf_engine.GetItemAttrText (itemtype => itemtype,
3037: itemkey => itemkey,
3038: aname => 'CLOSECHANGED_REASON'));

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

3031: IF (p_action_code is not null and p_action_code = 'CLOSEEARLY') THEN
3032:
3033: wf_Notification.setAttrText(x_nid, 'TP_TIME_ZONE_AUCTION', x_timezone_disp);
3034: wf_Notification.SetAttrText(x_nid, 'AUCTION_CLOSE_EARLY_SUB', x_close_early_subject);
3035: wf_Notification.SetAttrDate(x_nid, 'AUCTION_CLOSE_EARLY_DATE', x_new_close_early_date);
3036: wf_Notification.SetAttrText(x_nid, 'CLOSECHANGED_REASON', wf_engine.GetItemAttrText (itemtype => itemtype,
3037: itemkey => itemkey,
3038: aname => 'CLOSECHANGED_REASON'));
3039: ELSIF (p_action_code = 'CLOSECHANGED') then

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

3032:
3033: wf_Notification.setAttrText(x_nid, 'TP_TIME_ZONE_AUCTION', x_timezone_disp);
3034: wf_Notification.SetAttrText(x_nid, 'AUCTION_CLOSE_EARLY_SUB', x_close_early_subject);
3035: wf_Notification.SetAttrDate(x_nid, 'AUCTION_CLOSE_EARLY_DATE', x_new_close_early_date);
3036: wf_Notification.SetAttrText(x_nid, 'CLOSECHANGED_REASON', wf_engine.GetItemAttrText (itemtype => itemtype,
3037: itemkey => itemkey,
3038: aname => 'CLOSECHANGED_REASON'));
3039: ELSIF (p_action_code = 'CLOSECHANGED') then
3040:

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

3037: itemkey => itemkey,
3038: aname => 'CLOSECHANGED_REASON'));
3039: ELSIF (p_action_code = 'CLOSECHANGED') then
3040:
3041: wf_Notification.setAttrText(x_nid, 'TP_TIME_ZONE_AUCTION', x_timezone_disp);
3042: wf_Notification.SetAttrText(x_nid, 'CLOSE_DATE_CHANGED_SUBJECT', x_close_changed_subject);
3043: wf_Notification.SetAttrDate(x_nid, 'CLOSE_DATE_CHANGED', x_new_close_changed_date);
3044: wf_Notification.SetAttrText(x_nid, 'NEG_SUMMARY_URL_SUPPLIER', x_neg_summary_url_supplier);
3045: wf_Notification.SetAttrNumber(x_nid, 'VENDOR_SITE_ID', p_vendor_site_id);

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

3038: aname => 'CLOSECHANGED_REASON'));
3039: ELSIF (p_action_code = 'CLOSECHANGED') then
3040:
3041: wf_Notification.setAttrText(x_nid, 'TP_TIME_ZONE_AUCTION', x_timezone_disp);
3042: wf_Notification.SetAttrText(x_nid, 'CLOSE_DATE_CHANGED_SUBJECT', x_close_changed_subject);
3043: wf_Notification.SetAttrDate(x_nid, 'CLOSE_DATE_CHANGED', x_new_close_changed_date);
3044: wf_Notification.SetAttrText(x_nid, 'NEG_SUMMARY_URL_SUPPLIER', x_neg_summary_url_supplier);
3045: wf_Notification.SetAttrNumber(x_nid, 'VENDOR_SITE_ID', p_vendor_site_id);
3046:

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

3039: ELSIF (p_action_code = 'CLOSECHANGED') then
3040:
3041: wf_Notification.setAttrText(x_nid, 'TP_TIME_ZONE_AUCTION', x_timezone_disp);
3042: wf_Notification.SetAttrText(x_nid, 'CLOSE_DATE_CHANGED_SUBJECT', x_close_changed_subject);
3043: wf_Notification.SetAttrDate(x_nid, 'CLOSE_DATE_CHANGED', x_new_close_changed_date);
3044: wf_Notification.SetAttrText(x_nid, 'NEG_SUMMARY_URL_SUPPLIER', x_neg_summary_url_supplier);
3045: wf_Notification.SetAttrNumber(x_nid, 'VENDOR_SITE_ID', p_vendor_site_id);
3046:
3047: IF p_change_type <> 1 THEN --i.e if it is 'NEGOTIATION_SHORTENED'

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

3040:
3041: wf_Notification.setAttrText(x_nid, 'TP_TIME_ZONE_AUCTION', x_timezone_disp);
3042: wf_Notification.SetAttrText(x_nid, 'CLOSE_DATE_CHANGED_SUBJECT', x_close_changed_subject);
3043: wf_Notification.SetAttrDate(x_nid, 'CLOSE_DATE_CHANGED', x_new_close_changed_date);
3044: wf_Notification.SetAttrText(x_nid, 'NEG_SUMMARY_URL_SUPPLIER', x_neg_summary_url_supplier);
3045: wf_Notification.SetAttrNumber(x_nid, 'VENDOR_SITE_ID', p_vendor_site_id);
3046:
3047: IF p_change_type <> 1 THEN --i.e if it is 'NEGOTIATION_SHORTENED'
3048: wf_Notification.SetAttrText(x_nid, 'CLOSECHANGED_REASON', wf_engine.GetItemAttrText (itemtype => itemtype,

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

3041: wf_Notification.setAttrText(x_nid, 'TP_TIME_ZONE_AUCTION', x_timezone_disp);
3042: wf_Notification.SetAttrText(x_nid, 'CLOSE_DATE_CHANGED_SUBJECT', x_close_changed_subject);
3043: wf_Notification.SetAttrDate(x_nid, 'CLOSE_DATE_CHANGED', x_new_close_changed_date);
3044: wf_Notification.SetAttrText(x_nid, 'NEG_SUMMARY_URL_SUPPLIER', x_neg_summary_url_supplier);
3045: wf_Notification.SetAttrNumber(x_nid, 'VENDOR_SITE_ID', p_vendor_site_id);
3046:
3047: IF p_change_type <> 1 THEN --i.e if it is 'NEGOTIATION_SHORTENED'
3048: wf_Notification.SetAttrText(x_nid, 'CLOSECHANGED_REASON', wf_engine.GetItemAttrText (itemtype => itemtype,
3049: itemkey => itemkey,

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

3044: wf_Notification.SetAttrText(x_nid, 'NEG_SUMMARY_URL_SUPPLIER', x_neg_summary_url_supplier);
3045: wf_Notification.SetAttrNumber(x_nid, 'VENDOR_SITE_ID', p_vendor_site_id);
3046:
3047: IF p_change_type <> 1 THEN --i.e if it is 'NEGOTIATION_SHORTENED'
3048: wf_Notification.SetAttrText(x_nid, 'CLOSECHANGED_REASON', wf_engine.GetItemAttrText (itemtype => itemtype,
3049: itemkey => itemkey,
3050: aname => 'CLOSECHANGED_REASON'));
3051: END IF;
3052:

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

3051: END IF;
3052:
3053: ELSIF (p_action_code = 'CANCEL') THEN
3054:
3055: wf_Notification.SetAttrText(x_nid, 'TP_TIME_ZONE',x_timezone_disp);
3056: wf_Notification.SetAttrDate(x_nid, 'CANCEL_DATE', x_new_cancel_date);
3057:
3058: IF (p_event_title is not null) THEN
3059: wf_Notification.SetAttrText(x_nid, 'EVENT_TITLE', p_event_title);

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

3052:
3053: ELSIF (p_action_code = 'CANCEL') THEN
3054:
3055: wf_Notification.SetAttrText(x_nid, 'TP_TIME_ZONE',x_timezone_disp);
3056: wf_Notification.SetAttrDate(x_nid, 'CANCEL_DATE', x_new_cancel_date);
3057:
3058: IF (p_event_title is not null) THEN
3059: wf_Notification.SetAttrText(x_nid, 'EVENT_TITLE', p_event_title);
3060: wf_Notification.SetAttrText(x_nid, 'AUCTION_CANCELED_SUB',

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

3055: wf_Notification.SetAttrText(x_nid, 'TP_TIME_ZONE',x_timezone_disp);
3056: wf_Notification.SetAttrDate(x_nid, 'CANCEL_DATE', x_new_cancel_date);
3057:
3058: IF (p_event_title is not null) THEN
3059: wf_Notification.SetAttrText(x_nid, 'EVENT_TITLE', p_event_title);
3060: wf_Notification.SetAttrText(x_nid, 'AUCTION_CANCELED_SUB',
3061: getMessage('PON_AUC_WF_CANCEL_EVENT_SUB', x_msg_suffix,
3062: 'DOC_NUMBER', p_doc_number_dsp,
3063: 'AUCTION_TITLE', p_auction_title,

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

3056: wf_Notification.SetAttrDate(x_nid, 'CANCEL_DATE', x_new_cancel_date);
3057:
3058: IF (p_event_title is not null) THEN
3059: wf_Notification.SetAttrText(x_nid, 'EVENT_TITLE', p_event_title);
3060: wf_Notification.SetAttrText(x_nid, 'AUCTION_CANCELED_SUB',
3061: getMessage('PON_AUC_WF_CANCEL_EVENT_SUB', x_msg_suffix,
3062: 'DOC_NUMBER', p_doc_number_dsp,
3063: 'AUCTION_TITLE', p_auction_title,
3064: 'EVENT_TITLE', p_event_title));

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

3062: 'DOC_NUMBER', p_doc_number_dsp,
3063: 'AUCTION_TITLE', p_auction_title,
3064: 'EVENT_TITLE', p_event_title));
3065: ELSE
3066: wf_Notification.SetAttrText(x_nid, 'AUCTION_CANCELED_SUB',
3067: getMessage('PON_AUC_WF_AUC_CANCEL_SUB', x_msg_suffix,
3068: 'DOC_NUMBER', p_doc_number_dsp,
3069: 'AUCTION_TITLE', p_auction_title));
3070: END IF;

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

3069: 'AUCTION_TITLE', p_auction_title));
3070: END IF;
3071:
3072: IF (empty_reason(x_cancel_reason) = 'N') then
3073: wf_Notification.SetAttrText(x_nid, 'CANCEL_REASON', x_cancel_reason);
3074: END IF;
3075:
3076: ELSIF (p_action_code = 'DISQUALIFY_BID') then
3077:

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

3074: END IF;
3075:
3076: ELSIF (p_action_code = 'DISQUALIFY_BID') then
3077:
3078: wf_Notification.SetAttrText(x_nid, 'TP_TIME_ZONE', x_timezone_disp);
3079:
3080: -- convert the disqualify date to user's timezone
3081: x_new_disqualify_date := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(x_disqualify_date,x_oex_timezone,x_timezone);
3082:

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

3079:
3080: -- convert the disqualify date to user's timezone
3081: x_new_disqualify_date := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(x_disqualify_date,x_oex_timezone,x_timezone);
3082:
3083: wf_Notification.SetAttrDate(x_nid, 'DISQUALIFY_DATE', x_new_disqualify_date);
3084: wf_Notification.SetAttrText(x_nid, 'BID', x_bid_name);
3085: wf_Notification.SetAttrText ( x_nid, 'PON_WF_AUC_DSQ_OTH_SUB',
3086: getMessage('PON_WF_AUC_DSQ_OTH_SUB', x_msg_suffix,
3087: 'DOC_NUMBER', p_doc_number_dsp,

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

3080: -- convert the disqualify date to user's timezone
3081: x_new_disqualify_date := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(x_disqualify_date,x_oex_timezone,x_timezone);
3082:
3083: wf_Notification.SetAttrDate(x_nid, 'DISQUALIFY_DATE', x_new_disqualify_date);
3084: wf_Notification.SetAttrText(x_nid, 'BID', x_bid_name);
3085: wf_Notification.SetAttrText ( x_nid, 'PON_WF_AUC_DSQ_OTH_SUB',
3086: getMessage('PON_WF_AUC_DSQ_OTH_SUB', x_msg_suffix,
3087: 'DOC_NUMBER', p_doc_number_dsp,
3088: 'AUCTION_TITLE', p_auction_title));

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

3081: x_new_disqualify_date := PON_OEX_TIMEZONE_PKG.CONVERT_TIME(x_disqualify_date,x_oex_timezone,x_timezone);
3082:
3083: wf_Notification.SetAttrDate(x_nid, 'DISQUALIFY_DATE', x_new_disqualify_date);
3084: wf_Notification.SetAttrText(x_nid, 'BID', x_bid_name);
3085: wf_Notification.SetAttrText ( x_nid, 'PON_WF_AUC_DSQ_OTH_SUB',
3086: getMessage('PON_WF_AUC_DSQ_OTH_SUB', x_msg_suffix,
3087: 'DOC_NUMBER', p_doc_number_dsp,
3088: 'AUCTION_TITLE', p_auction_title));
3089: END IF;

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

9257: l_supp_ack :='B-NO';
9258: END IF;
9259:
9260: if (l_notification_id > 0) then
9261: Wf_Notification.SetAttrText(l_notification_id, 'RESULT', l_supp_ack);
9262: Wf_Notification.SetAttrText(l_notification_id, 'NOTE_TO_BUYER', p_ack_note);
9263: Wf_Notification.Respond(l_notification_id, 'On-Line', p_user_name);
9264: end if;
9265:

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

9258: END IF;
9259:
9260: if (l_notification_id > 0) then
9261: Wf_Notification.SetAttrText(l_notification_id, 'RESULT', l_supp_ack);
9262: Wf_Notification.SetAttrText(l_notification_id, 'NOTE_TO_BUYER', p_ack_note);
9263: Wf_Notification.Respond(l_notification_id, 'On-Line', p_user_name);
9264: end if;
9265:
9266: x_return_status := 0;

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

9259:
9260: if (l_notification_id > 0) then
9261: Wf_Notification.SetAttrText(l_notification_id, 'RESULT', l_supp_ack);
9262: Wf_Notification.SetAttrText(l_notification_id, 'NOTE_TO_BUYER', p_ack_note);
9263: Wf_Notification.Respond(l_notification_id, 'On-Line', p_user_name);
9264: end if;
9265:
9266: x_return_status := 0;
9267: