DBA Data[Home] [Help]

APPS.INVPOPIF dependencies on FND_FILE

Line 56: FND_FILE.put_line (FND_FILE.log, 'Import Items');

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

Line 57: FND_FILE.put_line (FND_FILE.log, '--------------------------------------------------------------------------------');

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

Line 58: FND_FILE.put_line (FND_FILE.log, 'Argument 1 (ORG_ID) = '||p_org_id);

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

Line 59: FND_FILE.put_line (FND_FILE.log, 'Argument 2 (ALL_ORG) = '||p_all_org);

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

Line 60: FND_FILE.put_line (FND_FILE.log, 'Argument 3 (VAL_ITEM_FLAG) = '||p_val_item_flag);

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

Line 61: FND_FILE.put_line (FND_FILE.log, 'Argument 4 (PRO_ITEM_FLAG) = '||p_pro_item_flag);

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

Line 62: FND_FILE.put_line (FND_FILE.log, 'Argument 5 (DEL_REC_FLAG) = '||p_del_rec_flag);

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

Line 63: FND_FILE.put_line (FND_FILE.log, 'Argument 6 (PROCESS_SET) = '||p_xset_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, '--------------------------------------------------------------------------------');
67: FND_FILE.put_line (FND_FILE.log, ' ');

Line 64: FND_FILE.put_line (FND_FILE.log, 'Argument 7 (MODE) = '||p_run_mode);

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:

Line 65: FND_FILE.put_line (FND_FILE.log, 'Argument 8 (Gather Stats) = '||p_gather_stats);

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

Line 66: FND_FILE.put_line (FND_FILE.log, '--------------------------------------------------------------------------------');

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:

Line 67: FND_FILE.put_line (FND_FILE.log, ' ');

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

Line 136: FND_FILE.put_line (FND_FILE.log, 'Validation errors occured during Import Item');

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;

Line 137: FND_FILE.put_line (FND_FILE.log, 'Refer to table MTL_INTERFACE_ERRORS to access validation errors');

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:

Line 143: FND_FILE.put_line (FND_FILE.log, 'Exceptions occured during Import Item');

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;

Line 144: FND_FILE.put_line (FND_FILE.log, err_text);

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:

Line 151: FND_FILE.put_line (FND_FILE.log, 'Exceptions occured during Import Item');

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;

Line 152: FND_FILE.put_line (FND_FILE.log, SQLERRM);

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: