DBA Data[Home] [Help]

APPS.IEX_PROMISES_PUB dependencies on FND_PROFILE

Line 165: l_days := to_number(nvl(fnd_profile.value('IEX_UWQ_DEFAULT_PENDING_DAYS'), '0'));

161: l_uwq_complete_date := NULL;
162: elsif P_STATUS = 'PENDING' then
163: -- set number of days
164: if P_DAYS is null then
165: l_days := to_number(nvl(fnd_profile.value('IEX_UWQ_DEFAULT_PENDING_DAYS'), '0'));
166: else
167: l_days := P_DAYS;
168: end if;
169: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 433: l_autofulfill := fnd_profile.value('IEX_AUTO_FULFILL');

429: begin
430: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
431: iex_debug_pub.LogMessage(G_PKG_NAME || '.SEND_FFM: start');
432: END IF;
433: l_autofulfill := fnd_profile.value('IEX_AUTO_FULFILL');
434: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
435: iex_debug_pub.LogMessage(G_PKG_NAME || '.SEND_FFM: l_autofulfill: ' || l_autofulfill);
436: END IF;
437:

Line 439: l_template_id := to_number(fnd_profile.value('IEX_PROMISE_CONFIRM'));

435: iex_debug_pub.LogMessage(G_PKG_NAME || '.SEND_FFM: l_autofulfill: ' || l_autofulfill);
436: END IF;
437:
438: if l_autofulfill is not null and l_autofulfill = 'Y' then
439: l_template_id := to_number(fnd_profile.value('IEX_PROMISE_CONFIRM'));
440: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
441: iex_debug_pub.LogMessage(G_PKG_NAME || '.SEND_FFM: ptp ffm template_id = ' || l_template_id);
442: END IF;
443: if l_template_id is not null then

Line 497: l_approval_required := fnd_profile.value('IEX_PTP_APPROVAL');

493: l_wf_process := 'PROMISE_WORKFLOW';
494: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
495: iex_debug_pub.LogMessage(G_PKG_NAME || '.start_ptp_wf: start');
496: END IF;
497: l_approval_required := fnd_profile.value('IEX_PTP_APPROVAL');
498: l_wf_item_type := fnd_profile.value('IEX_PTP_WF_ITEM_TYPE');
499: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
500: iex_debug_pub.LogMessage(G_PKG_NAME || '.start_ptp_wf: approval required = ' || l_approval_required);
501: iex_debug_pub.LogMessage(G_PKG_NAME || '.start_ptp_wf: item type = ' || l_wf_item_type);

Line 498: l_wf_item_type := fnd_profile.value('IEX_PTP_WF_ITEM_TYPE');

494: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
495: iex_debug_pub.LogMessage(G_PKG_NAME || '.start_ptp_wf: start');
496: END IF;
497: l_approval_required := fnd_profile.value('IEX_PTP_APPROVAL');
498: l_wf_item_type := fnd_profile.value('IEX_PTP_WF_ITEM_TYPE');
499: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
500: iex_debug_pub.LogMessage(G_PKG_NAME || '.start_ptp_wf: approval required = ' || l_approval_required);
501: iex_debug_pub.LogMessage(G_PKG_NAME || '.start_ptp_wf: item type = ' || l_wf_item_type);
502: END IF;

Line 581: l_grace_period := to_number(nvl(fnd_profile.value('IEX_PTP_GRACE_PERIOD'), '0'));

577: begin
578: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
579: iex_debug_pub.LogMessage(G_PKG_NAME || '.get_broken_on_date: start');
580: END IF;
581: l_grace_period := to_number(nvl(fnd_profile.value('IEX_PTP_GRACE_PERIOD'), '0'));
582: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
583: iex_debug_pub.LogMessage(G_PKG_NAME || '.get_broken_on_date: grace period = ' || l_grace_period);
584: END IF;
585: l_broken_on_date := p_promise_date + l_grace_period;

Line 1277: If nvl(fnd_profile.value('IEX_ALLOW_DUN_FULL_PROMISE'),'N')= 'Y' then -- added for bug 14318148

1273: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1274: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Insert OK');
1275: END IF;
1276:
1277: If nvl(fnd_profile.value('IEX_ALLOW_DUN_FULL_PROMISE'),'N')= 'Y' then -- added for bug 14318148
1278: --start
1279: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1280: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Calling update_del_stage_level');
1281: END IF;

Line 1841: If nvl(fnd_profile.value('IEX_ALLOW_DUN_FULL_PROMISE'),'N')= 'Y' then -- added for bug 14318148

1837:
1838: open l_cursor for l_SQL
1839: using P_PROMISE_REC.PROMISE_ID;
1840: fetch l_cursor into X_PRORESP_REC.STATE;
1841: If nvl(fnd_profile.value('IEX_ALLOW_DUN_FULL_PROMISE'),'N')= 'Y' then -- added for bug 14318148
1842: --start
1843: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1844: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Calling update_del_stage_level');
1845: END IF;

Line 2160: If nvl(fnd_profile.value('IEX_ALLOW_DUN_FULL_PROMISE'),'N')= 'Y' then -- added for bug 14318148

2156:
2157: open l_cursor for l_SQL
2158: using P_PROMISE_REC.PROMISE_ID;
2159: fetch l_cursor into X_PRORESP_REC.STATE;
2160: If nvl(fnd_profile.value('IEX_ALLOW_DUN_FULL_PROMISE'),'N')= 'Y' then -- added for bug 14318148
2161: --start
2162: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2163: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Calling update_del_stage_level');
2164: END IF;

Line 2636: If nvl(fnd_profile.value('IEX_ALLOW_DUN_FULL_PROMISE'),'N')= 'Y' then -- added for bug 14318148

2632: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2633: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Done');
2634: END IF;
2635:
2636: If nvl(fnd_profile.value('IEX_ALLOW_DUN_FULL_PROMISE'),'N')= 'Y' then -- added for bug 14318148
2637: --start
2638: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2639: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Calling update_del_stage_level');
2640: END IF;

Line 2791: If nvl(fnd_profile.value('IEX_ALLOW_DUN_FULL_PROMISE'),'N')= 'Y' then -- added for bug 14318148

2787:
2788: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2789: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Insert OK');
2790: END IF;
2791: If nvl(fnd_profile.value('IEX_ALLOW_DUN_FULL_PROMISE'),'N')= 'Y' then -- added for bug 14318148
2792: --start
2793: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2794: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ': Calling update_del_stage_level');
2795: END IF;

Line 2828: l_note_type := fnd_profile.value('AST_NOTES_DEFAULT_TYPE');

2824: X_MASS_PRORESP_TBL(k).COLLECTABLE_AMOUNT := l_remaining_amount;
2825: l_MASS_IDS_TBL(k) := l_payment_schedule_id;
2826: END LOOP;
2827:
2828: l_note_type := fnd_profile.value('AST_NOTES_DEFAULT_TYPE');
2829: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2830: iex_debug_pub.LogMessage(l_api_name || ': l_note_type = ' || l_note_type);
2831: END IF;
2832:

Line 3041: if l_amt_due_remaining <= l_total_already_pro_amt and nvl(fnd_profile.value('IEX_ALLOW_DUN_FULL_PROMISE'),'N')= 'Y' then --modified for bug 14318148

3037: End ;
3038: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
3039: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || 'l_amt_due_remaining: ' || l_amt_due_remaining);
3040: end if;
3041: if l_amt_due_remaining <= l_total_already_pro_amt and nvl(fnd_profile.value('IEX_ALLOW_DUN_FULL_PROMISE'),'N')= 'Y' then --modified for bug 14318148
3042: update iex_delinquencies_all
3043: set staged_dunning_level = 0
3044: where delinquency_id = l_promised_delinquency_id;
3045: