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.3.12010000.2 2008/08/14 13:37:03 schekuri 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.3.12010000.2 2008/08/14 13:37:03 schekuri 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 96: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');

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

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

420:
421: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
422: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_DUNNING',FALSE);
423: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
424: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
425:
426: /* process IEX_STRATEGIES.CUST_ACCOUNT_ID */
427: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
428: IEX_DEBUG_PUB.logMessage('IEX_DUNNING.DUNNING_OBJECT_ID');

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

712:
713: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
714: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_STRATEGIES',FALSE);
715: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
716: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
717:
718: /* process IEX_STRATEGIES.CUST_ACCOUNT_ID */
719: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
720: IEX_DEBUG_PUB.logMessage('IEX_STRATEGIES.CUST_ACCOUNT_ID');

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

1045: ELSE
1046: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1047: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_PROMISE_DETAILS',FALSE);
1048: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1049: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1050:
1051: open merged_records;
1052: LOOP
1053: FETCH merged_records BULK COLLECT INTO

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

1218: ELSE
1219: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1220: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','IEX_DELINQUENCIES',FALSE);
1221: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1222: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1223:
1224: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1225: IEX_DEBUG_PUB.logMessage('l_profile_val = ' || l_profile_val);
1226: END IF;