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 FND_PROFILE

Line 535: IF (NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y') THEN

531: where person_party_id = x_auction_contact_id
532: and nvl(end_date, sysdate+1) > sysdate;
533: EXCEPTION
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);

Line 841: IF (fnd_profile.value('POS_SM_ENABLE_SPM_EXTENSION') = 'Y' AND bidder.requested_supplier_id IS NOT NULL) THEN

837: 'AUCTION_TITLE', replaceHtmlChars(x_auction_title)));
838:
839: -- Begin Bug 9309785
840: -- Use a different subject for Supplier Hub
841: IF (fnd_profile.value('POS_SM_ENABLE_SPM_EXTENSION') = 'Y' AND bidder.requested_supplier_id IS NOT NULL) THEN
842: wf_engine.SetItemAttrText (itemtype => x_itemtype,
843: itemkey => x_itemkey,
844: aname => 'INVITE_RESPONSE_SUB',
845: avalue => getMessage('PON_SM_AUC_WF_PUB_OPEN_RG_S'));

Line 4414: if (nvl(fnd_profile.value('AFLOG_ENABLED'),'N') = 'Y') then

4410: from fnd_user where person_party_id = x_person_party_id
4411: and nvl(end_date, sysdate+1) > sysdate;
4412: EXCEPTION
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);

Line 4837: if (nvl(fnd_profile.value('AFLOG_ENABLED'),'N') = 'Y') then

4833: where person_party_id= p_trading_partner_contact_id
4834: and nvl(end_date, sysdate+1) > sysdate;
4835: EXCEPTION
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);

Line 5932: if (nvl(fnd_profile.value('AFLOG_ENABLED'),'N') = 'Y') then

5928: where person_party_id = x_contact_id
5929: and nvl(end_date, sysdate+1) > sysdate;
5930: EXCEPTION
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);

Line 6045: if (nvl(fnd_profile.value('AFLOG_ENABLED'),'N') = 'Y') then

6041: where person_party_id = x_contact_id
6042: and nvl(end_date, sysdate+1) > sysdate;
6043: EXCEPTION
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);

Line 7490: IF (fnd_profile.value('POS_SM_ENABLE_SPM_EXTENSION') = 'Y' AND l_requested_supplier) THEN

7486: --- 000001
7487:
7488: -- Begin Bug 9309785
7489: -- Use a different subject for Supplier Hub
7490: IF (fnd_profile.value('POS_SM_ENABLE_SPM_EXTENSION') = 'Y' AND l_requested_supplier) THEN
7491: wf_engine.SetItemAttrText (itemtype => t_itemtype,
7492: itemkey => t_itemkey,
7493: aname => 'INVITE_RESPONSE_SUB',
7494: avalue => getMessage('PON_SM_AUC_WF_PUB_OPEN_RG_S'));

Line 7908: if (nvl(fnd_profile.value('AFLOG_ENABLED'),'N') = 'Y') then

7904: where person_party_id = p_user_id
7905: and nvl(end_date,sysdate+1) > sysdate;
7906: exception
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);

Line 8004: x_oex_timezone := fnd_profile.value_specific('SERVER_TIMEZONE_ID');

8000: begin
8001: --
8002: -- Get the exchange time zone
8003: --
8004: x_oex_timezone := fnd_profile.value_specific('SERVER_TIMEZONE_ID');
8005: return x_oex_timezone;
8006: end;
8007:
8008:

Line 8024: x_timezone := fnd_profile.value_specific('CLIENT_TIMEZONE_ID',x_user_id);

8020: into x_user_id
8021: from fnd_user
8022: where person_party_id = contact_id
8023: and nvl(end_date, sysdate+1) > sysdate;
8024: x_timezone := fnd_profile.value_specific('CLIENT_TIMEZONE_ID',x_user_id);
8025: exception
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

Line 8027: if (nvl(fnd_profile.value('AFLOG_ENABLED'),'N') = 'Y') then

8023: and nvl(end_date, sysdate+1) > sysdate;
8024: x_timezone := fnd_profile.value_specific('CLIENT_TIMEZONE_ID',x_user_id);
8025: exception
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);

Line 8042: x_timezone := fnd_profile.value_specific('CLIENT_TIMEZONE_ID',x_user_id);

8038: where person_party_id = contact_id
8039: and nvl(end_date, sysdate+1) > sysdate
8040: and rownum=1;
8041:
8042: x_timezone := fnd_profile.value_specific('CLIENT_TIMEZONE_ID',x_user_id);
8043:
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

Line 8045: if (nvl(fnd_profile.value('AFLOG_ENABLED'),'N') = 'Y') then

8041:
8042: x_timezone := fnd_profile.value_specific('CLIENT_TIMEZONE_ID',x_user_id);
8043:
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);

