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_EXCHANGE_PARTTBL dependencies on MSC_CL_COLLECTION

Line 419: MSC_CL_COLLECTION.G_WARNING

415: v_tempTblList(i),
416: v_instance_code,
417: v_instance_id,
418: SYS_NO,
419: MSC_CL_COLLECTION.G_WARNING
420: );
421:
422: IF lv_crt_ind_status = MSC_CL_COLLECTION.G_WARNING THEN
423: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Warning during unique index creation on table, ' || v_tempTblList(i));

Line 422: IF lv_crt_ind_status = MSC_CL_COLLECTION.G_WARNING THEN

418: SYS_NO,
419: MSC_CL_COLLECTION.G_WARNING
420: );
421:
422: IF lv_crt_ind_status = MSC_CL_COLLECTION.G_WARNING THEN
423: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Warning during unique index creation on table, ' || v_tempTblList(i));
424: ELSIF lv_crt_ind_status = MSC_CL_COLLECTION.G_ERROR THEN
425: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error during unique index creation on table, ' || v_tempTblList(i));
426: RETURN FALSE;

Line 424: ELSIF lv_crt_ind_status = MSC_CL_COLLECTION.G_ERROR THEN

420: );
421:
422: IF lv_crt_ind_status = MSC_CL_COLLECTION.G_WARNING THEN
423: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Warning during unique index creation on table, ' || v_tempTblList(i));
424: ELSIF lv_crt_ind_status = MSC_CL_COLLECTION.G_ERROR THEN
425: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error during unique index creation on table, ' || v_tempTblList(i));
426: RETURN FALSE;
427: ELSE
428: trc('Unique index creation successful on table, ' || v_tempTblList(i));

Line 496: || v_swapTblList(i).column_name || ' = ' || MSC_CL_COLLECTION.G_STG_ODS_SWP_PHASE_2

492: END IF;
493:
494: --if the table is in the ods-staging swap table list.
495: EXECUTE IMMEDIATE ' update msc_coll_parameters set '
496: || v_swapTblList(i).column_name || ' = ' || MSC_CL_COLLECTION.G_STG_ODS_SWP_PHASE_2
497: || ' where instance_id = ' || v_instance_id;
498:
499: END LOOP;
500:

Line 783: || v_swapTblList(j).column_name || ' = ' || MSC_CL_COLLECTION.G_STG_ODS_SWP_PHASE_2

779:
780: --if the table is in the ods-staging swap table list.
781: if lv_is_swap_table then
782: EXECUTE IMMEDIATE ' update msc_coll_parameters set '
783: || v_swapTblList(j).column_name || ' = ' || MSC_CL_COLLECTION.G_STG_ODS_SWP_PHASE_2
784: || ' where instance_id = ' || v_instance_id;
785: end if;
786:
787: END LOOP;

Line 845: EXECUTE IMMEDIATE ' select nvl(' ||v_swapTblList(i).column_name || ',' || MSC_CL_COLLECTION.G_STG_ODS_SWP_PHASE_0 || ') from msc_coll_parameters '

841: BEGIN
842:
843: FOR i IN 1..v_swapTblList.COUNT LOOP
844:
845: EXECUTE IMMEDIATE ' select nvl(' ||v_swapTblList(i).column_name || ',' || MSC_CL_COLLECTION.G_STG_ODS_SWP_PHASE_0 || ') from msc_coll_parameters '
846: || ' where instance_id = ' || v_instance_id
847: INTO lv_swap_status;
848:
849: If lv_swap_status = MSC_CL_COLLECTION.G_STG_ODS_SWP_PHASE_2 then

Line 849: If lv_swap_status = MSC_CL_COLLECTION.G_STG_ODS_SWP_PHASE_2 then

845: EXECUTE IMMEDIATE ' select nvl(' ||v_swapTblList(i).column_name || ',' || MSC_CL_COLLECTION.G_STG_ODS_SWP_PHASE_0 || ') from msc_coll_parameters '
846: || ' where instance_id = ' || v_instance_id
847: INTO lv_swap_status;
848:
849: If lv_swap_status = MSC_CL_COLLECTION.G_STG_ODS_SWP_PHASE_2 then
850:
851: msc_manage_plan_partitions.get_partition_name
852: ( -1,
853: v_instance_id,

Line 871: If lv_swap_status <> MSC_CL_COLLECTION.G_STG_ODS_SWP_PHASE_0 then

867: FOR j IN i..v_swapTblList.COUNT LOOP
868: EXECUTE IMMEDIATE ' select ' ||v_swapTblList(j).column_name || 'from msc_coll_parameters '
869: || ' where instance_id = ' || v_instance_id
870: INTO lv_swap_status;
871: If lv_swap_status <> MSC_CL_COLLECTION.G_STG_ODS_SWP_PHASE_0 then
872: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,v_swapTblList(j).entity_name );
873: End if;
874: END LOOP;
875:

Line 878: lv_swap_status := MSC_CL_COLLECTION.G_STG_ODS_SWP_PHASE_1;

874: END LOOP;
875:
876: return FALSE;
877: END IF;
878: lv_swap_status := MSC_CL_COLLECTION.G_STG_ODS_SWP_PHASE_1;
879: End if;
880:
881: If lv_swap_status = MSC_CL_COLLECTION.G_STG_ODS_SWP_PHASE_1 then
882:

Line 881: If lv_swap_status = MSC_CL_COLLECTION.G_STG_ODS_SWP_PHASE_1 then

877: END IF;
878: lv_swap_status := MSC_CL_COLLECTION.G_STG_ODS_SWP_PHASE_1;
879: End if;
880:
881: If lv_swap_status = MSC_CL_COLLECTION.G_STG_ODS_SWP_PHASE_1 then
882:
883: if NOT EXCHANGE_SINGLE_TAB_PARTN ( v_swapTblList(i).stg_table_name ,
884: v_swapTblList(i).stg_table_partn_name ,
885: v_swapTblList(i).temp_table_name,

Line 893: If lv_swap_status <> MSC_CL_COLLECTION.G_STG_ODS_SWP_PHASE_0 then

889: FOR j IN i..v_swapTblList.COUNT LOOP
890: EXECUTE IMMEDIATE ' select ' ||v_swapTblList(j).column_name || 'from msc_coll_parameters '
891: || ' where instance_id = ' || v_instance_id
892: INTO lv_swap_status;
893: If lv_swap_status <> MSC_CL_COLLECTION.G_STG_ODS_SWP_PHASE_0 then
894: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,v_swapTblList(j).entity_name );
895: End if;
896: END LOOP;
897:

Line 904: || v_swapTblList(i).column_name || ' = ' || MSC_CL_COLLECTION.G_STG_ODS_SWP_PHASE_0

900: End if;
901:
902:
903: EXECUTE IMMEDIATE ' update msc_coll_parameters set '
904: || v_swapTblList(i).column_name || ' = ' || MSC_CL_COLLECTION.G_STG_ODS_SWP_PHASE_0
905: || ' where instance_id = ' || v_instance_id;
906:
907: End loop;
908:

Line 1132: EXECUTE IMMEDIATE ' select nvl(' ||v_swapTblList(i).column_name || ',' || MSC_CL_COLLECTION.G_STG_ODS_SWP_PHASE_0 || ') from msc_coll_parameters '

1128: END IF; -- sales_order_flag
1129:
1130: FOR i IN 1..v_swapTblList.COUNT LOOP
1131:
1132: EXECUTE IMMEDIATE ' select nvl(' ||v_swapTblList(i).column_name || ',' || MSC_CL_COLLECTION.G_STG_ODS_SWP_PHASE_0 || ') from msc_coll_parameters '
1133: || ' where instance_id = ' || v_instance_id
1134: INTO lv_swap_status;
1135:
1136: If lv_swap_status = MSC_CL_COLLECTION.G_STG_ODS_SWP_PHASE_1 then

Line 1136: If lv_swap_status = MSC_CL_COLLECTION.G_STG_ODS_SWP_PHASE_1 then

1132: EXECUTE IMMEDIATE ' select nvl(' ||v_swapTblList(i).column_name || ',' || MSC_CL_COLLECTION.G_STG_ODS_SWP_PHASE_0 || ') from msc_coll_parameters '
1133: || ' where instance_id = ' || v_instance_id
1134: INTO lv_swap_status;
1135:
1136: If lv_swap_status = MSC_CL_COLLECTION.G_STG_ODS_SWP_PHASE_1 then
1137: lv_TblList.EXTEND; -- Extend the size
1138: tbl_count := tbl_count + 1;
1139: lv_TblList(tbl_count) := v_swapTblList(i).temp_table_name;
1140: END if;

Line 1585: lv_retval NUMBER := MSC_CL_COLLECTION.G_SUCCESS;

1581: lv_ind_stmt VARCHAR2(2048);
1582: lv_sql_stmt2 VARCHAR2(2048);
1583: lv_sql_stmt3 VARCHAR2(2048);
1584: lv_sql_stmt4 VARCHAR2(2048);
1585: lv_retval NUMBER := MSC_CL_COLLECTION.G_SUCCESS;
1586: TYPE CharTblTyp IS TABLE OF VARCHAR2(4000);
1587: lv_error_msg CharTblTyp;
1588: lv_extent_management VARCHAR2(10);
1589: lv_allocation_type VARCHAR2(9);

Line 1755: IF p_error_level = MSC_CL_COLLECTION.G_ERROR THEN

1751: WHEN OTHERS THEN
1752: /* handle unique index violation exception */
1753:
1754: IF SQLCODE IN (-00001, -01452, -12801) THEN
1755: IF p_error_level = MSC_CL_COLLECTION.G_ERROR THEN
1756: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'ERROR');
1757: ELSE
1758: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'WARNING');
1759: END IF;

Line 1808: IF p_error_level = MSC_CL_COLLECTION.G_ERROR THEN

1804: END LOOP;
1805:
1806: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '===========================================================');
1807:
1808: IF p_error_level = MSC_CL_COLLECTION.G_ERROR THEN
1809: lv_retval := MSC_CL_COLLECTION.G_ERROR;
1810: RAISE;
1811: ELSE
1812: lv_retval := MSC_CL_COLLECTION.G_WARNING;

Line 1809: lv_retval := MSC_CL_COLLECTION.G_ERROR;

1805:
1806: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '===========================================================');
1807:
1808: IF p_error_level = MSC_CL_COLLECTION.G_ERROR THEN
1809: lv_retval := MSC_CL_COLLECTION.G_ERROR;
1810: RAISE;
1811: ELSE
1812: lv_retval := MSC_CL_COLLECTION.G_WARNING;
1813: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The above records would not be collected');

Line 1812: lv_retval := MSC_CL_COLLECTION.G_WARNING;

1808: IF p_error_level = MSC_CL_COLLECTION.G_ERROR THEN
1809: lv_retval := MSC_CL_COLLECTION.G_ERROR;
1810: RAISE;
1811: ELSE
1812: lv_retval := MSC_CL_COLLECTION.G_WARNING;
1813: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'The above records would not be collected');
1814: lv_sql_stmt4 := 'DELETE FROM ' || p_temp_table || ' t1 WHERE EXISTS '
1815: || '(SELECT 1 FROM ' || p_temp_table || ' t2 ' || lv_sql_stmt3
1816: || 't1.rowid < t2.rowid)';

Line 1831: lv_retval := MSC_CL_COLLECTION.G_ERROR;

1827: statement => v_sql_stmt,
1828: object_name => lv_temp_index_name);
1829: EXCEPTION
1830: WHEN OTHERS THEN
1831: lv_retval := MSC_CL_COLLECTION.G_ERROR;
1832: RAISE;
1833: END;
1834: END IF;
1835: ELSE

Line 1836: lv_retval := MSC_CL_COLLECTION.G_ERROR;

1832: RAISE;
1833: END;
1834: END IF;
1835: ELSE
1836: lv_retval := MSC_CL_COLLECTION.G_ERROR;
1837: RAISE;
1838: END IF;
1839: END;
1840: trc('Index creation done - ' || lv_temp_index_name);

Line 1850: lv_retval := MSC_CL_COLLECTION.G_ERROR;

1846: RETURN lv_retval;
1847:
1848: EXCEPTION
1849: WHEN OTHERS THEN
1850: lv_retval := MSC_CL_COLLECTION.G_ERROR;
1851: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
1852: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>'||v_sql_stmt);
1853: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1854: RETURN lv_retval;