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

Line 205: IF ( fnd_log.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

201: AddUserToAdHocRole(p_role, l_name);
202: l_count := l_count + 1;
203: EXCEPTION
204: WHEN OTHERS THEN
205: IF ( fnd_log.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
206: fnd_log.string(fnd_log.level_exception,
207: g_package_name || '.add_user_to_role_from_cur',
208: 'AddUserToAdHocRole failed with error '
209: || sqlerrm);

Line 206: fnd_log.string(fnd_log.level_exception,

202: l_count := l_count + 1;
203: EXCEPTION
204: WHEN OTHERS THEN
205: IF ( fnd_log.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
206: fnd_log.string(fnd_log.level_exception,
207: g_package_name || '.add_user_to_role_from_cur',
208: 'AddUserToAdHocRole failed with error '
209: || sqlerrm);
210: END IF;

Line 214: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

210: END IF;
211: END;
212: END LOOP;
213: CLOSE p_refcur;
214: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
215: fnd_log.string(fnd_log.level_statement,
216: g_log_module || '.add_user_to_role_from_cur',
217: 'count is ' || l_count);
218: END IF;

Line 215: fnd_log.string(fnd_log.level_statement,

211: END;
212: END LOOP;
213: CLOSE p_refcur;
214: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
215: fnd_log.string(fnd_log.level_statement,
216: g_log_module || '.add_user_to_role_from_cur',
217: 'count is ' || l_count);
218: END IF;
219: x_count := l_count;

Line 3313: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3309:
3310: EXCEPTION
3311: WHEN OTHERS THEN
3312: wf_core.context(g_package_name,'notify_bank_aprv_supp_aprv',l_itemtype,l_itemkey);
3313: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3314: FND_LOG.string(fnd_log.level_error, 'pos_spm_wf_pkg1' , 'Call to notify_bank_aprv_supp_aprv failed');
3315: END IF;
3316: END notify_bank_aprv_supp_aprv;
3317: -- notify the supplier that his/her supplier registration is approved

Line 3314: FND_LOG.string(fnd_log.level_error, 'pos_spm_wf_pkg1' , 'Call to notify_bank_aprv_supp_aprv failed');

3310: EXCEPTION
3311: WHEN OTHERS THEN
3312: wf_core.context(g_package_name,'notify_bank_aprv_supp_aprv',l_itemtype,l_itemkey);
3313: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3314: FND_LOG.string(fnd_log.level_error, 'pos_spm_wf_pkg1' , 'Call to notify_bank_aprv_supp_aprv failed');
3315: END IF;
3316: END notify_bank_aprv_supp_aprv;
3317: -- notify the supplier that his/her supplier registration is approved
3318: -- when the user (primary contact) already exists in OID and auto-link of username is enabled

Line 3735: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3731: WHEN OTHERS THEN
3732:
3733: wf_core.context(g_package_name,'bc_recert_workflow',l_itemtype,l_itemkey);
3734:
3735: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3736: FND_LOG.string(fnd_log.level_error, 'pos_spm_wf_pkg1' , 'Call to the workflow process for sending reminder notifications for Business Classification Re-Certification failed.');
3737: END IF;
3738:
3739: END bc_recert_workflow;

Line 3736: FND_LOG.string(fnd_log.level_error, 'pos_spm_wf_pkg1' , 'Call to the workflow process for sending reminder notifications for Business Classification Re-Certification failed.');

3732:
3733: wf_core.context(g_package_name,'bc_recert_workflow',l_itemtype,l_itemkey);
3734:
3735: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3736: FND_LOG.string(fnd_log.level_error, 'pos_spm_wf_pkg1' , 'Call to the workflow process for sending reminder notifications for Business Classification Re-Certification failed.');
3737: END IF;
3738:
3739: END bc_recert_workflow;
3740:

Line 3831: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3827: l_itemkey wf_items.item_key%TYPE;
3828:
3829: BEGIN
3830:
3831: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3832: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'p_document_id ' || p_document_id);
3833: END IF;
3834:
3835: l_itemtype := substr(p_document_id, 1, instr(p_document_id, ':') - 1);

Line 3832: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'p_document_id ' || p_document_id);

3828:
3829: BEGIN
3830:
3831: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3832: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'p_document_id ' || p_document_id);
3833: END IF;
3834:
3835: l_itemtype := substr(p_document_id, 1, instr(p_document_id, ':') - 1);
3836: l_itemkey := substr(p_document_id, instr(p_document_id, ':') + 1, (instr(p_document_id, '#') - instr(p_document_id, ':'))-1 );

Line 3839: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3835: l_itemtype := substr(p_document_id, 1, instr(p_document_id, ':') - 1);
3836: l_itemkey := substr(p_document_id, instr(p_document_id, ':') + 1, (instr(p_document_id, '#') - instr(p_document_id, ':'))-1 );
3837: l_supplier_reg_id := substr(p_document_id, instr(p_document_id, '#') + 1, length(p_document_id));
3838:
3839: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3840: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_item_type ' || l_itemtype);
3841: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_item_key ' || l_itemkey);
3842: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_supplier_reg_id ' || l_supplier_reg_id);
3843: END IF;

Line 3840: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_item_type ' || l_itemtype);

3836: l_itemkey := substr(p_document_id, instr(p_document_id, ':') + 1, (instr(p_document_id, '#') - instr(p_document_id, ':'))-1 );
3837: l_supplier_reg_id := substr(p_document_id, instr(p_document_id, '#') + 1, length(p_document_id));
3838:
3839: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3840: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_item_type ' || l_itemtype);
3841: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_item_key ' || l_itemkey);
3842: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_supplier_reg_id ' || l_supplier_reg_id);
3843: END IF;
3844:

Line 3841: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_item_key ' || l_itemkey);

3837: l_supplier_reg_id := substr(p_document_id, instr(p_document_id, '#') + 1, length(p_document_id));
3838:
3839: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3840: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_item_type ' || l_itemtype);
3841: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_item_key ' || l_itemkey);
3842: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_supplier_reg_id ' || l_supplier_reg_id);
3843: END IF;
3844:
3845: l_enterprisename := wf_engine.GetItemAttrText (itemtype => l_itemtype,

Line 3842: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_supplier_reg_id ' || l_supplier_reg_id);

3838:
3839: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3840: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_item_type ' || l_itemtype);
3841: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_item_key ' || l_itemkey);
3842: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_supplier_reg_id ' || l_supplier_reg_id);
3843: END IF;
3844:
3845: l_enterprisename := wf_engine.GetItemAttrText (itemtype => l_itemtype,
3846: itemkey => l_itemkey,

Line 3867: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

3863: aname => 'ADMIN_EMAIL');
3864:
3865:
3866:
3867: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3868: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_enterprisename ' || l_enterprisename);
3869: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_url ' || l_url);
3870: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_username ' || l_username);
3871: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_password ' || l_password);

Line 3868: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_enterprisename ' || l_enterprisename);

3864:
3865:
3866:
3867: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3868: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_enterprisename ' || l_enterprisename);
3869: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_url ' || l_url);
3870: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_username ' || l_username);
3871: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_password ' || l_password);
3872: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_adminemail ' || l_adminemail);

Line 3869: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_url ' || l_url);

3865:
3866:
3867: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3868: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_enterprisename ' || l_enterprisename);
3869: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_url ' || l_url);
3870: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_username ' || l_username);
3871: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_password ' || l_password);
3872: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_adminemail ' || l_adminemail);
3873: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'display_type ' || display_type);

Line 3870: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_username ' || l_username);

3866:
3867: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3868: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_enterprisename ' || l_enterprisename);
3869: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_url ' || l_url);
3870: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_username ' || l_username);
3871: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_password ' || l_password);
3872: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_adminemail ' || l_adminemail);
3873: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'display_type ' || display_type);
3874: END IF;

Line 3871: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_password ' || l_password);

3867: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
3868: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_enterprisename ' || l_enterprisename);
3869: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_url ' || l_url);
3870: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_username ' || l_username);
3871: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_password ' || l_password);
3872: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_adminemail ' || l_adminemail);
3873: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'display_type ' || display_type);
3874: END IF;
3875:

Line 3872: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_adminemail ' || l_adminemail);

3868: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_enterprisename ' || l_enterprisename);
3869: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_url ' || l_url);
3870: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_username ' || l_username);
3871: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_password ' || l_password);
3872: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_adminemail ' || l_adminemail);
3873: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'display_type ' || display_type);
3874: END IF;
3875:
3876: IF display_type = 'text/html' THEN

Line 3873: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'display_type ' || display_type);

3869: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_url ' || l_url);
3870: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_username ' || l_username);
3871: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_password ' || l_password);
3872: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'l_adminemail ' || l_adminemail);
3873: fnd_log.string(fnd_log.level_statement, g_log_module || '.GENERATE_APPRV_SUPPLIER_BODY', 'display_type ' || display_type);
3874: END IF;
3875:
3876: IF display_type = 'text/html' THEN
3877: l_disp_type:= display_type;