eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_ITEM_DATA_SCRIPTS dependencies on FND_FILE

Line 18: FND_FILE.put_line (FND_FILE.log, 'Entered procedure proc_io_shippable_flags ');

14:
15: l_sql_stmt_num NUMBER;
16:
17: BEGIN
18: FND_FILE.put_line (FND_FILE.log, 'Entered procedure proc_io_shippable_flags ');
19:
20: l_sql_stmt_num := 1;
21: UPDATE MTL_SYSTEM_ITEMS_B
22: SET INTERNAL_ORDER_ENABLED_FLAG ='N'

Line 42: FND_FILE.put_line (FND_FILE.log, 'End of procedure proc_io_shippable_flags ');

38: AND SHIPPABLE_ITEM_FLAG ='N'
39: AND NVL(CONTRACT_ITEM_TYPE_CODE, 'SUBSCRIPTION') NOT IN
40: ('WARRANTY','SERVICE','USAGE');
41:
42: FND_FILE.put_line (FND_FILE.log, 'End of procedure proc_io_shippable_flags ');
43:
44: EXCEPTION
45: WHEN OTHERS THEN
46: FND_FILE.put_line (FND_FILE.log, 'Exception occured during proc_io_shippable_flags ');

Line 46: FND_FILE.put_line (FND_FILE.log, 'Exception occured during proc_io_shippable_flags ');

42: FND_FILE.put_line (FND_FILE.log, 'End of procedure proc_io_shippable_flags ');
43:
44: EXCEPTION
45: WHEN OTHERS THEN
46: FND_FILE.put_line (FND_FILE.log, 'Exception occured during proc_io_shippable_flags ');
47: FND_FILE.put_line (FND_FILE.log, 'while executing sql statement '||l_sql_stmt_num);
48: FND_FILE.put_line (FND_FILE.log, SQLERRM);
49: errbuf := SQLERRM;
50: retcode := G_ERROR;

Line 47: FND_FILE.put_line (FND_FILE.log, 'while executing sql statement '||l_sql_stmt_num);

43:
44: EXCEPTION
45: WHEN OTHERS THEN
46: FND_FILE.put_line (FND_FILE.log, 'Exception occured during proc_io_shippable_flags ');
47: FND_FILE.put_line (FND_FILE.log, 'while executing sql statement '||l_sql_stmt_num);
48: FND_FILE.put_line (FND_FILE.log, SQLERRM);
49: errbuf := SQLERRM;
50: retcode := G_ERROR;
51: END proc_io_shippable_flags;

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

44: EXCEPTION
45: WHEN OTHERS THEN
46: FND_FILE.put_line (FND_FILE.log, 'Exception occured during proc_io_shippable_flags ');
47: FND_FILE.put_line (FND_FILE.log, 'while executing sql statement '||l_sql_stmt_num);
48: FND_FILE.put_line (FND_FILE.log, SQLERRM);
49: errbuf := SQLERRM;
50: retcode := G_ERROR;
51: END proc_io_shippable_flags;
52:

Line 102: FND_FILE.put_line (FND_FILE.log, 'Start of procedure proc_cat_datafix ');

98:
99: l_cat_set_exists VARCHAR2(8);
100: BEGIN
101:
102: FND_FILE.put_line (FND_FILE.log, 'Start of procedure proc_cat_datafix ');
103:
104: FOR rec_cur IN master_org_cur LOOP
105: /*Case 1 and 2: This will delete additional category records from the child organization
106: that are not present in the Master Organization*/

Line 183: FND_FILE.put_line (FND_FILE.log, 'End of procedure proc_cat_datafix ');

179: END LOOP;
180: END LOOP;
181: END LOOP;
182:
183: FND_FILE.put_line (FND_FILE.log, 'End of procedure proc_cat_datafix ');
184:
185: EXCEPTION
186: WHEN OTHERS THEN
187: FND_FILE.put_line (FND_FILE.log, 'Exception occured during proc_cat_datafix ');

Line 187: FND_FILE.put_line (FND_FILE.log, 'Exception occured during proc_cat_datafix ');

183: FND_FILE.put_line (FND_FILE.log, 'End of procedure proc_cat_datafix ');
184:
185: EXCEPTION
186: WHEN OTHERS THEN
187: FND_FILE.put_line (FND_FILE.log, 'Exception occured during proc_cat_datafix ');
188: FND_FILE.put_line (FND_FILE.log, SQLERRM);
189: errbuf := SQLERRM;
190: retcode := G_ERROR;
191: END proc_cat_datafix;

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

184:
185: EXCEPTION
186: WHEN OTHERS THEN
187: FND_FILE.put_line (FND_FILE.log, 'Exception occured during proc_cat_datafix ');
188: FND_FILE.put_line (FND_FILE.log, SQLERRM);
189: errbuf := SQLERRM;
190: retcode := G_ERROR;
191: END proc_cat_datafix;
192:

Line 203: FND_FILE.put_line (FND_FILE.log, 'Entered run_data_scripts of Items Data Scripts Execution Concurrent Program ');

199: retcode OUT NOCOPY NUMBER)
200: IS
201:
202: BEGIN
203: FND_FILE.put_line (FND_FILE.log, 'Entered run_data_scripts of Items Data Scripts Execution Concurrent Program ');
204:
205: /* call procedure proc_io_shippable_flags to correct the IO,IOE,shippable flags */
206: proc_io_shippable_flags(errbuf,retcode);
207:

Line 213: FND_FILE.put_line (FND_FILE.log, 'End run_data_scripts of Items Data Scripts Execution Concurrent Program ');

209: /* call procedure proc_cat_datafix to correct Master-Child cases for categories */
210: proc_cat_datafix(errbuf,retcode);
211:
212:
213: FND_FILE.put_line (FND_FILE.log, 'End run_data_scripts of Items Data Scripts Execution Concurrent Program ');
214:
215: EXCEPTION
216: WHEN OTHERS THEN
217: FND_FILE.put_line (FND_FILE.log, 'Exception occured during Items Data Scripts Execution Concurrent Program ');

Line 217: FND_FILE.put_line (FND_FILE.log, 'Exception occured during Items Data Scripts Execution Concurrent Program ');

213: FND_FILE.put_line (FND_FILE.log, 'End run_data_scripts of Items Data Scripts Execution Concurrent Program ');
214:
215: EXCEPTION
216: WHEN OTHERS THEN
217: FND_FILE.put_line (FND_FILE.log, 'Exception occured during Items Data Scripts Execution Concurrent Program ');
218: FND_FILE.put_line (FND_FILE.log, SQLERRM);
219: errbuf := SQLERRM;
220: retcode := G_ERROR;
221: END run_data_scripts;

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

214:
215: EXCEPTION
216: WHEN OTHERS THEN
217: FND_FILE.put_line (FND_FILE.log, 'Exception occured during Items Data Scripts Execution Concurrent Program ');
218: FND_FILE.put_line (FND_FILE.log, SQLERRM);
219: errbuf := SQLERRM;
220: retcode := G_ERROR;
221: END run_data_scripts;
222: