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.JL_CMERGE dependencies on ARP_MESSAGE

Line 66: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');

62: BEGIN
63: IF process_mode='LOCK' THEN
64: NULL;
65: ELSE
66: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
67: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JL_BR_AR_BANK_RETURNS',FALSE);
68: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
69: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
70:

Line 67: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JL_BR_AR_BANK_RETURNS',FALSE);

63: IF process_mode='LOCK' THEN
64: NULL;
65: ELSE
66: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
67: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JL_BR_AR_BANK_RETURNS',FALSE);
68: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
69: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
70:
71: open merged_records;

Line 132: arp_message.set_name('AR','AR_ROWS_UPDATED');

128: EXIT;
129: END IF;
130: END LOOP;
131:
132: arp_message.set_name('AR','AR_ROWS_UPDATED');
133: arp_message.set_token('NUM_ROWS',to_char(l_count));
134: END IF;
135: EXCEPTION
136: WHEN OTHERS THEN

Line 133: arp_message.set_token('NUM_ROWS',to_char(l_count));

129: END IF;
130: END LOOP;
131:
132: arp_message.set_name('AR','AR_ROWS_UPDATED');
133: arp_message.set_token('NUM_ROWS',to_char(l_count));
134: END IF;
135: EXCEPTION
136: WHEN OTHERS THEN
137: arp_message.set_line( 'jl_br_bank_rtrn_upd');

Line 137: arp_message.set_line( 'jl_br_bank_rtrn_upd');

133: arp_message.set_token('NUM_ROWS',to_char(l_count));
134: END IF;
135: EXCEPTION
136: WHEN OTHERS THEN
137: arp_message.set_line( 'jl_br_bank_rtrn_upd');
138: RAISE;
139: END jl_br_bank_rtrn_upd;
140:
141:

Line 209: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');

205: BEGIN
206: IF process_mode='LOCK' THEN
207: NULL;
208: ELSE
209: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
210: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JL_BR_AR_OCCURRENCE_DOCS',FALSE);
211: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
212: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
213:

Line 210: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JL_BR_AR_OCCURRENCE_DOCS',FALSE);

206: IF process_mode='LOCK' THEN
207: NULL;
208: ELSE
209: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
210: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JL_BR_AR_OCCURRENCE_DOCS',FALSE);
211: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
212: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
213:
214: open merged_records;

Line 283: arp_message.set_name('AR','AR_ROWS_UPDATED');

279: EXIT;
280: END IF;
281: END LOOP;
282:
283: arp_message.set_name('AR','AR_ROWS_UPDATED');
284: arp_message.set_token('NUM_ROWS',to_char(l_count));
285: END IF;
286: EXCEPTION
287: WHEN OTHERS THEN

Line 284: arp_message.set_token('NUM_ROWS',to_char(l_count));

280: END IF;
281: END LOOP;
282:
283: arp_message.set_name('AR','AR_ROWS_UPDATED');
284: arp_message.set_token('NUM_ROWS',to_char(l_count));
285: END IF;
286: EXCEPTION
287: WHEN OTHERS THEN
288: arp_message.set_line( 'jl_br_occ_doc_upd');

Line 288: arp_message.set_line( 'jl_br_occ_doc_upd');

284: arp_message.set_token('NUM_ROWS',to_char(l_count));
285: END IF;
286: EXCEPTION
287: WHEN OTHERS THEN
288: arp_message.set_line( 'jl_br_occ_doc_upd');
289: RAISE;
290: END jl_br_occ_doc_upd;
291:
292: ----------------------------------------------------------------------------

Line 351: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');

347: BEGIN
348: IF process_mode='LOCK' THEN
349: NULL;
350: ELSE
351: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
352: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JL_BR_AR_PAY_SCHED_AUX',FALSE);
353: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
354: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
355:

Line 352: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JL_BR_AR_PAY_SCHED_AUX',FALSE);

348: IF process_mode='LOCK' THEN
349: NULL;
350: ELSE
351: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
352: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JL_BR_AR_PAY_SCHED_AUX',FALSE);
353: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
354: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
355:
356: open merged_records;

Line 414: arp_message.set_name('AR','AR_ROWS_UPDATED');

410: EXIT;
411: END IF;
412: END LOOP;
413:
414: arp_message.set_name('AR','AR_ROWS_UPDATED');
415: arp_message.set_token('NUM_ROWS',to_char(l_count));
416: END IF;
417: EXCEPTION
418: WHEN OTHERS THEN

Line 415: arp_message.set_token('NUM_ROWS',to_char(l_count));

411: END IF;
412: END LOOP;
413:
414: arp_message.set_name('AR','AR_ROWS_UPDATED');
415: arp_message.set_token('NUM_ROWS',to_char(l_count));
416: END IF;
417: EXCEPTION
418: WHEN OTHERS THEN
419: arp_message.set_line( 'jl_br_pay_sch_upd');

Line 419: arp_message.set_line( 'jl_br_pay_sch_upd');

415: arp_message.set_token('NUM_ROWS',to_char(l_count));
416: END IF;
417: EXCEPTION
418: WHEN OTHERS THEN
419: arp_message.set_line( 'jl_br_pay_sch_upd');
420: RAISE;
421: END jl_br_pay_sch_upd;
422:
423:

Line 643: arp_message.set_line ('JL_CMERGE.JL_BR_JOURNALS_UPD()+');

639: l_count NUMBER;
640:
641: BEGIN
642:
643: arp_message.set_line ('JL_CMERGE.JL_BR_JOURNALS_UPD()+');
644:
645: IF (process_mode = 'LOCK' ) THEN
646: arp_message.set_name ('AR', 'AR_LOCKING_TABLE');
647: arp_message.set_token ('TABLE_NAME','JL_BR_JOURNALS_ALL',FALSE);

Line 646: arp_message.set_name ('AR', 'AR_LOCKING_TABLE');

642:
643: arp_message.set_line ('JL_CMERGE.JL_BR_JOURNALS_UPD()+');
644:
645: IF (process_mode = 'LOCK' ) THEN
646: arp_message.set_name ('AR', 'AR_LOCKING_TABLE');
647: arp_message.set_token ('TABLE_NAME','JL_BR_JOURNALS_ALL',FALSE);
648:
649: -- open c1;
650: -- close c1;

Line 647: arp_message.set_token ('TABLE_NAME','JL_BR_JOURNALS_ALL',FALSE);

643: arp_message.set_line ('JL_CMERGE.JL_BR_JOURNALS_UPD()+');
644:
645: IF (process_mode = 'LOCK' ) THEN
646: arp_message.set_name ('AR', 'AR_LOCKING_TABLE');
647: arp_message.set_token ('TABLE_NAME','JL_BR_JOURNALS_ALL',FALSE);
648:
649: -- open c1;
650: -- close c1;
651:

Line 680: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');

676: AND application_id=222;
677: g_count := SQL%ROWCOUNT;
678: */
679:
680: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
681: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JL_BR_JOURNALS_ALL',FALSE);
682: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
683: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
684:

Line 681: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JL_BR_JOURNALS_ALL',FALSE);

677: g_count := SQL%ROWCOUNT;
678: */
679:
680: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
681: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JL_BR_JOURNALS_ALL',FALSE);
682: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
683: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
684:
685: l_count:=0;

Line 795: arp_message.set_name ('AR','AR_ROWS_UPDATED');

791: EXIT;
792: END IF;
793: END LOOP;
794:
795: arp_message.set_name ('AR','AR_ROWS_UPDATED');
796: arp_message.set_token ('NUM_ROWS', to_char(l_count) );
797:
798: END IF ;
799: arp_message.set_line('JL_CMERGE.JL_BR_JOURNALS_UPD()-');

Line 796: arp_message.set_token ('NUM_ROWS', to_char(l_count) );

792: END IF;
793: END LOOP;
794:
795: arp_message.set_name ('AR','AR_ROWS_UPDATED');
796: arp_message.set_token ('NUM_ROWS', to_char(l_count) );
797:
798: END IF ;
799: arp_message.set_line('JL_CMERGE.JL_BR_JOURNALS_UPD()-');
800:

Line 799: arp_message.set_line('JL_CMERGE.JL_BR_JOURNALS_UPD()-');

795: arp_message.set_name ('AR','AR_ROWS_UPDATED');
796: arp_message.set_token ('NUM_ROWS', to_char(l_count) );
797:
798: END IF ;
799: arp_message.set_line('JL_CMERGE.JL_BR_JOURNALS_UPD()-');
800:
801: EXCEPTION
802: WHEN OTHERS THEN
803: arp_message.set_error ('JL_CMERGE.JL_BR_JOURNALS_UPD');

Line 803: arp_message.set_error ('JL_CMERGE.JL_BR_JOURNALS_UPD');

799: arp_message.set_line('JL_CMERGE.JL_BR_JOURNALS_UPD()-');
800:
801: EXCEPTION
802: WHEN OTHERS THEN
803: arp_message.set_error ('JL_CMERGE.JL_BR_JOURNALS_UPD');
804: RAISE;
805: END jl_br_journals_upd;
806:
807:

Line 1046: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');

1042:
1043:
1044: x_profile_org:=fnd_profile.value ('ORG_ID');
1045:
1046: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1047: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JL_BR_BALANCES_ALL',FALSE);
1048: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1049:
1050: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');

Line 1047: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JL_BR_BALANCES_ALL',FALSE);

1043:
1044: x_profile_org:=fnd_profile.value ('ORG_ID');
1045:
1046: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1047: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JL_BR_BALANCES_ALL',FALSE);
1048: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1049:
1050: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1051:

Line 1528: arp_message.set_line ('JL_CMERGE.JL_BR_BALANCES_UPD()+');

