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

Line 348: g_crev_gl_trans_date := FND_DATE.canonical_to_date(p_crev_gl_trans_date);

344: g_crev_prev_cost_type_id := TO_NUMBER(p_crev_prev_cost_type_id);
345: g_crev_prev_calendar := p_crev_prev_calendar;
346: g_crev_prev_period := p_crev_prev_period;
347:
348: g_crev_gl_trans_date := FND_DATE.canonical_to_date(p_crev_gl_trans_date);
349:
350:
351: IF g_crev_curr_calendar IS NULL OR g_crev_curr_period IS NULL OR
352: g_crev_prev_cost_type_id IS NULL OR g_crev_prev_calendar IS NULL OR

Line 487: p_posting_start_date => FND_DATE.canonical_to_date(p_posting_start_date),

483: insert_control_record(
484: p_user_id => FND_GLOBAL.user_id,
485: p_gl_fiscal_year => TO_NUMBER(p_gl_fiscal_year),
486: p_gl_period => TO_NUMBER(p_gl_period),
487: p_posting_start_date => FND_DATE.canonical_to_date(p_posting_start_date),
488: p_posting_end_date => FND_DATE.canonical_to_date(p_posting_end_date),
489: p_test_posting => p_test_posting,
490: /* Start INVCONV umoogala
491: p_co_code => p_co_code,

Line 488: p_posting_end_date => FND_DATE.canonical_to_date(p_posting_end_date),

484: p_user_id => FND_GLOBAL.user_id,
485: p_gl_fiscal_year => TO_NUMBER(p_gl_fiscal_year),
486: p_gl_period => TO_NUMBER(p_gl_period),
487: p_posting_start_date => FND_DATE.canonical_to_date(p_posting_start_date),
488: p_posting_end_date => FND_DATE.canonical_to_date(p_posting_end_date),
489: p_test_posting => p_test_posting,
490: /* Start INVCONV umoogala
491: p_co_code => p_co_code,
492: p_post_cm => l_post_cm, --p_post_cm,

Line 501: p_open_gl_date => FND_DATE.canonical_to_date(p_open_gl_date),

497: p_post_po => p_post_po,
498: p_post_pur => p_post_pur,
499: */
500: p_closed_per_ind => l_closed_per_ind,
501: p_open_gl_date => FND_DATE.canonical_to_date(p_open_gl_date),
502: p_crev_gl_trans_date => l_crev_gl_trans_date,
503: p_open_gl_fiscal_year => l_open_gl_fiscal_year,
504: p_open_gl_period => l_open_gl_period,
505: p_post_if_no_cost => p_post_if_no_cost,

Line 539: fnd_date.date_to_canonical(SYSDATE),

535:
536:
537: l_conc_id := FND_REQUEST.SUBMIT_REQUEST(
538: 'GMF','GMFXUPD','OPM Subledger Accounting Pre-Processor',
539: fnd_date.date_to_canonical(SYSDATE),
540: TRUE, '-r',TO_CHAR(l_subledger_ref_no),
541: CHR(0),'','','','','','','','','','','','',
542: '','','','','','','','','','','','','','','',
543: '','','','','','','','','','','','','','','',

Line 884: l_open_gl_date := FND_DATE.canonical_to_date(p_open_gl_date);

880:
881: l_gl_per_real_start_date := gmf_legal_entity_tz.convert_le_to_srv_tz(l_gl_per_start_date, g_legal_entity_id); /* Bug#5623121 ANTHIYAG 30-Oct-2006 */
882: l_gl_per_real_end_date := gmf_legal_entity_tz.convert_le_to_srv_tz(l_gl_per_end_date + 1 - (1/86400), g_legal_entity_id); /* Bug#5623121 ANTHIYAG 30-Oct-2006 */
883:
884: l_open_gl_date := FND_DATE.canonical_to_date(p_open_gl_date);
885: l_posting_start_date := FND_DATE.canonical_to_date(p_posting_start_date);
886: l_posting_end_date := FND_DATE.canonical_to_date(p_posting_end_date);
887:
888: /* Validate if dates are correct */

Line 885: l_posting_start_date := FND_DATE.canonical_to_date(p_posting_start_date);

881: l_gl_per_real_start_date := gmf_legal_entity_tz.convert_le_to_srv_tz(l_gl_per_start_date, g_legal_entity_id); /* Bug#5623121 ANTHIYAG 30-Oct-2006 */
882: l_gl_per_real_end_date := gmf_legal_entity_tz.convert_le_to_srv_tz(l_gl_per_end_date + 1 - (1/86400), g_legal_entity_id); /* Bug#5623121 ANTHIYAG 30-Oct-2006 */
883:
884: l_open_gl_date := FND_DATE.canonical_to_date(p_open_gl_date);
885: l_posting_start_date := FND_DATE.canonical_to_date(p_posting_start_date);
886: l_posting_end_date := FND_DATE.canonical_to_date(p_posting_end_date);
887:
888: /* Validate if dates are correct */
889: IF( l_posting_start_date > l_posting_end_date )

Line 886: l_posting_end_date := FND_DATE.canonical_to_date(p_posting_end_date);

882: l_gl_per_real_end_date := gmf_legal_entity_tz.convert_le_to_srv_tz(l_gl_per_end_date + 1 - (1/86400), g_legal_entity_id); /* Bug#5623121 ANTHIYAG 30-Oct-2006 */
883:
884: l_open_gl_date := FND_DATE.canonical_to_date(p_open_gl_date);
885: l_posting_start_date := FND_DATE.canonical_to_date(p_posting_start_date);
886: l_posting_end_date := FND_DATE.canonical_to_date(p_posting_end_date);
887:
888: /* Validate if dates are correct */
889: IF( l_posting_start_date > l_posting_end_date )
890: THEN

Line 912: FND_MESSAGE.SET_TOKEN('S1', fnd_date.date_to_displayDT(gmf_legal_entity_tz.convert_srv_to_le(g_legal_entity_id, l_posting_start_date), 'FND_NO_CONVERT'));

908: IF (l_posting_start_date < l_gl_per_real_start_date /* Bug#5623121 ANTHIYAG 30-Oct-2006 */
909: AND l_gl_per_real_start_date IS NOT NULL)
910: THEN
911: FND_MESSAGE.SET_NAME('GMF','GMF_INVALID_DATE_FOR_PERIOD');
912: FND_MESSAGE.SET_TOKEN('S1', fnd_date.date_to_displayDT(gmf_legal_entity_tz.convert_srv_to_le(g_legal_entity_id, l_posting_start_date), 'FND_NO_CONVERT'));
913: FND_MESSAGE.SET_TOKEN('S2', fnd_date.date_to_displayDT(gmf_legal_entity_tz.convert_srv_to_le(g_legal_entity_id, l_gl_per_real_start_date), 'FND_NO_CONVERT'));
914: FND_MESSAGE.SET_TOKEN('S3', fnd_date.date_to_displayDT(gmf_legal_entity_tz.convert_srv_to_le(g_legal_entity_id, l_gl_per_real_end_date), 'FND_NO_CONVERT'));
915: x_errbuf := fnd_message.get;
916: RAISE e_invalid_parameter;

Line 913: FND_MESSAGE.SET_TOKEN('S2', fnd_date.date_to_displayDT(gmf_legal_entity_tz.convert_srv_to_le(g_legal_entity_id, l_gl_per_real_start_date), 'FND_NO_CONVERT'));

909: AND l_gl_per_real_start_date IS NOT NULL)
910: THEN
911: FND_MESSAGE.SET_NAME('GMF','GMF_INVALID_DATE_FOR_PERIOD');
912: FND_MESSAGE.SET_TOKEN('S1', fnd_date.date_to_displayDT(gmf_legal_entity_tz.convert_srv_to_le(g_legal_entity_id, l_posting_start_date), 'FND_NO_CONVERT'));
913: FND_MESSAGE.SET_TOKEN('S2', fnd_date.date_to_displayDT(gmf_legal_entity_tz.convert_srv_to_le(g_legal_entity_id, l_gl_per_real_start_date), 'FND_NO_CONVERT'));
914: FND_MESSAGE.SET_TOKEN('S3', fnd_date.date_to_displayDT(gmf_legal_entity_tz.convert_srv_to_le(g_legal_entity_id, l_gl_per_real_end_date), 'FND_NO_CONVERT'));
915: x_errbuf := fnd_message.get;
916: RAISE e_invalid_parameter;
917: END IF;

Line 914: FND_MESSAGE.SET_TOKEN('S3', fnd_date.date_to_displayDT(gmf_legal_entity_tz.convert_srv_to_le(g_legal_entity_id, l_gl_per_real_end_date), 'FND_NO_CONVERT'));

910: THEN
911: FND_MESSAGE.SET_NAME('GMF','GMF_INVALID_DATE_FOR_PERIOD');
912: FND_MESSAGE.SET_TOKEN('S1', fnd_date.date_to_displayDT(gmf_legal_entity_tz.convert_srv_to_le(g_legal_entity_id, l_posting_start_date), 'FND_NO_CONVERT'));
913: FND_MESSAGE.SET_TOKEN('S2', fnd_date.date_to_displayDT(gmf_legal_entity_tz.convert_srv_to_le(g_legal_entity_id, l_gl_per_real_start_date), 'FND_NO_CONVERT'));
914: FND_MESSAGE.SET_TOKEN('S3', fnd_date.date_to_displayDT(gmf_legal_entity_tz.convert_srv_to_le(g_legal_entity_id, l_gl_per_real_end_date), 'FND_NO_CONVERT'));
915: x_errbuf := fnd_message.get;
916: RAISE e_invalid_parameter;
917: END IF;
918:

Line 923: FND_MESSAGE.SET_TOKEN('S1', fnd_date.date_to_displayDT(gmf_legal_entity_tz.convert_srv_to_le(g_legal_entity_id, l_posting_end_date), 'FND_NO_CONVERT'));

919: IF (l_posting_end_date > l_gl_per_real_end_date /* Bug#5623121 ANTHIYAG 30-Oct-2006 */
920: AND l_gl_per_real_end_date IS NOT NULL)
921: THEN
922: FND_MESSAGE.SET_NAME('GMF','GMF_INVALID_DATE_FOR_PERIOD');
923: FND_MESSAGE.SET_TOKEN('S1', fnd_date.date_to_displayDT(gmf_legal_entity_tz.convert_srv_to_le(g_legal_entity_id, l_posting_end_date), 'FND_NO_CONVERT'));
924: FND_MESSAGE.SET_TOKEN('S2', fnd_date.date_to_displayDT(gmf_legal_entity_tz.convert_srv_to_le(g_legal_entity_id, l_gl_per_real_start_date), 'FND_NO_CONVERT'));
925: FND_MESSAGE.SET_TOKEN('S3', fnd_date.date_to_displayDT(gmf_legal_entity_tz.convert_srv_to_le(g_legal_entity_id, l_gl_per_real_end_date), 'FND_NO_CONVERT'));
926: x_errbuf := fnd_message.get;
927: RAISE e_invalid_parameter;

Line 924: FND_MESSAGE.SET_TOKEN('S2', fnd_date.date_to_displayDT(gmf_legal_entity_tz.convert_srv_to_le(g_legal_entity_id, l_gl_per_real_start_date), 'FND_NO_CONVERT'));

920: AND l_gl_per_real_end_date IS NOT NULL)
921: THEN
922: FND_MESSAGE.SET_NAME('GMF','GMF_INVALID_DATE_FOR_PERIOD');
923: FND_MESSAGE.SET_TOKEN('S1', fnd_date.date_to_displayDT(gmf_legal_entity_tz.convert_srv_to_le(g_legal_entity_id, l_posting_end_date), 'FND_NO_CONVERT'));
924: FND_MESSAGE.SET_TOKEN('S2', fnd_date.date_to_displayDT(gmf_legal_entity_tz.convert_srv_to_le(g_legal_entity_id, l_gl_per_real_start_date), 'FND_NO_CONVERT'));
925: FND_MESSAGE.SET_TOKEN('S3', fnd_date.date_to_displayDT(gmf_legal_entity_tz.convert_srv_to_le(g_legal_entity_id, l_gl_per_real_end_date), 'FND_NO_CONVERT'));
926: x_errbuf := fnd_message.get;
927: RAISE e_invalid_parameter;
928: END IF;

Line 925: FND_MESSAGE.SET_TOKEN('S3', fnd_date.date_to_displayDT(gmf_legal_entity_tz.convert_srv_to_le(g_legal_entity_id, l_gl_per_real_end_date), 'FND_NO_CONVERT'));

921: THEN
922: FND_MESSAGE.SET_NAME('GMF','GMF_INVALID_DATE_FOR_PERIOD');
923: FND_MESSAGE.SET_TOKEN('S1', fnd_date.date_to_displayDT(gmf_legal_entity_tz.convert_srv_to_le(g_legal_entity_id, l_posting_end_date), 'FND_NO_CONVERT'));
924: FND_MESSAGE.SET_TOKEN('S2', fnd_date.date_to_displayDT(gmf_legal_entity_tz.convert_srv_to_le(g_legal_entity_id, l_gl_per_real_start_date), 'FND_NO_CONVERT'));
925: FND_MESSAGE.SET_TOKEN('S3', fnd_date.date_to_displayDT(gmf_legal_entity_tz.convert_srv_to_le(g_legal_entity_id, l_gl_per_real_end_date), 'FND_NO_CONVERT'));
926: x_errbuf := fnd_message.get;
927: RAISE e_invalid_parameter;
928: END IF;
929:

Line 1323: FND_DATE.date_to_canonical(SYSDATE), /* scheduled_on - always sysdate */

1319: p_gl_period, /* period */
1320: p_posting_start_date, /* period_start_date */
1321: p_posting_end_date, /* period_end_date */
1322: DECODE(p_test_posting,'N',0,1),
1323: FND_DATE.date_to_canonical(SYSDATE), /* scheduled_on - always sysdate */
1324: NULL, /* aborted_by */
1325: 0, /* update_stage */
1326: 0, /* errors_found */
1327: 0, /* errors_posted */

Line 1763: fnd_message.set_token('START_DATE', fnd_date.date_to_displayDT(gmf_legal_entity_tz.convert_srv_to_le(g_legal_entity_id, p_period_start_date), 'FND_NO_CONVERT')); /* Bug#5623121 ANTHIYAG 30-Oct-2006 */

1759: THEN
1760: IF (gmf_legal_entity_tz.convert_le_to_srv_tz(g_crev_gl_trans_date, g_legal_entity_id) NOT BETWEEN p_period_start_date and p_period_end_date) /* Bug#5623121 ANTHIYAG 30-Oct-2006 */
1761: THEN
1762: fnd_message.set_name('GMF','GMF_GL_DATE_MUST_WITHIN_PERIOD');
1763: fnd_message.set_token('START_DATE', fnd_date.date_to_displayDT(gmf_legal_entity_tz.convert_srv_to_le(g_legal_entity_id, p_period_start_date), 'FND_NO_CONVERT')); /* Bug#5623121 ANTHIYAG 30-Oct-2006 */
1764: fnd_message.set_token('END_DATE',fnd_date.date_to_displayDT(gmf_legal_entity_tz.convert_srv_to_le(g_legal_entity_id, p_period_end_date), 'FND_NO_CONVERT')); /* Bug#5623121 ANTHIYAG 30-Oct-2006 */
1765: x_errbuf := fnd_message.get;
1766: RAISE e_reval_error;
1767: ELSE

Line 1764: fnd_message.set_token('END_DATE',fnd_date.date_to_displayDT(gmf_legal_entity_tz.convert_srv_to_le(g_legal_entity_id, p_period_end_date), 'FND_NO_CONVERT')); /* Bug#5623121 ANTHIYAG 30-Oct-2006 */

1760: IF (gmf_legal_entity_tz.convert_le_to_srv_tz(g_crev_gl_trans_date, g_legal_entity_id) NOT BETWEEN p_period_start_date and p_period_end_date) /* Bug#5623121 ANTHIYAG 30-Oct-2006 */
1761: THEN
1762: fnd_message.set_name('GMF','GMF_GL_DATE_MUST_WITHIN_PERIOD');
1763: fnd_message.set_token('START_DATE', fnd_date.date_to_displayDT(gmf_legal_entity_tz.convert_srv_to_le(g_legal_entity_id, p_period_start_date), 'FND_NO_CONVERT')); /* Bug#5623121 ANTHIYAG 30-Oct-2006 */
1764: fnd_message.set_token('END_DATE',fnd_date.date_to_displayDT(gmf_legal_entity_tz.convert_srv_to_le(g_legal_entity_id, p_period_end_date), 'FND_NO_CONVERT')); /* Bug#5623121 ANTHIYAG 30-Oct-2006 */
1765: x_errbuf := fnd_message.get;
1766: RAISE e_reval_error;
1767: ELSE
1768: x_crev_gl_trans_date := g_crev_gl_trans_date;

Line 2066: -- g_crev_gl_trans_date := FND_DATE.canonical_to_date(p_crev_gl_trans_date);

2062: g_crev_prev_cost_type_id := TO_NUMBER(p_crev_prev_cost_type_id);
2063: g_crev_prev_calendar := p_crev_prev_calendar;
2064: g_crev_prev_period := p_crev_prev_period;
2065:
2066: -- g_crev_gl_trans_date := FND_DATE.canonical_to_date(p_crev_gl_trans_date);
2067: g_crev_gl_trans_date := p_crev_gl_trans_date;
2068:
2069:
2070: IF g_cost_method_type <> 6