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

Line 678: l_log boolean := ((FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) and

674: p_wip_entity_id IN NUMBER) -- DEFAULT NULL
675: RETURN VARCHAR2 IS
676:
677: l_module constant varchar2(200) := g_module_name||'.quality_mandatory_plans_remain';
678: l_log boolean := ((FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) and
679: FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module));
680: l_plog boolean := l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL);
681: l_slog boolean := l_plog and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL);
682: l_context_table qa_ss_const.ctx_table;

Line 679: FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module));

675: RETURN VARCHAR2 IS
676:
677: l_module constant varchar2(200) := g_module_name||'.quality_mandatory_plans_remain';
678: l_log boolean := ((FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) and
679: FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module));
680: l_plog boolean := l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL);
681: l_slog boolean := l_plog and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL);
682: l_context_table qa_ss_const.ctx_table;
683: l_plans_table qa_ss_const.num_table;

Line 680: l_plog boolean := l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL);

676:
677: l_module constant varchar2(200) := g_module_name||'.quality_mandatory_plans_remain';
678: l_log boolean := ((FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) and
679: FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module));
680: l_plog boolean := l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL);
681: l_slog boolean := l_plog and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL);
682: l_context_table qa_ss_const.ctx_table;
683: l_plans_table qa_ss_const.num_table;
684: result BOOLEAN;

Line 681: l_slog boolean := l_plog and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL);

677: l_module constant varchar2(200) := g_module_name||'.quality_mandatory_plans_remain';
678: l_log boolean := ((FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) and
679: FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module));
680: l_plog boolean := l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL);
681: l_slog boolean := l_plog and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL);
682: l_context_table qa_ss_const.ctx_table;
683: l_plans_table qa_ss_const.num_table;
684: result BOOLEAN;
685: return_value VARCHAR2(1) DEFAULT 'N';

Line 692: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

688: l_results_entered VARCHAR2(1);
689: l_wip_entity_id NUMBER := p_wip_entity_id;
690: BEGIN
691: --dgupta: Start R12 EAM Integration. Bug 4345492
692: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
693: 'Start of ' || l_module || '(' || 'p_txn_number=' || p_txn_number
694: || ',p_organization_id='|| p_organization_id|| ',pk1='|| pk1|| ',pk2='|| pk2
695: || ',pk3='|| pk3|| ', pk4='|| pk4|| ', pk5='|| pk5 || ', pk6='|| pk6|| ',p_txn_name='|| p_txn_name
696: || ',p_list_of_plans='|| p_list_of_plans || ',p_collection_id='|| p_collection_id

Line 707: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

703: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;
704: l_context_table(qa_ss_const.asset_instance_number) := pk6;
705: --dgupta: End R12 EAM Integration. Bug 4345492
706:
707: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
708: 'Calling evaluate_triggers');
709: end if;
710: result := evaluate_triggers (
711: p_context_table => l_context_table,

Line 718: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

714: p_optimize_flag => 1,
715: p_mandatory_flag => 1,
716: p_background_flag => 2,
717: p_plans_table => l_plans_table);
718: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
719: 'evaluate_triggers returned. No. of mandatory plans: '|| l_plans_table.count);
720: end if;
721:
722: i := l_plans_table.FIRST;

Line 728: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

724: if (l_wip_entity_id is null and l_plans_table.count > 0) then
725: select wip_entity_id into l_wip_entity_id
726: from wip_entities where wip_entity_name = pk4
727: and organization_id = p_organization_id;
728: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
729: 'l_wip_entity_id: '|| l_wip_entity_id);
730: end if;
731: end if;
732: elsif (i > 0) AND ( length(p_list_of_plans) = 2) THEN

Line 738: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

734: end if;
735: WHILE (i <> l_plans_table.LAST +1) LOOP
736: l_results_entered := 'N';
737: begin
738: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
739: 'l_plans_table('||i||'): ' || l_plans_table(i));
740: end if;
741: --
742: -- Bug 7685429

Line 779: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

775: end if;
776: if (l_results_entered is null) then
777: l_results_entered := 'N';
778: end if;
779: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
780: 'l_results_entered('||i||'): ' || l_results_entered);
781: end if;
782: exception
783: when no_data_found then

Line 791: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

787: RETURN 'Y';
788: END IF;
789: i := l_plans_table.NEXT(i);
790: END LOOP;
791: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
792: 'Exiting ' || l_module
793: || '. No mandatory qa plans remain. Return value: '|| return_value );
794: end if;
795: RETURN return_value;