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 1175: --Added for MSC_ST_GROUPS

1171: 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));
1172: END;
1173:
1174: --For Aeroexchange
1175: --Added for MSC_ST_GROUPS
1176: BEGIN
1177: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1178: application_short_name => 'MSC',
1179: statement_type => AD_DDL.CREATE_INDEX,

Line 1181: 'create index MSC_ST_GROUPS_N1_'||v_instance_code

1177: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1178: application_short_name => 'MSC',
1179: statement_type => AD_DDL.CREATE_INDEX,
1180: statement =>
1181: 'create index MSC_ST_GROUPS_N1_'||v_instance_code
1182: ||' on MSC_ST_GROUPS '
1183: ||'(GROUP_NAME) '
1184: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1185: object_name =>'MSC_ST_GROUPS_N1_'||v_instance_code);

Line 1182: ||' on MSC_ST_GROUPS '

1178: application_short_name => 'MSC',
1179: statement_type => AD_DDL.CREATE_INDEX,
1180: statement =>
1181: 'create index MSC_ST_GROUPS_N1_'||v_instance_code
1182: ||' on MSC_ST_GROUPS '
1183: ||'(GROUP_NAME) '
1184: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1185: object_name =>'MSC_ST_GROUPS_N1_'||v_instance_code);
1186:

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

1181: 'create index MSC_ST_GROUPS_N1_'||v_instance_code
1182: ||' on MSC_ST_GROUPS '
1183: ||'(GROUP_NAME) '
1184: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1185: object_name =>'MSC_ST_GROUPS_N1_'||v_instance_code);
1186:
1187: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_GROUPS_N1_'||v_instance_code);
1188:
1189: msc_analyse_tables_pk.analyse_table( 'MSC_ST_GROUPS', v_instance_id, -1);

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

1183: ||'(GROUP_NAME) '
1184: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1185: object_name =>'MSC_ST_GROUPS_N1_'||v_instance_code);
1186:
1187: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_GROUPS_N1_'||v_instance_code);
1188:
1189: msc_analyse_tables_pk.analyse_table( 'MSC_ST_GROUPS', v_instance_id, -1);
1190:
1191: EXCEPTION

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

1185: object_name =>'MSC_ST_GROUPS_N1_'||v_instance_code);
1186:
1187: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_GROUPS_N1_'||v_instance_code);
1188:
1189: msc_analyse_tables_pk.analyse_table( 'MSC_ST_GROUPS', v_instance_id, -1);
1190:
1191: EXCEPTION
1192: WHEN OTHERS THEN
1193: 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 1193: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_GROUPS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

1189: msc_analyse_tables_pk.analyse_table( 'MSC_ST_GROUPS', v_instance_id, -1);
1190:
1191: EXCEPTION
1192: WHEN OTHERS THEN
1193: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_GROUPS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1194: END;
1195:
1196: BEGIN
1197: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

Line 2399: ---- Drop index of MSC_ST_GROUPS

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
2400: BEGIN
2401: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2402: application_short_name => 'MSC',
2403: statement_type => AD_DDL.DROP_INDEX,

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

2401: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2402: application_short_name => 'MSC',
2403: statement_type => AD_DDL.DROP_INDEX,
2404: statement =>
2405: 'drop index MSC_ST_GROUPS_N1_'||v_instance_code,
2406: object_name => 'MSC_ST_GROUPS_N1_'||v_instance_code);
2407:
2408: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_GROUPS_N1_'||v_instance_code);
2409:

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

2402: application_short_name => 'MSC',
2403: statement_type => AD_DDL.DROP_INDEX,
2404: statement =>
2405: 'drop index MSC_ST_GROUPS_N1_'||v_instance_code,
2406: object_name => 'MSC_ST_GROUPS_N1_'||v_instance_code);
2407:
2408: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_GROUPS_N1_'||v_instance_code);
2409:
2410: EXCEPTION

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

2404: statement =>
2405: 'drop index MSC_ST_GROUPS_N1_'||v_instance_code,
2406: object_name => 'MSC_ST_GROUPS_N1_'||v_instance_code);
2407:
2408: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_GROUPS_N1_'||v_instance_code);
2409:
2410: EXCEPTION
2411: WHEN OTHERS THEN
2412: 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 2412: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_GROUPS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

2408: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_GROUPS_N1_'||v_instance_code);
2409:
2410: EXCEPTION
2411: WHEN OTHERS THEN
2412: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_GROUPS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2413: END;
2414:
2415:
2416: END IF;

Line 6333: FROM MSC_ST_GROUPS

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

Line 6340: FROM MSC_ST_GROUPS

6336: AND sr_instance_code = v_instance_code;
6337:
6338: CURSOR c10(p_batch_id NUMBER) IS
6339: SELECT rowid
6340: FROM MSC_ST_GROUPS
6341: WHERE process_flag = G_IN_PROCESS
6342: AND sr_instance_code = v_instance_code
6343: AND batch_id = p_batch_id
6344: AND NVL(group_id,NULL_VALUE) = NULL_VALUE;

Line 6376: FROM msc_st_groups msg,msc_groups mg

6372: msg.ATTRIBUTE12,
6373: msg.ATTRIBUTE13,
6374: msg.ATTRIBUTE14,
6375: msg.ATTRIBUTE15
6376: FROM msc_st_groups msg,msc_groups mg
6377: WHERE msg.process_flag = G_VALID
6378: AND msg.sr_instance_code = v_instance_code
6379: AND msg.batch_id = p_batch_id
6380: AND msg.group_id = mg.group_id;

Line 9913: ' UPDATE MSC_ST_GROUPS msu1'

9909:
9910: --Duplicate records check for the records whose source is XML
9911: v_sql_stmt := 52;
9912: lv_sql_stmt :=
9913: ' UPDATE MSC_ST_GROUPS msu1'
9914: ||' SET process_flag = '||G_ERROR_FLG||','
9915: ||' error_text = '||''''||lv_message_text||''''
9916: ||' WHERE message_id < (SELECT MAX(message_id)'
9917: ||' FROM MSC_ST_GROUPS msu2'

Line 9917: ||' FROM MSC_ST_GROUPS msu2'

9913: ' UPDATE MSC_ST_GROUPS msu1'
9914: ||' SET process_flag = '||G_ERROR_FLG||','
9915: ||' error_text = '||''''||lv_message_text||''''
9916: ||' WHERE message_id < (SELECT MAX(message_id)'
9917: ||' FROM MSC_ST_GROUPS msu2'
9918: ||' where msu2.group_name = msu1.group_name '
9919: ||' AND msu2.process_flag <> '||G_ERROR_FLG
9920: ||' AND NVL(msu2.message_id,'||NULL_VALUE||')<>'||NULL_VALUE||')'
9921: ||' AND msu1.process_flag = '||G_IN_PROCESS

Line 9947: ' UPDATE MSC_ST_GROUPS msu1'

9943: --whereas in batch load we cannot.
9944:
9945: v_sql_stmt := 53;
9946: lv_sql_stmt :=
9947: ' UPDATE MSC_ST_GROUPS msu1'
9948: ||' SET process_flag = '||G_ERROR_FLG||','
9949: ||' error_text = '||''''||lv_message_text||''''
9950: ||' WHERE EXISTS( SELECT 1 '
9951: ||' FROM MSC_ST_GROUPS msu2'

Line 9951: ||' FROM MSC_ST_GROUPS msu2'

9947: ' UPDATE MSC_ST_GROUPS msu1'
9948: ||' SET process_flag = '||G_ERROR_FLG||','
9949: ||' error_text = '||''''||lv_message_text||''''
9950: ||' WHERE EXISTS( SELECT 1 '
9951: ||' FROM MSC_ST_GROUPS msu2'
9952: ||' WHERE msu2.group_name = msu1.group_name'
9953: ||' AND msu2.process_flag <> '||G_ERROR_FLG
9954: ||' AND NVL(msu2.message_id,'||NULL_VALUE||') = '||NULL_VALUE
9955: ||' AND msu2.rowid <> msu1.rowid)'

Line 10003: ' UPDATE MSC_ST_GROUPS '

9999: FROM dual;
10000:
10001: v_sql_stmt := 55;
10002: lv_sql_stmt :=
10003: ' UPDATE MSC_ST_GROUPS '
10004: ||' SET batch_id = :lv_batch_id'
10005: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
10006: ||' AND sr_instance_code = :v_instance_code'
10007: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 10027: UPDATE MSC_ST_GROUPS

10023: CLOSE c9;
10024:
10025: v_sql_stmt := 56;
10026: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
10027: UPDATE MSC_ST_GROUPS
10028: SET st_transaction_id = msc_st_groups_s.NEXTVAL,
10029: last_update_date = v_current_date,
10030: last_updated_by = v_current_user,
10031: creation_date = v_current_date,

Line 10028: SET st_transaction_id = msc_st_groups_s.NEXTVAL,

10024:
10025: v_sql_stmt := 56;
10026: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
10027: UPDATE MSC_ST_GROUPS
10028: SET st_transaction_id = msc_st_groups_s.NEXTVAL,
10029: last_update_date = v_current_date,
10030: last_updated_by = v_current_user,
10031: creation_date = v_current_date,
10032: created_by = v_current_user

Line 10042: p_token_value1 => 'MSC_ST_GROUPS');

10038: p_error_code => 'MSC_PP_NO_DELETION',
10039: p_message_text => lv_message_text,
10040: p_error_text => lv_error_text,
10041: p_token1 => 'TABLE_NAME',
10042: p_token_value1 => 'MSC_ST_GROUPS');
10043:
10044: IF lv_return <> 0 THEN
10045: RAISE ex_logging_err;
10046: END IF;

Line 10051: ' UPDATE msc_st_groups '

10047:
10048: --Deletion is not allowed on this table.
10049: v_sql_stmt := 57;
10050: lv_sql_stmt :=
10051: ' UPDATE msc_st_groups '
10052: ||' SET process_flag ='||G_ERROR_FLG||','
10053: ||' error_text = '||''''||lv_message_text||''''
10054: ||' WHERE deleted_flag = '||SYS_YES
10055: ||' AND process_flag = '||G_IN_PROCESS

Line 10087: (p_table_name => 'MSC_ST_GROUPS',

10083: lv_where_str :=
10084: ' AND NVL(deleted_flag,'||NULL_VALUE||') NOT IN(1,2)';
10085:
10086: lv_return := MSC_ST_util.LOG_ERROR
10087: (p_table_name => 'MSC_ST_GROUPS',
10088: p_instance_code => v_instance_code,
10089: p_row => lv_column_names,
10090: p_severity => G_SEV_WARNING,
10091: p_message_text => lv_message_text,

Line 10123: 'UPDATE msc_st_groups '

10119:
10120: v_sql_stmt := 58;
10121:
10122: lv_sql_Stmt:=
10123: 'UPDATE msc_st_groups '
10124: ||' SET process_flag ='||G_ERROR_FLG||','
10125: ||' error_text = '||''''||lv_message_text||''''
10126: ||' WHERE NVL(group_type,'||NULL_VALUE||') NOT IN (1,2) '
10127: ||' AND sr_instance_code = :v_instance_code'

Line 10162: ' UPDATE MSC_ST_GROUPS '

10158:
10159: v_sql_stmt := 59;
10160:
10161: lv_sql_stmt :=
10162: ' UPDATE MSC_ST_GROUPS '
10163: ||' SET process_flag = '||G_ERROR_FLG||','
10164: ||' error_text = '||''''||lv_message_text||''''
10165: ||' WHERE (effective_date IS NULL '
10166: ||' OR group_name IS NULL '

Line 10195: ' UPDATE MSC_ST_GROUPS '

10191:
10192: v_sql_stmt := 60;
10193:
10194: lv_sql_stmt :=
10195: ' UPDATE MSC_ST_GROUPS '
10196: ||' SET process_flag = '||G_ERROR_FLG||','
10197: ||' error_text = '||''''||lv_message_text||''''
10198: ||' WHERE effective_date > disable_date'
10199: ||' AND disable_date IS NOT NULL'

Line 10217: 'UPDATE msc_st_groups msg'

10213: --Derive contact_user_id
10214:
10215: v_sql_stmt := 61;
10216: lv_sql_stmt :=
10217: 'UPDATE msc_st_groups msg'
10218: ||' SET contact_user_id = (select user_id '
10219: ||' from fnd_user fu'
10220: ||' where UPPER(fu.user_name) = UPPER(msg.contact_user_name)) '
10221: ||' WHERE contact_user_name IS NOT NULL'

Line 10252: 'UPDATE MSC_ST_GROUPS '

10248: -- Update the record as errored out record
10249:
10250: v_sql_stmt := 62;
10251: lv_sql_stmt :=
10252: 'UPDATE MSC_ST_GROUPS '
10253: ||' SET process_flag = '||G_ERROR_FLG||','
10254: ||' error_text = '||''''||lv_message_text||''''
10255: ||' WHERE contact_user_name IS NOT NULL '
10256: ||' AND contact_user_id IS NULL '

Line 10271: (p_table_name =>'MSC_ST_GROUPS',

10267:
10268: --DERIVE GROUP_ID
10269:
10270: lv_return := MSC_ST_util.DERIVE_GROUP_ID
10271: (p_table_name =>'MSC_ST_GROUPS',
10272: p_grp_col_name => 'GROUP_NAME',
10273: p_grp_col_id => 'GROUP_ID',
10274: p_instance_code => v_instance_code,
10275: p_instance_id => v_instance_id,

Line 10303: 'UPDATE MSC_ST_GROUPS msg'

10299: END IF;
10300:
10301: v_sql_stmt := 63;
10302: lv_sql_stmt :=
10303: 'UPDATE MSC_ST_GROUPS msg'
10304: ||' SET process_flag = '||G_ERROR_FLG||','
10305: ||' error_text = '||''''||lv_message_text||''''
10306: ||' WHERE EXISTS(SELECT 1 '
10307: ||' FROM MSC_GROUPS mg'

Line 10331: pEntityName => 'MSC_ST_GROUPS',

10327: (ERRBUF => lv_error_text,
10328: RETCODE => lv_return,
10329: pBatchID => lv_batch_id,
10330: pInstanceCode => v_instance_code,
10331: pEntityName => 'MSC_ST_GROUPS',
10332: pInstanceID => v_instance_id);
10333:
10334: IF NVL(lv_return,0) <> 0 THEN
10335: RAISE ex_logging_err;

Line 10346: UPDATE MSC_ST_GROUPS

10342:
10343: IF c10%ROWCOUNT > 0 THEN
10344: v_sql_stmt := 64;
10345: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
10346: UPDATE MSC_ST_GROUPS
10347: SET group_id = msc_st_group_id_s.NEXTVAL
10348: WHERE rowid = lb_rowid(j);
10349:
10350: v_sql_stmt := 65;

Line 10374: FROM MSC_ST_GROUPS

10370: v_current_date,
10371: v_current_user,
10372: v_current_date,
10373: v_current_user
10374: FROM MSC_ST_GROUPS
10375: WHERE rowid = lb_rowid(j);
10376:
10377: END IF;
10378: CLOSE c10 ;

Line 10384: (p_table_name => 'MSC_ST_GROUPS',

10380:
10381: -- Set the process flag as Valid and derive sr_instance_id
10382:
10383: lv_return := MSC_ST_util.SET_PROCESS_FLAG
10384: (p_table_name => 'MSC_ST_GROUPS',
10385: p_instance_id => v_instance_id,
10386: p_instance_code => v_instance_code,
10387: p_process_flag => G_VALID,
10388: p_error_text => lv_error_text,

Line 10399: (p_table_name => 'MSC_ST_GROUPS',

10395:
10396: -- Inserting all the errored out records into MSC_ERRORS
10397:
10398: lv_return := MSC_ST_util.LOG_ERROR
10399: (p_table_name => 'MSC_ST_GROUPS',
10400: p_instance_code => v_instance_code,
10401: p_row => lv_column_names,
10402: p_severity => G_SEV_ERROR,
10403: p_error_text => lv_error_text,

Line 10547: ||' FROM MSC_ST_GROUPS msg'

10543: ||' ATTRIBUTE12 ,'
10544: ||' ATTRIBUTE13 ,'
10545: ||' ATTRIBUTE14 ,'
10546: ||' ATTRIBUTE15 '
10547: ||' FROM MSC_ST_GROUPS msg'
10548: ||' WHERE sr_instance_code = :sr_instance_code'
10549: ||' AND batch_id = :lv_batch_id'
10550: ||' AND process_flag = '||G_VALID
10551: ||' AND NOT EXISTS( SELECT 1 '

Line 10895: ||' FROM msc_st_groups ms'

10891: ||' where mg.group_owner_id = msg.posting_party_id '
10892: ||' AND mg.group_id = msg.group_id '
10893: ||' UNION '
10894: ||' SELECT 1 '
10895: ||' FROM msc_st_groups ms'
10896: ||' where ms.group_owner_id = msg.posting_party_id '
10897: ||' AND ms.group_id = msg.group_id '
10898: ||' AND ms.process_flag = '||G_VALID ||')'
10899: ||' AND batch_id = :lv_batch_id'

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

55936: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_SUB_INVENTORIES');
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