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.IEM_EMTA_ADMIN_PVT dependencies on IEM_EMTA_CONFIG_PARAMS

Line 342: logMessage := '[input data is invalid, no data inserted to IEM_EMTA_CONFIG_PARAMS,return true!]';

338: FND_MSG_PUB.ADD;
339: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
340:
341: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
342: logMessage := '[input data is invalid, no data inserted to IEM_EMTA_CONFIG_PARAMS,return true!]';
343: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_EMTA_ADMIN_PVT.UPDATE_DP_CONFIG_DATA_WRAP', logMessage);
344: end if;
345:
346: WHEN IEM_UPD_DP_CONFIG_DATA_FAILED THEN

Line 476: from iem_emta_config_params where flag='N' and email_account_id=p_email_acct_id for update nowait

472:
473: begin
474: FOR x IN (
475: select emta_config_param_id, action_type, email_account_id, account_update_flag
476: from iem_emta_config_params where flag='N' and email_account_id=p_email_acct_id for update nowait
477: )
478: LOOP
479:
480: if x.account_update_flag = 'Y' then

Line 481: update iem_emta_config_params set action_type = l_action,last_update_date = sysdate

477: )
478: LOOP
479:
480: if x.account_update_flag = 'Y' then
481: update iem_emta_config_params set action_type = l_action,last_update_date = sysdate
482: where emta_config_param_id = x.emta_config_param_id;
483:
484: l_has_updated := 'Y';
485: exit;

Line 487: update iem_emta_config_params set action_type = l_action, account_update_flag=l_update_flag, last_update_date = sysdate

483:
484: l_has_updated := 'Y';
485: exit;
486: else
487: update iem_emta_config_params set action_type = l_action, account_update_flag=l_update_flag, last_update_date = sysdate
488: where emta_config_param_id = x.emta_config_param_id;
489:
490: l_has_updated := 'Y';
491: exit;

Line 506: select IEM_EMTA_CONFIG_PARAMS_S1.nextval into l_seq_id from dual;

502: null;
503: end;
504:
505: if l_has_updated = 'N' then
506: select IEM_EMTA_CONFIG_PARAMS_S1.nextval into l_seq_id from dual;
507:
508:
509: INSERT INTO IEM_EMTA_CONFIG_PARAMS
510: (

Line 509: INSERT INTO IEM_EMTA_CONFIG_PARAMS

505: if l_has_updated = 'N' then
506: select IEM_EMTA_CONFIG_PARAMS_S1.nextval into l_seq_id from dual;
507:
508:
509: INSERT INTO IEM_EMTA_CONFIG_PARAMS
510: (
511: EMTA_CONFIG_PARAM_ID,
512: EMAIL_ACCOUNT_ID,
513: ACTION_TYPE,

Line 638: from iem_emta_config_params where flag='N' for update nowait

634: Y := 1;
635:
636: for x in (
637: select emta_config_param_id, action_type, email_account_id, account_update_flag
638: from iem_emta_config_params where flag='N' for update nowait
639: )
640: LOOP
641: update IEM_EMTA_CONFIG_PARAMS set FLAG='A', LAST_UPDATE_DATE=SYSDATE
642: where emta_config_param_id=x.emta_config_param_id;

Line 641: update IEM_EMTA_CONFIG_PARAMS set FLAG='A', LAST_UPDATE_DATE=SYSDATE

637: select emta_config_param_id, action_type, email_account_id, account_update_flag
638: from iem_emta_config_params where flag='N' for update nowait
639: )
640: LOOP
641: update IEM_EMTA_CONFIG_PARAMS set FLAG='A', LAST_UPDATE_DATE=SYSDATE
642: where emta_config_param_id=x.emta_config_param_id;
643:
644: select count(*) into l_count
645: from iem_mstemail_accounts where email_account_id=x.email_account_id;

Line 648: delete IEM_EMTA_CONFIG_PARAMS where emta_config_param_id=x.emta_config_param_id;

644: select count(*) into l_count
645: from iem_mstemail_accounts where email_account_id=x.email_account_id;
646:
647: if ( l_count = 0 ) then
648: delete IEM_EMTA_CONFIG_PARAMS where emta_config_param_id=x.emta_config_param_id;
649: else
650:
651: select * into account_rec
652: from iem_mstemail_accounts where email_account_id=x.email_account_id;

Line 745: delete iem_emta_config_params where flag='A';

741: --Initialize API status return
742: x_return_status := FND_API.G_RET_STS_SUCCESS;
743:
744: --Actual API starts here
745: delete iem_emta_config_params where flag='A';
746:
747: --Standard check of p_commit
748: IF FND_API.to_Boolean(p_commit) THEN
749: COMMIT WORK;

Line 859: logMessage := '[input data is invalid, no data inserted to IEM_EMTA_CONFIG_PARAMS,return true!]';

855: FND_MSG_PUB.ADD;
856: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
857:
858: if fnd_log.test(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_EMTA_ADMIN_PVT.UPDATE_DP_CONFIG_DATA_WRAP') then
859: logMessage := '[input data is invalid, no data inserted to IEM_EMTA_CONFIG_PARAMS,return true!]';
860: dbms_output.put_line(logMessage);
861: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_EMTA_ADMIN_PVT.UPDATE_DP_CONFIG_DATA_WRAP', logMessage);
862: end if;
863: */ when others then