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_PLANNERS

Line 1565: 'create index MSC_ST_PLANNERS_N1_'||v_instance_code

1561: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1562: application_short_name => 'MSC',
1563: statement_type => AD_DDL.CREATE_INDEX,
1564: statement =>
1565: 'create index MSC_ST_PLANNERS_N1_'||v_instance_code
1566: ||' on MSC_ST_PLANNERS '
1567: ||'(sr_instance_code,organization_code,planner_code,company_name) '
1568: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1569: object_name =>'MSC_ST_PLANNERS_N1_'||v_instance_code);

Line 1566: ||' on MSC_ST_PLANNERS '

1562: application_short_name => 'MSC',
1563: statement_type => AD_DDL.CREATE_INDEX,
1564: statement =>
1565: 'create index MSC_ST_PLANNERS_N1_'||v_instance_code
1566: ||' on MSC_ST_PLANNERS '
1567: ||'(sr_instance_code,organization_code,planner_code,company_name) '
1568: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1569: object_name =>'MSC_ST_PLANNERS_N1_'||v_instance_code);
1570:

Line 1569: object_name =>'MSC_ST_PLANNERS_N1_'||v_instance_code);

1565: 'create index MSC_ST_PLANNERS_N1_'||v_instance_code
1566: ||' on MSC_ST_PLANNERS '
1567: ||'(sr_instance_code,organization_code,planner_code,company_name) '
1568: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1569: object_name =>'MSC_ST_PLANNERS_N1_'||v_instance_code);
1570:
1571: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_PLANNERS_N1_'||v_instance_code);
1572:
1573: EXCEPTION

Line 1571: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_PLANNERS_N1_'||v_instance_code);

1567: ||'(sr_instance_code,organization_code,planner_code,company_name) '
1568: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1569: object_name =>'MSC_ST_PLANNERS_N1_'||v_instance_code);
1570:
1571: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_PLANNERS_N1_'||v_instance_code);
1572:
1573: EXCEPTION
1574: WHEN OTHERS THEN
1575: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_PLANNERS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

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

1571: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_PLANNERS_N1_'||v_instance_code);
1572:
1573: EXCEPTION
1574: WHEN OTHERS THEN
1575: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_PLANNERS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1576: END;
1577:
1578: msc_analyse_tables_pk.analyse_table( 'MSC_ST_PLANNERS', v_instance_id, -1);
1579:

Line 1578: msc_analyse_tables_pk.analyse_table( 'MSC_ST_PLANNERS', v_instance_id, -1);

1574: WHEN OTHERS THEN
1575: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_PLANNERS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1576: END;
1577:
1578: msc_analyse_tables_pk.analyse_table( 'MSC_ST_PLANNERS', v_instance_id, -1);
1579:
1580: END IF;
1581:
1582: IF v_mat_sup_enabled = SYS_YES THEN

Line 2666: 'drop index MSC_ST_PLANNERS_N1_'||v_instance_code,

2662: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2663: application_short_name => 'MSC',
2664: statement_type => AD_DDL.DROP_INDEX,
2665: statement =>
2666: 'drop index MSC_ST_PLANNERS_N1_'||v_instance_code,
2667: object_name => 'MSC_ST_PLANNERS_N1_'||v_instance_code);
2668:
2669: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_PLANNERS_N1_'||v_instance_code);
2670:

Line 2667: object_name => 'MSC_ST_PLANNERS_N1_'||v_instance_code);

2663: application_short_name => 'MSC',
2664: statement_type => AD_DDL.DROP_INDEX,
2665: statement =>
2666: 'drop index MSC_ST_PLANNERS_N1_'||v_instance_code,
2667: object_name => 'MSC_ST_PLANNERS_N1_'||v_instance_code);
2668:
2669: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_PLANNERS_N1_'||v_instance_code);
2670:
2671: EXCEPTION

Line 2669: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_PLANNERS_N1_'||v_instance_code);

2665: statement =>
2666: 'drop index MSC_ST_PLANNERS_N1_'||v_instance_code,
2667: object_name => 'MSC_ST_PLANNERS_N1_'||v_instance_code);
2668:
2669: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_PLANNERS_N1_'||v_instance_code);
2670:
2671: EXCEPTION
2672: WHEN OTHERS THEN
2673: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_PLANNERS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

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

2669: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_PLANNERS_N1_'||v_instance_code);
2670:
2671: EXCEPTION
2672: WHEN OTHERS THEN
2673: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_PLANNERS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2674: END;
2675:
2676: END IF;
2677:

Line 15429: | table msc_st_planners. |

15425: END LOAD_WO_OPERATION_REL;
15426:
15427: /*==========================================================================+
15428: | DESCRIPTION : This procedure performs validation and loads data into the |
15429: | table msc_st_planners. |
15430: +==========================================================================*/
15431: PROCEDURE LOAD_planners IS
15432: TYPE RowidTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
15433: lb_rowid RowidTab;

Line 15439: lv_batch_id msc_st_planners.batch_id%TYPE;

15435: lv_error_text VARCHAR2(250);
15436: lv_where_str VARCHAR2(5000);
15437: lv_sql_stmt VARCHAR2(5000);
15438: lv_column_names VARCHAR2(5000);
15439: lv_batch_id msc_st_planners.batch_id%TYPE;
15440: lv_message_text msc_errors.error_text%TYPE;
15441:
15442: ex_logging_err EXCEPTION;
15443:

Line 15446: FROM msc_st_planners

15442: ex_logging_err EXCEPTION;
15443:
15444: CURSOR c1(p_batch_id NUMBER) IS
15445: SELECT rowid
15446: FROM msc_st_planners
15447: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
15448: AND batch_id = p_batch_id
15449: AND sr_instance_code = v_instance_code;
15450:

Line 15467: FROM MSC_ST_PLANNERS x

15463: x.LAST_UPDATED_BY,
15464: x.CREATION_DATE,
15465: x.CREATED_BY,
15466: x.deleted_flag
15467: FROM MSC_ST_PLANNERS x
15468: WHERE x.sr_instance_code = v_instance_code
15469: and x.batch_id =p_batch_id
15470: and x.process_flag = G_VALID;
15471:

Line 15487: ' UPDATE msc_st_planners msp1'

15483:
15484: --Duplicate records check for the records whose source is XML
15485: v_sql_stmt := 01;
15486: lv_sql_stmt :=
15487: ' UPDATE msc_st_planners msp1'
15488: ||' SET process_flag = '||G_ERROR_FLG||','
15489: ||' error_text = '||''''||lv_message_text||''''
15490: ||' WHERE message_id < (SELECT MAX(message_id)'
15491: ||' FROM msc_st_planners msp2'

Line 15491: ||' FROM msc_st_planners msp2'

15487: ' UPDATE msc_st_planners msp1'
15488: ||' SET process_flag = '||G_ERROR_FLG||','
15489: ||' error_text = '||''''||lv_message_text||''''
15490: ||' WHERE message_id < (SELECT MAX(message_id)'
15491: ||' FROM msc_st_planners msp2'
15492: ||' WHERE msp2.sr_instance_code = msp1.sr_instance_code'
15493: ||' AND NVL(msp2.company_name, ' ||''''||NULL_CHAR||''''||') = '
15494: ||' NVL(msp1.company_name, ' ||''''||NULL_CHAR||''''||')'
15495: ||' AND msp2.organization_code = msp1.organization_code'

Line 15525: ' UPDATE msc_st_planners msp1'

15521: --Different SQL is used because in XML we can identify the latest records
15522: --whereas in batch load we cannot.
15523: v_sql_stmt := 02;
15524: lv_sql_stmt :=
15525: ' UPDATE msc_st_planners msp1'
15526: ||' SET process_flag = '||G_ERROR_FLG||','
15527: ||' error_text = '||''''||lv_message_text||''''
15528: ||' WHERE EXISTS( SELECT 1 '
15529: ||' FROM msc_st_planners msp2'

Line 15529: ||' FROM msc_st_planners msp2'

15525: ' UPDATE msc_st_planners msp1'
15526: ||' SET process_flag = '||G_ERROR_FLG||','
15527: ||' error_text = '||''''||lv_message_text||''''
15528: ||' WHERE EXISTS( SELECT 1 '
15529: ||' FROM msc_st_planners msp2'
15530: ||' WHERE msp2.sr_instance_code = msp1.sr_instance_code'
15531: ||' AND NVL(msp2.company_name, ' ||''''||NULL_CHAR||''''||') = '
15532: ||' NVL(msp1.company_name, ' ||''''||NULL_CHAR||''''||')'
15533: ||' AND msp2.organization_code = msp1.organization_code'

Line 15569: 'UPDATE msc_st_planners '

15565: FROM dual;
15566:
15567: v_sql_stmt := 04;
15568: lv_sql_stmt :=
15569: 'UPDATE msc_st_planners '
15570: ||' SET batch_id = :lv_batch_id'
15571: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
15572: ||' AND sr_instance_code = :v_instance_code'
15573: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 15591: UPDATE msc_st_planners

15587: CLOSE c1;
15588:
15589: v_sql_stmt := 05;
15590: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
15591: UPDATE msc_st_planners
15592: SET st_transaction_id = msc_st_planners_s.NEXTVAL,
15593: refresh_id = v_refresh_id,
15594: last_update_date = v_current_date,
15595: last_updated_by = v_current_user,

Line 15592: SET st_transaction_id = msc_st_planners_s.NEXTVAL,

15588:
15589: v_sql_stmt := 05;
15590: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
15591: UPDATE msc_st_planners
15592: SET st_transaction_id = msc_st_planners_s.NEXTVAL,
15593: refresh_id = v_refresh_id,
15594: last_update_date = v_current_date,
15595: last_updated_by = v_current_user,
15596: creation_date = v_current_date,

Line 15607: p_token_value1 => 'MSC_ST_PLANNERS');

15603: p_error_code => 'MSC_PP_NO_DELETION',
15604: p_message_text => lv_message_text,
15605: p_error_text => lv_error_text,
15606: p_token1 => 'TABLE_NAME',
15607: p_token_value1 => 'MSC_ST_PLANNERS');
15608:
15609: IF lv_return <> 0 THEN
15610: RAISE ex_logging_err;
15611: END IF;

Line 15615: 'UPDATE msc_st_planners '

15611: END IF;
15612:
15613: v_sql_stmt := 06;
15614: lv_sql_stmt :=
15615: 'UPDATE msc_st_planners '
15616: ||' SET process_flag = '||G_ERROR_FLG||','
15617: ||' error_text = '||''''||lv_message_text||''''
15618: ||' WHERE deleted_flag = '||SYS_YES
15619: ||' AND process_flag = '||G_IN_PROCESS

Line 15652: (p_table_name => 'MSC_ST_PLANNERS',

15648: ||' NOT IN(1,2)';
15649: --Log a warning for those records where the deleted_flag has a value other
15650: --than SYS_NO
15651: lv_return := MSC_ST_UTIL.LOG_ERROR
15652: (p_table_name => 'MSC_ST_PLANNERS',
15653: p_instance_code => v_instance_code,
15654: p_row => lv_column_names,
15655: p_severity => G_SEV_WARNING,
15656: p_message_text => lv_message_text,

Line 15682: 'UPDATE msc_st_planners '

15678: END IF;
15679:
15680: v_sql_stmt := 07;
15681: lv_sql_stmt :=
15682: 'UPDATE msc_st_planners '
15683: ||' SET process_flag = '||G_ERROR_FLG||','
15684: ||' error_text = '||''''||lv_message_text||''''
15685: ||' WHERE NVL(planner_code, '||''''||NULL_CHAR||''''||') '
15686: ||' = '||''''||NULL_CHAR||''''

Line 15712: 'UPDATE msc_st_planners '

15708: END IF;
15709:
15710: v_sql_stmt := 07;
15711: lv_sql_stmt :=
15712: 'UPDATE msc_st_planners '
15713: ||' SET process_flag = '||G_ERROR_FLG||','
15714: ||' error_text = '||''''||lv_message_text||''''
15715: ||' WHERE NVL(current_employee_flag,'||NULL_VALUE||') NOT IN(1,2) '
15716: ||' AND batch_id = :lv_batch_id'

Line 15742: 'UPDATE msc_st_planners msp'

15738: END IF;
15739:
15740: v_sql_stmt := 07;
15741: lv_sql_stmt :=
15742: 'UPDATE msc_st_planners msp'
15743: ||' SET process_flag = '||G_ERROR_FLG||','
15744: ||' error_text = '||''''||lv_message_text||''''
15745: ||' WHERE NOT EXISTS(SELECT 1 '
15746: ||' FROM fnd_user fu'

Line 15777: (p_table_name => 'MSC_ST_PLANNERS',

15773:
15774: -- Derive organization_id
15775:
15776: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
15777: (p_table_name => 'MSC_ST_PLANNERS',
15778: p_org_partner_name => 'ORGANIZATION_CODE',
15779: p_org_partner_id => 'ORGANIZATION_ID',
15780: p_instance_code => v_instance_code,
15781: p_partner_type => G_ORGANIZATION,

Line 15798: p_token_value1 => 'MSC_ST_PLANNERS');

15794: p_error_code => 'MSC_PP_NO_UPDATION',
15795: p_message_text => lv_message_text,
15796: p_error_text => lv_error_text,
15797: p_token1 => 'TABLE_NAME',
15798: p_token_value1 => 'MSC_ST_PLANNERS');
15799:
15800: IF lv_return <> 0 THEN
15801: RAISE ex_logging_err;
15802: END IF;

Line 15808: ' UPDATE msc_st_planners msp1'

15804: --Updation is not allowed on this entity(this is done to make the
15805: --Post-Processor in sync with the collection program).
15806: v_sql_stmt := 09;
15807: lv_sql_stmt :=
15808: ' UPDATE msc_st_planners msp1'
15809: ||' SET process_flag = '||G_ERROR_FLG||','
15810: ||' error_text = '||''''||lv_message_text||''''
15811: ||' WHERE process_flag = '||G_IN_PROCESS
15812: ||' AND batch_id = :lv_batch_id'

Line 15833: 'UPDATE msc_st_planners msp'

15829: --Derive employee_id
15830:
15831: v_sql_stmt := 07;
15832: lv_sql_stmt :=
15833: 'UPDATE msc_st_planners msp'
15834: ||' SET employee_id = (select employee_id '
15835: ||' from fnd_user fu'
15836: ||' where fu.user_name = UPPER(msp.user_name)) '
15837: ||' WHERE batch_id = :lv_batch_id'

Line 15854: pEntityName => 'MSC_ST_PLANNERS',

15850: (ERRBUF => lv_error_text,
15851: RETCODE => lv_return,
15852: pBatchID => lv_batch_id,
15853: pInstanceCode => v_instance_code,
15854: pEntityName => 'MSC_ST_PLANNERS',
15855: pInstanceID => v_instance_id);
15856:
15857: IF NVL(lv_return,0) <> 0 THEN
15858: RAISE ex_logging_err;

Line 15862: (p_table_name => 'MSC_ST_PLANNERS',

15858: RAISE ex_logging_err;
15859: END IF;
15860:
15861: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
15862: (p_table_name => 'MSC_ST_PLANNERS',
15863: p_instance_id => v_instance_id,
15864: p_instance_code => v_instance_code,
15865: p_process_flag => G_VALID,
15866: p_error_text => lv_error_text,

Line 15875: (p_table_name => 'MSC_ST_PLANNERS',

15871: RAISE ex_logging_err;
15872: END IF;
15873:
15874: lv_return := MSC_ST_UTIL.LOG_ERROR
15875: (p_table_name => 'MSC_ST_PLANNERS',
15876: p_instance_code => v_instance_code,
15877: p_row => lv_column_names,
15878: p_severity => G_SEV_ERROR,
15879: p_message_text => NULL,

Line 15969: from msc_st_planners z

15965: END LOOP;
15966:
15967: UPDATE FND_USER y
15968: SET EMAIL_ADDRESS = (select ELECTRONIC_MAIL_ADDRESS
15969: from msc_st_planners z
15970: WHERE UPPER(z.USER_NAME) = y.USER_NAME
15971: AND z.process_flag = G_VALID
15972: AND z.CURRENT_EMPLOYEE_FLAG = 1
15973: AND z.EMPLOYEE_ID IS NOT NULL

Line 15978: from msc_st_planners x

15974: AND z.ELECTRONIC_MAIL_ADDRESS IS NOT NULL
15975: AND z.SR_INSTANCE_ID = v_instance_id
15976: AND rownum=1)
15977: WHERE exists (SELECT 1
15978: from msc_st_planners x
15979: WHERE x.USER_NAME = y.USER_NAME
15980: AND x.CURRENT_EMPLOYEE_FLAG = 1
15981: AND x.EMPLOYEE_ID IS NOT NULL
15982: AND x.ELECTRONIC_MAIL_ADDRESS IS NOT NULL

Line 56040: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_PLANNERS');

56036: End IF;
56037: END IF;
56038:
56039: IF v_planners_enabled = SYS_YES THEN
56040: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_PLANNERS');
56041: IF lv_count > 0 Then
56042: prec.planner_flag:= SYS_YES;
56043: End IF;
56044: END IF;