66: (sysdate + nvl(p_advance_days,0)) THEN
67: return(1);
68: ELSE
69: IF p_created_from = 'RAXTRX' THEN
70: fnd_message.set_name('JA','JA_TH_AR_INVALID_TRX_DATE');
71: fnd_message.set_token(
72: 'LAST_ISSUED_DATE',
73: fnd_date.date_to_chardate(p_last_issued_date));
74: fnd_message.set_token(
67: return(1);
68: ELSE
69: IF p_created_from = 'RAXTRX' THEN
70: fnd_message.set_name('JA','JA_TH_AR_INVALID_TRX_DATE');
71: fnd_message.set_token(
72: 'LAST_ISSUED_DATE',
73: fnd_date.date_to_chardate(p_last_issued_date));
74: fnd_message.set_token(
75: 'ADVANCED_DATE',
70: fnd_message.set_name('JA','JA_TH_AR_INVALID_TRX_DATE');
71: fnd_message.set_token(
72: 'LAST_ISSUED_DATE',
73: fnd_date.date_to_chardate(p_last_issued_date));
74: fnd_message.set_token(
75: 'ADVANCED_DATE',
76: fnd_date.date_to_chardate(sysdate+nvl(p_advance_days,0)));
77:
78: IF insert_interface_errors(
76: fnd_date.date_to_chardate(sysdate+nvl(p_advance_days,0)));
77:
78: IF insert_interface_errors(
79: p_customer_trx_id,
80: fnd_message.get,
81: fnd_date.date_to_chardate(p_trx_date),
82: 'validate_trx_date') THEN
83: return(0);
84: ELSE
174: WHEN others THEN
175: raise;
176: END;
177:
178: fnd_message.set_name('JA','JA_TH_AR_LAST_ISSD_DT_LOCKED');
179:
180: IF insert_interface_errors(
181: p_customer_trx_id,
182: fnd_message.get,
178: fnd_message.set_name('JA','JA_TH_AR_LAST_ISSD_DT_LOCKED');
179:
180: IF insert_interface_errors(
181: p_customer_trx_id,
182: fnd_message.get,
183: fnd_date.date_to_chardate(p_trx_date),
184: 'update_last_issued_date') THEN
185: return(0);
186: ELSE