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 496: g_crev_gl_trans_date := FND_DATE.canonical_to_date(p_crev_gl_trans_date);

492: g_crev_prev_cost_type_id := TO_NUMBER(p_crev_prev_cost_type_id);
493: g_crev_prev_calendar := p_crev_prev_calendar;
494: g_crev_prev_period := p_crev_prev_period;
495:
496: g_crev_gl_trans_date := FND_DATE.canonical_to_date(p_crev_gl_trans_date);
497:
498: g_post_txn_cmpt_cost := TO_NUMBER(p_post_txn_cmpt_cost);
499: g_num_of_process := TO_NUMBER(p_num_of_process);
500:

Line 655: l_up_temp_start_date := FND_DATE.canonical_to_date(p_posting_start_date);

651: l_up_post_pur = 1
652: )
653: AND g_num_req > 1
654: ) THEN --{
655: l_up_temp_start_date := FND_DATE.canonical_to_date(p_posting_start_date);
656: l_up_temp_end_date := FND_DATE.canonical_to_date(p_posting_end_date);
657: l_up_posting_start_date := gmf_legal_entity_tz.convert_le_to_srv_tz(l_up_temp_start_date, g_legal_entity_id);
658: l_up_posting_end_date := gmf_legal_entity_tz.convert_le_to_srv_tz(l_up_temp_end_date, g_legal_entity_id);
659: END IF; --}

Line 656: l_up_temp_end_date := FND_DATE.canonical_to_date(p_posting_end_date);

652: )
653: AND g_num_req > 1
654: ) THEN --{
655: l_up_temp_start_date := FND_DATE.canonical_to_date(p_posting_start_date);
656: l_up_temp_end_date := FND_DATE.canonical_to_date(p_posting_end_date);
657: l_up_posting_start_date := gmf_legal_entity_tz.convert_le_to_srv_tz(l_up_temp_start_date, g_legal_entity_id);
658: l_up_posting_end_date := gmf_legal_entity_tz.convert_le_to_srv_tz(l_up_temp_end_date, g_legal_entity_id);
659: END IF; --}
660:

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

727: p_posting_start_date => l_up_posting_start_date,
728: p_posting_end_date => l_up_posting_end_date,
729: p_test_posting => p_test_posting,
730: p_closed_per_ind => l_closed_per_ind,
731: p_open_gl_date => FND_DATE.canonical_to_date(p_open_gl_date),
732: p_crev_gl_trans_date => l_crev_gl_trans_date,
733: p_open_gl_fiscal_year => l_open_gl_fiscal_year,
734: p_open_gl_period => l_open_gl_period,
735: p_post_if_no_cost => p_post_if_no_cost,

Line 761: fnd_date.date_to_canonical(SYSDATE),

757:
758:
759: l_conc_id := FND_REQUEST.SUBMIT_REQUEST(
760: 'GMF','GMFXUPD','OPM Subledger Accounting Pre-Processor',
761: fnd_date.date_to_canonical(SYSDATE),
762: TRUE, '-r',TO_CHAR(l_subledger_ref_no),
763: CHR(0),'','','','','','','','','','','','',
764: '','','','','','','','','','','','','','','',
765: '','','','','','','','','','','','','','','',

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

864: p_posting_start_date => l_req_start_date,
865: p_posting_end_date => l_req_end_date,
866: p_test_posting => p_test_posting,
867: p_closed_per_ind => l_closed_per_ind,
868: p_open_gl_date => FND_DATE.canonical_to_date(p_open_gl_date),
869: p_crev_gl_trans_date => l_crev_gl_trans_date,
870: p_open_gl_fiscal_year => l_open_gl_fiscal_year,
871: p_open_gl_period => l_open_gl_period,
872: p_post_if_no_cost => p_post_if_no_cost,

Line 898: fnd_date.date_to_canonical(SYSDATE),

894:
895:
896: l_conc_id := FND_REQUEST.SUBMIT_REQUEST(
897: 'GMF','GMFXUPD','OPM Subledger Accounting Pre-Processor',
898: fnd_date.date_to_canonical(SYSDATE),
899: TRUE, '-r',TO_CHAR(l_subledger_ref_no),
900: CHR(0),'','','','','','','','','','','','',
901: '','','','','','','','','','','','','','','',
902: '','','','','','','','','','','','','','','',

Line 945: p_posting_start_date => gmf_legal_entity_tz.convert_le_to_srv_tz(FND_DATE.canonical_to_date(p_posting_start_date), g_legal_entity_id),

941: insert_control_record(
942: p_user_id => FND_GLOBAL.user_id,
943: p_gl_fiscal_year => TO_NUMBER(p_gl_fiscal_year),
944: p_gl_period => TO_NUMBER(p_gl_period),
945: p_posting_start_date => gmf_legal_entity_tz.convert_le_to_srv_tz(FND_DATE.canonical_to_date(p_posting_start_date), g_legal_entity_id),
946: p_posting_end_date => gmf_legal_entity_tz.convert_le_to_srv_tz(FND_DATE.canonical_to_date(p_posting_end_date), g_legal_entity_id),
947: p_test_posting => p_test_posting,
948: p_closed_per_ind => l_closed_per_ind,
949: p_open_gl_date => FND_DATE.canonical_to_date(p_open_gl_date),

Line 946: p_posting_end_date => gmf_legal_entity_tz.convert_le_to_srv_tz(FND_DATE.canonical_to_date(p_posting_end_date), g_legal_entity_id),

942: p_user_id => FND_GLOBAL.user_id,
943: p_gl_fiscal_year => TO_NUMBER(p_gl_fiscal_year),
944: p_gl_period => TO_NUMBER(p_gl_period),
945: p_posting_start_date => gmf_legal_entity_tz.convert_le_to_srv_tz(FND_DATE.canonical_to_date(p_posting_start_date), g_legal_entity_id),
946: p_posting_end_date => gmf_legal_entity_tz.convert_le_to_srv_tz(FND_DATE.canonical_to_date(p_posting_end_date), g_legal_entity_id),
947: p_test_posting => p_test_posting,
948: p_closed_per_ind => l_closed_per_ind,
949: p_open_gl_date => FND_DATE.canonical_to_date(p_open_gl_date),
950: p_crev_gl_trans_date => l_crev_gl_trans_date,

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

945: p_posting_start_date => gmf_legal_entity_tz.convert_le_to_srv_tz(FND_DATE.canonical_to_date(p_posting_start_date), g_legal_entity_id),
946: p_posting_end_date => gmf_legal_entity_tz.convert_le_to_srv_tz(FND_DATE.canonical_to_date(p_posting_end_date), g_legal_entity_id),
947: p_test_posting => p_test_posting,
948: p_closed_per_ind => l_closed_per_ind,
949: p_open_gl_date => FND_DATE.canonical_to_date(p_open_gl_date),
950: p_crev_gl_trans_date => l_crev_gl_trans_date,
951: p_open_gl_fiscal_year => l_open_gl_fiscal_year,
952: p_open_gl_period => l_open_gl_period,
953: p_post_if_no_cost => p_post_if_no_cost,

Line 979: fnd_date.date_to_canonical(SYSDATE),

975:
976:
977: l_conc_id := FND_REQUEST.SUBMIT_REQUEST(
978: 'GMF','GMFXUPD','OPM Subledger Accounting Pre-Processor',
979: fnd_date.date_to_canonical(SYSDATE),
980: TRUE, '-r',TO_CHAR(l_subledger_ref_no),
981: CHR(0),'','','','','','','','','','','','',
982: '','','','','','','','','','','','','','','',
983: '','','','','','','','','','','','','','','',

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

1323:
1324: l_gl_per_real_start_date := gmf_legal_entity_tz.convert_le_to_srv_tz(l_gl_per_start_date, g_legal_entity_id);
1325: /* Bug#5623121 ANTHIYAG 30-Oct-2006 */
1326: 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 */
1327: l_open_gl_date := FND_DATE.canonical_to_date(p_open_gl_date);
1328: l_temp_start_date := FND_DATE.canonical_to_date(p_posting_start_date); -- 13797936
1329: l_temp_end_date := FND_DATE.canonical_to_date(p_posting_end_date); -- 13797936
1330: l_posting_start_date := gmf_legal_entity_tz.convert_le_to_srv_tz(l_temp_start_date, g_legal_entity_id); -- 13797936
1331: l_posting_end_date := gmf_legal_entity_tz.convert_le_to_srv_tz(l_temp_end_date, g_legal_entity_id); -- 13797936

Line 1328: l_temp_start_date := FND_DATE.canonical_to_date(p_posting_start_date); -- 13797936

1324: l_gl_per_real_start_date := gmf_legal_entity_tz.convert_le_to_srv_tz(l_gl_per_start_date, g_legal_entity_id);
1325: /* Bug#5623121 ANTHIYAG 30-Oct-2006 */
1326: 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 */
1327: l_open_gl_date := FND_DATE.canonical_to_date(p_open_gl_date);
1328: l_temp_start_date := FND_DATE.canonical_to_date(p_posting_start_date); -- 13797936
1329: l_temp_end_date := FND_DATE.canonical_to_date(p_posting_end_date); -- 13797936
1330: l_posting_start_date := gmf_legal_entity_tz.convert_le_to_srv_tz(l_temp_start_date, g_legal_entity_id); -- 13797936
1331: l_posting_end_date := gmf_legal_entity_tz.convert_le_to_srv_tz(l_temp_end_date, g_legal_entity_id); -- 13797936
1332:

Line 1329: l_temp_end_date := FND_DATE.canonical_to_date(p_posting_end_date); -- 13797936

1325: /* Bug#5623121 ANTHIYAG 30-Oct-2006 */
1326: 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 */
1327: l_open_gl_date := FND_DATE.canonical_to_date(p_open_gl_date);
1328: l_temp_start_date := FND_DATE.canonical_to_date(p_posting_start_date); -- 13797936
1329: l_temp_end_date := FND_DATE.canonical_to_date(p_posting_end_date); -- 13797936
1330: l_posting_start_date := gmf_legal_entity_tz.convert_le_to_srv_tz(l_temp_start_date, g_legal_entity_id); -- 13797936
1331: l_posting_end_date := gmf_legal_entity_tz.convert_le_to_srv_tz(l_temp_end_date, g_legal_entity_id); -- 13797936
1332:
1333: /* Validate if dates are correct */

Line 1357: 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'));

1353: IF (l_posting_start_date < l_gl_per_real_start_date /* Bug#5623121 ANTHIYAG 30-Oct-2006 */
1354: AND l_gl_per_real_start_date IS NOT NULL)
1355: THEN
1356: FND_MESSAGE.SET_NAME('GMF','GMF_INVALID_DATE_FOR_PERIOD');
1357: 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'));
1358: 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'));
1359: 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'));
1360: x_errbuf := fnd_message.get;
1361: RAISE e_invalid_parameter;

Line 1358: 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'));

1354: AND l_gl_per_real_start_date IS NOT NULL)
1355: THEN
1356: FND_MESSAGE.SET_NAME('GMF','GMF_INVALID_DATE_FOR_PERIOD');
1357: 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'));
1358: 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'));
1359: 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'));
1360: x_errbuf := fnd_message.get;
1361: RAISE e_invalid_parameter;
1362: END IF;

Line 1359: 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'));

1355: THEN
1356: FND_MESSAGE.SET_NAME('GMF','GMF_INVALID_DATE_FOR_PERIOD');
1357: 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'));
1358: 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'));
1359: 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'));
1360: x_errbuf := fnd_message.get;
1361: RAISE e_invalid_parameter;
1362: END IF;
1363:

Line 1368: 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'));

1364: IF (l_posting_end_date > l_gl_per_real_end_date /* Bug#5623121 ANTHIYAG 30-Oct-2006 */
1365: AND l_gl_per_real_end_date IS NOT NULL)
1366: THEN
1367: FND_MESSAGE.SET_NAME('GMF','GMF_INVALID_DATE_FOR_PERIOD');
1368: 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'));
1369: 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'));
1370: 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'));
1371: x_errbuf := fnd_message.get;
1372: RAISE e_invalid_parameter;

Line 1369: 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'));

1365: AND l_gl_per_real_end_date IS NOT NULL)
1366: THEN
1367: FND_MESSAGE.SET_NAME('GMF','GMF_INVALID_DATE_FOR_PERIOD');
1368: 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'));
1369: 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'));
1370: 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'));
1371: x_errbuf := fnd_message.get;
1372: RAISE e_invalid_parameter;
1373: END IF;

Line 1370: 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'));

1366: THEN
1367: FND_MESSAGE.SET_NAME('GMF','GMF_INVALID_DATE_FOR_PERIOD');
1368: 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'));
1369: 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'));
1370: 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'));
1371: x_errbuf := fnd_message.get;
1372: RAISE e_invalid_parameter;
1373: END IF;
1374:

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

1831: p_gl_period, /* period */
1832: p_posting_start_date, /* period_start_date */
1833: p_posting_end_date, /* period_end_date */
1834: DECODE(p_test_posting,'N',0,1),
1835: FND_DATE.date_to_canonical(SYSDATE), /* scheduled_on - always sysdate */
1836: NULL, /* aborted_by */
1837: 0, /* update_stage */
1838: 0, /* errors_found */
1839: 0, /* errors_posted */

Line 2286: 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 */

2282: THEN
2283: 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 */
2284: THEN
2285: fnd_message.set_name('GMF','GMF_GL_DATE_MUST_WITHIN_PERIOD');
2286: 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 */
2287: 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 */
2288: x_errbuf := fnd_message.get;
2289: RAISE e_reval_error;
2290: ELSE

Line 2287: 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 */

2283: 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 */
2284: THEN
2285: fnd_message.set_name('GMF','GMF_GL_DATE_MUST_WITHIN_PERIOD');
2286: 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 */
2287: 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 */
2288: x_errbuf := fnd_message.get;
2289: RAISE e_reval_error;
2290: ELSE
2291: x_crev_gl_trans_date := g_crev_gl_trans_date;

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

2585: g_crev_prev_cost_type_id := TO_NUMBER(p_crev_prev_cost_type_id);
2586: g_crev_prev_calendar := p_crev_prev_calendar;
2587: g_crev_prev_period := p_crev_prev_period;
2588:
2589: -- g_crev_gl_trans_date := FND_DATE.canonical_to_date(p_crev_gl_trans_date);
2590: g_crev_gl_trans_date := p_crev_gl_trans_date;
2591:
2592:
2593: IF g_cost_method_type <> 6