APPS.IEX_MERGE_PVT dependencies on FND_PROFILE

Line 4: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));

1: PACKAGE BODY IEX_MERGE_PVT as
2: /* $Header: iexvmrgb.pls 120.9.12020000.2 2012/08/30 05:18:26 snuthala ship $ */
3:
4: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
5: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: G_Batch_Size NUMBER := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '1000'));
7: /*-------------------------------------------------------------
8: |

Line 6: G_Batch_Size NUMBER := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '1000'));

2: /* $Header: iexvmrgb.pls 120.9.12020000.2 2012/08/30 05:18:26 snuthala ship $ */
3:
4: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
5: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6: G_Batch_Size NUMBER := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '1000'));
7: /*-------------------------------------------------------------
8: |
9: | PROCEDURE
10: | SCORE_HISTORY_MERGE

Line 98: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');

94: ELSE
95: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
96: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_SCORE_HISTORIES',FALSE);
97: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
98: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
99:
100: /* process IEX_SCORE_HISTORIES.SCORE_OBJECT_ID.OBJECT_CODE='IEX_ACCOUNT' */
101: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
102: IEX_DEBUG_PUB.logMessage('IEX_SCORE_HISTORIES.SCORE_OBJECT_ID.OBJECT_CODE=IEX_ACCOUNT');

Line 459: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');

455:
456: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
457: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_DUNNING',FALSE);
458: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
459: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
460: IEX_DEBUG_PUB.logMessage('l_profile_val = ' || l_profile_val);
461: /* process IEX_STRATEGIES.CUST_ACCOUNT_ID */
462: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
463: IEX_DEBUG_PUB.logMessage('IEX_DUNNING.DUNNING_OBJECT_ID');

Line 797: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');

793:
794: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
795: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_STRATEGIES',FALSE);
796: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
797: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
798:
799: /* process IEX_STRATEGIES.CUST_ACCOUNT_ID */
800: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
801: IEX_DEBUG_PUB.logMessage('IEX_STRATEGIES.CUST_ACCOUNT_ID');

Line 1166: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');

1162: ELSE
1163: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1164: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_PROMISE_DETAILS',FALSE);
1165: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1166: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1167:
1168: open merged_records;
1169: LOOP
1170: FETCH merged_records BULK COLLECT INTO

Line 1344: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');

1340: ELSE
1341: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1342: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_DELINQUENCIES',FALSE);
1343: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1344: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1345:
1346: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1347: IEX_DEBUG_PUB.logMessage('l_profile_val = ' || l_profile_val);
1348: END IF;