DBA Data[Home] [Help]

APPS.MSC_CL_MISCELLANEOUS dependencies on FND_MESSAGE

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

66: WHERE INSTANCE_ID= arg_instance_id;
67:
68: lv_task_start_time:= SYSDATE;
69:
70: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
71: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING_HISTORY');
72: LOG_MESSAGE(FND_MESSAGE.GET);
73:
74: if (G_START_SH >= 0) then

Line 71: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING_HISTORY');

67:
68: lv_task_start_time:= SYSDATE;
69:
70: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
71: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING_HISTORY');
72: LOG_MESSAGE(FND_MESSAGE.GET);
73:
74: if (G_START_SH >= 0) then
75: --lv_starting_date := sysdate - G_START_SH;

Line 72: LOG_MESSAGE(FND_MESSAGE.GET);

68: lv_task_start_time:= SYSDATE;
69:
70: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
71: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING_HISTORY');
72: LOG_MESSAGE(FND_MESSAGE.GET);
73:
74: if (G_START_SH >= 0) then
75: --lv_starting_date := sysdate - G_START_SH;
76: lv_sql_stmt_app := ' and trunc(x.transaction_date) >= trunc(add_months(sysdate,-('||G_START_SH||')))';

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

126: commit;
127:
128: load_sourcing_history_sub1( lv_assignment_set_id);
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:
128: load_sourcing_history_sub1( lv_assignment_set_id);
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: EXCEPTION

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: EXCEPTION
136: WHEN OTHERS THEN
137: RAISE;

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

174: WHERE INSTANCE_ID= arg_instance_id;
175:
176: lv_task_start_time:= SYSDATE;
177:
178: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
179: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PO_RECEIPTS');
180: LOG_MESSAGE(FND_MESSAGE.GET);
181:
182: if (G_START_SH >= 0) then

Line 179: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PO_RECEIPTS');

175:
176: lv_task_start_time:= SYSDATE;
177:
178: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
179: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PO_RECEIPTS');
180: LOG_MESSAGE(FND_MESSAGE.GET);
181:
182: if (G_START_SH >= 0) then
183: --lv_starting_date := sysdate - G_START_SH;

Line 180: LOG_MESSAGE(FND_MESSAGE.GET);

176: lv_task_start_time:= SYSDATE;
177:
178: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
179: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_PO_RECEIPTS');
180: LOG_MESSAGE(FND_MESSAGE.GET);
181:
182: if (G_START_SH >= 0) then
183: --lv_starting_date := sysdate - G_START_SH;
184: lv_sql_stmt_app := ' and trunc(x.transaction_date) >= trunc(add_months(sysdate,-('||G_START_SH||')))';

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

220: USING v_instance_id, v_current_date, v_current_user,v_current_date, v_current_user, v_instance_id, v_instance_id, v_instance_id;
221:
222: commit;
223:
224: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
225: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
226: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
227: LOG_MESSAGE(FND_MESSAGE.GET);
228:

Line 225: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',

221:
222: commit;
223:
224: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
225: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
226: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
227: LOG_MESSAGE(FND_MESSAGE.GET);
228:
229: EXCEPTION

Line 227: LOG_MESSAGE(FND_MESSAGE.GET);

223:
224: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
225: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',
226: TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
227: LOG_MESSAGE(FND_MESSAGE.GET);
228:
229: EXCEPTION
230: WHEN OTHERS THEN
231: RAISE;

Line 480: FND_MESSAGE.SET_NAME('MSC', 'MSC_SH_TASK_START');

476: lv_start_date:= arg_start_date;
477: END IF;
478:
479: /* These are the Debug messages
480: FND_MESSAGE.SET_NAME('MSC', 'MSC_SH_TASK_START');
481: FND_MESSAGE.SET_TOKEN('ITEM_ID:',arg_item_id);
482: LOG_MESSAGE(FND_MESSAGE.GET);
483:
484: FND_MESSAGE.SET_NAME('MSC', 'MSC_SH_TASK_START');

Line 481: FND_MESSAGE.SET_TOKEN('ITEM_ID:',arg_item_id);

477: END IF;
478:
479: /* These are the Debug messages
480: FND_MESSAGE.SET_NAME('MSC', 'MSC_SH_TASK_START');
481: FND_MESSAGE.SET_TOKEN('ITEM_ID:',arg_item_id);
482: LOG_MESSAGE(FND_MESSAGE.GET);
483:
484: FND_MESSAGE.SET_NAME('MSC', 'MSC_SH_TASK_START');
485: FND_MESSAGE.SET_TOKEN('START_DATE:',lv_start_date);

Line 482: LOG_MESSAGE(FND_MESSAGE.GET);

478:
479: /* These are the Debug messages
480: FND_MESSAGE.SET_NAME('MSC', 'MSC_SH_TASK_START');
481: FND_MESSAGE.SET_TOKEN('ITEM_ID:',arg_item_id);
482: LOG_MESSAGE(FND_MESSAGE.GET);
483:
484: FND_MESSAGE.SET_NAME('MSC', 'MSC_SH_TASK_START');
485: FND_MESSAGE.SET_TOKEN('START_DATE:',lv_start_date);
486: LOG_MESSAGE(FND_MESSAGE.GET);

Line 484: FND_MESSAGE.SET_NAME('MSC', 'MSC_SH_TASK_START');

480: FND_MESSAGE.SET_NAME('MSC', 'MSC_SH_TASK_START');
481: FND_MESSAGE.SET_TOKEN('ITEM_ID:',arg_item_id);
482: LOG_MESSAGE(FND_MESSAGE.GET);
483:
484: FND_MESSAGE.SET_NAME('MSC', 'MSC_SH_TASK_START');
485: FND_MESSAGE.SET_TOKEN('START_DATE:',lv_start_date);
486: LOG_MESSAGE(FND_MESSAGE.GET);
487: */
488:

Line 485: FND_MESSAGE.SET_TOKEN('START_DATE:',lv_start_date);

481: FND_MESSAGE.SET_TOKEN('ITEM_ID:',arg_item_id);
482: LOG_MESSAGE(FND_MESSAGE.GET);
483:
484: FND_MESSAGE.SET_NAME('MSC', 'MSC_SH_TASK_START');
485: FND_MESSAGE.SET_TOKEN('START_DATE:',lv_start_date);
486: LOG_MESSAGE(FND_MESSAGE.GET);
487: */
488:
489: IF arg_source_org IS NULL THEN

Line 486: LOG_MESSAGE(FND_MESSAGE.GET);

482: LOG_MESSAGE(FND_MESSAGE.GET);
483:
484: FND_MESSAGE.SET_NAME('MSC', 'MSC_SH_TASK_START');
485: FND_MESSAGE.SET_TOKEN('START_DATE:',lv_start_date);
486: LOG_MESSAGE(FND_MESSAGE.GET);
487: */
488:
489: IF arg_source_org IS NULL THEN
490: lv_source_type := L_ST_PO_SUPPLIER;