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_CALENDAR_ASSIGNMENTS

Line 1663: ||' on MSC_ST_CALENDAR_ASSIGNMENTS '

1659: application_short_name => 'MSC',
1660: statement_type => AD_DDL.CREATE_INDEX,
1661: statement =>
1662: 'create index MSC_ST_CAL_ASSIGNMENTS_N1_'||v_instance_code
1663: ||' on MSC_ST_CALENDAR_ASSIGNMENTS '
1664: ||'(sr_instance_code,association_type, calendar_code, calendar_type, partner_name, partner_site_code, organization_code, ship_method_code) '
1665: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1666: object_name =>'MSC_ST_CAL_ASSIGNMENTS_N1_'||v_instance_code);
1667:

Line 1675: msc_analyse_tables_pk.analyse_table( 'MSC_ST_CALENDAR_ASSIGNMENTS', v_instance_id, -1);

1671: WHEN OTHERS THEN
1672: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_CAL_ASSIGNMENTS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1673: END;
1674:
1675: msc_analyse_tables_pk.analyse_table( 'MSC_ST_CALENDAR_ASSIGNMENTS', v_instance_id, -1);
1676:
1677: END IF;
1678:
1679:

Line 11233: | table msc_st_calendar_assignments. |

11229: END LOAD_TRADING_PARTNERS ;
11230:
11231: /*==========================================================================+
11232: | DESCRIPTION : This procedure performs validation and loads data into the |
11233: | table msc_st_calendar_assignments. |
11234: +==========================================================================*/
11235:
11236:
11237: PROCEDURE LOAD_CALENDAR_ASSIGNMENTS IS

Line 11245: lv_batch_id msc_st_calendar_assignments.batch_id%TYPE;

11241: lv_error_text VARCHAR2(250);
11242: lv_where_str VARCHAR2(5000);
11243: lv_sql_stmt VARCHAR2(5000);
11244: lv_column_names VARCHAR2(5000);
11245: lv_batch_id msc_st_calendar_assignments.batch_id%TYPE;
11246: lv_message_text msc_errors.error_text%TYPE;
11247:
11248: ex_logging_err EXCEPTION;
11249:

Line 11252: FROM msc_st_calendar_assignments

11248: ex_logging_err EXCEPTION;
11249:
11250: CURSOR c1(p_batch_id NUMBER) IS
11251: SELECT rowid
11252: FROM msc_st_calendar_assignments
11253: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
11254: AND batch_id = p_batch_id
11255: AND sr_instance_code = v_instance_code;
11256:

Line 11273: ' UPDATE msc_st_calendar_assignments msp1'

11269:
11270: --Duplicate records check for the records whose source is XML
11271: v_sql_stmt := 01;
11272: lv_sql_stmt :=
11273: ' UPDATE msc_st_calendar_assignments msp1'
11274: ||' SET process_flag = '||G_ERROR_FLG||','
11275: ||' error_text = '||''''||lv_message_text||''''
11276: ||' WHERE message_id < (SELECT MAX(message_id)'
11277: ||' FROM msc_st_calendar_assignments msp2'

Line 11277: ||' FROM msc_st_calendar_assignments msp2'

11273: ' UPDATE msc_st_calendar_assignments msp1'
11274: ||' SET process_flag = '||G_ERROR_FLG||','
11275: ||' error_text = '||''''||lv_message_text||''''
11276: ||' WHERE message_id < (SELECT MAX(message_id)'
11277: ||' FROM msc_st_calendar_assignments msp2'
11278: ||' WHERE msp2.sr_instance_code = msp1.sr_instance_code'
11279: ||' AND NVL(msp2.company_name, ' ||''''||NULL_CHAR||''''||') = '
11280: ||' NVL(msp1.company_name, ' ||''''||NULL_CHAR||''''||')'
11281: ||' AND NVL(msp2.organization_code, ' ||''''||NULL_CHAR||''''||') = '

