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 PON_AUCTION_PKG

Line 1: PACKAGE BODY PON_AUCTION_PKG as

1: PACKAGE BODY PON_AUCTION_PKG as
2: /* $Header: PONAUCTB.pls 120.93.12010000.2 2008/08/03 03:45:17 sarunach ship $ */
3:
4: g_module_prefix CONSTANT VARCHAR2(50) := 'pon.plsql.PON_AUCTION_PKG.';
5: g_userName varchar2(2000);

Line 4: g_module_prefix CONSTANT VARCHAR2(50) := 'pon.plsql.PON_AUCTION_PKG.';

1: PACKAGE BODY PON_AUCTION_PKG as
2: /* $Header: PONAUCTB.pls 120.93.12010000.2 2008/08/03 03:45:17 sarunach ship $ */
3:
4: g_module_prefix CONSTANT VARCHAR2(50) := 'pon.plsql.PON_AUCTION_PKG.';
5: g_userName varchar2(2000);
6: g_phoneNumber varchar2(2000);
7: g_faxNumber varchar2(2000);
8: g_eMail varchar2(2000);

Line 10: g_module varchar2(200) := 'pon.plsql.pon_auction_pkg';

6: g_phoneNumber varchar2(2000);
7: g_faxNumber varchar2(2000);
8: g_eMail varchar2(2000);
9: p_t_zone_temp varchar2(20) := '243';
10: g_module varchar2(200) := 'pon.plsql.pon_auction_pkg';
11: g_original_language FND_LANGUAGES.nls_language%TYPE;
12: g_original_lang_code FND_LANGUAGES.language_code%TYPE;
13: g_tp_cache_rec two_part_cache_rec; -- bug 6374353
14:

Line 515: module => 'pon.plsql.pon_auction_pkg.email_list',

511: WHEN TOO_MANY_ROWS THEN
512: IF (NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y') THEN
513: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
514: FND_LOG.string(log_level => FND_LOG.level_unexpected,
515: module => 'pon.plsql.pon_auction_pkg.email_list',
516: message => 'Multiple Users found for person_party_id:'|| x_auction_contact_id);
517: END IF;
518: END IF;
519: select user_name,

Line 714: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));

710:
711: wf_engine.SetItemAttrText (itemtype => x_itemtype,
712: itemkey => x_itemkey,
713: aname => 'PREVIEW_DATE_NOTSPECIFIED',
714: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
715: END IF;
716:
717: --Bug 6268467 : Shifted the operation of setting of the attribute NET_CHANGES_URL to this place (i.e. after call to SET_SESSION_LANGUAGE) so that the
718: --logged in user will be able to login to the application in the language that is set in his preferences.

Line 1269: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));

1265:
1266: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1267: itemkey => x_itemkey,
1268: aname => 'PREVIEW_DATE_NOTSPECIFIED',
1269: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
1270: END IF;
1271:
1272:
1273: if (p_event_id is not null) then

Line 1920: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));

1916:
1917: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1918: itemkey => x_itemkey,
1919: aname => 'PREVIEW_DATE_NOTSPECIFIED',
1920: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
1921: ELSE
1922: x_timezone1_disp := x_timezone_disp;
1923:
1924: wf_engine.SetItemAttrDate (itemtype => x_itemtype,

Line 2547: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));

2543:
2544: wf_engine.SetItemAttrText (itemtype => x_itemtype,
2545: itemkey => x_itemkey,
2546: aname => 'PREVIEW_DATE_NOTSPECIFIED',
2547: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
2548: ELSE
2549: x_timezone1_disp := x_timezone_disp;
2550:
2551: wf_engine.SetItemAttrDate (itemtype => x_itemtype,

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 3563: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));

3559:
3560: wf_engine.SetItemAttrText (itemtype => x_itemtype,
3561: itemkey => x_itemkey,
3562: aname => 'PREVIEW_DATE_NOTSPECIFIED',
3563: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
3564: END IF;
3565:
3566: x_msg_suffix := GET_MESSAGE_SUFFIX (x_doctype_group_name);
3567:

Line 3851: module => 'pon.plsql.pon_auction_pkg.populate_role_with_invitees',

3847: when too_many_rows then
3848: if (nvl(fnd_profile.value('AFLOG_ENABLED'),'N') = 'Y') then
3849: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
3850: fnd_log.string(log_level => fnd_log.level_unexpected,
3851: module => 'pon.plsql.pon_auction_pkg.populate_role_with_invitees',
3852: message => 'Multiple Users found for person_party_id:'|| x_person_party_id);
3853: end if;
3854: end if;
3855:

Line 4254: module => 'pon.plsql.pon_auction_pkg.check_auction_bidder',

4250: when too_many_rows then
4251: if (nvl(fnd_profile.value('AFLOG_ENABLED'),'N') = 'Y') then
4252: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
4253: fnd_log.string(log_level => fnd_log.level_unexpected,
4254: module => 'pon.plsql.pon_auction_pkg.check_auction_bidder',
4255: message => 'Multiple Users found for person_party_id:'|| p_trading_partner_contact_id);
4256: end if;
4257: end if;
4258:

Line 5339: module => 'pon.plsql.pon_auction_pkg.closeearly_auction',

5335: WHEN TOO_MANY_ROWS THEN
5336: if (nvl(fnd_profile.value('AFLOG_ENABLED'),'N') = 'Y') then
5337: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
5338: fnd_log.string(log_level => fnd_log.level_unexpected,
5339: module => 'pon.plsql.pon_auction_pkg.closeearly_auction',
5340: message => 'Multiple Users found for person_party_id:'|| x_contact_id);
5341: end if;
5342: end if;
5343:

Line 5452: module => 'pon.plsql.pon_auction_pkg.closechanged_auction',

5448: WHEN TOO_MANY_ROWS THEN
5449: if (nvl(fnd_profile.value('AFLOG_ENABLED'),'N') = 'Y') then
5450: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
5451: fnd_log.string(log_level => fnd_log.level_unexpected,
5452: module => 'pon.plsql.pon_auction_pkg.closechanged_auction',
5453: message => 'Multiple Users found for person_party_id:'|| x_contact_id);
5454: end if;
5455: end if;
5456:

Line 5559: --message := PON_PROFILE_UTIL_PKG.GET_STRING(PON_AUCTION_PKG.OperationId, 'PON', msg, PON_AUCTION_PKG.SessionLanguage);

5555: BEGIN
5556: BEGIN
5557:
5558: -- In ERP only three arguements.
5559: --message := PON_PROFILE_UTIL_PKG.GET_STRING(PON_AUCTION_PKG.OperationId, 'PON', msg, PON_AUCTION_PKG.SessionLanguage);
5560: message := PON_PROFILE_UTIL_PKG.GET_STRING('PON', msg, PON_AUCTION_PKG.SessionLanguage);
5561:
5562: if (message is null) then
5563: message := fnd_message.get_string('PON', msg);

Line 5560: message := PON_PROFILE_UTIL_PKG.GET_STRING('PON', msg, PON_AUCTION_PKG.SessionLanguage);

5556: BEGIN
5557:
5558: -- In ERP only three arguements.
5559: --message := PON_PROFILE_UTIL_PKG.GET_STRING(PON_AUCTION_PKG.OperationId, 'PON', msg, PON_AUCTION_PKG.SessionLanguage);
5560: message := PON_PROFILE_UTIL_PKG.GET_STRING('PON', msg, PON_AUCTION_PKG.SessionLanguage);
5561:
5562: if (message is null) then
5563: message := fnd_message.get_string('PON', msg);
5564: end if;

Line 5624: message := GET_STRING('PON', msg, PON_AUCTION_PKG.SessionLanguage);

5620: message VARCHAR2(1000);
5621: application_code VARCHAR2(5) := 'PON';
5622: BEGIN
5623: BEGIN
5624: message := GET_STRING('PON', msg, PON_AUCTION_PKG.SessionLanguage);
5625: EXCEPTION
5626: WHEN others THEN
5627: message := null;
5628: END;

Line 5929: message => 'Setting PON_AUCTION_PKG.SessionLanguage to x_language_code : ' || x_language_code);

5925:
5926: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
5927: FND_LOG.string(log_level => FND_LOG.level_statement,
5928: module => g_module_prefix || 'SET_SESSION_LANGUAGE',
5929: message => 'Setting PON_AUCTION_PKG.SessionLanguage to x_language_code : ' || x_language_code);
5930: END IF; --}
5931:
5932: -- set this package variable to be used with the get_message calls.
5933: PON_AUCTION_PKG.SessionLanguage := x_language_code;

Line 5933: PON_AUCTION_PKG.SessionLanguage := x_language_code;

5929: message => 'Setting PON_AUCTION_PKG.SessionLanguage to x_language_code : ' || x_language_code);
5930: END IF; --}
5931:
5932: -- set this package variable to be used with the get_message calls.
5933: PON_AUCTION_PKG.SessionLanguage := x_language_code;
5934:
5935: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
5936: FND_LOG.string(log_level => FND_LOG.level_statement,
5937: module => g_module_prefix || 'SET_SESSION_LANGUAGE',

Line 5938: message => 'Setting PON_AUCTION_PKG.SessionLanguage : ' || PON_AUCTION_PKG.SessionLanguage);

5934:
5935: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
5936: FND_LOG.string(log_level => FND_LOG.level_statement,
5937: module => g_module_prefix || 'SET_SESSION_LANGUAGE',
5938: message => 'Setting PON_AUCTION_PKG.SessionLanguage : ' || PON_AUCTION_PKG.SessionLanguage);
5939: END IF; --}
5940:
5941: END;
5942:

Line 5975: message => 'Setting PON_AUCTION_PKG.SessionLanguage to g_original_lang_code : ' || g_original_lang_code);

5971:
5972: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
5973: FND_LOG.string(log_level => FND_LOG.level_statement,
5974: module => g_module_prefix || 'UNSET_SESSION_LANGUAGE',
5975: message => 'Setting PON_AUCTION_PKG.SessionLanguage to g_original_lang_code : ' || g_original_lang_code);
5976: END IF; --}
5977: -- unset this package variable (used by the get_message calls).
5978: -- PON_AUCTION_PKG.SessionLanguage := 'US';
5979: PON_AUCTION_PKG.SessionLanguage := g_original_lang_code;

Line 5978: -- PON_AUCTION_PKG.SessionLanguage := 'US';

5974: module => g_module_prefix || 'UNSET_SESSION_LANGUAGE',
5975: message => 'Setting PON_AUCTION_PKG.SessionLanguage to g_original_lang_code : ' || g_original_lang_code);
5976: END IF; --}
5977: -- unset this package variable (used by the get_message calls).
5978: -- PON_AUCTION_PKG.SessionLanguage := 'US';
5979: PON_AUCTION_PKG.SessionLanguage := g_original_lang_code;
5980:
5981: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
5982: FND_LOG.string(log_level => FND_LOG.level_statement,

Line 5979: PON_AUCTION_PKG.SessionLanguage := g_original_lang_code;

5975: message => 'Setting PON_AUCTION_PKG.SessionLanguage to g_original_lang_code : ' || g_original_lang_code);
5976: END IF; --}
5977: -- unset this package variable (used by the get_message calls).
5978: -- PON_AUCTION_PKG.SessionLanguage := 'US';
5979: PON_AUCTION_PKG.SessionLanguage := g_original_lang_code;
5980:
5981: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
5982: FND_LOG.string(log_level => FND_LOG.level_statement,
5983: module => g_module_prefix || 'UNSET_SESSION_LANGUAGE',

Line 5984: message => 'Setting PON_AUCTION_PKG.SessionLanguage : ' || PON_AUCTION_PKG.SessionLanguage);

5980:
5981: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
5982: FND_LOG.string(log_level => FND_LOG.level_statement,
5983: module => g_module_prefix || 'UNSET_SESSION_LANGUAGE',
5984: message => 'Setting PON_AUCTION_PKG.SessionLanguage : ' || PON_AUCTION_PKG.SessionLanguage);
5985: END IF; --}
5986:
5987: END;
5988:

Line 7001: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));

6997:
6998: wf_engine.SetItemAttrText (itemtype => t_itemtype,
6999: itemkey => t_itemkey,
7000: aname => 'PREVIEW_DATE_NOTSPECIFIED',
7001: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
7002:
7003: END IF;
7004:
7005: wf_engine.SetItemAttrDate (itemtype => t_itemtype,

Line 7242: module => 'pon.plsql.pon_auction_pkg.get_user_name',

7238: when too_many_rows then
7239: if (nvl(fnd_profile.value('AFLOG_ENABLED'),'N') = 'Y') then
7240: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
7241: fnd_log.string(log_level => fnd_log.level_unexpected,
7242: module => 'pon.plsql.pon_auction_pkg.get_user_name',
7243: message => 'Multiple Users found for person_party_id:'|| p_user_id);
7244: end if;
7245: end if;
7246:

Line 7361: module => 'pon.plsql.pon_auction_pkg.get_time_zone',

7357: when too_many_rows then
7358: if (nvl(fnd_profile.value('AFLOG_ENABLED'),'N') = 'Y') then
7359: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
7360: fnd_log.string(log_level => fnd_log.level_unexpected,
7361: module => 'pon.plsql.pon_auction_pkg.get_time_zone',
7362: message => 'Multiple Users found for person_party_id:'|| contact_id);
7363: end if;
7364: end if;
7365:

Line 7379: module => 'pon.plsql.pon_auction_pkg.get_time_zone',

7375: when NO_DATA_FOUND then
7376: if (nvl(fnd_profile.value('AFLOG_ENABLED'),'N') = 'Y') then
7377: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
7378: fnd_log.string(log_level => fnd_log.level_unexpected,
7379: module => 'pon.plsql.pon_auction_pkg.get_time_zone',
7380: message => 'No Active Users found for person_party_id:'|| contact_id);
7381: end if;
7382: end if;
7383:

Line 7396: module => 'pon.plsql.pon_auction_pkg.get_time_zone',

7392: when OTHERS then
7393: if (nvl(fnd_profile.value('AFLOG_ENABLED'),'N') = 'Y') then
7394: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
7395: fnd_log.string(log_level => fnd_log.level_unexpected,
7396: module => 'pon.plsql.pon_auction_pkg.get_time_zone',
7397: message => 'Unknown exception for person_party_id:'|| contact_id);
7398: end if;
7399: end if;
7400: x_timezone := Get_Oex_Time_Zone;

Line 7470: PON_AUCTION_PKG.SessionLanguage := sLanguage;

7466: line_number = lineNumber;
7467: Begin
7468: begin
7469: sLanguage := USERENV('LANG');
7470: PON_AUCTION_PKG.SessionLanguage := sLanguage;
7471:
7472: open c1(auctionID,lineNumber);
7473: loop
7474: fetch c1 into needByFromDate,needByToDate;

Line 8762: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));

