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.MSC_E1APS_UTIL dependencies on MSC_UTIL

Line 170: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'LOAD PARAMETER FAILED. Session # ' || SessionNum);

166: -- Changes for 11G
167: IF SessionNum <> '-1' AND (LENGTH(ErrMessage) IS NULL) THEN
168: err_msg1 := GetODIErrorMessage(SessionNum);
169: IF (length(err_msg1) IS NOT NULL) THEN
170: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'LOAD PARAMETER FAILED. Session # ' || SessionNum);
171: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error : ' || err_msg1);
172: finalreturnStr := err_msg1;
173: RETURN finalreturnStr;
174: END IF;

Line 171: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error : ' || err_msg1);

167: IF SessionNum <> '-1' AND (LENGTH(ErrMessage) IS NULL) THEN
168: err_msg1 := GetODIErrorMessage(SessionNum);
169: IF (length(err_msg1) IS NOT NULL) THEN
170: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'LOAD PARAMETER FAILED. Session # ' || SessionNum);
171: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error : ' || err_msg1);
172: finalreturnStr := err_msg1;
173: RETURN finalreturnStr;
174: END IF;
175: END IF;

Line 244: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'UPDATE VARIABLE FAILED. Session # ' || SessionNum);

240: -- Changes for 11G
241: IF SessionNum <> '-1' AND (LENGTH(ErrMessage) IS NULL) THEN
242: err_msg1 := GetODIErrorMessage(SessionNum);
243: IF (length(err_msg1) > 0) THEN
244: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'UPDATE VARIABLE FAILED. Session # ' || SessionNum);
245: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error : ' || err_msg1);
246: finalreturnStr := err_msg1;
247: RETURN finalreturnStr;
248: END IF;

Line 245: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error : ' || err_msg1);

241: IF SessionNum <> '-1' AND (LENGTH(ErrMessage) IS NULL) THEN
242: err_msg1 := GetODIErrorMessage(SessionNum);
243: IF (length(err_msg1) > 0) THEN
244: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'UPDATE VARIABLE FAILED. Session # ' || SessionNum);
245: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error : ' || err_msg1);
246: finalreturnStr := err_msg1;
247: RETURN finalreturnStr;
248: END IF;
249: END IF;

Line 320: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'SYNCHRONIZE XML FAILED. Session # ' || SessionNum);

316: -- Changes for 11G
317: IF SessionNum <> '-1' AND (LENGTH(ErrMessage) IS NULL) THEN
318: err_msg1 := GetODIErrorMessage(SessionNum);
319: IF (length(err_msg1) > 0) THEN
320: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'SYNCHRONIZE XML FAILED. Session # ' || SessionNum);
321: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error : ' || err_msg1);
322: finalreturnStr := err_msg1;
323: RETURN finalreturnStr;
324: END IF;

Line 321: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error : ' || err_msg1);

317: IF SessionNum <> '-1' AND (LENGTH(ErrMessage) IS NULL) THEN
318: err_msg1 := GetODIErrorMessage(SessionNum);
319: IF (length(err_msg1) > 0) THEN
320: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'SYNCHRONIZE XML FAILED. Session # ' || SessionNum);
321: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error : ' || err_msg1);
322: finalreturnStr := err_msg1;
323: RETURN finalreturnStr;
324: END IF;
325: END IF;

Line 515: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'File copy failed.' );

511: fc_url := fnd_profile.value('MSC_E1APS_FCURL');
512: IF fc_url IS NOT NULL THEN
513: fc_ret_value :=MSC_E1APS_DEMCL.CALL_ODIEXE('EXPORTFILESFROMDEMANTRASERVER' ,scenario_version ,'' ,fc_url);
514: IF fc_ret_value = FALSE THEN
515: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'File copy failed.' );
516: RETURN DEM_FAILURE;
517: END IF;
518: ELSE
519: RETURN DEM_SUCCESS;

Line 570: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,' ' || scenario_name ||' SUCCESS');

566: EXECUTE immediate x_sql into Session_number,SessionStatus;
567:
568: IF (SESSIONSTATUS = 'D' or SESSIONSTATUS ='M') then /* Checking for Success or Warning*/
569: ResultFlag := 1;
570: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,' ' || scenario_name ||' SUCCESS');
571: EXIT;
572: ELSIF (SESSIONSTATUS = 'R') then /*Checking for Scenario still Running*/
573: ResultFlag := 2;
574: ELSIF (SESSIONSTATUS = 'E') then /*Checking for Scenario failure*/

Line 576: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Scenario ' || scenario_name|| ' executed with errors. Session # ' || Session_number );

572: ELSIF (SESSIONSTATUS = 'R') then /*Checking for Scenario still Running*/
573: ResultFlag := 2;
574: ELSIF (SESSIONSTATUS = 'E') then /*Checking for Scenario failure*/
575: ResultFlag := 0;
576: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Scenario ' || scenario_name|| ' executed with errors. Session # ' || Session_number );
577: EXIT;
578: END IF;
579:
580: DBMS_LOCK.sleep(60);/*Sleeps the execution for 60 seconds*/

