APPS.CN_SCA_CREDITS_BATCH_PUB dependencies on FND_PROFILE

Line 27: g_cn_debug VARCHAR2(1) := fnd_profile.VALUE('CN_DEBUG');

23: g_file_name CONSTANT VARCHAR2(12) := 'cnpscabb.pls';
24: no_trx EXCEPTION;
25: conc_fail EXCEPTION;
26: api_call_failed EXCEPTION;
27: g_cn_debug VARCHAR2(1) := fnd_profile.VALUE('CN_DEBUG');
28: g_login_id NUMBER := fnd_global.conc_login_id;
29: g_sysdate DATE := SYSDATE;
30: g_program_id NUMBER := fnd_global.conc_program_id;
31: g_user_id NUMBER := fnd_global.user_id;

Line 210: l_sleep_time_char := fnd_profile.VALUE('CN_SLEEP_TIME');

206: debugmsg('SCA : Conc_Dispatch : Total conc requests submitted : ' || x_batch_total);
207: debugmsg('Total conc requests submitted : ' || x_batch_total);
208: --cn_message_pkg.flush;
209: debug_v := l_primary_request_stack(primary_ptr);
210: l_sleep_time_char := fnd_profile.VALUE('CN_SLEEP_TIME');
211:
212: IF l_sleep_time_char IS NOT NULL THEN
213: l_sleep_time := TO_NUMBER(l_sleep_time_char);
214: END IF;

Line 355: l_worker_num := NVL(fnd_profile.VALUE('CN_NUMBER_OF_WORKERS'), 1);

351: FETCH query_cur
352: INTO l_logical_batch_size;
353:
354: x_size := l_logical_batch_size;
355: l_worker_num := NVL(fnd_profile.VALUE('CN_NUMBER_OF_WORKERS'), 1);
356:
357: IF (l_worker_num < 1) THEN
358: l_worker_num := 1;
359: END IF;

Line 938: IF (fnd_profile.defined('CN_FFNAME_SPLIT_PCTG')) THEN

934: errbuf := NULL;
935: retcode := 0;
936:
937: /* Get the flex field name corresponding to split percentage */
938: IF (fnd_profile.defined('CN_FFNAME_SPLIT_PCTG')) THEN
939: p_ffname_split_pctg := fnd_profile.VALUE('CN_FFNAME_SPLIT_PCTG');
940: END IF;
941:
942: /* Get the flex field name corresponding to revenue type */

Line 939: p_ffname_split_pctg := fnd_profile.VALUE('CN_FFNAME_SPLIT_PCTG');

935: retcode := 0;
936:
937: /* Get the flex field name corresponding to split percentage */
938: IF (fnd_profile.defined('CN_FFNAME_SPLIT_PCTG')) THEN
939: p_ffname_split_pctg := fnd_profile.VALUE('CN_FFNAME_SPLIT_PCTG');
940: END IF;
941:
942: /* Get the flex field name corresponding to revenue type */
943: IF (fnd_profile.defined('CN_FFNAME_REV_TYPE')) THEN

Line 943: IF (fnd_profile.defined('CN_FFNAME_REV_TYPE')) THEN

939: p_ffname_split_pctg := fnd_profile.VALUE('CN_FFNAME_SPLIT_PCTG');
940: END IF;
941:
942: /* Get the flex field name corresponding to revenue type */
943: IF (fnd_profile.defined('CN_FFNAME_REV_TYPE')) THEN
944: p_ffname_rev_type := fnd_profile.VALUE('CN_FFNAME_REV_TYPE');
945: END IF;
946:
947: /* the two flex field names should not be same and they should one of the fields attribute1 .. 15 */

Line 944: p_ffname_rev_type := fnd_profile.VALUE('CN_FFNAME_REV_TYPE');

940: END IF;
941:
942: /* Get the flex field name corresponding to revenue type */
943: IF (fnd_profile.defined('CN_FFNAME_REV_TYPE')) THEN
944: p_ffname_rev_type := fnd_profile.VALUE('CN_FFNAME_REV_TYPE');
945: END IF;
946:
947: /* the two flex field names should not be same and they should one of the fields attribute1 .. 15 */
948: IF (

Line 1475: SELECT TO_NUMBER(NVL(fnd_profile.value('CN_NUMBER_OF_WORKERS'),1))

1471: errbuf := NULL;
1472: retcode := 0;
1473: debugmsg('SCA : Populating data to TRANS table');
1474:
1475: SELECT TO_NUMBER(NVL(fnd_profile.value('CN_NUMBER_OF_WORKERS'),1))
1476: INTO l_num_workers
1477: FROM dual;
1478:
1479: IF l_num_workers > 10

Line 2709: IF (fnd_profile.defined('CN_SKIP_CREDIT_ALLOCATION')) THEN

2705: debugmsg('SCA : process_audit_id is ' || l_process_audit_id);
2706: /* Continue only if the profile "OIC: Skip Credit Allocation" is set to No */
2707: l_skip_credit_flag := 'Y';
2708:
2709: IF (fnd_profile.defined('CN_SKIP_CREDIT_ALLOCATION')) THEN
2710: l_skip_credit_flag := fnd_profile.VALUE('CN_SKIP_CREDIT_ALLOCATION');
2711: END IF;
2712:
2713: IF (l_skip_credit_flag <> 'N') THEN

Line 2710: l_skip_credit_flag := fnd_profile.VALUE('CN_SKIP_CREDIT_ALLOCATION');

2706: /* Continue only if the profile "OIC: Skip Credit Allocation" is set to No */
2707: l_skip_credit_flag := 'Y';
2708:
2709: IF (fnd_profile.defined('CN_SKIP_CREDIT_ALLOCATION')) THEN
2710: l_skip_credit_flag := fnd_profile.VALUE('CN_SKIP_CREDIT_ALLOCATION');
2711: END IF;
2712:
2713: IF (l_skip_credit_flag <> 'N') THEN
2714: debugmsg('SCA : Profile OIC: Skip Credit Allocation is set to Yes');

Line 2801: SELECT TO_NUMBER(NVL(fnd_profile.value('CN_NUMBER_OF_WORKERS'),1)) INTO l_num_workers

2797: END IF;
2798:
2799: debugmsg('SCA : CN_SCATM_TAE_PUB.get_credited_txns completed successfully');
2800:
2801: SELECT TO_NUMBER(NVL(fnd_profile.value('CN_NUMBER_OF_WORKERS'),1)) INTO l_num_workers
2802: FROM dual;
2803:
2804: IF l_num_workers < 1
2805: THEN