APPS.MSC_X_PURGE_SUPDEM_HISTORY_PKG dependencies on FND_MESSAGE

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

69: EXECUTE IMMEDIATE lv_sql_stmt;
70: COMMIT;
71: LOG_MESSAGE('Table MSC_SUP_DEM_HISTORY truncated.');
72:
73: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
74: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
75: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
76: LOG_MESSAGE(' '||FND_MESSAGE.GET);
77:

Line 74: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',

70: COMMIT;
71: LOG_MESSAGE('Table MSC_SUP_DEM_HISTORY truncated.');
72:
73: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
74: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
75: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
76: LOG_MESSAGE(' '||FND_MESSAGE.GET);
77:
78: ELSE

Line 76: LOG_MESSAGE(' '||FND_MESSAGE.GET);

72:
73: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
74: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
75: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
76: LOG_MESSAGE(' '||FND_MESSAGE.GET);
77:
78: ELSE
79: /* create the basic delete sql for Deletes in batches of 100K */
80: lv_sql_stmt := ' DELETE /*+ PARALLEL(msdh) */ '

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

126: LOOP
127: EXECUTE IMMEDIATE lv_sql_stmt;
128: LOG_MESSAGE('Number of records deleted in SQL#1 : ' || SQL%ROWCOUNT);
129:
130: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
131: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
132: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
133: LOG_MESSAGE(' '||FND_MESSAGE.GET);
134:

Line 131: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',

127: EXECUTE IMMEDIATE lv_sql_stmt;
128: LOG_MESSAGE('Number of records deleted in SQL#1 : ' || SQL%ROWCOUNT);
129:
130: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
131: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
132: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
133: LOG_MESSAGE(' '||FND_MESSAGE.GET);
134:
135: lv_task_start_time := SYSDATE;

Line 133: LOG_MESSAGE(' '||FND_MESSAGE.GET);

129:
130: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
131: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
132: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
133: LOG_MESSAGE(' '||FND_MESSAGE.GET);
134:
135: lv_task_start_time := SYSDATE;
136:
137: EXIT WHEN SQL%ROWCOUNT= 0;

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

143: LOOP
144: EXECUTE IMMEDIATE lv_sql_stmt1;
145: LOG_MESSAGE('Number of records deleted in SQL#2 : ' || SQL%ROWCOUNT);
146:
147: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
148: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
149: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
150: LOG_MESSAGE(' '||FND_MESSAGE.GET);
151:

Line 148: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',

144: EXECUTE IMMEDIATE lv_sql_stmt1;
145: LOG_MESSAGE('Number of records deleted in SQL#2 : ' || SQL%ROWCOUNT);
146:
147: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
148: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
149: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
150: LOG_MESSAGE(' '||FND_MESSAGE.GET);
151:
152: lv_task_start_time := SYSDATE;

Line 150: LOG_MESSAGE(' '||FND_MESSAGE.GET);

146:
147: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
148: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
149: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
150: LOG_MESSAGE(' '||FND_MESSAGE.GET);
151:
152: lv_task_start_time := SYSDATE;
153:
154: EXIT WHEN SQL%ROWCOUNT= 0;