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.GCS_XML_DT_UTILITY_PKG dependencies on FND_LOG

Line 56: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

52:
53:
54: BEGIN
55:
56: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
57: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, '<>');
58: END IF;
59:
60: -- Bugfix 5843592, Get the correct source ledger Id, depending upon the calendar period

Line 57: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, '<>');

53:
54: BEGIN
55:
56: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
57: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, '<>');
58: END IF;
59:
60: -- Bugfix 5843592, Get the correct source ledger Id, depending upon the calendar period
61:

Line 92: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

88: AND ftcp.column_property_code = 'PROCESSING_KEY'
89: AND ftcp.table_name = ftcb.table_name
90: AND gvcd.global_vs_combo_id = fla.dim_attribute_numeric_member;
91:
92: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
93: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Dimension Value Set retrieved in the collection');
94: END IF;
95:
96: IF (l_dimension_vs_id.FIRST IS NOT NULL AND l_dimension_vs_id.LAST IS NOT NULL) THEN

Line 93: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Dimension Value Set retrieved in the collection');

89: AND ftcp.table_name = ftcb.table_name
90: AND gvcd.global_vs_combo_id = fla.dim_attribute_numeric_member;
91:
92: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
93: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Dimension Value Set retrieved in the collection');
94: END IF;
95:
96: IF (l_dimension_vs_id.FIRST IS NOT NULL AND l_dimension_vs_id.LAST IS NOT NULL) THEN
97:

Line 100: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

96: IF (l_dimension_vs_id.FIRST IS NOT NULL AND l_dimension_vs_id.LAST IS NOT NULL) THEN
97:
98: FOR l_counter IN l_dimension_vs_id.FIRST..l_dimension_vs_id.LAST LOOP
99:
100: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
101: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Adding value set clause for dimension-id :' || l_dimension_vs_id(l_counter).dimension_id);
102: END IF;
103:
104: IF (l_dimension_vs_id(l_counter).dimension_id = 8) THEN

Line 101: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Adding value set clause for dimension-id :' || l_dimension_vs_id(l_counter).dimension_id);

97:
98: FOR l_counter IN l_dimension_vs_id.FIRST..l_dimension_vs_id.LAST LOOP
99:
100: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
101: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Adding value set clause for dimension-id :' || l_dimension_vs_id(l_counter).dimension_id);
102: END IF;
103:
104: IF (l_dimension_vs_id(l_counter).dimension_id = 8) THEN
105:

Line 216: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

212:
213: END LOOP;
214: END IF;
215:
216: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
217: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, '<>');
218: END IF;
219:
220: END;

Line 217: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, '<>');

213: END LOOP;
214: END IF;
215:
216: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
217: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, '<>');
218: END IF;
219:
220: END;
221:

Line 259: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

255: AND NVL(gcr.end_date,fcpa.date_assign_value);
256:
257:
258: BEGIN
259: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
260: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.begin', '<>');
261: END IF;
262:
263: -- Prepare parent entity and it's children in comma delimited list

Line 260: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.begin', '<>');

256:
257:
258: BEGIN
259: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
260: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.begin', '<>');
261: END IF;
262:
263: -- Prepare parent entity and it's children in comma delimited list
264: -- which would be used by IN clause of data template query

Line 271: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

267: entityIdListLiteral := entityIdListLiteral ||','|| temp.child_entity_id;
268: END LOOP;
269: entityIdListLiteral := entityIdListLiteral ||') ';
270:
271: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
272: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'entityIdListLiteral : ' || entityIdListLiteral);
273: END IF;
274:
275: -- insert into temp_cmtb values (entityIdListLiteral);

Line 272: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'entityIdListLiteral : ' || entityIdListLiteral);

268: END LOOP;
269: entityIdListLiteral := entityIdListLiteral ||') ';
270:
271: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
272: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'entityIdListLiteral : ' || entityIdListLiteral);
273: END IF;
274:
275: -- insert into temp_cmtb values (entityIdListLiteral);
276: -- commit;

Line 277: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

273: END IF;
274:
275: -- insert into temp_cmtb values (entityIdListLiteral);
276: -- commit;
277: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
278: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.end', '<>');
279: END IF;
280:
281: RETURN(TRUE);

Line 278: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.end', '<>');

274:
275: -- insert into temp_cmtb values (entityIdListLiteral);
276: -- commit;
277: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
278: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.end', '<>');
279: END IF;
280:
281: RETURN(TRUE);
282:

Line 287: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN

283: EXCEPTION
284: WHEN OTHERS THEN
285: BEGIN
286: -- Write appropriate error log information
287: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
288: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, g_pkg_name || '.' || l_api_name, substr(SQLERRM, 1, 200) || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
289: END IF; RETURN(FALSE);
290: END;
291:

Line 288: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, g_pkg_name || '.' || l_api_name, substr(SQLERRM, 1, 200) || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

284: WHEN OTHERS THEN
285: BEGIN
286: -- Write appropriate error log information
287: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
288: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, g_pkg_name || '.' || l_api_name, substr(SQLERRM, 1, 200) || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
289: END IF; RETURN(FALSE);
290: END;
291:
292: END before_cmtb_report;

Line 325: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

321: .version_id;
322:
323:
324: BEGIN
325: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
326: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.begin', '<>');
327: END IF;
328: -- Retrieve information to construct appropriate literals
329: -- used by data template to avoid unnecessary decodes

Line 326: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.begin', '<>');

322:
323:
324: BEGIN
325: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
326: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.begin', '<>');
327: END IF;
328: -- Retrieve information to construct appropriate literals
329: -- used by data template to avoid unnecessary decodes
330: -- Since decodes are making index unutilized and impacting performance

Line 362: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

358: AND fla_comp.ledger_id = gea.ledger_id
359: AND fla_comp.attribute_id = pLedgerCurrAttr
360: AND fla_comp.version_id = pLedgerCurrVersion ;
361:
362: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
363: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Load Id : ' || pXmlFileId );
364: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Source System Code : ' || l_source_system_code);
365: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Balance Type Code : ' || l_balance_type_code);
366: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Currency Type Code : ' || l_currency_type_code);

Line 363: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Load Id : ' || pXmlFileId );

359: AND fla_comp.attribute_id = pLedgerCurrAttr
360: AND fla_comp.version_id = pLedgerCurrVersion ;
361:
362: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
363: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Load Id : ' || pXmlFileId );
364: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Source System Code : ' || l_source_system_code);
365: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Balance Type Code : ' || l_balance_type_code);
366: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Currency Type Code : ' || l_currency_type_code);
367: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Currency Code : ' || l_currency_code);

Line 364: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Source System Code : ' || l_source_system_code);

360: AND fla_comp.version_id = pLedgerCurrVersion ;
361:
362: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
363: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Load Id : ' || pXmlFileId );
364: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Source System Code : ' || l_source_system_code);
365: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Balance Type Code : ' || l_balance_type_code);
366: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Currency Type Code : ' || l_currency_type_code);
367: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Currency Code : ' || l_currency_code);
368: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Entity Currency Code : ' || l_entity_currency_code);

Line 365: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Balance Type Code : ' || l_balance_type_code);

361:
362: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
363: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Load Id : ' || pXmlFileId );
364: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Source System Code : ' || l_source_system_code);
365: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Balance Type Code : ' || l_balance_type_code);
366: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Currency Type Code : ' || l_currency_type_code);
367: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Currency Code : ' || l_currency_code);
368: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Entity Currency Code : ' || l_entity_currency_code);
369: END IF;

Line 366: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Currency Type Code : ' || l_currency_type_code);

362: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
363: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Load Id : ' || pXmlFileId );
364: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Source System Code : ' || l_source_system_code);
365: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Balance Type Code : ' || l_balance_type_code);
366: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Currency Type Code : ' || l_currency_type_code);
367: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Currency Code : ' || l_currency_code);
368: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Entity Currency Code : ' || l_entity_currency_code);
369: END IF;
370:

Line 367: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Currency Code : ' || l_currency_code);

363: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Load Id : ' || pXmlFileId );
364: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Source System Code : ' || l_source_system_code);
365: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Balance Type Code : ' || l_balance_type_code);
366: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Currency Type Code : ' || l_currency_type_code);
367: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Currency Code : ' || l_currency_code);
368: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Entity Currency Code : ' || l_entity_currency_code);
369: END IF;
370:
371: currencyLiteral := ' ';

Line 368: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Entity Currency Code : ' || l_entity_currency_code);

364: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Source System Code : ' || l_source_system_code);
365: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Balance Type Code : ' || l_balance_type_code);
366: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Currency Type Code : ' || l_currency_type_code);
367: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Currency Code : ' || l_currency_code);
368: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'Entity Currency Code : ' || l_entity_currency_code);
369: END IF;
370:
371: currencyLiteral := ' ';
372: currencyTypeLiteral := ' ';

Line 398: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

