DBA Data[Home] [Help]

APPS.AHL_OSP_PO_REQ_PVT dependencies on FND_FILE

Line 573: fnd_file.put_line(fnd_file.log, 'Starting Requisition Synch process...');

569: END IF;
570:
571: -- Start processing
572: IF (p_concurrent_flag = 'Y') THEN
573: fnd_file.put_line(fnd_file.log, 'Starting Requisition Synch process...');
574: END IF;
575:
576: -- First make all associations (PO Req Header Id, PO Req Line Id, Status updates)
577: Associate_All_New_Reqs(p_api_version => 1.0,

Line 583: fnd_file.put_line(fnd_file.log, 'Completed Associating OSPs with POs');

579: x_return_status => x_return_status,
580: x_msg_count => x_msg_count,
581: x_msg_data => x_msg_data);
582: IF (p_concurrent_flag = 'Y') THEN
583: fnd_file.put_line(fnd_file.log, 'Completed Associating OSPs with POs');
584: fnd_file.put_line(fnd_file.log, 'Return Status = ' || x_return_status);
585: END IF;
586: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
587: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Completed Associating OSPs with Requisitions, Return Status = ' || x_return_status);

Line 584: fnd_file.put_line(fnd_file.log, 'Return Status = ' || x_return_status);

580: x_msg_count => x_msg_count,
581: x_msg_data => x_msg_data);
582: IF (p_concurrent_flag = 'Y') THEN
583: fnd_file.put_line(fnd_file.log, 'Completed Associating OSPs with POs');
584: fnd_file.put_line(fnd_file.log, 'Return Status = ' || x_return_status);
585: END IF;
586: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
587: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Completed Associating OSPs with Requisitions, Return Status = ' || x_return_status);
588: END IF;

Line 593: fnd_file.put_line(fnd_file.log, 'Completed Handling Deleted PO Requisition Headers.');

589:
590: Handle_Deleted_Req_Headers(p_commit => p_commit, --Commit this independent of other operations
591: x_return_status => x_return_status);
592: IF (p_concurrent_flag = 'Y') THEN
593: fnd_file.put_line(fnd_file.log, 'Completed Handling Deleted PO Requisition Headers.');
594: fnd_file.put_line(fnd_file.log, 'Return Status = ' || x_return_status);
595: END IF;
596: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
597: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Completed Handling Deleted PO Requisition Headers, Return Status = ' || x_return_status);

Line 594: fnd_file.put_line(fnd_file.log, 'Return Status = ' || x_return_status);

590: Handle_Deleted_Req_Headers(p_commit => p_commit, --Commit this independent of other operations
591: x_return_status => x_return_status);
592: IF (p_concurrent_flag = 'Y') THEN
593: fnd_file.put_line(fnd_file.log, 'Completed Handling Deleted PO Requisition Headers.');
594: fnd_file.put_line(fnd_file.log, 'Return Status = ' || x_return_status);
595: END IF;
596: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
597: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Completed Handling Deleted PO Requisition Headers, Return Status = ' || x_return_status);
598: END IF;

Line 605: fnd_file.put_line(fnd_file.log, 'Completed Handling Cancelled PO Requisition Lines.');

601: -- Handle Canceled PO Requisitions
602: Handle_Cancelled_Req_Lines(p_commit => p_commit, --Commit this independent of other operations
603: x_return_status => x_return_status);
604: IF (p_concurrent_flag = 'Y') THEN
605: fnd_file.put_line(fnd_file.log, 'Completed Handling Cancelled PO Requisition Lines.');
606: fnd_file.put_line(fnd_file.log, 'Return Status = ' || x_return_status);
607: END IF;
608: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
609: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Completed Handling Cancelled PO Requisition Lines, Return Status = ' || x_return_status);

Line 606: fnd_file.put_line(fnd_file.log, 'Return Status = ' || x_return_status);

602: Handle_Cancelled_Req_Lines(p_commit => p_commit, --Commit this independent of other operations
603: x_return_status => x_return_status);
604: IF (p_concurrent_flag = 'Y') THEN
605: fnd_file.put_line(fnd_file.log, 'Completed Handling Cancelled PO Requisition Lines.');
606: fnd_file.put_line(fnd_file.log, 'Return Status = ' || x_return_status);
607: END IF;
608: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
609: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Completed Handling Cancelled PO Requisition Lines, Return Status = ' || x_return_status);
610: END IF;

Line 616: fnd_file.put_line(fnd_file.log, 'Completed Handling Deleted PO Requisition Lines.');

612: -- Handle Deleted PO Requisition Lines
613: Handle_Deleted_Req_Lines(p_commit => p_commit, --Commit this independent of other operations
614: x_return_status => x_return_status);
615: IF (p_concurrent_flag = 'Y') THEN
616: fnd_file.put_line(fnd_file.log, 'Completed Handling Deleted PO Requisition Lines.');
617: fnd_file.put_line(fnd_file.log, 'Return Status = ' || x_return_status);
618: END IF;
619: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
620: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Completed Handling Deleted PO Requisition Lines, Return Status = ' || x_return_status);

Line 617: fnd_file.put_line(fnd_file.log, 'Return Status = ' || x_return_status);

613: Handle_Deleted_Req_Lines(p_commit => p_commit, --Commit this independent of other operations
614: x_return_status => x_return_status);
615: IF (p_concurrent_flag = 'Y') THEN
616: fnd_file.put_line(fnd_file.log, 'Completed Handling Deleted PO Requisition Lines.');
617: fnd_file.put_line(fnd_file.log, 'Return Status = ' || x_return_status);
618: END IF;
619: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
620: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Completed Handling Deleted PO Requisition Lines, Return Status = ' || x_return_status);
621: END IF;

Line 628: fnd_file.put_line(fnd_file.log, 'Completed Requisition Synch Process. Checking for errors.');

624: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Completed Processing. Checking for errors.');
625: END IF;
626:
627: IF (p_concurrent_flag = 'Y') THEN
628: fnd_file.put_line(fnd_file.log, 'Completed Requisition Synch Process. Checking for errors.');
629: END IF;
630: -- Check Error Message stack.
631: x_msg_count := FND_MSG_PUB.count_msg;
632: IF x_msg_count > 0 THEN

Line 664: fnd_file.put_line(fnd_file.log, 'Caught Execution Exception: ' || x_msg_data);

660: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
661: p_data => x_msg_data,
662: p_encoded => fnd_api.g_false);
663: IF (p_concurrent_flag = 'Y') THEN
664: fnd_file.put_line(fnd_file.log, 'Caught Execution Exception: ' || x_msg_data);
665: END IF;
666: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
667: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Caught Execution Exception: ' || x_msg_data);
668: END IF;

Line 679: fnd_file.put_line(fnd_file.log, 'Caught Unexpected Exception: ' || x_msg_data);

675: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
676: p_data => x_msg_data,
677: p_encoded => fnd_api.g_false);
678: IF (p_concurrent_flag = 'Y') THEN
679: fnd_file.put_line(fnd_file.log, 'Caught Unexpected Exception: ' || x_msg_data);
680: END IF;
681: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
682: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Caught Unexpected Exception: ' || x_msg_data);
683: END IF;

Line 698: fnd_file.put_line(fnd_file.log, 'Caught Unknown Exception: ' || x_msg_data);

694: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
695: p_data => x_msg_data,
696: p_encoded => fnd_api.g_false);
697: IF (p_concurrent_flag = 'Y') THEN
698: fnd_file.put_line(fnd_file.log, 'Caught Unknown Exception: ' || x_msg_data);
699: END IF;
700: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
701: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, L_DEBUG_KEY, 'Caught Unknown Exception: ' || x_msg_data);
702: END IF;