8758:
8759: wf_engine.SetItemAttrText (itemtype => x_itemtype,
8760: itemkey => x_itemkey,
8761: aname => 'PREVIEW_DATE_NOTSPECIFIED',
8762: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
8763:
8764:
8765: END IF;
8766:

Line 9202: PON_AUCTION_PKG.Check_Unique_Wrapper(p_order_number, null,

9198:
9199: -- Set the connection's policy context
9200: mo_global.set_policy_context('S', v_org_id);
9201:
9202: PON_AUCTION_PKG.Check_Unique_Wrapper(p_order_number, null,
9203: v_contract_type, v_is_unique);
9204:
9205: -- Set the org context back
9206: mo_global.set_policy_context(v_old_policy, v_old_org_id);

Line 9961: l_task_assigned_subject := PON_AUCTION_PKG.getMessage( msg => 'PON_AUC_TASK_ASN_NOTIF_SUB',

9957: x_timezone_disp =>l_timezone_disp);
9958:
9959: l_progress := '040';
9960:
9961: l_task_assigned_subject := PON_AUCTION_PKG.getMessage( msg => 'PON_AUC_TASK_ASN_NOTIF_SUB',
9962: msg_suffix => '_'|| l_msg_suffix,
9963: token1 => 'DOC_NUMBER',
9964: token1_value => l_doc_number,
9965: token2 => 'AUCTION_TITLE',

Line 10224: module => 'pon.plsql.pon_auction_pkg.send_task_compl_notif',

10220: WHEN TOO_MANY_ROWS THEN
10221: if (nvl(fnd_profile.value('AFLOG_ENABLED'),'N') = 'Y') then
10222: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
10223: fnd_log.string(log_level => fnd_log.level_unexpected,
10224: module => 'pon.plsql.pon_auction_pkg.send_task_compl_notif',
10225: message => 'Multiple Users found for auction_header_id:'|| p_auction_header_id);
10226: end if;
10227: end if;
10228:

Line 10360: l_task_completed_subject := PON_AUCTION_PKG.getMessage( msg => 'PON_AUC_TASK_COMPL_NOTIF_SUB',

10356: x_timezone_disp =>l_timezone_disp);
10357:
10358: l_progress := '040';
10359:
10360: l_task_completed_subject := PON_AUCTION_PKG.getMessage( msg => 'PON_AUC_TASK_COMPL_NOTIF_SUB',
10361: msg_suffix => '_'|| l_msg_suffix,
10362: token1 => 'DOC_NUMBER',
10363: token1_value => l_doc_number,
10364: token2 => 'AUCTION_TITLE',

Line 10622: module => 'pon.plsql.pon_auction_pkg.send_resp_notif',

10618: WHEN TOO_MANY_ROWS THEN
10619: if (nvl(fnd_profile.value('AFLOG_ENABLED'),'N') = 'Y') then
10620: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
10621: fnd_log.string(log_level => fnd_log.level_unexpected,
10622: module => 'pon.plsql.pon_auction_pkg.send_resp_notif',
10623: message => 'Multiple Users found for bid number:'|| p_bid_number);
10624: end if;
10625: end if;
10626:

Line 10734: l_resp_publish_sub := PON_AUCTION_PKG.getMessage( msg => 'PON_AUC_RESP_SUBM_NOTIF_SUB',

10730: l_progress := '040';
10731:
10732: -- Submitted: 4512 for 2759 (Equipment Renewal)
10733:
10734: l_resp_publish_sub := PON_AUCTION_PKG.getMessage( msg => 'PON_AUC_RESP_SUBM_NOTIF_SUB',
10735: msg_suffix => '_'||l_msg_suffix,
10736: token1 => 'RESPONSE_NUMBER',
10737: token1_value => p_bid_number,
10738: token2 => 'DOC_NUMBER',

Line 10765: l_response_type_name := PON_AUCTION_PKG.getMessage( msg => 'PON_AUCTS_BID',

10761:
10762: l_response_url := pon_wf_utl_pkg.get_dest_page_url (p_dest_func => 'PONRESENQ_VIEWBID'
10763: ,p_notif_performer => 'BUYER');
10764:
10765: l_response_type_name := PON_AUCTION_PKG.getMessage( msg => 'PON_AUCTS_BID',
10766: msg_suffix => '_'||l_msg_suffix);
10767:
10768: wf_engine.CreateProcess(itemtype => l_itemtype,
10769: itemkey => l_itemkey,

Line 10813: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));

10809:
10810: wf_engine.SetItemAttrText (itemtype => l_itemtype,
10811: itemkey => l_itemkey,
10812: aname => 'PREVIEW_DATE_NOTSPECIFIED',
10813: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
10814: END IF;
10815:
10816: l_progress := '090';
10817:

Line 11801: module => 'pon.plsql.pon_auction_pkg.notify_member 1',

11797: WHEN TOO_MANY_ROWS THEN
11798: IF (NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y') THEN
11799: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
11800: FND_LOG.string(log_level => FND_LOG.level_unexpected,
11801: module => 'pon.plsql.pon_auction_pkg.notify_member 1',
11802: message => 'Multiple Users found for person_party_id:'|| p_userPartyId);
11803: END IF;
11804: END IF;
11805:

Line 11834: module => 'pon.plsql.pon_auction_pkg.notify_member 2',

11830: WHEN TOO_MANY_ROWS THEN
11831: IF (NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y') THEN
11832: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
11833: FND_LOG.string(log_level => FND_LOG.level_unexpected,
11834: module => 'pon.plsql.pon_auction_pkg.notify_member 2',
11835: message => 'Multiple Users found for person_party_id:'|| p_from_id);
11836: END IF;
11837: END IF;
11838:

Line 11898: l_msg_sent_subject := PON_AUCTION_PKG.getMessage(msg => 'PON_DISC_MESSAGE_SENT_MSG',

11894: module => g_module || l_module_name,
11895: message => 'Negotiation Dates are converted to destination timezone: ' || l_timezone_disp);
11896: END IF;
11897:
11898: l_msg_sent_subject := PON_AUCTION_PKG.getMessage(msg => 'PON_DISC_MESSAGE_SENT_MSG',
11899: msg_suffix => '_'|| p_msg_suffix,
11900: token1 => 'DOC_NUMBER',
11901: token1_value => p_doc_number,
11902: token2 => 'NEG_TITLE',

Line 11921: l_timezone_nodisp := PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC');

11917: l_timezone_disp1 := l_timezone_disp;
11918: l_timezone_nodisp := NULL;
11919: ELSE
11920: l_timezone_disp1 := NULL;
11921: l_timezone_nodisp := PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC');
11922: END IF;
11923:
11924: l_progress := '040';
11925: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

Line 12218: module => 'pon.plsql.pon_auction_pkg.set_preview_date',

12214:
12215: IF (NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y') THEN
12216: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
12217: FND_LOG.string(log_level => FND_LOG.level_statement,
12218: module => 'pon.plsql.pon_auction_pkg.set_preview_date',
12219: message => 'Entered the procedure with params --- ' ||
12220: 'p_itemtype : ' || p_itemtype||
12221: ',p_itemkey : ' ||p_itemkey||
12222: ',p_preview_date : '||p_preview_date||

Line 12244: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_OPEN_IMM_AFTER_PUB',p_msg_suffix));

12240:
12241: wf_engine.SetItemAttrText (itemtype => p_itemtype,
12242: itemkey => p_itemkey,
12243: aname => 'PREVIEW_DATE_NOTSPECIFIED',
12244: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_OPEN_IMM_AFTER_PUB',p_msg_suffix));
12245:
12246: ELSIF (p_preview_date is NULL) THEN --if Not specified
12247:
12248: wf_engine.SetItemAttrDate (itemtype => p_itemtype,

Line 12261: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));

12257:
12258: wf_engine.SetItemAttrText (itemtype => p_itemtype,
12259: itemkey => p_itemkey,
12260: aname => 'PREVIEW_DATE_NOTSPECIFIED',
12261: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
12262:
12263: ELSE
12264: wf_engine.SetItemAttrDate (itemtype => p_itemtype,
12265: itemkey => p_itemkey,

Line 12283: module => 'pon.plsql.pon_auction_pkg.set_preview_date',

12279:
12280: IF (NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y') THEN
12281: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
12282: FND_LOG.string(log_level => FND_LOG.level_statement,
12283: module => 'pon.plsql.pon_auction_pkg.set_preview_date',
12284: message => 'Exiting the procedure');
12285: END IF;
12286: END IF;
12287:

Line 12303: module => 'pon.plsql.pon_auction_pkg.set_open_date',

12299:
12300: IF (NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y') THEN
12301: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
12302: FND_LOG.string(log_level => FND_LOG.level_statement,
12303: module => 'pon.plsql.pon_auction_pkg.set_open_date',
12304: message => 'Entered the procedure with params --- ' ||
12305: 'p_itemtype : ' || p_itemtype||
12306: ',p_itemkey : ' ||p_itemkey||
12307: ',p_auction_start_date : '||p_auction_start_date||

Line 12329: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_OPEN_IMM_AFTER_PUB',p_msg_suffix));

12325:
12326: wf_engine.SetItemAttrText (itemtype => p_itemtype,
12327: itemkey => p_itemkey,
12328: aname => 'OPEN_DATE_NOT_SPECIFIED',
12329: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_OPEN_IMM_AFTER_PUB',p_msg_suffix));
12330:
12331: ELSIF(p_auction_start_date is NULL) THEN --if not specified
12332: wf_engine.SetItemAttrDate (itemtype => p_itemtype,
12333: itemkey => p_itemkey,

Line 12345: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));

12341:
12342: wf_engine.SetItemAttrText (itemtype => p_itemtype,
12343: itemkey => p_itemkey,
12344: aname => 'OPEN_DATE_NOT_SPECIFIED',
12345: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
12346:
12347: ELSE
12348: wf_engine.SetItemAttrDate (itemtype => p_itemtype,
12349: itemkey => p_itemkey,

Line 12368: module => 'pon.plsql.pon_auction_pkg.set_open_date',

12364:
12365: IF (NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y') THEN
12366: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
12367: FND_LOG.string(log_level => FND_LOG.level_statement,
12368: module => 'pon.plsql.pon_auction_pkg.set_open_date',
12369: message => 'Exiting the procedure');
12370: END IF;
12371: END IF;
12372:

Line 12387: module => 'pon.plsql.pon_auction_pkg.set_close_date',

12383:
12384: IF (NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y') THEN
12385: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
12386: FND_LOG.string(log_level => FND_LOG.level_statement,
12387: module => 'pon.plsql.pon_auction_pkg.set_close_date',
12388: message => 'Entered the procedure with params --- ' ||
12389: 'p_itemtype : ' || p_itemtype||
12390: ',p_itemkey : ' ||p_itemkey||
12391: ',p_auction_end_date : '||p_auction_end_date||

Line 12411: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));

12407:
12408: wf_engine.SetItemAttrText (itemtype => p_itemtype,
12409: itemkey => p_itemkey,
12410: aname => 'CLOSE_DATE_NOT_SPECIFIED',
12411: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
12412:
12413:
12414: ELSE
12415: wf_engine.SetItemAttrDate (itemtype => p_itemtype,

Line 12436: module => 'pon.plsql.pon_auction_pkg.set_close_date',

12432:
12433: IF (NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y') THEN
12434: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
12435: FND_LOG.string(log_level => FND_LOG.level_statement,
12436: module => 'pon.plsql.pon_auction_pkg.set_close_date',
12437: message => 'Exiting the procedure');
12438: END IF;
12439: END IF;
12440:

Line 14076: END PON_AUCTION_PKG;

14072: message => 'Exiting procedure update_cache_rec');
14073: END IF; --}
14074: END update_cache_rec;
14075:
14076: END PON_AUCTION_PKG;