DBA Data[Home] [Help]

APPS.INVPOPIF dependencies on FND_FILE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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:

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

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

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

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;

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

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:

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

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;

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

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:

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

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;

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

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: