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 288: l_sleep_time_char := fnd_profile.VALUE('CN_SLEEP_TIME');

284: debugmsg('SCA : Conc_Dispatch : Total conc requests submitted : ' || x_batch_total);
285: debugmsg('Total conc requests submitted : ' || x_batch_total);
286: --cn_message_pkg.flush;
287: debug_v := l_primary_request_stack(primary_ptr);
288: l_sleep_time_char := fnd_profile.VALUE('CN_SLEEP_TIME');
289:
290: IF l_sleep_time_char IS NOT NULL THEN
291: l_sleep_time := TO_NUMBER(l_sleep_time_char);
292: END IF;

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

429: FETCH query_cur
430: INTO l_logical_batch_size;
431:
432: x_size := l_logical_batch_size;
433: l_worker_num := NVL(fnd_profile.VALUE('CN_NUMBER_OF_WORKERS'), 1);
434:
435: IF (l_worker_num < 1) THEN
436: l_worker_num := 1;
437: END IF;

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

1009: errbuf := NULL;
1010: retcode := 0;
1011:
1012: /* Get the flex field name corresponding to split percentage */
1013: IF (fnd_profile.defined('CN_FFNAME_SPLIT_PCTG')) THEN
1014: p_ffname_split_pctg := fnd_profile.VALUE('CN_FFNAME_SPLIT_PCTG');
1015: END IF;
1016:
1017: /* Get the flex field name corresponding to revenue type */

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

1010: retcode := 0;
1011:
1012: /* Get the flex field name corresponding to split percentage */
1013: IF (fnd_profile.defined('CN_FFNAME_SPLIT_PCTG')) THEN
1014: p_ffname_split_pctg := fnd_profile.VALUE('CN_FFNAME_SPLIT_PCTG');
1015: END IF;
1016:
1017: /* Get the flex field name corresponding to revenue type */
1018: IF (fnd_profile.defined('CN_FFNAME_REV_TYPE')) THEN

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

1014: p_ffname_split_pctg := fnd_profile.VALUE('CN_FFNAME_SPLIT_PCTG');
1015: END IF;
1016:
1017: /* Get the flex field name corresponding to revenue type */
1018: IF (fnd_profile.defined('CN_FFNAME_REV_TYPE')) THEN
1019: p_ffname_rev_type := fnd_profile.VALUE('CN_FFNAME_REV_TYPE');
1020: END IF;
1021:
1022: /* the two flex field names should not be same and they should one of the fields attribute1 .. 15 */

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

1015: END IF;
1016:
1017: /* Get the flex field name corresponding to revenue type */
1018: IF (fnd_profile.defined('CN_FFNAME_REV_TYPE')) THEN
1019: p_ffname_rev_type := fnd_profile.VALUE('CN_FFNAME_REV_TYPE');
1020: END IF;
1021:
1022: /* the two flex field names should not be same and they should one of the fields attribute1 .. 15 */
1023: IF (

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

3166: debugmsg('SCA : process_audit_id is ' || l_process_audit_id);
3167: /* Continue only if the profile "OIC: Skip Credit Allocation" is set to No */
3168: l_skip_credit_flag := 'Y';
3169:
3170: IF (fnd_profile.defined('CN_SKIP_CREDIT_ALLOCATION')) THEN
3171: l_skip_credit_flag := fnd_profile.VALUE('CN_SKIP_CREDIT_ALLOCATION');
3172: END IF;
3173:
3174: IF (l_skip_credit_flag <> 'N') THEN

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

3167: /* Continue only if the profile "OIC: Skip Credit Allocation" is set to No */
3168: l_skip_credit_flag := 'Y';
3169:
3170: IF (fnd_profile.defined('CN_SKIP_CREDIT_ALLOCATION')) THEN
3171: l_skip_credit_flag := fnd_profile.VALUE('CN_SKIP_CREDIT_ALLOCATION');
3172: END IF;
3173:
3174: IF (l_skip_credit_flag <> 'N') THEN
3175: debugmsg('SCA : Profile OIC: Skip Credit Allocation is set to Yes');

Line 3231: SELECT TO_NUMBER(NVL(fnd_profile.value('CN_NUMBER_OF_WORKERS'),1)) INTO g_num_workers

3227: g_unloaded_txn_tbl := g_rowid_tbl_type();
3228: g_loaded_txn_rowid_tbl := g_rowid_tbl_type();
3229: g_loaded_txn_comid_tbl := g_comm_lines_api_id_tbl_type();
3230:
3231: SELECT TO_NUMBER(NVL(fnd_profile.value('CN_NUMBER_OF_WORKERS'),1)) INTO g_num_workers
3232: FROM dual;
3233:
3234: IF g_num_workers < 1
3235: THEN