eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_CUST_MERGE dependencies on FND_PROFILE

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

218:
219: END LOOP;
220:
221: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
222: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
223:
224:
225: OPEN merge_headers_2;
226: LOOP

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

1417:
1418: ELSE
1419:
1420: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1421: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1422:
1423: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1424: insert into HZ_CUSTOMER_MERGE_LOG (
1425: MERGE_LOG_ID,

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

2178:
2179: END LOOP;
2180:
2181: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
2182: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
2183:
2184: arp_message.set_line( 'OE_CUST_MERGE.OE_Merge_Lines():1' );
2185:
2186: OPEN merge_lines_2;

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

3045:
3046: ELSE
3047:
3048: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
3049: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
3050:
3051: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
3052: insert into HZ_CUSTOMER_MERGE_LOG (
3053: MERGE_LOG_ID,

Line 3590: l_dbi_profile := NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'), 'Y');

3586:
3587: arp_message.set_line( 'OE_CUST_MERGE.Merge()+' );
3588: -- sql_stmnt := 'Alter Session set hash_area_size=61440000';
3589: -- EXECUTE IMMEDIATE sql_stmnt;
3590: l_dbi_profile := NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'), 'Y');
3591: arp_message.set_line(' Dbi Profile='||l_dbi_profile);
3592: OE_CUST_MERGE.OE_Attachment_Merge (Req_Id, Set_Num, Process_Mode);
3593: OE_CUST_MERGE.OE_Defaulting_Merge (Req_Id, Set_Num, Process_Mode);
3594: OE_CUST_MERGE.OE_Hold_Merge (Req_Id, Set_Num, Process_Mode);

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

3676:
3677: ELSE
3678:
3679: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
3680: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
3681:
3682: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
3683: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
3684: MERGE_LOG_ID,

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

4034:
4035: ELSE
4036:
4037: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
4038: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
4039: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
4040: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
4041: MERGE_LOG_ID,
4042: TABLE_NAME,

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

4682:
4683: ELSE
4684:
4685: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
4686: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
4687:
4688: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
4689: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
4690: MERGE_LOG_ID,

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

5039:
5040: ELSE
5041:
5042: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5043: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5044:
5045: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
5046: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
5047: MERGE_LOG_ID,

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

5290:
5291: ELSE
5292:
5293: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5294: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5295:
5296: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
5297: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
5298: MERGE_LOG_ID,

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

5414:
5415: ELSE
5416:
5417: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5418: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5419:
5420: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
5421: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
5422: MERGE_LOG_ID,

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

5606:
5607: ELSE
5608:
5609: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5610: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5611:
5612: OPEN sets_merge_2;
5613: LOOP
5614: FETCH sets_merge_2

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

5773:
5774: ELSE
5775:
5776: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
5777: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
5778:
5779: OPEN c1_2;
5780: LOOP
5781: FETCH c1_2

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

6027:
6028: END LOOP;
6029:
6030: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
6031: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
6032:
6033:
6034: OPEN merge_headers_2;
6035: LOOP

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

6304:
6305: ELSE
6306:
6307: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
6308: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
6309:
6310: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
6311: insert into HZ_CUSTOMER_MERGE_LOG (
6312: MERGE_LOG_ID,

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

6829:
6830: END LOOP;
6831:
6832: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
6833: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
6834:
6835: OPEN merge_lines_2;
6836: LOOP
6837: FETCH merge_lines_2

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

7164:
7165: END LOOP;
7166:
7167: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
7168: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
7169:
7170: OPEN merge_lines_history_2;
7171: LOOP
7172: FETCH merge_lines_history_2

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

7373:
7374: ELSE
7375:
7376: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
7377: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
7378:
7379:
7380: -- customer level update
7381: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');