52: BEGIN
53:
54: RETCODE := G_SUCCESS;
55:
56: FND_FILE.put_line (FND_FILE.log, 'Import Items');
57: FND_FILE.put_line (FND_FILE.log, '--------------------------------------------------------------------------------');
58: FND_FILE.put_line (FND_FILE.log, 'Argument 1 (ORG_ID) = '||p_org_id);
59: FND_FILE.put_line (FND_FILE.log, 'Argument 2 (ALL_ORG) = '||p_all_org);
60: FND_FILE.put_line (FND_FILE.log, 'Argument 3 (VAL_ITEM_FLAG) = '||p_val_item_flag);
53:
54: RETCODE := G_SUCCESS;
55:
56: FND_FILE.put_line (FND_FILE.log, 'Import Items');
57: FND_FILE.put_line (FND_FILE.log, '--------------------------------------------------------------------------------');
58: FND_FILE.put_line (FND_FILE.log, 'Argument 1 (ORG_ID) = '||p_org_id);
59: FND_FILE.put_line (FND_FILE.log, 'Argument 2 (ALL_ORG) = '||p_all_org);
60: FND_FILE.put_line (FND_FILE.log, 'Argument 3 (VAL_ITEM_FLAG) = '||p_val_item_flag);
61: FND_FILE.put_line (FND_FILE.log, 'Argument 4 (PRO_ITEM_FLAG) = '||p_pro_item_flag);
54: RETCODE := G_SUCCESS;
55:
56: FND_FILE.put_line (FND_FILE.log, 'Import Items');
57: FND_FILE.put_line (FND_FILE.log, '--------------------------------------------------------------------------------');
58: FND_FILE.put_line (FND_FILE.log, 'Argument 1 (ORG_ID) = '||p_org_id);
59: FND_FILE.put_line (FND_FILE.log, 'Argument 2 (ALL_ORG) = '||p_all_org);
60: FND_FILE.put_line (FND_FILE.log, 'Argument 3 (VAL_ITEM_FLAG) = '||p_val_item_flag);
61: FND_FILE.put_line (FND_FILE.log, 'Argument 4 (PRO_ITEM_FLAG) = '||p_pro_item_flag);
62: FND_FILE.put_line (FND_FILE.log, 'Argument 5 (DEL_REC_FLAG) = '||p_del_rec_flag);
55:
56: FND_FILE.put_line (FND_FILE.log, 'Import Items');
57: FND_FILE.put_line (FND_FILE.log, '--------------------------------------------------------------------------------');
58: FND_FILE.put_line (FND_FILE.log, 'Argument 1 (ORG_ID) = '||p_org_id);
59: FND_FILE.put_line (FND_FILE.log, 'Argument 2 (ALL_ORG) = '||p_all_org);
60: FND_FILE.put_line (FND_FILE.log, 'Argument 3 (VAL_ITEM_FLAG) = '||p_val_item_flag);
61: FND_FILE.put_line (FND_FILE.log, 'Argument 4 (PRO_ITEM_FLAG) = '||p_pro_item_flag);
62: FND_FILE.put_line (FND_FILE.log, 'Argument 5 (DEL_REC_FLAG) = '||p_del_rec_flag);
63: FND_FILE.put_line (FND_FILE.log, 'Argument 6 (PROCESS_SET) = '||p_xset_id);
56: FND_FILE.put_line (FND_FILE.log, 'Import Items');
57: FND_FILE.put_line (FND_FILE.log, '--------------------------------------------------------------------------------');
58: FND_FILE.put_line (FND_FILE.log, 'Argument 1 (ORG_ID) = '||p_org_id);
59: FND_FILE.put_line (FND_FILE.log, 'Argument 2 (ALL_ORG) = '||p_all_org);
60: FND_FILE.put_line (FND_FILE.log, 'Argument 3 (VAL_ITEM_FLAG) = '||p_val_item_flag);
61: FND_FILE.put_line (FND_FILE.log, 'Argument 4 (PRO_ITEM_FLAG) = '||p_pro_item_flag);
62: FND_FILE.put_line (FND_FILE.log, 'Argument 5 (DEL_REC_FLAG) = '||p_del_rec_flag);
63: FND_FILE.put_line (FND_FILE.log, 'Argument 6 (PROCESS_SET) = '||p_xset_id);
64: FND_FILE.put_line (FND_FILE.log, 'Argument 7 (MODE) = '||p_run_mode);
57: FND_FILE.put_line (FND_FILE.log, '--------------------------------------------------------------------------------');
58: FND_FILE.put_line (FND_FILE.log, 'Argument 1 (ORG_ID) = '||p_org_id);
59: FND_FILE.put_line (FND_FILE.log, 'Argument 2 (ALL_ORG) = '||p_all_org);
60: FND_FILE.put_line (FND_FILE.log, 'Argument 3 (VAL_ITEM_FLAG) = '||p_val_item_flag);
61: FND_FILE.put_line (FND_FILE.log, 'Argument 4 (PRO_ITEM_FLAG) = '||p_pro_item_flag);
62: FND_FILE.put_line (FND_FILE.log, 'Argument 5 (DEL_REC_FLAG) = '||p_del_rec_flag);
63: FND_FILE.put_line (FND_FILE.log, 'Argument 6 (PROCESS_SET) = '||p_xset_id);
64: FND_FILE.put_line (FND_FILE.log, 'Argument 7 (MODE) = '||p_run_mode);
65: FND_FILE.put_line (FND_FILE.log, 'Argument 8 (Gather Stats) = '||p_gather_stats);
58: FND_FILE.put_line (FND_FILE.log, 'Argument 1 (ORG_ID) = '||p_org_id);
59: FND_FILE.put_line (FND_FILE.log, 'Argument 2 (ALL_ORG) = '||p_all_org);
60: FND_FILE.put_line (FND_FILE.log, 'Argument 3 (VAL_ITEM_FLAG) = '||p_val_item_flag);
61: FND_FILE.put_line (FND_FILE.log, 'Argument 4 (PRO_ITEM_FLAG) = '||p_pro_item_flag);
62: FND_FILE.put_line (FND_FILE.log, 'Argument 5 (DEL_REC_FLAG) = '||p_del_rec_flag);
63: FND_FILE.put_line (FND_FILE.log, 'Argument 6 (PROCESS_SET) = '||p_xset_id);
64: FND_FILE.put_line (FND_FILE.log, 'Argument 7 (MODE) = '||p_run_mode);
65: FND_FILE.put_line (FND_FILE.log, 'Argument 8 (Gather Stats) = '||p_gather_stats);
66: FND_FILE.put_line (FND_FILE.log, '--------------------------------------------------------------------------------');
59: FND_FILE.put_line (FND_FILE.log, 'Argument 2 (ALL_ORG) = '||p_all_org);
60: FND_FILE.put_line (FND_FILE.log, 'Argument 3 (VAL_ITEM_FLAG) = '||p_val_item_flag);
61: FND_FILE.put_line (FND_FILE.log, 'Argument 4 (PRO_ITEM_FLAG) = '||p_pro_item_flag);
62: FND_FILE.put_line (FND_FILE.log, 'Argument 5 (DEL_REC_FLAG) = '||p_del_rec_flag);
63: FND_FILE.put_line (FND_FILE.log, 'Argument 6 (PROCESS_SET) = '||p_xset_id);
64: FND_FILE.put_line (FND_FILE.log, 'Argument 7 (MODE) = '||p_run_mode);
65: FND_FILE.put_line (FND_FILE.log, 'Argument 8 (Gather Stats) = '||p_gather_stats);
66: FND_FILE.put_line (FND_FILE.log, '--------------------------------------------------------------------------------');
67: FND_FILE.put_line (FND_FILE.log, ' ');
60: FND_FILE.put_line (FND_FILE.log, 'Argument 3 (VAL_ITEM_FLAG) = '||p_val_item_flag);
61: FND_FILE.put_line (FND_FILE.log, 'Argument 4 (PRO_ITEM_FLAG) = '||p_pro_item_flag);
62: FND_FILE.put_line (FND_FILE.log, 'Argument 5 (DEL_REC_FLAG) = '||p_del_rec_flag);
63: FND_FILE.put_line (FND_FILE.log, 'Argument 6 (PROCESS_SET) = '||p_xset_id);
64: FND_FILE.put_line (FND_FILE.log, 'Argument 7 (MODE) = '||p_run_mode);
65: FND_FILE.put_line (FND_FILE.log, 'Argument 8 (Gather Stats) = '||p_gather_stats);
66: FND_FILE.put_line (FND_FILE.log, '--------------------------------------------------------------------------------');
67: FND_FILE.put_line (FND_FILE.log, ' ');
68:
61: FND_FILE.put_line (FND_FILE.log, 'Argument 4 (PRO_ITEM_FLAG) = '||p_pro_item_flag);
62: FND_FILE.put_line (FND_FILE.log, 'Argument 5 (DEL_REC_FLAG) = '||p_del_rec_flag);
63: FND_FILE.put_line (FND_FILE.log, 'Argument 6 (PROCESS_SET) = '||p_xset_id);
64: FND_FILE.put_line (FND_FILE.log, 'Argument 7 (MODE) = '||p_run_mode);
65: FND_FILE.put_line (FND_FILE.log, 'Argument 8 (Gather Stats) = '||p_gather_stats);
66: FND_FILE.put_line (FND_FILE.log, '--------------------------------------------------------------------------------');
67: FND_FILE.put_line (FND_FILE.log, ' ');
68:
69: IF p_xset_id IS NULL THEN
62: FND_FILE.put_line (FND_FILE.log, 'Argument 5 (DEL_REC_FLAG) = '||p_del_rec_flag);
63: FND_FILE.put_line (FND_FILE.log, 'Argument 6 (PROCESS_SET) = '||p_xset_id);
64: FND_FILE.put_line (FND_FILE.log, 'Argument 7 (MODE) = '||p_run_mode);
65: FND_FILE.put_line (FND_FILE.log, 'Argument 8 (Gather Stats) = '||p_gather_stats);
66: FND_FILE.put_line (FND_FILE.log, '--------------------------------------------------------------------------------');
67: FND_FILE.put_line (FND_FILE.log, ' ');
68:
69: IF p_xset_id IS NULL THEN
70:
63: FND_FILE.put_line (FND_FILE.log, 'Argument 6 (PROCESS_SET) = '||p_xset_id);
64: FND_FILE.put_line (FND_FILE.log, 'Argument 7 (MODE) = '||p_run_mode);
65: FND_FILE.put_line (FND_FILE.log, 'Argument 8 (Gather Stats) = '||p_gather_stats);
66: FND_FILE.put_line (FND_FILE.log, '--------------------------------------------------------------------------------');
67: FND_FILE.put_line (FND_FILE.log, ' ');
68:
69: IF p_xset_id IS NULL THEN
70:
71: IF p_run_mode = 1 THEN
132: AND request_id = FND_GLOBAL.conc_request_id
133: AND rownum = 1;
134:
135: IF l_pro_flag_3 > 0 THEN
136: FND_FILE.put_line (FND_FILE.log, 'Validation errors occured during Import Item');
137: FND_FILE.put_line (FND_FILE.log, 'Refer to table MTL_INTERFACE_ERRORS to access validation errors');
138: ERRBUF := 'Validation errors occured during Import Item';
139: RETCODE := G_WARNING;
140: END IF;
133: AND rownum = 1;
134:
135: IF l_pro_flag_3 > 0 THEN
136: FND_FILE.put_line (FND_FILE.log, 'Validation errors occured during Import Item');
137: FND_FILE.put_line (FND_FILE.log, 'Refer to table MTL_INTERFACE_ERRORS to access validation errors');
138: ERRBUF := 'Validation errors occured during Import Item';
139: RETCODE := G_WARNING;
140: END IF;
141:
139: RETCODE := G_WARNING;
140: END IF;
141:
142: IF ret_status <> 0 THEN
143: FND_FILE.put_line (FND_FILE.log, 'Exceptions occured during Import Item');
144: FND_FILE.put_line (FND_FILE.log, err_text);
145: ERRBUF := err_text;
146: RETCODE := G_ERROR;
147: END IF;
140: END IF;
141:
142: IF ret_status <> 0 THEN
143: FND_FILE.put_line (FND_FILE.log, 'Exceptions occured during Import Item');
144: FND_FILE.put_line (FND_FILE.log, err_text);
145: ERRBUF := err_text;
146: RETCODE := G_ERROR;
147: END IF;
148:
147: END IF;
148:
149: EXCEPTION
150: WHEN others THEN
151: FND_FILE.put_line (FND_FILE.log, 'Exceptions occured during Import Item');
152: FND_FILE.put_line (FND_FILE.log, SQLERRM);
153: ERRBUF := SQLERRM;
154: RETCODE := G_ERROR;
155: END;
148:
149: EXCEPTION
150: WHEN others THEN
151: FND_FILE.put_line (FND_FILE.log, 'Exceptions occured during Import Item');
152: FND_FILE.put_line (FND_FILE.log, SQLERRM);
153: ERRBUF := SQLERRM;
154: RETCODE := G_ERROR;
155: END;
156: