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_PURGE_LID dependencies on FND_MESSAGE

Line 48: FND_MESSAGE.SET_NAME('MSC', 'MSC_ST_ERROR_DATA_EXIST');

44: IF lv_instance_enabled= SYS_YES THEN
45:
46: IF lv_staging_table_status= G_ST_READY THEN
47:
48: FND_MESSAGE.SET_NAME('MSC', 'MSC_ST_ERROR_DATA_EXIST');
49: ERRBUF:= FND_MESSAGE.GET;
50: retcode:= G_SUCCESS ;
51: RETURN TRUE ;
52:

Line 49: ERRBUF:= FND_MESSAGE.GET;

45:
46: IF lv_staging_table_status= G_ST_READY THEN
47:
48: FND_MESSAGE.SET_NAME('MSC', 'MSC_ST_ERROR_DATA_EXIST');
49: ERRBUF:= FND_MESSAGE.GET;
50: retcode:= G_SUCCESS ;
51: RETURN TRUE ;
52:
53: ELSIF lv_staging_table_status= G_ST_PULLING THEN

Line 54: FND_MESSAGE.SET_NAME('MSC', 'MSC_ST_ERROR_PULLING');

50: retcode:= G_SUCCESS ;
51: RETURN TRUE ;
52:
53: ELSIF lv_staging_table_status= G_ST_PULLING THEN
54: FND_MESSAGE.SET_NAME('MSC', 'MSC_ST_ERROR_PULLING');
55: errbuf:= FND_MESSAGE.GET;
56: retcode:= G_ERROR ;
57: RETURN FALSE ;
58:

Line 55: errbuf:= FND_MESSAGE.GET;

51: RETURN TRUE ;
52:
53: ELSIF lv_staging_table_status= G_ST_PULLING THEN
54: FND_MESSAGE.SET_NAME('MSC', 'MSC_ST_ERROR_PULLING');
55: errbuf:= FND_MESSAGE.GET;
56: retcode:= G_ERROR ;
57: RETURN FALSE ;
58:
59: ELSIF lv_staging_table_status= G_ST_COLLECTING THEN

Line 60: FND_MESSAGE.SET_NAME('MSC', 'MSC_ST_ERROR_LOADING');

56: retcode:= G_ERROR ;
57: RETURN FALSE ;
58:
59: ELSIF lv_staging_table_status= G_ST_COLLECTING THEN
60: FND_MESSAGE.SET_NAME('MSC', 'MSC_ST_ERROR_LOADING');
61: ERRBUF:= FND_MESSAGE.GET;
62: retcode:= G_ERROR ;
63: RETURN FALSE ;
64:

Line 61: ERRBUF:= FND_MESSAGE.GET;

57: RETURN FALSE ;
58:
59: ELSIF lv_staging_table_status= G_ST_COLLECTING THEN
60: FND_MESSAGE.SET_NAME('MSC', 'MSC_ST_ERROR_LOADING');
61: ERRBUF:= FND_MESSAGE.GET;
62: retcode:= G_ERROR ;
63: RETURN FALSE ;
64:
65: ELSIF lv_staging_table_status= G_ST_PURGING THEN

Line 67: FND_MESSAGE.SET_NAME('MSC', 'MSC_ST_ERROR_PURGING');

63: RETURN FALSE ;
64:
65: ELSIF lv_staging_table_status= G_ST_PURGING THEN
66:
67: FND_MESSAGE.SET_NAME('MSC', 'MSC_ST_ERROR_PURGING');
68: ERRBUF:= FND_MESSAGE.GET;
69: retcode:= G_SUCCESS ;
70: RETURN TRUE ;
71:

Line 68: ERRBUF:= FND_MESSAGE.GET;

64:
65: ELSIF lv_staging_table_status= G_ST_PURGING THEN
66:
67: FND_MESSAGE.SET_NAME('MSC', 'MSC_ST_ERROR_PURGING');
68: ERRBUF:= FND_MESSAGE.GET;
69: retcode:= G_SUCCESS ;
70: RETURN TRUE ;
71:
72: ELSIF lv_staging_table_status= G_ST_PRE_PROCESSING THEN

Line 74: FND_MESSAGE.SET_NAME('MSC', 'MSC_ST_PRE_PROCESSING');

70: RETURN TRUE ;
71:
72: ELSIF lv_staging_table_status= G_ST_PRE_PROCESSING THEN
73:
74: FND_MESSAGE.SET_NAME('MSC', 'MSC_ST_PRE_PROCESSING');
75: ERRBUF:= FND_MESSAGE.GET;
76: retcode:= G_ERROR ;
77: RETURN FALSE ;
78:

Line 75: ERRBUF:= FND_MESSAGE.GET;

71:
72: ELSIF lv_staging_table_status= G_ST_PRE_PROCESSING THEN
73:
74: FND_MESSAGE.SET_NAME('MSC', 'MSC_ST_PRE_PROCESSING');
75: ERRBUF:= FND_MESSAGE.GET;
76: retcode:= G_ERROR ;
77: RETURN FALSE ;
78:
79: ELSE

Line 85: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_INSTANCE_INACTIVE');

81: RETURN TRUE ;
82: END IF;
83:
84: ELSE
85: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_INSTANCE_INACTIVE');
86: errbuf:= FND_MESSAGE.GET;
87: retcode:= G_ERROR;
88: RETURN FALSE;
89: END IF;

Line 86: errbuf:= FND_MESSAGE.GET;

82: END IF;
83:
84: ELSE
85: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_INSTANCE_INACTIVE');
86: errbuf:= FND_MESSAGE.GET;
87: retcode:= G_ERROR;
88: RETURN FALSE;
89: END IF;
90:

Line 153: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');

149: BEGIN
150:
151: lv_task_start_time:= SYSDATE;
152:
153: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
154: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'DELETE_MSC_TABLE:'||p_table_name);
155: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
156:
157: IF p_sub_str IS NULL

Line 154: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'DELETE_MSC_TABLE:'||p_table_name);

150:
151: lv_task_start_time:= SYSDATE;
152:
153: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
154: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'DELETE_MSC_TABLE:'||p_table_name);
155: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
156:
157: IF p_sub_str IS NULL
158: AND is_msctbl_partitioned( p_table_name) THEN

Line 155: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);

151: lv_task_start_time:= SYSDATE;
152:
153: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
154: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'DELETE_MSC_TABLE:'||p_table_name);
155: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
156:
157: IF p_sub_str IS NULL
158: AND is_msctbl_partitioned( p_table_name) THEN
159:

Line 317: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');

313: END IF;
314: END IF;
315: END IF;
316:
317: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
318: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
319: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
320: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
321:

Line 318: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',

314: END IF;
315: END IF;
316:
317: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
318: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
319: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
320: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
321:
322: EXCEPTION

Line 320: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);

316:
317: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
318: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
319: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
320: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
321:
322: EXCEPTION
323: WHEN OTHERS THEN
324: lv_errtext := substr('DELETE_MSC_TABLE'||'('

Line 359: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');

355: BEGIN
356:
357: lv_task_start_time:= SYSDATE;
358:
359: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
360: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'DELETE_LID_TABLE:'||p_lid_table);
361: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' '||FND_MESSAGE.GET);
362:
363: lv_where_str := p_where_str;

Line 360: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'DELETE_LID_TABLE:'||p_lid_table);

356:
357: lv_task_start_time:= SYSDATE;
358:
359: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
360: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'DELETE_LID_TABLE:'||p_lid_table);
361: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' '||FND_MESSAGE.GET);
362:
363: lv_where_str := p_where_str;
364: lv_pbs:= TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE'));

Line 361: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' '||FND_MESSAGE.GET);

357: lv_task_start_time:= SYSDATE;
358:
359: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
360: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'DELETE_LID_TABLE:'||p_lid_table);
361: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' '||FND_MESSAGE.GET);
362:
363: lv_where_str := p_where_str;
364: lv_pbs:= TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE'));
365:

Line 432: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');

428:
429: COMMIT;
430:
431:
432: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
433: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
434: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
435: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
436:

Line 433: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',

429: COMMIT;
430:
431:
432: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
433: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
434: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
435: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
436:
437:

Line 435: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);

431:
432: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
433: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
434: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
435: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
436:
437:
438: EXCEPTION
439:

Line 1068: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');

1064:
1065: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'No of Rows deleted : '||lv_total);
1066:
1067:
1068: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1069: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1070: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1071:
1072: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_FCT ends here----

Line 1069: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));

1065: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'No of Rows deleted : '||lv_total);
1066:
1067:
1068: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1069: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1070: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1071:
1072: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_FCT ends here----
1073:

Line 1070: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);

1066:
1067:
1068: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1069: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1070: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1071:
1072: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_FCT ends here----
1073:
1074:

Line 1107: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');

1103:
1104: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'No of Rows deleted : '||lv_total);
1105:
1106:
1107: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1108: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1109: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1110:
1111: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_MDS ends here----

Line 1108: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));

1104: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'No of Rows deleted : '||lv_total);
1105:
1106:
1107: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1108: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1109: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1110:
1111: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_MDS ends here----
1112:

Line 1109: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);

1105:
1106:
1107: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1108: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1109: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1110:
1111: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_MDS ends here----
1112:
1113:

Line 1145: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');

1141:
1142:
1143: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'No of Rows deleted : '||lv_total);
1144:
1145: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1146: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1147: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1148:
1149: -- Deletion from MSC_LOCAL_ID_DEMAND for entity_name SALES_ORDER_ID ends here----

Line 1146: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));

1142:
1143: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'No of Rows deleted : '||lv_total);
1144:
1145: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1146: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1147: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1148:
1149: -- Deletion from MSC_LOCAL_ID_DEMAND for entity_name SALES_ORDER_ID ends here----
1150:

Line 1147: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);

1143: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'No of Rows deleted : '||lv_total);
1144:
1145: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1146: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1147: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1148:
1149: -- Deletion from MSC_LOCAL_ID_DEMAND for entity_name SALES_ORDER_ID ends here----
1150:
1151:

Line 1182: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');

1178: COMMIT;
1179:
1180: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'No of Rows deleted : '||lv_total);
1181:
1182: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1183: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1184: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1185:
1186: -- Deletion from MSC_LOCAL_ID_DEMAND for entity_name DEMAND_ID ends here ----

Line 1183: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));

1179:
1180: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'No of Rows deleted : '||lv_total);
1181:
1182: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1183: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1184: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1185:
1186: -- Deletion from MSC_LOCAL_ID_DEMAND for entity_name DEMAND_ID ends here ----
1187:

Line 1184: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);

1180: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'No of Rows deleted : '||lv_total);
1181:
1182: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1183: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1184: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1185:
1186: -- Deletion from MSC_LOCAL_ID_DEMAND for entity_name DEMAND_ID ends here ----
1187:
1188:

Line 1228: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');

1224:
1225: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'No of Rows deleted : '||lv_total);
1226:
1227:
1228: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1229: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' '||FND_MESSAGE.GET);
1231:
1232: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name WIP_ENTITY_ID ends here ----

Line 1229: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));

1225: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'No of Rows deleted : '||lv_total);
1226:
1227:
1228: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1229: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' '||FND_MESSAGE.GET);
1231:
1232: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name WIP_ENTITY_ID ends here ----
1233:

Line 1230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' '||FND_MESSAGE.GET);

1226:
1227:
1228: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1229: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' '||FND_MESSAGE.GET);
1231:
1232: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name WIP_ENTITY_ID ends here ----
1233:
1234:

Line 1266: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');

1262:
1263: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'No of Rows deleted : '||lv_total);
1264:
1265:
1266: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1267: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1268: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1269:
1270: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name SR_MTL_SUPPLY_ID ends here ----

Line 1267: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));

1263: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'No of Rows deleted : '||lv_total);
1264:
1265:
1266: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1267: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1268: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1269:
1270: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name SR_MTL_SUPPLY_ID ends here ----
1271:

Line 1268: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);

1264:
1265:
1266: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1267: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1268: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1269:
1270: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name SR_MTL_SUPPLY_ID ends here ----
1271:
1272:

Line 1303: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');

1299:
1300: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'No of Rows deleted : '||lv_total);
1301:
1302:
1303: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1304: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1305: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1306:
1307: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name PO_LINE_ID ends here ----

Line 1304: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));

1300: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'No of Rows deleted : '||lv_total);
1301:
1302:
1303: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1304: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1305: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1306:
1307: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name PO_LINE_ID ends here ----
1308:

Line 1305: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);

1301:
1302:
1303: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1304: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1305: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1306:
1307: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name PO_LINE_ID ends here ----
1308:
1309: -- Delete from MSC_LOCAL_ID_SUPPLY for entity_name DISPOSITION_ID starts here --

Line 1340: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');

1336:
1337: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'No of Rows deleted : '||lv_total);
1338:
1339:
1340: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1341: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1342: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1343:
1344: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name DISPOSITION_ID ends here ----

Line 1341: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));

1337: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'No of Rows deleted : '||lv_total);
1338:
1339:
1340: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1341: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1342: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1343:
1344: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name DISPOSITION_ID ends here ----
1345:

Line 1342: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);

1338:
1339:
1340: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1341: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1342: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1343:
1344: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name DISPOSITION_ID ends here ----
1345:
1346:

Line 1378: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');

1374:
1375: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'No of Rows deleted : '||lv_total);
1376:
1377:
1378: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1379: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1380: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1381:
1382: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name DISPOSITION_ID_MPS ends here ----

Line 1379: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));

1375: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'No of Rows deleted : '||lv_total);
1376:
1377:
1378: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1379: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1380: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1381:
1382: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name DISPOSITION_ID_MPS ends here ----
1383:

Line 1380: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);

1376:
1377:
1378: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1379: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1380: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1381:
1382: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name DISPOSITION_ID_MPS ends here ----
1383:
1384:

Line 1416: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');

1412:
1413: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' No of Rows deleted : '||lv_total);
1414:
1415:
1416: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1417: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1418: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1419:
1420: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name SCHEDULE_GROUP_ID ends here ----

Line 1417: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));

1413: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' No of Rows deleted : '||lv_total);
1414:
1415:
1416: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1417: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1418: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1419:
1420: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name SCHEDULE_GROUP_ID ends here ----
1421: END IF ; -- p_suply_flag

Line 1418: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);

1414:
1415:
1416: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1417: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1418: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1419:
1420: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name SCHEDULE_GROUP_ID ends here ----
1421: END IF ; -- p_suply_flag
1422: END IF ; -- Complete refresh

Line 1427: FND_MESSAGE.SET_NAME('MSC', 'MSC_PP_PURGE_SUCCEED');

1423:
1424: --------- Till here modified for the bug fix 2229944 --------------
1425:
1426:
1427: FND_MESSAGE.SET_NAME('MSC', 'MSC_PP_PURGE_SUCCEED');
1428: ERRBUF:= FND_MESSAGE.GET;
1429: RETCODE := G_SUCCESS;
1430: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ERRBUF);
1431: RETCODE := G_SUCCESS;

Line 1428: ERRBUF:= FND_MESSAGE.GET;

1424: --------- Till here modified for the bug fix 2229944 --------------
1425:
1426:
1427: FND_MESSAGE.SET_NAME('MSC', 'MSC_PP_PURGE_SUCCEED');
1428: ERRBUF:= FND_MESSAGE.GET;
1429: RETCODE := G_SUCCESS;
1430: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ERRBUF);
1431: RETCODE := G_SUCCESS;
1432: