DBA Data[Home] [Help]

APPS.MTL_RELATED_ITEMS_PVT dependencies on FND_FILE

Line 12: FND_FILE.put_line(FND_FILE.LOG, p_msg);

8: l_err_msg VARCHAR2(240);
9: BEGIN
10: -- If Profile set to TRUE --
11: IF (G_DEBUG = 1) THEN
12: FND_FILE.put_line(FND_FILE.LOG, p_msg);
13: END IF;
14:
15: EXCEPTION
16: WHEN OTHERS THEN

Line 18: FND_FILE.put_line(FND_FILE.LOG, 'LOGGING SQL ERROR => '||l_err_msg);

14:
15: EXCEPTION
16: WHEN OTHERS THEN
17: l_err_msg := SUBSTRB(SQLERRM, 1,240);
18: FND_FILE.put_line(FND_FILE.LOG, 'LOGGING SQL ERROR => '||l_err_msg);
19: END Write_Debug;
20:
21: -- -----------------------------------------------------------------------------
22: -- Procedure Name: Process_Rel_Item

Line 2259: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering process Related Items Import.');

2255: AND a.PROCESS_FLAG = 1;
2256:
2257: BEGIN
2258:
2259: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering process Related Items Import.');
2260: FND_FILE.PUT_LINE( FND_FILE.LOG,'Set Process Id : '||To_Char(p_data_set_id));
2261:
2262: l_err_count := 0; -- start with no errors
2263: RETCODE := 0; -- assumes successful completion

Line 2260: FND_FILE.PUT_LINE( FND_FILE.LOG,'Set Process Id : '||To_Char(p_data_set_id));

2256:
2257: BEGIN
2258:
2259: FND_FILE.PUT_LINE( FND_FILE.LOG,'Entering process Related Items Import.');
2260: FND_FILE.PUT_LINE( FND_FILE.LOG,'Set Process Id : '||To_Char(p_data_set_id));
2261:
2262: l_err_count := 0; -- start with no errors
2263: RETCODE := 0; -- assumes successful completion
2264:

Line 2520: FND_FILE.PUT_LINE( FND_FILE.LOG,'Error Message for Transaction '||To_Char(l_mtl_Rel_Item_rec.Transaction_Id)|| ' : ' ||l_msg.message_text);

2516: -- looping to take out the messages
2517: IF l_msg_list.FIRST IS NOT NULL THEN
2518: FOR msg IN l_msg_list.FIRST..l_msg_list.LAST LOOP
2519: l_msg := l_msg_list(msg);
2520: FND_FILE.PUT_LINE( FND_FILE.LOG,'Error Message for Transaction '||To_Char(l_mtl_Rel_Item_rec.Transaction_Id)|| ' : ' ||l_msg.message_text);
2521:
2522: -- place into mtl_interface_error_table
2523: l_dummyInt := mtl_cross_references_pvt.LOG_ERROR --bug 12533707 -- invpuopi.mtl_log_interface_err
2524: (

Line 2566: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processed '||To_Char(l_proc_rec_count)|| ' records.');

2562: RETCODE := 0;
2563: END IF;
2564:
2565:
2566: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processed '||To_Char(l_proc_rec_count)|| ' records.');
2567: FND_FILE.PUT_LINE( FND_FILE.LOG,'Exiting Related Items Import.');
2568:
2569:
2570: END Process_Rel_Items_Rows;

Line 2567: FND_FILE.PUT_LINE( FND_FILE.LOG,'Exiting Related Items Import.');

2563: END IF;
2564:
2565:
2566: FND_FILE.PUT_LINE( FND_FILE.LOG,'Processed '||To_Char(l_proc_rec_count)|| ' records.');
2567: FND_FILE.PUT_LINE( FND_FILE.LOG,'Exiting Related Items Import.');
2568:
2569:
2570: END Process_Rel_Items_Rows;
2571: