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.JA_TW_SH_GUI_UTILS dependencies on FND_DATE

Line 363: SELECT fnd_date.chardate_to_date(src.global_attribute5)

359: l_last_trx_date DATE;
360:
361: CURSOR c_last_trx_date(x_gui_source_id NUMBER,
362: x_org_id NUMBER) IS
363: SELECT fnd_date.chardate_to_date(src.global_attribute5)
364: FROM ra_batch_sources src
365: WHERE src.batch_source_id = x_gui_source_id
366: -- Bug 4673732 : R12 MOAC change
367: AND decode(nvl(x_org_id,1), 1, 1, src.org_id) = nvl(x_org_id, 1);

Line 585: l_last_trx_date := TRUNC(fnd_date.canonical_to_date(p_last_trx_date));

581:
582: l_interface_line_id := p_interface_line_id;
583: l_batch_source_id := p_batch_source_id;
584: l_trx_date := TRUNC(p_trx_date);
585: l_last_trx_date := TRUNC(fnd_date.canonical_to_date(p_last_trx_date));
586: l_adv_days := p_advance_days;
587: l_created_from := p_created_from;
588: l_advanced_date := sysdate + NVL(l_adv_days,0);
589:

Line 622: fnd_message.set_token('LAST_ISSUED_DATE',fnd_date.date_to_chardate(l_last_trx_date));

618: END IF;
619: ELSE
620: IF l_created_from = 'RAXTRX' THEN
621: fnd_message.set_name('JA','JA_TW_AR_INVALID_TRX_DATE');
622: fnd_message.set_token('LAST_ISSUED_DATE',fnd_date.date_to_chardate(l_last_trx_date));
623: fnd_message.set_token('ADVANCED_DATE',fnd_date.date_to_chardate(l_advanced_date));
624: l_message_text := fnd_message.get;
625: l_invalid_value := fnd_date.date_to_chardate(l_trx_date);
626: IF NOT jg_zz_auto_invoice.put_error_message(

Line 623: fnd_message.set_token('ADVANCED_DATE',fnd_date.date_to_chardate(l_advanced_date));

619: ELSE
620: IF l_created_from = 'RAXTRX' THEN
621: fnd_message.set_name('JA','JA_TW_AR_INVALID_TRX_DATE');
622: fnd_message.set_token('LAST_ISSUED_DATE',fnd_date.date_to_chardate(l_last_trx_date));
623: fnd_message.set_token('ADVANCED_DATE',fnd_date.date_to_chardate(l_advanced_date));
624: l_message_text := fnd_message.get;
625: l_invalid_value := fnd_date.date_to_chardate(l_trx_date);
626: IF NOT jg_zz_auto_invoice.put_error_message(
627: l_interface_line_id

Line 625: l_invalid_value := fnd_date.date_to_chardate(l_trx_date);

621: fnd_message.set_name('JA','JA_TW_AR_INVALID_TRX_DATE');
622: fnd_message.set_token('LAST_ISSUED_DATE',fnd_date.date_to_chardate(l_last_trx_date));
623: fnd_message.set_token('ADVANCED_DATE',fnd_date.date_to_chardate(l_advanced_date));
624: l_message_text := fnd_message.get;
625: l_invalid_value := fnd_date.date_to_chardate(l_trx_date);
626: IF NOT jg_zz_auto_invoice.put_error_message(
627: l_interface_line_id
628: , l_message_text
629: , l_invalid_value)

Line 776: l_last_trx_date := fnd_date.date_to_canonical(p_last_trx_date);

772: BEGIN
773:
774: l_gui_source_id := p_batch_source_id;
775: l_created_from := p_created_from;
776: l_last_trx_date := fnd_date.date_to_canonical(p_last_trx_date);
777:
778: OPEN c_last_issued_date(l_gui_source_id,
779: p_org_id);
780: FETCH c_last_issued_date INTO l_dummy;