Line 8059: x_timezone := fnd_profile.value_specific('CLIENT_TIMEZONE_ID',x_user_id);

8055: from fnd_user
8056: where person_party_id = contact_id
8057: and rownum=1;
8058:
8059: x_timezone := fnd_profile.value_specific('CLIENT_TIMEZONE_ID',x_user_id);
8060:
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

Line 8062: if (nvl(fnd_profile.value('AFLOG_ENABLED'),'N') = 'Y') then

8058:
8059: x_timezone := fnd_profile.value_specific('CLIENT_TIMEZONE_ID',x_user_id);
8060:
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);

Line 8152: return (getMessage('PON_AUC_NEEDBY_ONLY_START_DATE',x_msg_suffix,'FROMDATE',PON_OA_UTIL_PKG.DISPLAY_DATE_TIME(clmNeedByDate,fnd_profile.value('CLIENT_TIMEZONE_ID'),fnd_profile.value('SERVER_TIMEZONE_ID'),userDateFormat,'N')));

8148:
8149: /* CLM Offer Enhancement Start */
8150: if clmNeedByDate is not null and (PON_CLM_UTIL_PKG.IS_NEG_DOCUMENT_FEDERAL(auctionID) = 1)
8151: then
8152: return (getMessage('PON_AUC_NEEDBY_ONLY_START_DATE',x_msg_suffix,'FROMDATE',PON_OA_UTIL_PKG.DISPLAY_DATE_TIME(clmNeedByDate,fnd_profile.value('CLIENT_TIMEZONE_ID'),fnd_profile.value('SERVER_TIMEZONE_ID'),userDateFormat,'N')));
8153: end if;
8154: /* CLM Offer Enhancement End */
8155: if needByFromDate IS NOT NULL and needByToDate IS NULL then
8156: return (getMessage('PON_AUC_NEEDBY_ONLY_START_DATE',x_msg_suffix,'FROMDATE',PON_OA_UTIL_PKG.DISPLAY_DATE_TIME(needByFromDate,fnd_profile.value('CLIENT_TIMEZONE_ID'),fnd_profile.value('SERVER_TIMEZONE_ID'),userDateFormat,'N')));

Line 8156: return (getMessage('PON_AUC_NEEDBY_ONLY_START_DATE',x_msg_suffix,'FROMDATE',PON_OA_UTIL_PKG.DISPLAY_DATE_TIME(needByFromDate,fnd_profile.value('CLIENT_TIMEZONE_ID'),fnd_profile.value('SERVER_TIMEZONE_ID'),userDateFormat,'N')));

8152: return (getMessage('PON_AUC_NEEDBY_ONLY_START_DATE',x_msg_suffix,'FROMDATE',PON_OA_UTIL_PKG.DISPLAY_DATE_TIME(clmNeedByDate,fnd_profile.value('CLIENT_TIMEZONE_ID'),fnd_profile.value('SERVER_TIMEZONE_ID'),userDateFormat,'N')));
8153: end if;
8154: /* CLM Offer Enhancement End */
8155: if needByFromDate IS NOT NULL and needByToDate IS NULL then
8156: return (getMessage('PON_AUC_NEEDBY_ONLY_START_DATE',x_msg_suffix,'FROMDATE',PON_OA_UTIL_PKG.DISPLAY_DATE_TIME(needByFromDate,fnd_profile.value('CLIENT_TIMEZONE_ID'),fnd_profile.value('SERVER_TIMEZONE_ID'),userDateFormat,'N')));
8157: else
8158: if needByFromDate IS NULL and needByToDate IS NOT NULL then
8159: return (getMessage('PON_AUC_NEEDBY_ONLY_END_DATE',x_msg_suffix,'TODATE',PON_OA_UTIL_PKG.DISPLAY_DATE_TIME(needByToDate,fnd_profile.value('CLIENT_TIMEZONE_ID'),fnd_profile.value('SERVER_TIMEZONE_ID'),userDateFormat,'N')));
8160: else

Line 8159: return (getMessage('PON_AUC_NEEDBY_ONLY_END_DATE',x_msg_suffix,'TODATE',PON_OA_UTIL_PKG.DISPLAY_DATE_TIME(needByToDate,fnd_profile.value('CLIENT_TIMEZONE_ID'),fnd_profile.value('SERVER_TIMEZONE_ID'),userDateFormat,'N')));

8155: if needByFromDate IS NOT NULL and needByToDate IS NULL then
8156: return (getMessage('PON_AUC_NEEDBY_ONLY_START_DATE',x_msg_suffix,'FROMDATE',PON_OA_UTIL_PKG.DISPLAY_DATE_TIME(needByFromDate,fnd_profile.value('CLIENT_TIMEZONE_ID'),fnd_profile.value('SERVER_TIMEZONE_ID'),userDateFormat,'N')));
8157: else
8158: if needByFromDate IS NULL and needByToDate IS NOT NULL then
8159: return (getMessage('PON_AUC_NEEDBY_ONLY_END_DATE',x_msg_suffix,'TODATE',PON_OA_UTIL_PKG.DISPLAY_DATE_TIME(needByToDate,fnd_profile.value('CLIENT_TIMEZONE_ID'),fnd_profile.value('SERVER_TIMEZONE_ID'),userDateFormat,'N')));
8160: else
8161: if needByFromDate IS NOT NULL and needByToDate IS NOT NULL then
8162: return (getMessage('PON_AUC_NEEDBY_RANGE',x_msg_suffix,'FROMDATE',PON_OA_UTIL_PKG.DISPLAY_DATE_TIME(needByFromDate,fnd_profile.value('CLIENT_TIMEZONE_ID'),fnd_profile.value('SERVER_TIMEZONE_ID'),userDateFormat,'N'),
8163: 'TODATE',PON_OA_UTIL_PKG.DISPLAY_DATE_TIME(needByToDate,fnd_profile.value('CLIENT_TIMEZONE_ID'),fnd_profile.value('SERVER_TIMEZONE_ID'),userDateFormat,'N')));

Line 8162: return (getMessage('PON_AUC_NEEDBY_RANGE',x_msg_suffix,'FROMDATE',PON_OA_UTIL_PKG.DISPLAY_DATE_TIME(needByFromDate,fnd_profile.value('CLIENT_TIMEZONE_ID'),fnd_profile.value('SERVER_TIMEZONE_ID'),userDateFormat,'N'),

8158: if needByFromDate IS NULL and needByToDate IS NOT NULL then
8159: return (getMessage('PON_AUC_NEEDBY_ONLY_END_DATE',x_msg_suffix,'TODATE',PON_OA_UTIL_PKG.DISPLAY_DATE_TIME(needByToDate,fnd_profile.value('CLIENT_TIMEZONE_ID'),fnd_profile.value('SERVER_TIMEZONE_ID'),userDateFormat,'N')));
8160: else
8161: if needByFromDate IS NOT NULL and needByToDate IS NOT NULL then
8162: return (getMessage('PON_AUC_NEEDBY_RANGE',x_msg_suffix,'FROMDATE',PON_OA_UTIL_PKG.DISPLAY_DATE_TIME(needByFromDate,fnd_profile.value('CLIENT_TIMEZONE_ID'),fnd_profile.value('SERVER_TIMEZONE_ID'),userDateFormat,'N'),
8163: 'TODATE',PON_OA_UTIL_PKG.DISPLAY_DATE_TIME(needByToDate,fnd_profile.value('CLIENT_TIMEZONE_ID'),fnd_profile.value('SERVER_TIMEZONE_ID'),userDateFormat,'N')));
8164: else return (outputString);
8165: end if;
8166: end if;

Line 8163: 'TODATE',PON_OA_UTIL_PKG.DISPLAY_DATE_TIME(needByToDate,fnd_profile.value('CLIENT_TIMEZONE_ID'),fnd_profile.value('SERVER_TIMEZONE_ID'),userDateFormat,'N')));

8159: return (getMessage('PON_AUC_NEEDBY_ONLY_END_DATE',x_msg_suffix,'TODATE',PON_OA_UTIL_PKG.DISPLAY_DATE_TIME(needByToDate,fnd_profile.value('CLIENT_TIMEZONE_ID'),fnd_profile.value('SERVER_TIMEZONE_ID'),userDateFormat,'N')));
8160: else
8161: if needByFromDate IS NOT NULL and needByToDate IS NOT NULL then
8162: return (getMessage('PON_AUC_NEEDBY_RANGE',x_msg_suffix,'FROMDATE',PON_OA_UTIL_PKG.DISPLAY_DATE_TIME(needByFromDate,fnd_profile.value('CLIENT_TIMEZONE_ID'),fnd_profile.value('SERVER_TIMEZONE_ID'),userDateFormat,'N'),
8163: 'TODATE',PON_OA_UTIL_PKG.DISPLAY_DATE_TIME(needByToDate,fnd_profile.value('CLIENT_TIMEZONE_ID'),fnd_profile.value('SERVER_TIMEZONE_ID'),userDateFormat,'N')));
8164: else return (outputString);
8165: end if;
8166: end if;
8167: end if;

Line 10687: l_language_code := fnd_profile.value_specific('ICX_LANGUAGE', p_user_id, NULL, NULL);

10683: || ', p_user_id = ' || p_user_id);
10684: END IF;
10685:
10686:
10687: l_language_code := fnd_profile.value_specific('ICX_LANGUAGE', p_user_id, NULL, NULL);
10688:
10689: l_progress := '010';
10690:
10691: SELECT LANGUAGE_CODE