1524: END BALANCES;
1525:
1526: BEGIN
1527:
1528: arp_message.set_line ('JL_CMERGE.JL_BR_BALANCES_UPD()+');
1529:
1530: IF (process_mode = 'LOCK' ) THEN
1531: arp_message.set_name ('AR', 'AR_LOCKING_TABLE');
1532: arp_message.set_token ('TABLE_NAME','JL_BR_BALANCES_ALL',FALSE);

Line 1531: arp_message.set_name ('AR', 'AR_LOCKING_TABLE');

1527:
1528: arp_message.set_line ('JL_CMERGE.JL_BR_BALANCES_UPD()+');
1529:
1530: IF (process_mode = 'LOCK' ) THEN
1531: arp_message.set_name ('AR', 'AR_LOCKING_TABLE');
1532: arp_message.set_token ('TABLE_NAME','JL_BR_BALANCES_ALL',FALSE);
1533:
1534: open merged_records;
1535: close merged_records;

Line 1532: arp_message.set_token ('TABLE_NAME','JL_BR_BALANCES_ALL',FALSE);

1528: arp_message.set_line ('JL_CMERGE.JL_BR_BALANCES_UPD()+');
1529:
1530: IF (process_mode = 'LOCK' ) THEN
1531: arp_message.set_name ('AR', 'AR_LOCKING_TABLE');
1532: arp_message.set_token ('TABLE_NAME','JL_BR_BALANCES_ALL',FALSE);
1533:
1534: open merged_records;
1535: close merged_records;
1536:

Line 1554: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');

1550:
1551: */
1552: -- Replaced with new logic that will generate log file.
1553:
1554: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1555: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JL_BR_BALANCES_ALL',FALSE);
1556: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1557: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1558:

Line 1555: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JL_BR_BALANCES_ALL',FALSE);

1551: */
1552: -- Replaced with new logic that will generate log file.
1553:
1554: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1555: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','JL_BR_BALANCES_ALL',FALSE);
1556: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1557: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1558:
1559: l_count:=0;

Line 1670: arp_message.set_name ('AR','AR_ROWS_UPDATED');

1666: EXIT;
1667: END IF;
1668: END LOOP;
1669:
1670: arp_message.set_name ('AR','AR_ROWS_UPDATED');
1671: arp_message.set_token ('NUM_ROWS', to_char(l_count) );
1672:
1673: -- Call Procedure to Update Balances with the journals from the duplicated customer,
1674: -- now in the merged customer.

Line 1671: arp_message.set_token ('NUM_ROWS', to_char(l_count) );

1667: END IF;
1668: END LOOP;
1669:
1670: arp_message.set_name ('AR','AR_ROWS_UPDATED');
1671: arp_message.set_token ('NUM_ROWS', to_char(l_count) );
1672:
1673: -- Call Procedure to Update Balances with the journals from the duplicated customer,
1674: -- now in the merged customer.
1675: Balances;

Line 1678: arp_message.set_line('JL_CMERGE.JL_BR_BALANCES_UPD()-');

1674: -- now in the merged customer.
1675: Balances;
1676:
1677: END IF ;
1678: arp_message.set_line('JL_CMERGE.JL_BR_BALANCES_UPD()-');
1679:
1680: EXCEPTION
1681: WHEN OTHERS THEN
1682: arp_message.set_error ('JL_CMERGE.JL_BR_BALANCES_UPD');

Line 1682: arp_message.set_error ('JL_CMERGE.JL_BR_BALANCES_UPD');

1678: arp_message.set_line('JL_CMERGE.JL_BR_BALANCES_UPD()-');
1679:
1680: EXCEPTION
1681: WHEN OTHERS THEN
1682: arp_message.set_error ('JL_CMERGE.JL_BR_BALANCES_UPD');
1683: RAISE;
1684: END jl_br_balances_upd ;
1685:
1686:

Line 1720: arp_message.set_line ('JL_CMERGE.MERGE()+');

1716: return;
1717: end if;
1718:
1719:
1720: arp_message.set_line ('JL_CMERGE.MERGE()+');
1721: jl_br_bank_rtrn_upd (req_id, set_num, process_mode);
1722: jl_br_occ_doc_upd (req_id, set_num, process_mode);
1723: jl_br_pay_sch_upd (req_id,set_num,process_mode);
1724: jl_zz_tx_cus_cls_upd (req_id,set_num,process_mode);

Line 1729: arp_message.set_line ('JL_CMERGE.MERGE()-');

1725: jl_zz_tx_exc_cus_upd (req_id,set_num,process_mode);
1726: jl_zz_tx_lgl_msg_upd (req_id,set_num,process_mode);
1727: jl_br_journals_upd (req_id,set_num,process_mode);
1728: jl_br_balances_upd (req_id,set_num,process_mode);
1729: arp_message.set_line ('JL_CMERGE.MERGE()-');
1730:
1731: END merge;
1732: END jl_cmerge;