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

Line 306: l_runtime_level NUMBER := fnd_log.g_current_runtime_level;

302: x_xml_request_id OUT NOCOPY NUMBER,
303: x_result_flag OUT NOCOPY VARCHAR2) IS
304:
305: l_procedure_name VARCHAR2(30) := 'Submit_xml_Publisher';
306: l_runtime_level NUMBER := fnd_log.g_current_runtime_level;
307: l_procedure_level NUMBER := fnd_log.level_procedure;
308: --l_statement_level NUMBER := fnd_log.level_statement;
309: --l_exception_level NUMBER := fnd_log.level_exception;
310: l_complete_flag BOOLEAN;

Line 307: l_procedure_level NUMBER := fnd_log.level_procedure;

303: x_result_flag OUT NOCOPY VARCHAR2) IS
304:
305: l_procedure_name VARCHAR2(30) := 'Submit_xml_Publisher';
306: l_runtime_level NUMBER := fnd_log.g_current_runtime_level;
307: l_procedure_level NUMBER := fnd_log.level_procedure;
308: --l_statement_level NUMBER := fnd_log.level_statement;
309: --l_exception_level NUMBER := fnd_log.level_exception;
310: l_complete_flag BOOLEAN;
311: l_phase VARCHAR2(100);

Line 308: --l_statement_level NUMBER := fnd_log.level_statement;

304:
305: l_procedure_name VARCHAR2(30) := 'Submit_xml_Publisher';
306: l_runtime_level NUMBER := fnd_log.g_current_runtime_level;
307: l_procedure_level NUMBER := fnd_log.level_procedure;
308: --l_statement_level NUMBER := fnd_log.level_statement;
309: --l_exception_level NUMBER := fnd_log.level_exception;
310: l_complete_flag BOOLEAN;
311: l_phase VARCHAR2(100);
312: l_status VARCHAR2(100);

Line 309: --l_exception_level NUMBER := fnd_log.level_exception;

305: l_procedure_name VARCHAR2(30) := 'Submit_xml_Publisher';
306: l_runtime_level NUMBER := fnd_log.g_current_runtime_level;
307: l_procedure_level NUMBER := fnd_log.level_procedure;
308: --l_statement_level NUMBER := fnd_log.level_statement;
309: --l_exception_level NUMBER := fnd_log.level_exception;
310: l_complete_flag BOOLEAN;
311: l_phase VARCHAR2(100);
312: l_status VARCHAR2(100);
313: l_del_phase VARCHAR2(100);

Line 320: fnd_log.STRING(l_procedure_level,

316:
317: BEGIN
318: --log for debug
319: IF (l_procedure_level >= l_runtime_level) THEN
320: fnd_log.STRING(l_procedure_level,
321: g_module_name || '.' || l_procedure_name || '.begin',
322: 'begin procedure');
323: END IF; --l_procedure_level >= l_runtime_level
324: -- submit xml publisher concurrent program

Line 365: fnd_log.STRING(l_procedure_level,

361:
362: --log for debug
363: IF (l_procedure_level >= l_runtime_level)
364: THEN
365: fnd_log.STRING(l_procedure_level,
366: g_module_name || '.' || l_procedure_name || '.end',
367: 'end procedure');
368: END IF; --l_procedure_level >= l_runtime_level
369: EXCEPTION

Line 372: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

368: END IF; --l_procedure_level >= l_runtime_level
369: EXCEPTION
370: WHEN OTHERS THEN
371: --log for debug
372: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
373: THEN
374: fnd_log.STRING(fnd_log.level_unexpected,
375: g_module_name || l_procedure_name ||
376: '. OTHER_EXCEPTION ',

Line 374: fnd_log.STRING(fnd_log.level_unexpected,

370: WHEN OTHERS THEN
371: --log for debug
372: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
373: THEN
374: fnd_log.STRING(fnd_log.level_unexpected,
375: g_module_name || l_procedure_name ||
376: '. OTHER_EXCEPTION ',
377: SQLCODE || SQLERRM);
378: END IF; -- fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

Line 378: END IF; -- fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

374: fnd_log.STRING(fnd_log.level_unexpected,
375: g_module_name || l_procedure_name ||
376: '. OTHER_EXCEPTION ',
377: SQLCODE || SQLERRM);
378: END IF; -- fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
379: RAISE;
380: END Submit_xml_Publisher;
381: --==========================================================================
382: -- PROCEDURE NAME:

Line 478: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;

474: p_source_separator IN VARCHAR2
475: ) IS
476:
477: l_procedure_name VARCHAR2(30) := 'Submit_FSG_XML_Report';
478: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
479: l_proc_level NUMBER := FND_LOG.Level_Procedure;
480: --l_stmt_level NUMBER := FND_LOG.Level_Statement;
481: l_fsg_request_id NUMBER;
482: l_xml_request_id NUMBER;

Line 479: l_proc_level NUMBER := FND_LOG.Level_Procedure;

475: ) IS
476:
477: l_procedure_name VARCHAR2(30) := 'Submit_FSG_XML_Report';
478: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
479: l_proc_level NUMBER := FND_LOG.Level_Procedure;
480: --l_stmt_level NUMBER := FND_LOG.Level_Statement;
481: l_fsg_request_id NUMBER;
482: l_xml_request_id NUMBER;
483: l_program VARCHAR2(10);

Line 480: --l_stmt_level NUMBER := FND_LOG.Level_Statement;

476:
477: l_procedure_name VARCHAR2(30) := 'Submit_FSG_XML_Report';
478: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
479: l_proc_level NUMBER := FND_LOG.Level_Procedure;
480: --l_stmt_level NUMBER := FND_LOG.Level_Statement;
481: l_fsg_request_id NUMBER;
482: l_xml_request_id NUMBER;
483: l_program VARCHAR2(10);
484: l_submit_request_exp EXCEPTION;

Line 498: FND_LOG.STRING(l_proc_level,

494: BEGIN
495:
496: --log for debug
497: IF (l_proc_level >= l_dbg_level) THEN
498: FND_LOG.STRING(l_proc_level,
499: g_module_name || '.' || l_procedure_name || '.begin',
500: 'begin procedure');
501: END IF; --( g_proc_level >= g_dbg_level)
502: --call JA_CN_UTILITY.Check_Profile, if it doesn't return true, exit

Line 505: FND_LOG.STRING(l_proc_level,

501: END IF; --( g_proc_level >= g_dbg_level)
502: --call JA_CN_UTILITY.Check_Profile, if it doesn't return true, exit
503: IF JA_CN_UTILITY.Check_Profile() <> TRUE THEN
504: IF (l_proc_level >= l_dbg_level) THEN
505: FND_LOG.STRING(l_proc_level,
506: l_procedure_name,
507: 'Check profile failed!');
508: END IF; --l_exception_level >= l_runtime_level
509: retcode := 1;

Line 607: FND_LOG.STRING(l_proc_level,

603:
604:
605: IF (l_proc_level >= l_dbg_level)
606: THEN
607: FND_LOG.STRING(l_proc_level,
608: g_module_name || '.' || l_procedure_name || '.end',
609: 'end procedure');
610: END IF; --( g_proc_level >= g_dbg_level)
611: EXCEPTION

Line 621: fnd_log.STRING(l_proc_level,

617: SQLERRM);
618: --log for debug
619: IF (l_proc_level >= l_dbg_level)
620: THEN
621: fnd_log.STRING(l_proc_level,
622: g_module_name || '.' || l_procedure_name ||
623: '. Submit_Request_Exception ',
624: SQLCODE || ':' || SQLERRM);
625: END IF; --(l_proc_level >= l_dbg_level)

Line 632: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

628: l_conc_succ := fnd_concurrent.set_completion_status(status => 'ERROR',
629: message => SQLCODE || ':' ||
630: SQLERRM);
631: --log for debug
632: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
633: THEN
634: fnd_log.STRING(fnd_log.level_unexpected,
635: g_module_name || l_procedure_name ||
636: '. OTHER_EXCEPTION ',

Line 634: fnd_log.STRING(fnd_log.level_unexpected,

630: SQLERRM);
631: --log for debug
632: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
633: THEN
634: fnd_log.STRING(fnd_log.level_unexpected,
635: g_module_name || l_procedure_name ||
636: '. OTHER_EXCEPTION ',
637: SQLCODE || SQLERRM);
638: END IF;

Line 721: ln_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;

717: pn_convert_reqid OUT NOCOPY NUMBER
718: ) IS
719:
720: lv_procedure_name VARCHAR2(30) := 'Submit_FSG_XML_Report';
721: ln_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
722: ln_proc_level NUMBER := FND_LOG.Level_Procedure;
723:
724: lv_program VARCHAR2(10);
725: le_submit_request_exp EXCEPTION;

Line 722: ln_proc_level NUMBER := FND_LOG.Level_Procedure;

718: ) IS
719:
720: lv_procedure_name VARCHAR2(30) := 'Submit_FSG_XML_Report';
721: ln_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
722: ln_proc_level NUMBER := FND_LOG.Level_Procedure;
723:
724: lv_program VARCHAR2(10);
725: le_submit_request_exp EXCEPTION;
726: lb_conc_succ BOOLEAN;

Line 786: FND_LOG.STRING(ln_proc_level,

782:
783: BEGIN
784: --log for debug
785: IF (ln_proc_level >= ln_dbg_level) THEN
786: FND_LOG.STRING(ln_proc_level,
787: g_module_name || '.' || lv_procedure_name || '.begin',
788: 'begin procedure');
789: END IF; --( g_proc_level >= g_dbg_level)
790:

Line 797: FND_LOG.STRING(ln_proc_level,

793: --'Asia/Pacific Localizations', 'JG: Territory', which should be
794: --set to 'China' and 'JA: CNAO Legal Entity', which should be NOT NULL.
795: IF JA_CN_UTILITY.Check_Profile() <> TRUE THEN
796: IF (ln_proc_level >= ln_dbg_level) THEN
797: FND_LOG.STRING(ln_proc_level,
798: lv_procedure_name,
799: 'Check profile failed!');
800: END IF; --l_exception_level >= l_runtime_level
801: --retcode := 1;

Line 1618: FND_LOG.STRING(ln_proc_level

1614:
1615: --log for debug
1616: IF (ln_proc_level >= ln_dbg_level)
1617: THEN
1618: FND_LOG.STRING(ln_proc_level
1619: ,g_module_name||'.'||lv_procedure_name
1620: ,lv_error_flag
1621: );
1622: FND_LOG.STRING(ln_proc_level

Line 1622: FND_LOG.STRING(ln_proc_level

1618: FND_LOG.STRING(ln_proc_level
1619: ,g_module_name||'.'||lv_procedure_name
1620: ,lv_error_flag
1621: );
1622: FND_LOG.STRING(ln_proc_level
1623: ,g_module_name||'.'||lv_procedure_name||'.end'
1624: ,'end procedure'
1625: );
1626: END IF;

Line 1632: FND_LOG.STRING(ln_proc_level

1628: EXCEPTION
1629: WHEN OTHERS THEN
1630: IF (ln_proc_level >= ln_dbg_level)
1631: THEN
1632: FND_LOG.STRING(ln_proc_level
1633: ,g_module_name||'.'||lv_procedure_name||'EXCEPTION'
1634: ,lv_error_flag
1635: );
1636: FND_LOG.String(ln_proc_level

Line 1636: FND_LOG.String(ln_proc_level

1632: FND_LOG.STRING(ln_proc_level
1633: ,g_module_name||'.'||lv_procedure_name||'EXCEPTION'
1634: ,lv_error_flag
1635: );
1636: FND_LOG.String(ln_proc_level
1637: ,g_module_name||'.'||lv_procedure_name||'. Other_Exception '
1638: ,SQLCODE||':'||SQLERRM
1639: );
1640: END IF;

Line 1724: ln_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;

1720: pv_xml_output_format IN VARCHAR2
1721: ) IS
1722:
1723: lv_procedure_name VARCHAR2(30) := 'Submit_FSG_XML_Report';
1724: ln_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
1725: ln_proc_level NUMBER := FND_LOG.Level_Procedure;
1726:
1727: lv_program VARCHAR2(10);
1728: le_submit_request_exp EXCEPTION;

Line 1725: ln_proc_level NUMBER := FND_LOG.Level_Procedure;

1721: ) IS
1722:
1723: lv_procedure_name VARCHAR2(30) := 'Submit_FSG_XML_Report';
1724: ln_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
1725: ln_proc_level NUMBER := FND_LOG.Level_Procedure;
1726:
1727: lv_program VARCHAR2(10);
1728: le_submit_request_exp EXCEPTION;
1729: lb_conc_succ BOOLEAN;

Line 1784: FND_LOG.STRING(ln_proc_level,

1780:
1781: BEGIN
1782: --log for debug
1783: IF (ln_proc_level >= ln_dbg_level) THEN
1784: FND_LOG.STRING(ln_proc_level,
1785: g_module_name || '.' || lv_procedure_name || '.begin',
1786: 'begin procedure');
1787: END IF; --( g_proc_level >= g_dbg_level)
1788:

Line 1795: FND_LOG.STRING(ln_proc_level,

1791: --'Asia/Pacific Localizations', 'JG: Territory', which should be
1792: --set to 'China' and 'JA: CNAO Legal Entity', which should be NOT NULL.
1793: IF JA_CN_UTILITY.Check_Profile() <> TRUE THEN
1794: IF (ln_proc_level >= ln_dbg_level) THEN
1795: FND_LOG.STRING(ln_proc_level,
1796: lv_procedure_name,
1797: 'Check profile failed!');
1798: END IF; --l_exception_level >= l_runtime_level
1799: retcode := 1;

Line 2569: FND_LOG.STRING(ln_proc_level

2565:
2566: --log for debug
2567: IF (ln_proc_level >= ln_dbg_level)
2568: THEN
2569: FND_LOG.STRING(ln_proc_level
2570: ,g_module_name||'.'||lv_procedure_name
2571: ,lv_error_flag
2572: );
2573: FND_LOG.STRING(ln_proc_level

Line 2573: FND_LOG.STRING(ln_proc_level

2569: FND_LOG.STRING(ln_proc_level
2570: ,g_module_name||'.'||lv_procedure_name
2571: ,lv_error_flag
2572: );
2573: FND_LOG.STRING(ln_proc_level
2574: ,g_module_name||'.'||lv_procedure_name||'.end'
2575: ,'end procedure'
2576: );
2577: END IF;

Line 2583: FND_LOG.STRING(ln_proc_level

2579: EXCEPTION
2580: WHEN OTHERS THEN
2581: IF (ln_proc_level >= ln_dbg_level)
2582: THEN
2583: FND_LOG.STRING(ln_proc_level
2584: ,g_module_name||'.'||lv_procedure_name||'EXCEPTION'
2585: ,lv_error_flag
2586: );
2587: FND_LOG.String(ln_proc_level

Line 2587: FND_LOG.String(ln_proc_level

2583: FND_LOG.STRING(ln_proc_level
2584: ,g_module_name||'.'||lv_procedure_name||'EXCEPTION'
2585: ,lv_error_flag
2586: );
2587: FND_LOG.String(ln_proc_level
2588: ,g_module_name||'.'||lv_procedure_name||'. Other_Exception '
2589: ,SQLCODE||':'||SQLERRM
2590: );
2591: END IF;