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_LOG

Line 33: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

29: * - messages using msg dict.
30: *
31: ******************************************************************************/
32:
33: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
34: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
35: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
36: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
37: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

Line 34: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

30: *
31: ******************************************************************************/
32:
33: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
34: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
35: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
36: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
37: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
38: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 35: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

31: ******************************************************************************/
32:
33: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
34: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
35: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
36: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
37: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
38: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
39: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 36: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

32:
33: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
34: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
35: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
36: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
37: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
38: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
39: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
40: G_MODULE_NAME CONSTANT VARCHAR2(50) :='GMF.PLSQL.GMF_SUBLEDGER_PKG.';

Line 37: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

33: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
34: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
35: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
36: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
37: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
38: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
39: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
40: G_MODULE_NAME CONSTANT VARCHAR2(50) :='GMF.PLSQL.GMF_SUBLEDGER_PKG.';
41:

Line 38: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

34: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
35: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
36: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
37: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
38: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
39: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
40: G_MODULE_NAME CONSTANT VARCHAR2(50) :='GMF.PLSQL.GMF_SUBLEDGER_PKG.';
41:
42: g_log_msg FND_LOG_MESSAGES.message_text%TYPE;

Line 39: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

35: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
36: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
37: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
38: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
39: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
40: G_MODULE_NAME CONSTANT VARCHAR2(50) :='GMF.PLSQL.GMF_SUBLEDGER_PKG.';
41:
42: g_log_msg FND_LOG_MESSAGES.message_text%TYPE;
43:

Line 42: g_log_msg FND_LOG_MESSAGES.message_text%TYPE;

38: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
39: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
40: G_MODULE_NAME CONSTANT VARCHAR2(50) :='GMF.PLSQL.GMF_SUBLEDGER_PKG.';
41:
42: g_log_msg FND_LOG_MESSAGES.message_text%TYPE;
43:
44: g_legal_entity_id NUMBER;
45: g_legal_entity_name VARCHAR2(250);
46: g_ledger_id NUMBER;

Line 351: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

347: /*End for Bug 15954309 Enable parallel procesing */
348:
349: BEGIN
350:
351: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
352:
353: gmf_util.log('Begin of procedure '|| l_procedure_name);
354:
355: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )

Line 357: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

353: gmf_util.log('Begin of procedure '|| l_procedure_name);
354:
355: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
356: THEN
357: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
358: END IF;
359:
360:
361: l_req_data := FND_CONC_GLOBAL.REQUEST_DATA;

Line 412: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

408: --
409: gmf_util.log(l_procedure_name || ': Populate Global variables');
410: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
411: THEN
412: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
413: END IF;
414:
415: g_legal_entity_id := TO_NUMBER(p_legal_entity_id);
416: g_ledger_id := TO_NUMBER(p_ledger_id);

Line 444: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

440: EXCEPTION
441: WHEN NO_DATA_FOUND then
442: gmf_util.log(l_procedure_name || ': No data found in gmf_legal_entities query');
443: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
444: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
445: END IF;
446: RAISE;
447: END;
448: BEGIN

Line 457: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

453: EXCEPTION
454: WHEN NO_DATA_FOUND then
455: gmf_util.log(l_procedure_name || ': No data found in gl_ledgers query');
456: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
457: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
458: END IF;
459: RAISE;
460: END;
461: BEGIN

Line 479: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

475: EXCEPTION
476: WHEN NO_DATA_FOUND then
477: gmf_util.log(l_procedure_name || ': No data found in cost types query');
478: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
479: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
480: END IF;
481: RAISE;
482: END;
483: /* Bug#5708175 ANTHIYAG 12-Dec-2006 End */

Line 523: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

519:
520: gmf_util.log(l_procedure_name || ': query cost reval data');
521: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
522: THEN
523: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
524: END IF;
525:
526:
527: SELECT curr.period_id, prev.period_id,

Line 583: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

