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
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;
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||')))';
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:
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
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;
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
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;
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||')))';
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:
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
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;
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');
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);
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);
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:
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
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;