42: BEGIN
43:
44: RETCODE := G_SUCCESS;
45:
46: FND_FILE.put_line (FND_FILE.log, 'Import Items');
47: FND_FILE.put_line (FND_FILE.log, '--------------------------------------------------------------------------------');
48: FND_FILE.put_line (FND_FILE.log, 'Argument 1 (ORG_ID) = '||p_org_id);
49: FND_FILE.put_line (FND_FILE.log, 'Argument 2 (ALL_ORG) = '||p_all_org);
50: FND_FILE.put_line (FND_FILE.log, 'Argument 3 (VAL_ITEM_FLAG) = '||p_val_item_flag);
43:
44: RETCODE := G_SUCCESS;
45:
46: FND_FILE.put_line (FND_FILE.log, 'Import Items');
47: FND_FILE.put_line (FND_FILE.log, '--------------------------------------------------------------------------------');
48: FND_FILE.put_line (FND_FILE.log, 'Argument 1 (ORG_ID) = '||p_org_id);
49: FND_FILE.put_line (FND_FILE.log, 'Argument 2 (ALL_ORG) = '||p_all_org);
50: FND_FILE.put_line (FND_FILE.log, 'Argument 3 (VAL_ITEM_FLAG) = '||p_val_item_flag);
51: FND_FILE.put_line (FND_FILE.log, 'Argument 4 (PRO_ITEM_FLAG) = '||p_pro_item_flag);
44: RETCODE := G_SUCCESS;
45:
46: FND_FILE.put_line (FND_FILE.log, 'Import Items');
47: FND_FILE.put_line (FND_FILE.log, '--------------------------------------------------------------------------------');
48: FND_FILE.put_line (FND_FILE.log, 'Argument 1 (ORG_ID) = '||p_org_id);
49: FND_FILE.put_line (FND_FILE.log, 'Argument 2 (ALL_ORG) = '||p_all_org);
50: FND_FILE.put_line (FND_FILE.log, 'Argument 3 (VAL_ITEM_FLAG) = '||p_val_item_flag);
51: FND_FILE.put_line (FND_FILE.log, 'Argument 4 (PRO_ITEM_FLAG) = '||p_pro_item_flag);
52: FND_FILE.put_line (FND_FILE.log, 'Argument 5 (DEL_REC_FLAG) = '||p_del_rec_flag);
45:
46: FND_FILE.put_line (FND_FILE.log, 'Import Items');
47: FND_FILE.put_line (FND_FILE.log, '--------------------------------------------------------------------------------');
48: FND_FILE.put_line (FND_FILE.log, 'Argument 1 (ORG_ID) = '||p_org_id);
49: FND_FILE.put_line (FND_FILE.log, 'Argument 2 (ALL_ORG) = '||p_all_org);
50: FND_FILE.put_line (FND_FILE.log, 'Argument 3 (VAL_ITEM_FLAG) = '||p_val_item_flag);
51: FND_FILE.put_line (FND_FILE.log, 'Argument 4 (PRO_ITEM_FLAG) = '||p_pro_item_flag);
52: FND_FILE.put_line (FND_FILE.log, 'Argument 5 (DEL_REC_FLAG) = '||p_del_rec_flag);
53: FND_FILE.put_line (FND_FILE.log, 'Argument 6 (PROCESS_SET) = '||p_xset_id);
46: FND_FILE.put_line (FND_FILE.log, 'Import Items');
47: FND_FILE.put_line (FND_FILE.log, '--------------------------------------------------------------------------------');
48: FND_FILE.put_line (FND_FILE.log, 'Argument 1 (ORG_ID) = '||p_org_id);
49: FND_FILE.put_line (FND_FILE.log, 'Argument 2 (ALL_ORG) = '||p_all_org);
50: FND_FILE.put_line (FND_FILE.log, 'Argument 3 (VAL_ITEM_FLAG) = '||p_val_item_flag);
51: FND_FILE.put_line (FND_FILE.log, 'Argument 4 (PRO_ITEM_FLAG) = '||p_pro_item_flag);
52: FND_FILE.put_line (FND_FILE.log, 'Argument 5 (DEL_REC_FLAG) = '||p_del_rec_flag);
53: FND_FILE.put_line (FND_FILE.log, 'Argument 6 (PROCESS_SET) = '||p_xset_id);
54: FND_FILE.put_line (FND_FILE.log, 'Argument 7 (MODE) = '||p_run_mode);
47: FND_FILE.put_line (FND_FILE.log, '--------------------------------------------------------------------------------');
48: FND_FILE.put_line (FND_FILE.log, 'Argument 1 (ORG_ID) = '||p_org_id);
49: FND_FILE.put_line (FND_FILE.log, 'Argument 2 (ALL_ORG) = '||p_all_org);
50: FND_FILE.put_line (FND_FILE.log, 'Argument 3 (VAL_ITEM_FLAG) = '||p_val_item_flag);
51: FND_FILE.put_line (FND_FILE.log, 'Argument 4 (PRO_ITEM_FLAG) = '||p_pro_item_flag);
52: FND_FILE.put_line (FND_FILE.log, 'Argument 5 (DEL_REC_FLAG) = '||p_del_rec_flag);
53: FND_FILE.put_line (FND_FILE.log, 'Argument 6 (PROCESS_SET) = '||p_xset_id);
54: FND_FILE.put_line (FND_FILE.log, 'Argument 7 (MODE) = '||p_run_mode);
55: FND_FILE.put_line (FND_FILE.log, '--------------------------------------------------------------------------------');
48: FND_FILE.put_line (FND_FILE.log, 'Argument 1 (ORG_ID) = '||p_org_id);
49: FND_FILE.put_line (FND_FILE.log, 'Argument 2 (ALL_ORG) = '||p_all_org);
50: FND_FILE.put_line (FND_FILE.log, 'Argument 3 (VAL_ITEM_FLAG) = '||p_val_item_flag);
51: FND_FILE.put_line (FND_FILE.log, 'Argument 4 (PRO_ITEM_FLAG) = '||p_pro_item_flag);
52: FND_FILE.put_line (FND_FILE.log, 'Argument 5 (DEL_REC_FLAG) = '||p_del_rec_flag);
53: FND_FILE.put_line (FND_FILE.log, 'Argument 6 (PROCESS_SET) = '||p_xset_id);
54: FND_FILE.put_line (FND_FILE.log, 'Argument 7 (MODE) = '||p_run_mode);
55: FND_FILE.put_line (FND_FILE.log, '--------------------------------------------------------------------------------');
56: FND_FILE.put_line (FND_FILE.log, ' ');
49: FND_FILE.put_line (FND_FILE.log, 'Argument 2 (ALL_ORG) = '||p_all_org);
50: FND_FILE.put_line (FND_FILE.log, 'Argument 3 (VAL_ITEM_FLAG) = '||p_val_item_flag);
51: FND_FILE.put_line (FND_FILE.log, 'Argument 4 (PRO_ITEM_FLAG) = '||p_pro_item_flag);
52: FND_FILE.put_line (FND_FILE.log, 'Argument 5 (DEL_REC_FLAG) = '||p_del_rec_flag);
53: FND_FILE.put_line (FND_FILE.log, 'Argument 6 (PROCESS_SET) = '||p_xset_id);
54: FND_FILE.put_line (FND_FILE.log, 'Argument 7 (MODE) = '||p_run_mode);
55: FND_FILE.put_line (FND_FILE.log, '--------------------------------------------------------------------------------');
56: FND_FILE.put_line (FND_FILE.log, ' ');
57:
50: FND_FILE.put_line (FND_FILE.log, 'Argument 3 (VAL_ITEM_FLAG) = '||p_val_item_flag);
51: FND_FILE.put_line (FND_FILE.log, 'Argument 4 (PRO_ITEM_FLAG) = '||p_pro_item_flag);
52: FND_FILE.put_line (FND_FILE.log, 'Argument 5 (DEL_REC_FLAG) = '||p_del_rec_flag);
53: FND_FILE.put_line (FND_FILE.log, 'Argument 6 (PROCESS_SET) = '||p_xset_id);
54: FND_FILE.put_line (FND_FILE.log, 'Argument 7 (MODE) = '||p_run_mode);
55: FND_FILE.put_line (FND_FILE.log, '--------------------------------------------------------------------------------');
56: FND_FILE.put_line (FND_FILE.log, ' ');
57:
58: IF p_xset_id IS NULL THEN
51: FND_FILE.put_line (FND_FILE.log, 'Argument 4 (PRO_ITEM_FLAG) = '||p_pro_item_flag);
52: FND_FILE.put_line (FND_FILE.log, 'Argument 5 (DEL_REC_FLAG) = '||p_del_rec_flag);
53: FND_FILE.put_line (FND_FILE.log, 'Argument 6 (PROCESS_SET) = '||p_xset_id);
54: FND_FILE.put_line (FND_FILE.log, 'Argument 7 (MODE) = '||p_run_mode);
55: FND_FILE.put_line (FND_FILE.log, '--------------------------------------------------------------------------------');
56: FND_FILE.put_line (FND_FILE.log, ' ');
57:
58: IF p_xset_id IS NULL THEN
59:
52: FND_FILE.put_line (FND_FILE.log, 'Argument 5 (DEL_REC_FLAG) = '||p_del_rec_flag);
53: FND_FILE.put_line (FND_FILE.log, 'Argument 6 (PROCESS_SET) = '||p_xset_id);
54: FND_FILE.put_line (FND_FILE.log, 'Argument 7 (MODE) = '||p_run_mode);
55: FND_FILE.put_line (FND_FILE.log, '--------------------------------------------------------------------------------');
56: FND_FILE.put_line (FND_FILE.log, ' ');
57:
58: IF p_xset_id IS NULL THEN
59:
60: IF p_run_mode = 1 THEN
120: AND request_id = FND_GLOBAL.conc_request_id
121: AND rownum = 1;
122:
123: IF l_pro_flag_3 > 0 THEN
124: FND_FILE.put_line (FND_FILE.log, 'Validation errors occured during Import Item');
125: FND_FILE.put_line (FND_FILE.log, 'Refer to table MTL_INTERFACE_ERRORS to access validation errors');
126: ERRBUF := 'Validation errors occured during Import Item';
127: RETCODE := G_WARNING;
128: END IF;
121: AND rownum = 1;
122:
123: IF l_pro_flag_3 > 0 THEN
124: FND_FILE.put_line (FND_FILE.log, 'Validation errors occured during Import Item');
125: FND_FILE.put_line (FND_FILE.log, 'Refer to table MTL_INTERFACE_ERRORS to access validation errors');
126: ERRBUF := 'Validation errors occured during Import Item';
127: RETCODE := G_WARNING;
128: END IF;
129:
127: RETCODE := G_WARNING;
128: END IF;
129:
130: IF ret_status <> 0 THEN
131: FND_FILE.put_line (FND_FILE.log, 'Exceptions occured during Import Item');
132: FND_FILE.put_line (FND_FILE.log, err_text);
133: ERRBUF := err_text;
134: RETCODE := G_ERROR;
135: END IF;
128: END IF;
129:
130: IF ret_status <> 0 THEN
131: FND_FILE.put_line (FND_FILE.log, 'Exceptions occured during Import Item');
132: FND_FILE.put_line (FND_FILE.log, err_text);
133: ERRBUF := err_text;
134: RETCODE := G_ERROR;
135: END IF;
136:
135: END IF;
136:
137: EXCEPTION
138: WHEN others THEN
139: FND_FILE.put_line (FND_FILE.log, 'Exceptions occured during Import Item');
140: FND_FILE.put_line (FND_FILE.log, SQLERRM);
141: ERRBUF := SQLERRM;
142: RETCODE := G_ERROR;
143: END;
136:
137: EXCEPTION
138: WHEN others THEN
139: FND_FILE.put_line (FND_FILE.log, 'Exceptions occured during Import Item');
140: FND_FILE.put_line (FND_FILE.log, SQLERRM);
141: ERRBUF := SQLERRM;
142: RETCODE := G_ERROR;
143: END;
144: