DBA Data[Home] [Help]

APPS.MSC_PURGE_LID dependencies on MSC_ST_UTIL

Line 1187: msc_st_util.log_message('Delete from MSC_RESOURCE_REQUIREMENTS,MSC_JOB_OPERATIONS,MSC_JOB_OP_RESOURCES,MSC_JOB_REQUIREMENT_OPS for delted supply Id');

1183: lv_total := 0;
1184: v_sql_stmt := 05;
1185:
1186: IF V_DEBUG THEN
1187: msc_st_util.log_message('Delete from MSC_RESOURCE_REQUIREMENTS,MSC_JOB_OPERATIONS,MSC_JOB_OP_RESOURCES,MSC_JOB_REQUIREMENT_OPS for delted supply Id');
1188: END IF;
1189:
1190: OPEN C11(v_instance_id);
1191: LOOP

Line 1226: MSC_ST_UTIL.LOG_MESSAGE('Deletion Complete ');

1222:
1223: CLOSE C11;
1224:
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));

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',