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 GMF_LEGAL_ENTITY_TZ

Line 657: l_up_posting_start_date := gmf_legal_entity_tz.convert_le_to_srv_tz(l_up_temp_start_date, g_legal_entity_id);

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:
661: /* Check if date range is less than one hour */

Line 658: l_up_posting_end_date := gmf_legal_entity_tz.convert_le_to_srv_tz(l_up_temp_end_date, g_legal_entity_id);

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:
661: /* Check if date range is less than one hour */
662: IF (

Line 940: -- 13797936 Added gmf_legal_entity_tz call for p_posting_start_date and p_posting_end_date

936: x_retcode := 0;
937: x_errbuf := 'Concurrent request submitted. Reference#: ' || TO_CHAR(l_subledger_ref_no) ;
938: END LOOP;
939: ELSE --} {
940: -- 13797936 Added gmf_legal_entity_tz call for p_posting_start_date and p_posting_end_date
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),

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 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);

1320: THEN
1321: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1322: END IF;
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

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

1322: END IF;
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

Line 1330: l_posting_start_date := gmf_legal_entity_tz.convert_le_to_srv_tz(l_temp_start_date, g_legal_entity_id); -- 13797936

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 */
1334: IF( l_posting_start_date > l_posting_end_date )

Line 1331: l_posting_end_date := gmf_legal_entity_tz.convert_le_to_srv_tz(l_temp_end_date, g_legal_entity_id); -- 13797936

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 */
1334: IF( l_posting_start_date > l_posting_end_date )
1335: THEN

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 2065: AND oap.schedule_close_date = TRUNC(gmf_legal_entity_tz.convert_srv_to_le(g_legal_entity_id,gps.end_date)) -- PK B13797936

2061: AND hoi.org_information_context = 'Accounting Information'
2062: AND hoi.organization_id = oap.organization_id
2063: AND hoi.organization_id = mp.organization_id
2064: AND mp.process_enabled_flag = 'Y'
2065: AND oap.schedule_close_date = TRUNC(gmf_legal_entity_tz.convert_srv_to_le(g_legal_entity_id,gps.end_date)) -- PK B13797936
2066: AND oap.organization_id = gpb.organization_id(+)
2067: AND oap.acct_period_id = gpb.acct_period_id(+);
2068:
2069: l_prior_period_id NUMBER;

Line 2221: AND oap.schedule_close_date = TRUNC(gmf_legal_entity_tz.convert_srv_to_le(g_legal_entity_id,gps.end_date)) -- PK B13797936 V3

2217: AND hoi.org_information1 = gl.ledger_id
2218: AND oap.period_set_name = gl.period_set_name
2219: AND hoi.org_information_context = 'Accounting Information'
2220: AND hoi.organization_id = oap.organization_id
2221: AND oap.schedule_close_date = TRUNC(gmf_legal_entity_tz.convert_srv_to_le(g_legal_entity_id,gps.end_date)) -- PK B13797936 V3
2222: AND ROWNUM = 1;
2223: EXCEPTION
2224: WHEN no_data_found THEN
2225: x_inv_fiscal_year := NULL;

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

2279:
2280: /* Bug 2230751 */
2281: IF (p_closed_period_ind = 0)
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 */

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;