Line 11323: ' UPDATE msc_st_calendar_assignments msp1'

11319: --Different SQL is used because in XML we can identify the latest records
11320: --whereas in batch load we cannot.
11321: v_sql_stmt := 02;
11322: lv_sql_stmt :=
11323: ' UPDATE msc_st_calendar_assignments msp1'
11324: ||' SET process_flag = '||G_ERROR_FLG||','
11325: ||' error_text = '||''''||lv_message_text||''''
11326: ||' WHERE EXISTS( SELECT 1 '
11327: ||' FROM msc_st_calendar_assignments msp2'

Line 11327: ||' FROM msc_st_calendar_assignments msp2'

11323: ' UPDATE msc_st_calendar_assignments msp1'
11324: ||' SET process_flag = '||G_ERROR_FLG||','
11325: ||' error_text = '||''''||lv_message_text||''''
11326: ||' WHERE EXISTS( SELECT 1 '
11327: ||' FROM msc_st_calendar_assignments msp2'
11328: ||' WHERE msp2.sr_instance_code = msp1.sr_instance_code'
11329: ||' AND NVL(msp2.company_name, ' ||''''||NULL_CHAR||''''||') = '
11330: ||' NVL(msp1.company_name, ' ||''''||NULL_CHAR||''''||')'
11331: ||' AND NVL(msp2.organization_code, ' ||''''||NULL_CHAR||''''||') = '

Line 11378: 'UPDATE msc_st_calendar_assignments '

11374: FROM dual;
11375:
11376: v_sql_stmt := 04;
11377: lv_sql_stmt :=
11378: 'UPDATE msc_st_calendar_assignments '
11379: ||' SET batch_id = :lv_batch_id'
11380: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
11381: ||' AND sr_instance_code = :v_instance_code'
11382: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 11400: UPDATE msc_st_calendar_assignments

11396: CLOSE c1;
11397:
11398: v_sql_stmt := 05;
11399: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
11400: UPDATE msc_st_calendar_assignments
11401: SET st_transaction_id = msc_st_calendar_assignments_s.NEXTVAL,
11402: refresh_id = v_refresh_id,
11403: last_update_date = v_current_date,
11404: last_updated_by = v_current_user,

Line 11401: SET st_transaction_id = msc_st_calendar_assignments_s.NEXTVAL,

11397:
11398: v_sql_stmt := 05;
11399: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
11400: UPDATE msc_st_calendar_assignments
11401: SET st_transaction_id = msc_st_calendar_assignments_s.NEXTVAL,
11402: refresh_id = v_refresh_id,
11403: last_update_date = v_current_date,
11404: last_updated_by = v_current_user,
11405: creation_date = v_current_date,

Line 11431: (p_table_name => 'MSC_ST_CALENDAR_ASSIGNMENTS',

11427: ||' NOT IN(1,2)';
11428: --Log a warning for those records where the deleted_flag has a value other
11429: --than SYS_NO
11430: lv_return := MSC_ST_UTIL.LOG_ERROR
11431: (p_table_name => 'MSC_ST_CALENDAR_ASSIGNMENTS',
11432: p_instance_code => v_instance_code,
11433: p_row => lv_column_names,
11434: p_severity => G_SEV_WARNING,
11435: p_message_text => lv_message_text,

Line 11460: 'UPDATE msc_st_calendar_assignments '

11456: RAISE ex_logging_err;
11457: END IF;
11458:
11459: lv_sql_stmt :=
11460: 'UPDATE msc_st_calendar_assignments '
11461: ||' SET process_flag = '||G_ERROR_FLG||','
11462: ||' error_text = '||''''||lv_message_text||''''
11463: ||' WHERE NVL(calendar_type,'||''''||NULL_CHAR||''''||') '
11464: ||' NOT IN(''RECEIVING'',''SHIPPING'', ''CARRIER'' )'

Line 11492: 'UPDATE msc_st_calendar_assignments '

11488:
11489: -- error out the records where association_type is not correct
11490:
11491: lv_sql_stmt :=
11492: 'UPDATE msc_st_calendar_assignments '
11493: ||' SET process_flag = '||G_ERROR_FLG||','
11494: ||' error_text = '||''''||lv_message_text||''''
11495: ||' WHERE association_type '
11496: ||' NOT IN (SELECT lookup_code FROM mfg_lookups where lookup_type = ''MSC_UI_ASSIGNMENT_TYPE'')'

Line 11524: 'UPDATE msc_st_calendar_assignments'

11520:
11521: -- Error out records where partner_type NOT in (1,2,3,4)
11522: v_sql_stmt := 10;
11523: lv_sql_stmt :=
11524: 'UPDATE msc_st_calendar_assignments'
11525: ||' SET process_flag = '||G_ERROR_FLG||','
11526: ||' error_text = '||''''||lv_message_text||''''
11527: ||' WHERE sr_instance_code = :v_instance_code'
11528: ||' AND batch_id = :lv_batch_id'

Line 11553: 'UPDATE msc_st_calendar_assignments'

11549:
11550: -- Error out records where ASSOCIATION_LEVEL NOT in (1,2,3,4)
11551: v_sql_stmt := 11;
11552: lv_sql_stmt :=
11553: 'UPDATE msc_st_calendar_assignments'
11554: ||' SET process_flag = '||G_ERROR_FLG||','
11555: ||' error_text = '||''''||lv_message_text||''''
11556: ||' WHERE sr_instance_code = :v_instance_code'
11557: ||' AND batch_id = :lv_batch_id'

Line 11583: 'UPDATE msc_st_calendar_assignments '

11579:
11580: -- Error out records where calendar_code is NULL
11581:
11582: lv_sql_stmt :=
11583: 'UPDATE msc_st_calendar_assignments '
11584: ||' SET process_flag = '||G_ERROR_FLG||','
11585: ||' error_text = '||''''||lv_message_text||''''
11586: ||' WHERE sr_instance_code = :v_instance_code'
11587: ||' AND batch_id = :lv_batch_id'

Line 11618: 'UPDATE msc_st_calendar_assignments '

11614: RAISE ex_logging_err;
11615: END IF;
11616:
11617: lv_sql_stmt :=
11618: 'UPDATE msc_st_calendar_assignments '
11619: ||' SET process_flag = '||G_ERROR_FLG||','
11620: ||' error_text = '||''''||lv_message_text||''''
11621: ||' WHERE sr_instance_code = :v_instance_code'
11622: ||' AND batch_id = :lv_batch_id'

Line 11656: 'UPDATE msc_st_calendar_assignments '

11652: RAISE ex_logging_err;
11653: END IF;
11654:
11655: lv_sql_stmt :=
11656: 'UPDATE msc_st_calendar_assignments '
11657: ||' SET process_flag = '||G_ERROR_FLG||','
11658: ||' error_text = '||''''||lv_message_text||''''
11659: ||' WHERE sr_instance_code = :v_instance_code'
11660: ||' AND batch_id = :lv_batch_id'

Line 11690: 'UPDATE msc_st_calendar_assignments '

11686: RAISE ex_logging_err;
11687: END IF;
11688:
11689: lv_sql_stmt :=
11690: 'UPDATE msc_st_calendar_assignments '
11691: ||' SET process_flag = '||G_ERROR_FLG||','
11692: ||' error_text = '||''''||lv_message_text||''''
11693: ||' WHERE sr_instance_code = :v_instance_code'
11694: ||' AND batch_id = :lv_batch_id'

Line 11724: 'UPDATE msc_st_calendar_assignments '

11720: RAISE ex_logging_err;
11721: END IF;
11722:
11723: lv_sql_stmt :=
11724: 'UPDATE msc_st_calendar_assignments '
11725: ||' SET process_flag = '||G_ERROR_FLG||','
11726: ||' error_text = '||''''||lv_message_text||''''
11727: ||' WHERE sr_instance_code = :v_instance_code'
11728: ||' AND batch_id = :lv_batch_id'

Line 11758: 'UPDATE msc_st_calendar_assignments '

11754: RAISE ex_logging_err;
11755: END IF;
11756:
11757: lv_sql_stmt :=
11758: 'UPDATE msc_st_calendar_assignments '
11759: ||' SET process_flag = '||G_ERROR_FLG||','
11760: ||' error_text = '||''''||lv_message_text||''''
11761: ||' WHERE sr_instance_code = :v_instance_code'
11762: ||' AND batch_id = :lv_batch_id'

Line 11793: p_token_value3 => 'MSC_ST_CALENDAR_ASSIGNMENTS');

11789: p_token_value1 => 'CALENDAR_CODE',
11790: p_token2 => 'MASTER_TABLE',
11791: p_token_value2 => 'MSC_CALENDARS',
11792: p_token3 => 'CHILD_TABLE',
11793: p_token_value3 => 'MSC_ST_CALENDAR_ASSIGNMENTS');
11794: IF lv_return <> 0 THEN
11795: RAISE ex_logging_err;
11796: END IF;
11797:

Line 11799: 'UPDATE msc_st_calendar_assignments msca'

11795: RAISE ex_logging_err;
11796: END IF;
11797:
11798: lv_sql_stmt :=
11799: 'UPDATE msc_st_calendar_assignments msca'
11800: ||' SET process_flag = '||G_ERROR_FLG||','
11801: ||' error_text = '||''''||lv_message_text||''''
11802: ||' WHERE NOT EXISTS ( SELECT 1 '
11803: ||' FROM msc_calendars mc '

Line 11834: (p_table_name => 'MSC_ST_CALENDAR_ASSIGNMENTS',

11830: RAISE ex_logging_err;
11831: END IF;
11832:
11833: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
11834: (p_table_name => 'MSC_ST_CALENDAR_ASSIGNMENTS',
11835: p_org_partner_name => 'PARTNER_NAME',
11836: p_org_partner_id => 'PARTNER_ID',
11837: p_instance_code => v_instance_code,
11838: p_partner_type => G_VENDOR,

Line 11865: (p_table_name => 'MSC_ST_CALENDAR_ASSIGNMENTS',

11861: RAISE ex_logging_err;
11862: END IF;
11863:
11864: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
11865: (p_table_name => 'MSC_ST_CALENDAR_ASSIGNMENTS',
11866: p_org_partner_name => 'PARTNER_NAME',
11867: p_org_partner_id => 'PARTNER_ID',
11868: p_instance_code => v_instance_code,
11869: p_partner_type => G_CUSTOMER,

Line 11895: (p_table_name => 'MSC_ST_CALENDAR_ASSIGNMENTS',

11891: END IF;
11892:
11893: --Derive Organization_id
11894: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
11895: (p_table_name => 'MSC_ST_CALENDAR_ASSIGNMENTS',
11896: p_org_partner_name => 'ORGANIZATION_CODE',
11897: p_org_partner_id => 'ORGANIZATION_ID',
11898: p_instance_code => v_instance_code,
11899: p_partner_type => G_ORGANIZATION,

Line 11926: (p_table_name => 'MSC_ST_CALENDAR_ASSIGNMENTS',

11922: RAISE ex_logging_err;
11923: END IF;
11924:
11925: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
11926: (p_table_name => 'MSC_ST_CALENDAR_ASSIGNMENTS',
11927: p_org_partner_name => 'CARRIER_PARTNER_CODE',
11928: p_org_partner_id => 'CARRIER_PARTNER_ID',
11929: p_instance_code => v_instance_code,
11930: p_partner_type => G_CARRIER,

Line 11956: (p_table_name => 'MSC_ST_CALENDAR_ASSIGNMENTS',

11952: END IF;
11953:
11954: --Derive partner_site_id (Supplier)
11955: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_SITE_ID
11956: (p_table_name => 'MSC_ST_CALENDAR_ASSIGNMENTS',
11957: p_partner_name => 'PARTNER_NAME',
11958: p_partner_site_code => 'PARTNER_SITE_CODE',
11959: p_partner_site_id => 'PARTNER_SITE_ID',
11960: p_instance_code => v_instance_code,

Line 11987: (p_table_name => 'MSC_ST_CALENDAR_ASSIGNMENTS',

11983: END IF;
11984:
11985: --Derive partner_site_id (Customer)
11986: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_SITE_ID
11987: (p_table_name => 'MSC_ST_CALENDAR_ASSIGNMENTS',
11988: p_partner_name => 'PARTNER_NAME',
11989: p_partner_site_code => 'PARTNER_SITE_CODE',
11990: p_partner_site_id => 'PARTNER_SITE_ID',
11991: p_instance_code => v_instance_code,

Line 12010: pEntityName => 'MSC_ST_CALENDAR_ASSIGNMENTS',

12006: (ERRBUF => lv_error_text,
12007: RETCODE => lv_return,
12008: pBatchID => lv_batch_id,
12009: pInstanceCode => v_instance_code,
12010: pEntityName => 'MSC_ST_CALENDAR_ASSIGNMENTS',
12011: pInstanceID => v_instance_id);
12012:
12013: IF NVL(lv_return,0) <> 0 THEN
12014: RAISE ex_logging_err;

Line 12018: (p_table_name => 'MSC_ST_CALENDAR_ASSIGNMENTS',

12014: RAISE ex_logging_err;
12015: END IF;
12016:
12017: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
12018: (p_table_name => 'MSC_ST_CALENDAR_ASSIGNMENTS',
12019: p_instance_id => v_instance_id,
12020: p_instance_code => v_instance_code,
12021: p_process_flag => G_VALID,
12022: p_error_text => lv_error_text,

Line 12031: (p_table_name => 'MSC_ST_CALENDAR_ASSIGNMENTS',

12027: RAISE ex_logging_err;
12028: END IF;
12029:
12030: lv_return := MSC_ST_UTIL.LOG_ERROR
12031: (p_table_name => 'MSC_ST_CALENDAR_ASSIGNMENTS',
12032: p_instance_code => v_instance_code,
12033: p_row => lv_column_names,
12034: p_severity => G_SEV_ERROR,
12035: p_message_text => NULL,

Line 12049: lv_error_text := substr('MSC_CL_PRE_PROCESS.MSC_ST_CALENDAR_ASSIGNMENTS'||'('

12045:
12046: EXCEPTION
12047:
12048: WHEN too_many_rows THEN
12049: lv_error_text := substr('MSC_CL_PRE_PROCESS.MSC_ST_CALENDAR_ASSIGNMENTS'||'('
12050: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
12051: ROLLBACK ;
12052:
12053: WHEN ex_logging_err THEN

Line 12058: lv_error_text := substr('MSC_CL_PRE_PROCESS.MSC_ST_CALENDAR_ASSIGNMENTS '||'('

12054: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
12055: ROLLBACK;
12056:
12057: WHEN OTHERS THEN
12058: lv_error_text := substr('MSC_CL_PRE_PROCESS.MSC_ST_CALENDAR_ASSIGNMENTS '||'('
12059: ||v_sql_stmt||')'|| SQLERRM, 1, 240);
12060: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
12061: ROLLBACK;
12062:

Line 56053: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_CALENDAR_ASSIGNMENTS');

56049: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_APPS_INSTANCES', p_company_name_col => FALSE);
56050: END IF;
56051:
56052: IF v_cal_assignment_enabled = SYS_YES THEN
56053: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_CALENDAR_ASSIGNMENTS');
56054: IF lv_count > 0 Then
56055: prec.calendar_flag:=SYS_YES;
56056: End IF;
56057: END IF;