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_CL_PRE_PROCESS dependencies on MSC_ST_GROUP_COMPANIES

Line 1201: 'create index MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code

1197: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1198: application_short_name => 'MSC',
1199: statement_type => AD_DDL.CREATE_INDEX,
1200: statement =>
1201: 'create index MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code
1202: ||' on MSC_ST_GROUP_COMPANIES '
1203: ||'(group_name,company_name) '
1204: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1205: object_name =>'MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code);

Line 1202: ||' on MSC_ST_GROUP_COMPANIES '

1198: application_short_name => 'MSC',
1199: statement_type => AD_DDL.CREATE_INDEX,
1200: statement =>
1201: 'create index MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code
1202: ||' on MSC_ST_GROUP_COMPANIES '
1203: ||'(group_name,company_name) '
1204: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1205: object_name =>'MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code);
1206:

Line 1205: object_name =>'MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code);

1201: 'create index MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code
1202: ||' on MSC_ST_GROUP_COMPANIES '
1203: ||'(group_name,company_name) '
1204: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1205: object_name =>'MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code);
1206:
1207: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code);
1208:
1209: EXCEPTION

Line 1207: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code);

1203: ||'(group_name,company_name) '
1204: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1205: object_name =>'MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code);
1206:
1207: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code);
1208:
1209: EXCEPTION
1210: WHEN OTHERS THEN
1211: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

Line 1211: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

1207: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code);
1208:
1209: EXCEPTION
1210: WHEN OTHERS THEN
1211: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1212: END;
1213:
1214:
1215:

Line 2381: -- Drop index of MSC_ST_GROUP_COMPANIES

2377: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_PART_CONT_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2378: END;
2379:
2380: -- For Aeroexchange
2381: -- Drop index of MSC_ST_GROUP_COMPANIES
2382:
2383: BEGIN
2384: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2385: application_short_name => 'MSC',

Line 2388: 'drop index MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code,

2384: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2385: application_short_name => 'MSC',
2386: statement_type => AD_DDL.DROP_INDEX,
2387: statement =>
2388: 'drop index MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code,
2389: object_name => 'MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code);
2390:
2391: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code);
2392:

Line 2389: object_name => 'MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code);

2385: application_short_name => 'MSC',
2386: statement_type => AD_DDL.DROP_INDEX,
2387: statement =>
2388: 'drop index MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code,
2389: object_name => 'MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code);
2390:
2391: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code);
2392:
2393: EXCEPTION

Line 2391: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code);

2387: statement =>
2388: 'drop index MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code,
2389: object_name => 'MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code);
2390:
2391: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code);
2392:
2393: EXCEPTION
2394: WHEN OTHERS THEN
2395: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

Line 2395: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

2391: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code);
2392:
2393: EXCEPTION
2394: WHEN OTHERS THEN
2395: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2396: END;
2397:
2398:
2399: ---- Drop index of MSC_ST_GROUPS

Line 6385: FROM msc_st_group_companies

6381:
6382: --------
6383: CURSOR c12(p_batch_id NUMBER) IS
6384: SELECT rowid
6385: FROM msc_st_group_companies
6386: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
6387: AND sr_instance_code = v_instance_code
6388: AND batch_id = p_batch_id;
6389:

Line 6412: FROM msc_st_group_companies msg,msc_group_companies mg

6408: msg.ATTRIBUTE12,
6409: msg.ATTRIBUTE13,
6410: msg.ATTRIBUTE14,
6411: msg.ATTRIBUTE15
6412: FROM msc_st_group_companies msg,msc_group_companies mg
6413: WHERE msg.process_flag = G_VALID
6414: AND msg.sr_instance_code = v_instance_code
6415: AND msg.batch_id = p_batch_id
6416: AND msg.group_id = mg.group_id

Line 10579: ' UPDATE msc_st_group_companies mgc1'

10575:
10576: --Duplicate records check for the records whose source is XML
10577: v_sql_stmt := 68;
10578: lv_sql_stmt :=
10579: ' UPDATE msc_st_group_companies mgc1'
10580: ||' SET process_flag = '||G_ERROR_FLG||','
10581: ||' error_text = '||''''||lv_message_text||''''
10582: ||' WHERE message_id < (SELECT MAX(message_id)'
10583: ||' FROM msc_st_group_companies mgc2'

Line 10583: ||' FROM msc_st_group_companies mgc2'

10579: ' UPDATE msc_st_group_companies mgc1'
10580: ||' SET process_flag = '||G_ERROR_FLG||','
10581: ||' error_text = '||''''||lv_message_text||''''
10582: ||' WHERE message_id < (SELECT MAX(message_id)'
10583: ||' FROM msc_st_group_companies mgc2'
10584: ||' WHERE mgc2.group_name = mgc1.group_name '
10585: ||' AND mgc2.company_name = mgc1.company_name '
10586: ||' AND mgc2.process_flag <> '||G_ERROR_FLG
10587: ||' AND NVL(mgc2.message_id,'||NULL_VALUE||')<>'||NULL_VALUE||')'

Line 10615: ' UPDATE msc_st_group_companies mgc1'

10611:
10612: v_sql_stmt := 69;
10613:
10614: lv_sql_stmt :=
10615: ' UPDATE msc_st_group_companies mgc1'
10616: ||' SET process_flag = '||G_ERROR_FLG||','
10617: ||' error_text = '||''''||lv_message_text||''''
10618: ||' WHERE EXISTS( SELECT 1 '
10619: ||' FROM msc_st_group_companies mgc2'

Line 10619: ||' FROM msc_st_group_companies mgc2'

10615: ' UPDATE msc_st_group_companies mgc1'
10616: ||' SET process_flag = '||G_ERROR_FLG||','
10617: ||' error_text = '||''''||lv_message_text||''''
10618: ||' WHERE EXISTS( SELECT 1 '
10619: ||' FROM msc_st_group_companies mgc2'
10620: ||' WHERE mgc2.group_name = mgc1.group_name '
10621: ||' AND mgc2.company_name = mgc1.company_name '
10622: ||' AND mgc2.process_flag <> '||G_ERROR_FLG
10623: ||' AND NVL(mgc2.message_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 10669: 'UPDATE msc_st_group_companies '

10665: FROM DUAL;
10666:
10667: v_sql_stmt := 71;
10668: lv_sql_stmt :=
10669: 'UPDATE msc_st_group_companies '
10670: ||' SET batch_id = :lv_batch_id'
10671: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
10672: ||' AND sr_instance_code = :v_instance_code'
10673: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 10693: UPDATE msc_st_group_companies

10689: CLOSE c12;
10690:
10691: v_sql_stmt := 72;
10692: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
10693: UPDATE msc_st_group_companies
10694: SET st_transaction_id = msc_st_group_companies_s.NEXTVAL,
10695: last_update_date = v_current_date,
10696: last_updated_by = v_current_user,
10697: creation_date = v_current_date,

Line 10694: SET st_transaction_id = msc_st_group_companies_s.NEXTVAL,

10690:
10691: v_sql_stmt := 72;
10692: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
10693: UPDATE msc_st_group_companies
10694: SET st_transaction_id = msc_st_group_companies_s.NEXTVAL,
10695: last_update_date = v_current_date,
10696: last_updated_by = v_current_user,
10697: creation_date = v_current_date,
10698: created_by = v_current_user

Line 10710: p_token_value1 => 'MSC_ST_GROUP_COMPANIES');

10706: p_error_code => 'MSC_PP_NO_DELETION',
10707: p_message_text => lv_message_text,
10708: p_error_text => lv_error_text,
10709: p_token1 => 'TABLE_NAME',
10710: p_token_value1 => 'MSC_ST_GROUP_COMPANIES');
10711:
10712: IF lv_return <> 0 THEN
10713: RAISE ex_logging_err;
10714: END IF;

Line 10719: ' UPDATE msc_st_group_companies '

10715:
10716: --Deletion is not allowed on this table.
10717: v_sql_stmt := 73;
10718: lv_sql_stmt :=
10719: ' UPDATE msc_st_group_companies '
10720: ||' SET process_flag ='||G_ERROR_FLG||','
10721: ||' error_text = '||''''||lv_message_text||''''
10722: ||' WHERE deleted_flag = '||SYS_YES
10723: ||' AND process_flag = '||G_IN_PROCESS

Line 10755: (p_table_name => 'MSC_ST_GROUP_COMPANIES',

10751: lv_where_str :=
10752: ' AND NVL(deleted_flag,'||NULL_VALUE||') NOT IN(1,2)';
10753:
10754: lv_return := MSC_ST_util.LOG_ERROR
10755: (p_table_name => 'MSC_ST_GROUP_COMPANIES',
10756: p_instance_code => v_instance_code,
10757: p_row => lv_column_names,
10758: p_severity => G_SEV_WARNING,
10759: p_message_text => lv_message_text,

Line 10788: ' UPDATE msc_st_group_companies '

10784:
10785: v_sql_stmt := 74;
10786:
10787: lv_sql_stmt :=
10788: ' UPDATE msc_st_group_companies '
10789: ||' SET process_flag = '||G_ERROR_FLG||','
10790: ||' error_text = '||''''||lv_message_text||''''
10791: ||' WHERE effective_date IS NULL '
10792: ||' AND batch_id = :lv_batch_id'

Line 10818: ' UPDATE msc_st_group_companies '

10814:
10815: v_sql_stmt := 75;
10816:
10817: lv_sql_stmt :=
10818: ' UPDATE msc_st_group_companies '
10819: ||' SET process_flag = '||G_ERROR_FLG||','
10820: ||' error_text = '||''''||lv_message_text||''''
10821: ||' WHERE effective_date > disable_date'
10822: ||' AND disable_date IS NOT NULL'

Line 10847: (p_table_name =>'MSC_ST_GROUP_COMPANIES',

10843: p_token_value1 => 'GROUP_NAME');
10844:
10845:
10846: lv_return := MSC_ST_util.DERIVE_GROUP_ID
10847: (p_table_name =>'MSC_ST_GROUP_COMPANIES',
10848: p_grp_col_name => 'GROUP_NAME',
10849: p_grp_col_id => 'GROUP_ID',
10850: p_instance_code => v_instance_code,
10851: p_instance_id => v_instance_id,

Line 10886: 'UPDATE msc_st_group_companies msg'

10882: IF NOT MSC_ST_util.IS_OPERATOR(lv_user_id) THEN
10883:
10884: v_sql_stmt := 76;
10885: lv_sql_stmt :=
10886: 'UPDATE msc_st_group_companies msg'
10887: ||' SET process_flag = '||G_ERROR_FLG||','
10888: ||' error_text = '||''''||lv_message_text||''''
10889: ||' WHERE NOT EXISTS(SELECT 1 '
10890: ||' FROM msc_groups mg'

Line 10914: 'UPDATE msc_st_group_companies msg '

10910: --Derive company_id
10911:
10912: v_sql_stmt := 77;
10913: lv_sql_stmt :=
10914: 'UPDATE msc_st_group_companies msg '
10915: ||' SET company_id = ( SELECT mc.company_id '
10916: ||' FROM msc_companies mc '
10917: ||' WHERE mc.company_name = msg.company_name '
10918: ||' AND NVL(mc.disable_date,sysdate+1) > sysdate) '

Line 10948: 'UPDATE msc_st_group_companies msg'

10944: --Derive contact_user_id
10945:
10946: v_sql_stmt := 78;
10947: lv_sql_stmt :=
10948: 'UPDATE msc_st_group_companies msg'
10949: ||' SET contact_user_id = (select user_id '
10950: ||' from fnd_user fu'
10951: ||' where UPPER(fu.user_name) =UPPER( msg.contact_user_name)) '
10952: ||' WHERE batch_id = :lv_batch_id'

Line 10981: 'UPDATE msc_st_group_companies '

10977: -- Update the record as errored out record
10978:
10979: v_sql_stmt := 79;
10980: lv_sql_stmt :=
10981: 'UPDATE msc_st_group_companies '
10982: ||' SET process_flag = '||G_ERROR_FLG||','
10983: ||' error_text = '||''''||lv_message_text||''''
10984: ||' WHERE contact_user_id IS NULL '
10985: ||' AND batch_id = :lv_batch_id'

Line 10999: p_token_value3 => 'MSC_ST_GROUP_COMPANIES');

10995: p_token_value1 => 'CONTACT_USER_NAME,COMPANY_NAME',
10996: p_token2 => 'MASTER_TABLE',
10997: p_token_value2 => 'MSC_COMPANY_USERS',
10998: p_token3 => 'CHILD_TABLE',
10999: p_token_value3 => 'MSC_ST_GROUP_COMPANIES');
11000:
11001: IF lv_return <> 0 THEN
11002: RAISE ex_logging_err;
11003: END IF;

Line 11009: ' UPDATE msc_st_group_companies mgc'

11005: -- Populating valid Contact user id
11006:
11007: v_sql_stmt := 80;
11008: lv_sql_stmt :=
11009: ' UPDATE msc_st_group_companies mgc'
11010: ||' SET process_flag = '||G_ERROR_FLG||','
11011: ||' error_text = '||''''||lv_message_text||''''
11012: ||' WHERE NOT EXISTS (SELECT 1 '
11013: ||' FROM msc_company_users mcu '

Line 11034: pEntityName => 'MSC_ST_GROUP_COMPANIES',

11030: (ERRBUF => lv_error_text,
11031: RETCODE => lv_return,
11032: pBatchID => lv_batch_id,
11033: pInstanceCode => v_instance_code,
11034: pEntityName => 'MSC_ST_GROUP_COMPANIES',
11035: pInstanceID => v_instance_id);
11036:
11037: IF NVL(lv_return,0) <> 0 THEN
11038: RAISE ex_logging_err;

Line 11044: (p_table_name => 'MSC_ST_GROUP_COMPANIES',

11040:
11041: -- Set the process flag as Valid and derive sr_instance_id
11042:
11043: lv_return := MSC_ST_util.SET_PROCESS_FLAG
11044: (p_table_name => 'MSC_ST_GROUP_COMPANIES',
11045: p_instance_id => v_instance_id,
11046: p_instance_code => v_instance_code,
11047: p_process_flag => G_VALID,
11048: p_error_text => lv_error_text,

Line 11059: (p_table_name => 'MSC_ST_GROUP_COMPANIES',

11055:
11056: -- Inserting all the errored out records into MSC_ERRORS
11057:
11058: lv_return := MSC_ST_util.LOG_ERROR
11059: (p_table_name => 'MSC_ST_GROUP_COMPANIES',
11060: p_instance_code => v_instance_code,
11061: p_row => lv_column_names,
11062: p_severity => G_SEV_ERROR,
11063: p_error_text => lv_error_text,

Line 11188: ||' FROM msc_st_group_companies msg'

11184: ||' ATTRIBUTE12 ,'
11185: ||' ATTRIBUTE13 ,'
11186: ||' ATTRIBUTE14 ,'
11187: ||' ATTRIBUTE15 '
11188: ||' FROM msc_st_group_companies msg'
11189: ||' WHERE sr_instance_code = :sr_instance_code'
11190: ||' AND batch_id = :lv_batch_id'
11191: ||' AND process_flag = '||G_VALID
11192: ||' AND NOT EXISTS( SELECT 1 '

Line 55941: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_GROUP_COMPANIES');

55937: IF lv_count > 0 Then
55938: prec.sub_inventory_flag:= SYS_YES;
55939: End IF;
55940: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_GROUPS',p_company_name_col => FALSE);
55941: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_GROUP_COMPANIES');
55942: END IF;
55943:
55944: IF v_dmd_class_enabled = SYS_YES THEN
55945: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_DEMAND_CLASSES');