DBA Data[Home] [Help]

APPS.OE_RETROBILL_PVT dependencies on FND_FILE

Line 3562: fnd_file.put_line(FND_FILE.OUTPUT,'Could not set org context');

3558: WHERE transaction_type_id = p_order_type_id;
3559: EXCEPTION
3560: WHEN NO_DATA_FOUND THEN
3561: l_return_status := FND_API.G_RET_STS_ERROR;
3562: fnd_file.put_line(FND_FILE.OUTPUT,'Could not set org context');
3563: retcode := -1;
3564: RETURN;
3565: END;
3566: IF l_org_id IS NOT NULL THEN

Line 3573: fnd_file.put_line(FND_FILE.OUTPUT,'Could not set org context');

3569: oe_debug_pub.add('Context is set for org_id : '|| mo_global.get_current_org_id);
3570: END IF;
3571: ELSE
3572: l_return_status := FND_API.G_RET_STS_ERROR;
3573: fnd_file.put_line(FND_FILE.OUTPUT,'Could not set org context');
3574: retcode := -1;
3575: RETURN;
3576: END IF;
3577: --rt moac end

Line 3600: fnd_file.put_line(FND_FILE.OUTPUT,'Sucessful completion');

3596:
3597: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3598: OE_MSG_PUB.save_messages (l_concurrent_request_id);
3599: commit;
3600: fnd_file.put_line(FND_FILE.OUTPUT,'Sucessful completion');
3601: errbuf := FND_MESSAGE.GET;
3602: retcode := 0;
3603: ELSE
3604: rollback;

Line 3607: fnd_file.put_line(FND_FILE.OUTPUT,'Failed');

3603: ELSE
3604: rollback;
3605: OE_MSG_PUB.save_messages (l_concurrent_request_id);
3606: commit;
3607: fnd_file.put_line(FND_FILE.OUTPUT,'Failed');
3608: errbuf := FND_MESSAGE.GET;
3609: retcode := -1;
3610: END IF;
3611: EXCEPTION

Line 4132: fnd_file.put_line(FND_FILE.OUTPUT,'Parameters :');

4128: l_execution_date_from := fnd_date.canonical_to_date(p_execution_date_from);
4129: l_execution_date_to := fnd_date.canonical_to_date(p_execution_date_to);
4130: l_message_text := '';
4131:
4132: fnd_file.put_line(FND_FILE.OUTPUT,'Parameters :');
4133: fnd_file.put_line(FND_FILE.OUTPUT,'Request id :'||p_retrobill_request_id);
4134: fnd_file.put_line(FND_FILE.OUTPUT,'Creation Date From:'||p_creation_date_from);
4135: fnd_file.put_line(FND_FILE.OUTPUT,'Creation Date To :'||p_creation_date_to);
4136: fnd_file.put_line(FND_FILE.OUTPUT,'Execution Date From:'||p_execution_date_from);

Line 4133: fnd_file.put_line(FND_FILE.OUTPUT,'Request id :'||p_retrobill_request_id);

4129: l_execution_date_to := fnd_date.canonical_to_date(p_execution_date_to);
4130: l_message_text := '';
4131:
4132: fnd_file.put_line(FND_FILE.OUTPUT,'Parameters :');
4133: fnd_file.put_line(FND_FILE.OUTPUT,'Request id :'||p_retrobill_request_id);
4134: fnd_file.put_line(FND_FILE.OUTPUT,'Creation Date From:'||p_creation_date_from);
4135: fnd_file.put_line(FND_FILE.OUTPUT,'Creation Date To :'||p_creation_date_to);
4136: fnd_file.put_line(FND_FILE.OUTPUT,'Execution Date From:'||p_execution_date_from);
4137: fnd_file.put_line(FND_FILE.OUTPUT,'Execution Date To :'||p_execution_date_to);

Line 4134: fnd_file.put_line(FND_FILE.OUTPUT,'Creation Date From:'||p_creation_date_from);

4130: l_message_text := '';
4131:
4132: fnd_file.put_line(FND_FILE.OUTPUT,'Parameters :');
4133: fnd_file.put_line(FND_FILE.OUTPUT,'Request id :'||p_retrobill_request_id);
4134: fnd_file.put_line(FND_FILE.OUTPUT,'Creation Date From:'||p_creation_date_from);
4135: fnd_file.put_line(FND_FILE.OUTPUT,'Creation Date To :'||p_creation_date_to);
4136: fnd_file.put_line(FND_FILE.OUTPUT,'Execution Date From:'||p_execution_date_from);
4137: fnd_file.put_line(FND_FILE.OUTPUT,'Execution Date To :'||p_execution_date_to);
4138: fnd_file.put_line(FND_FILE.OUTPUT,'Purge Preview Orders:'||p_purge_preview_orders);

Line 4135: fnd_file.put_line(FND_FILE.OUTPUT,'Creation Date To :'||p_creation_date_to);

4131:
4132: fnd_file.put_line(FND_FILE.OUTPUT,'Parameters :');
4133: fnd_file.put_line(FND_FILE.OUTPUT,'Request id :'||p_retrobill_request_id);
4134: fnd_file.put_line(FND_FILE.OUTPUT,'Creation Date From:'||p_creation_date_from);
4135: fnd_file.put_line(FND_FILE.OUTPUT,'Creation Date To :'||p_creation_date_to);
4136: fnd_file.put_line(FND_FILE.OUTPUT,'Execution Date From:'||p_execution_date_from);
4137: fnd_file.put_line(FND_FILE.OUTPUT,'Execution Date To :'||p_execution_date_to);
4138: fnd_file.put_line(FND_FILE.OUTPUT,'Purge Preview Orders:'||p_purge_preview_orders);
4139: fnd_file.put_line(FND_FILE.OUTPUT,'Operating Unit Id:'||p_org_id);

Line 4136: fnd_file.put_line(FND_FILE.OUTPUT,'Execution Date From:'||p_execution_date_from);

4132: fnd_file.put_line(FND_FILE.OUTPUT,'Parameters :');
4133: fnd_file.put_line(FND_FILE.OUTPUT,'Request id :'||p_retrobill_request_id);
4134: fnd_file.put_line(FND_FILE.OUTPUT,'Creation Date From:'||p_creation_date_from);
4135: fnd_file.put_line(FND_FILE.OUTPUT,'Creation Date To :'||p_creation_date_to);
4136: fnd_file.put_line(FND_FILE.OUTPUT,'Execution Date From:'||p_execution_date_from);
4137: fnd_file.put_line(FND_FILE.OUTPUT,'Execution Date To :'||p_execution_date_to);
4138: fnd_file.put_line(FND_FILE.OUTPUT,'Purge Preview Orders:'||p_purge_preview_orders);
4139: fnd_file.put_line(FND_FILE.OUTPUT,'Operating Unit Id:'||p_org_id);
4140: fnd_file.put_line(FND_FILE.OUTPUT,'');

Line 4137: fnd_file.put_line(FND_FILE.OUTPUT,'Execution Date To :'||p_execution_date_to);

4133: fnd_file.put_line(FND_FILE.OUTPUT,'Request id :'||p_retrobill_request_id);
4134: fnd_file.put_line(FND_FILE.OUTPUT,'Creation Date From:'||p_creation_date_from);
4135: fnd_file.put_line(FND_FILE.OUTPUT,'Creation Date To :'||p_creation_date_to);
4136: fnd_file.put_line(FND_FILE.OUTPUT,'Execution Date From:'||p_execution_date_from);
4137: fnd_file.put_line(FND_FILE.OUTPUT,'Execution Date To :'||p_execution_date_to);
4138: fnd_file.put_line(FND_FILE.OUTPUT,'Purge Preview Orders:'||p_purge_preview_orders);
4139: fnd_file.put_line(FND_FILE.OUTPUT,'Operating Unit Id:'||p_org_id);
4140: fnd_file.put_line(FND_FILE.OUTPUT,'');
4141:

Line 4138: fnd_file.put_line(FND_FILE.OUTPUT,'Purge Preview Orders:'||p_purge_preview_orders);

4134: fnd_file.put_line(FND_FILE.OUTPUT,'Creation Date From:'||p_creation_date_from);
4135: fnd_file.put_line(FND_FILE.OUTPUT,'Creation Date To :'||p_creation_date_to);
4136: fnd_file.put_line(FND_FILE.OUTPUT,'Execution Date From:'||p_execution_date_from);
4137: fnd_file.put_line(FND_FILE.OUTPUT,'Execution Date To :'||p_execution_date_to);
4138: fnd_file.put_line(FND_FILE.OUTPUT,'Purge Preview Orders:'||p_purge_preview_orders);
4139: fnd_file.put_line(FND_FILE.OUTPUT,'Operating Unit Id:'||p_org_id);
4140: fnd_file.put_line(FND_FILE.OUTPUT,'');
4141:
4142: FND_PROFILE.Get('CONC_REQUEST_ID', l_concurrent_id);

Line 4139: fnd_file.put_line(FND_FILE.OUTPUT,'Operating Unit Id:'||p_org_id);

4135: fnd_file.put_line(FND_FILE.OUTPUT,'Creation Date To :'||p_creation_date_to);
4136: fnd_file.put_line(FND_FILE.OUTPUT,'Execution Date From:'||p_execution_date_from);
4137: fnd_file.put_line(FND_FILE.OUTPUT,'Execution Date To :'||p_execution_date_to);
4138: fnd_file.put_line(FND_FILE.OUTPUT,'Purge Preview Orders:'||p_purge_preview_orders);
4139: fnd_file.put_line(FND_FILE.OUTPUT,'Operating Unit Id:'||p_org_id);
4140: fnd_file.put_line(FND_FILE.OUTPUT,'');
4141:
4142: FND_PROFILE.Get('CONC_REQUEST_ID', l_concurrent_id);
4143:

Line 4140: fnd_file.put_line(FND_FILE.OUTPUT,'');

4136: fnd_file.put_line(FND_FILE.OUTPUT,'Execution Date From:'||p_execution_date_from);
4137: fnd_file.put_line(FND_FILE.OUTPUT,'Execution Date To :'||p_execution_date_to);
4138: fnd_file.put_line(FND_FILE.OUTPUT,'Purge Preview Orders:'||p_purge_preview_orders);
4139: fnd_file.put_line(FND_FILE.OUTPUT,'Operating Unit Id:'||p_org_id);
4140: fnd_file.put_line(FND_FILE.OUTPUT,'');
4141:
4142: FND_PROFILE.Get('CONC_REQUEST_ID', l_concurrent_id);
4143:
4144: IF l_debug_level > 0 THEN

Line 4232: fnd_file.put_line(FND_FILE.OUTPUT,'Source/Order/Seq/Line Message');

4228: /* Save messages to Process Messages Table */
4229: OE_MSG_PUB.save_messages(l_concurrent_id);
4230:
4231: /*Displaying messages from Processing Message table*/
4232: fnd_file.put_line(FND_FILE.OUTPUT,'Source/Order/Seq/Line Message');
4233: OPEN l_msg_cursor;
4234: LOOP
4235: FETCH l_msg_cursor
4236: INTO l_order_source_id

Line 4243: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_order_source_id)

4239: , l_orig_sys_line_ref
4240: , l_message_text;
4241: EXIT WHEN l_msg_cursor%NOTFOUND;
4242:
4243: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_order_source_id)
4244: ||'/'||l_orig_sys_document_ref
4245: ||'/'||l_change_sequence
4246: ||'/'||l_orig_sys_line_ref
4247: ||' '||l_message_text);

Line 4248: fnd_file.put_line(FND_FILE.OUTPUT,'');

4244: ||'/'||l_orig_sys_document_ref
4245: ||'/'||l_change_sequence
4246: ||'/'||l_orig_sys_line_ref
4247: ||' '||l_message_text);
4248: fnd_file.put_line(FND_FILE.OUTPUT,'');
4249: END LOOP;
4250:
4251: IF l_debug_level > 0 THEN
4252: oe_debug_pub.add('Number of Requests Purged:' ||l_requests_processed);

Line 4256: fnd_file.put_line(FND_FILE.OUTPUT,'Number of Requests Purged:' ||l_requests_processed);

4252: oe_debug_pub.add('Number of Requests Purged:' ||l_requests_processed);
4253: oe_debug_pub.add('Number of Orders Purged:' ||l_headers_processed);
4254: END IF;
4255:
4256: fnd_file.put_line(FND_FILE.OUTPUT,'Number of Requests Purged:' ||l_requests_processed);
4257: fnd_file.put_line(FND_FILE.OUTPUT,'Number of Orders Purged:' ||l_headers_processed);
4258: oe_debug_pub.add('Exiting Oe_Retrobill_pvt.Oe_retrobill_Purge');
4259: commit;
4260:

Line 4257: fnd_file.put_line(FND_FILE.OUTPUT,'Number of Orders Purged:' ||l_headers_processed);

4253: oe_debug_pub.add('Number of Orders Purged:' ||l_headers_processed);
4254: END IF;
4255:
4256: fnd_file.put_line(FND_FILE.OUTPUT,'Number of Requests Purged:' ||l_requests_processed);
4257: fnd_file.put_line(FND_FILE.OUTPUT,'Number of Orders Purged:' ||l_headers_processed);
4258: oe_debug_pub.add('Exiting Oe_Retrobill_pvt.Oe_retrobill_Purge');
4259: commit;
4260:
4261: EXCEPTION