DBA Data[Home] [Help]

APPS.CSI_GENERIC_GRP dependencies on FND_FILE

Line 755: fnd_file.put_line(fnd_file.log, 'Begining of Terminate Expired Instances.');

751: BEGIN
752:
753: SAVEPOINT terminate_instances;
754:
755: fnd_file.put_line(fnd_file.log, 'Begining of Terminate Expired Instances.');
756:
757: --l_expired_status_id := fnd_profile.value('CSI_INST_EXPIRED_STATUS');
758:
759: IF p_status_id is NOT NULL Then

Line 770: fnd_file.put_line(fnd_file.log,'Processing instance '||exp_inst_rec.instance_number); --to_char(exp_inst_rec.instance_id));

766:
767: FOR exp_inst_rec in exp_inst_cur(l_expired_status_id)
768: LOOP
769:
770: fnd_file.put_line(fnd_file.log,'Processing instance '||exp_inst_rec.instance_number); --to_char(exp_inst_rec.instance_id));
771:
772: BEGIN
773:
774: /* check if this instance is a child of some instance , if yes do not terminate it*/

Line 809: fnd_file.put_line(fnd_file.log,'Calling csi_item_instance_pub.expire item instance.');

805: l_exp_instance_rec.active_end_date := exp_inst_rec.active_end_date;
806: l_exp_instance_rec.object_version_number := exp_inst_rec.object_version_number;
807: l_exp_instance_rec.instance_status_id := l_expired_status_id;
808:
809: fnd_file.put_line(fnd_file.log,'Calling csi_item_instance_pub.expire item instance.');
810:
811: csi_item_instance_pub.expire_item_instance(
812: p_api_version => 1.0,
813: p_commit => fnd_api.g_false,

Line 830: fnd_file.put_line(fnd_file.log,'Processed successfully.');

826: l_error_message := csi_t_gen_utility_pvt.dump_error_stack;
827: raise fnd_api.g_exc_error;
828: END IF;
829:
830: fnd_file.put_line(fnd_file.log,'Processed successfully.');
831:
832: ELSE
833: fnd_file.put_line(fnd_file.log,'Parent found, so did not qualify.');
834: END IF;

Line 833: fnd_file.put_line(fnd_file.log,'Parent found, so did not qualify.');

829:
830: fnd_file.put_line(fnd_file.log,'Processed successfully.');
831:
832: ELSE
833: fnd_file.put_line(fnd_file.log,'Parent found, so did not qualify.');
834: END IF;
835:
836: EXCEPTION
837: WHEN fnd_api.g_exc_error THEN

Line 838: fnd_file.put_line(fnd_file.log, l_error_message);

834: END IF;
835:
836: EXCEPTION
837: WHEN fnd_api.g_exc_error THEN
838: fnd_file.put_line(fnd_file.log, l_error_message);
839: END;
840:
841: v_commit_counter := v_commit_counter + 1;
842: IF v_commit_counter = 100 THEN

Line 851: fnd_file.put_line(fnd_file.log,'Profile CSI_SYS_TERM_INST_STATUS_ID is not set.');

847: END LOOP;
848: commit;
849:
850: ELSE
851: fnd_file.put_line(fnd_file.log,'Profile CSI_SYS_TERM_INST_STATUS_ID is not set.');
852: l_error_flag := 'Y';
853: END IF;
854:
855: IF l_error_flag = 'Y' THEN

Line 862: fnd_file.put_line(fnd_file.log,'End of Terminate Expired Instances.');

858: retcode := 0;
859: errbuf := 'Instances Terminated Successfully.';
860: END IF;
861:
862: fnd_file.put_line(fnd_file.log,'End of Terminate Expired Instances.');
863:
864: EXCEPTION
865: WHEN fnd_api.g_exc_error THEN
866: ROLLBACK TO terminate_instances;