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 658: l_log boolean := ((FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) and

654: p_wip_entity_id IN NUMBER) -- DEFAULT NULL
655: RETURN VARCHAR2 IS
656:
657: l_module constant varchar2(200) := g_module_name||'.quality_mandatory_plans_remain';
658: l_log boolean := ((FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) and
659: FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module));
660: l_plog boolean := l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL);
661: l_slog boolean := l_plog and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL);
662: l_context_table qa_ss_const.ctx_table;

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

655: RETURN VARCHAR2 IS
656:
657: l_module constant varchar2(200) := g_module_name||'.quality_mandatory_plans_remain';
658: l_log boolean := ((FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) and
659: FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module));
660: l_plog boolean := l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL);
661: l_slog boolean := l_plog and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL);
662: l_context_table qa_ss_const.ctx_table;
663: l_plans_table qa_ss_const.num_table;

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

656:
657: l_module constant varchar2(200) := g_module_name||'.quality_mandatory_plans_remain';
658: l_log boolean := ((FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) and
659: FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module));
660: l_plog boolean := l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL);
661: l_slog boolean := l_plog and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL);
662: l_context_table qa_ss_const.ctx_table;
663: l_plans_table qa_ss_const.num_table;
664: result BOOLEAN;

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

657: l_module constant varchar2(200) := g_module_name||'.quality_mandatory_plans_remain';
658: l_log boolean := ((FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) and
659: FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module));
660: l_plog boolean := l_log and (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL);
661: l_slog boolean := l_plog and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL);
662: l_context_table qa_ss_const.ctx_table;
663: l_plans_table qa_ss_const.num_table;
664: result BOOLEAN;
665: return_value VARCHAR2(1) DEFAULT 'N';

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

668: l_results_entered VARCHAR2(1);
669: l_wip_entity_id NUMBER := p_wip_entity_id;
670: BEGIN
671: --dgupta: Start R12 EAM Integration. Bug 4345492
672: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
673: 'Start of ' || l_module || '(' || 'p_txn_number=' || p_txn_number
674: || ',p_organization_id='|| p_organization_id|| ',pk1='|| pk1|| ',pk2='|| pk2
675: || ',pk3='|| pk3|| ', pk4='|| pk4|| ', pk5='|| pk5 || ', pk6='|| pk6|| ',p_txn_name='|| p_txn_name
676: || ',p_list_of_plans='|| p_list_of_plans || ',p_collection_id='|| p_collection_id

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

683: l_context_table(qa_ss_const.maintenance_op_seq) := pk5;
684: l_context_table(qa_ss_const.asset_instance_number) := pk6;
685: --dgupta: End R12 EAM Integration. Bug 4345492
686:
687: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
688: 'Calling evaluate_triggers');
689: end if;
690: result := evaluate_triggers (
691: p_context_table => l_context_table,

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

694: p_optimize_flag => 1,
695: p_mandatory_flag => 1,
696: p_background_flag => 2,
697: p_plans_table => l_plans_table);
698: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
699: 'evaluate_triggers returned. No. of mandatory plans: '|| l_plans_table.count);
700: end if;
701:
702: i := l_plans_table.FIRST;

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

704: if (l_wip_entity_id is null and l_plans_table.count > 0) then
705: select wip_entity_id into l_wip_entity_id
706: from wip_entities where wip_entity_name = pk4
707: and organization_id = p_organization_id;
708: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
709: 'l_wip_entity_id: '|| l_wip_entity_id);
710: end if;
711: end if;
712: elsif (i > 0) AND ( length(p_list_of_plans) = 2) THEN

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

714: end if;
715: WHILE (i <> l_plans_table.LAST +1) LOOP
716: l_results_entered := 'N';
717: begin
718: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
719: 'l_plans_table('||i||'): ' || l_plans_table(i));
720: end if;
721: if (p_txn_number = 31) then --maintenance work order completion
722: select 'Y' into l_results_entered

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

748: end if;
749: if (l_results_entered is null) then
750: l_results_entered := 'N';
751: end if;
752: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
753: 'l_results_entered('||i||'): ' || l_results_entered);
754: end if;
755: exception
756: when no_data_found then

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

760: RETURN 'Y';
761: END IF;
762: i := l_plans_table.NEXT(i);
763: END LOOP;
764: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
765: 'Exiting ' || l_module
766: || '. No mandatory qa plans remain. Return value: '|| return_value );
767: end if;
768: RETURN return_value;