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_INTERORG_SHIP_METHODS

Line 1268: ||' on MSC_ST_INTERORG_SHIP_METHODS '

1264: application_short_name => 'MSC',
1265: statement_type => AD_DDL.CREATE_INDEX,
1266: statement =>
1267: 'create index MSC_ST_INTERORG_SHIP_N1_'||v_instance_code
1268: ||' on MSC_ST_INTERORG_SHIP_METHODS '
1269: ||'(sr_instance_code,from_organization_code,to_organization_code,ship_method,company_name) '
1270: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1271: object_name =>'MSC_ST_INTERORG_SHIP_N1_'||v_instance_code);
1272:

Line 1280: msc_analyse_tables_pk.analyse_table( 'MSC_ST_INTERORG_SHIP_METHODS', v_instance_id, -1);

1276: WHEN OTHERS THEN
1277: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_INTERORG_SHIP_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1278: END;
1279:
1280: msc_analyse_tables_pk.analyse_table( 'MSC_ST_INTERORG_SHIP_METHODS', v_instance_id, -1);
1281:
1282: END IF;
1283:
1284: IF v_sourcing_enabled = SYS_YES THEN

Line 12519: | methods for table MSC_ST_INTERORG_SHIP_METHODS |

12515:
12516:
12517: /*==========================================================================+
12518: | DESCRIPTION : This procedure validates the data for inter org shipping |
12519: | methods for table MSC_ST_INTERORG_SHIP_METHODS |
12520: +==========================================================================*/
12521: PROCEDURE LOAD_SHIP_METHODS IS
12522:
12523: TYPE RowidTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;

Line 12537: FROM msc_st_interorg_ship_methods

12533: ex_logging_err EXCEPTION;
12534:
12535: CURSOR c1(p_batch_id NUMBER) IS
12536: SELECT rowid
12537: FROM msc_st_interorg_ship_methods
12538: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
12539: AND sr_instance_code = v_instance_code
12540: AND batch_id = p_batch_id;
12541:

Line 12562: 'UPDATE msc_st_interorg_ship_methods msis1 '

12558: --whereas in batch load we cannot.
12559:
12560: v_sql_stmt := 01;
12561: lv_sql_stmt :=
12562: 'UPDATE msc_st_interorg_ship_methods msis1 '
12563: ||' SET process_flag = '||G_ERROR_FLG||','
12564: ||' error_text = '||''''||lv_message_text||''''
12565: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_interorg_ship_methods msis2 '
12566: ||' WHERE msis2.sr_instance_code = msis1.sr_instance_code'

Line 12565: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_interorg_ship_methods msis2 '

12561: lv_sql_stmt :=
12562: 'UPDATE msc_st_interorg_ship_methods msis1 '
12563: ||' SET process_flag = '||G_ERROR_FLG||','
12564: ||' error_text = '||''''||lv_message_text||''''
12565: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_interorg_ship_methods msis2 '
12566: ||' WHERE msis2.sr_instance_code = msis1.sr_instance_code'
12567: ||' AND NVL(msis2.company_name, '||''''||NULL_CHAR||''''||') = '
12568: ||' NVL(msis1.company_name, '||''''||NULL_CHAR||''''||')'
12569: ||' AND NVL(msis2.from_organization_code, '||''''||NULL_CHAR||''''||') = '

Line 12642: 'UPDATE msc_st_interorg_ship_methods msis1 '

12638:
12639: --Duplicate records check for the records whose source is XML
12640: v_sql_stmt := 02;
12641: lv_sql_stmt :=
12642: 'UPDATE msc_st_interorg_ship_methods msis1 '
12643: ||' SET process_flag = '||G_ERROR_FLG||','
12644: ||' error_text = '||''''||lv_message_text||''''
12645: ||' WHERE message_id < ( SELECT max(message_id) '
12646: ||' FROM msc_st_interorg_ship_methods msis2 '

Line 12646: ||' FROM msc_st_interorg_ship_methods msis2 '

12642: 'UPDATE msc_st_interorg_ship_methods msis1 '
12643: ||' SET process_flag = '||G_ERROR_FLG||','
12644: ||' error_text = '||''''||lv_message_text||''''
12645: ||' WHERE message_id < ( SELECT max(message_id) '
12646: ||' FROM msc_st_interorg_ship_methods msis2 '
12647: ||' WHERE msis2.sr_instance_code = msis1.sr_instance_code'
12648: ||' AND NVL(msis2.company_name, '||''''||NULL_CHAR||''''||') = '
12649: ||' NVL(msis1.company_name, '||''''||NULL_CHAR||''''||')'
12650: ||' AND NVL(msis2.from_organization_code, '||''''||NULL_CHAR||''''||') = '

Line 12738: 'UPDATE msc_st_interorg_ship_methods '

12734: FROM DUAL;
12735:
12736: v_sql_stmt := 04;
12737: lv_sql_stmt :=
12738: 'UPDATE msc_st_interorg_ship_methods '
12739: ||' SET batch_id = :lv_batch_id '
12740: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
12741: ||' AND sr_instance_code = :v_instance_code'
12742: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 12760: UPDATE msc_st_interorg_ship_methods

12756: CLOSE c1;
12757:
12758: v_sql_stmt := 05;
12759: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
12760: UPDATE msc_st_interorg_ship_methods
12761: SET st_transaction_id = msc_st_interorg_ship_methods_s.NEXTVAL,
12762: refresh_id = v_refresh_id,
12763: last_update_date = v_current_date,
12764: last_updated_by = v_current_user,

Line 12761: SET st_transaction_id = msc_st_interorg_ship_methods_s.NEXTVAL,

12757:
12758: v_sql_stmt := 05;
12759: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
12760: UPDATE msc_st_interorg_ship_methods
12761: SET st_transaction_id = msc_st_interorg_ship_methods_s.NEXTVAL,
12762: refresh_id = v_refresh_id,
12763: last_update_date = v_current_date,
12764: last_updated_by = v_current_user,
12765: creation_date = v_current_date,

Line 12775: p_token_value1 => 'MSC_ST_INTERORG_SHIP_METHODS');

12771: p_error_code => 'MSC_PP_NO_DELETION',
12772: p_message_text => lv_message_text,
12773: p_error_text => lv_error_text,
12774: p_token1 => 'TABLE_NAME',
12775: p_token_value1 => 'MSC_ST_INTERORG_SHIP_METHODS');
12776:
12777:
12778: -- Deletion is not allowed for this table
12779: v_sql_stmt := 06;

Line 12781: 'UPDATE msc_st_interorg_ship_methods '

12777:
12778: -- Deletion is not allowed for this table
12779: v_sql_stmt := 06;
12780: lv_sql_stmt :=
12781: 'UPDATE msc_st_interorg_ship_methods '
12782: ||' SET process_flag = '||G_ERROR_FLG||','
12783: ||' error_text = '||''''||lv_message_text||''''
12784: ||' WHERE deleted_flag = '||SYS_YES
12785: ||' AND process_flag = '||G_IN_PROCESS

Line 12819: (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS',

12815: lv_where_str := ' AND NVL(deleted_flag,'||NULL_VALUE||') '
12816: ||' NOT IN(1,2)';
12817:
12818: lv_return := MSC_ST_UTIL.LOG_ERROR
12819: (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS',
12820: p_instance_code => v_instance_code,
12821: p_row => lv_column_names,
12822: p_severity => G_SEV_WARNING,
12823: p_message_text => lv_message_text,

Line 12850: 'UPDATE msc_st_interorg_ship_methods'

12846:
12847: -- Error out records where ship_method is NULL
12848: v_sql_stmt := 07;
12849: lv_sql_stmt :=
12850: 'UPDATE msc_st_interorg_ship_methods'
12851: ||' SET process_flag = '||G_ERROR_FLG||','
12852: ||' error_text = '||''''||lv_message_text||''''
12853: ||' WHERE NVL(ship_method, '||''''||NULL_CHAR||''''||') '
12854: ||' = '||''''||NULL_CHAR||''''

Line 12882: (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS',

12878:
12879: -- Derive from_organization_id
12880:
12881: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
12882: (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS',
12883: p_org_partner_name => 'FROM_ORGANIZATION_CODE',
12884: p_org_partner_id => 'FROM_ORGANIZATION_ID',
12885: p_instance_code => v_instance_code,
12886: p_partner_type => G_ORGANIZATION,

Line 12898: 'UPDATE msc_st_interorg_ship_methods '

12894: RAISE ex_logging_err;
12895: END IF;
12896:
12897: lv_sql_stmt :=
12898: 'UPDATE msc_st_interorg_ship_methods '
12899: ||' SET FROM_ORGANIZATION_ID = -1 '
12900: ||' WHERE NVL(FROM_ORGANIZATION_ID,'||NULL_VALUE||') = '||NULL_VALUE
12901: ||' AND NVL(FROM_ORGANIZATION_CODE,'||''''||NULL_CHAR||''''||')'
12902: ||' = '||''''||NULL_CHAR||''''

Line 12932: (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS',

12928:
12929: -- Derive to_organization_id
12930:
12931: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
12932: (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS',
12933: p_org_partner_name => 'TO_ORGANIZATION_CODE',
12934: p_org_partner_id => 'TO_ORGANIZATION_ID',
12935: p_instance_code => v_instance_code,
12936: p_partner_type => G_ORGANIZATION,

Line 12948: 'UPDATE msc_st_interorg_ship_methods '

12944: RAISE ex_logging_err;
12945: END IF;
12946:
12947: lv_sql_stmt :=
12948: 'UPDATE msc_st_interorg_ship_methods '
12949: ||' SET TO_ORGANIZATION_ID = -1 '
12950: ||' WHERE NVL(TO_ORGANIZATION_ID,'||NULL_VALUE||') = '||NULL_VALUE
12951: ||' AND NVL(TO_ORGANIZATION_CODE,'||''''||NULL_CHAR||''''||')'
12952: ||' = '||''''||NULL_CHAR||''''

Line 12968: 'UPDATE msc_st_interorg_ship_methods msis'

12964:
12965: -- Update FROM_LOCATION_ID
12966: v_sql_stmt := 08;
12967: lv_sql_stmt :=
12968: 'UPDATE msc_st_interorg_ship_methods msis'
12969: ||' SET from_location_id = (SELECT local_id'
12970: ||' FROM msc_local_id_setup mls'
12971: ||' WHERE mls.char1 = msis.sr_instance_code'
12972: ||' AND mls.char3 = msis.from_location_code'

Line 12990: 'UPDATE msc_st_interorg_ship_methods msis'

12986: -- Update TO_LOCATION_ID
12987:
12988: v_sql_stmt := 09;
12989: lv_sql_stmt :=
12990: 'UPDATE msc_st_interorg_ship_methods msis'
12991: ||' SET to_location_id = (SELECT local_id'
12992: ||' FROM msc_local_id_setup mls'
12993: ||' WHERE mls.char1 = msis.sr_instance_code'
12994: ||' AND mls.char3 = msis.to_location_code'

Line 13025: 'UPDATE msc_st_interorg_ship_methods '

13021: END IF;
13022:
13023: v_sql_stmt := 9.1;
13024: lv_sql_stmt :=
13025: 'UPDATE msc_st_interorg_ship_methods '
13026: ||' SET error_text = '||''''||lv_error_text||''''||','
13027: ||' process_flag = '||G_ERROR
13028: ||' WHERE NVL(to_location_id,'||NULL_VALUE||') = '||NULL_VALUE
13029: ||' AND NVL(to_location_code,'||''''||NULL_CHAR||''''||')'

Line 13058: 'UPDATE msc_st_interorg_ship_methods '

13054: END IF;
13055:
13056: v_sql_stmt := 9.2;
13057: lv_sql_stmt :=
13058: 'UPDATE msc_st_interorg_ship_methods '
13059: ||' SET error_text = '||''''||lv_error_text||''''||','
13060: ||' process_flag = '||G_ERROR
13061: ||' WHERE NVL(from_location_id,'||NULL_VALUE||') = '||NULL_VALUE
13062: ||' AND NVL(from_location_code,'||''''||NULL_CHAR||''''||')'

Line 13077: 'UPDATE msc_st_interorg_ship_methods '

13073: USING lv_batch_id,
13074: v_instance_code;
13075:
13076: lv_sql_stmt :=
13077: 'UPDATE msc_st_interorg_ship_methods '
13078: ||' SET from_location_id = -1'
13079: ||' WHERE NVL(from_location_id,'||NULL_VALUE||') = '||NULL_VALUE
13080: ||' AND NVL(from_location_code,'||''''||NULL_CHAR||''''||')'
13081: ||' = '||''''||NULL_CHAR||''''

Line 13095: 'UPDATE msc_st_interorg_ship_methods '

13091: USING lv_batch_id,
13092: v_instance_code;
13093:
13094: lv_sql_stmt :=
13095: 'UPDATE msc_st_interorg_ship_methods '
13096: ||' SET to_location_id = -1'
13097: ||' WHERE NVL(to_location_id,'||NULL_VALUE||') = '||NULL_VALUE
13098: ||' AND NVL(to_location_code,'||''''||NULL_CHAR||''''||')'
13099: ||' = '||''''||NULL_CHAR||''''

Line 13115: 'UPDATE msc_st_interorg_ship_methods msr'

13111:
13112: -- Derive from_region_id
13113:
13114: lv_sql_stmt :=
13115: 'UPDATE msc_st_interorg_ship_methods msr'
13116: ||' SET from_region_id = (SELECT local_id'
13117: ||' FROM msc_local_id_setup mls'
13118: ||' WHERE mls.char1 = msr.sr_instance_code'
13119: ||' AND mls.number1 = nvl(msr.from_region_type,'||NULL_VALUE||')'

Line 13154: 'UPDATE msc_st_interorg_ship_methods msr'

13150:
13151: -- Derive to_region_id
13152:
13153: lv_sql_stmt :=
13154: 'UPDATE msc_st_interorg_ship_methods msr'
13155: ||' SET to_region_id = (SELECT local_id'
13156: ||' FROM msc_local_id_setup mls'
13157: ||' WHERE mls.char1 = msr.sr_instance_code'
13158: ||' AND mls.number1 = nvl(msr.to_region_type,'||NULL_VALUE||')'

Line 13215: 'UPDATE msc_st_interorg_ship_methods msis1'

13211:
13212:
13213: v_sql_stmt := 9.1;
13214: lv_sql_stmt :=
13215: 'UPDATE msc_st_interorg_ship_methods msis1'
13216: ||' SET process_flag = '||G_ERROR_FLG||','
13217: ||' error_text = '||''''||lv_message_text||''''
13218: ||' WHERE (msis1.to_location_id is NULL OR msis1.from_location_id is NULL) '
13219: ||' AND (msis1.to_organization_id is NULL OR msis1.from_organization_id is NULL) '

Line 13249: (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS',

13245: lv_where_str := ' AND NVL(default_flag,'||NULL_VALUE||') '
13246: ||' NOT IN(1,2)';
13247:
13248: lv_return := MSC_ST_UTIL.LOG_ERROR
13249: (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS',
13250: p_instance_code => v_instance_code,
13251: p_row => lv_column_names,
13252: p_severity => G_SEV_WARNING,
13253: p_message_text => lv_message_text,

Line 13286: 'UPDATE msc_st_interorg_ship_methods msis1'

13282: -- forward ported 2767559
13283:
13284: v_sql_stmt := 12;
13285: lv_sql_stmt :=
13286: 'UPDATE msc_st_interorg_ship_methods msis1'
13287: ||' SET process_flag = '||G_ERROR_FLG||','
13288: ||' error_text = '||''''||lv_message_text||''''
13289: ||' WHERE EXISTS( SELECT 1 '
13290: ||' FROM msc_st_interorg_ship_methods msis2'

Line 13290: ||' FROM msc_st_interorg_ship_methods msis2'

13286: 'UPDATE msc_st_interorg_ship_methods msis1'
13287: ||' SET process_flag = '||G_ERROR_FLG||','
13288: ||' error_text = '||''''||lv_message_text||''''
13289: ||' WHERE EXISTS( SELECT 1 '
13290: ||' FROM msc_st_interorg_ship_methods msis2'
13291: ||' WHERE msis2.sr_instance_code = msis1.sr_instance_code'
13292: ||' AND nvl(msis2.from_organization_code, '||''''||NULL_CHAR||''''||') = '
13293: ||' nvl(msis1.from_organization_code, '||''''||NULL_CHAR||''''||')'
13294: ||' AND nvl(msis2.to_organization_code, '||''''||NULL_CHAR||''''||') = '

Line 13353: MSC_ST_UTIL.VALIDATE_UOM (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS',

13349:
13350: -- Validate Volume UOM
13351:
13352: lv_return :=
13353: MSC_ST_UTIL.VALIDATE_UOM (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS',
13354: p_uom_col_name => 'VOLUME_UOM',
13355: p_instance_id => v_instance_id,
13356: p_instance_code => v_instance_code,
13357: p_severity => G_SEV3_ERROR,

Line 13382: MSC_ST_UTIL.VALIDATE_UOM (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS',

13378:
13379: -- Validate Weight UOM
13380:
13381: lv_return :=
13382: MSC_ST_UTIL.VALIDATE_UOM (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS',
13383: p_uom_col_name => 'WEIGHT_UOM',
13384: p_instance_id => v_instance_id,
13385: p_instance_code => v_instance_code,
13386: p_severity => G_SEV3_ERROR,

Line 13403: pEntityName => 'MSC_ST_INTERORG_SHIP_METHODS',

13399: (ERRBUF => lv_error_text,
13400: RETCODE => lv_return,
13401: pBatchID => lv_batch_id,
13402: pInstanceCode => v_instance_code,
13403: pEntityName => 'MSC_ST_INTERORG_SHIP_METHODS',
13404: pInstanceID => v_instance_id);
13405:
13406: IF NVL(lv_return,0) <> 0 THEN
13407: RAISE ex_logging_err;

Line 13412: (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS',

13408: END IF;
13409:
13410:
13411: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
13412: (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS',
13413: p_instance_id => v_instance_id,
13414: p_instance_code => v_instance_code,
13415: p_process_flag => G_VALID,
13416: p_error_text => lv_error_text,

Line 13426: 'UPDATE msc_st_interorg_ship_methods'

13422: END IF;
13423:
13424: v_sql_stmt := 13;
13425: lv_sql_stmt :=
13426: 'UPDATE msc_st_interorg_ship_methods'
13427: ||' SET sr_instance_id2 = '||v_instance_id
13428: ||' WHERE sr_instance_code = :v_instance_code'
13429: ||' AND process_flag ='|| G_VALID
13430: ||' AND batch_id = :lv_batch_id' ;

Line 13439: (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS',

13435:
13436: EXECUTE IMMEDIATE lv_sql_stmt USING v_instance_code,lv_batch_id;
13437:
13438: lv_return := MSC_ST_UTIL.LOG_ERROR
13439: (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS',
13440: p_instance_code => v_instance_code,
13441: p_row => lv_column_names,
13442: p_severity => G_SEV_ERROR,
13443: p_message_text => NULL,

Line 50911: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS');

50907: End IF;
50908: END IF;
50909:
50910: IF v_ship_mthd_enabled = SYS_YES THEN
50911: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS');
50912: IF lv_count > 0 Then
50913: prec.sourcing_rule_flag:= SYS_YES;
50914: End IF;
50915: END IF;