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 512: IF (NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y') THEN

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

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

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

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

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

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

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

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

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

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

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

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

7331: begin
7332: --
7333: -- Get the exchange time zone
7334: --
7335: x_oex_timezone := fnd_profile.value_specific('SERVER_TIMEZONE_ID');
7336: return x_oex_timezone;
7337: end;
7338:
7339:

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

7351: into x_user_id
7352: from fnd_user
7353: where person_party_id = contact_id
7354: and nvl(end_date, sysdate+1) > sysdate;
7355: x_timezone := fnd_profile.value_specific('CLIENT_TIMEZONE_ID',x_user_id);
7356: exception
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

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

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

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

7369: where person_party_id = contact_id
7370: and nvl(end_date, sysdate+1) > sysdate
7371: and rownum=1;
7372:
7373: x_timezone := fnd_profile.value_specific('CLIENT_TIMEZONE_ID',x_user_id);
7374:
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

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

7372:
7373: x_timezone := fnd_profile.value_specific('CLIENT_TIMEZONE_ID',x_user_id);
7374:
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);

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

7386: from fnd_user
7387: where person_party_id = contact_id
7388: and rownum=1;
7389:
7390: x_timezone := fnd_profile.value_specific('CLIENT_TIMEZONE_ID',x_user_id);
7391:
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

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

7389:
7390: x_timezone := fnd_profile.value_specific('CLIENT_TIMEZONE_ID',x_user_id);
7391:
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);

Line 7478: 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')));

7474: fetch c1 into needByFromDate,needByToDate;
7475: EXIT WHEN c1%NOTFOUND;
7476: end loop;
7477: if needByFromDate IS NOT NULL and needByToDate IS NULL then
7478: 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')));
7479: else
7480: if needByFromDate IS NULL and needByToDate IS NOT NULL then
7481: 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')));
7482: else

Line 7481: 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')));

7477: if needByFromDate IS NOT NULL and needByToDate IS NULL then
7478: 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')));
7479: else
7480: if needByFromDate IS NULL and needByToDate IS NOT NULL then
7481: 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')));
7482: else
7483: if needByFromDate IS NOT NULL and needByToDate IS NOT NULL then
7484: 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'),
7485: 'TODATE',PON_OA_UTIL_PKG.DISPLAY_DATE_TIME(needByToDate,fnd_profile.value('CLIENT_TIMEZONE_ID'),fnd_profile.value('SERVER_TIMEZONE_ID'),userDateFormat,'N')));

Line 7484: 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'),

7480: if needByFromDate IS NULL and needByToDate IS NOT NULL then
7481: 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')));
7482: else
7483: if needByFromDate IS NOT NULL and needByToDate IS NOT NULL then
7484: 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'),
7485: 'TODATE',PON_OA_UTIL_PKG.DISPLAY_DATE_TIME(needByToDate,fnd_profile.value('CLIENT_TIMEZONE_ID'),fnd_profile.value('SERVER_TIMEZONE_ID'),userDateFormat,'N')));
7486: else return (outputString);
7487: end if;
7488: end if;

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

7481: 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')));
7482: else
7483: if needByFromDate IS NOT NULL and needByToDate IS NOT NULL then
7484: 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'),
7485: 'TODATE',PON_OA_UTIL_PKG.DISPLAY_DATE_TIME(needByToDate,fnd_profile.value('CLIENT_TIMEZONE_ID'),fnd_profile.value('SERVER_TIMEZONE_ID'),userDateFormat,'N')));
7486: else return (outputString);
7487: end if;
7488: end if;
7489: end if;

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

9847: || ', p_user_id = ' || p_user_id);
9848: END IF;
9849:
9850:
9851: l_language_code := fnd_profile.value_specific('ICX_LANGUAGE', p_user_id, NULL, NULL);
9852:
9853: l_progress := '010';
9854:
9855: SELECT LANGUAGE_CODE

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

10217: AND nvl(fu.end_date,sysdate+1) > sysdate;
10218:
10219: EXCEPTION
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);

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

10282: || ', l_publish_auction_now_flag = ' || l_publish_auction_now_flag
10283: );
10284: END IF;
10285:
10286: l_language_code := fnd_profile.value_specific('ICX_LANGUAGE', l_tp_contact_usr_id, NULL, NULL);
10287:
10288: l_progress := '010';
10289:
10290: SELECT LANGUAGE_CODE

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

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

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

11794: AND NVL(END_DATE, SYSDATE+1) > SYSDATE;
11795:
11796: EXCEPTION
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);

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

11827: AND NVL(END_DATE, SYSDATE+1) > SYSDATE;
11828:
11829: EXCEPTION
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);

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

11847:
11848: END;
11849:
11850: -- Get the language of the Recipient of the message
11851: l_language := fnd_profile.value_specific('ICX_LANGUAGE', l_user_id, NULL, NULL);
11852: EXCEPTION
11853: WHEN NO_DATA_FOUND THEN
11854: l_language := 'AMERICAN';
11855: END;

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

12211: p_msg_suffix IN VARCHAR2) IS
12212:
12213: BEGIN
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 --- ' ||

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

12276: aname => 'PREVIEW_DATE_NOTSPECIFIED',
12277: avalue => null);
12278: END IF;
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');

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

12296: p_msg_suffix IN VARCHAR2) IS
12297:
12298: BEGIN
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 --- ' ||

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

12361: avalue => null);
12362:
12363: END IF;
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');

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

12380: p_timezone_disp IN VARCHAR2) IS
12381:
12382: BEGIN
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 --- ' ||

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

12429:
12430: END IF;
12431:
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');