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.

[Home] [Help]

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.125.12020000.4 2013/03/21 05:10:49 pamaniko 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.125.12020000.4 2013/03/21 05:10:49 pamaniko 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 538: module => 'pon.plsql.pon_auction_pkg.email_list',

534: WHEN TOO_MANY_ROWS THEN
535: IF (NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y') THEN
536: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
537: FND_LOG.string(log_level => FND_LOG.level_unexpected,
538: module => 'pon.plsql.pon_auction_pkg.email_list',
539: message => 'Multiple Users found for person_party_id:'|| x_auction_contact_id);
540: END IF;
541: END IF;
542: select user_name,

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

733:
734: wf_engine.SetItemAttrText (itemtype => x_itemtype,
735: itemkey => x_itemkey,
736: aname => 'PREVIEW_DATE_NOTSPECIFIED',
737: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
738: END IF;
739:
740: --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
741: --logged in user will be able to login to the application in the language that is set in his preferences.

Line 994: avalue => 'PLSQLCLOB:pon_auction_pkg.GEN_AUC_AMEND_BODY/'||x_itemtype ||':' ||x_itemkey

990: --Bug 8446265 Modifications
991: wf_engine.SetItemAttrText (itemtype => x_itemtype,
992: itemkey => x_itemkey,
993: aname => 'PON_AMENDMENT_START_BODY',
994: avalue => 'PLSQLCLOB:pon_auction_pkg.GEN_AUC_AMEND_BODY/'||x_itemtype ||':' ||x_itemkey
995: );
996:
997: wf_engine.SetItemAttrText (itemtype => x_itemtype,
998: itemkey => x_itemkey,

Line 1000: avalue => 'PLSQLCLOB:pon_auction_pkg.GEN_INV_NEWRND_START_BODY/'||x_itemtype ||':' ||x_itemkey

996:
997: wf_engine.SetItemAttrText (itemtype => x_itemtype,
998: itemkey => x_itemkey,
999: aname => 'PON_INV_NEW_RND_START_BODY',
1000: avalue => 'PLSQLCLOB:pon_auction_pkg.GEN_INV_NEWRND_START_BODY/'||x_itemtype ||':' ||x_itemkey
1001: );
1002:
1003:
1004: wf_engine.SetItemAttrText (itemtype => x_itemtype,

Line 1007: avalue => 'PLSQLCLOB:pon_auction_pkg.GEN_INV_NEWRND_START_AD_BODY/'||x_itemtype ||':' ||x_itemkey

1003:
1004: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1005: itemkey => x_itemkey,
1006: aname => 'PON_INV_NEW_RND_START_AD_BODY',
1007: avalue => 'PLSQLCLOB:pon_auction_pkg.GEN_INV_NEWRND_START_AD_BODY/'||x_itemtype ||':' ||x_itemkey
1008: );
1009:
1010:
1011: wf_engine.SetItemAttrText (itemtype => x_itemtype,

Line 1014: avalue => 'PLSQLCLOB:pon_auction_pkg.GEN_INVITE_REQ_SUPP_RESP_BODY/'||x_itemtype ||':' ||x_itemkey

1010:
1011: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1012: itemkey => x_itemkey,
1013: aname => 'PON_INVITE_REQ_SUPP_RESP_BODY',
1014: avalue => 'PLSQLCLOB:pon_auction_pkg.GEN_INVITE_REQ_SUPP_RESP_BODY/'||x_itemtype ||':' ||x_itemkey
1015: );
1016:
1017:
1018: wf_engine.SetItemAttrText (itemtype => x_itemtype,

Line 1021: avalue => 'PLSQLCLOB:pon_auction_pkg.GEN_INVITE_CONT_RESP_BODY/'||x_itemtype ||':' ||x_itemkey

1017:
1018: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1019: itemkey => x_itemkey,
1020: aname => 'PON_INVITE_RESPONSE_BODY',
1021: avalue => 'PLSQLCLOB:pon_auction_pkg.GEN_INVITE_CONT_RESP_BODY/'||x_itemtype ||':' ||x_itemkey
1022: );
1023:
1024:
1025: wf_engine.SetItemAttrText (itemtype => x_itemtype,

Line 1028: avalue => 'PLSQLCLOB:pon_auction_pkg.GEN_INVITE_ADD_CONT_RESP_BODY/'||x_itemtype ||':' ||x_itemkey

1024:
1025: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1026: itemkey => x_itemkey,
1027: aname => 'PON_INV_RESP_ADD_CONT_BODY',
1028: avalue => 'PLSQLCLOB:pon_auction_pkg.GEN_INVITE_ADD_CONT_RESP_BODY/'||x_itemtype ||':' ||x_itemkey
1029: );
1030: --Bug 8446265 Modifications
1031:
1032: -- Begin Supplier Management: Bug 10378806 / 11071755

Line 1037: avalue => 'PLSQLCLOB:pon_auction_pkg.GEN_REQ_SUPP_AUC_AMEND_BODY/'||x_itemtype ||':' ||x_itemkey

1033: -- RFI amendment / new round e-mail for prospective supplier
1034: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1035: itemkey => x_itemkey,
1036: aname => 'PON_REQ_SUPP_AMEND_START_BODY',
1037: avalue => 'PLSQLCLOB:pon_auction_pkg.GEN_REQ_SUPP_AUC_AMEND_BODY/'||x_itemtype ||':' ||x_itemkey
1038: );
1039:
1040: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1041: itemkey => x_itemkey,

Line 1043: avalue => 'PLSQLCLOB:pon_auction_pkg.GEN_INV_REQ_SUPP_NEWRND_BODY/'||x_itemtype ||':' ||x_itemkey

1039:
1040: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1041: itemkey => x_itemkey,
1042: aname => 'PON_INV_REQ_SUPP_NEWRND_BODY',
1043: avalue => 'PLSQLCLOB:pon_auction_pkg.GEN_INV_REQ_SUPP_NEWRND_BODY/'||x_itemtype ||':' ||x_itemkey
1044: );
1045: -- End Supplier Management: Bug 10378806 / 11071755
1046:
1047: -- Bug 4295915: Set the workflow owner

Line 1130: ,module => 'pon_auction_pkg.NotifyEmdAdminNegCancel'

1126: BEGIN
1127:
1128: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1129: fnd_log.string(log_level => fnd_log.level_unexpected
1130: ,module => 'pon_auction_pkg.NotifyEmdAdminNegCancel'
1131: ,message => 'Start calling NotifyEmdAdminNegCancel');
1132: END IF;
1133: x_progress := '010';
1134:

Line 1147: pon_auction_pkg.SET_SESSION_LANGUAGE(null, x_language_code);

1143: -- Set the userenv language so the message token (attribute) values that we retrieve using the
1144: -- getMessage call return the message in the correct language => x_language_code
1145:
1146:
1147: pon_auction_pkg.SET_SESSION_LANGUAGE(null, x_language_code);
1148:
1149: --
1150: -- Get next value in sequence for itemkey
1151: --

Line 1214: ,avalue => pon_auction_pkg.replaceHtmlChars(p_auction_title));

1210: /* Setting the negotiation title header attribute */
1211: wf_engine.SetItemAttrText(itemtype => x_itemtype
1212: ,itemkey => x_itemkey
1213: ,aname => 'AUCTION_TITLE'
1214: ,avalue => pon_auction_pkg.replaceHtmlChars(p_auction_title));
1215: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1216: itemkey => x_itemkey,
1217: aname => 'AUCTION_TYPE_NAME',
1218: avalue => x_auction_type_name);

Line 1242: pon_auction_pkg.UNSET_SESSION_LANGUAGE;

1238: --
1239:
1240: wf_engine.StartProcess(itemtype => x_itemtype,
1241: itemkey => x_itemkey );
1242: pon_auction_pkg.UNSET_SESSION_LANGUAGE;
1243:
1244: x_progress := '029';
1245: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1246: fnd_log.string(log_level => fnd_log.level_unexpected

Line 1247: ,module => 'pon_auction_pkg.NotifyEmdAdminNegCancel'

1243:
1244: x_progress := '029';
1245: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1246: fnd_log.string(log_level => fnd_log.level_unexpected
1247: ,module => 'pon_auction_pkg.NotifyEmdAdminNegCancel'
1248: ,message => 'End calling NotifyEmdAdminNegCancel');
1249: END IF;
1250:
1251: END;

Line 1280: ,module => 'pon_auction_pkg.email_emd_admins'

1276:
1277: BEGIN
1278: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1279: fnd_log.string(log_level => fnd_log.level_unexpected
1280: ,module => 'pon_auction_pkg.email_emd_admins'
1281: ,message => 'Start calling email_emd_admins');
1282: END IF;
1283: BEGIN
1284: select action_note

Line 1322: ,module => 'pon_auction_pkg.email_emd_admins'

1318: end loop;
1319: close all_emdAdmins;
1320: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1321: fnd_log.string(log_level => fnd_log.level_unexpected
1322: ,module => 'pon_auction_pkg.email_emd_admins'
1323: ,message => 'End calling email_emd_admins');
1324: END IF;
1325:
1326: END;

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

1710:
1711: wf_engine.SetItemAttrText (itemtype => x_itemtype,
1712: itemkey => x_itemkey,
1713: aname => 'PREVIEW_DATE_NOTSPECIFIED',
1714: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
1715: END IF;
1716:
1717:
1718: if (p_event_id is not null) then

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

2378:
2379: wf_engine.SetItemAttrText (itemtype => x_itemtype,
2380: itemkey => x_itemkey,
2381: aname => 'PREVIEW_DATE_NOTSPECIFIED',
2382: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
2383: ELSE
2384: x_timezone1_disp := x_timezone_disp;
2385:
2386: wf_engine.SetItemAttrDate (itemtype => x_itemtype,

Line 2446: avalue => 'PLSQLCLOB:pon_auction_pkg.GEN_PON_DSQBID_BODY/'||x_itemtype ||':' ||x_itemkey

2442: -- Bug 8446265 Modification
2443: wf_engine.SetItemAttrText (itemtype => x_itemtype,
2444: itemkey => x_itemkey,
2445: aname => 'PON_DSQBID_BODY',
2446: avalue => 'PLSQLCLOB:pon_auction_pkg.GEN_PON_DSQBID_BODY/'||x_itemtype ||':' ||x_itemkey
2447: );
2448:
2449:
2450:

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

3027:
3028: wf_engine.SetItemAttrText (itemtype => x_itemtype,
3029: itemkey => x_itemkey,
3030: aname => 'PREVIEW_DATE_NOTSPECIFIED',
3031: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
3032: ELSE
3033: x_timezone1_disp := x_timezone_disp;
3034:
3035: wf_engine.SetItemAttrDate (itemtype => x_itemtype,

Line 3088: avalue => 'PLSQLCLOB:pon_auction_pkg.GEN_AWARD_LINES_BODY/'||x_itemtype ||':' ||x_itemkey

3084: --Bug 8446265 Modifications
3085: wf_engine.SetItemAttrText (itemtype => x_itemtype,
3086: itemkey => x_itemkey,
3087: aname => 'PON_AUC_WF_AWARD_L_BODY',
3088: avalue => 'PLSQLCLOB:pon_auction_pkg.GEN_AWARD_LINES_BODY/'||x_itemtype ||':' ||x_itemkey
3089: );
3090:
3091:
3092: wf_engine.SetItemAttrText (itemtype => x_itemtype,

Line 3095: avalue => 'PLSQLCLOB:pon_auction_pkg.GEN_AWARD_NOLINES_BODY/'||x_itemtype ||':' ||x_itemkey

3091:
3092: wf_engine.SetItemAttrText (itemtype => x_itemtype,
3093: itemkey => x_itemkey,
3094: aname => 'PON_AUC_WF_AWARD_NL_BODY',
3095: avalue => 'PLSQLCLOB:pon_auction_pkg.GEN_AWARD_NOLINES_BODY/'||x_itemtype ||':' ||x_itemkey
3096: );
3097:
3098: wf_engine.SetItemAttrText (itemtype => x_itemtype,
3099: itemkey => x_itemkey,

Line 3101: avalue => 'PLSQLCLOB:pon_auction_pkg.GEN_AWARD_EVENT_LINES_BODY/'||x_itemtype ||':' ||x_itemkey

3097:
3098: wf_engine.SetItemAttrText (itemtype => x_itemtype,
3099: itemkey => x_itemkey,
3100: aname => 'PON_AUC_WF_AWARD_EVENT_L_BODY',
3101: avalue => 'PLSQLCLOB:pon_auction_pkg.GEN_AWARD_EVENT_LINES_BODY/'||x_itemtype ||':' ||x_itemkey
3102: );
3103:
3104: wf_engine.SetItemAttrText (itemtype => x_itemtype,
3105: itemkey => x_itemkey,

Line 3107: avalue => 'PLSQLCLOB:pon_auction_pkg.GEN_AWARD_EVENT_NOLINES_BODY/'||x_itemtype ||':' ||x_itemkey

3103:
3104: wf_engine.SetItemAttrText (itemtype => x_itemtype,
3105: itemkey => x_itemkey,
3106: aname => 'PON_AUC_WF_AWARD_EVENT_NL_BODY',
3107: avalue => 'PLSQLCLOB:pon_auction_pkg.GEN_AWARD_EVENT_NOLINES_BODY/'||x_itemtype ||':' ||x_itemkey
3108: );
3109:
3110: UNSET_SESSION_LANGUAGE;
3111:

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

4080:
4081: wf_engine.SetItemAttrText (itemtype => x_itemtype,
4082: itemkey => x_itemkey,
4083: aname => 'PREVIEW_DATE_NOTSPECIFIED',
4084: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
4085: END IF;
4086:
4087: x_msg_suffix := GET_MESSAGE_SUFFIX (x_doctype_group_name);
4088:

Line 4132: avalue => 'PLSQLCLOB:pon_auction_pkg.GEN_PON_ARI_UNINVITED_BODY/'||x_itemtype ||':' ||x_itemkey

4128: --Bug 8446265 Modifications
4129: wf_engine.SetItemAttrText (itemtype => x_itemtype,
4130: itemkey => x_itemkey,
4131: aname => 'PON_NON_INV_NEW_RND_START_BODY',
4132: avalue => 'PLSQLCLOB:pon_auction_pkg.GEN_PON_ARI_UNINVITED_BODY/'||x_itemtype ||':' ||x_itemkey
4133: );
4134:
4135:
4136: -- Bug 4295915: Set the workflow owner

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

4413: when too_many_rows then
4414: if (nvl(fnd_profile.value('AFLOG_ENABLED'),'N') = 'Y') then
4415: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
4416: fnd_log.string(log_level => fnd_log.level_unexpected,
4417: module => 'pon.plsql.pon_auction_pkg.populate_role_with_invitees',
4418: message => 'Multiple Users found for person_party_id:'|| x_person_party_id);
4419: end if;
4420: end if;
4421:

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

4836: when too_many_rows then
4837: if (nvl(fnd_profile.value('AFLOG_ENABLED'),'N') = 'Y') then
4838: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
4839: fnd_log.string(log_level => fnd_log.level_unexpected,
4840: module => 'pon.plsql.pon_auction_pkg.check_auction_bidder',
4841: message => 'Multiple Users found for person_party_id:'|| p_trading_partner_contact_id);
4842: end if;
4843: end if;
4844:

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

5931: WHEN TOO_MANY_ROWS THEN
5932: if (nvl(fnd_profile.value('AFLOG_ENABLED'),'N') = 'Y') then
5933: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
5934: fnd_log.string(log_level => fnd_log.level_unexpected,
5935: module => 'pon.plsql.pon_auction_pkg.closeearly_auction',
5936: message => 'Multiple Users found for person_party_id:'|| x_contact_id);
5937: end if;
5938: end if;
5939:

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

6044: WHEN TOO_MANY_ROWS THEN
6045: if (nvl(fnd_profile.value('AFLOG_ENABLED'),'N') = 'Y') then
6046: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
6047: fnd_log.string(log_level => fnd_log.level_unexpected,
6048: module => 'pon.plsql.pon_auction_pkg.closechanged_auction',
6049: message => 'Multiple Users found for person_party_id:'|| x_contact_id);
6050: end if;
6051: end if;
6052:

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

6151: BEGIN
6152: BEGIN
6153:
6154: -- In ERP only three arguements.
6155: --message := PON_PROFILE_UTIL_PKG.GET_STRING(PON_AUCTION_PKG.OperationId, 'PON', msg, PON_AUCTION_PKG.SessionLanguage);
6156: message := PON_PROFILE_UTIL_PKG.GET_STRING('PON', msg, PON_AUCTION_PKG.SessionLanguage);
6157:
6158: if (message is null) then
6159: message := fnd_message.get_string('PON', msg);

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

6152: BEGIN
6153:
6154: -- In ERP only three arguements.
6155: --message := PON_PROFILE_UTIL_PKG.GET_STRING(PON_AUCTION_PKG.OperationId, 'PON', msg, PON_AUCTION_PKG.SessionLanguage);
6156: message := PON_PROFILE_UTIL_PKG.GET_STRING('PON', msg, PON_AUCTION_PKG.SessionLanguage);
6157:
6158: if (message is null) then
6159: message := fnd_message.get_string('PON', msg);
6160: end if;

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

6216: message VARCHAR2(1000);
6217: application_code VARCHAR2(5) := 'PON';
6218: BEGIN
6219: BEGIN
6220: message := GET_STRING('PON', msg, PON_AUCTION_PKG.SessionLanguage);
6221: EXCEPTION
6222: WHEN others THEN
6223: message := null;
6224: END;

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

6521:
6522: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6523: FND_LOG.string(log_level => FND_LOG.level_statement,
6524: module => g_module_prefix || 'SET_SESSION_LANGUAGE',
6525: message => 'Setting PON_AUCTION_PKG.SessionLanguage to x_language_code : ' || x_language_code);
6526: END IF; --}
6527:
6528: -- set this package variable to be used with the get_message calls.
6529: PON_AUCTION_PKG.SessionLanguage := x_language_code;

Line 6529: PON_AUCTION_PKG.SessionLanguage := x_language_code;

6525: message => 'Setting PON_AUCTION_PKG.SessionLanguage to x_language_code : ' || x_language_code);
6526: END IF; --}
6527:
6528: -- set this package variable to be used with the get_message calls.
6529: PON_AUCTION_PKG.SessionLanguage := x_language_code;
6530:
6531: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6532: FND_LOG.string(log_level => FND_LOG.level_statement,
6533: module => g_module_prefix || 'SET_SESSION_LANGUAGE',

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

6530:
6531: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6532: FND_LOG.string(log_level => FND_LOG.level_statement,
6533: module => g_module_prefix || 'SET_SESSION_LANGUAGE',
6534: message => 'Setting PON_AUCTION_PKG.SessionLanguage : ' || PON_AUCTION_PKG.SessionLanguage);
6535: END IF; --}
6536:
6537: END;
6538:

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

6567:
6568: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6569: FND_LOG.string(log_level => FND_LOG.level_statement,
6570: module => g_module_prefix || 'UNSET_SESSION_LANGUAGE',
6571: message => 'Setting PON_AUCTION_PKG.SessionLanguage to g_original_lang_code : ' || g_original_lang_code);
6572: END IF; --}
6573: -- unset this package variable (used by the get_message calls).
6574: -- PON_AUCTION_PKG.SessionLanguage := 'US';
6575: PON_AUCTION_PKG.SessionLanguage := g_original_lang_code;

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

6570: module => g_module_prefix || 'UNSET_SESSION_LANGUAGE',
6571: message => 'Setting PON_AUCTION_PKG.SessionLanguage to g_original_lang_code : ' || g_original_lang_code);
6572: END IF; --}
6573: -- unset this package variable (used by the get_message calls).
6574: -- PON_AUCTION_PKG.SessionLanguage := 'US';
6575: PON_AUCTION_PKG.SessionLanguage := g_original_lang_code;
6576:
6577: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6578: FND_LOG.string(log_level => FND_LOG.level_statement,

Line 6575: PON_AUCTION_PKG.SessionLanguage := g_original_lang_code;

6571: message => 'Setting PON_AUCTION_PKG.SessionLanguage to g_original_lang_code : ' || g_original_lang_code);
6572: END IF; --}
6573: -- unset this package variable (used by the get_message calls).
6574: -- PON_AUCTION_PKG.SessionLanguage := 'US';
6575: PON_AUCTION_PKG.SessionLanguage := g_original_lang_code;
6576:
6577: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6578: FND_LOG.string(log_level => FND_LOG.level_statement,
6579: module => g_module_prefix || 'UNSET_SESSION_LANGUAGE',

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

6576:
6577: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
6578: FND_LOG.string(log_level => FND_LOG.level_statement,
6579: module => g_module_prefix || 'UNSET_SESSION_LANGUAGE',
6580: message => 'Setting PON_AUCTION_PKG.SessionLanguage : ' || PON_AUCTION_PKG.SessionLanguage);
6581: END IF; --}
6582:
6583: END;
6584:

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

7635:
7636: wf_engine.SetItemAttrText (itemtype => t_itemtype,
7637: itemkey => t_itemkey,
7638: aname => 'PREVIEW_DATE_NOTSPECIFIED',
7639: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
7640:
7641: END IF;
7642:
7643: wf_engine.SetItemAttrDate (itemtype => t_itemtype,

Line 7838: avalue => 'PLSQLCLOB:pon_auction_pkg.GEN_INVITE_REQ_SUPP_RESP_BODY/'||t_itemtype ||':' ||t_itemkey

7834: --Bug 8446265 Modifications
7835: wf_engine.SetItemAttrText (itemtype => t_itemtype,
7836: itemkey => t_itemkey,
7837: aname => 'PON_INVITE_REQ_SUPP_RESP_BODY',
7838: avalue => 'PLSQLCLOB:pon_auction_pkg.GEN_INVITE_REQ_SUPP_RESP_BODY/'||t_itemtype ||':' ||t_itemkey
7839: );
7840:
7841: wf_engine.SetItemAttrText (itemtype => t_itemtype,
7842: itemkey => t_itemkey,

Line 7844: avalue => 'PLSQLCLOB:pon_auction_pkg.GEN_INVITE_CONT_RESP_BODY/'||t_itemtype ||':' ||t_itemkey

7840:
7841: wf_engine.SetItemAttrText (itemtype => t_itemtype,
7842: itemkey => t_itemkey,
7843: aname => 'PON_INVITE_RESPONSE_BODY',
7844: avalue => 'PLSQLCLOB:pon_auction_pkg.GEN_INVITE_CONT_RESP_BODY/'||t_itemtype ||':' ||t_itemkey
7845: );
7846:
7847: wf_engine.SetItemAttrText (itemtype => t_itemtype,
7848: itemkey => t_itemkey,

Line 7850: avalue => 'PLSQLCLOB:pon_auction_pkg.GEN_INVITE_ADD_CONT_RESP_BODY/'||t_itemtype ||':' ||t_itemkey

7846:
7847: wf_engine.SetItemAttrText (itemtype => t_itemtype,
7848: itemkey => t_itemkey,
7849: aname => 'PON_INV_RESP_ADD_CONT_BODY',
7850: avalue => 'PLSQLCLOB:pon_auction_pkg.GEN_INVITE_ADD_CONT_RESP_BODY/'||t_itemtype ||':' ||t_itemkey
7851: );
7852:
7853: -- Bug 4295915: Set the workflow owner
7854: wf_engine.SetItemOwner(itemtype => t_itemtype,

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

7907: when too_many_rows then
7908: if (nvl(fnd_profile.value('AFLOG_ENABLED'),'N') = 'Y') then
7909: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
7910: fnd_log.string(log_level => fnd_log.level_unexpected,
7911: module => 'pon.plsql.pon_auction_pkg.get_user_name',
7912: message => 'Multiple Users found for person_party_id:'|| p_user_id);
7913: end if;
7914: end if;
7915:

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

8026: when too_many_rows then
8027: if (nvl(fnd_profile.value('AFLOG_ENABLED'),'N') = 'Y') then
8028: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
8029: fnd_log.string(log_level => fnd_log.level_unexpected,
8030: module => 'pon.plsql.pon_auction_pkg.get_time_zone',
8031: message => 'Multiple Users found for person_party_id:'|| contact_id);
8032: end if;
8033: end if;
8034:

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

8044: when NO_DATA_FOUND then
8045: if (nvl(fnd_profile.value('AFLOG_ENABLED'),'N') = 'Y') then
8046: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
8047: fnd_log.string(log_level => fnd_log.level_unexpected,
8048: module => 'pon.plsql.pon_auction_pkg.get_time_zone',
8049: message => 'No Active Users found for person_party_id:'|| contact_id);
8050: end if;
8051: end if;
8052:

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

8061: when OTHERS then
8062: if (nvl(fnd_profile.value('AFLOG_ENABLED'),'N') = 'Y') then
8063: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
8064: fnd_log.string(log_level => fnd_log.level_unexpected,
8065: module => 'pon.plsql.pon_auction_pkg.get_time_zone',
8066: message => 'Unknown exception for person_party_id:'|| contact_id);
8067: end if;
8068: end if;
8069: x_timezone := Get_Oex_Time_Zone;

Line 8141: PON_AUCTION_PKG.SessionLanguage := sLanguage;

8137: line_number = lineNumber;
8138: Begin
8139: begin
8140: sLanguage := USERENV('LANG');
8141: PON_AUCTION_PKG.SessionLanguage := sLanguage;
8142:
8143: open c1(auctionID,lineNumber);
8144: loop
8145: fetch c1 into clmNeedByDate,needByFromDate,needByToDate;

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

9484:
9485: wf_engine.SetItemAttrText (itemtype => x_itemtype,
9486: itemkey => x_itemkey,
9487: aname => 'PREVIEW_DATE_NOTSPECIFIED',
9488: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
9489:
9490:
9491: END IF;
9492:

Line 10038: PON_AUCTION_PKG.Check_Unique_Wrapper(p_order_number, null,

10034:
10035: -- Set the connection's policy context
10036: mo_global.set_policy_context('S', v_org_id);
10037:
10038: PON_AUCTION_PKG.Check_Unique_Wrapper(p_order_number, null,
10039: v_contract_type, p_bid_number, v_is_unique);
10040:
10041: -- Set the org context back
10042: mo_global.set_policy_context(v_old_policy, v_old_org_id);

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

10793: x_timezone_disp =>l_timezone_disp);
10794:
10795: l_progress := '040';
10796:
10797: l_task_assigned_subject := PON_AUCTION_PKG.getMessage( msg => 'PON_AUC_TASK_ASN_NOTIF_SUB',
10798: msg_suffix => '_'|| l_msg_suffix,
10799: token1 => 'DOC_NUMBER',
10800: token1_value => l_doc_number,
10801: token2 => 'AUCTION_TITLE',

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

11056: WHEN TOO_MANY_ROWS THEN
11057: if (nvl(fnd_profile.value('AFLOG_ENABLED'),'N') = 'Y') then
11058: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
11059: fnd_log.string(log_level => fnd_log.level_unexpected,
11060: module => 'pon.plsql.pon_auction_pkg.send_task_compl_notif',
11061: message => 'Multiple Users found for auction_header_id:'|| p_auction_header_id);
11062: end if;
11063: end if;
11064:

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

11192: x_timezone_disp =>l_timezone_disp);
11193:
11194: l_progress := '040';
11195:
11196: l_task_completed_subject := PON_AUCTION_PKG.getMessage( msg => 'PON_AUC_TASK_COMPL_NOTIF_SUB',
11197: msg_suffix => '_'|| l_msg_suffix,
11198: token1 => 'DOC_NUMBER',
11199: token1_value => l_doc_number,
11200: token2 => 'AUCTION_TITLE',

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

11454: WHEN TOO_MANY_ROWS THEN
11455: if (nvl(fnd_profile.value('AFLOG_ENABLED'),'N') = 'Y') then
11456: if (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) then
11457: fnd_log.string(log_level => fnd_log.level_unexpected,
11458: module => 'pon.plsql.pon_auction_pkg.send_resp_notif',
11459: message => 'Multiple Users found for bid number:'|| p_bid_number);
11460: end if;
11461: end if;
11462:

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

11566: l_progress := '040';
11567:
11568: -- Submitted: 4512 for 2759 (Equipment Renewal)
11569:
11570: l_resp_publish_sub := PON_AUCTION_PKG.getMessage( msg => 'PON_AUC_RESP_SUBM_NOTIF_SUB',
11571: msg_suffix => '_'||l_msg_suffix,
11572: token1 => 'RESPONSE_NUMBER',
11573: token1_value => p_bid_number,
11574: token2 => 'DOC_NUMBER',

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

11597:
11598: l_response_url := pon_wf_utl_pkg.get_dest_page_url (p_dest_func => 'PONRESENQ_VIEWBID'
11599: ,p_notif_performer => 'BUYER');
11600:
11601: l_response_type_name := PON_AUCTION_PKG.getMessage( msg => 'PON_AUCTS_BID',
11602: msg_suffix => '_'||l_msg_suffix);
11603:
11604: wf_engine.CreateProcess(itemtype => l_itemtype,
11605: itemkey => l_itemkey,

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

11645:
11646: wf_engine.SetItemAttrText (itemtype => l_itemtype,
11647: itemkey => l_itemkey,
11648: aname => 'PREVIEW_DATE_NOTSPECIFIED',
11649: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
11650: END IF;
11651:
11652: l_progress := '090';
11653:

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

12652: WHEN TOO_MANY_ROWS THEN
12653: IF (NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y') THEN
12654: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
12655: FND_LOG.string(log_level => FND_LOG.level_unexpected,
12656: module => 'pon.plsql.pon_auction_pkg.notify_member 1',
12657: message => 'Multiple Users found for person_party_id:'|| p_userPartyId);
12658: END IF;
12659: END IF;
12660:

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

12685: WHEN TOO_MANY_ROWS THEN
12686: IF (NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y') THEN
12687: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
12688: FND_LOG.string(log_level => FND_LOG.level_unexpected,
12689: module => 'pon.plsql.pon_auction_pkg.notify_member 2',
12690: message => 'Multiple Users found for person_party_id:'|| p_from_id);
12691: END IF;
12692: END IF;
12693:

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

12749: module => g_module || l_module_name,
12750: message => 'Negotiation Dates are converted to destination timezone: ' || l_timezone_disp);
12751: END IF;
12752:
12753: l_msg_sent_subject := PON_AUCTION_PKG.getMessage(msg => 'PON_DISC_MESSAGE_SENT_MSG',
12754: msg_suffix => '_'|| p_msg_suffix,
12755: token1 => 'DOC_NUMBER',
12756: token1_value => p_doc_number,
12757: token2 => 'NEG_TITLE',

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

12772: l_timezone_disp1 := l_timezone_disp;
12773: l_timezone_nodisp := NULL;
12774: ELSE
12775: l_timezone_disp1 := NULL;
12776: l_timezone_nodisp := PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC');
12777: END IF;
12778:
12779: l_progress := '040';
12780: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

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

13070:
13071: IF (NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y') THEN
13072: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
13073: FND_LOG.string(log_level => FND_LOG.level_statement,
13074: module => 'pon.plsql.pon_auction_pkg.set_preview_date',
13075: message => 'Entered the procedure with params --- ' ||
13076: 'p_itemtype : ' || p_itemtype||
13077: ',p_itemkey : ' ||p_itemkey||
13078: ',p_preview_date : '||p_preview_date||

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

13096:
13097: wf_engine.SetItemAttrText (itemtype => p_itemtype,
13098: itemkey => p_itemkey,
13099: aname => 'PREVIEW_DATE_NOTSPECIFIED',
13100: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_OPEN_IMM_AFTER_PUB',p_msg_suffix));
13101:
13102: ELSIF (p_preview_date is NULL) THEN --if Not specified
13103:
13104: wf_engine.SetItemAttrDate (itemtype => p_itemtype,

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

13113:
13114: wf_engine.SetItemAttrText (itemtype => p_itemtype,
13115: itemkey => p_itemkey,
13116: aname => 'PREVIEW_DATE_NOTSPECIFIED',
13117: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
13118:
13119: ELSE
13120: wf_engine.SetItemAttrDate (itemtype => p_itemtype,
13121: itemkey => p_itemkey,

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

13135:
13136: IF (NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y') THEN
13137: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
13138: FND_LOG.string(log_level => FND_LOG.level_statement,
13139: module => 'pon.plsql.pon_auction_pkg.set_preview_date',
13140: message => 'Exiting the procedure');
13141: END IF;
13142: END IF;
13143:

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

13155:
13156: IF (NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y') THEN
13157: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
13158: FND_LOG.string(log_level => FND_LOG.level_statement,
13159: module => 'pon.plsql.pon_auction_pkg.set_open_date',
13160: message => 'Entered the procedure with params --- ' ||
13161: 'p_itemtype : ' || p_itemtype||
13162: ',p_itemkey : ' ||p_itemkey||
13163: ',p_auction_start_date : '||p_auction_start_date||

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

13181:
13182: wf_engine.SetItemAttrText (itemtype => p_itemtype,
13183: itemkey => p_itemkey,
13184: aname => 'OPEN_DATE_NOT_SPECIFIED',
13185: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_OPEN_IMM_AFTER_PUB',p_msg_suffix));
13186:
13187: ELSIF(p_auction_start_date is NULL) THEN --if not specified
13188: wf_engine.SetItemAttrDate (itemtype => p_itemtype,
13189: itemkey => p_itemkey,

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

13197:
13198: wf_engine.SetItemAttrText (itemtype => p_itemtype,
13199: itemkey => p_itemkey,
13200: aname => 'OPEN_DATE_NOT_SPECIFIED',
13201: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
13202:
13203: ELSE
13204: wf_engine.SetItemAttrDate (itemtype => p_itemtype,
13205: itemkey => p_itemkey,

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

13220:
13221: IF (NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y') THEN
13222: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
13223: FND_LOG.string(log_level => FND_LOG.level_statement,
13224: module => 'pon.plsql.pon_auction_pkg.set_open_date',
13225: message => 'Exiting the procedure');
13226: END IF;
13227: END IF;
13228:

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

13239:
13240: IF (NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y') THEN
13241: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
13242: FND_LOG.string(log_level => FND_LOG.level_statement,
13243: module => 'pon.plsql.pon_auction_pkg.set_close_date',
13244: message => 'Entered the procedure with params --- ' ||
13245: 'p_itemtype : ' || p_itemtype||
13246: ',p_itemkey : ' ||p_itemkey||
13247: ',p_auction_end_date : '||p_auction_end_date||

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

13263:
13264: wf_engine.SetItemAttrText (itemtype => p_itemtype,
13265: itemkey => p_itemkey,
13266: aname => 'CLOSE_DATE_NOT_SPECIFIED',
13267: avalue => PON_AUCTION_PKG.getMessage('PON_AUC_PREVIEW_DATE_NOTSPEC'));
13268:
13269:
13270: ELSE
13271: wf_engine.SetItemAttrDate (itemtype => p_itemtype,

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

13288:
13289: IF (NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y') THEN
13290: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
13291: FND_LOG.string(log_level => FND_LOG.level_statement,
13292: module => 'pon.plsql.pon_auction_pkg.set_close_date',
13293: message => 'Exiting the procedure');
13294: END IF;
13295: END IF;
13296:

Line 17874: END PON_AUCTION_PKG;

17870: raise; --raise exception
17871:
17872: END POPULATE_PON_PR_REFS;
17873:
17874: END PON_AUCTION_PKG;