Line 11057: if (nvl(fnd_profile.value('AFLOG_ENABLED'),'N') = 'Y') then

11053: AND nvl(fu.end_date,sysdate+1) > sysdate;
11054:
11055: EXCEPTION
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);

Line 11122: l_language_code := fnd_profile.value_specific('ICX_LANGUAGE', l_tp_contact_usr_id, NULL, NULL);

11118: || ', l_publish_auction_now_flag = ' || l_publish_auction_now_flag
11119: );
11120: END IF;
11121:
11122: l_language_code := fnd_profile.value_specific('ICX_LANGUAGE', l_tp_contact_usr_id, NULL, NULL);
11123:
11124: l_progress := '010';
11125:
11126: SELECT LANGUAGE_CODE

Line 11455: if (nvl(fnd_profile.value('AFLOG_ENABLED'),'N') = 'Y') then

11451: AND fu.person_party_id = pbh.trading_partner_contact_id
11452: AND nvl(fu.end_date, sysdate+1) > sysdate;
11453: EXCEPTION
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);

Line 12653: IF (NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y') THEN

12649: AND NVL(END_DATE, SYSDATE+1) > SYSDATE;
12650:
12651: EXCEPTION
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);

Line 12686: IF (NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y') THEN

12682: AND NVL(END_DATE, SYSDATE+1) > SYSDATE;
12683:
12684: EXCEPTION
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);

Line 12706: l_language := fnd_profile.value_specific('ICX_LANGUAGE', l_user_id, NULL, NULL);

12702:
12703: END;
12704:
12705: -- Get the language of the Recipient of the message
12706: l_language := fnd_profile.value_specific('ICX_LANGUAGE', l_user_id, NULL, NULL);
12707: EXCEPTION
12708: WHEN NO_DATA_FOUND THEN
12709: l_language := 'AMERICAN';
12710: END;

Line 13071: IF (NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y') THEN

13067: p_msg_suffix IN VARCHAR2) IS
13068:
13069: BEGIN
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 --- ' ||

Line 13136: IF (NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y') THEN

13132: aname => 'PREVIEW_DATE_NOTSPECIFIED',
13133: avalue => null);
13134: END IF;
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');

Line 13156: IF (NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y') THEN

13152: p_msg_suffix IN VARCHAR2) IS
13153:
13154: BEGIN
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 --- ' ||

Line 13221: IF (NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y') THEN

13217: avalue => null);
13218:
13219: END IF;
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');

Line 13240: IF (NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y') THEN

13236: p_timezone_disp IN VARCHAR2) IS
13237:
13238: BEGIN
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 --- ' ||

Line 13289: IF (NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y') THEN

13285:
13286: END IF;
13287:
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');

Line 16497: IF (fnd_profile.value('POS_SM_ENABLE_SPM_EXTENSION') = 'Y') THEN

16493: l_disp_type:= display_type;
16494:
16495: -- Begin Bug 9309785
16496: -- Use a different body for Supplier Hub
16497: IF (fnd_profile.value('POS_SM_ENABLE_SPM_EXTENSION') = 'Y') THEN
16498: fnd_message.set_name('PON','PON_SM_INVITE_REQ_SUPP_RESP_HB');
16499: fnd_message.set_token('AUCTION_TITLE', x_auction_title);
16500: fnd_message.set_token('DOC_NUMBER', x_doc_number);
16501: fnd_message.set_token('PREPARER_TP_NAME',x_auction_owner_tp_name);

Line 16528: IF (fnd_profile.value('POS_SM_ENABLE_SPM_EXTENSION') = 'Y') THEN

16524: l_disp_type:= display_type;
16525:
16526: -- Begin Bug 9309785
16527: -- Use a different body for Supplier Hub
16528: IF (fnd_profile.value('POS_SM_ENABLE_SPM_EXTENSION') = 'Y') THEN
16529: fnd_message.set_name('PON','PON_SM_INVITE_REQ_SUPP_RESP_TB');
16530: fnd_message.set_token('AUCTION_TITLE', x_auction_title);
16531: fnd_message.set_token('DOC_NUMBER', x_doc_number);
16532: fnd_message.set_token('PREPARER_TP_NAME',x_auction_owner_tp_name);

Line 17741: IF FND_PROFILE.value('POS_SM_ENABLE_SPM_EXTENSION') = 'Y' THEN

17737: resultout OUT NOCOPY VARCHAR2)
17738: IS
17739: BEGIN
17740:
17741: IF FND_PROFILE.value('POS_SM_ENABLE_SPM_EXTENSION') = 'Y' THEN
17742: resultout := 'Y';
17743: ELSE
17744: resultout := 'N';
17745: END IF;