579: /* Validate input params */
580: gmf_util.log(l_procedure_name || ': calling validate_parameters procedure');
581: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
582: THEN
583: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
584: END IF;
585:
586: validate_parameters(
587: p_gl_fiscal_year => p_gl_fiscal_year,

Line 631: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

627: /* insert the control record */
628: gmf_util.log(l_procedure_name || ': inserting the control records into gl_subr_sta');
629: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
630: THEN
631: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
632: END IF;
633:
634: /*Bug 15954309 Enable parallel procesing based on number of process parameter */
635: IF (g_process_category = 'INVENTORY_TRANSACTIONS') THEN l_up_post_ic := 1; END IF;

Line 755: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

751:
752: gmf_util.log(l_procedure_name || ': Submitting concurrent request');
753: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
754: THEN
755: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
756: END IF;
757:
758:
759: l_conc_id := FND_REQUEST.SUBMIT_REQUEST(

Line 791: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

787:
788: gmf_util.log(l_procedure_name || ': concurrent request submitted. Reference#: ' || l_subledger_ref_no);
789: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
790: THEN
791: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
792: END IF;
793:
794: /* wait for child request to complete */
795: FND_CONC_GLOBAL.SET_REQ_GLOBALS(

Line 892: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

888:
889: gmf_util.log(l_procedure_name || ': Submitting concurrent request');
890: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
891: THEN
892: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
893: END IF;
894:
895:
896: l_conc_id := FND_REQUEST.SUBMIT_REQUEST(

Line 928: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

924:
925: gmf_util.log(l_procedure_name || ': concurrent request submitted. Reference#: ' || l_subledger_ref_no);
926: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
927: THEN
928: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
929: END IF;
930:
931: /* wait for child request to complete */
932: FND_CONC_GLOBAL.SET_REQ_GLOBALS(

Line 973: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

969:
970: gmf_util.log(l_procedure_name || ': Submitting concurrent request');
971: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
972: THEN
973: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
974: END IF;
975:
976:
977: l_conc_id := FND_REQUEST.SUBMIT_REQUEST(

Line 1009: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

1005:
1006: gmf_util.log(l_procedure_name || ': concurrent request submitted. Reference#: ' || l_subledger_ref_no);
1007: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1008: THEN
1009: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1010: END IF;
1011:
1012: /* wait for child request to complete */
1013: FND_CONC_GLOBAL.SET_REQ_GLOBALS(

Line 1029: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

1025:
1026: gmf_util.log(l_procedure_name || ': e_req_submit_error: ' || x_errbuf);
1027: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1028: THEN
1029: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1030: END IF;
1031:
1032: end_process('ERROR', l_msg_text);
1033:

Line 1040: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

1036:
1037: gmf_util.log('e_validation_failed: ' || x_errbuf);
1038: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1039: THEN
1040: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1041: END IF;
1042:
1043: end_process('ERROR', l_errbuf);
1044:

Line 1051: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

1047:
1048: gmf_util.log('e_ctlrec_failed: ' || x_errbuf);
1049: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1050: THEN
1051: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1052: END IF;
1053:
1054: end_process('ERROR', l_errbuf);
1055:

Line 1062: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

1058:
1059: gmf_util.log('error: ' || x_errbuf);
1060: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1061: THEN
1062: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1063: END IF;
1064:
1065: WHEN others THEN
1066: x_retcode := 3;

Line 1072: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

1068:
1069: gmf_util.log('in when other. error: ' || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1070: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1071: THEN
1072: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1073: END IF;
1074:
1075: end_process('ERROR', x_errbuf);
1076: -- TBD RAISE;

Line 1110: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

1106: gmf_util.log('Begin of procedure '|| l_procedure_name);
1107:
1108: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1109: THEN
1110: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1111: END IF;
1112:
1113: l_retval := fnd_concurrent.set_completion_status(p_errstat,p_errmsg);
1114:

Line 1267: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

1263: gmf_util.log('Begin of procedure '|| l_procedure_name);
1264:
1265: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1266: THEN
1267: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1268: END IF;
1269:
1270: --
1271: -- Validating GL Fiscal Year

Line 1276: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

1272: --
1273: gmf_util.log('validating GL Fiscal Year');
1274: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1275: THEN
1276: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1277: END IF;
1278:
1279:
1280: l_gl_fiscal_year := TO_NUMBER(p_gl_fiscal_year);

Line 1299: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

1295: --
1296: gmf_util.log('validating GL Period');
1297: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1298: THEN
1299: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1300: END IF;
1301:
1302: l_gl_period := TO_NUMBER(p_gl_period);
1303:

Line 1321: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

1317: --
1318: gmf_util.log('validating date ranges');
1319: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
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 */

Line 1347: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

1343: --
1344: gmf_util.log('Validating posting dates against GL Period');
1345: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1346: THEN
1347: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1348: END IF;
1349:
1350:
1351: /* Validate against the periods real start and end dates */

Line 1381: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

1377: --
1378: gmf_util.log('verifying the status of gl_period passed in. status: ' || l_gl_period_status);
1379: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1380: THEN
1381: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1382: END IF;
1383:
1384:
1385: IF( l_gl_period_status NOT IN ('F','N','O') )

Line 1393: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

1389: x_errbuf := 'GL Period is closed. Open GL date required' ;
1390: gmf_util.log('error: ' || x_errbuf);
1391: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1392: THEN
1393: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1394: END IF;
1395:
1396: RAISE e_invalid_parameter;
1397: END IF;

Line 1411: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

1407: CLOSE c_gl_period;
1408: gmf_util.log('error: ' || x_errbuf);
1409: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1410: THEN
1411: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1412: END IF;
1413:
1414:
1415: RAISE e_invalid_parameter;

Line 1425: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

1421: x_errbuf := 'Open GL Date not in an Open GL Period' ;
1422: gmf_util.log('error: ' || x_errbuf);
1423: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1424: THEN
1425: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1426: END IF;
1427:
1428: RAISE e_invalid_parameter;
1429: END IF;

Line 1459: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

1455: THEN
1456: gmf_util.log('calling check_costing procedure');
1457: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1458: THEN
1459: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1460: END IF;
1461:
1462:
1463: check_costing(

Line 1483: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

1479: gmf_util.log(l_procedure_name || ': error returned from check_costing procedure. ' ||
1480: 'error: ' || x_errbuf);
1481: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1482: THEN
1483: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1484: END IF;
1485:
1486:
1487: RAISE e_invalid_parameter;

Line 1507: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

1503:
1504: gmf_util.log('in when other. error: ' || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1505: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1506: THEN
1507: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1508: END IF;
1509: END validate_parameters;
1510:
1511: /*************************************************************************************************

Line 1649: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

1645: gmf_util.log('Begin of procedure '|| l_procedure_name);
1646:
1647: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1648: THEN
1649: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1650: END IF;
1651:
1652: x_retstatus := 'E';
1653:

Line 1669: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

1665: gmf_util.log('check for already running or scheduled process for same params');
1666:
1667: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1668: THEN
1669: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1670: END IF;
1671:
1672: /* Bug 12622793 */
1673: IF (

Line 1717: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

1713: gmf_util.log('Getting period_id for LE, CT and dates.');
1714:
1715: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1716: THEN
1717: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1718: END IF;
1719:
1720: BEGIN
1721: SELECT period_id

Line 1908: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

1904: x_errbuf := l_procedure_name || ': failed to insert control record';
1905: gmf_util.log('failed to insert control record');
1906: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1907: THEN
1908: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1909: END IF;
1910: l_subledger_ref_no := NULL; -- B7203807
1911: RAISE e_insert_error;
1912: END IF;

Line 1922: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

1918: gmf_util.log(l_procedure_name || ': ' || sql%rowcount || ' control record inserted into gl_subr_sta table. ' ||
1919: ' end of procedure');
1920: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1921: THEN
1922: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1923: END IF;
1924:
1925:
1926: EXCEPTION

Line 1933: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

1929:
1930: gmf_util.log(x_errbuf);
1931: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1932: THEN
1933: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1934: END IF;
1935:
1936: x_retstatus := 'E';
1937:

Line 2097: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

2093: gmf_util.log('Begin of procedure '|| l_procedure_name);
2094:
2095: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
2096: THEN
2097: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
2098: END IF;
2099:
2100: x_retstatus := 'E';
2101:

Line 2120: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

2116: --
2117: gmf_util.log('Check to see if current and prior period are successive');
2118: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
2119: THEN
2120: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
2121: END IF;
2122:
2123:
2124: OPEN c_stend(g_crev_prev_period_id);

Line 2141: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

2137: --
2138: gmf_util.log('Now get the start and end date for the cost reval current period');
2139: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
2140: THEN
2141: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
2142: END IF;
2143:
2144: OPEN c_stend(g_crev_curr_period_id);
2145: FETCH c_stend INTO lc_curr_stend_tmp;

Line 2162: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

2158: */
2159: gmf_util.log('Check for consecutive periods');
2160: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
2161: THEN
2162: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
2163: END IF;
2164:
2165:
2166: --

Line 2188: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

2184:
2185: /* Bug#5623121 ANTHIYAG 30-Oct-2006 Start */
2186: gmf_util.log(l_procedure_name || ': Getting the inventory period for the Previous costing period');
2187: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2188: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
2189: END IF;
2190:
2191: /******************************************************************************************
2192: * Based on LE, Cost type, Period Start and End Dates fetch the Previous costing period id *

Line 2231: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

2227: END;
2228:
2229: gmf_util.log(l_procedure_name || ': Inventory Period Year and Number fetched is : ' || x_inv_fiscal_year ||'/'|| x_inv_period);
2230: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2231: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
2232: END IF;
2233:
2234: /*************************************************************************************
2235: * Check if atleast premilinary close has been done for the Previous Inventory Period *

Line 2244: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

2240:
2241: IF (NVL (l_close_status, 0) <= 0) THEN
2242: gmf_util.log(l_procedure_name || ': Inventory Period Year and Number: ' || x_inv_fiscal_year ||'/'|| x_inv_period || ' is not closed ');
2243: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2244: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
2245: END IF;
2246: FND_MESSAGE.SET_NAME ('GMF', 'CM_AC_INVENT_NOT_CL');
2247: x_errbuf := fnd_message.get;
2248: RAISE e_reval_error;

Line 2259: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

2255: --
2256: gmf_util.log(l_procedure_name || ': Check current costing period is equivalent to gl yr/prd');
2257: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
2258: THEN
2259: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
2260: END IF;
2261:
2262: IF( p_period_start_date < lc_curr_stend_tmp.start_date OR
2263: p_period_start_date > lc_curr_stend_tmp.end_date OR

Line 2277: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

2273: gmf_util.log(l_procedure_name || ': Checking whether GL Date ' || to_char(g_crev_gl_trans_date, 'DD-MON-YYYY') ||
2274: ' is with data range: ' || to_char(p_period_start_date, 'DD-MON-YYYY') || ' and ' || to_char(p_period_end_date, 'DD-MON-YYYY'));
2275: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
2276: THEN
2277: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
2278: END IF;
2279:
2280: /* Bug 2230751 */
2281: IF (p_closed_period_ind = 0)

Line 2308: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

2304:
2305: gmf_util.log(l_procedure_name || ': error: ' || x_errbuf);
2306: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
2307: THEN
2308: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
2309: END IF;
2310:
2311: END check_costing;
2312:

Line 2401: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

2397: gmf_util.log('Begin of procedure '|| l_procedure_name);
2398:
2399: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
2400: THEN
2401: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
2402: END IF;
2403:
2404: x_inv_per_synch := 'N';
2405: x_retstatus := 'E';

Line 2473: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

2469:
2470: gmf_util.log(l_procedure_name || ': error: ' || x_errbuf);
2471: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
2472: THEN
2473: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
2474: END IF;
2475:
2476: END inter_mod_cal_conv;
2477:

Line 2500: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

2496: --
2497: gmf_util.log(l_procedure_name || ': Populate Global variables');
2498: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
2499: THEN
2500: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
2501: END IF;
2502:
2503: IF p_post_cm = 1
2504: THEN

Line 2539: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

2535: EXCEPTION
2536: WHEN NO_DATA_FOUND then
2537: gmf_util.log(l_procedure_name || ': No data found in gmf_legal_entities query');
2538: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2539: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
2540: END IF;
2541: RAISE;
2542: END;
2543: BEGIN

Line 2552: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

2548: EXCEPTION
2549: WHEN NO_DATA_FOUND then
2550: gmf_util.log(l_procedure_name || ': No data found in gl_ledgers query');
2551: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2552: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
2553: END IF;
2554: RAISE;
2555: END;
2556: BEGIN

Line 2574: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

2570: EXCEPTION
2571: WHEN NO_DATA_FOUND then
2572: gmf_util.log(l_procedure_name || ': No data found in cost types query');
2573: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2574: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
2575: END IF;
2576: RAISE;
2577: END;
2578: /* Bug#5708175 ANTHIYAG 12-Dec-2006 End */

Line 2608: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);

2604:
2605: gmf_util.log(l_procedure_name || ': query cost reval data');
2606: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
2607: THEN
2608: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
2609: END IF;
2610:
2611:
2612: SELECT curr.period_id, prev.period_id,