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 51: FND_MESSAGE.SET_NAME('MSC', 'MSC_ST_ERROR_DATA_EXIST');

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

Line 52: ERRBUF:= FND_MESSAGE.GET;

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

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

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

Line 58: errbuf:= FND_MESSAGE.GET;

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

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

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

Line 64: ERRBUF:= FND_MESSAGE.GET;

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

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

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

Line 71: ERRBUF:= FND_MESSAGE.GET;

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

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

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

Line 78: ERRBUF:= FND_MESSAGE.GET;

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

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

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

Line 89: errbuf:= FND_MESSAGE.GET;

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

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

164: 'FND', lv_dummy1,lv_dummy2, v_applsys_schema);
165:
166: lv_task_start_time:= SYSDATE;
167:
168: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
169: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'DELETE_MSC_TABLE:'||p_table_name);
170: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
171:
172:

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

165:
166: lv_task_start_time:= SYSDATE;
167:
168: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
169: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'DELETE_MSC_TABLE:'||p_table_name);
170: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
171:
172:
173: IF p_sub_str IS NULL

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

166: lv_task_start_time:= SYSDATE;
167:
168: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
169: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'DELETE_MSC_TABLE:'||p_table_name);
170: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
171:
172:
173: IF p_sub_str IS NULL
174: AND is_msctbl_partitioned( p_table_name) THEN

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

297:
298: END IF;
299: END IF;
300:
301: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
302: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
303: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
304: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
305:

Line 302: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',

298: END IF;
299: END IF;
300:
301: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
302: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
303: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
304: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
305:
306: EXCEPTION

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

300:
301: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
302: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
303: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
304: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
305:
306: EXCEPTION
307: WHEN OTHERS THEN
308: lv_errtext := substr('DELETE_MSC_TABLE'||'('

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

338: BEGIN
339:
340: lv_task_start_time:= SYSDATE;
341:
342: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
343: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'DELETE_LID_TABLE:'||p_lid_table);
344: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' '||FND_MESSAGE.GET);
345:
346: lv_where_str := p_where_str;

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

339:
340: lv_task_start_time:= SYSDATE;
341:
342: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
343: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'DELETE_LID_TABLE:'||p_lid_table);
344: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' '||FND_MESSAGE.GET);
345:
346: lv_where_str := p_where_str;
347:

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

340: lv_task_start_time:= SYSDATE;
341:
342: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
343: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'DELETE_LID_TABLE:'||p_lid_table);
344: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' '||FND_MESSAGE.GET);
345:
346: lv_where_str := p_where_str;
347:
348: v_sql_stmt := 01;

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

410:
411: COMMIT;
412:
413:
414: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
415: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
416: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
417: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
418:

Line 415: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',

411: COMMIT;
412:
413:
414: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
415: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
416: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
417: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
418:
419:

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

413:
414: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
415: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
416: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
417: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
418:
419:
420: EXCEPTION
421:

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

1051:
1052: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'No of Rows deleted : '||lv_total);
1053:
1054:
1055: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1056: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1057: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1058:
1059: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_FCT ends here----

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

1052: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'No of Rows deleted : '||lv_total);
1053:
1054:
1055: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1056: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1057: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1058:
1059: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_FCT ends here----
1060:

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

1053:
1054:
1055: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1056: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1057: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1058:
1059: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_FCT ends here----
1060:
1061:

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

1090:
1091: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'No of Rows deleted : '||lv_total);
1092:
1093:
1094: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1095: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1096: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1097:
1098: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_MDS ends here----

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

1091: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'No of Rows deleted : '||lv_total);
1092:
1093:
1094: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1095: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1096: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1097:
1098: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_MDS ends here----
1099:

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

1092:
1093:
1094: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1095: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1096: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1097:
1098: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_MDS ends here----
1099:
1100:

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

1128:
1129:
1130: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'No of Rows deleted : '||lv_total);
1131:
1132: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1133: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1134: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1135:
1136: -- Deletion from MSC_LOCAL_ID_DEMAND for entity_name SALES_ORDER_ID ends here----

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

1129:
1130: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'No of Rows deleted : '||lv_total);
1131:
1132: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1133: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1134: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1135:
1136: -- Deletion from MSC_LOCAL_ID_DEMAND for entity_name SALES_ORDER_ID ends here----
1137:

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

1130: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'No of Rows deleted : '||lv_total);
1131:
1132: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1133: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1134: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1135:
1136: -- Deletion from MSC_LOCAL_ID_DEMAND for entity_name SALES_ORDER_ID ends here----
1137:
1138:

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

1165: COMMIT;
1166:
1167: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'No of Rows deleted : '||lv_total);
1168:
1169: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1170: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1171: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1172:
1173: -- Deletion from MSC_LOCAL_ID_DEMAND for entity_name DEMAND_ID ends here ----

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

1166:
1167: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'No of Rows deleted : '||lv_total);
1168:
1169: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1170: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1171: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1172:
1173: -- Deletion from MSC_LOCAL_ID_DEMAND for entity_name DEMAND_ID ends here ----
1174:

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

1167: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'No of Rows deleted : '||lv_total);
1168:
1169: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1170: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1171: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1172:
1173: -- Deletion from MSC_LOCAL_ID_DEMAND for entity_name DEMAND_ID ends here ----
1174:
1175:

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

1225: IF V_DEBUG THEN
1226: MSC_ST_UTIL.LOG_MESSAGE('Deletion Complete ');
1227: END IF ;
1228:
1229: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1230: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1231: MSC_ST_UTIL.LOG_MESSAGE(' '||FND_MESSAGE.GET);
1232:
1233:

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

1226: MSC_ST_UTIL.LOG_MESSAGE('Deletion Complete ');
1227: END IF ;
1228:
1229: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1230: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1231: MSC_ST_UTIL.LOG_MESSAGE(' '||FND_MESSAGE.GET);
1232:
1233:
1234:

Line 1231: MSC_ST_UTIL.LOG_MESSAGE(' '||FND_MESSAGE.GET);

1227: END IF ;
1228:
1229: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1230: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1231: MSC_ST_UTIL.LOG_MESSAGE(' '||FND_MESSAGE.GET);
1232:
1233:
1234:
1235: DELETE_MSC_TABLE( p_table_name =>'MSC_SUPPLIES',

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

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

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

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

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

1268:
1269:
1270: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1271: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1272: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' '||FND_MESSAGE.GET);
1273:
1274: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name WIP_ENTITY_ID ends here ----
1275:
1276:

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

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

Line 1309: 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_DEBUG_1,'No of Rows deleted : '||lv_total);
1306:
1307:
1308: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1309: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1310: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1311:
1312: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name SR_MTL_SUPPLY_ID ends here ----
1313:

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

1306:
1307:
1308: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1309: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1310: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1311:
1312: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name SR_MTL_SUPPLY_ID ends here ----
1313:
1314:

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

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

Line 1346: 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_DEBUG_1,'No of Rows deleted : '||lv_total);
1343:
1344:
1345: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1346: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1347: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1348:
1349: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name PO_LINE_ID ends here ----
1350:

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

1343:
1344:
1345: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1346: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1347: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1348:
1349: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name PO_LINE_ID ends here ----
1350:
1351: -- Delete from MSC_LOCAL_ID_SUPPLY for entity_name DISPOSITION_ID starts here --

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

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

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

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

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

1380:
1381:
1382: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1383: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1384: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1385:
1386: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name DISPOSITION_ID ends here ----
1387:
1388:

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

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

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

1417: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'No of Rows deleted : '||lv_total);
1418:
1419:
1420: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1421: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1422: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1423:
1424: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name DISPOSITION_ID_MPS ends here ----
1425:

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

1418:
1419:
1420: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1421: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1422: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1423:
1424: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name DISPOSITION_ID_MPS ends here ----
1425:
1426:

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

1454:
1455: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' No of Rows deleted : '||lv_total);
1456:
1457:
1458: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1459: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1460: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1461:
1462: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name SCHEDULE_GROUP_ID ends here ----

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

1455: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' No of Rows deleted : '||lv_total);
1456:
1457:
1458: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1459: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1460: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1461:
1462: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name SCHEDULE_GROUP_ID ends here ----
1463: END IF ; -- p_suply_flag

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

1456:
1457:
1458: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1459: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1460: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1461:
1462: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name SCHEDULE_GROUP_ID ends here ----
1463: END IF ; -- p_suply_flag
1464: END IF ; -- Complete refresh

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

1465:
1466: --------- Till here modified for the bug fix 2229944 --------------
1467:
1468:
1469: FND_MESSAGE.SET_NAME('MSC', 'MSC_PP_PURGE_SUCCEED');
1470: ERRBUF:= FND_MESSAGE.GET;
1471: RETCODE := G_SUCCESS;
1472: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ERRBUF);
1473: RETCODE := G_SUCCESS;

Line 1470: ERRBUF:= FND_MESSAGE.GET;

1466: --------- Till here modified for the bug fix 2229944 --------------
1467:
1468:
1469: FND_MESSAGE.SET_NAME('MSC', 'MSC_PP_PURGE_SUCCEED');
1470: ERRBUF:= FND_MESSAGE.GET;
1471: RETCODE := G_SUCCESS;
1472: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, ERRBUF);
1473: RETCODE := G_SUCCESS;
1474: