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_GROUPS

Line 1167: --Added for MSC_ST_GROUPS

1163: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_PART_CONT_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1164: END;
1165:
1166: --For Aeroexchange
1167: --Added for MSC_ST_GROUPS
1168: BEGIN
1169: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1170: application_short_name => 'MSC',
1171: statement_type => AD_DDL.CREATE_INDEX,

Line 1173: 'create index MSC_ST_GROUPS_N1_'||v_instance_code

1169: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1170: application_short_name => 'MSC',
1171: statement_type => AD_DDL.CREATE_INDEX,
1172: statement =>
1173: 'create index MSC_ST_GROUPS_N1_'||v_instance_code
1174: ||' on MSC_ST_GROUPS '
1175: ||'(GROUP_NAME) '
1176: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1177: object_name =>'MSC_ST_GROUPS_N1_'||v_instance_code);

Line 1174: ||' on MSC_ST_GROUPS '

1170: application_short_name => 'MSC',
1171: statement_type => AD_DDL.CREATE_INDEX,
1172: statement =>
1173: 'create index MSC_ST_GROUPS_N1_'||v_instance_code
1174: ||' on MSC_ST_GROUPS '
1175: ||'(GROUP_NAME) '
1176: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1177: object_name =>'MSC_ST_GROUPS_N1_'||v_instance_code);
1178:

Line 1177: object_name =>'MSC_ST_GROUPS_N1_'||v_instance_code);

1173: 'create index MSC_ST_GROUPS_N1_'||v_instance_code
1174: ||' on MSC_ST_GROUPS '
1175: ||'(GROUP_NAME) '
1176: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1177: object_name =>'MSC_ST_GROUPS_N1_'||v_instance_code);
1178:
1179: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_GROUPS_N1_'||v_instance_code);
1180:
1181: msc_analyse_tables_pk.analyse_table( 'MSC_ST_GROUPS', v_instance_id, -1);

Line 1179: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_GROUPS_N1_'||v_instance_code);

1175: ||'(GROUP_NAME) '
1176: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1177: object_name =>'MSC_ST_GROUPS_N1_'||v_instance_code);
1178:
1179: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_GROUPS_N1_'||v_instance_code);
1180:
1181: msc_analyse_tables_pk.analyse_table( 'MSC_ST_GROUPS', v_instance_id, -1);
1182:
1183: EXCEPTION

Line 1181: msc_analyse_tables_pk.analyse_table( 'MSC_ST_GROUPS', v_instance_id, -1);

1177: object_name =>'MSC_ST_GROUPS_N1_'||v_instance_code);
1178:
1179: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_GROUPS_N1_'||v_instance_code);
1180:
1181: msc_analyse_tables_pk.analyse_table( 'MSC_ST_GROUPS', v_instance_id, -1);
1182:
1183: EXCEPTION
1184: WHEN OTHERS THEN
1185: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_GROUPS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

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

1181: msc_analyse_tables_pk.analyse_table( 'MSC_ST_GROUPS', v_instance_id, -1);
1182:
1183: EXCEPTION
1184: WHEN OTHERS THEN
1185: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_GROUPS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1186: END;
1187:
1188: BEGIN
1189: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

Line 2391: ---- Drop index of MSC_ST_GROUPS

2387: 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));
2388: END;
2389:
2390:
2391: ---- Drop index of MSC_ST_GROUPS
2392: BEGIN
2393: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2394: application_short_name => 'MSC',
2395: statement_type => AD_DDL.DROP_INDEX,

Line 2397: 'drop index MSC_ST_GROUPS_N1_'||v_instance_code,

2393: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2394: application_short_name => 'MSC',
2395: statement_type => AD_DDL.DROP_INDEX,
2396: statement =>
2397: 'drop index MSC_ST_GROUPS_N1_'||v_instance_code,
2398: object_name => 'MSC_ST_GROUPS_N1_'||v_instance_code);
2399:
2400: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_GROUPS_N1_'||v_instance_code);
2401:

Line 2398: object_name => 'MSC_ST_GROUPS_N1_'||v_instance_code);

2394: application_short_name => 'MSC',
2395: statement_type => AD_DDL.DROP_INDEX,
2396: statement =>
2397: 'drop index MSC_ST_GROUPS_N1_'||v_instance_code,
2398: object_name => 'MSC_ST_GROUPS_N1_'||v_instance_code);
2399:
2400: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_GROUPS_N1_'||v_instance_code);
2401:
2402: EXCEPTION

Line 2400: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_GROUPS_N1_'||v_instance_code);

2396: statement =>
2397: 'drop index MSC_ST_GROUPS_N1_'||v_instance_code,
2398: object_name => 'MSC_ST_GROUPS_N1_'||v_instance_code);
2399:
2400: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_GROUPS_N1_'||v_instance_code);
2401:
2402: EXCEPTION
2403: WHEN OTHERS THEN
2404: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_GROUPS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

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

2400: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_GROUPS_N1_'||v_instance_code);
2401:
2402: EXCEPTION
2403: WHEN OTHERS THEN
2404: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_GROUPS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2405: END;
2406:
2407:
2408: END IF;

Line 6326: FROM MSC_ST_GROUPS

6322: AND batch_id = p_batch_id;
6323:
6324: CURSOR c9(p_batch_id NUMBER) IS
6325: SELECT rowid
6326: FROM MSC_ST_GROUPS
6327: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
6328: AND batch_id = p_batch_id
6329: AND sr_instance_code = v_instance_code;
6330:

Line 6333: FROM MSC_ST_GROUPS

6329: AND sr_instance_code = v_instance_code;
6330:
6331: CURSOR c10(p_batch_id NUMBER) IS
6332: SELECT rowid
6333: FROM MSC_ST_GROUPS
6334: WHERE process_flag = G_IN_PROCESS
6335: AND sr_instance_code = v_instance_code
6336: AND batch_id = p_batch_id
6337: AND NVL(group_id,NULL_VALUE) = NULL_VALUE;

Line 6369: FROM msc_st_groups msg,msc_groups mg

6365: msg.ATTRIBUTE12,
6366: msg.ATTRIBUTE13,
6367: msg.ATTRIBUTE14,
6368: msg.ATTRIBUTE15
6369: FROM msc_st_groups msg,msc_groups mg
6370: WHERE msg.process_flag = G_VALID
6371: AND msg.sr_instance_code = v_instance_code
6372: AND msg.batch_id = p_batch_id
6373: AND msg.group_id = mg.group_id;

Line 9787: ' UPDATE MSC_ST_GROUPS msu1'

9783:
9784: --Duplicate records check for the records whose source is XML
9785: v_sql_stmt := 52;
9786: lv_sql_stmt :=
9787: ' UPDATE MSC_ST_GROUPS msu1'
9788: ||' SET process_flag = '||G_ERROR_FLG||','
9789: ||' error_text = '||''''||lv_message_text||''''
9790: ||' WHERE message_id < (SELECT MAX(message_id)'
9791: ||' FROM MSC_ST_GROUPS msu2'

Line 9791: ||' FROM MSC_ST_GROUPS msu2'

9787: ' UPDATE MSC_ST_GROUPS msu1'
9788: ||' SET process_flag = '||G_ERROR_FLG||','
9789: ||' error_text = '||''''||lv_message_text||''''
9790: ||' WHERE message_id < (SELECT MAX(message_id)'
9791: ||' FROM MSC_ST_GROUPS msu2'
9792: ||' where msu2.group_name = msu1.group_name '
9793: ||' AND msu2.process_flag <> '||G_ERROR_FLG
9794: ||' AND NVL(msu2.message_id,'||NULL_VALUE||')<>'||NULL_VALUE||')'
9795: ||' AND msu1.process_flag = '||G_IN_PROCESS

Line 9821: ' UPDATE MSC_ST_GROUPS msu1'

9817: --whereas in batch load we cannot.
9818:
9819: v_sql_stmt := 53;
9820: lv_sql_stmt :=
9821: ' UPDATE MSC_ST_GROUPS msu1'
9822: ||' SET process_flag = '||G_ERROR_FLG||','
9823: ||' error_text = '||''''||lv_message_text||''''
9824: ||' WHERE EXISTS( SELECT 1 '
9825: ||' FROM MSC_ST_GROUPS msu2'

Line 9825: ||' FROM MSC_ST_GROUPS msu2'

9821: ' UPDATE MSC_ST_GROUPS msu1'
9822: ||' SET process_flag = '||G_ERROR_FLG||','
9823: ||' error_text = '||''''||lv_message_text||''''
9824: ||' WHERE EXISTS( SELECT 1 '
9825: ||' FROM MSC_ST_GROUPS msu2'
9826: ||' WHERE msu2.group_name = msu1.group_name'
9827: ||' AND msu2.process_flag <> '||G_ERROR_FLG
9828: ||' AND NVL(msu2.message_id,'||NULL_VALUE||') = '||NULL_VALUE
9829: ||' AND msu2.rowid <> msu1.rowid)'

Line 9877: ' UPDATE MSC_ST_GROUPS '

9873: FROM dual;
9874:
9875: v_sql_stmt := 55;
9876: lv_sql_stmt :=
9877: ' UPDATE MSC_ST_GROUPS '
9878: ||' SET batch_id = :lv_batch_id'
9879: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
9880: ||' AND sr_instance_code = :v_instance_code'
9881: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 9901: UPDATE MSC_ST_GROUPS

9897: CLOSE c9;
9898:
9899: v_sql_stmt := 56;
9900: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
9901: UPDATE MSC_ST_GROUPS
9902: SET st_transaction_id = msc_st_groups_s.NEXTVAL,
9903: last_update_date = v_current_date,
9904: last_updated_by = v_current_user,
9905: creation_date = v_current_date,

Line 9902: SET st_transaction_id = msc_st_groups_s.NEXTVAL,

9898:
9899: v_sql_stmt := 56;
9900: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
9901: UPDATE MSC_ST_GROUPS
9902: SET st_transaction_id = msc_st_groups_s.NEXTVAL,
9903: last_update_date = v_current_date,
9904: last_updated_by = v_current_user,
9905: creation_date = v_current_date,
9906: created_by = v_current_user

Line 9916: p_token_value1 => 'MSC_ST_GROUPS');

9912: p_error_code => 'MSC_PP_NO_DELETION',
9913: p_message_text => lv_message_text,
9914: p_error_text => lv_error_text,
9915: p_token1 => 'TABLE_NAME',
9916: p_token_value1 => 'MSC_ST_GROUPS');
9917:
9918: IF lv_return <> 0 THEN
9919: RAISE ex_logging_err;
9920: END IF;

Line 9925: ' UPDATE msc_st_groups '

9921:
9922: --Deletion is not allowed on this table.
9923: v_sql_stmt := 57;
9924: lv_sql_stmt :=
9925: ' UPDATE msc_st_groups '
9926: ||' SET process_flag ='||G_ERROR_FLG||','
9927: ||' error_text = '||''''||lv_message_text||''''
9928: ||' WHERE deleted_flag = '||SYS_YES
9929: ||' AND process_flag = '||G_IN_PROCESS

Line 9961: (p_table_name => 'MSC_ST_GROUPS',

9957: lv_where_str :=
9958: ' AND NVL(deleted_flag,'||NULL_VALUE||') NOT IN(1,2)';
9959:
9960: lv_return := MSC_ST_util.LOG_ERROR
9961: (p_table_name => 'MSC_ST_GROUPS',
9962: p_instance_code => v_instance_code,
9963: p_row => lv_column_names,
9964: p_severity => G_SEV_WARNING,
9965: p_message_text => lv_message_text,

Line 9997: 'UPDATE msc_st_groups '

9993:
9994: v_sql_stmt := 58;
9995:
9996: lv_sql_Stmt:=
9997: 'UPDATE msc_st_groups '
9998: ||' SET process_flag ='||G_ERROR_FLG||','
9999: ||' error_text = '||''''||lv_message_text||''''
10000: ||' WHERE NVL(group_type,'||NULL_VALUE||') NOT IN (1,2) '
10001: ||' AND sr_instance_code = :v_instance_code'

Line 10036: ' UPDATE MSC_ST_GROUPS '

10032:
10033: v_sql_stmt := 59;
10034:
10035: lv_sql_stmt :=
10036: ' UPDATE MSC_ST_GROUPS '
10037: ||' SET process_flag = '||G_ERROR_FLG||','
10038: ||' error_text = '||''''||lv_message_text||''''
10039: ||' WHERE (effective_date IS NULL '
10040: ||' OR group_name IS NULL '

Line 10069: ' UPDATE MSC_ST_GROUPS '

10065:
10066: v_sql_stmt := 60;
10067:
10068: lv_sql_stmt :=
10069: ' UPDATE MSC_ST_GROUPS '
10070: ||' SET process_flag = '||G_ERROR_FLG||','
10071: ||' error_text = '||''''||lv_message_text||''''
10072: ||' WHERE effective_date > disable_date'
10073: ||' AND disable_date IS NOT NULL'

Line 10091: 'UPDATE msc_st_groups msg'

10087: --Derive contact_user_id
10088:
10089: v_sql_stmt := 61;
10090: lv_sql_stmt :=
10091: 'UPDATE msc_st_groups msg'
10092: ||' SET contact_user_id = (select user_id '
10093: ||' from fnd_user fu'
10094: ||' where UPPER(fu.user_name) = UPPER(msg.contact_user_name)) '
10095: ||' WHERE contact_user_name IS NOT NULL'

Line 10126: 'UPDATE MSC_ST_GROUPS '

10122: -- Update the record as errored out record
10123:
10124: v_sql_stmt := 62;
10125: lv_sql_stmt :=
10126: 'UPDATE MSC_ST_GROUPS '
10127: ||' SET process_flag = '||G_ERROR_FLG||','
10128: ||' error_text = '||''''||lv_message_text||''''
10129: ||' WHERE contact_user_name IS NOT NULL '
10130: ||' AND contact_user_id IS NULL '

Line 10145: (p_table_name =>'MSC_ST_GROUPS',

10141:
10142: --DERIVE GROUP_ID
10143:
10144: lv_return := MSC_ST_util.DERIVE_GROUP_ID
10145: (p_table_name =>'MSC_ST_GROUPS',
10146: p_grp_col_name => 'GROUP_NAME',
10147: p_grp_col_id => 'GROUP_ID',
10148: p_instance_code => v_instance_code,
10149: p_instance_id => v_instance_id,

Line 10177: 'UPDATE MSC_ST_GROUPS msg'

10173: END IF;
10174:
10175: v_sql_stmt := 63;
10176: lv_sql_stmt :=
10177: 'UPDATE MSC_ST_GROUPS msg'
10178: ||' SET process_flag = '||G_ERROR_FLG||','
10179: ||' error_text = '||''''||lv_message_text||''''
10180: ||' WHERE EXISTS(SELECT 1 '
10181: ||' FROM MSC_GROUPS mg'

Line 10205: pEntityName => 'MSC_ST_GROUPS',

10201: (ERRBUF => lv_error_text,
10202: RETCODE => lv_return,
10203: pBatchID => lv_batch_id,
10204: pInstanceCode => v_instance_code,
10205: pEntityName => 'MSC_ST_GROUPS',
10206: pInstanceID => v_instance_id);
10207:
10208: IF NVL(lv_return,0) <> 0 THEN
10209: RAISE ex_logging_err;

Line 10220: UPDATE MSC_ST_GROUPS

10216:
10217: IF c10%ROWCOUNT > 0 THEN
10218: v_sql_stmt := 64;
10219: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
10220: UPDATE MSC_ST_GROUPS
10221: SET group_id = msc_st_group_id_s.NEXTVAL
10222: WHERE rowid = lb_rowid(j);
10223:
10224: v_sql_stmt := 65;

Line 10248: FROM MSC_ST_GROUPS

10244: v_current_date,
10245: v_current_user,
10246: v_current_date,
10247: v_current_user
10248: FROM MSC_ST_GROUPS
10249: WHERE rowid = lb_rowid(j);
10250:
10251: END IF;
10252: CLOSE c10 ;

Line 10258: (p_table_name => 'MSC_ST_GROUPS',

10254:
10255: -- Set the process flag as Valid and derive sr_instance_id
10256:
10257: lv_return := MSC_ST_util.SET_PROCESS_FLAG
10258: (p_table_name => 'MSC_ST_GROUPS',
10259: p_instance_id => v_instance_id,
10260: p_instance_code => v_instance_code,
10261: p_process_flag => G_VALID,
10262: p_error_text => lv_error_text,

Line 10273: (p_table_name => 'MSC_ST_GROUPS',

10269:
10270: -- Inserting all the errored out records into MSC_ERRORS
10271:
10272: lv_return := MSC_ST_util.LOG_ERROR
10273: (p_table_name => 'MSC_ST_GROUPS',
10274: p_instance_code => v_instance_code,
10275: p_row => lv_column_names,
10276: p_severity => G_SEV_ERROR,
10277: p_error_text => lv_error_text,

Line 10421: ||' FROM MSC_ST_GROUPS msg'

10417: ||' ATTRIBUTE12 ,'
10418: ||' ATTRIBUTE13 ,'
10419: ||' ATTRIBUTE14 ,'
10420: ||' ATTRIBUTE15 '
10421: ||' FROM MSC_ST_GROUPS msg'
10422: ||' WHERE sr_instance_code = :sr_instance_code'
10423: ||' AND batch_id = :lv_batch_id'
10424: ||' AND process_flag = '||G_VALID
10425: ||' AND NOT EXISTS( SELECT 1 '

Line 10769: ||' FROM msc_st_groups ms'

10765: ||' where mg.group_owner_id = msg.posting_party_id '
10766: ||' AND mg.group_id = msg.group_id '
10767: ||' UNION '
10768: ||' SELECT 1 '
10769: ||' FROM msc_st_groups ms'
10770: ||' where ms.group_owner_id = msg.posting_party_id '
10771: ||' AND ms.group_id = msg.group_id '
10772: ||' AND ms.process_flag = '||G_VALID ||')'
10773: ||' AND batch_id = :lv_batch_id'

Line 51018: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_GROUPS',p_company_name_col => FALSE);

51014: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_SUB_INVENTORIES');
51015: IF lv_count > 0 Then
51016: prec.sub_inventory_flag:= SYS_YES;
51017: End IF;
51018: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_GROUPS',p_company_name_col => FALSE);
51019: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_GROUP_COMPANIES');
51020: END IF;
51021:
51022: IF v_dmd_class_enabled = SYS_YES THEN