Line 585: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Session Time out after' || Time_Out ||'Seconds Session No#'|| Session_number|| ' Please set maximum time to profile MSC_E1APS_WS_TIME_OUT');

581: v_Sleep:= v_Sleep+60; /*Counter value for Sleep */
582:
583: IF (v_Sleep = Time_Out) Then
584: ResultFlag := 0;
585: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Session Time out after' || Time_Out ||'Seconds Session No#'|| Session_number|| ' Please set maximum time to profile MSC_E1APS_WS_TIME_OUT');
586: EXIT;
587: END IF;
588: END LOOP;
589:

Line 618: IF (updateFlag = MSC_UTIL.SYS_NO) THEN

614: SELECT NVL(count(1),0) into x_table_presence
615: FROM dba_tables
616: WHERE owner = owner AND table_name = 'MDP_MATRIX';
617:
618: IF (updateFlag = MSC_UTIL.SYS_NO) THEN
619: IF (fnd_profile.value('MSD_DEM_SCHEMA') IS NOT NULL AND x_table_presence > 0) THEN
620: x_dem_schema := fnd_profile.value('MSD_DEM_SCHEMA');
621: IF (fnd_profile.value('MSD_DEM_TRUNCATE_STG_TABLE') = 'Y' ) THEN
622: x_sql := 'truncate table ' || x_dem_schema || '.t_src_sales_tmpl';

Line 628: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Truncated tables t_src_sales_tmpl/item/loc.');

624: x_sql := 'truncate table ' || x_dem_schema || '.t_src_item_tmpl';
625: execute immediate x_sql;
626: x_sql := 'truncate table ' || x_dem_schema || '.t_src_loc_tmpl';
627: execute immediate x_sql;
628: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Truncated tables t_src_sales_tmpl/item/loc.');
629: END IF;
630: END IF;
631: END IF;
632:

Line 648: IF updateFlag = MSC_UTIL.SYS_YES THEN

644: IF e1_instance_name is not null THEN
645:
646: -- Profile Check for E1VCP Integration
647:
648: IF updateFlag = MSC_UTIL.SYS_YES THEN
649: -- TO Update TP_SITE_CODE to BILL_TO
650: lv_sql_stmt :=
651: 'UPDATE msc_trading_partner_sites '
652: ||' SET TP_SITE_CODE = ''BILL_TO'' '

Line 657: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

653: ||' WHERE partner_type = ' || MSC_CL_PRE_PROCESS.G_CUSTOMER
654: ||' AND sr_instance_id = ' || parInstanceID
655: ||' AND partner_address like ''E1_BILL_TO%''';
656:
657: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
658: EXECUTE IMMEDIATE lv_sql_stmt;
659: COMMIT;
660:
661: --TO Update TP_SITE_CODE to SHIP_TO

Line 670: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

666: ||' AND sr_instance_id = ' || parInstanceID
667: ||' AND partner_address not like ''E1_BILL_TO%'''; -- Removed comment for bug# 12558193
668: -- OR partner_address is null )';
669:
670: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
671:
672: EXECUTE IMMEDIATE lv_sql_stmt;
673: COMMIT;
674:

Line 675: ELSIF updateFlag = MSC_UTIL.SYS_NO THEN

671:
672: EXECUTE IMMEDIATE lv_sql_stmt;
673: COMMIT;
674:
675: ELSIF updateFlag = MSC_UTIL.SYS_NO THEN
676: -- To Update TP_SITE_CODE with Location
677:
678: lv_sql_stmt :=
679: 'UPDATE msc_trading_partner_sites '

Line 684: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);

680: ||' SET TP_SITE_CODE = LOCATION '
681: ||' WHERE partner_type = ' || MSC_CL_PRE_PROCESS.G_CUSTOMER
682: ||' AND sr_instance_id = ' || parInstanceID ;
683:
684: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
685: EXECUTE IMMEDIATE lv_sql_stmt;
686: COMMIT;
687: END IF ;
688: END IF;

Line 694: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,substr(SQLERRM,1,150));

690:
691: exception
692: when others then
693: errbuf := ' TP_SITE_CODE Update failed ';
694: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,substr(SQLERRM,1,150));
695: retcode := MSC_UTIL.G_ERROR;
696:
697: END UPDATE_TP_SITE_CODE;
698:

Line 695: retcode := MSC_UTIL.G_ERROR;

691: exception
692: when others then
693: errbuf := ' TP_SITE_CODE Update failed ';
694: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,substr(SQLERRM,1,150));
695: retcode := MSC_UTIL.G_ERROR;
696:
697: END UPDATE_TP_SITE_CODE;
698:
699: