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 28: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

24: * - messages using msg dict.
25: *
26: ******************************************************************************/
27:
28: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
29: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
30: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
31: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
32: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

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

25: *
26: ******************************************************************************/
27:
28: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
29: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
30: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
31: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
32: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
33: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

26: ******************************************************************************/
27:
28: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
29: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
30: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
31: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
32: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
33: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
34: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

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

27:
28: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
29: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
30: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
31: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
32: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
33: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
34: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
35: G_MODULE_NAME CONSTANT VARCHAR2(50) :='GMF.PLSQL.GMF_SUBLEDGER_PKG.';

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

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

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

29: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
30: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
31: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
32: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
33: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
34: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
35: G_MODULE_NAME CONSTANT VARCHAR2(50) :='GMF.PLSQL.GMF_SUBLEDGER_PKG.';
36:
37: g_log_msg FND_LOG_MESSAGES.message_text%TYPE;

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

30: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
31: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
32: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
33: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
34: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
35: G_MODULE_NAME CONSTANT VARCHAR2(50) :='GMF.PLSQL.GMF_SUBLEDGER_PKG.';
36:
37: g_log_msg FND_LOG_MESSAGES.message_text%TYPE;
38:

Line 37: g_log_msg FND_LOG_MESSAGES.message_text%TYPE;

33: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
34: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
35: G_MODULE_NAME CONSTANT VARCHAR2(50) :='GMF.PLSQL.GMF_SUBLEDGER_PKG.';
36:
37: g_log_msg FND_LOG_MESSAGES.message_text%TYPE;
38:
39: g_legal_entity_id NUMBER;
40: g_legal_entity_name VARCHAR2(250);
41: g_ledger_id NUMBER;

Line 202: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

198: l_procedure_name CONSTANT VARCHAR2(30) := 'UPDATE_PROCESS';
199:
200: BEGIN
201:
202: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
203:
204: g_log_msg := 'Begin of procedure '|| l_procedure_name;
205:
206: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )

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

204: g_log_msg := 'Begin of procedure '|| l_procedure_name;
205:
206: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
207: THEN
208: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
209: END IF;
210:
211:
212: l_req_data := FND_CONC_GLOBAL.REQUEST_DATA;

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

259: --
260: g_log_msg := l_procedure_name || ': Populate Global variables';
261: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
262: THEN
263: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
264: END IF;
265:
266: g_legal_entity_id := TO_NUMBER(p_legal_entity_id);
267: g_ledger_id := TO_NUMBER(p_ledger_id);

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

292: EXCEPTION
293: WHEN NO_DATA_FOUND then
294: g_log_msg := l_procedure_name || ': No data found in gmf_legal_entities query';
295: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
296: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
297: END IF;
298: RAISE;
299: END;
300: BEGIN

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

305: EXCEPTION
306: WHEN NO_DATA_FOUND then
307: g_log_msg := l_procedure_name || ': No data found in gl_ledgers query';
308: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
309: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
310: END IF;
311: RAISE;
312: END;
313: BEGIN

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

327: EXCEPTION
328: WHEN NO_DATA_FOUND then
329: g_log_msg := l_procedure_name || ': No data found in cost types query';
330: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
331: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
332: END IF;
333: RAISE;
334: END;
335: /* Bug#5708175 ANTHIYAG 12-Dec-2006 End */

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

369:
370: g_log_msg := l_procedure_name || ': query cost reval data';
371: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
372: THEN
373: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
374: END IF;
375:
376:
377: SELECT curr.period_id, prev.period_id,

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

427: /* Validate input params */
428: g_log_msg := l_procedure_name || ': calling validate_parameters procedure';
429: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
430: THEN
431: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
432: END IF;
433:
434: validate_parameters(
435: p_gl_fiscal_year => p_gl_fiscal_year,

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

475: /* insert the control record */
476: g_log_msg := l_procedure_name || ': inserting the control record into gl_subr_sta';
477: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
478: THEN
479: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
480: END IF;
481:
482:
483: insert_control_record(

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

529:
530: g_log_msg := l_procedure_name || ': Submitting concurrent request';
531: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
532: THEN
533: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
534: END IF;
535:
536:
537: l_conc_id := FND_REQUEST.SUBMIT_REQUEST(

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

565:
566: g_log_msg := l_procedure_name || ': concurrent request submitted. Reference#: ' || l_subledger_ref_no;
567: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
568: THEN
569: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
570: END IF;
571:
572: /* wait for child request to complete */
573: FND_CONC_GLOBAL.SET_REQ_GLOBALS(

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

584:
585: g_log_msg := l_procedure_name || ': e_req_submit_error: ' || x_errbuf;
586: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
587: THEN
588: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
589: END IF;
590:
591: end_process('ERROR', l_msg_text);
592:

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

595:
596: g_log_msg := 'e_validation_failed: ' || x_errbuf;
597: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
598: THEN
599: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
600: END IF;
601:
602: end_process('ERROR', l_errbuf);
603:

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

606:
607: g_log_msg := 'e_ctlrec_failed: ' || x_errbuf;
608: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
609: THEN
610: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
611: END IF;
612:
613: end_process('ERROR', l_errbuf);
614:

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

617:
618: g_log_msg := 'error: ' || x_errbuf;
619: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
620: THEN
621: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
622: END IF;
623:
624: WHEN others THEN
625: x_retcode := 3;

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

627:
628: g_log_msg := 'in when other. error: ' || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE;
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: end_process('ERROR', x_errbuf);
635: -- TBD RAISE;

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

665: g_log_msg := 'Begin of procedure '|| l_procedure_name;
666:
667: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
668: THEN
669: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
670: END IF;
671:
672: l_retval := fnd_concurrent.set_completion_status(p_errstat,p_errmsg);
673:

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

819: g_log_msg := 'Begin of procedure '|| l_procedure_name;
820:
821: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
822: THEN
823: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
824: END IF;
825:
826: --
827: -- Validating GL Fiscal Year

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

828: --
829: g_log_msg := 'validating GL Fiscal Year';
830: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
831: THEN
832: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
833: END IF;
834:
835:
836: l_gl_fiscal_year := TO_NUMBER(p_gl_fiscal_year);

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

851: --
852: g_log_msg := 'validating GL Period';
853: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
854: THEN
855: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
856: END IF;
857:
858: l_gl_period := TO_NUMBER(p_gl_period);
859:

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

873: --
874: g_log_msg := 'validating date ranges';
875: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
876: THEN
877: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
878: END IF;
879:
880:
881: l_gl_per_real_start_date := gmf_legal_entity_tz.convert_le_to_srv_tz(l_gl_per_start_date, g_legal_entity_id); /* Bug#5623121 ANTHIYAG 30-Oct-2006 */

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

898: --
899: g_log_msg := 'Validating posting dates against GL Period';
900: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
901: THEN
902: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
903: END IF;
904:
905:
906: /* Validate against the periods real start and end dates */

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

932: --
933: g_log_msg := 'verifying the status of gl_period passed in. status: ' || l_gl_period_status;
934: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
935: THEN
936: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
937: END IF;
938:
939:
940: IF( l_gl_period_status NOT IN ('F','N','O') )

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

944: x_errbuf := 'GL Period is closed. Open GL date required' ;
945: g_log_msg := 'error: ' || x_errbuf;
946: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
947: THEN
948: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
949: END IF;
950:
951: RAISE e_invalid_parameter;
952: END IF;

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

962: CLOSE c_gl_period;
963: g_log_msg := 'error: ' || x_errbuf;
964: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
965: THEN
966: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
967: END IF;
968:
969:
970: RAISE e_invalid_parameter;

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

976: x_errbuf := 'Open GL Date not in an Open GL Period' ;
977: g_log_msg := 'error: ' || x_errbuf;
978: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
979: THEN
980: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
981: END IF;
982:
983: RAISE e_invalid_parameter;
984: END IF;

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

1010: THEN
1011: g_log_msg := 'calling check_costing procedure';
1012: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1013: THEN
1014: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1015: END IF;
1016:
1017:
1018: check_costing(

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

1034: g_log_msg := l_procedure_name || ': error returned from check_costing procedure. ' ||
1035: 'error: ' || x_errbuf;
1036: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1037: THEN
1038: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1039: END IF;
1040:
1041:
1042: RAISE e_invalid_parameter;

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

1058:
1059: g_log_msg := 'in when other. error: ' || DBMS_UTILITY.FORMAT_ERROR_BACKTRACE;
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: END validate_parameters;
1065:
1066: /*****************************************************************************

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

1167: g_log_msg := 'Begin of procedure '|| l_procedure_name;
1168:
1169: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1170: THEN
1171: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1172: END IF;
1173:
1174: x_retstatus := 'E';
1175:

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

1183: g_log_msg := 'check for already running or scheduled process for same params';
1184:
1185: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1186: THEN
1187: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1188: END IF;
1189:
1190: open c_sch (g_legal_entity_id, g_ledger_id, g_cost_type_id,
1191: p_gl_fiscal_year, p_gl_period,

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

1210: g_log_msg := 'Getting period_id for LE, CT and dates.';
1211:
1212: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1213: THEN
1214: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1215: END IF;
1216:
1217: BEGIN
1218: SELECT period_id

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

1387: x_errbuf := l_procedure_name || ': failed to insert control record';
1388: g_log_msg := 'failed to insert control record';
1389: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1390: THEN
1391: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1392: END IF;
1393:
1394: RAISE e_insert_error;
1395: END IF;

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

1401: g_log_msg := l_procedure_name || ': ' || sql%rowcount || ' control record inserted into gl_subr_sta table. ' ||
1402: ' end of procedure';
1403: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1404: THEN
1405: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1406: END IF;
1407:
1408:
1409: EXCEPTION

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

1412:
1413: g_log_msg := x_errbuf;
1414: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1415: THEN
1416: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1417: END IF;
1418:
1419: x_retstatus := 'E';
1420:

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

1570: g_log_msg := 'Begin of procedure '|| l_procedure_name;
1571:
1572: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1573: THEN
1574: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1575: END IF;
1576:
1577: x_retstatus := 'E';
1578:

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

1593: --
1594: g_log_msg := 'Check to see if current and prior period are successive';
1595: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1596: THEN
1597: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1598: END IF;
1599:
1600:
1601: OPEN c_stend(g_crev_prev_period_id);

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

1614: --
1615: g_log_msg := 'Now get the start and end date for the cost reval current period';
1616: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1617: THEN
1618: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1619: END IF;
1620:
1621: OPEN c_stend(g_crev_curr_period_id);
1622: FETCH c_stend INTO lc_curr_stend_tmp;

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

1635: */
1636: g_log_msg := 'Check for consecutive periods';
1637: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1638: THEN
1639: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1640: END IF;
1641:
1642:
1643: --

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

1661:
1662: /* Bug#5623121 ANTHIYAG 30-Oct-2006 Start */
1663: g_log_msg := l_procedure_name || ': Getting the inventory period for the Previous costing period';
1664: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1665: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1666: END IF;
1667:
1668: /******************************************************************************************
1669: * Based on LE, Cost type, Period Start and End Dates fetch the Previous costing period id *

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

1704: END;
1705:
1706: g_log_msg := l_procedure_name || ': Inventory Period Year and Number fetched is : ' || x_inv_fiscal_year ||'/'|| x_inv_period;
1707: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1708: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1709: END IF;
1710:
1711: /*************************************************************************************
1712: * Check if atleast premilinary close has been done for the Previous Inventory Period *

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

1717:
1718: IF (NVL (l_close_status, 0) <= 0) THEN
1719: g_log_msg := l_procedure_name || ': Inventory Period Year and Number: ' || x_inv_fiscal_year ||'/'|| x_inv_period || ' is not closed ';
1720: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1721: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1722: END IF;
1723: FND_MESSAGE.SET_NAME ('GMF', 'CM_AC_INVENT_NOT_CL');
1724: x_errbuf := fnd_message.get;
1725: RAISE e_reval_error;

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

1732: --
1733: g_log_msg := l_procedure_name || ': Check current costing period is equivalent to gl yr/prd';
1734: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1735: THEN
1736: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1737: END IF;
1738:
1739: IF( p_period_start_date < lc_curr_stend_tmp.start_date OR
1740: p_period_start_date > lc_curr_stend_tmp.end_date OR

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

1750: g_log_msg := l_procedure_name || ': Checking whether GL Date ' || to_char(g_crev_gl_trans_date, 'DD-MON-YYYY') ||
1751: ' is with data range: ' || to_char(p_period_start_date, 'DD-MON-YYYY') || ' and ' || to_char(p_period_end_date, 'DD-MON-YYYY');
1752: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1753: THEN
1754: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1755: END IF;
1756:
1757: /* Bug 2230751 */
1758: IF (p_closed_period_ind = 0)

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

1781:
1782: g_log_msg := l_procedure_name || ': error: ' || x_errbuf;
1783: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1784: THEN
1785: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1786: END IF;
1787:
1788: END check_costing;
1789:

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

1874: g_log_msg := 'Begin of procedure '|| l_procedure_name;
1875:
1876: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1877: THEN
1878: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1879: END IF;
1880:
1881: x_inv_per_synch := 'N';
1882: x_retstatus := 'E';

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

1946:
1947: g_log_msg := l_procedure_name || ': error: ' || x_errbuf;
1948: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1949: THEN
1950: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1951: END IF;
1952:
1953: END inter_mod_cal_conv;
1954:

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

1973: --
1974: g_log_msg := l_procedure_name || ': Populate Global variables';
1975: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1976: THEN
1977: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
1978: END IF;
1979:
1980: IF p_post_cm = 1
1981: THEN

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

2012: EXCEPTION
2013: WHEN NO_DATA_FOUND then
2014: g_log_msg := l_procedure_name || ': No data found in gmf_legal_entities query';
2015: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2016: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
2017: END IF;
2018: RAISE;
2019: END;
2020: BEGIN

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

2025: EXCEPTION
2026: WHEN NO_DATA_FOUND then
2027: g_log_msg := l_procedure_name || ': No data found in gl_ledgers query';
2028: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2029: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
2030: END IF;
2031: RAISE;
2032: END;
2033: BEGIN

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

2047: EXCEPTION
2048: WHEN NO_DATA_FOUND then
2049: g_log_msg := l_procedure_name || ': No data found in cost types query';
2050: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2051: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
2052: END IF;
2053: RAISE;
2054: END;
2055: /* Bug#5708175 ANTHIYAG 12-Dec-2006 End */

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

2081:
2082: g_log_msg := l_procedure_name || ': query cost reval data';
2083: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
2084: THEN
2085: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
2086: END IF;
2087:
2088:
2089: SELECT curr.period_id, prev.period_id,