APPS.JA_ZZ_VALIDATE_INVOICE_GDF dependencies on FND_DATE

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

322: l_gui_source_id NUMBER;
323: l_last_trx_date DATE;
324:
325: CURSOR c_last_trx_date(x_gui_source_id NUMBER) IS
326: SELECT fnd_date.chardate_to_date(src.global_attribute5)
327: FROM ra_batch_sources src
328: WHERE src.batch_source_id = x_gui_source_id;
329:
330: BEGIN

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

562: l_trx_header_id := p_trx_header_id;
563: l_trx_line_id := p_trx_line_id;
564: l_batch_source_id := p_batch_source_id;
565: l_trx_date := TRUNC(p_trx_date);
566: l_last_trx_date := TRUNC(fnd_date.canonical_to_date(p_last_trx_date));
567: l_adv_days := p_advance_days;
568: l_created_from := p_created_from;
569:
570: l_advanced_date := sysdate + NVL(l_adv_days,0);

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

602: END;
603: END IF;
604: ELSE
605: IF l_created_from = 'RAXTRX' THEN
606: fnd_message.set_token('LAST_ISSUED_DATE',fnd_date.date_to_chardate(l_last_trx_date));
607: fnd_message.set_token('ADVANCED_DATE',fnd_date.date_to_chardate(l_advanced_date));
608: l_message_text := fnd_message.get;
609: l_invalid_value := fnd_date.date_to_chardate(l_trx_date);
610: IF NOT jg_zz_invoice_create.put_error_message(

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

603: END IF;
604: ELSE
605: IF l_created_from = 'RAXTRX' THEN
606: fnd_message.set_token('LAST_ISSUED_DATE',fnd_date.date_to_chardate(l_last_trx_date));
607: fnd_message.set_token('ADVANCED_DATE',fnd_date.date_to_chardate(l_advanced_date));
608: l_message_text := fnd_message.get;
609: l_invalid_value := fnd_date.date_to_chardate(l_trx_date);
610: IF NOT jg_zz_invoice_create.put_error_message(
611: 'JA'

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

605: IF l_created_from = 'RAXTRX' THEN
606: fnd_message.set_token('LAST_ISSUED_DATE',fnd_date.date_to_chardate(l_last_trx_date));
607: fnd_message.set_token('ADVANCED_DATE',fnd_date.date_to_chardate(l_advanced_date));
608: l_message_text := fnd_message.get;
609: l_invalid_value := fnd_date.date_to_chardate(l_trx_date);
610: IF NOT jg_zz_invoice_create.put_error_message(
611: 'JA'
612: , 'JA_TW_AR_INVALID_TRX_DATE'
613: , l_trx_header_id

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

775:
776: l_gui_source_id := p_batch_source_id;
777: l_created_from := p_created_from;
778:
779: l_last_trx_date := fnd_date.date_to_canonical(p_last_trx_date);
780:
781: OPEN c_last_issued_date(l_gui_source_id);
782: FETCH c_last_issued_date INTO l_dummy;
783:

Line 933: fnd_date.date_to_chardate(p_last_issued_date));

929: ELSE
930: IF p_created_from = 'RAXTRX' THEN
931: fnd_message.set_token(
932: 'LAST_ISSUED_DATE',
933: fnd_date.date_to_chardate(p_last_issued_date));
934: fnd_message.set_token(
935: 'ADVANCED_DATE',
936: fnd_date.date_to_chardate(sysdate+nvl(p_advance_days,0)));
937:

Line 936: fnd_date.date_to_chardate(sysdate+nvl(p_advance_days,0)));

932: 'LAST_ISSUED_DATE',
933: fnd_date.date_to_chardate(p_last_issued_date));
934: fnd_message.set_token(
935: 'ADVANCED_DATE',
936: fnd_date.date_to_chardate(sysdate+nvl(p_advance_days,0)));
937:
938: IF insert_interface_errors(
939: p_customer_trx_id,
940: 'JA_TH_AR_INVALID_TRX_DATE',

Line 941: fnd_date.date_to_chardate(p_trx_date),

937:
938: IF insert_interface_errors(
939: p_customer_trx_id,
940: 'JA_TH_AR_INVALID_TRX_DATE',
941: fnd_date.date_to_chardate(p_trx_date),
942: 'validate_trx_date') THEN
943: return(0);
944: ELSE
945: return(-1);

Line 1083: SET global_attribute2 = fnd_date.date_to_canonical(p_trx_date)

1079:
1080: FETCH last_issued_date INTO dummy;
1081:
1082: UPDATE ra_cust_trx_types
1083: SET global_attribute2 = fnd_date.date_to_canonical(p_trx_date)
1084: WHERE CURRENT OF last_issued_date;
1085:
1086: CLOSE last_issued_date;
1087:

Line 1106: fnd_date.date_to_chardate(p_trx_date),

1102:
1103: IF insert_interface_errors(
1104: p_customer_trx_id,
1105: 'JA_TH_AR_LAST_ISSD_DT_LOCKED',
1106: fnd_date.date_to_chardate(p_trx_date),
1107: 'update_last_issued_date') THEN
1108: return(0);
1109: ELSE
1110: return(-1);