394: ':currency_name currency_name1,';
395:
396: END IF;
397:
398: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
399: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'dsSelectLiteral : ' || dsSelectLiteral);
400: END IF;
401:
402: -- Prepare financial element where clause literal for data template line level query

Line 399: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'dsSelectLiteral : ' || dsSelectLiteral);

395:
396: END IF;
397:
398: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
399: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'dsSelectLiteral : ' || dsSelectLiteral);
400: END IF;
401:
402: -- Prepare financial element where clause literal for data template line level query
403: -- Bug 5066176 :: Santosh

Line 412: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

408: ELSE
409: finElemsLiteral := ' AND NVL(fb.FINANCIAL_ELEM_ID,100) NOT IN (140,10000) ';
410: END IF;
411:
412: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
413: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'finElemsLiteral : ' || finElemsLiteral);
414: END IF;
415:
416: -- Prepare base_currency where clause literal for data template line level query

Line 413: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'finElemsLiteral : ' || finElemsLiteral);

409: finElemsLiteral := ' AND NVL(fb.FINANCIAL_ELEM_ID,100) NOT IN (140,10000) ';
410: END IF;
411:
412: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
413: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'finElemsLiteral : ' || finElemsLiteral);
414: END IF;
415:
416: -- Prepare base_currency where clause literal for data template line level query
417: IF (l_source_system_code <> 10 AND l_currency_type_code = 'BASE_CURRENCY') THEN

Line 423: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

419: ELSE
420: currencyLiteral := ' ';
421: END IF;
422:
423: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
424: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'currencyLiteral : ' || currencyLiteral);
425: END IF;
426:
427: -- Check if this is a mapped (for which org mapping in not required)

Line 424: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'currencyLiteral : ' || currencyLiteral);

420: currencyLiteral := ' ';
421: END IF;
422:
423: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
424: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'currencyLiteral : ' || currencyLiteral);
425: END IF;
426:
427: -- Check if this is a mapped (for which org mapping in not required)
428: -- or unmapped (for which org mapping is required) dstb case

Line 464: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

460: AND gvcd.dimension_id = 8
461: AND fch_gvcd.dimension_id = 8
462: AND gdsd.load_id = pXmlFileId;
463:
464: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
465: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_map_flag : ' || l_map_flag);
466: END IF;
467:
468: -- If OGL dstb case

Line 465: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_map_flag : ' || l_map_flag);

461: AND fch_gvcd.dimension_id = 8
462: AND gdsd.load_id = pXmlFileId;
463:
464: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
465: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_map_flag : ' || l_map_flag);
466: END IF;
467:
468: -- If OGL dstb case
469: IF (l_source_system_code = 10 ) THEN

Line 530: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

526:
527: entityOrgsLiteral := entityOrgsLiteral || l_value_set_clause;
528: --end bug fix 5394468
529:
530: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
531: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'currencyTypeLiteral : ' || currencyTypeLiteral);
532: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'entityOrgsLiteral : ' || entityOrgsLiteral);
533: END IF;
534:

Line 531: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'currencyTypeLiteral : ' || currencyTypeLiteral);

527: entityOrgsLiteral := entityOrgsLiteral || l_value_set_clause;
528: --end bug fix 5394468
529:
530: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
531: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'currencyTypeLiteral : ' || currencyTypeLiteral);
532: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'entityOrgsLiteral : ' || entityOrgsLiteral);
533: END IF;
534:
535: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

Line 532: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'entityOrgsLiteral : ' || entityOrgsLiteral);

528: --end bug fix 5394468
529:
530: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
531: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'currencyTypeLiteral : ' || currencyTypeLiteral);
532: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'entityOrgsLiteral : ' || entityOrgsLiteral);
533: END IF;
534:
535: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
536: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.end', '<>');

Line 535: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

531: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'currencyTypeLiteral : ' || currencyTypeLiteral);
532: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'entityOrgsLiteral : ' || entityOrgsLiteral);
533: END IF;
534:
535: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
536: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.end', '<>');
537: END IF;
538:
539: RETURN(TRUE);

Line 536: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.end', '<>');

532: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'entityOrgsLiteral : ' || entityOrgsLiteral);
533: END IF;
534:
535: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
536: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.end', '<>');
537: END IF;
538:
539: RETURN(TRUE);
540:

Line 546: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN

542: WHEN OTHERS THEN
543: BEGIN
544:
545: -- Write appropriate error log information
546: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
547: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, g_pkg_name || '.' || l_api_name, SUBSTR(SQLERRM, 1, 200) || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
548: END IF;
549: RETURN(FALSE);
550: END;

Line 547: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, g_pkg_name || '.' || l_api_name, SUBSTR(SQLERRM, 1, 200) || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

543: BEGIN
544:
545: -- Write appropriate error log information
546: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
547: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, g_pkg_name || '.' || l_api_name, SUBSTR(SQLERRM, 1, 200) || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
548: END IF;
549: RETURN(FALSE);
550: END;
551:

Line 596: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

592: .version_id;
593:
594: BEGIN
595: --Do initial logging
596: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
597: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.begin', '<>');
598: END IF;
599:
600: /*

Line 597: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.begin', '<>');

593:
594: BEGIN
595: --Do initial logging
596: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
597: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.begin', '<>');
598: END IF;
599:
600: /*
601: From the entity_id, Fetch currency_code and dataset_code.

Line 632: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN

628: AND fla.version_id = gcs_utility_pkg.g_dimension_attr_info('LEDGER_ID-LEDGER_FUNCTIONAL_CRNCY_CODE').version_id
629: AND fda.attribute_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-DATASET_BALANCE_TYPE_CODE').attribute_id
630: AND fda.version_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-DATASET_BALANCE_TYPE_CODE').version_id ;
631:
632: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
633: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_currency_code : '||l_currency_code);
634: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_dataset_code : '||l_dataset_code);
635: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_ledger_id : '||l_ledger_id);
636: END IF;

Line 633: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_currency_code : '||l_currency_code);

629: AND fda.attribute_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-DATASET_BALANCE_TYPE_CODE').attribute_id
630: AND fda.version_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-DATASET_BALANCE_TYPE_CODE').version_id ;
631:
632: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
633: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_currency_code : '||l_currency_code);
634: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_dataset_code : '||l_dataset_code);
635: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_ledger_id : '||l_ledger_id);
636: END IF;
637:

Line 634: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_dataset_code : '||l_dataset_code);

630: AND fda.version_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-DATASET_BALANCE_TYPE_CODE').version_id ;
631:
632: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
633: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_currency_code : '||l_currency_code);
634: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_dataset_code : '||l_dataset_code);
635: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_ledger_id : '||l_ledger_id);
636: END IF;
637:
638: -- Bugfix 5843592, Get the correct source data set code, depending upon the calendar period

Line 635: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_ledger_id : '||l_ledger_id);

631:
632: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
633: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_currency_code : '||l_currency_code);
634: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_dataset_code : '||l_dataset_code);
635: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_ledger_id : '||l_ledger_id);
636: END IF;
637:
638: -- Bugfix 5843592, Get the correct source data set code, depending upon the calendar period
639:

Line 656: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN

652: AND fcpa.version_id = l_period_end_date_version
653: AND fcpa.date_assign_value BETWEEN gea.effective_start_date AND NVL(gea.effective_end_date, fcpa.date_assign_value ) ;
654:
655:
656: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
657: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_source_datasetcode : '||l_source_datasetcode);
658: END IF;
659:
660: /*

Line 657: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_source_datasetcode : '||l_source_datasetcode);

653: AND fcpa.date_assign_value BETWEEN gea.effective_start_date AND NVL(gea.effective_end_date, fcpa.date_assign_value ) ;
654:
655:
656: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
657: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_source_datasetcode : '||l_source_datasetcode);
658: END IF;
659:
660: /*
661: From each dataset code (fem_datasets_attr), you can get the

Line 676: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN

672: WHERE fda.attribute_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-BUDGET_ID').attribute_id
673: AND fda.version_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-BUDGET_ID').version_id
674: AND fda.dataset_code = l_source_datasetcode ; -- datasetcode from previous query
675:
676: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
677: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_budget_vers_id : '||l_budget_vers_id);
678: END IF;
679:
680: END IF;

Line 677: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_budget_vers_id : '||l_budget_vers_id);

673: AND fda.version_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-BUDGET_ID').version_id
674: AND fda.dataset_code = l_source_datasetcode ; -- datasetcode from previous query
675:
676: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
677: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_budget_vers_id : '||l_budget_vers_id);
678: END IF;
679:
680: END IF;
681:

Line 691: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN

687: WHERE fda.attribute_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-ENCUMBRANCE_TYPE_ID').attribute_id
688: AND fda.version_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-ENCUMBRANCE_TYPE_ID').version_id
689: AND fda.dataset_code = l_source_datasetcode ; -- datasetcode from previous query
690:
691: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
692: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_enc_type_id : '||l_enc_type_id);
693: END IF;
694:
695: END IF;

Line 692: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_enc_type_id : '||l_enc_type_id);

688: AND fda.version_id = gcs_utility_pkg.g_dimension_attr_info('DATASET_CODE-ENCUMBRANCE_TYPE_ID').version_id
689: AND fda.dataset_code = l_source_datasetcode ; -- datasetcode from previous query
690:
691: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
692: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_enc_type_id : '||l_enc_type_id);
693: END IF;
694:
695: END IF;
696:

Line 708: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN

704: FROM fem_cal_periods_tl
705: WHERE cal_period_id = pCalPeriodId --obtained from UI parameters
706: AND language = userenv('LANG');
707:
708: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
709: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_cal_period : '||l_cal_period);
710: END IF;
711:
712: /*

Line 709: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_cal_period : '||l_cal_period);

705: WHERE cal_period_id = pCalPeriodId --obtained from UI parameters
706: AND language = userenv('LANG');
707:
708: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
709: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_cal_period : '||l_cal_period);
710: END IF;
711:
712: /*
713: we need to know which column it corresponds to in the GL data table

Line 727: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN

723: AND fsav.application_id = 101
724: AND fsav.id_flex_code = 'GL#'
725: AND gsob.set_of_books_id = l_ledger_id;
726:
727: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
728: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_segment_column : '||l_segment_column);
729: END IF;
730:
731: /* Finally form the literal to return back to the main template*/

Line 728: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_segment_column : '||l_segment_column);

724: AND fsav.id_flex_code = 'GL#'
725: AND gsob.set_of_books_id = l_ledger_id;
726:
727: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
728: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_segment_column : '||l_segment_column);
729: END IF;
730:
731: /* Finally form the literal to return back to the main template*/
732: FilterParamsLiteral := ' AND gbd.LEDGER_ID = ' || l_ledger_id ;

Line 747: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN

743: FilterParamsLiteral := FilterParamsLiteral || ' AND gcc.' ||l_segment_column || ' = fidl.balance_seg_value';
744: FilterParamsLiteral := FilterParamsLiteral || ' AND fidl.ledger_id = ' || l_ledger_id ;
745: FilterParamsLiteral := FilterParamsLiteral || ' AND fidl.dataset_code = ' || l_source_datasetcode ;
746:
747: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
748: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'FilterParamsLiteral : '||FilterParamsLiteral);
749: END IF;
750:
751: --Collect header level Names here

Line 748: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'FilterParamsLiteral : '||FilterParamsLiteral);

744: FilterParamsLiteral := FilterParamsLiteral || ' AND fidl.ledger_id = ' || l_ledger_id ;
745: FilterParamsLiteral := FilterParamsLiteral || ' AND fidl.dataset_code = ' || l_source_datasetcode ;
746:
747: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
748: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'FilterParamsLiteral : '||FilterParamsLiteral);
749: END IF;
750:
751: --Collect header level Names here
752: --LEDGER

Line 758: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN

754: INTO LedgerLiteral
755: FROM fem_ledgers_vl
756: WHERE ledger_id = l_ledger_id;
757:
758: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
759: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'LedgerLiteral : '||LedgerLiteral);
760: END IF;
761:
762: --Decide the Mapped/Unmapped status.

Line 759: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'LedgerLiteral : '||LedgerLiteral);

755: FROM fem_ledgers_vl
756: WHERE ledger_id = l_ledger_id;
757:
758: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
759: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'LedgerLiteral : '||LedgerLiteral);
760: END IF;
761:
762: --Decide the Mapped/Unmapped status.
763:

Line 795: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN

791: AND gvcd.global_vs_combo_id = fla.dim_attribute_numeric_member
792: AND gvcd.dimension_id = 8
793: AND fch_gvcd.dimension_id = 8 ;
794:
795: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
796: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_global_vsid : '||l_global_vsid);
797: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_fch_vsid : '||l_fch_vsid);
798: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_map_flag : '||l_map_flag);
799: END IF;

Line 796: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_global_vsid : '||l_global_vsid);

792: AND gvcd.dimension_id = 8
793: AND fch_gvcd.dimension_id = 8 ;
794:
795: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
796: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_global_vsid : '||l_global_vsid);
797: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_fch_vsid : '||l_fch_vsid);
798: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_map_flag : '||l_map_flag);
799: END IF;
800:

Line 797: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_fch_vsid : '||l_fch_vsid);

793: AND fch_gvcd.dimension_id = 8 ;
794:
795: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
796: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_global_vsid : '||l_global_vsid);
797: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_fch_vsid : '||l_fch_vsid);
798: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_map_flag : '||l_map_flag);
799: END IF;
800:
801: IF (l_map_flag = 'MAPPED') THEN

Line 798: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_map_flag : '||l_map_flag);

794:
795: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
796: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_global_vsid : '||l_global_vsid);
797: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_fch_vsid : '||l_fch_vsid);
798: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_map_flag : '||l_map_flag);
799: END IF;
800:
801: IF (l_map_flag = 'MAPPED') THEN
802: entityOrgsLiteral := ' AND EXISTS (SELECT 1 '||

Line 817: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN

813: WHERE fcpa.attribute_id = l_period_end_date_attr
814: AND fcpa.version_id = l_period_end_date_version
815: AND fcpa.cal_period_id = pCalPeriodId ;
816:
817: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
818: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_cal_pd_end_date : '||l_cal_pd_end_date);
819: END IF;
820:
821: -- Get the object_def_id with care for end date

Line 818: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_cal_pd_end_date : '||l_cal_pd_end_date);

814: AND fcpa.version_id = l_period_end_date_version
815: AND fcpa.cal_period_id = pCalPeriodId ;
816:
817: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
818: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_cal_pd_end_date : '||l_cal_pd_end_date);
819: END IF;
820:
821: -- Get the object_def_id with care for end date
822: SELECT NVL(default_mvs_hierarchy_obj_id,-1)

Line 827: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN

823: INTO l_def_hier_id
824: FROM fem_xdim_dimensions
825: WHERE dimension_id = 8;
826:
827: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
828: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_def_hier_id : '||l_def_hier_id);
829: END IF;
830: --Bugfix 5853090
831: IF(l_def_hier_id IS NULL OR l_def_hier_id = -1) THEN

Line 828: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_def_hier_id : '||l_def_hier_id);

824: FROM fem_xdim_dimensions
825: WHERE dimension_id = 8;
826:
827: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
828: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_def_hier_id : '||l_def_hier_id);
829: END IF;
830: --Bugfix 5853090
831: IF(l_def_hier_id IS NULL OR l_def_hier_id = -1) THEN
832:

Line 843: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN

839: FROM fem_object_definition_b
840: WHERE object_id = l_def_hier_id
841: AND l_cal_pd_end_date BETWEEN effective_start_date AND effective_end_date;
842:
843: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
844: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_her_obj_def_id : '||l_her_obj_def_id);
845: END IF;
846:
847: -- Append the extra filter clause here

Line 844: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_her_obj_def_id : '||l_her_obj_def_id);

840: WHERE object_id = l_def_hier_id
841: AND l_cal_pd_end_date BETWEEN effective_start_date AND effective_end_date;
842:
843: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
844: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_her_obj_def_id : '||l_her_obj_def_id);
845: END IF;
846:
847: -- Append the extra filter clause here
848:

Line 859: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN

855:
856: END IF;
857: END IF;
858:
859: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
860: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'entityOrgsLiteral : '||entityOrgsLiteral);
861: END IF;
862:
863: --Finally return true to show success of the call.

Line 860: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'entityOrgsLiteral : '||entityOrgsLiteral);

856: END IF;
857: END IF;
858:
859: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT THEN
860: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'entityOrgsLiteral : '||entityOrgsLiteral);
861: END IF;
862:
863: --Finally return true to show success of the call.
864: RETURN(TRUE);

Line 869: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN

865: EXCEPTION
866: WHEN OTHERS THEN
867: BEGIN
868: -- Write appropriate error log information
869: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
870: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, g_pkg_name || '.' || l_api_name, SUBSTR(SQLERRM, 1, 200) || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
871: END IF;
872: RETURN(FALSE);
873: END;

Line 870: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, g_pkg_name || '.' || l_api_name, SUBSTR(SQLERRM, 1, 200) || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

866: WHEN OTHERS THEN
867: BEGIN
868: -- Write appropriate error log information
869: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
870: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, g_pkg_name || '.' || l_api_name, SUBSTR(SQLERRM, 1, 200) || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
871: END IF;
872: RETURN(FALSE);
873: END;
874: END before_femnonposted_report;

Line 902: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

898: ORDER BY segment_num;
899: counter NUMBER;
900:
901: BEGIN
902: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
903: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.begin', '<>');
904: END IF;
905:
906: accountName := NULL;

Line 903: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.begin', '<>');

899: counter NUMBER;
900:
901: BEGIN
902: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
903: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.begin', '<>');
904: END IF;
905:
906: accountName := NULL;
907: FOR temp IN c1(pXmlFileId) LOOP

Line 915: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

911: accountName := accountName || '||''-''||' || temp.application_column_name;
912: END IF;
913: END LOOP;
914:
915: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
916: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'accountName : ' || accountName);
917: END IF;
918:
919: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

Line 916: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'accountName : ' || accountName);

912: END IF;
913: END LOOP;
914:
915: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
916: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'accountName : ' || accountName);
917: END IF;
918:
919: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
920: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.end', '<>');

Line 919: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

915: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
916: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'accountName : ' || accountName);
917: END IF;
918:
919: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
920: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.end', '<>');
921: END IF;
922:
923: RETURN(TRUE);

Line 920: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.end', '<>');

916: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'accountName : ' || accountName);
917: END IF;
918:
919: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
920: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.end', '<>');
921: END IF;
922:
923: RETURN(TRUE);
924:

Line 928: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN

924:
925: EXCEPTION WHEN OTHERS THEN
926: BEGIN
927: -- Write appropriate error log information
928: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
929: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, g_pkg_name || '.' || l_api_name, SUBSTR(SQLERRM, 1, 200) || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
930: END IF;
931: RETURN(FALSE);
932: END;

Line 929: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, g_pkg_name || '.' || l_api_name, SUBSTR(SQLERRM, 1, 200) || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

925: EXCEPTION WHEN OTHERS THEN
926: BEGIN
927: -- Write appropriate error log information
928: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
929: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, g_pkg_name || '.' || l_api_name, SUBSTR(SQLERRM, 1, 200) || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
930: END IF;
931: RETURN(FALSE);
932: END;
933:

Line 969: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

965: l_year_to_appy_re GCS_ENTRY_HEADERS.YEAR_TO_APPLY_RE%TYPE;
966: l_view_period FEM_CAL_PERIODS_ATTR.NUMBER_ASSIGN_VALUE%TYPE;
967:
968: BEGIN
969: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
970: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.begin', '<>');
971: END IF;
972:
973: --Bugfix 6610924: The default value of 'addWhereClause' must be blank

Line 970: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.begin', '<>');

966: l_view_period FEM_CAL_PERIODS_ATTR.NUMBER_ASSIGN_VALUE%TYPE;
967:
968: BEGIN
969: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
970: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.begin', '<>');
971: END IF;
972:
973: --Bugfix 6610924: The default value of 'addWhereClause' must be blank
974: addWhereClause := ' ';

Line 986: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

982: OPEN year_to_apply_re_cur(pXmlFileId);
983: FETCH year_to_apply_re_cur INTO l_year_to_appy_re;
984: CLOSE year_to_apply_re_cur;
985:
986: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
987: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_year_to_appy_re : ' || l_year_to_appy_re);
988: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_view_period : ' || l_view_period);
989: END IF;
990:

Line 987: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_year_to_appy_re : ' || l_year_to_appy_re);

983: FETCH year_to_apply_re_cur INTO l_year_to_appy_re;
984: CLOSE year_to_apply_re_cur;
985:
986: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
987: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_year_to_appy_re : ' || l_year_to_appy_re);
988: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_view_period : ' || l_view_period);
989: END IF;
990:
991:

Line 988: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_view_period : ' || l_view_period);

984: CLOSE year_to_apply_re_cur;
985:
986: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
987: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_year_to_appy_re : ' || l_year_to_appy_re);
988: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'l_view_period : ' || l_view_period);
989: END IF;
990:
991:
992: IF (pSourceUI = 'MANUAL' OR pSourceUI = 'ACQ_DISP' OR pSourceUI = 'REPORTING') THEN

Line 1011: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1007: addWhereClause := 'AND gel.line_type_code IN(''BALANCE_SHEET'',''CALCULATED'')';
1008: END IF;
1009: END IF;
1010:
1011: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1012: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'addWhereClause : ' || addWhereClause);
1013: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'addREWhereClause : ' || addREWhereClause);
1014: END IF;
1015:

Line 1012: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'addWhereClause : ' || addWhereClause);

1008: END IF;
1009: END IF;
1010:
1011: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1012: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'addWhereClause : ' || addWhereClause);
1013: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'addREWhereClause : ' || addREWhereClause);
1014: END IF;
1015:
1016: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

Line 1013: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'addREWhereClause : ' || addREWhereClause);

1009: END IF;
1010:
1011: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1012: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'addWhereClause : ' || addWhereClause);
1013: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'addREWhereClause : ' || addREWhereClause);
1014: END IF;
1015:
1016: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1017: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.end', '<>');

Line 1016: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

1012: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'addWhereClause : ' || addWhereClause);
1013: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'addREWhereClause : ' || addREWhereClause);
1014: END IF;
1015:
1016: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1017: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.end', '<>');
1018: END IF;
1019:
1020: RETURN(TRUE);

Line 1017: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.end', '<>');

1013: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT, g_pkg_name || '.' || l_api_name, 'addREWhereClause : ' || addREWhereClause);
1014: END IF;
1015:
1016: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1017: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.end', '<>');
1018: END IF;
1019:
1020: RETURN(TRUE);
1021:

Line 1025: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN

1021:
1022: EXCEPTION WHEN OTHERS THEN
1023: BEGIN
1024: -- Write appropriate error log information
1025: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
1026: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, g_pkg_name || '.' || l_api_name, SUBSTR(SQLERRM, 1, 200) || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1027: END IF;
1028: RETURN(FALSE);
1029: END;

Line 1026: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, g_pkg_name || '.' || l_api_name, SUBSTR(SQLERRM, 1, 200) || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

1022: EXCEPTION WHEN OTHERS THEN
1023: BEGIN
1024: -- Write appropriate error log information
1025: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
1026: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, g_pkg_name || '.' || l_api_name, SUBSTR(SQLERRM, 1, 200) || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1027: END IF;
1028: RETURN(FALSE);
1029: END;
1030: END before_entry_report;

Line 1045: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

1041: FUNCTION intercompany_report RETURN BOOLEAN
1042: IS
1043: l_api_name VARCHAR2 (30) := 'INTERCOMPANY_REPORT';
1044: BEGIN
1045: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1046: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.begin', '<>');
1047: END IF;
1048:
1049: --Checking for the value of the counter entity passed

Line 1046: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.begin', '<>');

1042: IS
1043: l_api_name VARCHAR2 (30) := 'INTERCOMPANY_REPORT';
1044: BEGIN
1045: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1046: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.begin', '<>');
1047: END IF;
1048:
1049: --Checking for the value of the counter entity passed
1050: --If Counter Entity = -1 condition is always true

Line 1081: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

1077: ELSE
1078: suspenseExFlagLiteral := ' ';
1079: END IF;
1080:
1081: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1082: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.' || counterEntityIdLiteral, '<>');
1083: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.' || ruleIdLiteral, '<>');
1084: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.' || suspenseExFlagLiteral, '<>');
1085: END IF;

Line 1082: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.' || counterEntityIdLiteral, '<>');

1078: suspenseExFlagLiteral := ' ';
1079: END IF;
1080:
1081: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1082: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.' || counterEntityIdLiteral, '<>');
1083: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.' || ruleIdLiteral, '<>');
1084: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.' || suspenseExFlagLiteral, '<>');
1085: END IF;
1086:

Line 1083: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.' || ruleIdLiteral, '<>');

1079: END IF;
1080:
1081: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1082: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.' || counterEntityIdLiteral, '<>');
1083: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.' || ruleIdLiteral, '<>');
1084: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.' || suspenseExFlagLiteral, '<>');
1085: END IF;
1086:
1087: RETURN(TRUE);

Line 1084: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.' || suspenseExFlagLiteral, '<>');

1080:
1081: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1082: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.' || counterEntityIdLiteral, '<>');
1083: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.' || ruleIdLiteral, '<>');
1084: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_pkg_name || '.' || l_api_name || '.' || suspenseExFlagLiteral, '<>');
1085: END IF;
1086:
1087: RETURN(TRUE);
1088:

Line 1092: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN

1088:
1089: EXCEPTION WHEN OTHERS THEN
1090: BEGIN
1091: -- Write appropriate error log information
1092: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
1093: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, g_pkg_name || '.' || l_api_name, SUBSTR(SQLERRM, 1, 200) || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1094: END IF;
1095: RETURN(FALSE);
1096: END;

Line 1093: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, g_pkg_name || '.' || l_api_name, SUBSTR(SQLERRM, 1, 200) || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

1089: EXCEPTION WHEN OTHERS THEN
1090: BEGIN
1091: -- Write appropriate error log information
1092: IF FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR THEN
1093: FND_LOG.STRING (FND_LOG.LEVEL_ERROR, g_pkg_name || '.' || l_api_name, SUBSTR(SQLERRM, 1, 200) || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
1094: END IF;
1095: RETURN(FALSE);
1096: END;
1097: END intercompany_report;